' . "\n"; foreach (PMA_StorageEngine::getStorageEngines() as $key => $details) { if (!$offerUnavailableEngines && ($details['Support'] == 'NO' || $details['Support'] == 'DISABLED')) { continue; } // currently (MySQL 5.1.26) there is no way we can be informed // that PBMS does not support normal table creation so // we use an exception here if ('PBMS' == $details['Engine']) { continue; } $output .= ' ' . "\n"; } $output .= '' . "\n"; return $output; } /** * public static final PMA_StorageEngine getEngine() * * Loads the corresponding engine plugin, if available. * * @uses str_replace() * @uses file_exists() * @uses PMA_StorageEngine * @param string $engine The engine ID * @return object The engine plugin */ static public function getEngine($engine) { $engine = str_replace('/', '', str_replace('.', '', $engine)); $engine_lowercase_filename = strtolower($engine); if (file_exists('./libraries/engines/' . $engine_lowercase_filename . '.lib.php') && include_once './libraries/engines/' . $engine_lowercase_filename . '.lib.php') { $class_name = 'PMA_StorageEngine_' . $engine; $engine_object = new $class_name($engine); } else { $engine_object = new PMA_StorageEngine($engine); } return $engine_object; } /** * return true if given engine name is supported/valid, otherwise false * * @static * @uses PMA_StorageEngine::getStorageEngines() * @param string $engine name of engine * @reutrn boolean whether $engine is valid or not */ static public function isValid($engine) { $storage_engines = PMA_StorageEngine::getStorageEngines(); return isset($storage_engines[$engine]); } /** * returns as HTML table of the engine's server variables * * @uses PMA_ENGINE_DETAILS_TYPE_SIZE * @uses PMA_ENGINE_DETAILS_TYPE_NUMERIC * @uses PMA_StorageEngine::getVariablesStatus() * @uses $GLOBALS['strNoDetailsForEngine'] * @uses PMA_showHint() * @uses PMA_formatByteDown() * @uses PMA_formatNumber() * @uses htmlspecialchars() * @return string The table that was generated based on the retrieved information */ function getHtmlVariables() { $odd_row = false; $ret = ''; foreach ($this->getVariablesStatus() as $details) { $ret .= '' . "\n" . ' ' . "\n"; if (!empty($details['desc'])) { $ret .= ' ' . PMA_showHint($details['desc']) . "\n"; } $ret .= ' ' . "\n" . ' ' . htmlspecialchars($details['title']) . '' . "\n" . ' '; switch ($details['type']) { case PMA_ENGINE_DETAILS_TYPE_SIZE: $parsed_size = PMA_formatByteDown($details['value']); $ret .= $parsed_size[0] . ' ' . $parsed_size[1]; unset($parsed_size); break; case PMA_ENGINE_DETAILS_TYPE_NUMERIC: $ret .= PMA_formatNumber($details['value']) . ' '; break; default: $ret .= htmlspecialchars($details['value']) . ' '; } $ret .= '' . "\n" . '' . "\n"; $odd_row = !$odd_row; } if (! $ret) { $ret = '

' . "\n" . ' ' . $GLOBALS['strNoDetailsForEngine'] . "\n" . '

' . "\n"; } else { $ret = '' . "\n" . $ret . '
' . "\n"; } return $ret; } /** * returns array with detailed info about engine specific server variables * * @uses PMA_ENGINE_DETAILS_TYPE_PLAINTEXT * @uses PMA_StorageEngine::getVariables() * @uses PMA_StorageEngine::getVariablesLikePattern() * @uses PMA_DBI_query() * @uses PMA_DBI_fetch_assoc() * @uses PMA_DBI_free_result() * @return array with detailed info about specific engine server variables */ function getVariablesStatus() { $variables = $this->getVariables(); $like = $this->getVariablesLikePattern(); if ($like) { $like = " LIKE '" . $like . "' "; } else { $like = ''; } $mysql_vars = array(); $sql_query = 'SHOW GLOBAL VARIABLES ' . $like . ';'; $res = PMA_DBI_query($sql_query); while ($row = PMA_DBI_fetch_assoc($res)) { if (isset($variables[$row['Variable_name']])) { $mysql_vars[$row['Variable_name']] = $variables[$row['Variable_name']]; } elseif (! $like && strpos(strtolower($row['Variable_name']), strtolower($this->engine)) !== 0) { continue; } $mysql_vars[$row['Variable_name']]['value'] = $row['Value']; if (empty($mysql_vars[$row['Variable_name']]['title'])) { $mysql_vars[$row['Variable_name']]['title'] = $row['Variable_name']; } if (! isset($mysql_vars[$row['Variable_name']]['type'])) { $mysql_vars[$row['Variable_name']]['type'] = PMA_ENGINE_DETAILS_TYPE_PLAINTEXT; } } PMA_DBI_free_result($res); return $mysql_vars; } /** * Constructor * * @uses PMA_StorageEngine::getStorageEngines() * @uses PMA_ENGINE_SUPPORT_DEFAULT * @uses PMA_ENGINE_SUPPORT_YES * @uses PMA_ENGINE_SUPPORT_DISABLED * @uses PMA_ENGINE_SUPPORT_NO * @uses $this->engine * @uses $this->title * @uses $this->comment * @uses $this->support * @param string $engine The engine ID */ function __construct($engine) { $storage_engines = PMA_StorageEngine::getStorageEngines(); if (!empty($storage_engines[$engine])) { $this->engine = $engine; $this->title = $storage_engines[$engine]['Engine']; $this->comment = (isset($storage_engines[$engine]['Comment']) ? $storage_engines[$engine]['Comment'] : ''); switch ($storage_engines[$engine]['Support']) { case 'DEFAULT': $this->support = PMA_ENGINE_SUPPORT_DEFAULT; break; case 'YES': $this->support = PMA_ENGINE_SUPPORT_YES; break; case 'DISABLED': $this->support = PMA_ENGINE_SUPPORT_DISABLED; break; case 'NO': default: $this->support = PMA_ENGINE_SUPPORT_NO; } } } /** * public String getTitle() * * Reveals the engine's title * @uses $this->title * @return string The title */ function getTitle() { return $this->title; } /** * public String getComment() * * Fetches the server's comment about this engine * @uses $this->comment * @return string The comment */ function getComment() { return $this->comment; } /** * public String getSupportInformationMessage() * * @uses $GLOBALS['strDefaultEngine'] * @uses $GLOBALS['strEngineAvailable'] * @uses $GLOBALS['strEngineDisabled'] * @uses $GLOBALS['strEngineUnsupported'] * @uses $GLOBALS['strEngineUnsupported'] * @uses PMA_ENGINE_SUPPORT_DEFAULT * @uses PMA_ENGINE_SUPPORT_YES * @uses PMA_ENGINE_SUPPORT_DISABLED * @uses PMA_ENGINE_SUPPORT_NO * @uses $this->support * @uses $this->title * @uses sprintf * @return string The localized message. */ function getSupportInformationMessage() { switch ($this->support) { case PMA_ENGINE_SUPPORT_DEFAULT: $message = $GLOBALS['strDefaultEngine']; break; case PMA_ENGINE_SUPPORT_YES: $message = $GLOBALS['strEngineAvailable']; break; case PMA_ENGINE_SUPPORT_DISABLED: $message = $GLOBALS['strEngineDisabled']; break; case PMA_ENGINE_SUPPORT_NO: default: $message = $GLOBALS['strEngineUnsupported']; } return sprintf($message, htmlspecialchars($this->title)); } /** * public string[][] getVariables() * * Generates a list of MySQL variables that provide information about this * engine. This function should be overridden when extending this class * for a particular engine. * * @abstract * @return Array The list of variables. */ function getVariables() { return array(); } /** * returns string with filename for the MySQL helppage * about this storage engne * * @return string mysql helppage filename */ function getMysqlHelpPage() { return $this->engine . '-storage-engine'; } /** * public string getVariablesLikePattern() * * @abstract * @return string SQL query LIKE pattern */ function getVariablesLikePattern() { return false; } /** * public String[] getInfoPages() * * Returns a list of available information pages with labels * * @abstract * @return array The list */ function getInfoPages() { return array(); } /** * public String getPage() * * Generates the requested information page * * @abstract * @param string $id The page ID * * @return string The page * boolean or false on error. */ function getPage($id) { return false; } } ?>