I have a stand-alone php script that I'm attempting to integrate with vb. The script has it's own users table, however I'd like to integrate it in such a way that it will use the vb users table in addition to the extra fields that are unique to the scripts user table. What would I need to do? Alter the script's user table to match the user id field of vb's user table?
Here is the sql I'm using to create the script's user table:
Code:
CREATE TABLE nflp_users (
userID int AUTO_INCREMENT NOT NULL,
userName varchar(32) NOT NULL,
password varchar(255) NOT NULL,
salt varchar(255) NOT NULL,
firstname varchar(255),
lastname varchar(255),
email varchar(255) NOT NULL,
`status` tinyint(1) DEFAULT '1',
/* Keys */
PRIMARY KEY (userID)
) ENGINE = MyISAM
CHARACTER SET utf8 COLLATE utf8_general_ci;
Please advise,
Thanks in advance,
Jim