Mine

begin_block("Stats");//main stats here$a = @mysql_fetch_assoc(@mysql_query("SELECT id,username FROM users WHERE status='confirmed' ORDER BY id DESC LIMIT 1"));if ($CURUSER)  $latestuser = "<a href=account-details.php?id=" . $a["id"] . ">" . $a["username"] . "</a>";else  $latestuser = "<b>$a[username]</b>";$registered = number_format(get_row_count("users"));$torrents = number_format(get_row_count("torrents"));$result = mysql_query("SELECT SUM(downloaded) AS totaldl FROM users") or sqlerr(__FILE__, __LINE__);while ($row = mysql_fetch_array ($result)){$totaldownloaded      = $row["totaldl"];}$result = mysql_query("SELECT SUM(uploaded) AS totalul FROM users") or sqlerr(__FILE__, __LINE__);while ($row = mysql_fetch_array ($result)){$totaluploaded      = $row["totalul"];}$seeders = get_row_count("peers", "WHERE seeder='yes'");$leechers = get_row_count("peers", "WHERE seeder='no'");$usersactive = 0;if ($leechers == 0)  $ratio = "100";else  $ratio = round($seeders / $leechers * 100);if ($ratio < 20)    $ratio = "<font class=red>" . $ratio . "%</font>";else    $ratio .= "%";$peers = number_format($seeders + $leechers);$seeders = number_format($seeders);$leechers = number_format($leechers);//start count visited today$res = mysql_query("SELECT COUNT(*) FROM users WHERE UNIX_TIMESTAMP(" . get_dt_num() . ") - UNIX_TIMESTAMP(last_access) < 86400");$arr3 = mysql_fetch_row($res);$totaltoday = $arr3[0];// start count registered today$res = mysql_query("SELECT COUNT(*) FROM users WHERE UNIX_TIMESTAMP(" . get_dt_num() . ") - UNIX_TIMESTAMP(added) < 86400");$arr44 = mysql_fetch_row($res);$regtoday = $arr44[0];//start count online now$res = mysql_query("SELECT COUNT(*) FROM users WHERE UNIX_TIMESTAMP(" . get_dt_num() . ") - UNIX_TIMESTAMP(last_access) < 900");$arr4 = mysql_fetch_row($res);$totalnow = $arr4[0];if ($CURUSER)    guestadd();if (!$activepeople)  $activepeople = "" . NO_USERS . "";  if (!$todayactive)  $todayactive = "" . NO_USERS . "";$guests = getguests();if (!$guests)    $guests = "0";$time_start = getmicrotime();//end here  stdhead();  begin_frame("" . STATS . "", center);echo "<div align=left><font class=stats>" . WELCOME_NEW . ": " . $latestuser . "</font><br>";if (!$activepeople)    echo "<br><font class=stats>" . ONLINE_USERS . ": (" . $totalnow . ")<b>0 Members</b></font>";else    echo "<br><font class=stats>" . ONLINE_USERS . ": (" . $totalnow . ")</font>";$totalusers = $totalnow + $guests;echo "<br><font class=stats>" . GUESTS_ONLINE . ": (" . $guests . ")</font>";echo "<br><font class=stats>" . TOTAL_ONLINE . ": (" . $totalusers . ")</font>";if (!$todayactive)    echo "<br><font class=stats>" . VISITORS_TODAY . ": (<!--<a href='visitorstoday.php'>-->" . $totaltoday . "<!--</a>-->)<br>0 Members</font>";else    echo "<br><font class=stats>" . VISITORS_TODAY . ": (<!--<a href='visitorstoday.php'>-->" . $totaltoday . "<!--</a>-->)<!--<br>" . $todayactive . "--></font>";echo "<br><font class=stats>" . TOTAL_USERS . ": " . $registered . "</font>";echo "<br><font class=stats>" . NEWUSERS_TODAY . ": " . $regtoday . "</font>";echo "<br><font class=stats>" . ACTIVE_TRANSFERS . ": " . $peers . "</font>";ECHO "<br><font class=stats>" . DOWNLOADED . ": " . mksize($totaldownloaded) . "</FONT>";ECHO "<br><font class=stats>" . UPLOADED . ": " . mksize($totaluploaded) . "</FONT>";echo "<br><font class=stats>" . TRACKING . " " . $torrents . " Torrents</font>";echo "<br><font class=stats>" . SEEDS . ": " . $seeders . "</font>";echo "<br><font class=stats>" . LEECH . ": " . $leechers . "</font>";echo "<br><font class=stats>" . SEED_RATIO . ": " . $ratio . "</font>";echo "<br><br></div>";end_frame();end_block();