function simplenews_statistics_update_6301 in Simplenews Statistics 6.3

Upgrade to 3.x continued.

File

./simplenews_statistics.install, line 194

Simplenews statistics (un)install and updates file.

Code

function simplenews_statistics_update_6301() {

  // Count the total clicks for each newsletter and update the column.
  $query = 'SELECT nid FROM {simplenews_statistics}';
  $result = db_query($query);
  while ($newsletter = db_fetch_array($result)) {
    $query = 'SELECT COUNT(nid) AS total FROM {simplenews_statistics_clicks} WHERE nid=%d';
    $result_clicks = db_query($query, $newsletter['nid']);
    if ($count = db_fetch_array($result_clicks)) {
      $query = 'UPDATE {simplenews_statistics} SET clicks=%d WHERE nid=%d';
      db_query($query, $count['total'], $newsletter['nid']);
    }
  }

  // Count and sum the total opens for each newsletter and update the column.
  $query = 'SELECT nid FROM {simplenews_statistics}';
  $result = db_query($query);
  while ($newsletter = db_fetch_array($result)) {
    $query = 'SELECT SUM(opens) AS total FROM {simplenews_statistics_opens} WHERE nid=%d';
    $result_clicks = db_query($query, $newsletter['nid']);
    if ($count = db_fetch_array($result_clicks)) {
      $query = 'UPDATE {simplenews_statistics} SET opens=%d WHERE nid=%d';
      db_query($query, $count['total'], $newsletter['nid']);
    }
  }
  return array();
}