<?php
$dbuser = "root";
$dbpass = "root";
$dbhost = "127.0.0.1";
$dbname = "aion_gs";

$msconn = mysql_connect($dbhost, $dbuser, $dbpass); 
$db = mysql_select_db($dbname, $msconn);
mysql_query("set names 'UTF8'");

    $q = mysql_query("SELECT name, race, ap, all_kill, rank FROM abyss_rank LEFT JOIN players ON player_id = id WHERE ap>1 ORDER BY ap DESC LIMIT 100");
    echo "<table width='99%' border='0' cellpadding='0' cellspacing='0' bordercolor='#6b6b6b'>"; 
    echo "<tr align='center'>"; 
    echo "<td><font size='2'><b>Name</b></font></td> 
    <td><font size='2'><b>Race</b></font></td>
    <td><font size='2'><b>AP</b></font></td>
    <td><font size='2'><b>Kills</b></font></td>
    <td><font size='2'><b>Rank</b></font></td>"; 
    echo "</tr>"; 
    while($row = mysql_fetch_array($q)) 
    { 

if ($row["rank"] == '1') {$rank = "Soldier, Rank 9";} 
elseif ($row["rank"] == '2') {$rank = "Soldier, Rank 8";} 
elseif ($row["rank"] == '3') {$rank = "Soldier, Rank 7";} 
elseif ($row["rank"] == '4') {$rank = "Soldier, Rank 6";} 
elseif ($row["rank"] == '5') {$rank = "Soldier, Rank 5";} 
elseif ($row["rank"] == '6') {$rank = "Soldier, Rank 4";} 
elseif ($row["rank"] == '7') {$rank = "Soldier, Rank 3";} 
elseif ($row["rank"] == '8') {$rank = "Soldier, Rank 2";} 
elseif ($row["rank"] == '9') {$rank = "Soldier, Rank 1";} 
elseif ($row["rank"] == '10') {$rank = "1-Star Officer";} 
elseif ($row["rank"] == '11') {$rank = "2-Star Officer";} 
elseif ($row["rank"] == '12') {$rank = "3-Star Officer";} 
elseif ($row["rank"] == '13') {$rank = "4-Star Officer";} 
elseif ($row["rank"] == '14') {$rank = "5-Star Officer";} 
elseif ($row["rank"] == '15') {$rank = "Army General";} 
elseif ($row["rank"] == '16') {$rank = "Army Great General";} 
elseif ($row["rank"] == '17') {$rank = "Army Commander";} 
elseif ($row["rank"] == '18') {$rank = "Army Governor";} 

if ($row["race"] == 'ELYOS') {$race = "Elyos";} 
elseif ($row["race"] == 'ASMODIANS') {$race = "Asmodian";} 

        echo "<tr align='center'>"; 
        echo "<td><font size='2'>".$row["name"]."</font></td>";
        echo "<td><font size='2'>".$race."</font></td>";  
        echo "<td><font size='2'>".$row["ap"]."</font></td>"; 
        echo "<td><font size='2'>".$row["all_kill"]."</font></td>"; 
        echo "<td><font size='2'>".$rank."</font></td>"; 
        echo "</tr>"; 
    } 
    echo "</table><br />"; 
?>