/**
* Shows the top online players.
*/

$limit=50;

echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";

$sql="SELECT PLAYER.USERNAME,PLAYER.LEVEL,PLAYER.SCHOOL,LOCATIONS.NAME
FROM PLAYER LEFT JOIN ISLAND_STATUS ON (ISLAND_STATUS.USERID=PLAYER.ID AND ISLAND_STATUS.STATUS='C')
LEFT JOIN LOCATIONS ON (ISLAND_STATUS.LOCATION=LOCATIONS.ID)
WHERE UNIX_TIMESTAMP(LASTACTION) > UNIX_TIMESTAMP(CURRENT_TIMESTAMP)-15*60
AND PLAYER.AUTHORIZED = 'Y' ORDER BY EXPERIENCE DESC";

$class=array("F"=>"Fire Mage","I"=>"Ice Mage","E"=>"Earth Mage","A"=>"Air Mage","V"=>"Vampire Mage","B"=>"Vandale Warrior","C"=>"Cavaliar Warrior","M"=>"Marauder Warrior","R"=>"Rogue Warrior",""=>"Adventurer");

$r=$db->Execute($sql);
$l=1;
while(!$r->EOF)
{
if(($l%2) == 0)
echo "\n";
else
echo "";
echo "";
echo "\n";
echo "\n";
echo "\n";
$r->MoveNext();
$l++;
}
$r->Close();

echo "

Top Online Players
Name	Level	Class	Island Owned
".$r->fields[0]."	".number_format($r->fields[1]+0, 0, ".", "'")."	".$class[$r->fields[2]]."	".remove_tags($r->fields[3])."

\n";
?>