vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Mass Enable Reputation on Vbulletin Forums Using Mysql Query (https://vborg.vbsupport.ru/showthread.php?t=319872)

saini1987 08-14-2015 01:51 PM

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

Seven Skins 08-14-2015 03:14 PM

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

saini1987 08-14-2015 03:53 PM

1 Attachment(s)
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 08-14-2015 05:26 PM

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

saini1987 08-15-2015 06:28 AM

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.

Skyrider 08-15-2015 08:10 AM

Quote:

Originally Posted by saini1987 (Post 2552925)
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:

Quote:

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.

saini1987 08-16-2015 09:11 AM

Thanks skyrider that worked :)


All times are GMT. The time now is 06:43 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01070 seconds
  • Memory Usage 1,724KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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