<?php




$ulname = $_SESSION['Username'];

$sql1  = "SELECT UID FROM Login WHERE ID = '".$ulname."'";



$dbhost = 'WIN-T8TI9CQBSHN\SQLEXPRESS';
$dbuser = 'website';
$dbpass = 'Zen&ErikRape';

$conn = mssql_connect($dbhost, $dbuser, $dbpass) or die("MSSSQL Error");

//change to kal_db
mssql_select_db('kal_db', $conn);
$query = mssql_query("SELECT * FROM Player WHERE UID = '".$sql1."'");
while($r = mssql_fetch_array($query)){



if ($r['Class'] == 0){ $class = "Knight"; } else if ($r['Class'] == 1){ $class = "Mage"; } else if ($r['Class'] == 2){ $class = "Archer"; }
if ($class == "Knight" && $r['Specialty'] == 1){
$specialty = "Wondering Knight";
} else if ($class == "Knight" && $r['Specialty'] == 3){
$specialty = "Apprentice Knight";
} else if ($class == "Knight" && $r['Specialty'] == 7){
$specialty = "Vagabond Swordman";
} else if ($class == "Knight" && $r['Specialty'] == 8){
$specialty = "Commander";
} else if ($class == "Mage" && $r['Specialty'] == 1){
$specialty = "Scholar";
} else if ($class == "Mage" && $r['Specialty'] == 3){
$specialty = "Literary Man";
} else if ($class == "Mage" && $r['Specialty'] == 7){
$specialty = "Hermit";
} else if ($class == "Mage" && $r['Specialty'] == 8){
$specialty = "Chairperson of Joong-Bang(CJB)";
} else if ($class == "Archer" && $r['Specialty'] == 1){
$specialty = "Wondering Archer";
} else if ($class == "Archer" && $r['Specialty'] == 3){
$specialty = "Apprentice Archer";
} else if ($class == "Archer" && $r['Specialty'] == 7){
$specialty = "Expert Archer";
} else if ($class == "Archer" && $r['Specialty'] == 8){
$specialty = "Imperial Commander";
} else if ($r['Specialty'] == 15){
$specialty = "All Jobs";
}
if ($r['Admin'] == 0){
$rank = "Normal";
} else if ($r['Admin'] == 8){
$rank = "Game Master";
} else if ($r['Admin'] == 11){
$rank = "Administrator";
}


echo '
<table align="center" width="250">
<tr><td width="125" >Character Name:</td><td>'.$r['Name'].'</td></tr>
<tr><td width="125" >Level</td><td>'.$r['Level'].'</td></tr>
<tr><td width="125" >Class:</td><td>'.$class.'</td></tr>
<tr><td width="125" >Specialty:</td><td>'.$specialty.'</td></tr>
<tr><td width="125" >Contribute Points:</td><td>'.$r['Contribute'].'</td></tr>
<tr><td width="125" >Rank:</td><td>'.$rank.'</td></tr>
</table>';

?>