|
|
|
|
All
Blogs
include("mysqlcon.php");
$query = "SELECT bhost_users.u_id,bhost_users.title,bhost_users.description,bhost_users.username,bhost_users.country,bhost_users.last_login,bhost_users.signup_date FROM
bhost_users ORDER BY bhost_users.title";
$result = mysql_query($query);
echo mysql_error();
while (list($u_id,$title,$description,$username,$country,$last_login,$signup_date) = mysql_fetch_array($result))
{
$lastlogindate = date("m.d.Y", $last_login);
$signupdate = date("m.d.Y", $signup_date);
if($signup_date == 0) { $signupdate = "Never"; }
$latest_entry = mysql_fetch_assoc(mysql_query("SELECT e_id, title FROM bhost_entries WHERE u_id='$u_id' ORDER BY e_id DESC LIMIT 1"));
if($latest_entry[title] == "") { $latest_entry_title = "Untitled"; } else { $latest_entry_title = $latest_entry[title]; }
echo "Blog Name: $title ";
echo "Description: $description ";
echo "Author: $username ";
echo "Location: $country ";
echo "Last Login: $lastlogindate ";
echo " ";
}
?>
|
Most
Active Users
include "mysqlcon.php";
$users = mysql_query("SELECT u_id, COUNT(e_id) AS mode FROM bhost_entries GROUP BY u_id ORDER BY mode DESC LIMIT 10");
$count = 0;
while($thisuser = mysql_fetch_assoc($users)) {
$count++;
$thisuser_info = mysql_fetch_assoc(mysql_query("SELECT u_id, username FROM bhost_users WHERE u_id='$thisuser[u_id]'"));
echo "
$thisuser_info[username] - $thisuser[mode] entries
";
}
?>
|
|
Last
Posts
include("mysqlcon.php");
$query = "SELECT bhost_users.u_id,bhost_users.title,bhost_users.description,bhost_users.username,bhost_users.country,bhost_users.last_login,bhost_users.signup_date FROM
bhost_users ORDER BY bhost_users.title";
$result = mysql_query($query);
echo mysql_error();
while (list($u_id,$title,$description,$username,$country,$last_login,$signup_date) = mysql_fetch_array($result))
{
$lastlogindate = date("m.d.Y", $last_login);
$signupdate = date("m.d.Y", $signup_date);
if($signup_date == 0) { $signupdate = "Never"; }
$latest_entry = mysql_fetch_assoc(mysql_query("SELECT e_id, title FROM bhost_entries WHERE u_id='$u_id' ORDER BY e_id DESC LIMIT 1"));
if($latest_entry[title] == "") { $latest_entry_title = "Untitled"; } else { $latest_entry_title = $latest_entry[title]; }
echo "$title ";
}
?>
|
|
|
|