1, 'kib' => 1, 'mb' => 2, 'mib' => 2, 'gb' => 3, 'gib' => 3);
$value = floatval($matches[1]) * pow(1024, $exp[strtolower($matches[3])]);
} else {
$value = PMA_sqlAddslashes($value);
}
if (! is_numeric($value)) {
$value="'" . $value . "'";
}
if (! preg_match("/[^a-zA-Z0-9_]+/", $_REQUEST['varName'])
&& PMA_DBI_query('SET GLOBAL ' . $_REQUEST['varName'] . ' = ' . $value)
) {
// Some values are rounded down etc.
$varValue = PMA_DBI_fetch_single_row(
'SHOW GLOBAL VARIABLES WHERE Variable_name="'
. PMA_sqlAddslashes($_REQUEST['varName']) . '";', 'NUM'
);
exit(
json_encode(
array(
'success' => true,
'variable' => formatVariable($_REQUEST['varName'], $varValue[1])
)
)
);
}
exit(
json_encode(
array(
'success' => false,
'error' => __('Setting variable failed')
)
)
);
break;
}
}
}
/**
* Displays the sub-page heading
*/
echo '' . PMA_getImage('s_vars.png')
. '' . __('Server variables and settings') . "\n"
. PMA_showMySQLDocu('server_system_variables', 'server_system_variables')
. '
' . "\n";
/**
* Sends the queries and buffers the results
*/
$serverVarsSession = PMA_DBI_fetch_result('SHOW SESSION VARIABLES;', 0, 1);
$serverVars = PMA_DBI_fetch_result('SHOW GLOBAL VARIABLES;', 0, 1);
/**
* Displays the page
*/
?>
|
|
|---|
$value) {
$has_session_value = isset($serverVarsSession[$name]) && $serverVarsSession[$name] != $value;
$row_class = ($odd_row ? 'odd' : 'even') . ' ' . ($has_session_value ? 'diffSession' : '');
?>
|
|
|
| () |
|
|
'.implode(' ', PMA_formatByteDown($value, 3, 3)).'';
} else {
return PMA_formatNumber($value, 0);
}
}
return htmlspecialchars($value);
}
/**
* Sends the footer
*/
require 'libraries/footer.inc.php';
?>