fewdox
New Member
I Have This Script .. Why Show Only Players Of Top
How i can make to show 5 of ranking top ?
5 of rank rep
5 of rank level
5 of rank xp
5 of rank frags
5 of rank rep negative ?
PLEASE HELP ME WITH THAT .. THIS IS LAST PHP OF MY SITE TO FINISH ME OT AND SEND TO HOST :wub:
How i can make to show 5 of ranking top ?
5 of rank rep
5 of rank level
5 of rank xp
5 of rank frags
5 of rank rep negative ?
PHP:
//Queryes ..
$query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`rep`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC LIMIT 10;')->fetch();
$query3 = $SQL->query('SELECT `players`.`experience`, `players`.`name` FROM `players` WHERE experience > 0;')->fetch();
$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 10;')->fetch();
$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
$banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();
$reputation = $SQL->query('SELECT `rep`, `name` FROM `players` WHERE `rep` > 0;')->fetch();
$reputation2 = $SQL->query('SELECT `rep`, `name` FROM `players` WHERE `rep` < 0;')->fetch();
//End Of Queries
$main_content .='
<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=2 cellspacing=2 width=0%><tr bgcolor='. $config['site']['vdarkborder'] .'>
<tr>
<td bgcolor='. $config['site']['vdarkborder'] .' align="center" class="white" colspan="" width="10%"><b>Top Experience</b></td>
<td bgcolor='. $config['site']['vdarkborder'] .' align="center" class="white" colspan="" width="10%"><b>Top Reputation</b></td>
<td bgcolor='. $config['site']['vdarkborder'] .' align="center" class="white" colspan="" width="10%"><b>Top Reputation Negative</b></td>
<td bgcolor='. $config['site']['vdarkborder'] .' align="center" class="white" colspan="" width="10%"><b>Top Frags</b></td>
<td bgcolor='. $config['site']['vdarkborder'] .' align="center" class="white" colspan="" width="10%"><b>Top Level</b></td>
</tr>
<tr>
<td align="top"><b>'.$query['name'].'</b> ('.urlencode($query['experience']).')</td>
<td align="top"><b><font size="1">'.$reputation['name'].'</font> <font color="red" font size="1">('.$reputation['rep'].')</font></td>
<td align="top"><b><font size="1">'.$reputation2['name'].'</font> <font color="red" font size="1">('.$reputation2['rep'].')</font></TD>
<td align="top"></TD>
<td align="top"><b>'.$query['name'].'</b> ('.urlencode($query['level']).')</td>
</tr>
<tr>
<td align="top"><b>'.$query3['name'].'</b>('.urlencode($query['experience']).')</td>
<td align="top"></td>
<td align="top"></td>
<td align="top"></td>
<td align="top"></td>
</tr>
<tr>
<td align="top"></td>
<td align="top"></td>
<td align="top"></td>
<td align="top"></td>
<td align="top"></td>
</tr>
<tr>
<td align="top"><b>'.$query['name'].'</b> ('.urlencode($query['experience']).')</td>
<td align="top"></td>
<td align="top"></td>
<td align="top"></td>
<td align="top"></td>
</tr>
</table>';
// END END END END END END ENDPLEASE HELP ME WITH THAT .. THIS IS LAST PHP OF MY SITE TO FINISH ME OT AND SEND TO HOST :wub:
