Hide admin user in manage user menu

[bexter]

Script URL: latest
Version of script:
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Hi Klemen,

what query if i want to hide admin user in manage user menu?
i want just to show normal user

[Klemen]

In admin/manage_users.php change

Code: Select all

$sql = 'SELECT * FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'users` ORDER BY `id` ASC';

to

Code: Select all

$sql = 'SELECT * FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'users` WHERE `isadmin`='0' ORDER BY `id` ASC';

[bexter]

Code: Select all

$sql = 'SELECT * FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'users` WHERE `isadmin`='0' ORDER BY `id` ASC';

have tried this query before but weird not working

[bexter]

or other ways for me to permanent disable editing admin profile?

[Klemen]

Probably a parse error, try escaping quotes around 0 so it says:

Code: Select all

$sql = 'SELECT * FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'users` WHERE `isadmin`=\'0\' ORDER BY `id` ASC'; 

[bexter]

yes, parse error
thanks klemen.now its working