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
Quote Reply
Re: [xev] integrating with current user db In reply to
Hi,

You would want to use a plugin to do it. I'll be putting up a beta of Gossamer Community in a couple hours that will have a plugin that you can pretty much copy. It will modify Gossamer Forum to authenticate off a different user table.

Cheers,

Alex
--
Gossamer Threads Inc.