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

[Christine]

Brinnie,

Unless you paid for copyright removal, at the least, the copyright needs to read:

vBulletin, Copyright ?2000 - 2005, Jelsoft Enterprises Ltd.

You don't have to keep version information, but the rest is required by Jelsoft.

[Brinnie]

Originally Posted by Christine

Brinnie,

Unless you paid for copyright removal, at the least, the copyright needs to read:

vBulletin, Copyright ?2000 - 2005, Jelsoft Enterprises Ltd.

You don't have to keep version information, but the rest is required by Jelsoft.

oh well, that's jelsofts problem.
I'm buying the full version next week, so...

anyone have sucess with this on Beta 4?

[Marco van Herwaarden]

Originally Posted by Brinnie

oh well, that's jelsofts problem.
I'm buying the full version next week, so...

anyone have sucess with this on Beta 4?

Wrong this is your problem. You must follow your license agreement.

[Brinnie]

Originally Posted by MarcoH64

Wrong this is your problem. You must follow your license agreement.

of course...

[amykhar]

Originally Posted by Brinnie

oh well, that's jelsofts problem.
I'm buying the full version next week, so...

anyone have sucess with this on Beta 4?

It's running fine for me on Beta 4.

[akanevsky]

I don't think you need the select query. I mean, the custom fields get passed on by the POST method. They should already be somewhere in the script. Get the values from there.

[amykhar]

You would think so, wouldn't you. But, if you look at the code, you'll see that what's passed in to the activation routine are two things: The username and the activation id.

Using the username, the code gets the userinfo BUT not all of it. It only gets what's in the user table. It doesn't get the profile fields. And, it never does a call to fetch_userinfo(). (Which would result in a query as well.)

If I weren't doing this as a plugin, I would have changed the query to do a left join and get the profile field stuff. But, I'm doing this as a plugin and can't change the query. Hence, the second query.

Amy

[akanevsky]

Ah... Sorry, I did not notice that you were hooking it into the activation section. I thought you added the group right upon registration... :P

[amykhar]

Nope. I don't want unactivated users in secondary user groups.

I figured it was safer this way for all concerned because not everybody understands how secondary usergroup permissions work. They could end up with some nasty surprises by putting somebody in a secondary usergroup that has priv to post, view attachments, or whatever.

Yes, the answer is to severely limit secondary groups, but not everybody knows to do that.

Amy

[justindwhite]

I am getting a Parse error when the user tries to activate their account. Here is the plugin I used. Is everything OK? Anyone know the problem?

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

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


					if ($user['field9'] == 'OnLineRegulator')
		{
			$userdata->set('usergroupid', 11);
			
					if ($user['field9'] == 'OLR')
		{
			$userdata->set('usergroupid', 10);
			
					if ($user['field9'] == 'OLR ANZACs')
		{
			$userdata->set('usergroupid', 19);
			
					if ($user['field9'] == 'OLR Canada')
		{
			$userdata->set('usergroupid', 20);
			
					if ($user['field9'] == 'OLR Divas')
		{
			$userdata->set('usergroupid', 12);
			
					if ($user['field9'] == 'OLR Elite')
		{
			$userdata->set('usergroupid', 13);
			
					if ($user['field9'] == 'OLR GreatBritain')
		{
			$userdata->set('usergroupid', 25);
			
					if ($user['field9'] == 'OLR Holland')
		{
			$userdata->set('usergroupid', 22);
			
					if ($user['field9'] == 'OLR Spartan')
		{
			$userdata->set('usergroupid', 9);
						
					if ($user['field9'] == 'OLR United States')
		{
			$userdata->set('usergroupid', 24);
						
					if ($user['field9'] == 'OLR Coalition')
		{
			$userdata->set('usergroupid', 39);
						
					if ($user['field9'] == 'OLR Honorary Member')
		{
			$userdata->set('usergroupid', 38);
						
					if ($user['field9'] == 'Not A Member')
		{
			$userdata->set('usergroupid', 16);
			
		}]]></phpcode>
	</plugin>
</plugins>