[HELP] Dekaron php configuration

05/26/2013 04:07 slaaash#1

I need to make this code show if a specific gm is online.
Example: this code need to show if only [GM]TEST is online.
I can't figure it out because i don't know php programing.

Spoiler

05/29/2013 09:10 janvier123#2

here you go

PHP Code:


			
$busca_equipe = mssql_query("select p.user_id as uid, c.character_name as cnm FROM character.dbo.user_character c join account.dbo.user_profile p ON c.user_no = p.user_no WHERE c.login_time IN (SELECT max(login_time) FROM character.dbo.user_character GROUP BY user_no) AND p.login_flag = '1100' and c.login_time is not null AND c.character_name = '[GM]TEST'");  

if(mssql_num_rows($busca_equipe) == '1')
{
    echo '<font color="green"><strong>Online</strong></font>';
}
else
{
    echo '<font color="red"><strong>Offline</strong></font>';
}