$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;
?>
You are missing a key point of comment; yes, it shouldn't be the cyclists' roles to police the roads, but with almost total indifference from...
If one is prepared to pay £28 for a TPU tube, the butyl comparison should be Continental's Supersonic ~50g or Schwalbe at 70g. Both costing £8 - ...
I'd buy that for a dollar.
Media needs to do their part, but the readr/consumer also needs to do theirs as well:...
You can't do around getting rid of grass verges. They provide much needed parking space.
Kona makes practical, affordable commuter bikes and goes bust. Colnago makes toys for the affluent and it is booming. Just goes to show that the...
To answer your question, yes you can sometimes feel the difference. Built a set of wheels for a friend and he installed them with new lightweight...
Cycling infrastructure does not force drivers to break the law, drivers are the reason they break the law, no one else.
Ah but taking pictures of things to defy the man (avoid a fine) is righteous. Taking pictures of people to grass on them to the cops (perhaps...
As a woman, this works great for me! My chain broke once, and a kind guy stopped with a chain breaker and sorted it all out for me. We stopped at a...