Alguém sabe o código de bota na equipe no status online? No lugar de online, aparece o servidor exemplo Online Sala Trade+Baú , alguém sabe?
Versão Imprimível
Alguém sabe o código de bota na equipe no status online? No lugar de online, aparece o servidor exemplo Online Sala Trade+Baú , alguém sabe?
qual website que se ta usando?
EffectCitação:
Postado originalmente por hadeslan [Only registered and activated users can see links. Click Here To Register...]
alguém ????????????? 20pussy
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>";
}
?>
eu uso essa aqui, oq eu tenho que mudar?
<?php
$ADMIN = mssql_query ( "SELECT NAME,CTLCODE,ACCOUNTID FROM muonline.dbo.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 muonline.dbo.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;
}
?>
Código PHP:
<?php
$ADMIN = mssql_query ( "SELECT NAME,CTLCODE,ACCOUNTID FROM muonline.dbo.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 muonline.dbo.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] {$STATUS[1]}</font>";
break;
}
?>