Statystyki na forum

print("</table>\n");

print("<p align=center><a href=?action=search><b>Search</b></a> | <a href=?action=viewunread><b>View unread</b></a> | <a href=?catchup><b>Catch up</b></a></p>");

print("<tr><td class=colhead>Statystki forum</td></tr>\n");

$registered = number_format(get_row_count("users", "WHERE enabled = 'yes'"));

$a = @mysql_fetch_assoc(@mysql_query("SELECT id,username FROM users WHERE status='confirmed' ORDER BY id DESC LIMIT 1")) or die(mysql_error());

if ($CURUSER)

$latestuser = "<a href=userdetails.php?id=" . $a["id"] . ">" . $a["username"] . "</a>";

else

$latestuser = $a['username'];

$totalonline = number_format(get_row_count("users", "WHERE UNIX_TIMESTAMP(" . get_dt_num() . ") - UNIX_TIMESTAMP(last_access) < 1200"));

$topiccount = mysql_query("select sum(topiccount) as topiccount from forums");

$row1 = mysql_fetch_array($topiccount);

$topiccount = $row1[topiccount];

$postcount = mysql_query("select sum(postcount) as postcount from forums");

$row2 = mysql_fetch_array($postcount);

$postcount = $row2[postcount];

print("<tr><td>

&raquo;&nbsp;Nasi użytkownicy napisali " . $postcount . " postów w " . $topiccount . " tematach,<BR>

&raquo;&nbsp;Mamy" . $registered . " zarejestrowanych użytkowników,<BR>

&raquo;&nbsp;Naszym ostatnim zarejestrowanym użytkownikiem jest " . $latestuser . ", <BR>

&raquo;&nbsp;" . $totalonline . " -Tylu użytkowników jest online.</td></tr>\n");

print("</table>");