Top Online Player

[TheKamikaze]

Hi guys,

i decided to make this small script, that show how many hours the player have spend on your server. It work with ODBC/Mssql, then no problem with your integration (MuWeb Module). This script show 25 player.



Thnx to Grissha for the screen

<div align="center">
  <div align="center">
    <table width="50%" border="0" cellspacing="1" cellpadding="1">
      <tr>
        <td class="normal_text_white">Players</td>
        <td class="normal_text_white">Online Time</td>
        <td class="normal_text_white">Status</td>
      </tr>
  <?php

/**
 * @DjSoulz
 * @copyright 2008
 */
 
if( !isset($_GET['op']))
{
    require('../includes/denied.php');
    denied('Time');
}
require('config.php');

//We get the user
$online = $db->Execute('SELECT DISTINCT 
TOP 25
AccountCharacter.ID, 
AccountCharacter.GameIDC, 
MEMB_STAT.ServerName, 
MEMB_STAT.IP, 
MEMB_STAT.ConnectTM, 
MEMB_STAT.DisConnectTM,
MEMB_STAT.OnlineHours
from 
MEMB_STAT 
join 
AccountCharacter 
on 
Memb_stat.memb___id = AccountCharacter.ID
ORDER BY 
MEMB_STAT.OnlineHours DESC');
while($online_time = $online->fetchrow())
{
//Maybe the statut too
$statut = $db->Execute("Select ConnectStat FROM MEMB_STAT WHERE memb___id='".$online_time[0]."'");
$statut_ok = $statut->fetchrow();
if($statut_ok[0] == 1){$online_stat = '<span style="color:green"><b>Online</b></span>';}
elseif($statut_ok[0] == 0){$online_stat = '<span style="color:red"><b>Offline</b></span>';}
?>
      <tr>
        <td class="normal_text_white"><a href="index.php?op=character&character=<?=$online_time[1];?>"><?=$online_time[1];?></a></td>
        <td class="normal_text_white"><?=$online_time[6];?></td>
        <td class="normal_text_white"><?=$online_stat?></td>
      </tr>
  <?
}
?>
      </table>
</div>

You must put it in Modules/Most Online.php

Credit : Me (TheKamikaze/DjSoulz)

[MentaL]

[Faronnia]

Great work,I am impressed.I guess I will use this.
PS : I suck at PHP :(
But I am working on it :winky:

[darknightt]

Thank's Gob Jog

plx screen!

[TheKamikaze]

click on Demo link lol

[darknightt]

ok thank's sorry i am noob^^^^

[RisingKing2010]

1) not bad... rather simple tho ;)
2) Remove demo link against the rules :P

[TheKamikaze]

ok i'll put a screen

[Saint]

That' s a great Release dude.

How to write "hours" after the number of hours?

Sorry, dont know anything about PHP.

[tunerband]

cool :)

[Ooo Yee]

madness, kamikaze u rule :) 10/10

great scipt, just show that some players on my server is ~ 800 hours online :rofl:

[TheKamikaze]

find <?=$online_time[6];?> and change it for :

<?=$online_time[6];?> Hours

[JleXa]

nice 10/10

[Derek23]

good thx^^

[alin2008]

u can use this and for event :D exemple wtho player is number one to play this server at the 1.1.2009 won a gm or items :P

[serrinha]

thx...
this is go to my server page..^^

[TheKamikaze]

If someone have an idea for a script, just say it :)

[=Ady=]

can you release webpage too?
thx for the script, very usefull

[TheKamikaze]

webpage ??

[=Ady=]

yes, the muweb with this new template

[serrinha]

Thank's Gob Jog

plx screen!

God job???

i dont now...
God play MuOnline???
:sleepy:

[Maxim.T]

That'z nice

[[hidden]]

^^ nice one.

[Saint]

You should contact Master, he will definately input in into muweb 0.9 i guess.

This line ISNT in the Most Online.php > <?=$online_time[6];?>

[vaiben]

just looking for it THX!

[GRECO]

This webpage template is released?