From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Thu, 9 Jan 2020 10:55:03 +0100
Subject: phpmyadmin working

---
 .../server/privileges/add_user_fieldset.twig       |   8 ++
 .../server/privileges/choose_user_group.twig       |   9 ++
 .../server/privileges/column_privileges.twig       |  24 +++++
 .../server/privileges/delete_user_fieldset.twig    |  17 ++++
 .../server/privileges/edit_routine_privileges.twig |  26 ++++++
 .../server/privileges/global_priv_table.twig       |  22 +++++
 .../templates/server/privileges/initials_row.twig  |  26 ++++++
 .../server/privileges/privileges_summary.twig      | 104 +++++++++++++++++++++
 .../server/privileges/require_options.twig         |  32 +++++++
 .../server/privileges/resource_limits.twig         |  21 +++++
 10 files changed, 289 insertions(+)
 create mode 100644 srcs/phpmyadmin/templates/server/privileges/add_user_fieldset.twig
 create mode 100644 srcs/phpmyadmin/templates/server/privileges/choose_user_group.twig
 create mode 100644 srcs/phpmyadmin/templates/server/privileges/column_privileges.twig
 create mode 100644 srcs/phpmyadmin/templates/server/privileges/delete_user_fieldset.twig
 create mode 100644 srcs/phpmyadmin/templates/server/privileges/edit_routine_privileges.twig
 create mode 100644 srcs/phpmyadmin/templates/server/privileges/global_priv_table.twig
 create mode 100644 srcs/phpmyadmin/templates/server/privileges/initials_row.twig
 create mode 100644 srcs/phpmyadmin/templates/server/privileges/privileges_summary.twig
 create mode 100644 srcs/phpmyadmin/templates/server/privileges/require_options.twig
 create mode 100644 srcs/phpmyadmin/templates/server/privileges/resource_limits.twig

(limited to 'srcs/phpmyadmin/templates/server/privileges')

