Mass Enable Reputation on Vbulletin Forums Using Mysql Query

[saini1987]

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. ?

[Seven Skins]

Go to admincp > Maintenance > Execute SQL Query and run query "Display Reputation - ON" from the drop down list.

[saini1987]

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.

[Zachery]

I don't believe that is a default option in vBulletin. Looks like it might be an addon.

[saini1987]

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: www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/415447-enable-reputation-for-all-forums but that query haven't worke.

[Skyrider]

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: www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/415447-enable-reputation-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/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/415447-enable-reputation-for-all-forums

It's slightly different.

[saini1987]

Thanks skyrider that worked :)