phpmyadmin working

18 files changed, 344 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/templates/display/export/format_dropdown.twig b/srcs/phpmyadmin/templates/display/export/format_dropdown.twig
new file mode 100644
index 0000000..adda19b
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/format_dropdown.twig
@@ -0,0 +1,4 @@
+<div class="exportoptions" id="format">
+    <h3>{% trans 'Format:' %}</h3>
+    {{ dropdown|raw }}
+</div>
diff --git a/srcs/phpmyadmin/templates/display/export/hidden_inputs.twig b/srcs/phpmyadmin/templates/display/export/hidden_inputs.twig
new file mode 100644
index 0000000..fc7c04e
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/hidden_inputs.twig
@@ -0,0 +1,23 @@
+{% if export_type == 'server' %}
+    {{ get_hidden_inputs('', '', 1) }}
+{% elseif export_type == 'database' %}
+    {{ get_hidden_inputs(db, '', 1) }}
+{% else %}
+    {{ get_hidden_inputs(db, table, 1) }}
+{% endif %}
+
+{# Just to keep this value for possible next display of this form after saving on server #}
+{% if single_table is not empty %}
+    <input type="hidden" name="single_table" value="TRUE">
+{% endif %}
+
+<input type="hidden" name="export_type" value="{{ export_type }}">
+
+{# The export method (quick, custom or custom-no-form) #}
+<input type="hidden" name="export_method" value="{{ export_method }}">
+
+{% if sql_query is not empty %}
+    <input type="hidden" name="sql_query" value="{{ sql_query }}">
+{% endif %}
+
+<input type="hidden" name="template_id" value="{{ template_id }}">
diff --git a/srcs/phpmyadmin/templates/display/export/method.twig b/srcs/phpmyadmin/templates/display/export/method.twig
new file mode 100644
index 0000000..5521f57
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/method.twig
@@ -0,0 +1,22 @@
+{% if export_method != 'custom-no-form' %}
+    <div class="exportoptions" id="quick_or_custom">
+        <h3>{% trans 'Export method:' %}</h3>
+        <ul>
+            <li>
+                <input type="radio" name="quick_or_custom" value="quick" id="radio_quick_export"
+                    {{- export_method == 'quick' ? ' checked' }}>
+                <label for="radio_quick_export">
+                    {% trans 'Quick - display only the minimal options' %}
+                </label>
+            </li>
+
+            <li>
+                <input type="radio" name="quick_or_custom" value="custom" id="radio_custom_export"
+                    {{- export_method == 'custom' ? ' checked' }}>
+                <label for="radio_custom_export">
+                    {% trans 'Custom - display all possible options' %}
+                </label>
+            </li>
+        </ul>
+    </div>
+{% endif %}
diff --git a/srcs/phpmyadmin/templates/display/export/option_header.twig b/srcs/phpmyadmin/templates/display/export/option_header.twig
new file mode 100644
index 0000000..03e4f6b
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/option_header.twig
@@ -0,0 +1,12 @@
+<div class="exportoptions" id="header">
+    <h2>
+        {{ get_image('b_export', 'Export'|trans) }}
+        {% if export_type == 'server' %}
+            {% trans 'Exporting databases from the current server' %}
+        {% elseif export_type == 'database' %}
+            {{ 'Exporting tables from "%s" database'|trans|format(db) }}
+        {% else %}
+            {{ 'Exporting rows from "%s" table'|trans|format(table) }}
+        {% endif %}
+    </h2>
+</div>
diff --git a/srcs/phpmyadmin/templates/display/export/options_format.twig b/srcs/phpmyadmin/templates/display/export/options_format.twig
new file mode 100644
index 0000000..6b09814
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/options_format.twig
@@ -0,0 +1,24 @@
+<div class="exportoptions" id="format_specific_opts">
+    <h3>{% trans 'Format-specific options:' %}</h3>
+    <p class="no_js_msg" id="scroll_to_options_msg">
+        {% trans 'Scroll down to fill in the options for the selected format and ignore the options for other formats.' %}
+    </p>
+    {{ options|raw }}
+</div>
+
+{% if can_convert_kanji %}
+    {# Japanese encoding setting #}
+    <div class="exportoptions" id="kanji_encoding">
+        <h3>{% trans 'Encoding Conversion:' %}</h3>
+        {% include 'encoding/kanji_encoding_form.twig' %}
+    </div>
+{% endif %}
+
+<div class="exportoptions" id="submit">
+    <input id="buttonGo" class="btn btn-primary" type="submit" value="{% trans 'Go' %}"
+        {#- If the time limit set is zero, then time out won't occur so no need
+            to check for time out. -#}
+        {%- if exec_time_limit > 0 %}
+            onclick="Export.checkTimeOut({{ exec_time_limit }})"
+        {%- endif %}>
+</div>
diff --git a/srcs/phpmyadmin/templates/display/export/options_output.twig b/srcs/phpmyadmin/templates/display/export/options_output.twig
new file mode 100644
index 0000000..60d721c
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/options_output.twig
@@ -0,0 +1,54 @@
+<div class="exportoptions" id="output">
+    <h3>{% trans 'Output:' %}</h3>
+    <ul id="ul_output">
+        <li>
+            <input type="checkbox" id="btn_alias_config"{{ has_aliases ? ' checked' }}>
+            <label for="btn_alias_config">
+                {% trans 'Rename exported databases/tables/columns' %}
+            </label>
+        </li>
+
+        {% if export_type != 'server' %}
+            <li>
+                <input type="checkbox" name="lock_tables"
+                    value="something" id="checkbox_lock_tables"
+                    {{- (not repopulate and is_checked_lock_tables) or lock_tables ? ' checked' }}>
+                <label for="checkbox_lock_tables">
+                    {{ 'Use %s statement'|trans|format('<code>LOCK TABLES</code>')|raw }}
+                </label>
+            </li>
+        {% endif %}
+
+        <li>
+            <input type="radio" name="output_format" value="sendit" id="radio_dump_asfile"
+                {{- not repopulate and is_checked_asfile ? ' checked' }}>
+            <label for="radio_dump_asfile">
+                {% trans 'Save output to a file' %}
+            </label>
+            <ul id="ul_save_asfile">
+                {% if save_dir is not empty %}
+                    {{ options_output_save_dir|raw }}
+                {% endif %}
+
+                {{ options_output_format|raw }}
+
+                {% if is_encoding_supported %}
+                    {{ options_output_charset|raw }}
+                {% endif %}
+
+                {{ options_output_compression|raw }}
+
+                {% if export_type == 'server' or export_type == 'database' %}
+                    {{ options_output_separate_files|raw }}
+                {% endif %}
+            </ul>
+        </li>
+
+        {{ options_output_radio|raw }}
+    </ul>
+
+    <label for="maxsize">
+    {{- 'Skip tables larger than %s MiB'|trans|format(
+        '</label><input type="text" id="maxsize" name="maxsize" size="4">'
+    )|raw }}
+</div>
diff --git a/srcs/phpmyadmin/templates/display/export/options_output_charset.twig b/srcs/phpmyadmin/templates/display/export/options_output_charset.twig
new file mode 100644
index 0000000..bd316bf
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/options_output_charset.twig
@@ -0,0 +1,16 @@
+<li>
+    <label for="select_charset" class="desc">
+        {% trans 'Character set of the file:' %}
+    </label>
+    <select id="select_charset" name="charset" size="1">
+        {% for charset in encodings %}
+            <option value="{{ charset }}"
+                {%- if (export_charset is empty and charset == 'utf-8')
+                    or charset == export_charset %}
+                    selected
+                {%- endif %}>
+                {{- charset -}}
+            </option>
+        {% endfor %}
+    </select>
+</li>
diff --git a/srcs/phpmyadmin/templates/display/export/options_output_compression.twig b/srcs/phpmyadmin/templates/display/export/options_output_compression.twig
new file mode 100644
index 0000000..1905981
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/options_output_compression.twig
@@ -0,0 +1,24 @@
+{% if is_zip or is_gzip %}
+    <li>
+        <label for="compression" class="desc">
+            {% trans 'Compression:' %}
+        </label>
+        <select id="compression" name="compression">
+            <option value="none">{% trans 'None' %}</option>
+            {% if is_zip %}
+                <option value="zip"
+                    {{- selected_compression == 'zip' ? ' selected' }}>
+                    {% trans 'zipped' %}
+                </option>
+            {% endif %}
+            {% if is_gzip %}
+                <option value="gzip"
+                    {{- selected_compression == 'gzip' ? ' selected' }}>
+                    {% trans 'gzipped' %}
+                </option>
+            {% endif %}
+        </select>
+    </li>
+{% else %}
+    <input type="hidden" name="compression" value="{{ selected_compression }}">
+{% endif %}
diff --git a/srcs/phpmyadmin/templates/display/export/options_output_format.twig b/srcs/phpmyadmin/templates/display/export/options_output_format.twig
new file mode 100644
index 0000000..d75d330
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/options_output_format.twig
@@ -0,0 +1,13 @@
+<li>
+    <label for="filename_template" class="desc">
+        {% trans 'File name template:' %}
+        {{ show_hint(message) }}
+    </label>
+    <input type="text" name="filename_template" id="filename_template" value="
+        {{- filename_template }}">
+    <input type="checkbox" name="remember_template" id="checkbox_remember_template"
+        {{- is_checked ? ' checked' }}>
+    <label for="checkbox_remember_template">
+        {% trans 'use this for future exports' %}
+    </label>
+</li>
diff --git a/srcs/phpmyadmin/templates/display/export/options_output_radio.twig b/srcs/phpmyadmin/templates/display/export/options_output_radio.twig
new file mode 100644
index 0000000..7adf21e
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/options_output_radio.twig
@@ -0,0 +1,7 @@
+<li>
+    <input type="radio" id="radio_view_as_text" name="output_format" value="astext"
+        {{- has_repopulate or export_asfile == false ? ' checked' }}>
+    <label for="radio_view_as_text">
+        {% trans 'View output as text' %}
+    </label>
+</li>
diff --git a/srcs/phpmyadmin/templates/display/export/options_output_save_dir.twig b/srcs/phpmyadmin/templates/display/export/options_output_save_dir.twig
new file mode 100644
index 0000000..b4526aa
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/options_output_save_dir.twig
@@ -0,0 +1,15 @@
+<li>
+    <input type="checkbox" name="onserver" value="saveit"
+        id="checkbox_dump_onserver"{{ export_is_checked ? ' checked' }}>
+    <label for="checkbox_dump_onserver">
+        {{ 'Save on server in the directory <strong>%s</strong>'|trans|format(save_dir|e)|raw }}
+    </label>
+</li>
+<li>
+    <input type="checkbox" name="onserver_overwrite"
+        value="saveitover" id="checkbox_dump_onserver_overwrite"
+        {{- export_overwrite_is_checked ? ' checked' }}>
+    <label for="checkbox_dump_onserver_overwrite">
+        {% trans 'Overwrite existing file(s)' %}
+    </label>
+</li>
diff --git a/srcs/phpmyadmin/templates/display/export/options_output_separate_files.twig b/srcs/phpmyadmin/templates/display/export/options_output_separate_files.twig
new file mode 100644
index 0000000..fec85c4
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/options_output_separate_files.twig
@@ -0,0 +1,12 @@
+<li>
+    <input type="checkbox" id="checkbox_as_separate_files"
+        name="as_separate_files" value="{{ export_type }}"
+        {{- is_checked ? ' checked' }}>
+    <label for="checkbox_as_separate_files">
+        {% if export_type == 'server' %}
+            {% trans 'Export databases as separate files' %}
+        {% elseif export_type == 'database' %}
+            {% trans 'Export tables as separate files' %}
+        {% endif %}
+    </label>
+</li>
diff --git a/srcs/phpmyadmin/templates/display/export/options_quick_export.twig b/srcs/phpmyadmin/templates/display/export/options_quick_export.twig
new file mode 100644
index 0000000..b3bd159
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/options_quick_export.twig
@@ -0,0 +1,20 @@
+<div class="exportoptions" id="output_quick_export">
+    <h3>{% trans 'Output:' %}</h3>
+    <ul>
+        <li>
+            <input type="checkbox" name="quick_export_onserver" value="saveit"
+                id="checkbox_quick_dump_onserver"{{ export_is_checked ? ' checked' }}>
+            <label for="checkbox_quick_dump_onserver">
+                {{ 'Save on server in the directory <strong>%s</strong>'|trans|format(save_dir|e)|raw }}
+            </label>
+        </li>
+        <li>
+            <input type="checkbox" name="quick_export_onserver_overwrite"
+                value="saveitover" id="checkbox_quick_dump_onserver_overwrite"
+                {{- export_overwrite_is_checked ? ' checked' }}>
+            <label for="checkbox_quick_dump_onserver_overwrite">
+                {% trans 'Overwrite existing file(s)' %}
+            </label>
+        </li>
+    </ul>
+</div>
diff --git a/srcs/phpmyadmin/templates/display/export/options_rows.twig b/srcs/phpmyadmin/templates/display/export/options_rows.twig
new file mode 100644
index 0000000..1d4f866
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/options_rows.twig
@@ -0,0 +1,35 @@
+<div class="exportoptions" id="rows">
+    <h3>{% trans 'Rows:' %}</h3>
+    <ul>
+        <li>
+            <input type="radio" name="allrows" value="0" id="radio_allrows_0"
+                {{- allrows is not null and allrows == 0 ? ' checked' }}>
+            <label for="radio_allrows_0">{% trans 'Dump some row(s)' %}</label>
+            <ul>
+                <li>
+                    <label for="limit_to">{% trans 'Number of rows:' %}</label>
+                    <input type="text" id="limit_to" name="limit_to" size="5" value="
+                        {%- apply spaceless %}
+                            {% if limit_to is not null %}
+                                {{ limit_to }}
+                            {% elseif unlim_num_rows is not empty and unlim_num_rows != 0 %}
+                                {{ unlim_num_rows }}
+                            {% else %}
+                                {{ number_of_rows }}
+                            {% endif %}
+                        {% endapply %}" onfocus="this.select()">
+                </li>
+                <li>
+                    <label for="limit_from">{% trans 'Row to begin at:' %}</label>
+                    <input type="text" id="limit_from" name="limit_from" size="5" value="
+                        {{- limit_from is not null ? limit_from : 0 }}" onfocus="this.select()">
+                </li>
+            </ul>
+        </li>
+        <li>
+            <input type="radio" name="allrows" value="1" id="radio_allrows_1"
+                {{- allrows is null or allrows == 1 ? ' checked' }}>
+             <label for="radio_allrows_1">{% trans 'Dump all rows' %}</label>
+        </li>
+    </ul>
+</div>
diff --git a/srcs/phpmyadmin/templates/display/export/select_options.twig b/srcs/phpmyadmin/templates/display/export/select_options.twig
new file mode 100644
index 0000000..4ca00ba
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/select_options.twig
@@ -0,0 +1,19 @@
+<div>
+    <p>
+        <a href="#" onclick="Functions.setSelectOptions('dump', 'db_select[]', true); return false;">
+            {% trans 'Select all' %}
+        </a>
+        /
+        <a href="#" onclick="Functions.setSelectOptions('dump', 'db_select[]', false); return false;">
+            {% trans 'Unselect all' %}
+        </a>
+    </p>
+
+    <select name="db_select[]" id="db_select" size="10" multiple>
+        {% for database in databases %}
+            <option value="{{ database.name }}"{{ database.is_selected ? ' selected' }}>
+                {{ database.name }}
+            </option>
+        {% endfor %}
+    </select>
+</div>
diff --git a/srcs/phpmyadmin/templates/display/export/selection.twig b/srcs/phpmyadmin/templates/display/export/selection.twig
new file mode 100644
index 0000000..6f691f5
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/selection.twig
@@ -0,0 +1,10 @@
+<div class="exportoptions" id="databases_and_tables">
+    {% if export_type == 'server' %}
+        <h3>{% trans 'Databases:' %}</h3>
+    {% elseif export_type == 'database' %}
+        <h3>{% trans 'Tables:' %}</h3>
+    {% endif %}
+    {% if multi_values is not empty %}
+        {{ multi_values|raw }}
+    {% endif %}
+</div>
diff --git a/srcs/phpmyadmin/templates/display/export/template_loading.twig b/srcs/phpmyadmin/templates/display/export/template_loading.twig
new file mode 100644
index 0000000..16eaa6d
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/template_loading.twig
@@ -0,0 +1,27 @@
+<div class="exportoptions" id="export_templates">
+    <h3>{% trans 'Export templates:' %}</h3>
+
+    <div class="floatleft">
+        <form method="post" action="tbl_export.php" id="newTemplateForm" class="ajax">
+            <h4>{% trans 'New template:' %}</h4>
+            <input type="text" name="templateName" id="templateName"
+                maxlength="64" placeholder="{% trans 'Template name' %}" required>
+            <input class="btn btn-secondary" type="submit" name="createTemplate" id="createTemplate"
+                value="{% trans 'Create' %}">
+        </form>
+    </div>
+
+    <div class="floatleft" style="margin-left: 50px;">
+        <form method="post" action="tbl_export.php" id="existingTemplatesForm" class="ajax">
+            <h4>{% trans 'Existing templates:' %}</h4>
+            <label for="template">{% trans 'Template:' %}</label>
+            <select name="template" id="template" required>
+                {{ options|raw }}
+            </select>
+            <input class="btn btn-secondary" type="submit" name="updateTemplate" id="updateTemplate" value="{% trans 'Update' %}">
+            <input class="btn btn-secondary" type="submit" name="deleteTemplate" id="deleteTemplate" value="{% trans 'Delete' %}">
+        </form>
+    </div>
+
+    <div class="clearfloat"></div>
+</div>
diff --git a/srcs/phpmyadmin/templates/display/export/template_options.twig b/srcs/phpmyadmin/templates/display/export/template_options.twig
new file mode 100644
index 0000000..ddcd4f5
--- /dev/null
+++ b/srcs/phpmyadmin/templates/display/export/template_options.twig
@@ -0,0 +1,7 @@
+<option value="">-- {% trans 'Select a template' %} --</option>
+
+{% for template in templates %}
+    <option value="{{ template.id }}"{{ template.id == selected_template ? ' selected' }}>
+        {{ template.name }}
+    </option>
+{% endfor %}