$wynik = dbquery("SELECT user_id, user_name, (user_posts +
(SELECT COUNT(comment_id) FROM ".DB_COMMENTS." WHERE comment_name=user_id) +
(SELECT COUNT(shout_id) FROM ".DB_SHOUTBOX." WHERE shout_name=user_id)) AS razem FROM ".DB_USERS."
ORDER BY razem DESC LIMIT 5");
if(dbrows($wynik) > 0) {
echo "";
while($r = dbarray($wynik))
{
echo "| ".THEME_BULLET." ".$r['user_name']." | ".number_format($r['razem'])." |
";
}
echo "
";
} else {
echo "Brak danych do wyswietlenia.
\n";
}