Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

Migrate Vanilla with my website database

edited September 2007 in Vanilla 1.0 Help
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

Comments

  • Options
    edited 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`) );
This discussion has been closed.