Migrating Data from PHPNUKE 7.8 to RN76 2.02

Guardian2003 · Posted: Sun Jun 04, 2006 7:57 pm

The DB schema for nuke_blocks may provide the clue as it may be missing the additional field which NSN Groups uses Wink

fkelly · Posted: Sun Jun 04, 2006 8:17 pm

Just to confirm what Guardian said. Those custom fields you mentioned definitely come from the Approve Membership and Add Fields Modules over at Ulsoft.com. If you aren't using those modules you can definitely delete those fields. They are referenced in the Your_Account modifications that Approve Membership makes so you definitely want to be running a "pure" RN 2.02 system before deleting those fields -- i.e., you want to have the Your Account module that comes with RN and not the one that comes with Approve Membership.

Approve Membership has a lot of good features and possibly someday we can build some of them into a future version of RN. But that's another topic.

spurtus · Regular Joined: May 13, 2006 Posts: 89

I will send the FTP and Admin info via a PM.....Here is the table schema info for....

Nuke_Modules:

CREATE TABLE `nuke_modules` (
`mid` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`custom_title` varchar(255) NOT NULL default '',
`active` int(1) NOT NULL default '0',
`view` int(1) NOT NULL default '0',
`groups` text NOT NULL,
`inmenu` tinyint(1) NOT NULL default '1',
`mod_group` int(10) default '0',
`admins` varchar(255) NOT NULL default '',
PRIMARY KEY (`mid`),
KEY `title` (`title`),
KEY `custom_title` (`custom_title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=121 ;

--
-- Table structure for table `nuke_blocks`
--

CREATE TABLE `nuke_blocks` (
`bid` int(10) NOT NULL auto_increment,
`bkey` varchar(15) NOT NULL default '',
`title` varchar(60) NOT NULL default '',
`content` text NOT NULL,
`url` varchar(200) NOT NULL default '',
`bposition` char(1) NOT NULL default '',
`weight` int(10) NOT NULL default '1',
`active` int(1) NOT NULL default '1',
`refresh` int(10) NOT NULL default '0',
`time` varchar(14) NOT NULL default '0',
`blanguage` varchar(30) NOT NULL default '',
`blockfile` varchar(255) NOT NULL default '',
`view` int(1) NOT NULL default '0',
`groups` text NOT NULL,
`expire` varchar(14) NOT NULL default '0',
`action` char(1) NOT NULL default '',
`subscription` int(1) NOT NULL default '0',
PRIMARY KEY (`bid`),
KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

spurtus · Regular Joined: May 13, 2006 Posts: 89

fkelly wrote:

Just to confirm what Guardian said. Those custom fields you mentioned definitely come from the Approve Membership and Add Fields Modules over at Ulsoft.com. If you aren't using those modules you can definitely delete those fields. They are referenced in the Your_Account modifications that Approve Membership makes so you definitely want to be running a "pure" RN 2.02 system before deleting those fields -- i.e., you want to have the Your Account module that comes with RN and not the one that comes with Approve Membership.

Approve Membership has a lot of good features and possibly someday we can build some of them into a future version of RN. But that's another topic.

Understood: I actually never got that anywhere close to working...and it was at that time that I came across NSN (which I like much better)!

spurtus · Regular Joined: May 13, 2006 Posts: 89

oh...if you happen to be prowling around, I was wondering why, in my forums, it no longer shows "new" when new posts are made. Is that a switch somewhere now?

THanks

gregexp · Posted: Sun Jun 04, 2006 10:03 pm

Id prefer to not have too many hands in the pot so to say....guardian u got this or should i?

Just rather there be only one person in..less confusion and not doin something twice...lol

Guardian2003 · Posted: Mon Jun 05, 2006 3:38 am

Go right ahead, I am a little busy right now.
The tables look fine.

spurtus · Regular Joined: May 13, 2006 Posts: 89

Hi...I was just curious if you have found anything yet that I may have kludged at this point ? I am still not able to see a number of the blocks that I would hope to see to be able to make visibible (like Raven's Who is Where" block).

Thanks for all your help!!!

azakow · Posted: Wed Jun 14, 2006 8:44 am

Just what I was looking for! Very Happy

My site was hacked an I would like to keep the complete data base content. In order to do this I'm planing to replace the complete PHPNUKE with RN. Reading up to here gave me a good impression whats ahead of me to build up a new site.

I have a question regarding the user password and site key.
As far as I understand, the site key is used to crypt the pw and then write the crypted pw into the user table and vs versa.

I asume that my old site key is not secret any more. Therefore, I would need a new site key. Confused

Asuming a new site key is set:
1.1 Will users be able to login with thier old pw?
1.2 Do I have to reset all user pw, or generate new passwords?

Asuming the old site key is used:
2.1 Will the system be safe?

Thx.

Guardian2003 · Posted: Wed Jun 14, 2006 8:51 am

Yes
No

You will need to make sure you have your old site working properly before migrating to ensure you do not carry across corrupted or changed data due to changes the hacker(s) may have made.
If you do not do this, you are going to be trying to debug a new site before it is even working and with no point of reference.

azakow · Posted: Fri Jun 16, 2006 12:24 am

Thx alot.
The migration into a local RN test environment was smooth. Very Happy