Import existing groups and group users

Regular Joined: Jun 09, 2004 Posts: 79

Migrated from 8.0 to RavenNuke 2.40. I have been searching for some guidelines as to how to move the existing bbtonuke groups to RavenNuke. If I just go into the Admin Panel and add the groups, they get added to the bb_groups table, which already has them. Do I have to start over by cleaning out the bb_groups table and adding all the groups and their users manually from Admin/Groups - or is it possible to convert the users data in the bb_groups table to work with RavenNuke?

Posted: Tue Nov 17, 2009 5:09 pm

First I have to ask how did you migrate everything else?

Posted: Tue Nov 17, 2009 5:37 pm

Thanks for responding. I did search but couldn't find anything about this.

This site was previously hacked, so I started by installing a clean RN 2.40 and then imported old 8.0 db data to it. Everything works well. It has several groups with a lot of users.

Involved Joined: Jul 03, 2006 Posts: 273

You could run My Fix Groups script. If the groups exist in phpbb groups then it will create all the NSN groups to match (and users) automatically for you. Should work fine just make sure you back up the DB first in case something goes wrong.

Script can be found here: Only registered users can see links on this board! Get registered or login!

Posted: Wed Nov 18, 2009 11:00 am

duck wrote:

You could run My Fix Groups script. If the groups exist in phpbb groups then it will create all the NSN groups to match (and users) automatically for you. Should work fine just make sure you back up the DB first in case something goes wrong.

Script can be found here: Only registered users can see links on this board! Get registered or login!

Thanks, I'll try it now.

Posted: Wed Nov 18, 2009 11:33 am

There might be a column mismatch in the group table. I am not sure.

Posted: Wed Nov 18, 2009 12:04 pm

I tried the script 3 times, but it doesn't work. It gives a list of users added, but they are never actually added. The NSN groups were created, however, they are empty.

Posted: Wed Nov 18, 2009 12:25 pm

I'll have a quick look through my script see if I can see what that might be and get back to you. My first guess is Palbins answer may be right about columns.

Posted: Wed Nov 18, 2009 12:57 pm

Can you please list the field names of your _nsngr_users table.

You can look them up via phpmyadmin

Thanks.

Posted: Wed Nov 18, 2009 1:33 pm

duck wrote:

Can you please list the field names of your _nsngr_users table.

You can look them up via phpmyadmin

Thanks.

Code:

CREATE TABLE IF NOT EXISTS `nuke_nsngr_users` (


  `gid` int(11) NOT NULL default '0',


  `uid` int(11) NOT NULL default '0',


  `trial` tinyint(1) NOT NULL default '0',


  `notice` tinyint(1) NOT NULL default '0',


  `sdate` int(14) NOT NULL default '0',


  `edate` int(14) NOT NULL default '0',


  PRIMARY KEY  (`gid`,`uid`)


) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Posted: Wed Nov 18, 2009 2:44 pm

duck, I think there was a "name" column in there or something. I think it was removed because it was duplicate data. I think the uid is just used to get the name now.

Posted: Wed Nov 18, 2009 3:48 pm

Replace with this file

Only registered users can see links on this board! Get registered or login!

Posted: Wed Nov 18, 2009 5:04 pm

Okay, I ran that, and it appears to have done the job. Thanks, Duck, and Palbin, for all your help.
Left a small token at your site.

Posted: Sun Nov 22, 2009 6:37 am

I'm not sure what to select where it says:

Quote:

Set Blocks To:
Set Modules To:
Set NSNGD Categroies To:
Set NSNGDDownloads To:

What exactly does that do?

Posted: Sun Nov 22, 2009 8:28 am

I would imagine those are all fields to "group only" blocks and modules, as well as NSN group downloads (if you have that installed).

What you set them to will depend on if you have any "group only" blocks, modules, or NSN group downloads

just a guess though, haven't seen the script Smile

Posted: Sun Nov 22, 2009 10:14 pm

Yes Spasticdonkey is right. If you have any Blocks Modules or Downloads set to groups only and there is an NSN group that is deleted that was listed in those it will reset those items to what you chose. But only in the case of there is no group left assigned to it.