@bump
Check if ctlcode in module is = 8 or 32
hi sk1zzo,
still dont work
<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='8' or ctlcode='8' or ctlcode='32'";
$sql_admin_check=mssql_query($admin);
echo'
';
i use ariethmu module.
HELP!
Add SQL Connection=Yes in "Edit Pages"<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"
Code:<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> "; } ?>