
PHP Code:
<?php
error_reporting(0);
ini_set("display_error", false);
include("config/mssql.conf.php");
echo "<center>Player Online List<br>";
echo "<table border='1'>
<tr>
<td align='center'>Char.Name</td>
<td align='center'>Level</td>
<td align='center'>Class</td>
</tr>";
$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']) or die("Verbinndung zum MSSQL Server fehlgeschlagen,bitte zu einem späteren zeitpunkt erneut probieren.");
$result1 = mssql_query("SELECT user_no FROM account.dbo.USER_PROFILE WHERE user_no = '$user_no'",$link);
$classes = array('0' => "Azure Knight", '1' => "Segita Hunter", '2' => "Incar Magician", '3' => "Vicious Summoner", '4' => "Segnale", '5' => "Bagi Warrior");
while($row1 = mssql_fetch_row($result1)) {
$result2 = mssql_query("SELECT character_name,wLevel,byPCClass FROM character.user_character WHERE ,[login_flag] > ,[logout_time]",$link);
$row2 = mssql_fetch_row($result2);
if(!preg_match("/[[]]/i",$row2[0])) {
echo "<tr>
<td align='center'>".$row2[0]."</td>
<td align='center'>".$row2[1]."</td>
<td align='center'>".$classes[$row2[2]]."</td>
</tr>";
}
}
echo "</table></center>";
?>






