Hiy madelectrical,
That's odd. Do you have the 'User Registration Solution Pack' showing on your 'Download Products' ( downloadcenter.php ) page?
If so:
click that - and then on the next page - click the 'User Registration Solution Pack' (again) and download the 'Complete Files' . When you unzip that, you will have the folder 'UserRegistration100'. Inside that there is a folder called 'Database', and finally, inside that is a 'users.sql' file. As far as I know, - and I hope someone will correct me if I'm wrong - this is the closest you'll come to the file you need in the resources you've (we've) been given.
If not: (and this should have happened earlier - I apologise) this is it:
CREATE TABLE `users` (
`UserID` int(11) NOT NULL auto_increment,
`UserEmail` varchar(500) default NULL,
`UserPassword` varchar(500) default NULL,
`UserFirstName` varchar(50) default NULL,
`UserLastName` varchar(50) default NULL,
`UserCity` varchar(90) default NULL,
`UserState` varchar(20) default NULL,
`UserZip` varchar(12) default NULL,
`UserEmailVerified` tinyint(1) default '0',
`UserRegistrationDate` timestamp NULL default CURRENT_TIMESTAMP,
`UserVerificationCode` varchar(20) default NULL,
`UserIP` varchar(50) default NULL,
`UserPhone` varchar(20) default NULL,
`UserFax` varchar(20) default NULL,
`UserCountry` varchar(20) default NULL,
`UserAddress` varchar(100) default NULL,
`UserAddress2` varchar(50) default NULL,
PRIMARY KEY (`UserID`)
)
Copy that code into a plaintext (Notepad?) file and save it as users.sql
Or just paste the code into the SQL query area in your mySql (i do it via phpMyAdmin) in your blue sky database.
You may need to adjust the sql a little bit, but that would be easy to do, and I think it's pretty much up to what is required for the tutorial.
Hope this helps.
Neil H
PS Have also put the User Registration zip file: here LINK REMOVED BY Jason Byrnes