Page 1 of 1
Posted: Tue Jan 04, 2005 10:16 pm
ok some how a user got administrative rights on my site
is there anyway to set the all the ADMIN users to Reg users including myself then how would i make myself ADMIN again
anyone can PLEASE help
thanx and happy new years
Posted: Tue Jan 04, 2005 10:21 pm
This query will list all admins
SELECT username FROM phpbb_users WHERE user_level = 1;
This query will UN-admin anyone who is an admin
UPDATE phpbb_users SET user_level = 0 WHERE (user_level = 1 AND user_id > 1);
This query will then set a user to admin
UPDATE phpbb_users SET user_level = 1 WHERE username = "YourUsername";
replace YourUsername with your username.
Most paid hosts have phpMyAdmin
preinstalled and can be used to run queries.
Sometimes you can run queries via your hosting control panel.
In addition, double check your webspace for any suspicious files which may have been placed there by outsiders.
And if you are not running 2.0.11, upgrade asap.
Posted: Tue Jan 04, 2005 10:30 pm
thanx xo very much