Elep

<div class="container">
  {% if is_superuser %}
    <h2>
      {{ get_icon('b_usrcheck') }}
      {{ 'Users having access to "%s"'|trans|format('<a href="' ~ database_url ~ get_common({'db': db}, '&') ~ '">' ~ db|escape('html') ~ '</a>')|raw }}
    </h2>

<form id="usersForm" action="{{ url('/server/privileges') }}" class="card mb-3">
      {{ get_hidden_inputs(db) }}

<div class="card-body">
        <div class="table-responsive jsresponsive">
          <table class="table table-striped table-hover w-auto">
            <thead>
              <tr>
                <th></th>
                <th scope="col">{% trans 'User name' %}</th>
                <th scope="col">{% trans 'Host name' %}</th>
                <th scope="col">{% trans 'Type' %}</th>
                <th scope="col">{% trans 'Privileges' %}</th>
                <th scope="col">{% trans 'Grant' %}</th>
                <th scope="col" colspan="2">{% trans 'Action' %}</th>
              </tr>
            </thead>

<tbody>
              {% for privilege in privileges %}
                {% set privileges_amount = privilege.privileges|length %}
                <tr>
                  <td{% if privileges_amount > 1 %} class="align-middle" rowspan="{{ privileges_amount }}"{% endif %}>
                    <input type="checkbox" class="checkall" name="selected_usr[]" id="checkbox_sel_users_{{ loop.index0 }}" value="
                        {{- privilege.user ~ '&amp;#27;' ~ privilege.host }}">
                  </td>
                  <td{% if privileges_amount > 1 %} class="align-middle" rowspan="{{ privileges_amount }}"{% endif %}>
                    {% if privilege.user is empty %}
                      <span class="text-danger">{% trans 'Any' %}</span>
                    {% else %}
                      {{ privilege.user }}
                    {% endif %}
                  </td>
                  <td{% if privileges_amount > 1 %} class="align-middle" rowspan="{{ privileges_amount }}"{% endif %}>
                    {{ privilege.host }}
                  </td>
                  {% for priv in privilege.privileges %}
                    <td>
                      {% if priv.type == 'g' %}
                        {% trans 'global' %}
                      {% elseif priv.type == 'd' %}
                        {% if priv.database == db|replace({'_': '\\_', '%': '\\%'}) %}
                          {% trans 'database-specific' %}
                        {% else %}
                          {% trans 'wildcard' %}: <code>{{ priv.database }}</code>
                        {% endif %}
                      {% elseif priv.type == 'r' %}
                        {% trans 'routine' %}
                      {% endif %}
                    </td>
                    <td>
                      <code>
                        {% if priv.type == 'r' %}
                          {{ priv.routine }}
                          ({{ priv.privileges|join(', ')|upper }})
                        {% else %}
                          {{ priv.privileges|join(', ')|raw }}
                        {% endif %}
                      </code>
                    </td>
                    <td>
                      {{ priv.has_grant ? 'Yes'|trans : 'No'|trans }}
                    </td>
                    <td>
                      {% if is_grantuser %}
                        <a class="edit_user_anchor" href="{{ url('/server/privileges', {
                          'username': privilege.user,
                          'hostname': privilege.host,
                          'dbname': priv.database != '*' ? priv.database,
                          'tablename': '',
                          'routinename': priv.routine ?? ''
                        }) }}">
                          {{ get_icon('b_usredit', 'Edit privileges'|trans) }}
                        </a>
                      {% endif %}
                    </td>
                    <td class="text-center">
                      <a class="export_user_anchor ajax" href="{{ url('/server/privileges', {
                        'username': privilege.user,
                        'hostname': privilege.host,
                        'export': true,
                        'initial': ''
                      }) }}">
                        {{ get_icon('b_tblexport', 'Export'|trans) }}
                      </a>
                    </td>
                  </tr>
                  {% if privileges_amount > 1 %}
                    <tr class="noclick">
                  {% endif %}
                {% endfor %}
              {% else %}
                <tr>
                  <td colspan="7">
                    {% trans 'No user found.' %}
                  </td>
                </tr>
              {% endfor %}
            </tbody>
          </table>
        </div>

<div>
          {{ get_image('select_all_arrow', 'With selected:'|trans, {'dir': text_dir, 'width': '38', 'height': '22'}) }}
          <input type="checkbox" id="usersForm_checkall" class="checkall_box" title="{% trans 'Check all' %}">
          <label for="usersForm_checkall">{% trans 'Check all' %}</label>
          <em class="with-selected">{% trans 'With selected:' %}</em>
          <button class="btn btn-link mult_submit" type="submit" name="submit_mult" value="export" title="{% trans 'Export' %}">
            {{ get_icon('b_tblexport', 'Export'|trans) }}
          </button>
        </div>
      </div>
    </form>
  {% else %}
    {{ 'Not enough privilege to view users.'|trans|error }}
  {% endif %}

{% if is_createuser %}
    <div>
      <a class="btn btn-primary" id="add_user_anchor" href="{{ url('/server/privileges', {
        'adduser': true,
        'dbname': db
      }) }}">
        {{ get_icon('b_usradd', 'Add user account'|trans) }}
      </a>
    </div>
  {% endif %}
</div>