diff --git a/srcs/phpmyadmin/templates/server/privileges/add_user_fieldset.twig b/srcs/phpmyadmin/templates/server/privileges/add_user_fieldset.twig
new file mode 100644
index 0000000..26f0419
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/privileges/add_user_fieldset.twig
@@ -0,0 +1,8 @@
+<fieldset id="fieldset_add_user">
+    <legend>{% trans %}New{% context %}Create new user{% endtrans %}</legend>
+    <a id="add_user_anchor" href="server_privileges.php{{ get_common(url_params) }}"
+        {% if rel_params is not empty %}
+            rel="{{ get_common(rel_params) }}"
+        {% endif %}>
+        {{ get_icon('b_usradd') }}{% trans 'Add user account' %}</a>
+</fieldset>
diff --git a/srcs/phpmyadmin/templates/server/privileges/choose_user_group.twig b/srcs/phpmyadmin/templates/server/privileges/choose_user_group.twig
new file mode 100644
index 0000000..a28f302
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/privileges/choose_user_group.twig
@@ -0,0 +1,9 @@
+<form class="ajax" id="changeUserGroupForm" action="server_privileges.php" method="post">
+    {{ get_hidden_inputs(params) }}
+    <fieldset id="fieldset_user_group_selection">
+        <legend>{% trans 'User group' %}</legend>
+        {% trans 'User group' %}:
+        {{ get_dropdown('userGroup', all_user_groups, user_group, 'userGroup_select') }}
+        <input type="hidden" name="changeUserGroup" value="1">
+    </fieldset>
+</form>
diff --git a/srcs/phpmyadmin/templates/server/privileges/column_privileges.twig b/srcs/phpmyadmin/templates/server/privileges/column_privileges.twig
new file mode 100644
index 0000000..b49efa5
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/privileges/column_privileges.twig
@@ -0,0 +1,24 @@
+<div class="item" id="div_item_{{ name }}">
+    <label for="select_{{ name }}_priv">
+        <code><dfn title="{{ name_for_dfn }}">{{ priv_for_header }}</dfn></code>
+    </label>
+
+    <select id="select_{{ name }}_priv" name="{{ name_for_select }}[]" multiple="multiple" size="8">
+        {% for curr_col, curr_col_privs in columns %}
+            <option value="{{ curr_col }}"
+            {% if row[name_for_select] == 'Y' or curr_col_privs[name_for_current] %}
+                selected="selected"
+            {% endif %}>
+                {{ curr_col }}
+            </option>
+        {% endfor %}
+    </select>
+
+    <em>{% trans 'Or' %}</em>
+    <label for="checkbox_{{ name_for_select }}_none">
+        <input type="checkbox" name="{{ name_for_select }}_none"
+            id="checkbox_{{ name_for_select }}_none"
+            title="{% trans %}None{% context %}None privileges{% endtrans %}">
+            {% trans %}None{% context %}None privileges{% endtrans %}
+    </label>
+</div>
diff --git a/srcs/phpmyadmin/templates/server/privileges/delete_user_fieldset.twig b/srcs/phpmyadmin/templates/server/privileges/delete_user_fieldset.twig
new file mode 100644
index 0000000..84d288f
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/privileges/delete_user_fieldset.twig
@@ -0,0 +1,17 @@
+<fieldset id="fieldset_delete_user">
+    <legend>
+        {{ get_icon('b_usrdrop') }}{% trans 'Remove selected user accounts' %}
+    </legend>
+    <input type="hidden" name="mode" value="2">
+    <p>({% trans 'Revoke all active privileges from the users and delete them afterwards.' %})</p>
+    <input type="checkbox" title="{% trans 'Drop the databases that have the same names as the users.' %}"
+        name="drop_users_db" id="checkbox_drop_users_db">
+    <label for="checkbox_drop_users_db"
+        title="{% trans 'Drop the databases that have the same names as the users.' %}">
+        {% trans 'Drop the databases that have the same names as the users.' %}
+    </label>
+</fieldset>
+
+<fieldset id="fieldset_delete_user_footer" class="tblFooters">
+    <input id="buttonGo" class="btn btn-primary ajax" type="submit" name="delete" value="{% trans 'Go' %}">
+</fieldset>
diff --git a/srcs/phpmyadmin/templates/server/privileges/edit_routine_privileges.twig b/srcs/phpmyadmin/templates/server/privileges/edit_routine_privileges.twig
new file mode 100644
index 0000000..12f8433
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/privileges/edit_routine_privileges.twig
@@ -0,0 +1,26 @@
+<div id="edit_user_dialog">
+    {{ header|raw }}
+    <form class="submenu-item" name="usersForm" id="addUsersForm" action="server_privileges.php" method="post">
+        {{ get_hidden_inputs() }}
+        <input type="hidden" name="username" value="{{ username }}">
+        <input type="hidden" name="hostname" value="{{ hostname }}">
+        <input type="hidden" name="dbname" value="{{ database }}">
+        <input type="hidden" name="routinename" value="{{ routine }}">
+        <input type="hidden" name="grant_count" value="{{ grant_count }}">
+        <fieldset id="fieldset_user_global_rights">
+            <legend data-submenu-label="{% trans 'Routine' %}">
+                {% trans 'Routine-specific privileges' %}
+            </legend>
+            <p>
+                <small>
+                    <em>{% trans 'Note: MySQL privilege names are expressed in English.' %}</em>
+                </small>
+            </p>
+            {{ priv_checkboxes|raw }}
+        </fieldset>
+        <fieldset id="fieldset_user_privtable_footer" class="tblFooters">
+            <input type="hidden" name="update_privs" value="1">
+            <input class="btn btn-primary" type="submit" value="{% trans 'Go' %}">
+        </fieldset>
+    </form>
+</div>
diff --git a/srcs/phpmyadmin/templates/server/privileges/global_priv_table.twig b/srcs/phpmyadmin/templates/server/privileges/global_priv_table.twig
new file mode 100644
index 0000000..54b1046
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/privileges/global_priv_table.twig
@@ -0,0 +1,22 @@
+{% for key, table in priv_table %}
+    <fieldset>
+        <legend>
+            <input type="checkbox" class="sub_checkall_box" id="checkall_{{ priv_table_names[key] }}_priv"
+                title="{% trans 'Check all' %}">
+            <label for="checkall_{{ priv_table_names[key] }}_priv">{{ priv_table_names[key] }}</label>
+        </legend>
+        {% for priv in table %}
+            {% set checked = row[priv[0] ~ '_priv'] is defined and row[priv[0] ~ '_priv'] == 'Y' ? ' checked="checked"' %}
+            {% set formatted_priv = format_privilege(priv, true) %}
+            <div class="item">
+                <input type="checkbox" class="checkall" name="{{ priv[0] }}_priv" id="checkbox_{{ priv[0] }}_priv"
+                    value="Y" title="{{ priv[2] }}" {{ checked }}>
+                <label for="checkbox_{{ priv[0] }}_priv">
+                    <code>
+                        {{ formatted_priv|raw }}
+                    </code>
+                </label>
+            </div>
+        {% endfor %}
+    </fieldset>
+{% endfor %}
diff --git a/srcs/phpmyadmin/templates/server/privileges/initials_row.twig b/srcs/phpmyadmin/templates/server/privileges/initials_row.twig
new file mode 100644
index 0000000..feadc46
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/privileges/initials_row.twig
@@ -0,0 +1,26 @@
+<table id="initials_table" cellspacing="5">
+    <tr>
+        {% for tmp_initial, initial_was_found in array_initials %}
+          {% if tmp_initial is not same as(null) %}
+            {% if initial_was_found %}
+                <td>
+                    <a class="ajax
+                        {{- initial is defined and initial is same as(tmp_initial) ? ' active' -}}
+                        " href="server_privileges.php
+                        {{- get_common({'initial': tmp_initial}) }}">
+                        {{- tmp_initial|raw -}}
+                    </a>
+                </td>
+            {% else %}
+                <td>{{ tmp_initial|raw }}</td>
+            {% endif %}
+          {% endif %}
+        {% endfor %}
+        <td>
+            <a href="server_privileges.php
+                {{- get_common({'showall': 1}) }}" class="nowrap">
+                {% trans 'Show all' %}
+            </a>
+        </td>
+    </tr>
+</table>
diff --git a/srcs/phpmyadmin/templates/server/privileges/privileges_summary.twig b/srcs/phpmyadmin/templates/server/privileges/privileges_summary.twig
new file mode 100644
index 0000000..438ecb7
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/privileges/privileges_summary.twig
@@ -0,0 +1,104 @@
+<form class="submenu-item" action="server_privileges.php" id="{{ form_id }}" method="post">
+    {{ get_hidden_inputs() }}
+    <input type="hidden" name="username" value="{{ username }}">
+    <input type="hidden" name="hostname" value="{{ hostname }}">
+
+    <fieldset>
+        <legend data-submenu-label="{{ sub_menu_label }}">
+            {{ legend }}
+        </legend>
+
+        <table class="data">
+            <thead>
+                <tr>
+                    <th>{{ type_label }}</th>
+                    <th>{% trans 'Privileges' %}</th>
+                    <th>{% trans 'Grant' %}</th>
+                    {% if type == 'database' %}
+                        <th>{% trans 'Table-specific privileges' %}</th>
+                    {% elseif type == 'table' %}
+                        <th>{% trans 'Column-specific privileges' %}</th>
+                    {% endif %}
+                    <th colspan="2">{% trans 'Action' %}</th>
+                </tr>
+            </thead>
+
+            <tbody>
+                {% if privileges|length == 0 %}
+                    {% set colspan = type == 'database' ? 7 : (type == 'table' ? 6 : 5) %}
+                    <tr>
+                        <td colspan="{{ colspan }}"><center><em>{% trans 'None' %}</em></center></td>
+                    </tr>
+                {% else %}
+                    {% for privilege in privileges %}
+                        <tr>
+                            <td>{{ privilege['name'] }}</td>
+                            <td><code>{{ privilege['privileges']|raw }}</code></td>
+                            <td>{{ privilege['grant'] ? 'Yes'|trans : 'No'|trans }}</td>
+
+                            {% if type == 'database' %}
+                                <td>{{ privilege['table_privs'] ? 'Yes'|trans : 'No'|trans }}</td>
+                            {% elseif type == 'table' %}
+                                <td>{{ privilege['column_privs'] ? 'Yes'|trans : 'No'|trans }}</td>
+                            {% endif %}
+
+                            <td>{{ privilege['edit_link']|raw }}</td>
+                            <td>{{ privilege['revoke_link']|raw }}</td>
+                        </tr>
+                    {% endfor %}
+                {% endif %}
+            </tbody>
+        </table>
+
+        {% if type == 'database' %}
+            <label for="text_dbname">{% trans 'Add privileges on the following database(s):' %}</label>
+
+            {%- if databases is not empty %}
+                <select name="pred_dbname[]" multiple="multiple">
+                    {% for database in databases %}
+                        <option value="{{ database|escape_mysql_wildcards }}">
+                            {{ database }}
+                        </option>
+                    {% endfor %}
+                </select>
+            {% endif -%}
+
+            <input type="text" id="text_dbname" name="dbname">
+            {{ show_hint("Wildcards % and _ should be escaped with a \\ to use them literally."|trans) }}
+        {% elseif type == 'table' %}
+            <input type="hidden" name="dbname" value="{{ database }}">
+
+            <label for="text_tablename">{% trans 'Add privileges on the following table:' %}</label>
+
+            {%- if tables is not empty %}
+                <select name="pred_tablename" class="autosubmit">
+                    <option value="" selected="selected">{% trans 'Use text field' %}:</option>
+                    {% for table in tables %}
+                        <option value="{{ table }}">{{ table }}</option>
+                    {% endfor %}
+                </select>
+            {% endif -%}
+
+            <input type="text" id="text_tablename" name="tablename">
+        {% else %}
+            <input type="hidden" name="dbname" value="{{ database }}">
+
+            <label for="text_routinename">{% trans 'Add privileges on the following routine:' %}</label>
+
+            {%- if routines is not empty %}
+                <select name="pred_routinename" class="autosubmit">
+                    <option value="" selected="selected">{% trans 'Use text field' %}:</option>
+                    {% for routine in routines %}
+                        <option value="{{ routine }}">{{ routine }}</option>
+                    {% endfor %}
+                </select>
+            {% endif -%}
+
+            <input type="text" id="text_routinename" name="routinename">
+        {% endif %}
+    </fieldset>
+
+    <fieldset class="tblFooters">
+        <input class="btn btn-primary" type="submit" value="{% trans 'Go' %}">
+    </fieldset>
+</form>
diff --git a/srcs/phpmyadmin/templates/server/privileges/require_options.twig b/srcs/phpmyadmin/templates/server/privileges/require_options.twig
new file mode 100644
index 0000000..03da691
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/privileges/require_options.twig
@@ -0,0 +1,32 @@
+<fieldset>
+    <legend>SSL</legend>
+    <div id="require_ssl_div">
+        {% for require_option in require_options %}
+            {% if require_option['name'] is same as('ssl_cipher') %}
+                <div id="specified_div" style="padding-left:20px;">
+            {% endif %}
+            <div class="item">
+                {% if require_option['radio'] %}
+                    <input type="radio" name="ssl_type"
+                        id="{{ require_option['name'] }}_{{ require_option['value'] }}"
+                        title="{{ require_option['description'] }}"
+                        value="{{ require_option['value'] }}" {{ require_option['checked']|raw }}>
+                    <label for="{{ require_option['name'] }}_{{ require_option['value'] }}">
+                        <code>{{ require_option['label'] }}</code>
+                    </label>
+                {% else %}
+                    <label for="text_{{ require_option['name'] }}">
+                        <code>{{ require_option['label'] }}</code>
+                    </label>
+                    <input type="text" name="{{ require_option['name'] }}"
+                        id="text_{{ require_option['name'] }}" value="{{ require_option['value'] }}"
+                        size="80" title="{{ require_option['description'] }}"
+                        {%- if require_option['disabled'] %}
+                            disabled
+                        {%- endif %}>
+                {% endif %}
+            </div>
+        {% endfor %}
+        </div>{# END specified_div #}
+    </div>{# END require_ssl_div #}
+</fieldset>
diff --git a/srcs/phpmyadmin/templates/server/privileges/resource_limits.twig b/srcs/phpmyadmin/templates/server/privileges/resource_limits.twig
new file mode 100644
index 0000000..2569bd7
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/privileges/resource_limits.twig
@@ -0,0 +1,21 @@
+<fieldset>
+    <legend>{% trans 'Resource limits' %}</legend>
+    <p>
+        <small>
+            <em>{% trans 'Note: Setting these options to 0 (zero) removes the limit.' %}</em>
+        </small>
+    </p>
+    {% for limit in limits %}
+        <div class="item">
+            <label for="text_{{ limit['input_name'] }}">
+                <code>
+                <dfn title="{{ limit['description'] }}">
+                    {{ limit['name_main'] }}
+                </dfn>
+                </code>
+            </label>
+            <input type="number" name="{{ limit['input_name'] }}" id="text_{{ limit['input_name'] }}"
+                value="{{ limit['value'] }}" title="{{ limit['description'] }}">
+        </div>
+    {% endfor %}
+</fieldset>
-- 
cgit