No meu servidor uso isso:
Código PHP:
<?php
$gmsq = mssql_query("SELECT dbo.Memb_stat.Connectstat, dbo.AccountCharacter.GameIDC, dbo.Character.Name, dbo.Character.staff, dbo.memb_stat.ServerName
FROM Memb_stat JOIN dbo.AccountCharacter ON dbo.Memb_stat.memb___id = dbo.AccountCharacter.ID COLLATE database_default
JOIN dbo.Character ON dbo.Memb_stat.memb___id = dbo.Character.AccountID COLLATE database_default WHERE dbo.Character.CtlCode >= 8
ORDER BY dbo.Character.Name ASC");
if(mssql_num_rows($gmsq) == 0)
{
echo"<td> Nenhum membro cadastrado.</td>";
}
for($i=0;$i<mssql_num_rows($gmsq);$i++)
{
$gm = mssql_fetch_row($gmsq);
if($gm[0] >= 1 and $gm[1] == $gm[2])
{
$status = "<span style=\"color: green;\">Online ($gm[4])</span>";
}
else
{
$status = "<span style=\"color: red;\">Offline</span>";
}
echo"<tr>
<td style=\"width: 120px;\">$gm[2]</td>
<td >$status</td>
</tr>";
}
?>