* @version SVN: $rev: 1207 $ * @author $Author$ * @lastmodified $Date$ */ if (!defined('MSD_VERSION')) { die('No direct access.'); } $selectedFilter = -1; if (isset($_POST['filter_selected'])) { $selectedFilter = $_POST['filter_selected']; } $res = $dbo->query('SHOW GLOBAL STATUS', MsdDbFactory::ARRAY_ASSOC); foreach ($res as $row) { $status[$row['Variable_name']] = $row['Value']; } $filter = getPrefixArray($status); // values that will be formatted as times $timeValues = array('Uptime', 'Uptime_since_flush_status'); $tplSqlbrowserGeneralStatus = new MSDTemplate(); $tplSqlbrowserGeneralStatus->set_filenames(array('tplSqlbrowserGeneralStatus' => 'tpl/sqlbrowser/general/status.tpl')); if ($selectedFilter != '-1') { $query = 'SHOW GLOBAL STATUS LIKE \'' . $selectedFilter . '_%\''; $res = $dbo->query($query, MsdDbFactory::ARRAY_ASSOC); } if (@sizeof($res) == 0) { $tpl->assign_block_vars('NO_STATUS', array()); } else { if (count($filter) > 0) { $tplSqlbrowserGeneralStatus->assign_block_vars('FILTER', array('SEL_FILTER' => Html::getOptionlist($filter, $selectedFilter))); } $i = 0;
* @lastmodified $Date$ */ if (!defined('MSD_VERSION')) { die('No direct access.'); } $selectedFilter = -1; if (isset($_POST['filter_selected'])) { $selectedFilter = $_POST['filter_selected']; } $vars = array(); $res = $dbo->query('SHOW VARIABLES', MsdDbFactory::ARRAY_ASSOC); $numrows = @sizeof($res); foreach ($res as $row) { $vars[$row['Variable_name']] = $row['Value']; } $filter = getPrefixArray($vars); $tplSqlbrowserGeneralMysqlVariables = new MSDTemplate(); $tplSqlbrowserGeneralMysqlVariables->set_filenames(array('tplSqlbrowserGeneralMysqlVariables' => 'tpl/sqlbrowser/general/mysqlVariables.tpl')); $tplSqlbrowserGeneralMysqlVariables->assign_vars(array('SEL_FILTER' => Html::getOptionlist($filter, $selectedFilter))); if (count($vars) == 0) { $tpl->assign_block_vars('NO_VALUES', array()); } else { $i = 0; foreach ($vars as $name => $val) { if ($selectedFilter != '-1' && substr($name, 0, strlen($selectedFilter)) != $selectedFilter) { continue; } if (is_numeric($val)) { if (strpos($name, 'time') === false) { $val = String::formatNumber($val); } else {