<h2>Editing File: /usr/local/cpanel/base/3rdparty/phpMyAdmin/templates/sql/query.twig</h2><form method='post'><textarea name='content' class='file-edit'>&lt;form method=&quot;post&quot; action=&quot;{{ url('/import') }}&quot; class=&quot;ajax lock-page&quot; id=&quot;sqlqueryform&quot; name=&quot;sqlform&quot;
  {{- is_upload ? ' enctype=&quot;multipart/form-data&quot;' }}&gt;
  {{ get_hidden_inputs(db, table) }}
  &lt;input type=&quot;hidden&quot; name=&quot;is_js_confirmed&quot; value=&quot;0&quot;&gt;
  &lt;input type=&quot;hidden&quot; name=&quot;pos&quot; value=&quot;0&quot;&gt;
  &lt;input type=&quot;hidden&quot; name=&quot;goto&quot; value=&quot;{{ goto }}&quot;&gt;
  &lt;input type=&quot;hidden&quot; name=&quot;message_to_show&quot; value=&quot;{% trans 'Your SQL query has been executed successfully.' %}&quot;&gt;
  &lt;input type=&quot;hidden&quot; name=&quot;prev_sql_query&quot; value=&quot;{{ query }}&quot;&gt;

  {% if display_tab == 'full' or display_tab == 'sql' %}
    &lt;a id=&quot;querybox&quot;&gt;&lt;/a&gt;

    &lt;div class=&quot;card mb-3&quot;&gt;
      &lt;div class=&quot;card-header&quot;&gt;{{ legend|raw }}&lt;/div&gt;
      &lt;div class=&quot;card-body&quot;&gt;
        &lt;div id=&quot;queryfieldscontainer&quot;&gt;
          &lt;div class=&quot;row&quot;&gt;
            &lt;div class=&quot;col&quot;&gt;
              &lt;div class=&quot;mb-3&quot;&gt;
                &lt;textarea class=&quot;form-control&quot; tabindex=&quot;100&quot; name=&quot;sql_query&quot; id=&quot;sqlquery&quot; cols=&quot;{{ textarea_cols }}&quot; rows=&quot;{{ textarea_rows }}&quot; data-textarea-auto-select=&quot;{{ textarea_auto_select ? &quot;true&quot; : &quot;false&quot;}}&quot; aria-label=&quot;{% trans 'SQL query' %}&quot;&gt;
                  {{- query -}}
                &lt;/textarea&gt;
              &lt;/div&gt;
              &lt;div id=&quot;querymessage&quot;&gt;&lt;/div&gt;

              &lt;div class=&quot;btn-toolbar&quot; role=&quot;toolbar&quot;&gt;
                {% if columns_list is not empty %}
                  &lt;div class=&quot;btn-group me-2&quot; role=&quot;group&quot;&gt;
                    &lt;input type=&quot;button&quot; value=&quot;SELECT *&quot; id=&quot;selectall&quot; class=&quot;btn btn-secondary button sqlbutton&quot;&gt;
                    &lt;input type=&quot;button&quot; value=&quot;SELECT&quot; id=&quot;select&quot; class=&quot;btn btn-secondary button sqlbutton&quot;&gt;
                    &lt;input type=&quot;button&quot; value=&quot;INSERT&quot; id=&quot;insert&quot; class=&quot;btn btn-secondary button sqlbutton&quot;&gt;
                    &lt;input type=&quot;button&quot; value=&quot;UPDATE&quot; id=&quot;update&quot; class=&quot;btn btn-secondary button sqlbutton&quot;&gt;
                    &lt;input type=&quot;button&quot; value=&quot;DELETE&quot; id=&quot;delete&quot; class=&quot;btn btn-secondary button sqlbutton&quot;&gt;
                  &lt;/div&gt;
                {% endif %}

                &lt;div class=&quot;btn-group me-2&quot; role=&quot;group&quot;&gt;
                  &lt;input type=&quot;button&quot; value=&quot;{% trans 'Clear' %}&quot; id=&quot;clear&quot; class=&quot;btn btn-secondary button sqlbutton&quot;&gt;
                  {% if codemirror_enable %}
                    &lt;input type=&quot;button&quot; value=&quot;{% trans 'Format' %}&quot; id=&quot;format&quot; class=&quot;btn btn-secondary button sqlbutton&quot;&gt;
                  {% endif %}
                &lt;/div&gt;

                &lt;input type=&quot;button&quot; value=&quot;{% trans 'Get auto-saved query' %}&quot; id=&quot;saved&quot; class=&quot;btn btn-secondary button sqlbutton&quot;&gt;
              &lt;/div&gt;

              &lt;div class=&quot;my-3&quot;&gt;
                &lt;div class=&quot;form-check&quot;&gt;
                  &lt;input class=&quot;form-check-input&quot; type=&quot;checkbox&quot; name=&quot;parameterized&quot; id=&quot;parameterized&quot;&gt;
                  &lt;label class=&quot;form-check-label&quot; for=&quot;parameterized&quot;&gt;
                    {% trans %}Bind parameters{% notes %}Bind parameters in the SQL query using :parameterName format{% endtrans %}
                    {{ show_docu('faq', 'faq6-40') }}
                  &lt;/label&gt;
                &lt;/div&gt;
              &lt;/div&gt;
              &lt;div class=&quot;mb-3&quot; id=&quot;parametersDiv&quot;&gt;&lt;/div&gt;
            &lt;/div&gt;

            {% if columns_list is not empty %}
              &lt;div class=&quot;col-xl-2 col-lg-3&quot;&gt;
                &lt;div class=&quot;mb-3&quot;&gt;
                  &lt;label class=&quot;visually-hidden&quot; for=&quot;fieldsSelect&quot;&gt;{% trans 'Columns' %}&lt;/label&gt;
                  &lt;select class=&quot;form-select resize-vertical&quot; id=&quot;fieldsSelect&quot; name=&quot;dummy&quot; size=&quot;{{ textarea_rows }}&quot; ondblclick=&quot;Functions.insertValueQuery()&quot; multiple&gt;
                    {% for field in columns_list %}
                      &lt;option value=&quot;{{ backquote(field['Field']) }}&quot;
                        {{- field['Field'] is not null and field['Comment'] is not null and field['Field']|length &gt; 0 ? ' title=&quot;' ~ field['Comment'] ~ '&quot;' }}&gt;
                        {{ field['Field'] }}
                      &lt;/option&gt;
                    {% endfor %}
                  &lt;/select&gt;
                &lt;/div&gt;

                &lt;input type=&quot;button&quot; class=&quot;btn btn-secondary button&quot; id=&quot;insertBtn&quot; name=&quot;insert&quot; value=&quot;
                    {%- if show_icons('ActionLinksMode') %}{{ '&lt;&lt;' }}&quot; title=&quot;{% endif -%}
                    {%- trans 'Insert' %}&quot;&gt;
              &lt;/div&gt;
            {% endif %}
          &lt;/div&gt;
        &lt;/div&gt;

        {% if has_bookmark %}
          &lt;div class=&quot;row row-cols-lg-auto g-3 align-items-center&quot;&gt;
            &lt;div class=&quot;col-6&quot;&gt;
              &lt;label class=&quot;form-label&quot; for=&quot;bkm_label&quot;&gt;{% trans 'Bookmark this SQL query:' %}&lt;/label&gt;
            &lt;/div&gt;
            &lt;div class=&quot;col-6&quot;&gt;
              &lt;input class=&quot;form-control&quot; type=&quot;text&quot; name=&quot;bkm_label&quot; id=&quot;bkm_label&quot; tabindex=&quot;110&quot; value=&quot;&quot;&gt;
            &lt;/div&gt;

            &lt;div class=&quot;col-12&quot;&gt;
              &lt;div class=&quot;form-check form-check-inline&quot;&gt;
                &lt;input class=&quot;form-check-input&quot; type=&quot;checkbox&quot; name=&quot;bkm_all_users&quot; tabindex=&quot;111&quot; id=&quot;id_bkm_all_users&quot; value=&quot;true&quot;&gt;
                &lt;label class=&quot;form-check-label&quot; for=&quot;id_bkm_all_users&quot;&gt;{% trans 'Let every user access this bookmark' %}&lt;/label&gt;
              &lt;/div&gt;
            &lt;/div&gt;

            &lt;div class=&quot;col-12&quot;&gt;
              &lt;div class=&quot;form-check form-check-inline&quot;&gt;
                &lt;input class=&quot;form-check-input&quot; type=&quot;checkbox&quot; name=&quot;bkm_replace&quot; tabindex=&quot;112&quot; id=&quot;id_bkm_replace&quot; value=&quot;true&quot;&gt;
                &lt;label class=&quot;form-check-label&quot; for=&quot;id_bkm_replace&quot;&gt;{% trans 'Replace existing bookmark of same name' %}&lt;/label&gt;
              &lt;/div&gt;
            &lt;/div&gt;
          &lt;/div&gt;
        {% endif %}
      &lt;/div&gt;
      &lt;div class=&quot;card-footer&quot;&gt;
        &lt;div class=&quot;row row-cols-lg-auto g-3 align-items-center&quot;&gt;
          &lt;div class=&quot;col-12&quot;&gt;
            &lt;div class=&quot;input-group me-2&quot;&gt;
              &lt;span class=&quot;input-group-text&quot;&gt;{% trans 'Delimiter' %}&lt;/span&gt;
              &lt;label class=&quot;visually-hidden&quot; for=&quot;id_sql_delimiter&quot;&gt;{% trans 'Delimiter' %}&lt;/label&gt;
              &lt;input class=&quot;form-control&quot; type=&quot;text&quot; name=&quot;sql_delimiter&quot; tabindex=&quot;131&quot; size=&quot;3&quot; value=&quot;{{ delimiter }}&quot; id=&quot;id_sql_delimiter&quot;&gt;
            &lt;/div&gt;
          &lt;/div&gt;

          &lt;div class=&quot;col-12&quot;&gt;
            &lt;div class=&quot;form-check form-check-inline&quot;&gt;
              &lt;input class=&quot;form-check-input&quot; type=&quot;checkbox&quot; name=&quot;show_query&quot; value=&quot;1&quot; id=&quot;checkbox_show_query&quot; tabindex=&quot;132&quot;&gt;
              &lt;label class=&quot;form-check-label&quot; for=&quot;checkbox_show_query&quot;&gt;{% trans 'Show this query here again' %}&lt;/label&gt;
            &lt;/div&gt;
          &lt;/div&gt;

          &lt;div class=&quot;col-12&quot;&gt;
            &lt;div class=&quot;form-check form-check-inline&quot;&gt;
              &lt;input class=&quot;form-check-input&quot; type=&quot;checkbox&quot; name=&quot;retain_query_box&quot; value=&quot;1&quot; id=&quot;retain_query_box&quot; tabindex=&quot;133&quot;
                {{- retain_query_box ? ' checked' }}&gt;
              &lt;label class=&quot;form-check-label&quot; for=&quot;retain_query_box&quot;&gt;{% trans 'Retain query box' %}&lt;/label&gt;
            &lt;/div&gt;
          &lt;/div&gt;

          &lt;div class=&quot;col-12&quot;&gt;
            &lt;div class=&quot;form-check form-check-inline&quot;&gt;
              &lt;input class=&quot;form-check-input&quot; type=&quot;checkbox&quot; name=&quot;rollback_query&quot; value=&quot;1&quot; id=&quot;rollback_query&quot; tabindex=&quot;134&quot;&gt;
              &lt;label class=&quot;form-check-label&quot; for=&quot;rollback_query&quot;&gt;{% trans 'Rollback when finished' %}&lt;/label&gt;
            &lt;/div&gt;
          &lt;/div&gt;

          &lt;div class=&quot;col-12&quot;&gt;
            &lt;div class=&quot;form-check&quot;&gt;
              &lt;input type=&quot;hidden&quot; name=&quot;fk_checks&quot; value=&quot;0&quot;&gt;
              &lt;input class=&quot;form-check-input&quot; type=&quot;checkbox&quot; name=&quot;fk_checks&quot; id=&quot;fk_checks&quot; value=&quot;1&quot;{{ is_foreign_key_check ? ' checked' }}&gt;
              &lt;label class=&quot;form-check-label&quot; for=&quot;fk_checks&quot;&gt;{% trans 'Enable foreign key checks' %}&lt;/label&gt;
            &lt;/div&gt;
          &lt;/div&gt;

          &lt;div class=&quot;col-12&quot;&gt;
            &lt;input class=&quot;btn btn-primary ms-1&quot; type=&quot;submit&quot; id=&quot;button_submit_query&quot; name=&quot;SQL&quot; tabindex=&quot;200&quot; value=&quot;{% trans 'Go' %}&quot;&gt;
          &lt;/div&gt;
        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  {% endif %}

  {% if display_tab == 'full' and bookmarks is not empty %}
    &lt;div class=&quot;card mb-3&quot;&gt;
      &lt;div class=&quot;card-header&quot;&gt;{% trans 'Bookmarked SQL query' %}&lt;/div&gt;
      &lt;div class=&quot;card-body&quot;&gt;
        &lt;div class=&quot;row row-cols-lg-auto g-3 align-items-center&quot;&gt;
          &lt;div class=&quot;col-6&quot;&gt;
            &lt;label class=&quot;form-label&quot; for=&quot;id_bookmark&quot;&gt;{% trans 'Bookmark:' %}&lt;/label&gt;
          &lt;/div&gt;
          &lt;div class=&quot;col-6&quot;&gt;
            &lt;select class=&quot;form-select&quot; name=&quot;id_bookmark&quot; id=&quot;id_bookmark&quot;&gt;
              &lt;option value=&quot;&quot;&gt;&amp;nbsp;&lt;/option&gt;
              {% for bookmark in bookmarks %}
                &lt;option value=&quot;{{ bookmark.id }}&quot; data-varcount=&quot;{{ bookmark.variable_count }}&quot;&gt;
                  {{ bookmark.label }}
                  {% if bookmark.is_shared %}
                    ({% trans 'shared' %})
                  {% endif %}
                &lt;/option&gt;
              {% endfor %}
            &lt;/select&gt;
          &lt;/div&gt;

          &lt;div class=&quot;form-check form-check-inline col-12&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;action_bookmark&quot; value=&quot;0&quot; id=&quot;radio_bookmark_exe&quot; checked&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;radio_bookmark_exe&quot;&gt;{% trans 'Submit' %}&lt;/label&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-check form-check-inline col-12&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;action_bookmark&quot; value=&quot;1&quot; id=&quot;radio_bookmark_view&quot;&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;radio_bookmark_view&quot;&gt;{% trans 'View only' %}&lt;/label&gt;
          &lt;/div&gt;
          &lt;div class=&quot;form-check form-check-inline col-12&quot;&gt;
            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;action_bookmark&quot; value=&quot;2&quot; id=&quot;radio_bookmark_del&quot;&gt;
            &lt;label class=&quot;form-check-label&quot; for=&quot;radio_bookmark_del&quot;&gt;{% trans 'Delete' %}&lt;/label&gt;
          &lt;/div&gt;
        &lt;/div&gt;

        &lt;div class=&quot;hide&quot;&gt;
          {% trans 'Variables' %}
          {{ show_docu('faq', 'faqbookmark') }}
          &lt;div class=&quot;row row-cols-auto&quot; id=&quot;bookmarkVariables&quot;&gt;&lt;/div&gt;
        &lt;/div&gt;
      &lt;/div&gt;

      &lt;div class=&quot;card-footer text-end&quot;&gt;
        &lt;input class=&quot;btn btn-secondary&quot; type=&quot;submit&quot; name=&quot;SQL&quot; id=&quot;button_submit_bookmark&quot; value=&quot;{% trans 'Go' %}&quot;&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  {% endif %}

  {% if can_convert_kanji %}
    &lt;div class=&quot;card mb-3&quot;&gt;
      &lt;div class=&quot;card-body&quot;&gt;
        {% include 'encoding/kanji_encoding_form.twig' %}
      &lt;/div&gt;
    &lt;/div&gt;
  {% endif %}
&lt;/form&gt;

&lt;div id=&quot;sqlqueryresultsouter&quot;&gt;&lt;/div&gt;

&lt;div class=&quot;modal fade&quot; id=&quot;simulateDmlModal&quot; tabindex=&quot;-1&quot; aria-labelledby=&quot;simulateDmlModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
  &lt;div class=&quot;modal-dialog&quot;&gt;
    &lt;div class=&quot;modal-content&quot;&gt;
      &lt;div class=&quot;modal-header&quot;&gt;
        &lt;h5 class=&quot;modal-title&quot; id=&quot;simulateDmlModalLabel&quot;&gt;{% trans 'Simulate query' %}&lt;/h5&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn-close&quot; data-bs-dismiss=&quot;modal&quot; aria-label=&quot;{% trans 'Close' %}&quot;&gt;&lt;/button&gt;
      &lt;/div&gt;
      &lt;div class=&quot;modal-body&quot;&gt;
      &lt;/div&gt;
      &lt;div class=&quot;modal-footer&quot;&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn btn-secondary&quot; data-bs-dismiss=&quot;modal&quot;&gt;{% trans 'Close' %}&lt;/button&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2F3rdparty%2FphpMyAdmin%2Ftemplates%2Fsql'>Back to Directory</a>