Gossamer Forum
Home : Products : Gossamer Forum : Pre Sales :

integrating with current user db

Quote Reply
integrating with current user db
How hard would it be to integrate this forum with my current user db? I know perl and MySQL very well.

Here is most of my users table:

Code:
# Users - X
$DBH->do(qq|CREATE TABLE tblUsers (
usNum INT(10) NOT NULL AUTO_INCREMENT,
usName CHAR(15) NOT NULL,
# passwords are stored with crypt
# if longer than 8 char crypt is used twice
usPassword CHAR(26) NOT NULL,
usLostPassTime INT(10) NOT NULL,
usLostPassKey CHAR(15) NOT NULL,
usEmail CHAR(50) NOT NULL,
usICQ INT(10) NOT NULL,
usAIM CHAR(16) NOT NULL,
usAdmin ENUM('No','Admin') NOT NULL,
usSuspendUntil INT(10) NOT NULL,

usBanReason ENUM('Flaming','Scamming','Spamming','Feedback Abuse'),
usSignupIp CHAR(15) NOT NULL,
usSignupDate INT(10) NOT NULL,


UNIQUE (usName),INDEX (usEmail),PRIMARY KEY (usNum))|);

Last edited by:

xev: Jan 19, 2003, 5:23 PM
Subject Author Views Date
Thread integrating with current user db xev 1769 Jan 19, 2003, 5:20 PM
Post Re: [xev] integrating with current user db
Alex 1722 Jan 20, 2003, 10:06 AM