I like to convert a phpbb2 forum (with many mods installed) to vbulletin 3.7.
This is the most important import:
- Additional profile fields (about 15 new profile fields).
I think the above can be imported easily by modifying the impex files.
I also like to convert three mods to vb.
- One is the smartor photo album, which I have only used for personal albums. These should be imported to vb' s new profile album feature, if possible with comments and ratings.
- The second is a profile guestbook mod, which should be converted to vb' s new visitor messages feature.
- The last mod is a profile view mod. The phpbb mod also stores the time, but I only need the name of the visiting user converted to vb' s recent visitors feature.
I know that invision board has those features, too, so impex might be able to import those into vb. Maybe that code can be adjusted to convert from phpbb.
If the last three mods cannot be converted by impex, can you please advise a manual strategy? I think you could export those databases to excel, modify the columns to suit vb' s database and import it to the new database. Do you know any tutorials for this difficult task?
Here are the database structures:
photo album pictures:
CREATE TABLE `phpbb_album` ( `pic_id` int(11) unsigned NOT NULL auto_increment, `pic_filename` varchar(255) NOT NULL default '', `pic_thumbnail` varchar(255) default NULL, `pic_title` varchar(255) NOT NULL default '', `pic_desc` text, `pic_user_id` mediumint(8) NOT NULL default '0', `pic_username` varchar(32) default NULL, `pic_user_ip` varchar(8) NOT NULL default '0', `pic_time` int(11) unsigned NOT NULL default '0', `pic_cat_id` mediumint(8) unsigned NOT NULL default '1', `pic_view_count` int(11) unsigned NOT NULL default '0', `pic_lock` tinyint(3) NOT NULL default '0', `pic_approval` tinyint(3) NOT NULL default '1', PRIMARY KEY (`pic_id`), KEY `pic_cat_id` (`pic_cat_id`), KEY `pic_user_id` (`pic_user_id`), KEY `pic_time` (`pic_time`) ) TYPE=MyISAM AUTO_INCREMENT=32647 ;
CREATE TABLE `phpbb_album_comment` ( `comment_id` int(11) unsigned NOT NULL auto_increment, `comment_pic_id` int(11) unsigned NOT NULL default '0', `comment_cat_id` int(11) NOT NULL default '0', `comment_user_id` mediumint(8) NOT NULL default '0', `comment_username` varchar(32) default NULL, `comment_user_ip` varchar(8) NOT NULL default '', `comment_time` int(11) unsigned NOT NULL default '0', `comment_text` text, `comment_edit_time` int(11) unsigned default NULL, `comment_edit_count` smallint(5) unsigned NOT NULL default '0', `comment_edit_user_id` mediumint(8) default NULL, PRIMARY KEY (`comment_id`), KEY `comment_pic_id` (`comment_pic_id`), KEY `comment_user_id` (`comment_user_id`), KEY `comment_user_ip` (`comment_user_ip`), KEY `comment_time` (`comment_time`) ) TYPE=MyISAM AUTO_INCREMENT=39271 ;
CREATE TABLE `phpbb_album_rate` ( `rate_pic_id` int(11) unsigned NOT NULL default '0', `rate_user_id` mediumint(8) NOT NULL default '0', `rate_user_ip` char(8) NOT NULL default '', `rate_point` tinyint(3) unsigned NOT NULL default '0', `rate_hon_point` tinyint(3) NOT NULL default '0', KEY `rate_pic_id` (`rate_pic_id`), KEY `rate_user_id` (`rate_user_id`), KEY `rate_user_ip` (`rate_user_ip`), KEY `rate_point` (`rate_point`) ) TYPE=MyISAM;
CREATE TABLE `phpbb_profile_gb` ( `comments_id` int(10) NOT NULL auto_increment, `user_id` int(10) NOT NULL default '0', `comments_text` text NOT NULL, `comments_title` text NOT NULL, `comments_time` int(50) NOT NULL default '0', `comment_bbcode_uid` varchar(10) default NULL, `poster_id` mediumint(8) NOT NULL default '0', PRIMARY KEY (`comments_id`), KEY `comments_id` (`comments_id`), FULLTEXT KEY `comment_bbcode_uid` (`comment_bbcode_uid`) ) TYPE=MyISAM AUTO_INCREMENT=263638 ;
CREATE TABLE `phpbb_profile_view` ( `user_id` mediumint(8) NOT NULL default '0', `viewername` varchar(25) NOT NULL default '', `viewer_id` mediumint(8) NOT NULL default '0', `view_stamp` int(11) NOT NULL default '0', `counter` mediumint(8) NOT NULL default '0' ) TYPE=MyISAM;
Comment