| FBChris |
01-06-2008 10:37 AM |
ImpEx: Write custom script for homebrew forum
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.
Code:
#
# 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;
|
More Information