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: 197
Joined: Mon May 13, 2013 5:05 am
Location: Australia
Contact:

Confused by the Help re extra mysql fields

Post by bburgess » Mon Oct 02, 2017 10:09 am

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

User avatar
Pablo
 
Posts: 13034
Joined: Tue Mar 28, 2006 12:00 pm
Location: Europe
Contact:

Re: Confused by the Help re extra mysql fields

Post by Pablo » 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.

User avatar
bburgess
 
 
Posts: 197
Joined: Mon May 13, 2013 5:05 am
Location: Australia
Contact:

Re: Confused by the Help re extra mysql fields

Post by bburgess » Mon Oct 02, 2017 10:29 am

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

User avatar
Pablo
 
Posts: 13034
Joined: Tue Mar 28, 2006 12:00 pm
Location: Europe
Contact:

Re: Confused by the Help re extra mysql fields

Post by Pablo » Mon Oct 02, 2017 11:05 am

No, it is because all names (database fields, input field, scripts, admin tool) need to match.

User avatar
bburgess
 
 
Posts: 197
Joined: Mon May 13, 2013 5:05 am
Location: Australia
Contact:

Re: Confused by the Help re extra mysql fields

Post by bburgess » Mon Oct 02, 2017 11:26 am

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

Post Reply

Who is online

Users browsing this forum: scribe and 2 guests