[ModernAAC] Online Players Records

[hodleo]

----------------------------------------------------

/system/pages/record.php

<?php
/* Online Players Record 
// By CyberM for ModernAAC
// OTLand.NET */

$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = $ots->getDBHandle();

#Load online players record
$record = $SQL->query('select * from server_record order by record desc limit 20;')->fetchAll();
?>

<div class='message'>
    <div class='title'>
        Online Players Records
    </div>
</div><br/>

<?php if(empty($record[0]['record'])) return alert('There are no records of online players.');?>

<center>
    Max amount of online players was of <?php echo $record[0]['record'] ?> players on <?php echo date("M j Y", $record[0]['timestamp']) ?>
</center><br/>

<table border="0" cellspacing="0" cellpadding="5" width="100%" class="cellspadding">
    <tr class="tableheader">
        <td align="center" width="30%">
            <span style="font-weight:bold;">Players</span>
        </td>
        <td width="70%" align="center">
            <span style="font-weight:bold;">Date</span>
        </td>
    </tr>

<?php
    foreach($record as $record):
        echo'<tr><td align="center" >'.$record['record'].'</center></td>';
        echo'<td align="center">'.date("M j Y, H:i:s T", $record['timestamp']).'</td></tr>';
    endforeach;
?>
</table>

Access via http://localhost//index.php/p/v/record
​

​

 

[Wipflash]

Thanks m8 ! i was looking for this

 

[Lanibox]

Thanks! Its awesome

 

[richux]

remember I was once trying to figure out how to write that dmn query, now I know. THx

 

[Shikate]

What's this layout??