In terms of level, frag, or what?
Just 1. Name
2. Name
3. Name
4. Name
5. Name
It will be showing on main page at right, I just need the script..
<h1>Top 5<small> Players</small></h1>
<ul>
<?php
$limitt = 5;
$zap = $SQL->query('SELECT `name`, `level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;');
$number_of_rows = 0;
foreach($zap as $wynik)
{
$number_of_rows++;
echo '<li class="light">'.$number_of_rows.'. <a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" >'.$wynik['name'].'</a> <br> Level: <b>('.$wynik['levell'].')</b></li>';
}
?>
</ul>
<h1>Top 5<small> Players</small></h1>
<ul>
<?php
$limitt = 5;
$zap = $SQL->query('SELECT `name`, `level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;');
$number_of_rows = 0;
foreach($zap as $wynik)
{
$number_of_rows++;
echo '<li class="light">'.$number_of_rows.'. <a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" >'.$wynik['name'].'</a> <br> Level: <b>('.$wynik['level'].')</b></li>';
}
?>
</ul>
lil typo:
PHP:<h1>Top 5<small> Players</small></h1> <ul> <?php $limitt = 5; $zap = $SQL->query('SELECT `name`, `level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;'); $number_of_rows = 0; foreach($zap as $wynik) { $number_of_rows++; echo '<li class="light">'.$number_of_rows.'. <a rel="nofollow" href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" >'.($wynik['online']>0 ? "<font color=\"green\">".$wynik['name']."</font>" : "<font color=\"red\">".$wynik['name']."</font>").'</a> <br> Level: <b>('.$wynik['level'].')</b></li>'; } ?> </ul>