• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

MyACC "Who is online" shows admin

Solution
slaw
In file: system/pages/online.php

Change:
Code: 
if($db->hasTable('players_online')) // tfs 1.0
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players`, `players_online` WHERE `players`.`id` = `players_online`.`player_id` AND `accounts`.`id` = `players`.`account_id`  ORDER BY ' . $order);
else
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', ' . $promotion . ' `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players` WHERE `players`.`online` > 0 AND `accounts`.`id` =...
Sort by date Sort by votes
hi,

to remove search bar, you need to remove this part from file system/pages/online.php :

Code: 
$twig->display('online.form.html.twig')

about admins: do you mean gamemasters, gods and so?
 
Upvote 0 Downvote
In file: system/pages/online.php

Change:
Code: 
if($db->hasTable('players_online')) // tfs 1.0
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players`, `players_online` WHERE `players`.`id` = `players_online`.`player_id` AND `accounts`.`id` = `players`.`account_id`  ORDER BY ' . $order);
else
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', ' . $promotion . ' `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players` WHERE `players`.`online` > 0 AND `accounts`.`id` = `players`.`account_id`  ORDER BY ' . $order);

To:
Code: 
if($db->hasTable('players_online')) // tfs 1.0
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players`, `players_online` WHERE `players`.`id` = `players_online`.`player_id` AND `accounts`.`id` = `players`.`account_id` AND `players`.`group_id` = 1  ORDER BY ' . $order);
else
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', ' . $promotion . ' `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players` WHERE `players`.`online` > 0 AND `accounts`.`id` = `players`.`account_id` AND `players`.`group_id` = 1 AND `accounts`.`group_id` = 1 ORDER BY ' . $order);
 
Upvote 0 Downvote
Solution
slawkens said:
In file: system/pages/online.php

Change:
Code: 
if($db->hasTable('players_online')) // tfs 1.0
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players`, `players_online` WHERE `players`.`id` = `players_online`.`player_id` AND `accounts`.`id` = `players`.`account_id`  ORDER BY ' . $order);
else
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', ' . $promotion . ' `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players` WHERE `players`.`online` > 0 AND `accounts`.`id` = `players`.`account_id`  ORDER BY ' . $order);

To:
Code: 
if($db->hasTable('players_online')) // tfs 1.0
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players`, `players_online` WHERE `players`.`id` = `players_online`.`player_id` AND `accounts`.`id` = `players`.`account_id` AND `players`.`group_id` = 1  ORDER BY ' . $order);
else
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', ' . $promotion . ' `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players` WHERE `players`.`online` > 0 AND `accounts`.`id` = `players`.`account_id` AND `players`.`group_id` = 1 AND `accounts`.`group_id` = 1 ORDER BY ' . $order);
Click to expand...

The syntax of my code is a bit different:

LUA: 
if (tableExist ('players_online')) // tfs 1.0
$ playersOnline = $ db-> query ('SELECT `accounts`.`country`,` players`.`name`, `level`,` vocation`. $ outfit.', `'. $ skull_time.'` as `skulltime`,` '. $ skull_type.' `` `` `` `` `` players`, `` players`, `players_online` WHERE` players`.`id` = `players_online`.`player_id` AND` accounts`.` id` = `players`.`account_id` AND` players`.`group_id` = 1 ORDER BY '. $ order);
else
$ playersOnline = $ db-> query ('SELECT `accounts`.`country`,` players`.`name`, `level`,` vocation`. $ outfit.', '. $ promotion.' ``. $ skull_time. `` as `skulltime`,` '. $ skull_type. `` `` `` `` `` `` `` players` WHERE `` players`.``> players`.`account_id` AND `players`.`group_id` = 1 AND` accounts`.`group_id` = 1 ORDER BY '. $ order);
 
Upvote 0 Downvote
darkmubr said:
The syntax of my code is a bit different:

LUA: 
if (tableExist ('players_online')) // tfs 1.0
$ playersOnline = $ db-> query ('SELECT `accounts`.`country`,` players`.`name`, `level`,` vocation`. $ outfit.', `'. $ skull_time.'` as `skulltime`,` '. $ skull_type.' `` `` `` `` `` players`, `` players`, `players_online` WHERE` players`.`id` = `players_online`.`player_id` AND` accounts`.` id` = `players`.`account_id` AND` players`.`group_id` = 1 ORDER BY '. $ order);
else
$ playersOnline = $ db-> query ('SELECT `accounts`.`country`,` players`.`name`, `level`,` vocation`. $ outfit.', '. $ promotion.' ``. $ skull_time. `` as `skulltime`,` '. $ skull_type. `` `` `` `` `` `` `` players` WHERE `` players`.``> players`.`account_id` AND `players`.`group_id` = 1 AND` accounts`.`group_id` = 1 ORDER BY '. $ order);
Click to expand...

Try to replace just 2 and 4 line.
 
Upvote 0 Downvote
slawkens said:
In file: system/pages/online.php

Change:
Code: 
if($db->hasTable('players_online')) // tfs 1.0
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players`, `players_online` WHERE `players`.`id` = `players_online`.`player_id` AND `accounts`.`id` = `players`.`account_id`  ORDER BY ' . $order);
else
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', ' . $promotion . ' `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players` WHERE `players`.`online` > 0 AND `accounts`.`id` = `players`.`account_id`  ORDER BY ' . $order);

To:
Code: 
if($db->hasTable('players_online')) // tfs 1.0
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players`, `players_online` WHERE `players`.`id` = `players_online`.`player_id` AND `accounts`.`id` = `players`.`account_id` AND `players`.`group_id` = 1  ORDER BY ' . $order);
else
   $playersOnline = $db->query('SELECT `accounts`.`country`, `players`.`name`, `level`, `vocation`' . $outfit . ', ' . $promotion . ' `' . $skull_time . '` as `skulltime`, `' . $skull_type . '` as `skull` FROM `accounts`, `players` WHERE `players`.`online` > 0 AND `accounts`.`id` = `players`.`account_id` AND `players`.`group_id` = 1 AND `accounts`.`group_id` = 1 ORDER BY ' . $order);
Click to expand...
Works.
 
Last edited:
Upvote 0 Downvote
Back
Top