Forums

I there a tutorial how to build as Registration Form for Users.
I using Community Builder from https://www.joomlapolis.com/
So I have to add to different Tables:
xx_users table for the Joomla fields
xx_usergroup_map table for the user group
xx_comprofiler table for the the exra field in the CommunityBuilder

Hi Hansueli,

Please see this FAQ

Bob

Thank you
I went through this but had 2 challenges to solve:
1. The user, username and password is saved but the user is not “Activated” and not “Enabled”.
2. How can I save the other tables in CB?:
a) xx_usergroup_map table for the user group
b) xx_comprofiler table for the extra field in the CommunityBuilder.
In the introduction of the FAQ it tells me:
ChronoForms has good support for registering users in ChronoForms and in Community Builder (CB) using the Joomla! Registration action

Hi Hansueli,

I don't use CB so can't offer much detailed help. Normally you'd use the Joomla! (or CB I guess) verification process to enable an account. If you want to bypass that then you can use a Custom MySQL query to update the User table (there's an Update User action that might also do it for you).

To update the CB tables you'd again need to use either a DB Save action or a custom MySQL query.

Bob

Thank you Bob - GH
I am not familiar with the DB save and I like the idea of using a Custom MySQL query to set all the parameters I need.
How do I use one?
How can I insert php? I think I have missed somthing important.
Thank you
Hansueli - nHH
(nHH == noHearHead)

Hi Hansueli,

You can use PHP & MySQL in a Custom Code action in your form. Please see this FAQ about how CF holds the form data. A MySQL query might look like this:

<?php
$db =& JFactory::getDBO();
$query = "
    SELECT `some_input`
        FROM `#__some_table`
        WHERE `some_input` = 'some_value ;
";
$db->setQuery($query);
// some examples
$data = $db->loadObjectList();
// $data = $db->loadResult();
// $db->execute();
?>

Bob

Thank you I will try it