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.";