[Guide] Top 25 Online User PHP Code

[MorgaN]

Hi all , i think this my little guide help some ppl.
It work with odbc and mssql, then no problem with integration.
the ranking take the top 25 online players.

Script : (Modules/Most Online.php)

Code Here:

<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

/**
 * @Throzen
 * @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>

 

[^K1LL3R^]

Брао

 

[StoneAngel]

Live at http://dsep2.sytes.net/MU/index.php?op=most online

 

[ReaL]

Good job
9/10

 

[Break House]

i love you ^^ 11/10

 

[Break House]

its not work

Fatal error: Call to a member function on a non-object in c:\appserv\www\modules\mostonline.php on line 41

 

[MorgaN]

hmm , you have make file?

 

[Murder]

This is only for muweb 0.8.. What to change in the file to get it work ?!

 

[MorgaN]

i have test only for mu web 8

download this link and try agein
http://files.filefront.com/Most+Onlinerar/;10167452;/fileinfo.html

 

[Break House]

i use muweb 0.8

 

[Break House]

 

[MorgaN]

hmm , you must have season 1 or 2 or 3 , what season you have?

 

[Break House]

hmm , you must have season 1 or 2 or 3 , what season you have?

97d

 

[Murder]

My is 98c but it didnt work

 

[ReaL]

It's cuz there are changes in the new DBs of the new versions (s1 s2 and 3), the column in your DB has another name (the column, which shows minutes online)! So look in the DB and change the php file

 

[MorgaN]

yes that need ty ReaL :blush-anim-cl:

 

[MorgaN]

Here is my old php.ini , is work on all version obc.reg

Download : HERE

 

[Mephisto]

this will not work on old version cause this

MEMB_STAT.OnlineHours

missing for old version must be

//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,
from 
MEMB_STAT 
join 
AccountCharacter 
on 
Memb_stat.memb___id = AccountCharacter.ID
ORDER BY 
MEMB_STAT.OnlineHours DESC');

 

[Break House]

not work for 97d

 

[Mephisto]

Ups my bad

//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,
from 
MEMB_STAT 
join 
AccountCharacter 
on 
Memb_stat.memb___id = AccountCharacter.ID
ORDER BY 
MEMB_STAT.ConnectTM DESC');

this should work