[REQUEST] top10 exp on index.php

[vDk]

Hi.
I want to show serwer top10 exp players on my all pages in my acc (gesior accmaker)



How i can make that?;

 

[Norix]

Put this somehwere in your layout.php file:

<center><table width="225"><tr><td width="1"></td><td width="85"></td><td width="65"></font></td><td width="18"></td></tr>
 <?PHP
$order = 0;
$skills = $SQL->query('SELECT name,online,level,experience,vocation,promotion FROM players WHERE players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 10;');
foreach($skills as $skill) {
  $order++;
$players_skill .= '<tr><td align="center">'.$order.'.</td><td align="left"><B><a href="?subtopic=characters&name='.urlencode($skill['name']).'">'.($skill['online']>0 ? "<font color=\"green\">".$skill['name']."</font>" : "".$skill['name']."</font>").'</a></td> <td align="center"><font color="#7073FC">(<em>Level '.$skill['level'].'</em>)</font></td> <td align="center"><font color="#FE2E2E">'.$vocation_name[$skill['promotion']][$skill['vocation']].'</font><br></td>';
}
echo "$players_skill";
?>
</td></tr></TABLE>

 

[vDk]

Woah!
Thanks rep++
but how i can add "$bgcolor" like highscores?

Royal Paladin (white background)
Elite Knight (black background)
Elder druid (white background)
Master sorcerer (black background)

@down
THANKS!! =]

 

[Norix]

Try this:

<center><table width="225"><tr><td width="1"></td><td width="85"></td><td width="65"></font></td><td width="18"></td></tr>
 <?PHP
$order = 0;
$number_of_people = 0;
$skills = $SQL->query('SELECT name,online,level,experience,vocation,promotion FROM players WHERE players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 10;');
foreach($skills as $skill) {
  $order++;
if(is_int($number_of_people / 2))
$bgcolor = $config['site']['darkborder'];
else
$bgcolor = $config['site']['lightborder'];
$number_of_people++;
$players_skill .= '<tr BGCOLOR="'.$bgcolor.'"><td align="center">'.$order.'.</td><td align="left"><B><a href="?subtopic=characters&name='.urlencode($skill['name']).'">'.($skill['online']>0 ? "<font color=\"green\">".$skill['name']."</font>" : "".$skill['name']."</font>").'</a></td> <td align="center"><font color="#7073FC">(<em>Level '.$skill['level'].'</em>)</font></td> <td align="center"><font color="#FE2E2E">'.$vocation_name[$skill['promotion']][$skill['vocation']].'</font><br></td>';
}
echo "$players_skill";
?>
</td></tr></TABLE>

 

[Zerak]

not works ;O

 

[hodleo]

it works
-.- but what If I want it in a individual page? it looks messy just above all the aac web