civicrm.install

<?php
/*
 +--------------------------------------------------------------------+
 | CiviCRM version 4.4                                                |
 +--------------------------------------------------------------------+
 | Copyright CiviCRM LLC (c) 2004-2013                                |
 +--------------------------------------------------------------------+
 | This file is a part of CiviCRM.                                    |
 |                                                                    |
 | CiviCRM is free software; you can copy, modify, and distribute it  |
 | under the terms of the GNU Affero General Public License           |
 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
 |                                                                    |
 | CiviCRM is distributed in the hope that it will be useful, but     |
 | WITHOUT ANY WARRANTY; without even the implied warranty of         |
 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
 | See the GNU Affero General Public License for more details.        |
 |                                                                    |
 | You should have received a copy of the GNU Affero General Public   |
 | License and the CiviCRM Licensing Exception along                  |
 | with this program; if not, contact CiviCRM LLC                     |
 | at info[AT]civicrm[DOT]org. If you have questions about the        |
 | GNU Affero General Public License or the licensing of CiviCRM,     |
 | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
 +--------------------------------------------------------------------+
*/

/**
 *
 * @package CRM
 * @copyright CiviCRM LLC (c) 2004-2013
 * $Id$
 *
 */

/**
 * Implementation of hook_install()
 *
 * Drupal specific direct database install for civicrm
 */
function civicrm_install() {
  global $base_url;

  try {
    $error = _civicrm_init_setting();
  }
  catch(Exception $e){
    require_once DRUPAL_ROOT . '/includes/errors.inc';
    $variables = _drupal_decode_exception($e);
    $problems['install']['severity'] = REQUIREMENT_ERROR;
    $problems['install']['description'] = $e->getMessage();
    drupal_set_message($e->getMessage(), 'error');
    watchdog_exception('civicrm', $e);
    db_query("UPDATE civicrm SET status = 0 WHERE name = 'civicrm'");
  }

  // step 1: import databases
  $success = _civicrm_import_sql('sql/civicrm.mysql');

  if($success){
    _civicrm_import_sql('sql/civicrm_data.zh_TW.mysql');
    _civicrm_import_sql('sql/civicrm_acl.zh_TW.mysql');
  }

  // step 2: create file directory
  // Oh we can't create civicrm directory here. Leave it for initialize auto create script.
  $dir1 = file_build_uri('civicrm');
  file_prepare_directory($dir1, FILE_CREATE_DIRECTORY);
  $dir2 = file_build_uri('civicrm/templates_c');
  file_prepare_directory($dir2, FILE_CREATE_DIRECTORY);
  $dir3 = file_build_uri('civicrm/upload');
  file_prepare_directory($dir3, FILE_CREATE_DIRECTORY);
  $dir4 = file_build_uri('civicrm/persist');
  file_prepare_directory($dir4, FILE_CREATE_DIRECTORY);
  $dir5 = file_build_uri('civicrm/custom');
  file_prepare_directory($dir5, FILE_CREATE_DIRECTORY);

  drupal_set_message("Successful install CiviCRM");
}

/**
 * Implementation of hook_uninstall( )
 */
function civicrm_uninstall() {
  require_once 'civicrm.module';

  if (!civicrm_initialize()) {
    return;
  }

  require_once 'CRM/Core/Config.php';
  $config = CRM_Core_Config::singleton();

  require_once 'CRM/Core/DAO.php';
  CRM_Core_DAO::dropAllTables();
}

