5 star rating problem - vb.org Archive

		vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
5 star rating problem

Reply

#1

Old

08-09-2008, 04:54 AM

wickland

wickland is offline

Join Date: Jul 2007

Posts: 121

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

5 star rating problem

There is some spammer or bot going through my forum and putting 5 star ratings on every thread. Is there some way to erase all the ratings or the ones that the spammers inflated?

Thanks

Reply With Quote

#2

Old

08-09-2008, 06:24 AM

Dismounted Dismounted is offline

Dismounted is offline

Join Date: Jun 2005

Location: Melbourne, Australia

Posts: 15,047

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

[sql]UPDATE thread
SET
votenum = 0,
votetotal = 0[/sql]
That query will erase ALL ratings.

Reply With Quote

#3

Old

08-09-2008, 06:08 PM

wickland

wickland is offline

Join Date: Jul 2007

Posts: 121

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

Thanks for the help! That seems to have done the trick

Thanks
Best

Reply With Quote

Reply

« Previous Thread | Next Thread »

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 Forum Rules

Forum Jump

All times are GMT. The time now is 10:24 PM.