Migrate Vanilla with my website database

marSoul · September 2007

Hi all I am new in this forum, I have a website with its own database and users data, i want to know how can i make my users work in vanilla forum without registering a new user ? I have installed vanilla in my server is this easy work or need time ? because i have little time to complete this website regards

Dinoboff · September 2007

Vanilla has been built to make the DB integration easy
Here are the references to the user table and user table fields.


// User Table
$DatabaseTables['User'] = 'LUM_User';
// User Table fields
$DatabaseColumns['User']['UserID'] = 'UserID';
$DatabaseColumns['User']['RoleID'] = 'RoleID';
$DatabaseColumns['User']['StyleID'] = 'StyleID';
$DatabaseColumns['User']['CustomStyle'] = 'CustomStyle';
$DatabaseColumns['User']['FirstName'] = 'FirstName';
$DatabaseColumns['User']['LastName'] = 'LastName';
$DatabaseColumns['User']['Name'] = 'Name';
$DatabaseColumns['User']['Password'] = 'Password';
$DatabaseColumns['User']['VerificationKey'] = 'VerificationKey';
$DatabaseColumns['User']['EmailVerificationKey'] = 'EmailVerificationKey';
$DatabaseColumns['User']['Email'] = 'Email';
$DatabaseColumns['User']['UtilizeEmail'] = 'UtilizeEmail';
$DatabaseColumns['User']['ShowName'] = 'ShowName';
$DatabaseColumns['User']['Icon'] = 'Icon';
$DatabaseColumns['User']['Picture'] = 'Picture';
$DatabaseColumns['User']['Attributes'] = 'Attributes';
$DatabaseColumns['User']['CountVisit'] = 'CountVisit';
$DatabaseColumns['User']['CountDiscussions'] = 'CountDiscussions';
$DatabaseColumns['User']['CountComments'] = 'CountComments';
$DatabaseColumns['User']['DateFirstVisit'] = 'DateFirstVisit';
$DatabaseColumns['User']['DateLastActive'] = 'DateLastActive';
$DatabaseColumns['User']['RemoteIp'] = 'RemoteIp';
$DatabaseColumns['User']['LastDiscussionPost'] = 'LastDiscussionPost';
$DatabaseColumns['User']['DiscussionSpamCheck'] = 'DiscussionSpamCheck';
$DatabaseColumns['User']['LastCommentPost'] = 'LastCommentPost';
$DatabaseColumns['User']['CommentSpamCheck'] = 'CommentSpamCheck';
$DatabaseColumns['User']['UserBlocksCategories'] = 'UserBlocksCategories';
$DatabaseColumns['User']['DefaultFormatType'] = 'DefaultFormatType';
$DatabaseColumns['User']['Discovery'] = 'Discovery';
$DatabaseColumns['User']['Preferences'] = 'Preferences';
$DatabaseColumns['User']['SendNewApplicantNotifications'] = 'SendNewApplicantNotifications';

Copy that in conf/database.php and change.

You should look on the wiki documentation; there is on example of integration with WP and with Drupal.

Here is the sql request to create the user table:

CREATE TABLE `LUM_User` (
  `UserID` int(10) NOT NULL auto_increment,
  `RoleID` int(2) NOT NULL default '0',
  `StyleID` int(3) NOT NULL default '1',
  `CustomStyle` varchar(255) default NULL,
  `FirstName` varchar(50) NOT NULL default '',
  `LastName` varchar(50) NOT NULL default '',
  `Name` varchar(20) NOT NULL default '',
  `Password` varchar(32) default NULL,
  `VerificationKey` varchar(50) NOT NULL default '',
  `EmailVerificationKey` varchar(50) default NULL,
  `Email` varchar(200) NOT NULL default '',
  `UtilizeEmail` enum('1','0') NOT NULL default '0',
  `ShowName` enum('1','0') NOT NULL default '1',
  `Icon` varchar(255) default NULL,
  `Picture` varchar(255) default NULL,
  `Attributes` text NULL,
  `CountVisit` int(8) NOT NULL default '0',
  `CountDiscussions` int(8) NOT NULL default '0',
  `CountComments` int(8) NOT NULL default '0',
  `DateFirstVisit` datetime NOT NULL default '0000-00-00 00:00:00',
  `DateLastActive` datetime NOT NULL default '0000-00-00 00:00:00',
  `RemoteIp` varchar(100) NOT NULL default '',
  `LastDiscussionPost` datetime default NULL,
  `DiscussionSpamCheck` int(11) NOT NULL default '0',
  `LastCommentPost` datetime default NULL,
  `CommentSpamCheck` int(11) NOT NULL default '0',
  `UserBlocksCategories` enum('1','0') NOT NULL default '0',
  `DefaultFormatType` varchar(20) default NULL,
  `Discovery` text,
  `Preferences` text,
  `SendNewApplicantNotifications` enum('1','0') NOT NULL default '0',
  PRIMARY KEY  (`UserID`),
  KEY `user_role` (`RoleID`),
  KEY `user_style` (`StyleID`),
  KEY `user_name` (`Name`)
);