<?php // -*- mode:php; tab-width:4; indent-tabs-mode:t; c-basic-offset:4; -*-
#CMS - CMS Made Simple
#(c)2004-2007 by Ted Kulp (ted@cmsmadesimple.org)
#This project's homepage is: http://cmsmadesimple.org
#
#This program is free software; you can redistribute it and/or modify
#it under the terms of the GNU General Public License as published by
#the Free Software Foundation; either version 2 of the License, or
#(at your option) any later version.
#
#This program 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 General Public License for more details.
#You should have received a copy of the GNU General Public License
#along with this program; if not, write to the Free Software
#Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
#
#$Id$
 
class CmsInstallOperations extends CmsObject
{
  function __construct()
  {
    parent::__construct();
  }
  
  static function create_table($db, $table, $fields)
  {  
    $dbdict = NewDataDictionary($db);
    $taboptarray = array('mysql' => 'TYPE=MyISAM');
 
    $sqlarray = $dbdict->CreateTableSQL(CmsDatabase::get_prefix().$table, $fields, $taboptarray);
    $dbdict->ExecuteSQLArray($sqlarray);
  }
  
  static function create_index($db, $table, $name, $field)
  {  
    $dbdict = NewDataDictionary($db);
 
    $sqlarray = $dbdict->CreateIndexSQL($name, CmsDatabase::get_prefix().$table, $field);
    $dbdict->ExecuteSQLArray($sqlarray);
  }
  
  static function get_action()
  {
    $value = CmsRequest::get('action');
    return $value != '' ? $value : 'intro';
  }
  
  static function get_language_list()
  {
    return array('en_US' => 'English/US', 'fr_FR' => 'French');
  }
  
  static function get_language_cookie()
  {
    if (CmsRequest::has('select_language'))
    {
      $value = CmsRequest::get('select_language');
      self::set_language_cookie($value);
    }
    else
    {
      $value = CmsRequest::get_cookie('cms_install_lang');
    }
    return $value != '' ? $value : 'en_US';
  }
  
  static function set_language_cookie($value)
  {
    CmsRequest::set_cookie('cms_install_lang', $value);
  }
  
  static function required_setting_output($bool)
  {
    return $bool ? '<span class="yes">'.self::_('Yes').'</span>' : '<span class="no">'.self::_('No').'</span>';
  }
  
  static function recommended_setting_output($state, $opposite = false)
  {
    return $state ? '<span class="yes">'.(!$opposite ? self::_('On') : self::_('Off')).'</span>' : '<span class="no">'.(!$opposite ? self::_('Off') : self::_('On')).'</span>';
  }
  
  static function required_checks()
  {
    $result = array();
    
    $result['php_version'] = version_compare(phpversion(), "5.0.4", ">=");
    $result['has_database'] = count(self::get_loaded_database_modules()) > 0;
    $result['which_database'] = self::_('No Drivers Loaded');
    if ($result['has_database'])
    {
      $result['which_database'] = implode(',', self::get_loaded_database_modules());
    }
    $result['has_xml'] = extension_loaded('xml');
    $result['has_simplexml'] = extension_loaded('SimpleXML');
    $result['canwrite_templates'] = is_writable(cms_join_path(dirname(dirname(dirname(__FILE__))),'tmp','templates_c'));
    $result['canwrite_cache'] = is_writable(cms_join_path(dirname(dirname(dirname(__FILE__))),'tmp','cache'));
    
    $count = count(array_keys($result, true, true));
    $result['failure'] = ((count($result) - 1) != $count);
    
    return $result;
  }
  
  static function recommended_checks()
  {
    $result = array();
 
    $result['file_uploads'] = (ini_get('file_uploads') == '1');
    $result['safe_mode'] = (ini_get('safe_mode') != '1');
    $result['magic_quotes_runtime'] = (ini_get('magic_quotes_runtime') != '1');
    $result['register_globals'] = (ini_get('register_globals') != '1');
    $result['output_buffering'] = (ini_get('output_buffering') != '1');
    $result['canwrite_uploads'] = is_writable(cms_join_path(dirname(dirname(dirname(__FILE__))),'uploads'));
    $result['canwrite_modules'] = is_writable(cms_join_path(dirname(dirname(dirname(__FILE__))),'modules'));
    
    $count = count(array_keys($result, true, true));
    $result['failure'] = (count($result) != $count);
    
    return $result;
  }
  
  static function get_loaded_database_modules()
  {
    $which = array();
    if (extension_loaded('mysql'))
      $which[] = 'mysql';
    if (extension_loaded('mysqli'))
      $which[] = 'mysqli';
    if (extension_loaded('pgsql'))
      $which[] = 'pgsql';
    if (extension_loaded('SQLite'))
      $which[] = 'sqlite';
    return $which;
  }
  
  static function test_database_connection($driver = '', $hostname = '', $username = '', $password = '', $dbname = '')
  {
    $drivers = self::get_loaded_database_modules();
    $driver = $drivers[$driver];
 
    $have_connection = false;
    $have_create_ability = false;
    $have_existing_db = false;
    if ($username != '' && $hostname != '')
    {
      $db = self::get_database_connection($driver, $hostname, $username, $password);
      if ($db != null && $db->IsConnected())
      {
        $have_connection = true;
        //TODO: Get permissions here...
        $db->Close();
 
        //Ok, we have a connection.  Now, what about with the db name?
        if ($dbname != '')
        {
          $db = self::get_database_connection($driver, $hostname, $username, $password, $dbname);
          if ($db != null && $db->IsConnected())
          {
            $have_existing_db = true;
            $db->Close();
          }
        }
      }
    }
    
    return array('have_connection' => $have_connection, 'have_create_ability' => $have_create_ability, 'have_existing_db' => $have_existing_db);
  }
  
