1#@!#!123s

: / opt / psa / phpMyAdmin / templates / server / binlog /
Filename : index.twig
back
<h2>
  {{ get_image('s_tbl') }}
  {% trans 'Binary log' %}
</h2>

<form action="{{ url('/server/binlog') }}" method="post">
  {{ get_hidden_inputs(url_params) }}
  <fieldset class="pma-fieldset">
    <legend>
      {% trans 'Select binary log to view' %}
    </legend>

    {% set full_size = 0 %}
    <select name="log">
      {% for each_log in binary_logs %}
        <option value="{{ each_log['Log_name'] }}"
          {{- each_log['Log_name'] == log ? ' selected' }}>
          {{ each_log['Log_name'] }}
          {% if each_log['File_size'] is defined %}
            ({{ format_byte_down(each_log['File_size'], 3, 2)|join(' ') }})
            {% set full_size = full_size + each_log['File_size'] %}
          {% endif %}
        </option>
      {% endfor %}
    </select>
    {{ binary_logs|length }}
    {% trans 'Files' %},
    {% if full_size > 0 %}
      {{ format_byte_down(full_size)|join(' ') }}
    {% endif %}
  </fieldset>

  <fieldset class="pma-fieldset tblFooters">
    <input class="btn btn-primary" type="submit" value="{% trans 'Go' %}">
  </fieldset>
</form>

{{ sql_message|raw }}

<table class="table table-striped table-hover align-middle" id="binlogTable">
  <thead>
    <tr>
      <td colspan="6" class="text-center">
        {% if has_previous %}
          {% if has_icons %}
            <a href="{{ url('/server/binlog') }}" data-post="{{ get_common(previous_params, '', false) }}" title="
                {%- trans %}Previous{% context %}Previous page{% endtrans %}">
              &laquo;
            </a>
          {% else %}
            <a href="{{ url('/server/binlog') }}" data-post="{{ get_common(previous_params, '', false) }}">
              {% trans %}Previous{% context %}Previous page{% endtrans %} &laquo;
            </a>
          {% endif %}
          -
        {% endif %}

        {% if is_full_query %}
          <a href="{{ url('/server/binlog') }}" data-post="{{ get_common(full_queries_params, '', false) }}" title="{% trans 'Truncate shown queries' %}">
            <img src="{{ image('s_partialtext.png') }}" alt="{% trans 'Truncate shown queries' %}">
          </a>
        {% else %}
          <a href="{{ url('/server/binlog') }}" data-post="{{ get_common(full_queries_params, '', false) }}" title="{% trans 'Show full queries' %}">
            <img src="{{ image('s_fulltext.png') }}" alt="{% trans 'Show full queries' %}">
          </a>
        {% endif %}

        {% if has_next %}
          -
          {% if has_icons %}
            <a href="{{ url('/server/binlog') }}" data-post="{{ get_common(next_params, '', false) }}" title="
                {%- trans %}Next{% context %}Next page{% endtrans %}">
              &raquo;
            </a>
          {% else %}
            <a href="{{ url('/server/binlog') }}" data-post="{{ get_common(next_params, '', false) }}">
              {% trans %}Next{% context %}Next page{% endtrans %} &raquo;
            </a>
          {% endif %}
        {% endif %}
      </td>
    </tr>
    <tr class="text-nowrap">
      <th>{% trans 'Log name' %}</th>
      <th>{% trans 'Position' %}</th>
      <th>{% trans 'Event type' %}</th>
      <th>{% trans 'Server ID' %}</th>
      <th>{% trans 'Original position' %}</th>
      <th>{% trans 'Information' %}</th>
    </tr>
  </thead>

  <tbody>
    {% for value in values %}
      <tr class="noclick">
        <td>{{ value['Log_name'] }}</td>
        <td class="text-end">{{ value['Pos'] }}</td>
        <td>{{ value['Event_type'] }}</td>
        <td class="text-end">{{ value['Server_id'] }}</td>
        <td class="text-end">
          {{- value['Orig_log_pos'] is defined ? value['Orig_log_pos'] : value['End_log_pos'] -}}
        </td>
        <td>{{ format_sql(value['Info'], not is_full_query) }}</td>
      </tr>
    {% endfor %}
  </tbody>
</table>