End-User Options - PB Usergroup Choice on registration

What does it do?
Allows a user to be assigned to a certain usergroup based on a drop down menu at registration time.

How is it different from the one posted a couple of days ago by Viet:
Well,
1. This one will work with email verification. So you can still require email verification for all new users and they will be assigned to the appropriate usergroup after their email has been verified.
2. It will automatically draw in the usergroup names for the ids instead of having you type out both the usergroup ID's and usergroup names.

Installation:
1. Import the product
2. Go to AdminCP->vbulletin Options->Vbulletin Options->PB Usergroup Choice on Register
and set up the options the way you want...

Notes:
Will add 1 query when showing the registration form.
Will add 1 more query to the processing of a registration if VB is set up for every user having to verify email addresses.

Fixed:
Forgot table prefix in one call to the database causing database error.

[MrNase]

Does it put the user into the primary or secondary usergroup?

[RLShare]

It sets their primary usergroup.

[PlymWS]

Could this be coded so that instead of manually entering the usergroupids in the ACP the script could look in the database for publically joinable groups and then output them in the list ?

I've been messing around with SELECT usergroupid FROM usergroup WHERE ispublicgroup = 1 but I can't get the SQL to output the correct array

[GHC Webmaster]

This would be useful for me, if it would also be a profile field. In other words if the name off the chosen group shows (along with the field title) up in the user profile and everywhere where user profile fields can be used (memberlist, mods which add profile fields to postbit etc). I also would have to be editable through Edit Your Details, and on edit it should also change the usergroup.

Basically it would have to act like a custom single selection list profile field, which just happens to be connected to usergroups.

(I want to use it for a country field, which should also put members into a usergroup for that country.)

Btw, it also would be more usefull if it would set the usergroup as a secondary group, and leave the primary group as it is (Registered Users or otherwise).

As it is now, I unfortunately cannot use it.

[ShadowOne]

i really like this...
i.e...you can do male or female...
change the text color of each and you will have a diff color for male and female...
so when they register... they can choose male or female...

[wmlvb]

What if two of my usergroups require certain moderation procedures before they are put in that user group? Can the register and fill in information I need to get approval and while they are waiting be regular registered user group. I do not want the regular registered usergroup to have to go through this moderation! Thanks for the help.

[justchil]

Any suggestion for those of us who have email verification and moderation on new accounts?

[oz_girl]

I love this idea but one of usergroups is a subscription only. Is there anyway to have members who chose the subscription group to be redirected to the subscription information after they fill out the registration? i'd also pay to have this done.

[Tharos]

excelent
I will use it for woman and mesn

[d-wiz]

I would like it if the usergroups each had there registration and information options so that I can custom it for customers and companys so that I get different information from them and the other group don't have to see the questions.