  static function get_database_connection($driver = '', $hostname = '', $username = '', $password = '', $dbname = '')
  {
    return CmsDatabase::connect($driver, $hostname, $username, $password, $dbname, false, false);
  }
  
  static function create_database($driver = '', $hostname = '', $username = '', $password = '', $dbname = '')
  {
    $drivers = self::get_loaded_database_modules();
    $driver = $drivers[$driver];
 
    if ($username != '' && $hostname != '')
    {
      $db = CmsDatabase::connect($driver, $hostname, $username, $password, '', false, false);
      if ($db != null && $db->IsConnected())
      {
        $dict = NewDataDictionary($db);
        if ($dict)
        {
          $dict->CreateNewDatabase($dbname);
          $db->Close();
          $db = CmsDatabase::connect($driver, $hostname, $username, $password, $dbname, false, false);
          if ($db != null && $db->IsConnected())
          {
            return true;
          }
        }
      }
    }
 
    return false;
  }
  
  static function install_config($conn,$url)
  {
    //Get an instance of CMSConfig(we need a list of all the variables plus defaults)
    $config = CmsConfig::get_instance();
    $config_data = $config->params;
    //Update the defaults with what we have. Start with database
    $drivers = CmsInstallOperations::get_loaded_database_modules();
    $config_data['dbms'] = $drivers[$conn['driver']];
    $config_data['db_username'] = $conn['username'];
    $config_data['db_hostname'] = $conn['hostname'];
    $config_data['db_password'] = $conn['password'];
    $config_data['db_name'] = $conn['dbname'];
    $config_data['db_prefix'] = $conn['table_prefix'];
    //Now location stuff
    $config_data['root_path'] = $url['rootpath'];
    $config_data['root_url'] = $url['rooturl'];
    $config_data["previews_path"] = $config_data["root_path"] . "/tmp/cache";
    $config_data["uploads_path"] = $config_data["root_path"] . "/uploads";
    $config_data["uploads_url"] = $config_data["root_url"] . "/uploads";
    $config["image_uploads_path"] = $config_data["root_path"] . "/uploads/images";
    $config["image_uploads_url"] = $config_data["root_url"] . "/uploads/images";
    //Generate the file
    $file_data = "<?php\n";
    $file_data .= $config->config_text($config_data);
    $file_data .= "?>";
    //Write the file
    return file_put_contents(CONFIG_FILE_LOCATION,$file_data) > 0;
  }
  
  static function install_schema($driver = '', $hostname = '', $username = '', $password = '', $dbname = '', $prefix = '')
  {
    $drivers = self::get_loaded_database_modules();
    $driver = $drivers[$driver];
 
    if ($username != '' && $hostname != '')
    {
      $db = CmsDatabase::connect($driver, $hostname, $username, $password, $dbname, false, false, $prefix);
      if ($db != null && $db->IsConnected())
      {
        include_once(cms_join_path(dirname(dirname(__FILE__)), 'schemas', 'schema.php'));
        return true;
      }
    }
    
    return false;
  }
  
  static function install_account($driver = '', $hostname = '', $dbusername = '', $dbpassword = '', $dbname = '', $prefix = '', $username = '', $password = '')
  {
    $drivers = self::get_loaded_database_modules();
    $driver = $drivers[$driver];
 
    if ($username != '' && $hostname != '')
    {
      $db = CmsDatabase::connect($driver, $hostname, $dbusername, $dbpassword, $dbname, false, false, $prefix);
      if ($db != null && $db->IsConnected())
      {
        $user = new CmsUser();
        $user->username = $username;
        $user->set_password($password);
        $user->active = true;
        $user->admin_access = true;
        return $user->save();
      }
    }
    
    return false;
  }
  
  static function load_basic_schema($driver = '', $hostname = '', $dbusername = '', $dbpassword = '', $dbname = '', $prefix = '')
  {
    $drivers = self::get_loaded_database_modules();
    $driver = $drivers[$driver];
 
    $db = CmsDatabase::connect($driver, $hostname, $dbusername, $dbpassword, $dbname, false, false, $prefix);
    if ($db != null && $db->IsConnected())
    {
      $handle = fopen(dirname(dirname(__FILE__)).DIRECTORY_SEPARATOR.'schemas'.DIRECTORY_SEPARATOR.'basic.sql', 'r');
 
      if ($handle)
      {
        while (!feof($handle))
        {
          set_magic_quotes_runtime(false);
          $s = fgets($handle, 32768);
          if ($s != "")
          {
            $s = trim(preg_replace('/^INSERT INTO /', "INSERT INTO {$prefix}", $s));
            $s = str_replace("\\r\\n", "\r\n", $s);
            $s = str_replace("\\'", "''", $s);
            $s = str_replace('\\"', '"', $s);
            $result = $db->Execute($s);
            if (!$result)
            {
              die("Invalid query: $s");
            } ## if
          }
        }
        fclose($handle);
      }
    }
  }
  
  static function _()
  {
    $args = func_get_args();
    return count($args[0]) > 0 ? $args[0] : '';
  }
}
 
# vim:ts=4 sw=4 noet
?>