[Tutorial]How to remove thread ratings

[Matt]

Quite a few people have asked how to remove thread ratings from all the forums without having to go through each one and remove the option. Here's how to do it:

In PHPMyAdmin, run this query:

UPDATE `mybb_forums` SET `allowtratings` = '0' WHERE `allowtratings` = '1'

Make sure your table prefix, mybb_ here, is correct. This will turn off the rating for all your current forums. Now, if you look in the settings for each forum, the option to allow threads to be rated will be unticked... but, the thread ratings column still shows in forums.



To fix that, go to 'ACP > Tools & Maintenance > Cache Manager' find forums and click Rebuild Cache.

Then when you make new forums, just untick the option. Also should you ever want to add them back in, edit the query; change the 0 to a 1 and the 1 to a 0, run that, and rebuild the cache again. Note that current thread ratings will not be lost if you hide the columns as the ratings are stored in a separate table, and will show again once you turn on ratings again.

[seeker]

Thanks Matt,

Really helpful for anyone with a lot of sub-forums...
This could be easily modified to quickly update almost any setting (any setting which is yes or no, 0 or 1)

[Claire]

Could also make theming easier.

[alv4]

Thanks for this

[ghazal]

Excellentaaaa You are really SQL guru

[Streder]

Oh you dear good wonderful human being

THANK YOU!

Steven

[byixps]

If you want, do a tutorial on how to manually remove the SKIN.

[Matt]

What??

[byixps]

I post how to remove the skin, moving it in the templates, without being in the tables of phpmyadmin.

[Matt]

Better to do it this way because you're mass changing settings, not edited templates, if you edit templates and then want to use ratings again you have to revert the templates.