PHP [Konkurs] Ranking taskow!

[Placek]

Powiazany temat: http://tibia.net.pl/threads/554387-Konkurs-Task-system-przez-komendy!?p=1538462#post1538462

Jest to skrypt ktory wyswietli najlepszych graczy na serwerze ktorzy wykonuja taski.

 <?php
    $result = $SQL->query("SELECT `players`.`name`, `player_storage`.`value` FROM `players` JOIN `player_storage` ON `players`.`id` = `player_storage`.`player_id` WHERE `player_storage`.`key` = 32151 ORDER BY CAST(`player_storage`.`value` AS UNSIGNED) DESC LIMIT 30 ;");
        $main_content .= '<div style="text-align: center; font-weight: bold;"><h2>Top of Task Makers on ' . $config['server']['serverName'] . '</h2></div> 
<center><table border="0" cellspacing="1" cellpadding="4" width="100%"> 
    <tr bgcolor="'.$config['site']['vdarkborder'].'"> 
        <td width="10%"><b><font color=white><center>Pos</font></center></b></td> 
        <td width="60%"><b><font color=white><center>Player Name</center></b></font></td> 
        <td width="30%"><b><font color=white><center>Task Points</center></b></font></td>  
    </tr>'; 
    $i = 0; 
    foreach ($result as $entry)
    { 
    $i++; 
    $main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']). '"> ';
    $main_content .= '
    <td><center>'.$i.' </center></td>
    <td><b><center><a href="?subtopic=characters&name='.$entry['name'].'">'.$entry['name'].'</a></center></b></td>
    <td><center>'. $entry["value"] .'</center></td>';

    $main_content .= "</td></tr>";
    } 
    $main_content .= '</table><br />'; 
?>

Zabraniam kopiowania zawarto?ci na inne fora/serwisy.

Notka moderatorska:

+10pkt do konkursu!