Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 14 Aug 2015, 15:51
saini1987 saini1987 is offline
 
Join Date: Jul 2010
Mass Enable Reputation on Vbulletin Forums Using Mysql Query

how can i Mass Enable Reputation on Vbulletin Forums Using Mysql Query?
Reputation is enabled in settings and usergroups but not in all forums.
Can someone provide the mysql query to run to enable it for all forums. ?
__________________
Android Crunch
Reply With Quote
  #2  
Old 14 Aug 2015, 17:14
Seven Skins's Avatar
Seven Skins Seven Skins is offline
 
Join Date: Sep 2008
Go to admincp > Maintenance > Execute SQL Query and run query "Display Reputation - ON" from the drop down list.
Reply With Quote
  #3  
Old 14 Aug 2015, 17:53
saini1987 saini1987 is offline
 
Join Date: Jul 2010
That query haven't worked. It's still set to no. I have run the update counter for forum but still set to no. Please check the attachment image where the option I am pointing towards is at last.
Attached Images
File Type: jpg image.jpg (101.8 KB, 15 views)
__________________
Android Crunch
Reply With Quote
  #4  
Old 14 Aug 2015, 19:26
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
I don't believe that is a default option in vBulletin. Looks like it might be an addon.
__________________
Looking for ImpEx?
Reply With Quote
  #5  
Old 15 Aug 2015, 08:28
saini1987 saini1987 is offline
 
Join Date: Jul 2010
I don't have any such add on to disable reputation on forums, it's a default option available in Vbulletin and if set to no, users can't give reputation in that forum. Why do I install an add on to disable reputation and then ask it about here for a fix???

Meanwhile I tried this: http://www.vbulletin.com/forum/forum...for-all-forums but that query haven't worke.
__________________
Android Crunch
Reply With Quote
  #6  
Old 15 Aug 2015, 10:10
Skyrider Skyrider is offline
 
Join Date: Feb 2006
Originally Posted by saini1987 View Post
I don't have any such add on to disable reputation on forums, it's a default option available in Vbulletin and if set to no, users can't give reputation in that forum. Why do I install an add on to disable reputation and then ask it about here for a fix???

Meanwhile I tried this: http://www.vbulletin.com/forum/forum...for-all-forums but that query haven't worke.
Try:

UPDATE forum SET options = options + 2097152 WHERE NOT(options & 2097152);
But make a backup of the database first before running the query.

Just so you know, the above query is 'not' the same as the one you linked to:
http://www.vbulletin.com/forum/forum...for-all-forums

It's slightly different.
Reply With Quote
  #7  
Old 16 Aug 2015, 11:11
saini1987 saini1987 is offline
 
Join Date: Jul 2010
Thanks skyrider that worked
__________________
Android Crunch
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 08:59.

Layout Options | Width: Wide Color: