[snafuu]

Okay, I have this installed. I just converted my old phpBB forum to vB, and the phpbb one had a 'blog' mod installed. I compared the databases from the vB one and the phpBB one, and they were very similar. My users really want their 'blog' posts on the new one. Is there a way I can import the phpbb one into the new vB one?

the phpbb one looks like this:

-- Table structure for table `phpbb_weblog_entries`
--

CREATE TABLE `phpbb_weblog_entries` (
`entry_id` mediumint(8) unsigned NOT NULL default '0',
`weblog_id` mediumint(8) unsigned NOT NULL default '0',
`entry_access` tinyint(4) unsigned NOT NULL default '0',
`entry_subject` varchar(60) NOT NULL default '',
`entry_text` text NOT NULL,
`bbcode_uid` varchar(10) NOT NULL default '',
`entry_mood` smallint(5) NOT NULL default '0',
`entry_currently` smallint(5) NOT NULL default '0',
`currently_text` varchar(60) NOT NULL default '',
`entry_time` int(11) NOT NULL default '0',
`entry_views` mediumint(8) unsigned NOT NULL default '0',
`enable_bbcode` tinyint(1) unsigned NOT NULL default '1',
`enable_smilies` tinyint(1) unsigned NOT NULL default '1',
`enable_html` tinyint(1) unsigned NOT NULL default '0',
`memorable` tinyint(1) unsigned NOT NULL default '0',
`no_replies` tinyint(1) unsigned NOT NULL default '0',
`entry_replies` mediumint(8) unsigned NOT NULL default '0',
`entry_last_post_userid` mediumint(8) unsigned NOT NULL default '0',
`entry_last_post_id` mediumint(8) unsigned NOT NULL default '0',
`entry_poster_id` mediumint(8) NOT NULL default '0',
`entry_trackbacks` smallint(5) unsigned NOT NULL default '0',
`entry_deleted` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`entry_id`),
KEY `weblog_id` (`weblog_id`),
KEY `entry_last_post_userid` (`entry_last_post_userid`),
KEY `entry_last_post_id` (`entry_last_post_id`),
KEY `entry_poster_id` (`entry_poster_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `phpbb_weblog_entries`
--

INSERT INTO `phpbb_weblog_entries` VALUES (1, 1, 1, 'SnafuMedia presents: BLOGS!', ':shock:', 'd1a5cbe5d1', -1, 5, 'Computer Screen', 1122085630, 182, 1, 1, 1, 0, 0, 1, 48, 6, 2, 0, 0);

Here's what that one looks like: http://snafumedia.com/forum/phpBB2/weblog_entry.php?e=1

Now here's the vB Journal one just for comparison:

--
-- Table structure for table `snafo_journal_entries`
--

CREATE TABLE `snafo_journal_entries` (
`entry_id` int(10) NOT NULL auto_increment,
`journal_id` int(10) NOT NULL default '0',
`entrytitle` varchar(80) NOT NULL default '',
`entrytext` mediumtext NOT NULL,
`entrydate` int(10) NOT NULL default '0',
`ipaddress` varchar(15) NOT NULL default '',
`mood` int(10) NOT NULL default '0',
`entry_totalrating` int(15) NOT NULL default '0',
`entry_totalvotes` int(10) NOT NULL default '0',
`private` tinyint(4) NOT NULL default '0',
`allowbuddies` tinyint(4) NOT NULL default '0',
`whocanview` varchar(150) NOT NULL default '',
`entry_active` tinyint(4) NOT NULL default '0',
`allowedusers` mediumtext,
`np` text NOT NULL,
PRIMARY KEY (`entry_id`),
KEY `journal_id` (`journal_id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

--
-- Dumping data for table `snafo_journal_entries`
--

INSERT INTO `snafo_journal_entries` VALUES (1, 1, 'Way to go...', 'Three cheers for Snafu...\r\n\r\nHip-hip Horray!\r\nHip-hip Horray!\r\nHip-hip Horray!\r\n\r\nbsb', 1139504972, '68.197.152.61', 0, 0, 0, 0, 0, '', 1, '', '');

from: http://snafumedia.com/snafo/journal....howjournal&j=1

There's only a couple dozen people who actually use the blog/journal thing, so It would be easy for me to relate one blog ID to a user ID.

ideas?

Thanks.