So here's a weird thing – wonder if it’ll work.
In the
misc_user_addfields table, in addition to other fields, have also included fields name, username, email and password (same as in the users table) .
As mentioned in previous post the form has two save actions, Saver User and Save Data. Save User saves name, username, email and password to the
users table. In
the Save Data section have set Data Provider to {data:}. Seems therefore that name, username, email and password are also saved to the
misc_user_addfields
table. So although the 2 tables are not linked I am sending all the data from the form submission to the
misc_user_addfields table. So if I create a listing
of this table then the Joomla admin will have sufficient info to figure whether to approve the registration or not.
So what I have is a
users table that has not been altered in any way, this is good. And a custom table that contains the additional registration data that I need to collect as well as a copy of the name / username / email / password values that are in the
users table
And presume can also use Chronoform Connectivity in a similar fashion, to create a form where a user can edit their registration details. In other words if members edits name / password / email then the changes are sent to both the
users table as well as to
misc_user_addfields, whereas any edit made to the fields that are not in the
users table are sent only to
misc_user_addfields . Will likely make username unique and not editable.
Prob not explaining myself properly but am thinking that this might be a way to go ??
This is the debug info
Array
(
[chronoform] => memberregistrationnew
[event] => submit
[name] => Jada Slater
[username] => wecodawesa
[email] => qikujafo@mailinator.net
[password] => Pa$$w0rd!
[confirmpassword] => Pa$$w0rd!
[usernamefk] =>
[ciuStatus] =>
[title] => Culpa cillum minus n
[occupation] =>
[describeoccupation] =>
[experience] =>
[explainexperience] =>
[company] => Burns Villarreal Associates
[city] => Et pariatur Pariatu
[province] =>
[country] => Canada
[nameCountry] =>
[telephone] => +1 (263) 905-2918
[button66] =>
[phpbb3_bbxl1_u] => 1
[phpbb3_bbxl1_k] =>
[phpbb3_bbxl1_sid] => 23045c448862f7a9264430a190eac754
[0d4e14f532d92632bd557daf62d88643] => 87e0c0a54c683449b6cc2c3e4a67519c
[c42234b300a2feaffea15712e4c1305d] => a29738a491d9b76fe217fb84d26cf63a
[joomla_user_state] => logged_in
[jSGCacheBypass] => 1
[Itemid] => 1937
[option] => com_chronoforms6
[view] => form
[7f479ba2ad89d6f65e1b3cc9e6495d8f] => 1
)
Array
(
[joomla_user15] => Array
(
[_success] => User saved successfully under id 1167
[var] => Array
(
[name] => Jada Slater
[username] => wecodawesa
[email] => qikujafo@mailinator.net
[password] => Pa$$w0rd!
[block] => 1
[activation] => d386bee5-70bf-4001-9418-840970f6770e
[registerDate] => 2019-02-17 16:04:20
[id] => 1167
)
)
[save_data17] => Array
(
[data] => Array
(
[chronoform] => memberregistrationnew
[event] => submit
[name] => Jada Slater
[username] => wecodawesa
[email] => qikujafo@mailinator.net
[password] => Pa$$w0rd!
[confirmpassword] => Pa$$w0rd!
[usernamefk] =>
[ciuStatus] =>
[title] => Culpa cillum minus n
[occupation] =>
[describeoccupation] =>
[experience] =>
[explainexperience] =>
[company] => Burns Villarreal Associates
[city] => Et pariatur Pariatu
[province] =>
[country] => Canada
[nameCountry] =>
[telephone] => +1 (263) 905-2918
[button66] =>
[phpbb3_bbxl1_u] => 1
[phpbb3_bbxl1_k] =>
[phpbb3_bbxl1_sid] => 23045c448862f7a9264430a190eac754
[0d4e14f532d92632bd557daf62d88643] => 87e0c0a54c683449b6cc2c3e4a67519c
[c42234b300a2feaffea15712e4c1305d] => a29738a491d9b76fe217fb84d26cf63a
[joomla_user_state] => logged_in
[jSGCacheBypass] => 1
[Itemid] => 1937
[option] => com_chronoforms6
[view] => form
[7f479ba2ad89d6f65e1b3cc9e6495d8f] => 1
)
[_success] => Data saved successfully
[log] => Array
(
[0] => INSERT INTO `misc_user_addfields` (`name`, `username`, `email`, `password`, `confirmpassword`, `usernamefk`, `title`, `occupation`, `describeoccupation`, `experience`, `explainexperience`, `company`, `city`, `province`, `country`, `telephone`) values ('Jada Slater', 'wecodawesa', 'qikujafo@mailinator.net', 'Pa$$w0rd!', 'Pa$$w0rd!', '', 'Culpa cillum minus n', '', '', '', '', 'Burns Villarreal Associates', 'Et pariatur Pariatu', '', 'Canada', '+1 (263) 905-2918');
)
[var] => Array
(
[name] => Jada Slater
[username] => wecodawesa
[email] => qikujafo@mailinator.net
[password] => Pa$$w0rd!
[confirmpassword] => Pa$$w0rd!
[usernamefk] =>
[title] => Culpa cillum minus n
[occupation] =>
[describeoccupation] =>
[experience] =>
[explainexperience] =>
[company] => Burns Villarreal Associates
[city] => Et pariatur Pariatu
[province] =>
[country] => Canada
[telephone] => +1 (263) 905-2918
[id] => 12
)
)
)