".
" Personal lists for $user[username]$donor$warned$country |
\n");
print("");
print("
");
print("\n");
print("");
$i = 0;
$res = do_mysql_query("SELECT f.friendid as id, u.username AS name, u.class, u.avatar, u.title, u.donor, u.warned, u.enabled, u.last_access, UNIX_TIMESTAMP(u.last_access) as utadded FROM friends AS f LEFT JOIN users as u ON f.friendid = u.id WHERE userid=$userid ORDER BY name") or sqlerr(__FILE__, __LINE__);
if(mysql_num_rows($res) == 0)
$friends = "Your friends list is empty.";
else
while ($friend = mysql_fetch_assoc($res))
{
$title = $friend["title"];
if (!$title)
$title = get_user_class_name($friend["class"]);
$body1 = "" . $friend['name'] . "" .
get_user_icons($friend) . " ($title)
last seen on " . $friend['last_access'] .
"
(" . get_elapsed_time(($friend['utadded'])) . " ago)";
$body2 = "
Remove" .
"
Send PM";
$avatar = ($CURUSER["avatars"] == "yes" ? htmlspecialchars($friend["avatar"]) : "");
if (!$avatar)
$avatar = $GLOBALS['pic_base_url']."/default_avatar.gif";
if ($i % 2 == 0)
print("| ");
else
print(" | ");
print("");
print("| " .
($avatar ? "" : ""). " | \n");
print("");
print("| $body1 | \n");
print("$body2 | \n");
print(" ");
print(" | ");
print(" \n");
if ($i % 2 == 1)
print(" |
\n");
else
print(" | \n");
$i++;
}
if ($i % 2 == 1)
print(" |
\n");
print($friends);
print(" |
\n");
/* Added you to friends list */
$i = 0;
$res = do_mysql_query("SELECT
f.userid as id,
u.username AS name,
u.class,
u.avatar,
u.title,
u.donor,
u.warned,
u.enabled,
u.last_access,
UNIX_TIMESTAMP(u.last_access) as utadded
FROM friends AS f
LEFT JOIN users as u
ON f.userid = u.id
WHERE f.friendid=$userid ORDER BY username") or sqlerr(__FILE__, __LINE__);
print("| ");
print(" |
");
print("| ");
print("$blocks\n");
print(" |
\n");
print("\n");
print("