ADMINISTRATIVE rights

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
AndrewThomas
Registered User
Posts: 215
Joined: Sun Aug 10, 2003 2:17 am

ADMINISTRATIVE rights

Post by AndrewThomas » 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
www.technoputa.com

Cause EVERYONE Listens To Techno

User avatar
Drexion
Former Team Member
Posts: 8892
Joined: Sat Jan 25, 2003 9:54 pm
Location: City 17

Post by Drexion » 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.

AndrewThomas
Registered User
Posts: 215
Joined: Sun Aug 10, 2003 2:17 am

Post by AndrewThomas » Tue Jan 04, 2005 10:30 pm

thanx xo very much
www.technoputa.com

Cause EVERYONE Listens To Techno

Locked

Return to “2.0.x Support Forum”