Does a convertor exist for Xoops Community Forum System??

[Lord Raiden]

Got a friend who's wanting to move from Xoops to Phpbb, but we don't know if the existing system can be converted over or not. Does anyone know?

[D¡cky]

Maybe this,

http://www.phpbb.com/phpBB/viewtopic.ph ... 50#1891850

[Lord Raiden]

Nope, that's newbb. Xoops is entirely different.

[lordzim]

xoops uses newbb, there is also a update for newbb called cbb.

i'm running an xoops site with cbb, and would like to find a phpbb converter.

i only need to convert the forum topics and posts.

i did the member list by hand.

[lordzim]

example:

-- Table structure for table `xoops_bb_topics`
--

DROP TABLE IF EXISTS `xoops_bb_topics`;
CREATE TABLE IF NOT EXISTS `xoops_bb_topics` (
`topic_id` int(8) unsigned NOT NULL auto_increment,
`topic_title` varchar(255) default NULL,
`topic_poster` int(10) unsigned NOT NULL default '0',
`topic_time` int(10) unsigned NOT NULL default '0',
`topic_views` int(10) unsigned NOT NULL default '0',
`topic_replies` mediumint(8) unsigned NOT NULL default '0',
`topic_last_post_id` int(8) unsigned NOT NULL default '0',
`forum_id` smallint(4) unsigned NOT NULL default '0',
`topic_status` tinyint(1) unsigned NOT NULL default '0',
`topic_subject` smallint(3) unsigned NOT NULL default '0',
`topic_sticky` tinyint(1) unsigned NOT NULL default '0',
`topic_digest` tinyint(1) unsigned NOT NULL default '0',
`digest_time` int(10) unsigned NOT NULL default '0',
`approved` tinyint(2) NOT NULL default '1',
`poster_name` varchar(255) default NULL,
`rating` double(6,4) NOT NULL default '0.0000',
`votes` int(11) unsigned NOT NULL default '0',
`topic_haspoll` tinyint(1) unsigned NOT NULL default '0',
`poll_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`topic_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_last_post_id` (`topic_last_post_id`),
KEY `topic_poster` (`topic_poster`),
KEY `topic_forum` (`topic_id`,`forum_id`),
KEY `topic_sticky` (`topic_sticky`),
KEY `digest_time` (`digest_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1322 ;

--
-- Dumping data for table `xoops_bb_topics`
--

INSERT INTO `xoops_bb_topics` VALUES (1, 'I AM THE 1ST!!!!!!!!!!', 5, 1107702775, 78, 5, 13, 1, 0, 0, 0, 0, 0, 1, NULL, 0.0000, 0, 0, 0);
INSERT INTO `xoops_bb_topics` VALUES (2, 'DC EL ALA, donkeyspit server', 1, 1107701466, 65, 3, 12, 2, 0, 0, 0, 0, 0, 1, NULL, 0.0000, 0, 0, 0);

[lordzim]

-- Table structure for table `xoops_bb_posts`
--

DROP TABLE IF EXISTS `xoops_bb_posts`;
CREATE TABLE IF NOT EXISTS `xoops_bb_posts` (
`post_id` int(10) unsigned NOT NULL auto_increment,
`pid` int(10) unsigned NOT NULL default '0',
`topic_id` int(8) unsigned NOT NULL default '0',
`forum_id` smallint(4) unsigned NOT NULL default '0',
`post_time` int(10) unsigned NOT NULL default '0',
`uid` int(5) unsigned NOT NULL default '0',
`poster_name` varchar(255) default NULL,
`poster_ip` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`dohtml` tinyint(1) unsigned NOT NULL default '0',
`dosmiley` tinyint(1) unsigned NOT NULL default '1',
`doxcode` tinyint(1) unsigned NOT NULL default '1',
`dobr` tinyint(1) unsigned NOT NULL default '1',
`doimage` tinyint(1) unsigned NOT NULL default '1',
`icon` varchar(25) NOT NULL default '',
`attachsig` tinyint(1) unsigned NOT NULL default '0',
`approved` smallint(2) NOT NULL default '1',
`post_karma` int(10) unsigned NOT NULL default '0',
`attachment` text,
`require_reply` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`post_id`),
KEY `uid` (`uid`),
KEY `pid` (`pid`),
KEY `subject` (`subject`(40)),
KEY `forumid_uid` (`forum_id`,`uid`),
KEY `topicid_uid` (`topic_id`,`uid`),
KEY `topicid_postid_pid` (`topic_id`,`post_id`,`pid`),
KEY `forum_id` (`forum_id`),
KEY `topic_id` (`topic_id`),
KEY `post_time` (`post_time`),
FULLTEXT KEY `search` (`subject`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8274 ;

--
-- Dumping data for table `xoops_bb_posts`
--

INSERT INTO `xoops_bb_posts` VALUES (1, 0, 1, 1, 1107649450, 5, NULL, 24, 'I AM THE 1ST!!!!!!!!!!', 0, 1, 1, 1, 1, '', 1, 1, 0, NULL, 0);
INSERT INTO `xoops_bb_posts` VALUES (2, 1, 1, 1, 1107649725, 1, NULL, 68, 'Re: I AM THE 1ST!!!!!!!!!!', 0, 1, 1, 1, 1, '', 0, 1, 0, NULL, 0);

[lordzim]

-- Table structure for table `xoops_bb_posts_text`
--

DROP TABLE IF EXISTS `xoops_bb_posts_text`;
CREATE TABLE IF NOT EXISTS `xoops_bb_posts_text` (
`post_id` int(10) unsigned NOT NULL default '0',
`post_text` text,
`post_edit` text NOT NULL,
PRIMARY KEY (`post_id`),
FULLTEXT KEY `search` (`post_text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `xoops_bb_posts_text`
--

INSERT INTO `xoops_bb_posts_text` VALUES (1, 'until Zim deletes it...LOL.', '');
INSERT INTO `xoops_bb_posts_text` VALUES (2, 'lmao, nah\r\n\r\nhell your a mod, you can del my post :x ', '');
INSERT INTO `xoops_bb_posts_text` VALUES (3, 'WEll... IM Second! LOLOLOL :w00t ', '');
INSERT INTO `xoops_bb_posts_text` VALUES (4, 'third :P ', '');

[D¡cky]

The posts and topics tables look almost the same as phpBB tables with some extra fields. The posts_text table is the same but is missing the bbcode_uid field. You could probably get by with renaming the tables and dropping the extra fields. The bbcode_uid field will have to be added to the posts_text table.

If you have the phpBB download package, look at install/mysql_schema.sql to see the table differences.

[lordzim]

oh yeah, they are very simular, just editing a few thousand posts will take for ev er.

[D¡cky]

Why would you have to edit the posts? Because of the formatting? I say that because I wonder what newbb uses for bbcode since there is no bbcode_uid field.

[piroman]

Will the newbb2 2 phpbb converter do the job with cbb?

[lordzim]

i would like to know as well

[D¡cky]

Will the newbb2 2 phpbb converter do the job with cbb?

The only way you are going to find out, is to try it. If you have backups of your databases, you have nothing to lose.

[piroman]

Hi Dicky, thx for the answer, but I don't have it, and I don't intend to lose a week or 2 to find it if it wont work

regs
Piroman