Page 1 of 1
Hide admin user in manage user menu
Posted: Tue Aug 03, 2010 6:21 pm
by 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
Posted: Wed Aug 04, 2010 9:11 am
by 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';
Posted: Wed Aug 04, 2010 12:52 pm
by 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
Posted: Wed Aug 04, 2010 12:56 pm
by bexter
or other ways for me to permanent disable editing admin profile?
Posted: Wed Aug 04, 2010 3:26 pm
by 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';
Posted: Wed Aug 04, 2010 3:48 pm
by bexter
yes, parse error
thanks klemen.now its working