vb.org Archive - Execute SQL Query- What is the code to select multiple usergroups/users? [SOLVED]

Quote:

Originally Posted by Dave (Post 2555249)

PHP Code:


		
			
AND usergroupid IN(1,2,3,4,etc)

Is that what you mean?

Yes that was precisely what I was looking for.
Thank you :)

------------------------------------------------------------------------------------------------------------------------------------------------------

A quick summary/guide for anybody reading:

What I'm about to show you below, allows you to change 'Display Reputation' forcefully for any usergroup(s) or user(s) using Execute SQL Query.
If they have been given permission to Hide Reputation from Others, then they can change Hide/Show reputation from the UserCP later. This just hides/shows reputation from the postbit.

Show Reputation for a single usergroup:
On:

Code:

UPDATE user SET options=options + 1024 WHERE NOT(options & 1024) AND usergroupid = X;

Off:

Code:

UPDATE user SET options=options - 1024 WHERE options & 1024 AND usergroupid = X;

Show Reputation for multiple usergroups:
On:

Code:

UPDATE user SET options=options + 1024 WHERE NOT(options & 1024) AND usergroupid IN(X,X,X);

Off:

Code:

UPDATE user SET options=options - 1024 WHERE options & 1024 AND usergroupid IN(X,X,X);

Edit: Even if you don't insert multiple usergroupid/userid, it still works with a single one.

Where X = UsergroupID (can be seen from usergroup manger).

If you just want it for multiple users instead of multiple usergroups, then change:

Code:

usergroupid

to:

Code:

userid

To find userid number, just click on somebody's profile and view the web address. You'll see a ?X-USERNAME
X= userid number.
------------------------------------------------------------------------------------------------------------------------------------------------------
Note:
This is an issue within vbulletin postbit_legacy coding:
If a usergroup doesn't have permission to show/hide reputation from their UserCP, even if you set it as no (manually), their reputation will still display (green bars).
If you want to fix this, look at my guide here:
Step A (adds one more condition) which makes it disappear completely (if Display Reputation is set to No by the admin) even if they don't have permission to edit from the UserCP.
You don't have to check out the rest of the thread. You only need to do Step A.

Note 2:
http://www.vbulletin.com/forum/forum...tions-en-masse
If you want to change other UserCP settings, look at that thread.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01701 seconds Memory Usage 1,729KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (2)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: