I use a wordpress plugin called "GD Star Rating" to allow my users to vote on stories that I post to one of my sites. http://everydayfiction.com/ We recently had a lot of system abuse. Stories that were obviously artificially voted. "GD Star Rating" creates some detailed logs when a user votes for a story. Including; IP, voting time and user_adgent, ect ..
For example, this story has 181 votes with an average of 5.7 http://www.everydayfiction.com/snowman-by-shaun-simon/ Most other stories have only about 40 votes each day.
At first, I thought that the story got to the Digg social bookmarking site, Stumbleupon ect ... but after checking the magazines, I found that this story receives the same amount of traffic as a normal ~ 2k story.
I checked if everyone voted for this perpendicular story coming from the same IP address. I could see this happening if the user was in the school computer lab, using all his lab computers to vote on this story. Not one duplicate log IP address for this story.
SELECT ip, COUNT (*) as count FROM wp_gdsr_votes_logWHERE id= 3932 GROUP BY ( ip) ORDER BY countDESC
Further, I thought that use could use proxies to vote for a story. I checked this by grouping the entire user_agent browser together to see if there is one vote per browser perpendicularly. No more than 7 users who use a similar browser, but voted sporadically (1-5), no evidence of incorrect behavior.
SELECT user_agent, COUNT (*) as count FROM wp_gdsr_votes_logWHERE id= 3932 GROUP BY ( user_agent) ORDER BY countDESC
, . , - , user_adgent -, ect... 5 2 . , - , (IE 5 )
SELECT * FROM wp_gdsr_votes_log WHERE id= 3932 = 5 ORDER BY wp_gdsr_votes_log. voted DESC
- , . , .
, .
Edit
, , , , , perdicutre, IP-. , 80 IP- . , , 80% , , . , , - , , .
SELECT id, `ip`, COUNT(*) as count FROM `wp_gdsr_votes_log` GROUP BY (`ip` ) ORDER BY `count` ASC
2
, , http://www.mychemicalromance.com/ (-) twitter - . , , .