Show Admin into list users

[dcontini]

I need to see the admin user in the list of users. The chat is blocked for users only friends but I need to login to operator all users to be able to see it in chat dialogue.
This setting can not seem to find it in the admin panel, so you can give me some advice on the file to edit and how to edit it. Thanks

[dcontini]

It's query sql from user chat:

Code: Select all

$sql = ("
         SELECT DISTINCT " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " userid, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " username, arrowchat_status.session_time lastactivity, " . TABLE_PREFIX . "community_users." . DB_USERTABLE_AVATAR . " avatar, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " link, arrowchat_status.is_admin, arrowchat_status.status 
         FROM " . TABLE_PREFIX . DB_FRIENDSTABLE . " 
         JOIN " . TABLE_PREFIX . DB_USERTABLE . " 
            ON  " . TABLE_PREFIX . DB_FRIENDSTABLE . "." . DB_FRIENDSTABLE_FRIENDID . " = " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " 
         LEFT JOIN arrowchat_status 
            ON " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = arrowchat_status.userid 
         LEFT JOIN " . TABLE_PREFIX . "community_users 
            ON " . TABLE_PREFIX . "community_users.userid = " . TABLE_PREFIX . DB_FRIENDSTABLE . "." . DB_FRIENDSTABLE_FRIENDID . " 
         
         WHERE " . TABLE_PREFIX . DB_FRIENDSTABLE . "." . DB_FRIENDSTABLE_USERID . " = '" . $db->escape_string($userid) . "' 
            AND " . TABLE_PREFIX . DB_FRIENDSTABLE . "." . DB_FRIENDSTABLE_FRIENDS . " = '1' 
            AND (arrowchat_status.session_time + 60 + " . $online_timeout . ") > " . time() . " 
         ORDER BY " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " ASC
      ");

I must also add the administrator as well as friends. I ask one of your Aiut

[Staff Bot]

[b]This thread has been locked because the last post is greater than six months old. There is a good chance that the information in this thread is outdated. Please open a new topic if you wish to discuss this further.[/b]