Hi all.
I have seen alot looking for this script. So now i will release it.
IT IS NOT MY OWN CREATION!
Unfortunately, i cant remember where i got it from, so i cant add credits.
Though alot webs got it already.
But here it is.
If you want to add another table with the Invisible gm's, insert came code but change:
WITH:
If you got questions or need help to get it into your site, PM me.
I have seen alot looking for this script. So now i will release it.
IT IS NOT MY OWN CREATION!
Unfortunately, i cant remember where i got it from, so i cant add credits.
Though alot webs got it already.
But here it is.
PHP:
<?
include("config.php");
$query=mssql_query("SELECT * FROM Character WHERE CtlCode=32");
while($gm=mssql_fetch_array($query)){
$stat="";
$gmname=$gm['Name'];
$gmacc=$gm['AccountID'];
$query2=mssql_query("SELECT ConnectStat FROM MEMB_STAT WHERE memb___id='$gmacc'");
$query3=mssql_query("SELECT GameIDC FROM AccountCharacter WHERE Id='$gmacc'");
$query3=mssql_result($query3, 0, 0);
$rquery2=mssql_num_rows($query2);
if($rquery2<1) { $query2 = '0'; }
else{ $query2=mssql_result($query2, 0, 0); }
if($query2=='1'){
if($query3==$gmname){
$stat = '<font color=green><strong>[ON]</strong></font>';
}
}
if($query2=='0'){
$stat = '<font color=red><strong>[OFF]</strong></font>';
}
if($query2=='1' AND $query3 <> $gmname){
$stat = '<font color=red><strong>[OFF]</strong></font>';
}
echo "$gmname $stat";
echo "<br>";
}
?>
If you want to add another table with the Invisible gm's, insert came code but change:
PHP:
$query=mssql_query("SELECT * FROM Character WHERE CtlCode=32");
WITH:
PHP:
$query=mssql_query("SELECT * FROM Character WHERE CtlCode=8");
If you got questions or need help to get it into your site, PM me.