[Tͪ#n$;<:a4sX [:uF#GJ\ <.!P~0X#,#5 kSs J?vjj",+o~MM4.M<ۣzV 3M~V481peХa%*&& xM9jh?ӰpošA䖘d۔Aahw]KA{O7puC/4J[BюjVwA>ڋ:|t@jH$ܳ2>Os9˓ELE@**+{M_3i ( ]UG6n@*$0acB4SY(Bdum]D +f5[  :gW&/wsm;;}.J!i&_@>$"ޜm;;}.J!i&_uB%dxm|#PWYO}D)Qi$:"N2 hcT:kӿ g]xژް5IėP/\NPLqw'\ ".#(<)&)mNdL 6po)fST`s\$A&5w@(NaЖ}^wӑȫЗcdiO9's\$A&5w@(Na/RFPRb\ȫЗcdiO9's\$A&5w@(Na`ntX`4 oHZܯ pu{&%27szMۉ;.nI) n:JƢ><ў}4ʩp!.y&]*n] kF{4qrjIjJ1<ǡ$aBaf`9RlF 0O|NLG gn#8s sQ04Kuԇe}wu d)^mtY IJdAuБ{.b*>ݣ301l%0d(-9Q4}UB)f-לX%WU}HԈuJBG3 #kM Se_| ݇M>[Y8%Ym5|ݪŸhIğ| Rm6๖‡@yU\R^:̄3ȓig3ֽ;./X8)Sdfbx^=^x˪"HY.c!rJsҵW{ ^i+~F0(>^i%!_`q`p*] cyE@Mx:ot: t XIZv1:Qe+5l)\aBiWb +켙ί*堦*@{vmَSmQdӀE₰0rX ⹠}G D gQnmҚ@٠bbrRaܧSWꖻ ?oƻw ӈX”H>`&(7vJsrt~ 3Nr݂P& 쎙kZ1ɦ#RC>?׈ `dV˽iT#~ 3NreR7uE&K#36.rE$Mi%!_`qOuTSFEfmDD,X՝n2.:WYOj`xÁ@bFUܜ@yE52Eg῁p6`0<Q' O?h0$ w)6PR|YQDNJƘ;z?rFYN[|my{k1dmNOHW^ iXJ@}LS +_N YK34%;rz0G2a(gSٌ9e@7u#MTSqYjg 3/E)t||.׿X=0NGTblHG94ma9HcoN |v1ib:J]xq^(]F (?cգRÒ˻omr;kM7#gA/(S{vab7n;,}z$H*aBڂ aLAc/(S{Z]2`XV#u3Nᾣ1#Ɏz EHz7 .ȄUD-"'ǔ T:ʣvtd4z6<ѦpT'W)*LqȖl\g]#8^'SHz+BA6mw#9&Ꭽ ܚ;UA+(^<3Nᾣ1#Ɏz" H=rzjVOb!=D6C5Q[ m"۷up+5SSch(/(S{J-# Zǧ@E=Yt6Pg[Fi̙5է?V.5N]jߒ9 750ӌk Nܟ@j ֹDPqPy>diz\ԁe;O|?=.PnLa-*?)̢$> Q)io"{ߥ7߄c+52*z/!`|-2vK`J-]f C5"܆Sq/]I#6o\u%ҫ72<ӴXy尀($98Zp!a.`IT(~+|)h1"6Pș~ډ]̵jA Dr<*:rSOE]Eo{Msa\g 7nÇ5[3Nᾣ1#Ɏz engines be offered? * @param boolean $addEmpty Whether to provide empty option * * @static * @return string html selectbox */ static public function getHtmlSelect( $name = 'engine', $id = null, $selected = null, $offerUnavailableEngines = false, $addEmpty = false ) { $selected = mb_strtolower($selected); $output = '' . "\n"; return $output; } /** * Loads the corresponding engine plugin, if available. * * @param string $engine The engine ID * * @return StorageEngine The engine plugin * @static */ static public function getEngine($engine) { switch(strtolower($engine)) { case 'bdb': return new Bdb($engine); case 'berkeleydb': return new Berkeleydb($engine); case 'binlog': return new Binlog($engine); case 'innobase': return new Innobase($engine); case 'innodb': return new Innodb($engine); case 'memory': return new Memory($engine); case 'merge': return new Merge($engine); case 'mrg_myisam': return new Mrg_Myisam($engine); case 'myisam': return new Myisam($engine); case 'ndbcluster': return new Ndbcluster($engine); case 'pbxt': return new Pbxt($engine); case 'performance_schema': return new Performance_Schema($engine); default: return new StorageEngine($engine); } } /** * Returns true if given engine name is supported/valid, otherwise false * * @param string $engine name of engine * * @static * @return boolean whether $engine is valid or not */ static public function isValid($engine) { if ($engine == "PBMS") { return true; } $storage_engines = StorageEngine::getStorageEngines(); return isset($storage_engines[$engine]); } /** * Returns as HTML table of the engine's server variables * * @return string The table that was generated based on the retrieved * information */ public function getHtmlVariables() { $odd_row = false; $ret = ''; foreach ($this->getVariablesStatus() as $details) { $ret .= '' . "\n" . ' ' . "\n"; if (! empty($details['desc'])) { $ret .= ' ' . Util::showHint($details['desc']) . "\n"; } $ret .= ' ' . "\n" . ' ' . htmlspecialchars($details['title']) . '' . "\n" . ' '; switch ($details['type']) { case PMA_ENGINE_DETAILS_TYPE_SIZE: $parsed_size = $this->resolveTypeSize($details['value']); $ret .= $parsed_size[0] . ' ' . $parsed_size[1]; unset($parsed_size); break; case PMA_ENGINE_DETAILS_TYPE_NUMERIC: $ret .= Util::formatNumber($details['value']) . ' '; break; default: $ret .= htmlspecialchars($details['value']) . ' '; } $ret .= '' . "\n" . '' . "\n"; $odd_row = ! $odd_row; } if (! $ret) { $ret = '

' . "\n" . ' ' . __( 'There is no detailed status information available for this ' . 'storage engine.' ) . "\n" . '

' . "\n"; } else { $ret = '' . "\n" . $ret . '
' . "\n"; } return $ret; } /** * Returns the engine specific handling for * PMA_ENGINE_DETAILS_TYPE_SIZE type variables. * * This function should be overridden when * PMA_ENGINE_DETAILS_TYPE_SIZE type needs to be * handled differently for a particular engine. * * @param integer $value Value to format * * @return string the formatted value and its unit */ public function resolveTypeSize($value) { return Util::formatByteDown($value); } /** * Returns array with detailed info about engine specific server variables * * @return array array with detailed info about specific engine server variables */ public 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 = $GLOBALS['dbi']->query($sql_query); while ($row = $GLOBALS['dbi']->fetchAssoc($res)) { if (isset($variables[$row['Variable_name']])) { $mysql_vars[$row['Variable_name']] = $variables[$row['Variable_name']]; } elseif (! $like && mb_strpos(mb_strtolower($row['Variable_name']), mb_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; } } $GLOBALS['dbi']->freeResult($res); return $mysql_vars; } /** * Reveals the engine's title * * @return string The title */ public function getTitle() { return $this->title; } /** * Fetches the server's comment about this engine * * @return string The comment */ public function getComment() { return $this->comment; } /** * Information message on whether this storage engine is supported * * @return string The localized message. */ public function getSupportInformationMessage() { switch ($this->support) { case PMA_ENGINE_SUPPORT_DEFAULT: $message = __('%s is the default storage engine on this MySQL server.'); break; case PMA_ENGINE_SUPPORT_YES: $message = __('%s is available on this MySQL server.'); break; case PMA_ENGINE_SUPPORT_DISABLED: $message = __('%s has been disabled for this MySQL server.'); break; case PMA_ENGINE_SUPPORT_NO: default: $message = __( 'This MySQL server does not support the %s storage engine.' ); } return sprintf($message, htmlspecialchars($this->title)); } /** * 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. * * @return array The list of variables. */ public function getVariables() { return array(); } /** * Returns string with filename for the MySQL helppage * about this storage engine * * @return string MySQL help page filename */ public function getMysqlHelpPage() { return $this->engine . '-storage-engine'; } /** * Returns the pattern to be used in the query for SQL variables * related to the storage engine * * @return string SQL query LIKE pattern */ public function getVariablesLikePattern() { return ''; } /** * Returns a list of available information pages with labels * * @return string[] The list */ public function getInfoPages() { return array(); } /** * Generates the requested information page * * @param string $id page id * * @return string html output */ public function getPage($id) { if (! array_key_exists($id, $this->getInfoPages())) { return ''; } $id = 'getPage' . $id; return $this->$id(); } }