• 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!

Solved nvm

alramo

New Member
Joined
May 25, 2009
Messages
197
Reaction score
0
it gives the error "Your server does not store information on players online state" and yeha, is because lastlogout is not saved on DB, last login yes , but what should i do and where to make it save last log out? using avesta v4

thanks

PHP:
include ("include.inc.php");
$ptitle="Online Players - $cfg[server_name]";
include ("header.inc.php");
?>
<div id="content">
    <div class="top">Online Players</div>
    <div class="mid">
        <?php
        $SQL = AAC::$SQL;
        try {
            $SQL->myQuery('SELECT name, vocation, level FROM players WHERE online = 1 ORDER BY name ASC');
        } catch(DatabaseQueryException $e) {
            try {
                $SQL->myQuery('SELECT name, vocation, level FROM players WHERE lastlogin > lastlogout ORDER BY name ASC');
            } catch(DatabaseQueryException $e) {
                throw new DatabaseException('Your server does not store information on players online state.');
            }
        }

        if ($SQL->num_rows() == 0) {
            echo 'Nobody is online :-O';
        } else {

            $i = 0;
            echo '<table><tr class="color0"><td style="width:150px"><b>Name</b></td><td style="width:150px"><b>Vocation</b></td><td style="width:60px"><b>Level</b></td></tr>';
            while ($player = $SQL->fetch_array()) {
                $i++;
                echo '<tr '.getStyle($i).'><td><a href="characters.php?player_name='.urlencode($player['name']).'">'.htmlspecialchars($player['name']).'</a></td><td>'.htmlspecialchars($cfg['vocations'][$player['vocation']]['name']).'</td><td>'.$player['level'].'</td></tr>'."\n";
            }
        }
        ?>
        </table>
    </div>
    <div class="bot"></div>
</div>
<?php include ("footer.inc.php");?>
 
Last edited:
Back
Top