Top Online Player

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.

http://img505.imageshack.us/img505/9366/onlineuo8.jpg

Thnx to Grissha for the screen

PHP Code:

---

<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)

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

Thank's Gob Jog

plx screen!

click on Demo link lol

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

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

ok i'll put a screen

That' s a great Release dude.

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

Sorry, dont know anything about PHP.

cool :)

madness, kamikaze u rule :) 10/10

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

http://img228.imageshack.us/img228/1599/20648394za7.jpg

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

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

nice 10/10

good thx^^

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

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

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

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

webpage ??

yes, the muweb with this new template

Quote:

---

Originally Posted by darknightt

Thank's Gob Jog

plx screen!

---

God job???

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

That'z nice

^^ nice one.

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];?>

just looking for it THX!

This webpage template is released?

Nice, very usefull

Quote:

---

Originally Posted by grishaaa

madness, kamikaze u rule :) 10/10

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

http://img505.imageshack.us/img505/9366/onlineuo8.jpg

---

Plis Bro Up Your Web site Template.
Pliss.
Send-me this PM.^^

It' s a little bit like FrienzMu template.

Thanks for release,

Quote:

---

Originally Posted by GRECO

This webpage template is released?

---

I hope so =P

Great! Thanks for the script!

Cool share :P

I post this template for muweb 8 but erased the post ...

Great work man.

Nice script, with few editing should be just fine for me.

Quote:

---

Originally Posted by Derek23

I post this template for muweb 8 but erased the post ...

---

Could you share it [again?]

Quote:

---

Originally Posted by RayOfLight

Nice script, with few editing should be just fine for me.

---

what don't work with you ?

Why dont u share the template again...:(

As I said earlier I shared but not erased ^ ^

But since I have a good Update 2
- New logo
- New Downloads module
- add Top Online Player by TheKamikaze/DjSoulz
- add FAQ

Images
http://img403.imageshack.us/img403/7679/41604877yn4.png

http://img247.imageshack.us/img247/461/32158028oa0.png

http://img216.imageshack.us/img216/7258/69489223dv3.png

http://img161.imageshack.us/img161/1326/41084074mo5.png

so you will release it?

great 10/10

how's web is that?? please post the web!

nice!

Please stop spamming the topic

i can't see any link to download this script, i don't know to get the script into the module
Plz post your link
srr 4 my bad english

Good work! nice

Quote:

---

Originally Posted by TheKamikaze

what don't work with you ?

---

It works but I'm not happy with the way it is :P I'll add the word Hours and use images instead of On/off text. :P

The 5 char are on an account? 5/10 !

Nice release! I Like!

nice dude

Quote:

---

Originally Posted by TheKamikaze

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

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

---

I got a question how do we reset everyone online time so everyone has a fresh start?

lol .. ~800 hours .. Aren't they crazy or smthin' .. I never play more than 2-3 hours a day ^^
Nice work any way :} 10/10

Can anyone tell me how i would set MEMB_STAT.OnlineHours to reset everyones online time to "0" kinda like this or something?

"SET
MEMB_STAT.OnlineHours = "0"
"

Something like this could anyone tell me the correct "SQL Query" to reset the online hours count?


Any help for a novice query script user would be much appreciated =)

I figured it out use :

Quote:

---

UPDATE MEMB_STAT
SET MEMB_STAT.OnlineHours='0'
from
MEMB_STAT
WHERE MEMB_STAT.OnlineHours>'1'

---

its like xfire :D counting hours of played game :P

dont work for me :(

can it be made to be used on any web?

god job man :))