Quote:
<div align="center">
<img src="template/<?=$core['config']['template'] ?>/images/gamemasters.png">
<br><br><br>
<table class="themain" align="center" cellpadding="2" cellspacing="0" width="50%"><tbody><tr><td>
<table border="0" cellpadding="3" cellspacing="1" width="100%">
<tbody><tr>
<td class="topp1" align="center" width="60%">GM Name</td>
<td class="topp3" align="center" width="20%">Status</td>
<?
$admin="select TOP 50 Name,AccountID From Character where ctlcode='24' or ctlcode='8' or ctlcode='32'";
$sql_admin_check=mssql_query($admin);
echo'
';
for($i=0;$i < mssql_num_rows($sql_admin_check);++$i)
{
$nr=$i+1;
$row=mssql_fetch_row($sql_admin_check);
$status="select ConnectStat from MEMB_STAT where memb___id='$row[1]'";
$sql_status_check=mssql_query($status);
$row1=mssql_fetch_row($sql_status_check);
if($row1[0] == 0){ $row1[0] ='<td style="background: none repeat scroll 0% 0% rgb(255, 230, 230);" align="center"><span style="color: red;"><b>Offline</b></span></td>';
}
if($row1[0] == 1){ $row1[0] ='<td style="background: none repeat scroll 0% 0% rgb(223, 255, 218);" align="center"><span style="color: green;"><b>Online</b></span></td>';
}
echo"
</tr>
<tr>
<td class='trhover' align='center'><span style='color: rgb(255, 132, 0); font-size: 12pt;'> <b>$row[0]</b> </span></td>
$row1[0]
</tr>
"; }
?>
Add SQL Connection=Yes in "Edit Pages"