ImpEx: Write custom script for homebrew forum

[FBChris]

I just purchased vBulletin and am looking at the ImpEx system.

I did have my homemade message board and want to import it. I did take a look at the pre-made ImpEx systems scripts.

Is there a developer manual available?

What about my forum structure, it is pretty straight forward. Is there any of the systems which has a similar structure? This can be a good starting point for creating my own import scripts.

#
# Table structure for table `category`
#

CREATE TABLE `category` (
  `category` tinyint(2) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  PRIMARY KEY  (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `forum`
#

CREATE TABLE `forum` (
  `forum` tinyint(3) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `description` tinytext,
  `note` tinytext NOT NULL,
  `moderators` varchar(50) NOT NULL default '',
  `category` tinyint(3) default NULL,
  `ordering` tinyint(3) default NULL,
  `code` set('html','forumcode','imgcode') NOT NULL default 'forumcode,imgcode',
  `hide` enum('Y','N') default 'N',
  `lastpost` int(10) default NULL,
  `topic` int(7) NOT NULL default '0',
  `reply` int(7) NOT NULL default '0',
  `showdays` int(2) NOT NULL default '0',
  `read_access` varchar(40) NOT NULL default '',
  `post_access` varchar(40) NOT NULL default '',
  `reply_access` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`forum`),
  KEY `forum` (`forum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `post`
#

CREATE TABLE `post` (
  `post` int(10) NOT NULL auto_increment,
  `topic` int(10) NOT NULL default '0',
  `user` int(10) NOT NULL default '0',
  `forum` int(3) NOT NULL default '0',
  `body` text,
  `date` int(10) NOT NULL default '0',
  `attachment` int(5) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `edit` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`post`),
  KEY `user` (`user`),
  KEY `topic` (`topic`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `topic`
#

CREATE TABLE `topic` (
  `topic` int(10) NOT NULL auto_increment,
  `user` int(5) default NULL,
  `title` varchar(50) default NULL,
  `start` int(10) default NULL,
  `last` int(10) default NULL,
  `icon` int(2) default NULL,
  `reply` int(5) default NULL,
  `view` int(5) NOT NULL default '0',
  `forum` int(3) default NULL,
  `closed` enum('Y','N') default 'N',
  `announce` enum('Y','N') default 'N',
  `sticky` enum('Y','N') default 'N',
  `hide` enum('Y','N') default 'N',
  `poll` blob NOT NULL,
  PRIMARY KEY  (`topic`),
  KEY `forum` (`forum`,`last`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `user`
#

CREATE TABLE `user` (
  `user` int(5) NOT NULL auto_increment,
  `privilege` int(3) NOT NULL default '1',
  `name` varchar(20) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `email` varchar(70) NOT NULL default '',
  `origemail` varchar(70) NOT NULL default '',
  `showemail` enum('Y','N') default 'Y',
  `register` int(10) NOT NULL default '0',
  `birthday` int(10) NOT NULL default '0',
  `icq` int(10) NOT NULL default '0',
  `title` varchar(30) NOT NULL default '',
  `icon` varchar(75) NOT NULL default '',
  `homepage` varchar(100) NOT NULL default '',
  `occupation` tinytext NOT NULL,
  `intresses` tinytext NOT NULL,
  `signature` tinytext NOT NULL,
  `status` varchar(30) NOT NULL default '',
  `prefs` varchar(150) NOT NULL default '',
  `totalposts` int(5) NOT NULL default '0',
  `sex` enum('M','F') default 'M',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`user`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `userprofile`
#

CREATE TABLE `userprofile` (
  `id` int(10) NOT NULL auto_increment,
  `user` int(10) NOT NULL default '0',
  `body` text NOT NULL,
  `createdate` int(10) NOT NULL default '0',
  `updatedate` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;