$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;
?>
And 3 of the 'workers' are just leaning!
Same sketch everywhere, or so it seems. Take Whitelegg Way in Bournemouth. Wide cycle lanes put in both sides of a (formerly very wide) two lane...
Sounds cool. I haven't taken an "unnecessary flight" since 1992. Flown many times since then for work, but you can't patrol the Iraqi desert, or...
My first thought on reading the headline was "ooh, has Clevedon put in covered bike parking now?".
I rented a car a few weeks ago, a Skoda Octavia (needed a big car for a weekend), and the ride was astonishingly good compared to my own 10 year...
Silly.
Shimano for me please ! 👋👋
Shimano were castigated for not bringing on new factories to meet pandemic demand, thus gumming up the supply chain. Their argument at the time was...
I figured out a reason of that squeaking noise. I have xpresso 2 and 7, and also xpro 10 pedals, and that squeaking isn't present only at Xpresso 2...
Italian tourist and pussycat in Portugal.