<?php
// $Id: false_account.install,v 1.3.2.2 2009/01/07 14:11:08 nunoveloso18 Exp $

/**
 * Implementation of hook_install()
 * just give a message
 */
function false_account_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $created = db_query("
        CREATE TABLE IF NOT EXISTS {false_accounts} (
        cid varchar(64) NOT NULL,
        uid int(10) NOT NULL,
        created int(11) unsigned NOT NULL default '0',
        status tinyint(3) unsigned NOT NULL default '0',
        PRIMARY KEY (cid, uid)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
  }

  if ($created) {
    drupal_set_message(t('False Account module installed successfully.'));
  }
  else {
    drupal_set_message(t('Table installation for the False Accounts module was unsuccessful.'), 'error');
  }
}


/**
 * Implementation of hook_uninstall()
 */
function false_account_uninstall() {
  $drop = db_query("DROP TABLE {false_accounts}");
}


/**
 * Implementation of hook_update_N()
 * new DB structure
 */
function false_account_update_1() {

  $return = array();
  $done = array();

  // replicate table
  $result = db_query('
    CREATE TABLE IF NOT EXISTS {false_accounts_old}
    LIKE {false_accounts}'
  );
  $done[] = $result;
  
  $result = db_query('
    INSERT {false_accounts_old}
    SELECT * 
    FROM {false_accounts}'
  );
  $done[] = $result;
  
  // avoid data destruction if copy actions haven't succeed
  if (! in_array(false, $done)) {
    $done = array();

    $result = db_query('DROP TABLE {false_accounts}');
    $done[] = $result;
    
    $created = db_query("
      CREATE TABLE IF NOT EXISTS {false_accounts} (
      cid varchar(64) NOT NULL,
      uid int(10) NOT NULL,
      created int(11) unsigned NOT NULL default '0',
      status tinyint(3) unsigned NOT NULL default '0',
      PRIMARY KEY (cid, uid)
    ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
		$done[] = $result;
    
    $result = db_query('
      SELECT *
      FROM {false_accounts_old}'
    );
    
    // handle old data to fit into new table and instert
    while ($row = db_fetch_object($result)) {
			if ($row->cid != '' && $row->uids != '' && $row->status >= 0) {
				$uids = explode(',', $row->uids);
				
				for ($i = 0 ; $i < sizeof($uids) ; $i++) {
					$res = db_query('
						INSERT INTO {false_accounts} (cid, uid, created, status)
						VALUES ("%s", %d, %d, %d)',
						$row->cid, $uids[$i], $row->updated, $row->status
					);
					$done[] = $res;
				}
			}
    }
    if (! in_array(false, $done)) {
      drupal_set_message(t('False Account module upgraded successfully.'));
    }
    else {
      drupal_set_message(t('Table upgrade for the False Accounts module was unsuccessful.'), 
        'error');
    }
  }
  else {
    drupal_set_message(t('Table upgrade for the False Accounts module was unsuccessful.'), 'error');
  }

	return $return;  
}


function false_account_update_2() {

  $return = array();
  $done = array();
  
  $result = db_query('
    SELECT cid, created
    FROM {false_accounts}
    GROUP BY cid 
    ORDER BY created DESC'
  );
  
  while ($cookie = db_fetch_object($result)) {
    $done[] = db_query('
      UPDATE {false_accounts} 
      SET created = %d
      WHERE cid = "%s"',
      $cookie->created, $cookie->cid
    );
  }

  if (! in_array(false, $done)) {
    drupal_set_message(t('False Account module upgraded successfully.'));
  }
  else {
    drupal_set_message(t('Table upgrade for the False Accounts module was unsuccessful.'), 
      'error');
  }
  return $return;
}