• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Znote AAC] Online players records

hodleo

Formerly cbrm -Crypto enthusiast, Retired scripter
Staff member
Global Moderator
Joined
Jan 6, 2009
Messages
6,598
Solutions
3
Reaction score
955
Location
Caribbean Sea
Only for TFS 0.3, unless you add the record tables to your 0.2 db and edit your record globalevent like 0.3

Preview:

huo0BvD.png


record.php
PHP:
<?php 
#    Online Players Records for ZnoteAAC
#    By cbrm @ otland.net

require_once 'engine/init.php'; include 'layout/overall/header.php';
echo'<h1>Online Players Records</h1>';
$record = mysql_query('SELECT * FROM `server_record` ORDER BY `record` DESC LIMIT 20;');
while ($row = mysql_fetch_assoc($record)) {$data[] = $row;}
if (empty($data)) {echo 'This server is not born yet.'; return include 'layout/overall/footer.php';}
?>

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

<table>
<tr class="yellow">
    <td width="30%">
        <span style="font-weight:bold;">Players</span>
    </td>
    <td width="70%">
        <span style="font-weight:bold;">Date</span>
    </td>
</tr>

<?php
foreach($data as $record):
    echo'<tr><td>'.$record['record'].'</td>';
    echo'<td>'.date("M j Y, H:i:s T", $record['timestamp']).'</td></tr>';
endforeach;
echo'</table>'; include 'layout/overall/footer.php'; ?>
 
Last edited:
Save code as "record.php" in your znote folder

Code:
localhost/record.php

You can add link at template with:
PHP:
<li><a href="record.php">Online Records</a></li>
 
Save code as "record.php" in your znote folder

Code:
localhost/record.php

You can add link at template with:
PHP:
<li><a href="record.php">Online Records</a></li>

do you mean my znote folder in phpmyadmin?:eek:
 
your htdocs folder if windows or www directory if linux
 
Do you know how to start this script from 0? I mean, my server isn't officially opened yet, and when I open it I'd like to "reset" the record table. Thank you:)
 
i get this error sometimes
Code:
Fatal error: [] operator not supported for strings in C:\xampp\htdocs\record.php on line 8

and after many refreshes show the record
 
Online Players Records

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given inD:\xxmap\htdocs\record.php on line 8
This server is not born yet.
 
Back
Top