function simplenews_statistics_view in Simplenews Statistics 6.2

Same name and namespace in other branches

1. 6.3 simplenews_statistics.module \simplenews_statistics_view()
2. 6 simplenews_statistics.module \simplenews_statistics_view()

simplenews_statistics_view.

Gathers the opens

1 string reference to 'simplenews_statistics_view'

simplenews_statistics_menu in ./simplenews_statistics.module

Implementation of hook_menu().

File

./simplenews_statistics.module, line 80

Gathers newsletter statistics.

Code

function simplenews_statistics_view() {
  $stat = _simplenews_statistics_decode($_GET);
  if ($stat['mail'] && $stat['nid']) {
    if (!db_fetch_array(db_query("SELECT * FROM {simplenews_statistics_opens} WHERE email = '%s' AND nid = %d", $stat['mail'], $stat['nid']))) {
      db_query("INSERT INTO {simplenews_statistics_opens} (email, nid, opens, timestamp) VALUES ('%s', %d, %d, %d)", $stat['mail'], $stat['nid'], 1, time());
    }
    else {
      db_query("UPDATE {simplenews_statistics_opens} SET opens = opens+1 WHERE email = '%s' AND nid = %d", $stat['mail'], $stat['nid']);
    }
  }
}