<?php

// $Id: roundcube.install,v 1.1.2.1 2008/11/10 21:46:56 ximo Exp $


/**
 * @file
 * Installer script for the RoundCube – a Drupal module that
 * integrates RoundCube Webmail 0.2 with Drupal.
 */


/******************************************************************************
 * MYSQL
 ******************************************************************************/

/**
 * Install.
 */
function roundcube_install_mysql() {

  _roundcube_install_db_query(<<<SQL
CREATE TABLE {roundcube_passwords} (
  uid int(10) unsigned NOT NULL,
  password blob,
  PRIMARY KEY (uid)
) /*!40100 DEFAULT CHARACTER SET utf8 */;
SQL
  );

  _roundcube_install_db_query(<<<SQL
CREATE TABLE {roundcube_credentials} (
  id char(32) NOT NULL,
  uid int(10) unsigned NOT NULL,
  expires int(10) unsigned NOT NULL,
  PRIMARY KEY (id)
) /*!40100 DEFAULT CHARACTER SET utf8 */;
SQL
  );

}

/**
 * Uninstall.
 */
function roundcube_uninstall_mysql() {
  _roundcube_install_db_query('DROP TABLE {roundcube_passwords}');
  _roundcube_install_db_query('DROP TABLE {roundcube_credentials}');
}

/******************************************************************************
 * HOOKS
 ******************************************************************************/

/**
 * Implements hook_install().
 */
function roundcube_install() {
  _roundcube_install_dispatcher(__FUNCTION__);
}

/**
 * Implements hook_uninstall().
 */
function roundcube_uninstall() {
  _roundcube_install_dispatcher(__FUNCTION__);
}


/******************************************************************************
 * HELPERS
 ******************************************************************************/

/**
 * Dispatch the call for $hook to the database specific implementation of it.
 */
function _roundcube_install_dispatcher($hook) {
  global $db_type;
  $db = $db_type === 'mysqli' ? 'mysql' : $db_type;
  $op = substr($hook, strpos($hook, '_') + 1);
  $function = _roundcube_install_module_name() .'_'. $op .'_'. $db;
  if (function_exists($function)) {
    return $function();
  }
  else {
    $msg = t('!hook() doesn\'t support !db', array('!hook' => $hook, '!db' => $db));
    drupal_set_message($msg, 'error');
  }
}

/**
 * Execute a database query. Based on db_query() and update_sql().
 */
function _roundcube_install_db_query($query) {

  // Get the arguments.
  $args = func_get_args();
  array_shift($args);
  if (isset($args[0]) and is_array($args[0])) {
    $args = $args[0];
  }

  // Build the query.
  $query = db_prefix_tables($query);
  _db_query_callback($args, true);
  $query = preg_replace_callback(DB_QUERY_REGEXP, '_db_query_callback', $query);

  // Do the database query, and return the status.
  $result = _db_query($query);
  return array('success' => $result !== false, 'query' => check_plain($query));  

}

/**
 * Returns the name of this module.
 */
function _roundcube_install_module_name() {
  return substr(__FUNCTION__, 1, strpos(__FUNCTION__, '_', 1) - 1);
}