function _civicrm_init_setting(){
  global $crm_root;
  if(empty($crm_root)){
    $crm_root = DRUPAL_ROOT.base_path().drupal_get_path('module', 'civicrm');
    $crm_root = preg_replace('/\/drupal$/', '', $crm_root);
    $include_path = '.'.PATH_SEPARATOR.$crm_root.PATH_SEPARATOR.$crm_root.PATH_SEPARATOR.'packages'.PATH_SEPARATOR.get_include_path();
    set_include_path( $include_path );
  }
  $civicrm_path = drupal_get_path('module', 'civicrm');
  $conf_path = conf_path();
  $setting = $conf_path.'/civicrm.settings.php';
  if(file_exists($setting)){
    // trying to require 
    require_once $setting;
    $dsn = defined(CIVICRM_DSN) ? CIVICRM_DSN : NULL;
    if(empty($dsn)){
      throw new Exception(t('Could not detect database settings from civicrm.settings.php'));
    }
  }
  else{
    if(is_writable($conf_path)){
      $db = Database::getConnection()->getConnectionOptions();
      if ($db['host'] == '127.0.0.1') {
        $db['host'] = 'localhost'; // use mysql socket instead
      }
      $params = array();
      $params['%%baseURL%%'] = base_path();
      $params['%%cms%%'] = 'Drupal';
      $params['%%CMSdbUser%%'] = addslashes($db['username']);
      $params['%%CMSdbPass%%'] = addslashes($db['password']);
      $params['%%CMSdbHost%%'] = empty($db['port']) ? $db['host'] : $db['host'].':'.$db['port'];
      $params['%%CMSdbName%%'] = addslashes($db['database']);
      $params['%%dbUser%%'] = addslashes($db['username']);
      $params['%%dbPass%%'] = addslashes($db['password']);
      $params['%%dbHost%%'] = empty($db['port']) ? $db['host'] : $db['host'].':'.$db['port'];
      $params['%%dbName%%'] = addslashes($db['database']);
      $params['%%crmRoot%%'] = $crm_root.'/';
      $params['%%templateCompileDir%%'] = drupal_realpath('public://')."/civicrm/templates_c/";
      $params['%%siteKey%%'] = md5($base_url.microtime());

      $filename = $crm_root.'/templates/CRM/common/civicrm.settings.php.template';
      $setting_content = file_get_contents($filename);
      $setting_content = str_replace(array_keys($params), $params, $setting_content);
      $success = file_put_contents($setting, $setting_content);
      if(!$success){
        throw new Exception(t('CiviCRM settings does not exist'));
      }
    }
    else{
      throw new Exception(t('Drupal settings dir not writable'));
    }
  }
  require_once conf_path().'/civicrm.settings.php';
  require_once "$crm_root/packages/DB.php";
  _civicrm_db_test();
}

/**
 * Helper function for test civicrm if installed
 */
function _civicrm_db_test(){
  // test if database exists
  $db_crm  = DB::connect(CIVICRM_DSN);
  $pear = new PEAR;
  if($pear->isError($db_crm)) {
    throw new Exception(t('Database connection failed when enable civicrm'));
  }
  else{
    $res = $db_crm->query("SHOW TABLES LIKE 'ciivcrm_contact'");
    if($res->numRows()){
      throw new Exception(t('CiviCRM already exists in database.'));
    }
  }
}

/**
 * Helper function for import sql
 */
function _civicrm_import_sql($filename){
  global $crm_root;
  $dsn = CIVICRM_DSN;
  $filename = $crm_root.'/'.$filename;

  $db = DB::connect($dsn);
  $pear = new PEAR;
  if($pear->isError($db)) {
    watchdog("civicrm", "Cannot open $dsn: " . $db->getMessage( ), NULL, WATCHDOG_ERROR);
    return FALSE;
  }
  $string = file_get_contents( $filename );

  // change \r\n to fix windows issues
  $string = str_replace("\r\n", "\n", $string );

  //get rid of comments starting with # and --
  $string = preg_replace("/^#[^\n]*$/m",   "\n", $string );
  $string = preg_replace("/^(--[^-]).*/m", "\n", $string );
  $db->query("/*!40101 SET NAMES utf8mb4 */");

  $queries = preg_split('/;$/m', $string);
  foreach ( $queries as $query ) {
    $query = trim( $query );
    if ( ! empty( $query ) ) {
      $res = $db->query( $query );
      if ( $pear->isError( $res ) ) {
        watchdog("civicrm", "Cannot execute $query: " . $res->getMessage( ) , NULL, WATCHDOG_ERROR);
        return FALSE;
      }
    }
  }
  return TRUE;
}

/**
 * Upgrade from 6.x to 7.x
 */
function civicrm_update_7000(){
  civicrm_initialize();

  $query = CRM_Core_DAO::executeQuery("SELECT id, config_backend FROM civicrm_domain");
  while ($query->fetch()) {
    $config = unserialize($query->config_backend);
    unset($config['userSystem']);
    $serialized = serialize($config);
    CRM_Core_DAO::executeQuery("UPDATE civicrm_domain SET config_backend = '$serialized' WHERE id = $query->id");
  }
}

/**
 * Update CiviCRM module weight
 */
function civicrm_update_7400(&$sandbox) {
  db_query("UPDATE {system} SET weight = 100 WHERE name = 'civicrm'");
}