Newbie Spellweaver
- Joined
- Jan 27, 2007
- Messages
- 34
- Reaction score
- 1
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
You must put it in Modules/Most Online.php
Credit : Me (TheKamikaze/DjSoulz)
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
PHP:
<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)
Last edited: