Custom phpbb2 -> vb 3.7

[jigger]

Hello vbulletin-team,

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 ;

album comments:

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 ;

album ratings:

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;

profile guestbook:

 
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 ;

profile views:

 
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;

Thank you!

[Jerry]

Currently there is no gallery import support in ImpEx for any product, what you're asking here is a fairly big bit of work.

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.

Those features aren't imported from IPB, so the code can't be modified it would have to be wholly written.

I'd think the best approach would be to ask for a custom coder from vbulletin.org to help with the migration.

[jigger]

Too bad, this is not supported in impex. Can you please tell me how to add a custom field to impex? I have seen this post of you:
http://www.vbulletin.com/forum/showp...59&postcount=4

But that file seem to have been changed very much, so that I don' t know how to modify that file.

Thank you!

[Jerry]

That post is the explanation of how you add a field and add data to it, for phpBB2 it would be in the file :

impex/systems/phpbb2/004.php