Announcement

Collapse
No announcement yet.

Importing Homebrew Message Board

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Importing Homebrew Message Board

    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 simila 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;

  • #2
    I'm sorry but no Developer manual is available for Impex. Since this is going to require a fair bit of custom coding, you should ask for assistance over at www.vbulletin.org.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X