<?php

$dbuser = "root";
$dbpass = "";
$dbhost = "localhost";
$dbname = "lcep2";


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

    $q = mysql_query("SELECT a_level, a_class, a_charname, a_job FROM t_characters WHERE a_level>31 ORDER BY a_level DESC");
    echo "<table width='400' border='0' cellpadding='2' cellspacing='2' bordercolor='#6b6b6b'>";
    echo "<tr align='left'>";
    echo "
    <td align='center' bgcolor='#999999' width='20%'><font size='4'><b>Level</b></font></td>
    <td align='left' bgcolor='#999999' width='50%'><font size='4'><b>Name</b></font></td>
    <td align='center' bgcolor='#999999' width='30%'><font size='4'><b>Klasse</b></font></td>



"
 ;

    echo "</tr>";
    while($row = mysql_fetch_array($q))
    {

    //Titan
    if ($row["a_class"] == '0' && $row["a_job"] == '1' ) {$class = "<font color=red>Highlander</font>";}
    elseif ($row["a_class"] == '0' && $row["a_job"] == '2' ) {$class = "<font color=red>Kriegsmeister</font>";}

    //Ritter
    elseif ($row["a_class"] == '1' && $row["a_job"] == '1' ) {$class = "<font color=blue>Königsritter</font>";}
    elseif ($row["a_class"] == '1' && $row["a_job"] == '2' ) {$class = "<font color=blue>Tempelritter</font>";}

    //Heiler
    elseif ($row["a_class"] == '2' && $row["a_job"] == '1' ) {$class = "<font color=green>Walsläuferin</font>";}
    elseif ($row["a_class"] == '2' && $row["a_job"] == '2' ) {$class = "<font color=green>Klerikerin</font>";}

    //Magierin
    elseif ($row["a_class"] == '3' && $row["a_job"] == '1' ) {$class = "<font color=purple>Zauberer</font>";}
    elseif ($row["a_class"] == '3' && $row["a_job"] == '2' ) {$class = "<font color=purple>Hexe</font>";}

    //Schurkin
    elseif ($row["a_class"] == '4' && $row["a_job"] == '1' ) {$class = "<font color=orange>Assassine</font>";}
    elseif ($row["a_class"] == '4' && $row["a_job"] == '2' ) {$class = "<font color=orange>Schwarfschütze</font>";}

    //Beschwörer
    elseif ($row["a_class"] == '5' && $row["a_job"] == '1' ) {$class = "<font color=#9B30FF>Elementarist</font>";}
    elseif ($row["a_class"] == '5' && $row["a_job"] == '2' ) {$class = "<font color=#9B30FF>Spezialist</font>";}

    //Dummy
    elseif ($row["a_class"] == '0' && $row["a_job"] == '0' ) {$class = "<font color=#9B30FF>Kein Job gewählt</font>";}
    elseif ($row["a_class"] == '1' && $row["a_job"] == '0' ) {$class = "<font color=#9B30FF>Kein Job gewählt</font>";}
    elseif ($row["a_class"] == '2' && $row["a_job"] == '0' ) {$class = "<font color=#9B30FF>Kein Job gewählt</font>";}
    elseif ($row["a_class"] == '3' && $row["a_job"] == '0' ) {$class = "<font color=#9B30FF>Kein Job gewählt</font>";}
    elseif ($row["a_class"] == '4' && $row["a_job"] == '0' ) {$class = "<font color=#9B30FF>Kein Job gewählt</font>";}
    elseif ($row["a_class"] == '5' && $row["a_job"] == '0' ) {$class = "<font color=#9B30FF>Kein Job gewählt</font>";}

    //Schattenpriester
    elseif ($row["a_class"] == '6' && $row["a_job"] == '0' ) {$class = "Schattenpriester";}




        echo "<tr align='left'>";
        echo "<td align='center' bgcolor='#CCCCCC' width='20%'><font size='3'>".$row["a_level"]."</font></td>";
        echo "<td align='left' bgcolor='#CCCCCC' width='50%'><font size='3'>".$row["a_charname"]."</font></td>";
        echo "<td align='center' bgcolor='#CCCCCC' width='30%'><font size='3'>".$class."</font></td>";
    }
    echo "</table><br />";
?>