Add User to Primary Usergroup Based on Value of Custom Profile Field

This version is for the PRIMARY group. Here is the one for secondary groups:

https://vborg.vbsupport.ru/showthread.php?t=82993

As far as plugins goes, this one is an advanced plugin because you WILL need to make some tweaks to suit your needs.

What this plugin does: If you have a custom profile field, for example one for gender, it checks to see if the user has selected a specific value and then assigns them to a primary user group based on that selection. This happens at the time the user activates their email account after registering.

Instructions for installation:
A. Create your custom profile field and make a note of the field number. (Or simply make a note of the field number of an existing field.)

B. Make a note of the value you are checking for. For example, you may be looking to see if your member selected "male" in your custom gender field.

C. Make a note of the usergroup number that you want to set the user to.

D. Here you have two options:
Option 1: Edit the attached XML file before you import it to change the field number, the value that you check for and the usergroupid. In my XML file, I am checking field5 to see if the value is yes and changing the usergroup to 10.

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugins>
	<plugin active="1" product="vbulletin">
		<title>Put User In User Group Based on Field Value</title>
		<hookname>register_activate_process</hookname>
		<phpcode><![CDATA[// Get the value for field 5
        $user = $db->query_first("
			SELECT field5
			FROM " . TABLE_PREFIX . "userfield
			WHERE userid = " . $vbulletin->userinfo['userid'] . "
		");


		if ($user['field5'] == 'yes')
		{
			$userdata->set('usergroupid', 10);
		}]]></phpcode>
	</plugin>
</plugins>

If, for example, you want to check the value of field6, change field5 in the XML file to field6. If you are looking for "male" instead of "yes", change

if ($user['field5'] == 'yes')

to:

if ($user['field5'] == 'male')

And, finally, change the usergroup as appropriate. Instead of 10 in this line:

$userdata->set('usergroupid', 10);

substiture your usergroupid of choice.

Option 2: Import the XML file as is, open the plugin manager, and make your edits there.


NOTE: This mod works for forums that require users to verify their email address upon registration. If your forum does not require users to verify their email address, you will need to use a different hook. If I have time, I'll test that variation.

Amy

[Oreamnos]

NOTE: This mod works for forums that require users to verify their email address upon registration. If your forum does not require users to verify their email address, you will need to use a different hook. If I have time, I'll test that variation.

OK, after I registered about 20 new test users here is what i found regarding this plugin's use with non-email verification registrations.

I tried almost every register_hook_name and none of them worked. it doesn't seem like it's possible to process this plugin without using the email verification function.

That being said, if you only want to move a user to another primary group on registration without a custom field being checked, you can still do this:

Add this:

PHP Code:

$userdata->set('usergroupid', 11); 


(where 11 is the ID of the new primary usergroup)

Hook that with:
register_addmember_process

Activate and every member that registers on your site will have their primary group changed to ID: 11 (or whatever your choose)

i hope this info helps and saves some people a lot of time.

eric

[DeMagH]

it should be hooked correctly in my forums "using 3.6.2" but it doesn't seem to work
here is my code, please let me know if something is wrong: "i use field5 by the way"

if ($user['field5'] == 'Egypt')
{
	$userdata->set('usergroupid', 14);
}
if ($user['field5'] == 'Canada')
{
        $userdata->set('usergroupid', 18);
}
if ($user['field5'] == 'Saudi Arabia')
{
        $userdata->set('usergroupid', 15);
}
if ($user['field5'] == 'United Arab Emirates')
{
        $userdata->set('usergroupid', 16);
}
if ($user['field5'] == 'United Kingdom')
{
        $userdata->set('usergroupid', 17);
}
if ($user['field5'] == 'United States')
{
        $userdata->set('usergroupid', 10);
}
if ($user['field5'] == 'Other')
{
        $userdata->set('usergroupid', 19);
}

checked usergroupid matching
checked field matching
checked case sensitivity
is there anything else to check?!

note:
my field type is single selection menu, should i change it into radio buttons?

note:
here how the code is appearing in the plugins manager section:

// Get the value for field 5
        $user = $db->query_first("
            SELECT field5
            FROM " . TABLE_PREFIX . "userfield
            WHERE userid = " . $vbulletin->userinfo['userid'] . "
        ");


if ($user['field5'] == 'Egypt')
{
    $userdata->set('usergroupid', 14);
}
if ($user['field5'] == 'Canada')
{
        $userdata->set('usergroupid', 18);
}
if ($user['field5'] == 'Saudi Arabia')
{
        $userdata->set('usergroupid', 15);
}
if ($user['field5'] == 'United Arab Emirates')
{
        $userdata->set('usergroupid', 16);
}
if ($user['field5'] == 'United Kingdom')
{
        $userdata->set('usergroupid', 17);
}
if ($user['field5'] == 'United States')
{
        $userdata->set('usergroupid', 10);
}
if ($user['field5'] == 'Other')
{
        $userdata->set('usergroupid', 19);
}

[DeMagH]

bumping thread

[amnesia623]

does this work in 3.6.4?

[amykhar]

Yes. It's still running unchanged on my site.

[wes_517]

This is VERY close to exactly what my members are asking for, but I would need one small change...

Most of my site is closed off to non-members, and so to make sure who I am adding, I have to moderate all new users for privacy reasons...

So instead of adding new users directly to the group, what would I need to change to add them into the moderation queue instead?

I'm decent with PHP and Mysql, but still learning ins and outs of vbulletin...

any help?
--edit 1--
Thinking about this more, is that POSSIBLE for a primary group? (if the user logs in while their primary group is still under review, wouldn't they then not belong to ANY group and be denied access?)

--edit 2--

I hacked some code out, it may not be pretty, but it's working...

https://vborg.vbsupport.ru/showthrea...31#post1129131

since it modifies the secondary user, i posted it over there... anyone have an idea on the edit 1 question? can that be done or would it throw a fit because they wouldn't have a group yet?

[salata]

i am having diffulculty getting this to work for me, i am using 3.5.4

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugins>
	<plugin active="1" product="vbulletin">
		<title>Put User In User Group Based on Field Value</title>
		
<hookname>register_activate_process</hookname>
		<phpcode><![CDATA[// Get the value for field 25
        $user = $db->query_first("
			SELECT field25
			FROM " . TABLE_PREFIX . "userfield
			WHERE userid = " . $vbulletin->userinfo['userid'] . "
		");


		if ($user['field25'] == 'No')
		{
			$userdata->set('usergroupid', 36);
		}]]></phpcode>
	</plugin>
</plugins>

[yingzhou]

can this mod work on vb 3.6.x? Im using 3.6.4 now.

[DeMagH]

Originally Posted by yingzhou

can this mod work on vb 3.6.x? Im using 3.6.4 now.

yeah worked for me in 3.6.2

[Mum]

I installed this, but when i registered a new user to test it, it hasn't added it to the group at all. This is my very first plug in, so may be something i've done wrong. PLease help

// Get the value for field 5
$user = $db->query_first("
SELECT field5
FROM " . TABLE_PREFIX . "userfield
WHERE userid = " . $vbulletin->userinfo['userid'] . "
");


if ($user['field5'] == 'Female')
{
$userdata->set('usergroupid', 11);

if ($user['field5'] == 'Male')
{
$userdata->set('usergroupid', 13);
}