function click_filter_update_1 in Advertisement 5.2

Same name and namespace in other branches

1. 5 statistics/click_filter/click_filter.install \click_filter_update_1()

Filter clicks from search engine bots.

File

statistics/click_filter/click_filter.install, line 63

Code

function click_filter_update_1() {
  $ret = array();
  $result = db_query("SELECT cid FROM {ad_clicks} WHERE user_agent LIKE '%%bot%%'");
  while ($click = db_fetch_object($result)) {
    $ret[] = update_sql('UPDATE {ad_clicks} SET status = ' . CLICK_BOT . " WHERE cid = {$click->cid}");
  }
  return $ret;
}