$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;
?>
Drivers have already turned roads into death traps.
The more I think about this, the more I worry about its scope and ramifications....
"If this was directed at a gender, race or religion it would be rightly called out as the hate speech it is. Mums, dads, sons and daughters being...
How many times now has Strava announced that they're finally going to do something about the integrity of the leaderboards, but then actually done...
Charlie State there: "Well, I suppose the arguement is though, that... oh yeah, there isn't really an arguement is there".
50+ years to lose nearly 1.5 kg! https://www.retrobike.co.uk/threads/holdsworth-cronometro-ultralight-now...
Changed to SRAM AXS (Force and Rival) about 5 years ago. When it works it is great but I have had 2 rear mechs, one front mech and a spider power...
I think he's a good example of why the parkcos have become so widespread among landowners operating car parks. I don't much care for the way in...
I think, along with others judging by the comments, that the cycling group have the wrong end of this - in that the travel conditions are similat...
Actually, yes. Hundreds of thousands.