* @copyright 2007-2011 PrestaShop SA * @version Release: $Revision: 7501 $ * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) * International Registered Trademark & Property of PrestaShop SA */ include_once(PS_ADMIN_DIR.'/tabs/AdminPreferences.php'); class AdminDb extends AdminPreferences { public function __construct() { $this->className = 'Configuration'; $this->table = 'configuration'; $this->_fieldsDatabase = array( 'db_server' => array('title' => $this->l('Server:'), 'desc' => $this->l('IP or server name; \'localhost\' will work in most cases'), 'size' => 30, 'type' => 'text', 'required' => true), 'db_name' => array('title' => $this->l('Database:'), 'desc' => $this->l('Database name (e.g., \'prestashop\')'), 'size' => 30, 'type' => 'text', 'required' => true), 'db_prefix' => array('title' => $this->l('Prefix:'), 'size' => 30, 'type' => 'text'), 'db_user' => array('title' => $this->l('User:'), 'size' => 30, 'type' => 'text', 'required' => true), 'db_passwd' => array('title' => $this->l('Password:'), 'size' => 30, 'type' => 'password', 'desc' => $this->l('Leave blank if no change'))); parent::__construct(); } public function postProcess() { global $currentIndex; if (isset($_POST['submitDatabase'.$this->table])) { if ($this->tabAccess['edit'] === '1') { foreach ($this->_fieldsDatabase AS $field => $values) if (isset($values['required']) AND $values['required']) if (($value = Tools::getValue($field)) == false AND (string)$value != '0') $this->_errors[] = Tools::displayError('field').' '.$values['title'].' '.Tools::displayError('is required.'); if (!sizeof($this->_errors)) { /* Datas are not saved in database but in config/settings.inc.php */ $settings = array(); foreach ($_POST as $k => $value) if ($value) $settings['_'.Tools::strtoupper($k).'_'] = $value; rewriteSettingsFile(NULL, NULL, $settings); Tools::redirectAdmin($currentIndex.'&conf=6'.'&token='.$this->token); } } else $this->_errors[] = Tools::displayError('You do not have permission to edit here.'); } if (Tools::isSubmit('submitEngine')) { if (!isset($_POST['tablesBox']) OR !sizeof($_POST['tablesBox'])) $this->_errors[] = Tools::displayError('You did not select any tables'); else { $available_engines = $this->_getEngines(); $tables_status = $this->_getTablesStatus(); $tables_engine = array(); foreach ($tables_status AS $table) $tables_engine[$table['Name']] = $table['Engine']; $engineType = pSQL(Tools::getValue('engineType')); /* Datas are not saved in database but in config/settings.inc.php */ $settings = array('_MYSQL_ENGINE_' => $engineType); rewriteSettingsFile(NULL, NULL, $settings); foreach ($_POST['tablesBox'] AS $table) { if ($engineType == $tables_engine[$table]) $this->_errors[] = $table.' '.$this->l('is already in').' '.$engineType; else if (!Db::getInstance()->Execute('ALTER TABLE '.pSQL($table).' ENGINE='.pSQL($engineType))) $this->_errors[] = $this->l('Can\'t change engine for').' '.$table; else echo '
'.$this->l('Confirmation').''.$this->l('Engine change of').' '.$table.' '.$this->l('to').' '.$engineType.'
'; } } } } public function display() { global $currentIndex; echo $this->displayWarning($this->l('Be VERY CAREFUL with these settings, as changes may cause your PrestaShop online store to malfunction. For all issues, check the config/settings.inc.php file.')).'
'; $this->_displayForm('database', $this->_fieldsDatabase, $this->l('Database'), 'width2', 'database_gear'); $engines = $this->_getEngines(); $irow = 0; echo '
'.$this->l('MySQL Engine').'
'; $tables_status = $this->_getTablesStatus(); foreach ($tables_status AS $table) { if (!preg_match('/^'._DB_PREFIX_.'.*/Ui', $table['Name'])) continue; echo ''; } echo '
'.$this->l('Table').''.$this->l('Table Engine').'
'.$table['Name'].''.$table['Engine'].'

'; } private function _getEngines() { $engines = Db::getInstance()->ExecuteS('SHOW ENGINES'); $allowed_engines = array(); foreach ($engines AS $engine) { if (in_array($engine['Engine'], array('InnoDB', 'MyISAM')) AND in_array($engine['Support'], array('DEFAULT', 'YES'))) $allowed_engines[] = $engine['Engine']; } return $allowed_engines; } private function _getTablesStatus() { return Db::getInstance()->ExecuteS('SHOW TABLE STATUS'); } }