A few weeks ago I was advised to use 2 tables when trying to create a modified Joomla User Registration. This will keep the Users table separate from the modified user fields
Overall need to create
* a modified user registration form
* a form that allows a user to modify their registration detials, including the name, usename, password and email.
I have created a modified form, all in the Users table, using the CF Joomla Registration Plugn.
It works.
Have also created an edit form, using Chronoforms and ChronConnectivity.
This also works for the modified fields, but cant edit the main User fields (name, username, pass, email).
So think I do need to build 2 forms, one with the modified data that links to the Users table.
How do I do this?
Thanks
Overall need to create
* a modified user registration form
* a form that allows a user to modify their registration detials, including the name, usename, password and email.
I have created a modified form, all in the Users table, using the CF Joomla Registration Plugn.
It works.
Have also created an edit form, using Chronoforms and ChronConnectivity.
This also works for the modified fields, but cant edit the main User fields (name, username, pass, email).
So think I do need to build 2 forms, one with the modified data that links to the Users table.
How do I do this?
Thanks
Hi hangbill,
You need 2 forms, one to create new accounts and one to modify existing ones, but both should update the core users table, and any extra user info can be saved into a 2nd table (e.g: title, job..etc), but I think a recent Joomla update is now making it possible to add extra user profiles fields.
Best regards,
Max
You need 2 forms, one to create new accounts and one to modify existing ones, but both should update the core users table, and any extra user info can be saved into a 2nd table (e.g: title, job..etc), but I think a recent Joomla update is now making it possible to add extra user profiles fields.
Best regards,
Max
Hi Max
I do have 2 working forms, one for new Joomla registrations and one for editing. Both the new and editing forms have conditional fields, so that a registered user can edit all of his / her registration details. They only difference between the forms is that a registered user cannot edit the password value. In my setup passwords cannot be changed unless user clicks the "forgot password" link on the Joomla login module. In this case they can change password but then it goes through the Joomla module and the password remains encrypted.
I thought it was ok to place all the new registration fields in the Joomla Users table. In a previous post Greybeard suggested I should save the additional User fields in a separate table, as you have suggested how. In that exchange I was allowing users to change passwords - the password change was not encrypted. Greybeard did not like this setup, agree. And users lost ability to login. Think this was linked to editing the password from Chronoforms. But if the password issue is resolved, then is saving new registration fields to the Users table is a bad practice? And if I must change setup how to do it?
So seems this boils down to 2 questions
What is the risk if new user registation fields are saved to the Users table?
From the new registration or edit form, how do I save some fields to the Users table and other fields to a separate table?
Thanks for the help, appreciate it ...
Bill
I do have 2 working forms, one for new Joomla registrations and one for editing. Both the new and editing forms have conditional fields, so that a registered user can edit all of his / her registration details. They only difference between the forms is that a registered user cannot edit the password value. In my setup passwords cannot be changed unless user clicks the "forgot password" link on the Joomla login module. In this case they can change password but then it goes through the Joomla module and the password remains encrypted.
I thought it was ok to place all the new registration fields in the Joomla Users table. In a previous post Greybeard suggested I should save the additional User fields in a separate table, as you have suggested how. In that exchange I was allowing users to change passwords - the password change was not encrypted. Greybeard did not like this setup, agree. And users lost ability to login. Think this was linked to editing the password from Chronoforms. But if the password issue is resolved, then is saving new registration fields to the Users table is a bad practice? And if I must change setup how to do it?
So seems this boils down to 2 questions
What is the risk if new user registation fields are saved to the Users table?
From the new registration or edit form, how do I save some fields to the Users table and other fields to a separate table?
Thanks for the help, appreciate it ...
Bill
Hi Bill,
Unknown, it depends on Joomla, some system process may be affected by the table change ? now or in the future, I can't know that.
Use 2 save data actions, if this is v6 you are using then leave the "data provider" empty in both and fill the "data override" with the fields you want to save:
OR just make sure the form fields names match the table fields names (applies for both v5 and v6)
Best regards,
Max
What is the risk if new user registation fields are saved to the Users table?
Unknown, it depends on Joomla, some system process may be affected by the table change ? now or in the future, I can't know that.
From the new registration or edit form, how do I save some fields to the Users table and other fields to a separate table?
Use 2 save data actions, if this is v6 you are using then leave the "data provider" empty in both and fill the "data override" with the fields you want to save:
field:{data:field_name}
OR just make sure the form fields names match the table fields names (applies for both v5 and v6)
Best regards,
Max
This topic is locked and no more replies can be posted.
