<?php

/**
 * @file
 * Comment Counter
 */

/**
 * Implements hook_install().
 */
function comment_counter_install() {
  $t = get_t();
  $transaction = db_transaction();

  try {
    $query = "
      ALTER TABLE {node_comment_statistics}
      ADD COLUMN `comment_day_count`   MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The total number of comments on this node today.'      AFTER `comment_count`,
      ADD COLUMN `comment_week_count`  MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The total number of comments on this node this week.'  AFTER `comment_day_count`,
      ADD COLUMN `comment_month_count` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The total number of comments on this node this month.' AFTER `comment_week_count`,
      ADD COLUMN `comment_year_count`  BIGINT(20)   UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The total number of comments on this node this year.'  AFTER `comment_month_count`
    ";

    db_query($query);

    // Ignore slave server temporarily to give time for the
    // saved block to be propagated to the slave.
    db_ignore_slave();
  }
  catch (Exception $e) {
    $transaction->rollback();
    watchdog_exception('php', $e);
    drupal_set_message($t('Cannot create new fields'), 'error');
  }
}

/**
 * Implements hook_uninstall().
 */
function comment_counter_uninstall() {
  $t = get_t();
  $transaction = db_transaction();

  try {
    $query = "
      ALTER TABLE {node_comment_statistics}
      DROP COLUMN `comment_day_count`,
      DROP COLUMN `comment_week_count`,
      DROP COLUMN `comment_month_count`,
      DROP COLUMN `comment_year_count`
    ";

    db_query($query);

    variable_del('comment_counter_timestamp');
    variable_del('comment_counter_count_comments');

    // Ignore slave server temporarily to give time for the
    // saved block to be propagated to the slave.
    db_ignore_slave();
  }
  catch (Exception $e) {
    $transaction->rollback();
    watchdog_exception('php', $e);
    drupal_set_message($t('Cannot drop fields'), 'error');
  }
}