I run a gaming clan website, and the person who started the clan has now deceided to leave the clan, but wants to continue as a normal user on the site.
Is there a way to convert that god account to a normal user account?
i have changed the name "God" to something else in the authors table, but that did not do the trick, is there another way? , or will i instead need to rename his account, change the password and ask him to create a new user account?
Joined: Aug 29, 2004 Posts: 9136 Location: Arizona
Posted:
Tue Jan 08, 2008 6:17 am
mrpg99, well, everyone should always have a regular nuke user account, otherwise, they would not be able to post in the forums (for example). So, yes, remove him from the authors table and if he does not have a regular nuke user account, he just needs to request one and then you can give him any groups that he needs (if you have used the "Edit Groups").
Ok now i have messed things up deleting the admin from the authors table worked ok and did not cause many problems, but the old admin was still a member of many of my groups, and listed there as "moderator" and i was unable to remove him from the groups, so i then manually removed him from the nuke_nsngr_groups tables and also in the phpbbforum admin pages set myself as moderator on all groups.
Now when i try to change any permissions in the phpbbadmin page, i get this error message :
Could not obtain moderator status
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.use' at line 3
SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM nuke_bbauth_access aa, nuke_bbuser_group ug WHERE ug.user_id IN () AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id
Dont delete the GOD author row in table nuke_authors. Just edit it. New username and password. Dont forget to set the password to MD5 when you save the edited row
Then use the forums admin to edit your usergroups, ranks and user accounts (user is admin etc)
View next topic View previous topic
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
![[Valid RSS]](http://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::
deleting the admin from the authors table worked ok and did not cause many problems, but the old admin was still a member of many of my groups, and listed there as "moderator" and i was unable to remove him from the groups, so i then manually removed him from the nuke_nsngr_groups tables and also in the phpbbforum admin pages set myself as moderator on all groups.
