Player Hall of Fame count added

Added by raz0rsedge over 1 year ago

The playerstats.php was edited in order to properly display the player ranks column in the Top 100 table and to reset the division precision.

$sql_table_var = "SET div_precision_increment = 1";
    $sql_player_table = "SELECT @rownum:=@rownum+1 Rank, t.* FROM (SELECT @rownum:=0) r, (SELECT name, customScore AS score, killsSoft AS soft, killsArmor AS armor, killsAir AS air, killsPlayers AS human, killsTotal AS kills, killed AS deaths, (killsTotal/killed) AS 'K/D Ratio' FROM `Players` ORDER BY customScore DESC LIMIT 100)t";
       $result = mysql_query($sql_table_var) or die(mysql_error());
    $result_player_table = mysql_query($sql_player_table);
    if(!$result_player_table){
    print mysql_error();
    print "<br>\n";
    }


Comments