/** * Create an instance of JO_Db_Adapter_Abstract. * * @param array $server master (supplier) or slave (consumer) * @return JO_Db_Adapter_Abstract|false * @see JO_Db */ public function createConnection($server) { $config = $this->getConfig(); foreach ($config as $key => $value) { if ('servers' !== $key && !array_key_exists($key, $server)) { $server[$key] = $value; } } $db = JO_Db::factory($config['adapter'], $server); if ($this->isConnected($db)) { return $db; } return false; }
public function indexAction() { $request = $this->getRequest(); $this->view->msg_error = array(); $this->view->msg_success = array(); //begin updater $sys_config = APPLICATION_PATH . '/config/config_db.ini'; if (!file_exists($sys_config)) { $this->view->msg_error['old_sys'] = 'System Db config file not found: <strong>' . $sys_config . '</strong>'; } elseif (!is_writable($sys_config)) { $this->view->msg_error['old_sys'] = '<strong>' . $sys_config . '</strong> must be writable!'; } $upload_folder = BASE_PATH . '/uploads/'; if (!is_writable($upload_folder)) { $this->view->msg_error['upload'] = '<strong>' . $upload_folder . '</strong> must be writable!'; } $upload_folder = BASE_PATH . '/cache/'; if (!is_writable($upload_folder)) { $this->view->msg_error['cache'] = '<strong>' . $upload_folder . '</strong> must be writable!'; } if (!$this->view->msg_error && $request->getPost('install') == 'yes') { $db_params = $request->getPost('params'); $db_params['charset'] = 'utf8'; foreach ($db_params as $key => $value) { if (!$value && in_array($key, array('password', 'dbname'))) { $db_params[$key] = ' '; } } $error = false; try { $db = JO_Db::factory("MYSQLi", $db_params); $db->query("ALTER DATABASE `" . $request->getPost('params[dbname]') . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci"); $db->query("SET NAMES 'utf8'"); } catch (JO_Db_Exception $e) { $error = $e->getMessage(); } if ($db->isConnected()) { if (trim($request->getPost('username')) == '') { $this->view->msg_error['username'] = '******'; } elseif (!preg_match('/^[a-zA-Z0-9_]+$/i', $request->getPost('username'))) { $this->view->msg_error['username'] = '******'; } if (trim($request->getPost('password')) == '') { $this->view->msg_error['password'] = '******'; } if (trim($request->getPost('admin_mail')) == '') { $this->view->msg_error['admin_mail'] = 'You must type your email'; } elseif (!self::ValidMail($request->getPost('admin_mail'))) { $this->view->msg_error['admin_mail'] = 'You must type valid email'; } if (trim($request->getPost('report_mail')) == '') { $this->view->msg_error['report_mail'] = 'You must type your email'; } elseif (!self::ValidMail($request->getPost('report_mail'))) { $this->view->msg_error['report_mail'] = 'You must type valid email'; } if (count($this->view->msg_error) == 0) { if ($request->getPost('demo') == 'yes') { $result = Model_Install::installWithDemo($db); } else { $result = Model_Install::installWithoutDemo($db); } if ($result) { JO_Action::getInstance()->redirect($request->getBaseUrl() . '?module=install&action=success'); } else { $this->view->msg_error['install_error'] = 'An error occurred during installation. Try again to install and the installation fails, contact <a target="_blank" title="marketplace script" href="http://cloneforest.com"> Marketplace script </a>'; } } } else { $this->view->msg_error['db_connect'] = $error; } } }
/** * Set Db configuration settings * * @param array $options * @return JO_Db */ public function setDb($options) { $adapter = null; if (!isset($options['adapter'])) { throw new JO_Exception("Db adapter not set"); } elseif (empty($options['adapter'])) { throw new JO_Exception("Db adapter is empty"); } if (!isset($options['params']) || !is_array($options['params'])) { throw new JO_Exception("Db params error"); } $this->_db = JO_Db_Table::setDefaultAdapter(JO_Db::factory($options['adapter'], $options['params'])); return $this->_db; }