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

MyACC "Who is online" shows admin

Solution
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` =...
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?
 
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);
 
Solution
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);

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);
 
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);

Try to replace just 2 and 4 line.
 
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);
Works.
 
Last edited:
Back
Top