public function indexAction() { $this->view->phpVersion = phpversion(); $this->view->databaseVersion = Gio_Db_Mysql::getInstance()->getVersion(); $configs = Gio_Core_Config_Xml::getConfig('install'); $this->view->installInformation = $configs; $modules = Modules_Core_Services_Module::getModulesInstalled(); /** * Add module core to the top array */ $modules = array_pad($modules, -count($modules) - 1, array('module_id' => 'core')); $quickaccess = array(); if ($modules) { foreach ($modules as $index => $module) { $aboutXml = MOD_DIR . DS . $module['module_id'] . DS . 'configs' . DS . 'about.xml'; if (!file_exists($aboutXml)) { continue; } $aboutXml = @simplexml_load_file($aboutXml); $items = isset($aboutXml->admin->quickaccess->item) ? $aboutXml->admin->quickaccess->item : null; if ($items) { foreach ($items as $item) { $data = array(); $data['module'] = $module['module_id']; $data['route'] = $item->route; $data['lang_key'] = $item->lang_key; $data['thumbnail'] = $item->thumbnail; $quickaccess[] = $data; } } } } $this->view->quickaccess = $quickaccess; }
/** * @return Gio_Db_Mysql */ public function __construct($instance = false) { if ($instance) { return $this; } $configs = Gio_Core_Config_Xml::getConfig('db'); $this->_host = $configs->host; $this->_username = $configs->username; $this->_password = $configs->password; $this->_dbName = $configs->name; $this->_port = $configs->port; $this->_tablePrefix = $configs->table_prefix; $host = $this->_port != null ? $this->_host . ':' . $this->_port : $this->_host; $link = null; $connected = false; $connected = mysql_pconnect($host, $this->_username, $this->_password, $link) or die('Cannot connect to Database!'); $this->_connected = $connected; $this->_link = $link; mysql_select_db($this->_dbName, $connected); mysql_query(sprintf("SET CHARACTER SET '%s'", mysql_real_escape_string($configs->encoding))); return self::$_instance = $this; }
/** * Test database connection * * @return void */ private function _testdbconn() { $request = $this->getRequest(); if (!$request->isPost()) { return; } $conn = Gio_Db_Mysql::getInstance(); $options = array('host' => $request->getPost('host'), 'port' => $request->getPost('port'), 'username' => $request->getPost('username'), 'password' => $request->getPost('password')); $success = $conn->testConnection($options); if ($success) { $databases = $conn->getDatabases($options); $return = array('result' => 'RESULT_OK', 'databases' => $databases); } else { $return = array('result' => 'RESULT_ERROR', 'databases' => null); } $json = new Services_JSON(); $this->getResponse()->setBody($json->encodeUnsafe($return)); }
public static function getUsersOnline() { $mysql = new Gio_Db_Mysql(); $sql = 'SELECT * FROM ' . $mysql->_tablePrefix . 'core_session AS s WHERE status = "active" AND data != ""'; $rs = $mysql->query($sql); $sessions = array(); while ($row = $mysql->fetchAll($rs)) { $sessions[] = $row; } /** * Free result */ $mysql->freeResult($rs); return $sessions; }