[phpMyAdmin Developers] Server variables modification

Kordován Szabolcs koszab at gmail.com
Thu Jun 9 14:16:27 CEST 2016


Hi,

The server variables are not configurable because of javascript.
The Jquery's .text() function is not useable in this HTML structure because
it will collect all '\n's and spaces which are inside the tr element with
'class=.var-name'. This is why varName will be "
____________
____________slow_query_log________
________"

POST request:
ajax_request=true&type=setval&varName=%0A____________%0A____________slow_query_log________%0A________&varValue=off&_nocache=1465473774538469936

Query  SHOW GLOBAL VARIABLES WHERE Variable_name='
____________
____________slow_query_log________
________'


My solution is find the span element inside the tr and use title of this
span.

/js/server_variables.js

function editVariable(link) {
        var $cell = $(link).parent();
        var $valueCell = $(link).parents('.var-row').find('.var-value');
--      var varName = $cell.parent().find('.var-name').text().replace(/ /g,
'_');
++        var TvarName = $cell.parent().find('.var-name');
++       var varName = TvarName[0].children[0].title.replace(/ /g, '_');
         var $mySaveLink = $saveLink.clone().show();


Query  SHOW GLOBAL VARIABLES WHERE Variable_name='slow_query_log'


POST request:
ajax_request=true&type=setval&varName=slow_query_log&varValue=on&_nocache=1465473600358154148

Regards,
Szabolcs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.phpmyadmin.net/pipermail/developers/attachments/20160609/99a2ff77/attachment.html>


More information about the Developers mailing list