Login Page
original form config Event:
end
-- Insert Form
INSERT INTO Form (Title, `Table`, LoadFile, SaveChanges, FormUpdate, DisplayCondition) VALUES
;
-- Link Form to Tab
INSERT INTO TabForm (TabID, FormID) VALUES
((SELECT TabID FROM Tab WHERE TabType = 'logintabs' AND Name = 'login' AND (EventID = '' OR ( = 0 AND EventID IS NULL))), LAST_INSERT_ID());
-- FormElement and specifics
first stage database form config Event:
Array ( [0] => Array ( [loadfile] => [tabtitle] => login [formtitle] => login [displaycondition] => 1 [formupdate] => 0 [formid] => login [formtable] => ) )
end
database form config
Array ( [0] => Array ( [loadfile] => [tabtitle] => login [formtitle] => login [displaycondition] => 1 [formupdate] => 0 [formid] => login [formtable] => ) )
end
original form config Event:0
Array ( [0] => Array ( [tabtitle] => Login [formtitle] => Login [displaycondition] => 1 [formupdate] => 0 [formid] => login [formtable] => [formcolumns] => Array ( [0] => Array ( [type] => email [tablecolumn] => EmailAddress [id] => EmailAddress [startingvalue] => [errormessage] => [placeholder] => user@domain.com [label] => Email Address [required] => 1 ) [1] => Array ( [type] => password [tablecolumn] => Password [id] => Password [startingvalue] => [errormessage] => [placeholder] => [label] => Password [required] => 1 ) ) ) )
end
-- Insert Form
INSERT INTO Form (Title, `Table`, LoadFile, SaveChanges, FormUpdate, DisplayCondition) VALUES
('Login', '', '', NULL, 0, '1');
-- Link Form to Tab
INSERT INTO TabForm (TabID, FormID) VALUES
((SELECT TabID FROM Tab WHERE TabType = 'logintabs' AND Name = 'login' AND (EventID = '0' OR (0 = 0 AND EventID IS NULL))), LAST_INSERT_ID());
-- FormElement and specifics
-- Element 1 for login, type email
INSERT INTO FormElement (Type, Description) VALUES ('email', 'Email Address');
SET @eid = LAST_INSERT_ID();
INSERT INTO FormFormElement (FormID, ElementID, `Order`) VALUES
((SELECT FormID FROM Form ORDER BY FormID DESC LIMIT 1), @eid, 1);
INSERT INTO FormElementEmail (ElementID, TableColumn, ID, StartingValue, ErrorMessage, Placeholder, Label, Required) VALUES
(@eid, 'EmailAddress', 'EmailAddress', '', '', 'user@domain.com', 'Email Address', '1');
-- Element 2 for login, type password
INSERT INTO FormElement (Type, Description) VALUES ('password', 'Password');
SET @eid = LAST_INSERT_ID();
INSERT INTO FormFormElement (FormID, ElementID, `Order`) VALUES
((SELECT FormID FROM Form ORDER BY FormID DESC LIMIT 1), @eid, 2);
INSERT INTO FormElementPassword (ElementID, TableColumn, ID, StartingValue, ErrorMessage, Placeholder, Label, Required) VALUES
(@eid, 'Password', 'Password', '', '', '', 'Password', '1');
first stage database form config Event:0
Array ( [0] => Array ( [loadfile] => [tabtitle] => Login [formtitle] => Login [displaycondition] => 1 [formupdate] => 0 [formid] => login [formtable] => ) )
end
database form config
Array ( [0] => Array ( [loadfile] => [tabtitle] => Login [formtitle] => Login [displaycondition] => 1 [formupdate] => 0 [formid] => login [formtable] => [formcolumns] => Array ( [0] => Array ( [type] => email [tablecolumn] => EmailAddress [id] => EmailAddress [startingvalue] => [errormessage] => [placeholder] => user@domain.com [label] => Email Address [required] => 1 [idcolumn] => ) [1] => Array ( [type] => password [tablecolumn] => Password [id] => Password [startingvalue] => [errormessage] => [placeholder] => [label] => Password [required] => 1 ) ) ) )
end
original form config Event:0
Array ( [0] => Array ( [tabtitle] => Login [formtitle] => Login [displaycondition] => 1 [formupdate] => 0 [formid] => login [formtable] => [formcolumns] => Array ( [0] => Array ( [type] => email [tablecolumn] => EmailAddress [id] => EmailAddress [startingvalue] => [errormessage] => [placeholder] => user@domain.com [label] => Email Address [required] => 1 ) [1] => Array ( [type] => password [tablecolumn] => Password [id] => Password [startingvalue] => [errormessage] => [placeholder] => [label] => Password [required] => 1 ) ) ) )
end
-- Insert Form
INSERT INTO Form (Title, `Table`, LoadFile, SaveChanges, FormUpdate, DisplayCondition) VALUES
('Login', '', '', NULL, 0, '1');
-- Link Form to Tab
INSERT INTO TabForm (TabID, FormID) VALUES
((SELECT TabID FROM Tab WHERE TabType = 'logintabs' AND Name = 'login' AND (EventID = '0' OR (0 = 0 AND EventID IS NULL))), LAST_INSERT_ID());
-- FormElement and specifics
-- Element 1 for login, type email
INSERT INTO FormElement (Type, Description) VALUES ('email', 'Email Address');
SET @eid = LAST_INSERT_ID();
INSERT INTO FormFormElement (FormID, ElementID, `Order`) VALUES
((SELECT FormID FROM Form ORDER BY FormID DESC LIMIT 1), @eid, 1);
INSERT INTO FormElementEmail (ElementID, TableColumn, ID, StartingValue, ErrorMessage, Placeholder, Label, Required) VALUES
(@eid, 'EmailAddress', 'EmailAddress', '', '', 'user@domain.com', 'Email Address', '1');
-- Element 2 for login, type password
INSERT INTO FormElement (Type, Description) VALUES ('password', 'Password');
SET @eid = LAST_INSERT_ID();
INSERT INTO FormFormElement (FormID, ElementID, `Order`) VALUES
((SELECT FormID FROM Form ORDER BY FormID DESC LIMIT 1), @eid, 2);
INSERT INTO FormElementPassword (ElementID, TableColumn, ID, StartingValue, ErrorMessage, Placeholder, Label, Required) VALUES
(@eid, 'Password', 'Password', '', '', '', 'Password', '1');
first stage database form config Event:0
Array ( [0] => Array ( [loadfile] => [tabtitle] => Login [formtitle] => Login [displaycondition] => 1 [formupdate] => 0 [formid] => login [formtable] => ) )
end
database form config
Array ( [0] => Array ( [loadfile] => [tabtitle] => Login [formtitle] => Login [displaycondition] => 1 [formupdate] => 0 [formid] => login [formtable] => [formcolumns] => Array ( [0] => Array ( [type] => email [tablecolumn] => EmailAddress [id] => EmailAddress [startingvalue] => [errormessage] => [placeholder] => user@domain.com [label] => Email Address [required] => 1 [idcolumn] => ) [1] => Array ( [type] => password [tablecolumn] => Password [id] => Password [startingvalue] => [errormessage] => [placeholder] => [label] => Password [required] => 1 ) ) ) )
end