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"] = "" . $arr["username"] . "";
if ($CURUSER)
$activeusers .= "" . $arr["username"] . "";
else
$activeusers .= "$arr[username]";
$activeusers .= " ".get_user_icons($arr);
}
if (!$activeusers)
$activeusers = "Keine aktiven Mitglieder in den letzten 15 Minuten.";