& Matías Parodi # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU Affero General Public License as # published by the Free Software Foundation, either version 3 of the # License, or (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU Affero General Public License for more details. # # You should have received a copy of the GNU Affero General Public License # along with this program. If not, see . # ## if (!defined("SECURITY")) { exit; } $sql = " SELECT `users`.`username`, `users`.`avatar`, `users`.`karma` FROM `users` ORDER BY `users`.`karma` DESC LIMIT 0, 5;"; $result = mysql_query($sql); echo 'Top karma
'; if (mysql_affected_rows() != 0) { while ($row = mysql_fetch_assoc($result)) { $avatar = 'images/avatar/' . $row['username'] . '/thumb_top.' . $row['avatar']; $avatar = (file_exists($avatar) === true) ? $avatar : 'images/avatar/default_top.png'; echo '' . $row['username'] . ' ' . $row['username'] . ' - ' . $row['karma'] . ' karma
'; } mysql_free_result($result); } ?>