function _simplenews_statistics_click_add in Simplenews Statistics 6.3

Register click.

1 call to _simplenews_statistics_click_add()

simplenews_statistics_click in ./simplenews_statistics.module

Gathers the clicks.

File

./simplenews_statistics.module, line 292

Main simplenews statistics file.

Code

function _simplenews_statistics_click_add($stat) {

  // Check if this is a unique click for the newsletter-mail combination.
  $query = 'SELECT nid FROM {simplenews_statistics_clicks} WHERE email=\'%s\' AND nid=%d LIMIT 1';
  $result = db_query($query, $stat['mail'], $stat['nid']);
  $row = db_fetch_array($result);
  if (empty($row)) {
    db_query('UPDATE {simplenews_statistics} SET user_unique_click_through=user_unique_click_through+1 WHERE nid=%d', $stat['nid']);
  }

  // Update the total click amount.
  db_query('UPDATE {simplenews_statistics} SET total_clicks=total_clicks+1 WHERE nid=%d', $stat['nid']);

  // Register the indivudual click.
  db_query('INSERT INTO {simplenews_statistics_clicks} (email, nid, url, timestamp) VALUES (\'%s\', %d, \'%s\', %d)', $stat['mail'], $stat['nid'], urldecode($stat['url']), time());
}