Postado originalmente por
GuilhermeSouza
Eu uso faço por CtlCode. Se quiser, tá aí.
#CtlCodes:
24 = ADM
216 = SUB
8 = GM
120 = MD/MM
Código:
<table width="300" border="1" cellpadding="0" cellspacing="0" class="table">
<h2><font color=green><b><u>Lista de Membros da Equipe</b></u></h2></font>
<?php
$ADMIN = mssql_query ( "SELECT NAME,CTLCODE,ACCOUNTID FROM CHARACTER WHERE CTLCODE = 24" );
for ( $i = 0 ; $i < mssql_num_rows ( $ADMIN ) ; $i ++ )
{
$SHOWADMIN = mssql_fetch_row ( $ADMIN );
switch ( $SHOWADMIN[1] )
{
case 24 : $getCargo = "<font color=\"black\">".$SHOWADMIN[0]."</font>";
break;
}
$STATUS = mssql_fetch_row ( mssql_query ( "SELECT CONNECTSTAT,SERVERNAME FROM MEMB_STAT WHERE MEMB___ID='".$SHOWADMIN[2]."'" ) );
switch ( $STATUS[0] )
{
case 0 : $getStatus = "<font color=red>[Offline]</font>";
break;
case 1 : $getStatus = "<font color=green>[Online]</font>";
break;
}
?>
<div align="center"><b><font color=gray><b>Lista de Administrador</b></font></b></div>
<tr>
<td width="10%"><div align="center"><img ="imagem" src="templates/MuEclipse/imagens/adm.png" width="13" height="15" border="0" /></td></div>
<td width="60%"><div align="center"><?php echo $getCargo; ?></td></div>
<td width="30%" align="center"><div align="center"><?php echo $getStatus; ?></td></div>
</tr>
<?php } ?>
</table>
<table width="300" border="1" cellpadding="0" cellspacing="0" class="table">
<br>
<div align="center"><b><font color=gray><b>Lista de Sub-Administrador</b></font></b></div>
<?php
$ADMIN = mssql_query ( "SELECT NAME,CTLCODE,ACCOUNTID FROM CHARACTER WHERE CTLCODE = 216" );
for ( $i = 0 ; $i < mssql_num_rows ( $ADMIN ) ; $i ++ )
{
$SHOWADMIN = mssql_fetch_row ( $ADMIN );
switch ( $SHOWADMIN[1] )
{
case 216 : $getCargo = "<font color=\"black\">".$SHOWADMIN[0]."</font>";
break;
}
$STATUS = mssql_fetch_row ( mssql_query ( "SELECT CONNECTSTAT,SERVERNAME FROM MEMB_STAT WHERE MEMB___ID='".$SHOWADMIN[2]."'" ) );
switch ( $STATUS[0] )
{
case 0 : $getStatus = "<font color=red>[Offline]</font>";
break;
case 1 : $getStatus = "<font color=green>[Online]</font>";
break;
}
?>
<tr>
<td width="10%"><div align="center"><img ="imagem" src="templates/MuEclipse/imagens/sub.png" width="13" height="15" border="0" /></td></div>
<td width="60%"><div align="center"><?php echo $getCargo; ?></td></div>
<td width="30%" align="center"><div align="center"><?php echo $getStatus; ?></td></div>
</tr>
<?php } ?>
</table>
<table width="300" border="1" cellpadding="0" cellspacing="0" class="table">
<br>
<div align="center"><b><font color=gray><b>Lista de GameMaster</b></font></b></div>
<?php
$GM = mssql_query ( "SELECT NAME,CTLCODE,ACCOUNTID FROM CHARACTER WHERE CTLCODE = 8" );
for ( $i = 0 ; $i < mssql_num_rows ( $GM ) ; $i ++ )
{
$SHOWGM = mssql_fetch_row ( $GM );
switch ( $SHOWGM[1] )
{
case 8 : $getCargo = "<font color=\"black\">".$SHOWGM[0]."</font>";
break;
}
$STATUSS = mssql_fetch_row ( mssql_query ( "SELECT CONNECTSTAT,SERVERNAME FROM MEMB_STAT WHERE MEMB___ID='".$SHOWGM[2]."'" ) );
switch ( $STATUSS[0] )
{
case 0 : $getStatus = "<font color=red>[Offline]</font>";
break;
case 1 : $getStatus = "<font color=green>[Online]</font>";
break;
}
?>
<tr>
<td width="10%"><div align="center"><img ="imagem" src="templates/MuEclipse/imagens/gm.png" width="13" height="15" border="0" /></td></div>
<td width="60%"><div align="center"><?php echo $getCargo; ?></td></div>
<td width="30%" align="center"><div align="center"><?php echo $getStatus; ?></td></div>
</tr>
<?php } ?>
</table>
<table width="300" border="1" cellpadding="0" cellspacing="0" class="table">
<br>
<div align="center"><b><font color=gray><b>Lista de Moderador</b></font></b></div>
<?php
$GM = mssql_query ( "SELECT NAME,CTLCODE,ACCOUNTID FROM CHARACTER WHERE CTLCODE = 120" );
for ( $i = 0 ; $i < mssql_num_rows ( $GM ) ; $i ++ )
{
$SHOWGM = mssql_fetch_row ( $GM );
switch ( $SHOWGM[1] )
{
case 120 : $getCargo = "<font color=\"black\">".$SHOWGM[0]."</font>";
break;
}
$STATUSS = mssql_fetch_row ( mssql_query ( "SELECT CONNECTSTAT,SERVERNAME FROM MEMB_STAT WHERE MEMB___ID='".$SHOWGM[2]."'" ) );
switch ( $STATUSS[0] )
{
case 0 : $getStatus = "<font color=red>[Offline]</font>";
break;
case 1 : $getStatus = "<font color=green>[Online]</font>";
break;
}
?>
<tr>
<td width="10%"><div align="center"><img ="imagem" src="templates/MuEclipse/imagens/md.png" width="13" height="15" border="0" /></td></div>
<td width="60%"><div align="center"><?php echo $getCargo; ?></td></div>
<td width="30%" align="center"><div align="center"><?php echo $getStatus; ?></td></div>
</tr>
<?php } ?>
</table>