vb.org Archive - Removing thread ratings?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Removing thread ratings? (https://vborg.vbsupport.ru/showthread.php?t=317204)

darnoldy

02-07-2015 06:51 PM

Removing thread ratings?

Folks-

Okay, so I ask weird questions...

I don't want to remove the feature, I want to remove all the thread ratings that have been given.

I have been testing some stuff, and given ratings to threads during the test. I want to go back to zero before I go live.

--don

ozzy47

02-07-2015 07:05 PM

Take a backup first! This is untested.

Run this first:

Code:

SELECT  user.username,  user.userid,  thread.title,  threadrate.vote FROM threadrate LEFT JOIN  user ON  user.userid = threadrate.userid LEFT JOIN  thread ON  thread.threadid = threadrate.threadid ORDER BY  thread.title

Then if you see what you expected, run this:

Code:

DELETE FROM threadrate WHERE userid = X

Change X to the userid of the offender.

You'll need to update your thread & forum information counters afterwards.

darnoldy

02-07-2015 07:21 PM

Thanks, Ozzy! I'll give it a try a little later (I have some more screwing around to do first).

--don

ozzy47

02-07-2015 07:27 PM

Not a problem, hopefully it works. :)

All times are GMT. The time now is 03:54 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01098 seconds Memory Usage 1,710KB 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_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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
Messages: