Additional registration info tied to _users table?

highrockmedia 01 Oct, 2008
I am using the registration plugin in Chronoforms and collect addtional user info on my registration form such as company name, phone, postal code, city, state.

I see that the additional info gets inserted in a table called _chronoforms_1 whereas the basic user info goes into _users table.

Is there a foreign key that ties the additional info I collect to the Joomla user table?
Max_admin 01 Oct, 2008
Hi, if you got V3.0 stable then the user id will get automatically inserted in the Chronoforms table, any earlier version will be hard to have any relations with registrations!

Cheers

Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
highrockmedia 01 Oct, 2008
3.0 only works with Joomla 1.5 though right?
Max_admin 01 Oct, 2008
oh yes, you have J1.0.x ? this may be a problem...
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
highrockmedia 01 Oct, 2008
yes it's Joomla 1.0.15. I think it will take less time to write some MySQL rather than upgrading the site to 1.5 at this point. I was only brought in for maintenance work, its not my own site.
Max_admin 01 Oct, 2008
free some field in the table for the user id, name it user_id for example and change the MYSQL at the auto generated so that it adds a posted variable with name user_id to this field.

now at the joomla registration plugin file you need to find the line which stores the user with ->store and below it add : $_POST['user_id'] = $row->id;

I think this will do it!

Cheers

Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
highrockmedia 01 Oct, 2008

now at the joomla registration plugin file you need to find the line which stores the user with ->store and below it add : $_POST['user_id'] = $row->id;


Max can you tell me what line number in that file? Its the one named "cf_joomla_registration.php" right?
Max_admin 02 Oct, 2008
yes that file, just look for ->store, how many instances of this word there ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.