Home
-

$query = "select distinct vote_source from votingapi_vote where content_id in (102192, 105623, 100650, 101209, 100703, 100718, 102957, 100965, 101087, 103363, 101223, 103689, 104168, 104563, 107548, 106815, 107225, 101754, 101923, 102052, 100802, 101223, 102318, 100733, 102027, 103420) and checked = 0 limit 25";
$query_result = db_query($query);
$spamcount = 0;
while ($v = db_fetch_object($query_result)):
$spam = simplexml_load_file('http://www.stopforumspam.com/api?ip='.$v->vote_source);
if ($spam->appears == 'yes'):
?>

$query = "delete from votingapi_vote where vote_source = '$v->vote_source'";
//print $query.'
';
db_query($query);
else:
?>

$query = "update votingapi_vote set checked = 1 where vote_source = '$v->vote_source'";
db_query($query);
endif;
endwhile;
?>

$finalists = array(102192, 105623, 100650, 101209, 100703, 100718, 102957, 100965, 101087, 103363, 101223, 103689, 104168, 104563, 107548, 106815, 107225, 101754, 101923, 102052, 100802, 101223, 102318, 100733, 102027, 103420);
foreach($finalists as $f):
$query = "SELECT
SUBSTRING_INDEX(vote_source, '.', 2) AS vote_source,
COUNT(*) AS c
FROM
votingapi_vote
WHERE
content_id = $f
GROUP BY
SUBSTRING_INDEX(vote_source, '.', 2)

ORDER BY
c DESC";
//$block["content"] = $query;
//break;
$query_result = db_query($query);
$count = 0;
while ($n = db_fetch_object($query_result)):
if ($n->c > 12):
$norm = "delete from votingapi_vote where vote_source like '$n->vote_source%' and content_id = $f limit ".($n->c - 12);
//print $norm.'
';
db_query($norm);
endif;
$count += ($n->c > 12) ? 12 : $n->c;
endwhile;
$count -= $spamcount;
$nd = node_load($f);
?>

endforeach;

?>

Dave is a founding father of road.cc and responsible for kicking the server when it breaks. In a previous life he was a graphic designer but he's also a three-time Mountain Bike Bog Snorkelling world champion, and remains unbeaten through the bog. Dave rides all sorts of bikes but tends to prefer metal ones. He's getting old is why.