<?php
$dbuser = "";
$dbpass = "";
$dbhost = "";
$dbname = "aion";

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

    $q = mysql_query("SELECT legions.name, legions.level, players.race FROM legions LEFT JOIN legion_members ON legions.id = legion_members.legion_id LEFT JOIN players ON legion_members.player_id = players.id WHERE rank='BRIGADE_GENERAL' ORDER BY name ASC");
    if($q == FALSE){ echo "Error"; End_page(); }
    $count_online = mysql_num_rows($q);
    echo "<table width='99%' border='0' cellpadding='0' cellspacing='0' bordercolor='#6b6b6b'>";
    echo "<tr align='center'>";
    echo "<td><font size='2'><b>Legion</b></font></td>
    <td><font size='2'><b>Level</b></font></td>
    <td><font size='2'><b>Race</b></font></td>";
    echo "</tr>";
    while($row = mysql_fetch_array($q))
    {

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'>".$row["level"]."</font></td>";
        echo "<td><font size='2'>".$race."</font></td>";
        echo "</tr>";
    }
    echo "</table><br />";
    echo "<b>Total</b>: $count_online";
?>