<?
$hs="127.0.0.1";
$us="sa";
$pass="password"; // SQL PASSWORD
$conn=mssql_connect($hs,$us,$pass);
$db=mssql_select_db($db,$conn);
$proverka="select top 99999 Name,AccountID,CtlCode From Character where Ctlcode='8' or Ctlcode='32' order by strength desc";
$proverka2=mssql_query($proverka);
echo'<table align=center width=320 border=0 cellpadding=4 cellspacing=2>
<tr><td>#</td>
<td>Name:</td>
<td>Status:</td>
</tr>';
for($i=0;$i < mssql_num_rows($proverka2);++$i)
{
$nomer=$i+1;
$row=mssql_fetch_row($proverka2);
$status="select ConnectStat from MEMB_STAT where memb___id='$row[1]'";
$status2=mssql_query($status);
$row1=mssql_fetch_row($status2);
if($row1[0] == 0){ $row1[0] ='<font color=red><b>Offline;';
}
if($row1[0] == 1){ $row1[0] ='<font color=green><b>Online';
}
echo"<tr><td>$nomer</td>
<td>$row[0]</td>
<td>$row1[0]</td>
</tr>"; }
?>
</table>
