How to add forum moderator directly into database

Nuke Soldier Joined: Jun 07, 2004 Posts: 22

I like others get an error due to a bug when I try to add a forum moderator through the control panel. I have been able to add moderators directly into the database by using the following steps. This worked for me but use at your own risk. As always backup your database before making changes.

In table: bbauth_access
1. Browse data then add new row (not new tables but new row of data).
2. group_id = a number that is not currently being used. If you have 1-4 use 5.
3. forum_id = insert the forum number where you would like to add the moderator, this can be found in the forum admin panel or in the url of the forum
4. Fill in the rest of the fields with a 1 for yes or a 0 for no depending on the options you need the moderator to have. Make sure auth_mod is a 1.

In table: bbgroups
1. Browse data then add new row (not new tables but new row of data).
2. group_id = use the same number as you did in bbauth_access step 2.
3. group_type = I used 1 for this field but try 2 if 1 does not work.
4. group_name = A short name for the group.
5. group_description = A short description for the group.
6. group_moderator = 1 (must be a 1)
7. group_single_user = 1 (must use a 1 if this is not a multiple user group)

In table: bbuser_group
1. Browse data then add new row (not new tables but new row of data).
2. group_id = use the same number as you did in bbauth_access step 2.
3. user_id = The user id you want to make a moderator. Can be found in the users table on the users record if you do not know it.
4. user_pending = 0

--- End ---

Nuke Soldier Joined: Apr 26, 2005 Posts: 16

uhh stuck on step one lol Embarassed

i cant browse bbauth_access Mad

but this is perfect since i have never been able to make mods cuz of the blank page with permissions

Site Admin Joined: Aug 17, 2003 Posts: 12397

http://www.nukefixes.com/ftopic-1386-30.html#5100

Nuke Soldier Joined: Apr 26, 2005 Posts: 16

fixgroup.php? that didnt do anything aside from printing out the code on a white page Shocked

what is is supposed to do

Site Admin Joined: Aug 17, 2003 Posts: 12397

Are you using a standard text editor? That code should work if you created and executed the php file correctly

Nuke Soldier Joined: Apr 26, 2005 Posts: 16

yeah i used notepad and a php editor i have i thought it was weird to..but it didnt work Shocked

dunno ill keep trying. but im still not clear what im supposed to do with it Embarassed

*edit* ok i got it. extra space in the copy and paste Very Happy

but still dont get what its for

Site Admin Joined: Aug 17, 2003 Posts: 12397

To fix moderator permissions due to missing group entries

Nuke Soldier Joined: Apr 26, 2005 Posts: 16

ok i cant even get to the screen that changes permissions forum admin/ permissions page is just blank Confused

i really have no clue how to fix it

Site Admin Joined: Aug 17, 2003 Posts: 12397

Using the latest BBToNuke files? Received any error messages? Anything in your error log?

Nuke Soldier Joined: Apr 26, 2005 Posts: 16

Module's Version: 2.0.8
Module's Description: phpBB 2.0.7 port by NukeCops
thats current right? all i could find was 2.0.5 in ur downloads and no no error in my error log and no errors on the page its just blank

**edit update**
ok well i got it kinda. i just did it threw the db. but im a little confused on the "group id" portion what is the group id. how come i have several ppl with the same group id. can those be changed to whatever?

Site Admin Joined: Aug 17, 2003 Posts: 12397

You'll need to download the BBToNuke upgrades from http://www.nukeresources.com - OR even better, just download the latest Patched files for your version. They will upgrade your forums to BBToNuke 2.0.17

Group id is a permissions thing in the database. Every user and usergroup has their own id. When you're given a permission, it applies to the group id. Thus the user permissions and the usergroup permissions can use the same system. Usually the error happens when there is no group id created when a user registers in phpNuke. Thus the fixgroup script to solve this

I can confirm that latest BBToNuke files work. I'm not confirm this for older versions.

Nuke Soldier Joined: Apr 26, 2005 Posts: 16

ok awesome ur a genius lol i been playing with this and posting for months and that upgrade fixed it finally Laughing