Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 18 Sep 2015, 20:19
akz645 akz645 is offline
 
Join Date: Jul 2015
Thumbs up Execute SQL Query- What is the code to select multiple usergroups/users? [SOLVED]

http://www.vbulletin.com/forum/forum...tions-en-masse

Show Reputation
On: UPDATE user SET options=options + 1024 WHERE NOT(options & 1024) AND usergroupid = X;
Off: UPDATE user SET options=options - 1024 WHERE options & 1024 AND usergroupid = X;

What is the coding so I can select multiple UsergroupIDs/UserIDs?



Last edited by akz645; 27 Sep 2015 at 22:39.
Reply With Quote
  #2  
Old 18 Sep 2015, 20:44
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Is that what you mean?
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 19 Sep 2015, 00:51
akz645 akz645 is offline
 
Join Date: Jul 2015
Originally Posted by Dave View Post
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Off:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Show Reputation for multiple usergroups:
On:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Off:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.

Last edited by akz645; 19 Sep 2015 at 02:14.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 17:49.

Layout Options | Width: Wide Color: