[akz645]

Originally Posted by akz645

How do I execute a SQL Query to force All Users/ Certain Usergroups/ Certain Users to have their X user profile field options changed into what I want?
They can change into what they want from the userCP later.

Glenn Vergara posted how to do it, from vbulletin.com

1)

UPDATE userfield SET field5='Hide' where userid in (SELECT userid FROM user WHERE usergroupid IN (X, X, X))

This code allows you to change a usergroups' custom user profile field (any option they have), to whatever specific option you want them all to have changed to.
Key:
Red = User Profile Field ID.
Green = User Profile Field Option you want to change to.
Blue = Usergroup ID.

2)

UPDATE userfield SET field5='Hide' where field5='Male' AND userid in (SELECT userid FROM user WHERE usergroupid IN (X, X, X))

This code allows you to change a usergroups' custom user profile field (any single option), to whatever other specific option you want them all to have it changed to.
Key:
Red = User Profile Field ID.
Green = User Profile Field Option you want to change to.
Orange = Option you want changed.
Blue = Usergroup ID.

3)

UPDATE userfield SET field5='Hide' where (field5='Male' OR field5='Female') AND userid in (SELECT userid FROM user WHERE usergroupid IN (X, X, X))

This code allows you to change a usergroups' custom user profile field (multiple options), to whatever specific option you want them all to have it changed to. If they have selected an option you don't include (example: Other), then users who have selected that option will be left unaffected.
Key:
Red = User Profile Field ID.
Green = User Profile Field Option you want to change to.
Orange = Option you want changed.
Blue = Usergroup ID.

Note: Change usergroupid to userid to change for several users, instead of entire usergroups.
Note 2: You don't have to select more than 1 usergroup. Just selecting 1 usergroup still works.

P.S= If you want to know how to change 'Display Reputation', 'Invisible' etc, check out my guide here:
https://vborg.vbsupport.ru/showthrea...58#post2555258

--------------- Added [DATE]1443391500[/DATE] at [TIME]1443391500[/TIME] ---------------

Originally Posted by akz645

Do you know any way to set it so only certain usergroups will have X User Profile Field option appear in their userCP?

That's the only question still left unanswered.

If anybody can help out, that would be great