Confused by the Help re extra mysql fields

Issues related to the Login tools of WYSIWYG Web Builder.
Forum rules
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901

MUST READ:
http://www.wysiwygwebbuilder.com/login_basics.html
http://www.wysiwygwebbuilder.com/login_tools.html

TIP:
A lot of information about the login tools can be found in the help/manual.
Also checkout the demo template that is include with the software.
Post Reply
User avatar
bburgess
 
 
Posts: 129
Joined: Mon May 13, 2013 5:05 am
Location: Australia

Confused by the Help re extra mysql fields

Post by bburgess »

Hi guys ;)

Sorry this has me confused in the help it states:

If you have added custom profile fields to any (or all) of the login objects then you must also create these fields in the database.
Custom profile fields must be named extra1, extra2, extra3 etc!
The following SQL query generates a table with 5 extra custom profile fields:

Code: Select all

CREATE TABLE `USERS` (
`id` int(10) NOT NULL auto_increment,
`username` varchar(50) NOT NULL,
`fullname` varchar(75) NOT NULL,
`password` varchar(50) NOT NULL,
`email` varchar(75) NOT NULL,
`active` tinyint(1) NOT NULL,
`code` varchar(75),
`extra1` varchar(100),
`extra2` varchar(100),
`extra3` varchar(100),
`extra4` varchar(100),
`extra5` varchar(100),
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
Custom profile fields must be named extra1, extra2, extra3 etc! What does that mean please?

Cheers
BB
KISS is the key!
User avatar
Pablo
 
Posts: 21578
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: Confused by the Help re extra mysql fields

Post by Pablo »

It means that the database fields and input fields need to be named like this. You cannot pick random names.
User avatar
bburgess
 
 
Posts: 129
Joined: Mon May 13, 2013 5:05 am
Location: Australia

Re: Confused by the Help re extra mysql fields

Post by bburgess »

Pablo wrote: Mon Oct 02, 2017 10:18 am It means that the database fields and input fields need to be named like this. You cannot pick random names.
Thanks Pablo

I thought that is what it meant, but wanted to be sure, is this because its tied in with the PHP?

Cheers
BB
KISS is the key!
User avatar
Pablo
 
Posts: 21578
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: Confused by the Help re extra mysql fields

Post by Pablo »

No, it is because all names (database fields, input field, scripts, admin tool) need to match.
User avatar
bburgess
 
 
Posts: 129
Joined: Mon May 13, 2013 5:05 am
Location: Australia

Re: Confused by the Help re extra mysql fields

Post by bburgess »

Pablo wrote: Mon Oct 02, 2017 11:05 am No, it is because all names (database fields, input field, scripts, admin tool) need to match.
Thanks Pablo :) at some stage I will get to go through the tools code and not ask you dumb questions :D

Have a great day!

Cheers
BB
KISS is the key!
Post Reply