change god account to normal user?

New Member Joined: Jan 06, 2007 Posts: 8

Hi There,

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?

Best Regards
mrpg99

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").

Posted: Tue Jan 08, 2008 6:39 am

Aha, i will give it a try Smile

Many thanks for the reply!

Best Regards
mrpg99

Posted: Tue Jan 08, 2008 8:16 am

Ok now i have messed things up Sad

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

Line : 530
File : admin_ug_auth.php

Any ideas guys? , any help is very appriciated!

Br
mrpg99

Posted: Tue Jan 08, 2008 9:42 am

I think it is fixed by using the fixgroup.php script, atleast i do not get any further error messages Smile

Posted: Tue Jan 08, 2008 2:08 pm

Yea you definitely shouldn't be mucking around in the tables. But the fixgroup should get it fixed Wink

Involved Joined: Oct 09, 2006 Posts: 413 Location: UK

Ideally.

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 Idea

Then use the forums admin to edit your usergroups, ranks and user accounts (user is admin etc)