Super Suite
Get all extensions for one suite price
Design Extender
Design and create unlimited websites
Data Bridge
Develop database-driven websites
eCart
Build a responsive shopping cart + checkout
MySQLi Server Behaviors
Generate streamlined MySQLi
Free PayPal Toolkit
Paypal, PayPal Credit, and Skype
Help
7/18/2011 12:37 pm | #1 newparadigmmedia426729 A little confused. I've been searching around this forum for three days now, still no leads. Dreamweaver couldn't make a table for my registration in security assist, so I made one. I am finding it impossible to match all of the fields. I can't find a table in any of my download centers and there is NO LINK to solution recipe's in my Security Assist download folder...
7/18/2011 1:03 pm | #2 Mike Perry 
A little confused. I've been searching around this forum for three days now, still no leads. Dreamweaver couldn't make a table for my registration in security assist, so I made one. I am finding it impossible to match all of the fields. I can't find a table in any of my download centers and there is NO LINK to solution recipe's in my Security Assist download folder... 
A dumb question -- you've set up the connection in DW to the db, right??
7/18/2011 2:19 pm | #3 newparadigmmedia426729 Yup... it is connecting to the table I have, because I can change the validation fields in the table and it responds in the site. I just need the table that is supposed to be with the security assist. I'm a little lost without it.
7/19/2011 8:07 am | #4 Jason ByrnesWebAssist
which table preset did you select? The table structure is slightly diferant based on the preset you select:
PowerCMSV2Users:
CREATE TABLE IF NOT EXISTS `pcms2_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(50) 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,
`UserGroupID` int(11) NOT NULL default '1',
PRIMARY KEY (`UserID`)
)
PowerStoreV4Users:
CREATE TABLE IF NOT EXISTS `ps4_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(50) 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,
`UserGroupID` int(11) NOT NULL default '1',
PRIMARY KEY (`UserID`)
)
SimpleRegistrationSP:
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`)
)
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.
©1999-2024 WebAssist.com Corporation. All rights reserved and all that jazz.
Account or customer service questions?
Please user our contact form.
Need technical support?
Please visit support to ask a question
Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...
Uploading file...
