[Help] How can I add one panel that shows the current GM online in my server?

[rocerao]

Hi all, how can I add one panel in my mu web 0.8 that shows the current online GMs ?
thanks for the atention

[MentaL]

[djspankman]

First you need to create tables and things like that and a query would be nice...
something like this
$query = "SELECT GM Name from Character Where CtlCode=32 WHERE connectstat=1 order by Name desc";
$result = mssql_query($query);

or something similar....that above will probably not work but yeah. It's a good start I guess :P

[stivnnik]

Hi all, how can I add one panel in my mu web 0.8 that shows the current online GMs ?
thanks for the atention

Just you have to be good at PHP & Mssql

[rocerao]

But can anyone help me with this code ?
I'll be very happy if anyone can help me with this ^^

[Jahte]

Learn MSSQL language.

[kopinits]

put this code where you want to show who is online.

<?
$sql = "SELECT C.Name from Character C inner join memb_stat m on c.accountid = m.memb___id inner join accountcharacter ac on c.accountid = ac.id
Where c.CtlCode=32 and ac.gameidc = c.name and m.connectstat=1 order by C.Name desc";
$row = mssql_query($sql);
while ($sql = my=ssql_fetch_array($row)){
echo $sql["Name"]."<br>";
}
?>

[rocerao]

Thanks a lot man, but can you create one simple designed table of showing this for I put in my web, like one aditional page, that the users enter in http:// mysiteadress/onlinegms section?

[rocerao]

In my site my mu web 0.8 don't have the section who is online, can anyone that have this script and page can post it for me ? for I add this feature in my mu web 0.8 ?
And where can I put this code that you have pass to me kopoints ?
thanks for the atention