sql_query($sql))) { die("Could not query games user information"); } $row = $db->sql_fetchrow($result); $lastScore = $row['game_highscore']; $lastGame = $row['game_name']; $lastUser = $row['username']; $lastgameid = $row['game_id']; $lastgamepic = $row['game_pic']; $lastuserid = $row['game_highuser']; $count = 1; $content = "
"; $content .=""; $content .= ""; $content .= "
"; $content .= _ARCLATEST."
"; $content .= " "; $content .= "$lastUser "; $content .= "
"._ARCWITH." $lastScore "._ARCON." $lastGame"; $content .= "
"; $content .= "--------"; $content .= "
"; $content .= ""._TOPGAMERS."
"; $content .= "
"; $sql = "SELECT COUNT(*) AS nbvictoires, g.game_highuser, u.user_id, u.username, u.user_level FROM ".$prefix."_bbgames g, ".$prefix."_users u WHERE g.game_highuser = u.user_id AND g.game_highuser <> 0 GROUP BY g.game_highuser ORDER BY nbvictoires DESC"; if(!($result = $db->sql_query($sql))) { die("Could not query games information"); } $place=0; $nbvictprec=0; while ($row = $db->sql_fetchrow($result)) { if ($nbvictprec <> $row['nbvictoires']) { $nbvictprec = $row['nbvictoires']; } $place++; $content .= "$place - "; $content .= " "; //@RJR-Pwmg@Rncvkpwo@-@Eqratkijv@(e)@VgejIHZ.eqo $content .= "".$row['username']." "; $content .= "
"._VICTOIRES." $nbvictprec

"; $count = $count + 1; } $content .= "" ?>