Mambo to PHPNuke

adrienne · New Member Joined: Feb 08, 2004 Posts: 6

I am looking for a script to convert Mambo to PHPNuke.

I've converted PHPbb over to PHPnuke in the past. I'm not familiar with Mambo - this is a friends site. I know how awesome Raven is though and figured if there was a script this would be the place to find it! Very Happy

adrienne · New Member Joined: Feb 08, 2004 Posts: 6

I understand to convert from Mambo to PhpNuke you have to have both database files in one database. I've gotten that portion complete.

Mambo has a script that once you do this you can convert from PHPNuke to them.

Since no one here has responded I'm going to try to edit their script to change Mambo into phpnuke.

Wish me luck!

Guardian2003 · Posted: Tue Nov 13, 2007 4:29 pm

Good luck and sorry I couldn't help.

adrienne · New Member Joined: Feb 08, 2004 Posts: 6

Thanks for even checking to see if you could help Smile

The phpnuke to mambo conversion is a module on their page it looks like. That makes it a tad confusing. I'm still trying to knock it out. The only thing that my friend needs is the private messages, users and forum cat/messages.

rashedup.com/igs/com_ezphpnuke.zip is the converter. I'm still pecking away at it - I might have to find another converter to try to write backwards if I can't get this one.

I'm amazed that mambo has an easy translation from nuke but nuke has no easy translation from mambo Sad

Gremmie · Posted: Wed Nov 14, 2007 1:53 pm

Why would anyone want to go from Mambo to Nuke? (ducking...)

adrienne · New Member Joined: Feb 08, 2004 Posts: 6

I finally found a script that would allow mambo to phpbb but it didn't move the private messages. Hopefully I'll be able to find a way to transfer that too..

Once the pms are in phpbb form I can upgrade it to nuke

adrienne · New Member Joined: Feb 08, 2004 Posts: 6

I just tried to put the script in a post and now it says I'm on perma ban Sad

Dunno how I'm posting but might as well dig my grave Laughing

These are the two table structures for the private messages.

CREATE TABLE IF NOT EXISTS `phpbb_privmsgs` (
`privmsgs_id` mediumint( Cool

unsigned NOT NULL auto_increment,
`privmsgs_type` tinyint(4) NOT NULL default '0',
`privmsgs_subject` varchar(255) NOT NULL default '0',
`privmsgs_from_userid` mediumint( Cool

NOT NULL default '0',
`privmsgs_to_userid` mediumint( Cool

NOT NULL default '0',
`privmsgs_date` int(11) NOT NULL default '0',
`privmsgs_ip` char( Cool

NOT NULL,
`privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1',
`privmsgs_enable_html` tinyint(1) NOT NULL default '0',
`privmsgs_enable_smilies` tinyint(1) NOT NULL default '1',
`privmsgs_attach_sig` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`privmsgs_id`),
KEY `privmsgs_from_userid` (`privmsgs_from_userid`),
KEY `privmsgs_to_userid` (`privmsgs_to_userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `mos_pms` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(25) NOT NULL default '',
`whofrom` varchar(25) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`readstate` smallint(1) unsigned NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`message` text NOT NULL,
PRIMARY KEY (`id`),
KEY `pms_idx1` (`username`,`readstate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21041 ;

I'm not a database admin - does anyone have an idea how to convert the two?

Guardian2003 · Posted: Fri Nov 16, 2007 12:17 am

The second database table should not be required. mos_pms is a table used with Mambo so I don't know why it is trying to create that as the script is converting mambo to nuke.
UNLESS the script is later transfering the data from the Mambo table to the nuke one.

The first table name looks like it is for phpBB stand alone not nuke.
The correct table name should be nuke_bbprivmsgs
The fields for that table do look correct

adrienne · New Member Joined: Feb 08, 2004 Posts: 6

The only conversion script that I could find was from mambo to phpbb. I've updated phpbb to phpnuke in the past so that shouldn't be to much of an issue (crosses my fingers).

Unfortunately it did not change over the private messages. The tables I posted are the table structure for the mambo private messages and the phpbb (standalone) tables.

I'm hoping someone knows how to transfer the two Sad