openside("TOP pakvietę narių");
$result = dbquery("SELECT * FROM `".DB_PREFIX."invites` GROUP by `invite_user_id` ORDER by COUNT(*) DESC LIMIT 10");
echo "
";
while ($data = dbarray($result)) {
$time = dbrows(dbquery("SELECT * FROM `".DB_PREFIX."invites` WHERE `invite_user_id`='".$data['invite_user_id']."'"));
$data2 = dbarray(dbquery("SELECT * FROM `".DB_PREFIX."users` WHERE `user_id`='".$data['invite_user_id']."'"));
echo "
".$data2['user_name']." |
$time |
";
}
echo "
";
closeside();