RSForm registration and user group assigning

[acrocephalus]

Hello,
How can I assign a user to a specific user group other than registered? For example, under registered groups I have "Member" and "Volunteer", and I need to assign each user to its groups according to the form they use.
Thanks,

Dani

[alexpRS]

Hi!

The following article might put you on the right track: http://www.rsjoomla.com/support/documen ... nment.html

[acrocephalus]

I've tried it but I've run into a problem. I have a form named fes-te-soci. Within the form, there is a hidden field named "Usuari" with value "Soci". Also, I have a group of users named Soci. Then, I want to assign the users registered through this form to the Soci's group. I have tried this code from the linked provided:

Code: Select all

list($replace, $with) = RSFormProHelper::getReplacements($SubmissionId);
$userID = str_replace($replace, $with, '{global:userid}');
JUserHelper::setUserGroups($userID, $_POST['form']['Usuari']);

However, it returns an error:

Code: Select all

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 SQL=SELECT `id`, `title` FROM `mpctz_usergroups` WHERE `id` =

When I check the registered users in the Joomla user's area, the new user is assigned to "Registered" users.
Thanks,

Dani

[alexpRS]

Are you using other scripts besides the ones mentioned within the article ?

[acrocephalus]

No

[alexpRS]

Try this instead:

Code: Select all

list($replace, $with) = RSFormProHelper::getReplacements($SubmissionId);
$userID = str_replace($replace, $with, '{global:userid}');
$gr = array($_POST['form']['Usuari']);
JUserHelper::setUserGroups($userID, $gr);