2
'lo again
with phpMyadmin and a text editor.....
here's the standard table format for CBB/NewBB
Quote:
-- Table structure for table `96kimpradio_bb_forums`
--
CREATE TABLE `96kimpradio_bb_forums` (
`forum_id` smallint(4) unsigned NOT NULL auto_increment,
`forum_name` varchar(150) NOT NULL default '',
`forum_desc` text,
`parent_forum` int(10) NOT NULL default '0',
`forum_moderator` text NOT NULL,
`forum_topics` int(8) NOT NULL default '0',
`forum_posts` int(8) NOT NULL default '0',
`forum_last_post_id` int(5) unsigned NOT NULL default '0',
`cat_id` int(2) NOT NULL default '0',
`forum_type` int(1) NOT NULL default '0',
`allow_html` int(1) NOT NULL default '1',
`allow_sig` int(1) NOT NULL default '1',
`allow_subject_prefix` int(1) NOT NULL default '0',
`hot_threshold` tinyint(3) unsigned NOT NULL default '10',
`forum_order` int(8) NOT NULL default '0',
`allow_attachments` int(1) NOT NULL default '1',
`attach_maxkb` int(10) NOT NULL default '1000',
`attach_ext` text NOT NULL,
`allow_polls` int(1) NOT NULL default '0',
`subforum_count` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`forum_id`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;
--
and here's the phpBB forums table structure:
Quote:
-- Table structure for table `phpbb_forums`
--
CREATE TABLE `phpbb_forums` (
`forum_id` smallint(5) unsigned NOT NULL default '0',
`cat_id` mediumint(8) unsigned NOT NULL default '0',
`forum_name` varchar(150) default NULL,
`forum_desc` text,
`forum_status` tinyint(4) NOT NULL default '0',
`forum_order` mediumint(8) unsigned NOT NULL default '1',
`forum_posts` mediumint(8) unsigned NOT NULL default '0',
`forum_topics` mediumint(8) unsigned NOT NULL default '0',
`forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
`prune_next` int(11) default NULL,
`prune_enable` tinyint(1) NOT NULL default '0',
`auth_view` tinyint(2) NOT NULL default '0',
`auth_read` tinyint(2) NOT NULL default '0',
`auth_post` tinyint(2) NOT NULL default '0',
`auth_reply` tinyint(2) NOT NULL default '0',
`auth_edit` tinyint(2) NOT NULL default '0',
`auth_delete` tinyint(2) NOT NULL default '0',
`auth_sticky` tinyint(2) NOT NULL default '0',
`auth_announce` tinyint(2) NOT NULL default '0',
`auth_vote` tinyint(2) NOT NULL default '0',
`auth_pollcreate` tinyint(2) NOT NULL default '0',
`auth_attachments` tinyint(2) NOT NULL default '0',
`auth_download` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`forum_id`),
KEY `forums_order` (`forum_order`),
KEY `cat_id` (`cat_id`),
KEY `forum_last_post_id` (`forum_last_post_id`)
) TYPE=MyISAM;
--
as you can see, there are a few more fields in the phpbb forum than there are in the CBB/NewBB forum.... just edit out the 'extra' fields from the phpbb dump, and make sure that the entries are ordered the same as the CBB/NewBB tables are ordered, and then insert them into your XOOPS DB.
It's just really tedious...not hard or too complicated.