diff options
author | Madhura Jayaratne <madhura.cj@gmail.com> | 2012-04-13 19:27:17 +0400 |
---|---|---|
committer | Madhura Jayaratne <madhura.cj@gmail.com> | 2012-04-13 19:27:17 +0400 |
commit | fa9aaea8c0f409cfd6f131de6b808de1a4851008 (patch) | |
tree | a3de6420ca4aea5471e57a05680c4b3bdfc0e76f /server_variables.php | |
parent | dac767f3c43abf00b3aa95c7c281b74229c4a97d (diff) |
Coding style improvements
Diffstat (limited to 'server_variables.php')
-rw-r--r-- | server_variables.php | 96 |
1 files changed, 57 insertions, 39 deletions
diff --git a/server_variables.php b/server_variables.php index c5abf25de5..246d124a1d 100644 --- a/server_variables.php +++ b/server_variables.php @@ -34,46 +34,64 @@ if (isset($_REQUEST['ajax_request']) && $_REQUEST['ajax_request'] == true) { if (isset($_REQUEST['type'])) { switch($_REQUEST['type']) { - case 'getval': - $varValue = PMA_DBI_fetch_single_row('SHOW GLOBAL VARIABLES WHERE Variable_name="' . PMA_sqlAddslashes($_REQUEST['varName']) . '";', 'NUM'); - if (isset($VARIABLE_DOC_LINKS[$_REQUEST['varName']][3]) - && $VARIABLE_DOC_LINKS[$_REQUEST['varName']][3] == 'byte') { - exit(implode(' ', PMA_formatByteDown($varValue[1], 3, 3))); - } - exit($varValue[1]); - break; - - case 'setval': - $value = $_REQUEST['varValue']; - - if (isset($VARIABLE_DOC_LINKS[$_REQUEST['varName']][3]) - && $VARIABLE_DOC_LINKS[$_REQUEST['varName']][3] == 'byte' - && preg_match('/^\s*(\d+(\.\d+)?)\s*(mb|kb|mib|kib|gb|gib)\s*$/i', $value, $matches)) { - $exp = array('kb' => 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') - )) + case 'getval': + $varValue = PMA_DBI_fetch_single_row( + 'SHOW GLOBAL VARIABLES WHERE Variable_name="' + . PMA_sqlAddslashes($_REQUEST['varName']) . '";', 'NUM' + ); + if (isset($VARIABLE_DOC_LINKS[$_REQUEST['varName']][3]) + && $VARIABLE_DOC_LINKS[$_REQUEST['varName']][3] == 'byte' + ) { + exit(implode(' ', PMA_formatByteDown($varValue[1], 3, 3))); + } + exit($varValue[1]); + break; + + case 'setval': + $value = $_REQUEST['varValue']; + + if (isset($VARIABLE_DOC_LINKS[$_REQUEST['varName']][3]) + && $VARIABLE_DOC_LINKS[$_REQUEST['varName']][3] == 'byte' + && preg_match('/^\s*(\d+(\.\d+)?)\s*(mb|kb|mib|kib|gb|gib)\s*$/i', $value, $matches) + ) { + $exp = array('kb' => 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' ); - break; + + exit( + json_encode( + array( + 'success' => true, + 'variable' => formatVariable($_REQUEST['varName'], $varValue[1]) + ) + ) + ); + } + + exit( + json_encode( + array( + 'success' => false, + 'error' => __('Setting variable failed') + ) + ) + ); + break; } } } |