Miscellany

else
    $latestuser = $a['username'];

$registered = number_format(get_row_count("users"));
$unverified = number_format(get_row_count("users", "WHERE status='pending'"));
$inactive = number_format(get_row_count("users", "WHERE enabled='no'"));
$torrents = get_row_count("torrents");
$dead = get_row_count("torrents", "WHERE visible='no'");

$r = mysql_query("SELECT value_u FROM avps WHERE arg='seeders'") or sqlerr(__FILE__, __LINE__);
$a = mysql_fetch_row($r);
$seeders = 0 + $a[0];
$r = mysql_query("SELECT value_u FROM avps WHERE arg='leechers'") or sqlerr(__FILE__, __LINE__);
$a = mysql_fetch_row($r);
$leechers = 0 + $a[0];
$r = mysql_query("SELECT SUM(downloaded) FROM users WHERE enabled='yes'") or sqlerr(__FILE__, __LINE__);
$a = mysql_fetch_row($r);
$totaldown = mksize(0 + $a[0]);
$r = mysql_query("SELECT SUM(uploaded) FROM users WHERE enabled='yes'") or sqlerr(__FILE__, __LINE__);
$a = mysql_fetch_row($r);
$totalup = mksize(0 + $a[0]);

if ($leechers == 0)
    $ratio = 0;
else
    $ratio = round($seeders / $leechers * 100);
    
$peers = number_format(get_row_count("peers"));
$seeder = number_format(get_row_count("peers", "WHERE seeder='yes'"));
$leecher = number_format(get_row_count("peers", "WHERE seeder='no'"));
$pratio = ($seeder / $leecher) * 100;

$dt = time() - 200;
$dt = sqlesc(get_date_time($dt));
$maxdt = get_date_time(time() - 21600*28);
$res = mysql_query("SELECT id, username, class, donor, warned, added, enabled FROM users WHERE last_access >= $dt AND last_access <= NOW() ORDER BY class DESC,username") or print(mysql_error());
$activeusers_no = mysql_num_rows($res);

while ($arr = mysql_fetch_assoc($res))
{
    if ($activeusers) $activeusers .= ",\n";
    $arr["username"] = "<font class=".get_class_color($arr["class"]).">" . $arr["username"] . "</font>";
    if ($CURUSER)
        $activeusers .= "<a href=userdetails.php?id=" . $arr["id"] . "><b>" . $arr["username"] . "</b></a>";
    else
        $activeusers .= "<b>$arr[username]</b>";
    
    $activeusers .= "&nbsp;".get_user_icons($arr);
}

if (!$activeusers)
    $activeusers = "Keine aktiven Mitglieder in den letzten 15 Minuten.";