PhotoPost Community - View Single Post - 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/

January 31st, 2007, 10:42 AM	#1 (permalink)
ryand789 Junior Member Verified Customer Join Date: Sep 2003 Location: Boise Posts: 20	How Do I Mass Delete A Specific User's Ratings? 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/