How Do I Mass Delete A Specific User's Ratings?

ryand789 · January 31st, 2007, 10:42 AM

We have a problem with a few users with multiple usernames going around and rating THOUSANDS of people a one (multiple times with different usernames), causing a lot of people to be upset about their low ratings.

We obviously ban them when we find them, but they come back each day with a new name and new IP address. It's actually pretty crazy how determined these people are...

Anyways, we would like to delete these thousands of bad ratings by these few specific users quickly. I know if I do it in the database, it will delete them, but it won't recalculate each photos overall rating score (since that is stored in a different table).

Is there any way to do this? I really need help to stop these guys and fix the 5000 - 6000 photos that have been "vandalized" by these jerks and they show no sign of stopping.

Thanks!
Ryan DeLuca

http://forum.bodybuilding.com/photo/

Chuck S · January 31st, 2007, 11:07 AM

Well if you know how to delete the bad ratings go ahead and do that

This little script may help save it as whatever name you want say ratings.php and run it from your photopost directory

Code:

Content visible to verified customers only.

Alien515 · February 13th, 2007, 02:14 AM

Has anyone been successful with this script above?

Chuck S · February 13th, 2007, 09:02 AM

The script above simply refreshes the ratings nothing more.