diff options
| author | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
|---|---|---|
| committer | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
| commit | 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab (patch) | |
| tree | 39a1a4629749056191c05dfd899f931701b7acf3 /srcs/phpmyadmin/templates/table | |
| parent | 5afd237bbd22028b85532b8c0b3fcead49a00764 (diff) | |
| download | ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.gz ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.bz2 ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.zip | |
Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my famillyHEADmaster
Diffstat (limited to 'srcs/phpmyadmin/templates/table')
31 files changed, 0 insertions, 2680 deletions
diff --git a/srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig b/srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig deleted file mode 100644 index f2ec2ba..0000000 --- a/srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig +++ /dev/null @@ -1,12 +0,0 @@ -<td{{ nowrap ? ' class="nowrap"' }}> - {{ is_selected ? '<strong>' }} - <a class="foreign_value" data-key="{{ keyname }}" href="#" title=" - {%- trans 'Use this value' %}{{ title is not empty ? ': ' ~ title }}"> - {% if nowrap %} - {{ keyname }} - {% else %} - {{ description }} - {% endif %} - </a> - {{ is_selected ? '</strong>' }} -</td> diff --git a/srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig b/srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig deleted file mode 100644 index 4de9b81..0000000 --- a/srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig +++ /dev/null @@ -1,5 +0,0 @@ -{% if foreign_data.disp_row is iterable and - (show_all and foreign_data.the_total > max_rows) %} - <input class="btn btn-secondary" type="submit" id="foreign_showAll" name="foreign_showAll" value=" - {%- trans 'Show all' %}"> -{% endif %} diff --git a/srcs/phpmyadmin/templates/table/chart/tbl_chart.twig b/srcs/phpmyadmin/templates/table/chart/tbl_chart.twig deleted file mode 100644 index 4201599..0000000 --- a/srcs/phpmyadmin/templates/table/chart/tbl_chart.twig +++ /dev/null @@ -1,159 +0,0 @@ -<script type="text/javascript"> - url_query = '{{ url_query }}'; -</script> -{# Display Chart options #} -<div id="div_view_options"> - <form method="post" id="tblchartform" action="tbl_chart.php" class="ajax"> - {{ get_hidden_inputs(url_params) }} - <fieldset> - <legend> - {% trans 'Display chart' %} - </legend> - <div class="chartOption"> - <div class="formelement"> - <input type="radio" name="chartType" value="bar" id="radio_bar"> - <label for ="radio_bar">{% trans %}Bar{% context %}Chart type{% endtrans %}</label> - </div> - <div class="formelement"> - <input type="radio" name="chartType" value="column" id="radio_column"> - <label for ="radio_column">{% trans %}Column{% context %}Chart type{% endtrans %}</label> - </div> - <div class="formelement"> - <input type="radio" name="chartType" value="line" id="radio_line" checked="checked"> - <label for ="radio_line">{% trans %}Line{% context %}Chart type{% endtrans %}</label> - </div> - <div class="formelement"> - <input type="radio" name="chartType" value="spline" id="radio_spline"> - <label for ="radio_spline">{% trans %}Spline{% context %}Chart type{% endtrans %}</label> - </div> - <div class="formelement"> - <input type="radio" name="chartType" value="area" id="radio_area"> - <label for ="radio_area">{% trans %}Area{% context %}Chart type{% endtrans %}</label> - </div> - <span class="span_pie hide"> - <input type="radio" name="chartType" value="pie" id="radio_pie"> - <label for ="radio_pie">{% trans %}Pie{% context %}Chart type{% endtrans %}</label> - </span> - <span class="span_timeline hide"> - <input type="radio" name="chartType" value="timeline" id="radio_timeline"> - <label for ="radio_timeline">{% trans %}Timeline{% context %}Chart type{% endtrans %}</label> - </span> - <span class="span_scatter hide"> - <input type="radio" name="chartType" value="scatter" id="radio_scatter"> - <label for ="radio_scatter">{% trans %}Scatter{% context %}Chart type{% endtrans %}</label> - </span> - <br><br> - <span class="barStacked hide"> - <input type="checkbox" name="barStacked" value="1" id="checkbox_barStacked"> - <label for ="checkbox_barStacked">{% trans 'Stacked' %}</label> - </span> - <br><br> - <label for ="chartTitle">{% trans 'Chart title:' %}</label> - <input type="text" name="chartTitle" id="chartTitle"> - </div> - {% set xaxis = null %} - <div class="chartOption"> - <label for="select_chartXAxis">{% trans 'X-Axis:' %}</label> - <select name="chartXAxis" id="select_chartXAxis"> - {% for idx, key in keys %} - {% if xaxis is same as(null) %} - {% set xaxis = idx %} - {% endif %} - {% if xaxis is same as(idx) %} - <option value="{{ idx }}" selected="selected">{{ key }}</option> - {% else %} - <option value="{{ idx }}">{{ key }}</option> - {% endif %} - {% endfor %} - </select> - <br> - <label for="select_chartSeries"> - {% trans 'Series:' %} - </label> - <select name="chartSeries" id="select_chartSeries" multiple="multiple"> - {% for idx, key in keys %} - {% if fields_meta[idx].type in numeric_types %} - {% if idx == xaxis and numeric_column_count > 1 %} - <option value="{{ idx }}">{{ key }}</option> - {% else %} - <option value="{{ idx }}" selected="selected">{{ key }}</option> - {% endif %} - {% endif %} - {% endfor %} - </select> - <input type="hidden" name="dateTimeCols" value=" - {% set date_time_types = ['date', 'datetime', 'timestamp'] %} - {% for idx, key in keys %} - {% if fields_meta[idx].type in date_time_types %} - {{ idx ~ ' ' }} - {% endif %} - {% endfor %}"> - <input type="hidden" name="numericCols" value=" - {% for idx, key in keys %} - {% if fields_meta[idx].type in numeric_types %} - {{ idx ~ ' ' }} - {% endif %} - {% endfor %}"> - </div> - <div class="chartOption"> - <label for="xaxis_panel"> - {% trans 'X-Axis label:' %} - </label> - <input style="margin-top:0;" type="text" name="xaxis_label" id="xaxis_label" value="{{ xaxis == -1 ? 'X Values'|trans : keys[xaxis] }}"> - <br> - <label for="yaxis_label"> - {% trans 'Y-Axis label:' %} - </label> - <input type="text" name="yaxis_label" id="yaxis_label" value="{% trans 'Y Values' %}"> - <br> - </div> - <div class="clearfloat"></div> - <div> - <input type="checkbox" id="chkAlternative" name="chkAlternative" value="alternativeFormat"> - <label for="chkAlternative">{% trans 'Series names are in a column' %}</label> - <br> - <label for="select_seriesColumn"> - {% trans 'Series column:' %} - </label> - <select name="chartSeriesColumn" id="select_seriesColumn" disabled> - {% for idx, key in keys %} - <option value="{{ idx }}" - {% if idx == 1 %} - selected="selected" - {% endif %}> - {{ key }} - </option> - {% set series_column = idx %} - {% endfor %} - </select> - <label for="select_valueColumn"> - {% trans 'Value Column:' %} - </label> - <select name="chartValueColumn" id="select_valueColumn" disabled> - {% set selected = false %} - {% for idx, key in keys %} - {% if fields_meta[idx].type in numeric_types %} - {% if not selected and idx != xaxis and idx != series_column %} - <option value="{{ idx }}" selected="selected">{{ key }}</option> - {% set selected = true %} - {% else %} - <option value="{{ idx }}">{{ key }}</option> - {% endif %} - {% endif %} - {% endfor %} - </select> - </div> - {{ get_start_and_number_of_rows_panel(sql_query) }} - <div class="clearfloat"></div> - <div id="resizer" style="width:600px; height:400px;"> - <div style="position: absolute; right: 10px; top: 10px; cursor: pointer; z-index: 1000;"> - <a class="disableAjax" id="saveChart" href="#" download="chart.png"> - {{ get_image('b_saveimage', 'Save chart as image'|trans) }} - </a> - </div> - <div id="querychart" dir="ltr"> - </div> - </div> - </fieldset> - </form> -</div> diff --git a/srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig b/srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig deleted file mode 100644 index 9e82e2e..0000000 --- a/srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig +++ /dev/null @@ -1,80 +0,0 @@ -<div id="div_view_options"> - <fieldset> - <legend>{% trans 'Display GIS Visualization' %}</legend> - <div id="gis_div" style="position:relative;"> - <form method="post" action="tbl_gis_visualization.php"> - {{ get_hidden_inputs(url_params) }} - <label for="labelColumn"> - {% trans "Label column" %} - </label> - <select name="visualizationSettings[labelColumn]" id="labelColumn" class="autosubmit"> - <option value="">{% trans "-- None --" %}</option> - {% for value in label_candidates %} - <option value="{{ value }}"{{ value == visualization_settings['labelColumn'] ? ' selected="selected"' }}> - {{ value }} - </option> - {% endfor %} - </select> - <label for="spatialColumn"> - {% trans "Spatial column" %} - </label> - <select name="visualizationSettings[spatialColumn]" id="spatialColumn" class="autosubmit"> - {% for value in spatial_candidates %} - <option value="{{ value }}"{{ value == visualization_settings['spatialColumn'] ? ' selected="selected"' }}> - {{ value }} - </option> - {% endfor %} - </select> - <input type="hidden" name="displayVisualization" value="redraw"> - <tr> - <td class="choice" colspan="2"> - <input type="checkbox" - name="visualizationSettings[choice]" - id="choice" value="useBaseLayer" - {% if visualization_settings['choice'] is defined %} - checked="checked" - {% endif %}> - <label for="choice" id="labelChoice"> - {% trans "Use OpenStreetMaps as Base Layer" %} - </label> - </td> - </tr> - {{ get_start_and_number_of_rows_panel(sql_query) }} - </form> - - <div class="pma_quick_warp" style="width: 50px; position: absolute; right: 0; top: 0; cursor: pointer;"> - <div class="drop_list"> - <span class="drop_button" style="padding: 0; border: 0;"> - {{ get_image('b_saveimage', 'Save'|trans) }} - </span> - <ul> - <li class="warp_link"> - <a href="{{ download_url|raw }}&fileFormat=png" class="disableAjax">PNG</a> - </li> - <li class="warp_link"> - <a href="{{ download_url|raw }}&fileFormat=pdf" class="disableAjax">PDF</a> - </li> - <li class="warp_link"> - <a href="{{ download_url|raw }}&fileFormat=svg" class="disableAjax">SVG</a> - </li> - </ul> - </div> - </div> - </div> - - <div class="clearfloat"></div> - - <div id="placeholder" - style="width:{{ visualization_settings['width'] }}px;height:{{ visualization_settings['height'] }}px;"> - {{ visualization|raw }} - </div> - <div id="openlayersmap"></div> - <input type="hidden" id="pmaThemeImage" value="{{ pma_theme_image }}"> - <script language="javascript" type="text/javascript"> - function drawOpenLayers() - { - {{ draw_ol|raw }} - } - </script> - </fieldset> -</div> diff --git a/srcs/phpmyadmin/templates/table/index_form.twig b/srcs/phpmyadmin/templates/table/index_form.twig deleted file mode 100644 index 6364599..0000000 --- a/srcs/phpmyadmin/templates/table/index_form.twig +++ /dev/null @@ -1,223 +0,0 @@ -<form action="tbl_indexes.php" - method="post" - name="index_frm" - id="index_frm" - class="ajax"> - - {{ get_hidden_inputs(form_params) }} - - <fieldset id="index_edit_fields"> - <div class="index_info"> - <div> - <div class="label"> - <strong> - <label for="input_index_name"> - {% trans 'Index name:' %} - {{ show_hint('"PRIMARY" <b>must</b> be the name of and <b>only of</b> a primary key!'|trans) }} - </label> - </strong> - </div> - - <input type="text" - name="index[Key_name]" - id="input_index_name" - size="25" - maxlength="64" - value="{{ index.getName() }}" - onfocus="this.select()"> - </div> - - <div> - <div class="label"> - <strong> - <label for="select_index_choice"> - {% trans 'Index choice:' %} - {{ show_mysql_docu('ALTER_TABLE') }} - </label> - </strong> - </div> - {{ index.generateIndexChoiceSelector(create_edit_table)|raw }} - </div> - - {% include 'div_for_slider_effect.twig' with { - 'id': 'indexoptions', - 'message': 'Advanced Options'|trans, - 'initial_sliders_state': default_sliders_state - } only %} - - <div> - <div class="label"> - <strong> - <label for="input_key_block_size"> - {% trans 'Key block size:' %} - </label> - </strong> - </div> - - <input type="text" - name="index[Key_block_size]" - id="input_key_block_size" - size="30" - value="{{ index.getKeyBlockSize() }}"> - </div> - - <div> - - <div class="label"> - <strong> - <label for="select_index_type"> - {% trans 'Index type:' %} - {{ show_mysql_docu('ALTER_TABLE') }} - </label> - </strong> - </div> - {{ index.generateIndexTypeSelector()|raw }} - </div> - - <div> - <div class="label"> - <strong> - <label for="input_parser"> - {% trans 'Parser:' %} - </label> - </strong> - </div> - - <input type="text" - name="index[Parser]" - id="input_parse" - size="30" - value="{{ index.getParser() }}"> - </div> - - <div> - <div class="label"> - <strong> - <label for="input_index_comment"> - {% trans 'Comment:' %} - </label> - </strong> - </div> - - <input type="text" - name="index[Index_comment]" - id="input_index_comment" - size="30" - maxlength="1024" - value="{{ index.getComment() }}"> - </div> - </div> - <!-- end of indexoptions div --> - - <div class="clearfloat"></div> - - <table id="index_columns"> - <thead> - <tr> - <th></th> - <th> - {% trans 'Column' %} - </th> - <th> - {% trans 'Size' %} - </th> - </tr> - </thead> - {% set spatial_types = [ - 'geometry', - 'point', - 'linestring', - 'polygon', - 'multipoint', - 'multilinestring', - 'multipolygon', - 'geomtrycollection' - ] %} - <tbody> - {% for column in index.getColumns() %} - <tr class="noclick"> - <td> - <span class="drag_icon" title="{% trans 'Drag to reorder' %}"></span> - </td> - <td> - <select name="index[columns][names][]"> - <option value=""> - -- {% trans 'Ignore' %} -- - </option> - {% for field_name, field_type in fields %} - {% if (index.getChoice() != 'FULLTEXT' - or field_type matches '/(char|text)/i') - and (index.getChoice() != 'SPATIAL' - or field_type in spatial_types) %} - - <option value="{{ field_name }}" - {%- if field_name == column.getName() %} - selected="selected" - {%- endif %}> - {{ field_name }} [{{ field_type }}] - </option> - {% endif %} - {% endfor %} - </select> - </td> - <td> - <input type="text" - size="5" - onfocus="this.select()" - name="index[columns][sub_parts][]" - value="{{ index.getChoice() != 'SPATIAL' ? - column.getSubPart() }}"> - </td> - </tr> - {% endfor %} - {% if add_fields > 0 %} - {% for i in range(1, add_fields) %} - <tr class="noclick"> - <td> - <span class="drag_icon" title="{% trans 'Drag to reorder' %}"></span> - </td> - <td> - <select name="index[columns][names][]"> - <option value="">-- {% trans 'Ignore' %} --</option> - {% set j = 0 %} - {% for field_name, field_type in fields %} - {% if create_edit_table %} - {% set col_index = field_type[1] %} - {% set field_type = field_type[0] %} - {% endif %} - {% set j = j + 1 %} - <option value="{{ col_index is defined ? - col_index : field_name }}" - {{- j == i ? ' selected="selected"' }}> - {{ field_name }} [{{ field_type }}] - </option> - {% endfor %} - </select> - </td> - <td> - <input type="text" - size="5" - onfocus="this.select()" - name="index[columns][sub_parts][]" - value=""> - </td> - </tr> - {% endfor %} - {% endif %} - </tbody> - </table> - <div class="add_more"> - - <div class="slider"></div> - <div class="add_fields hide"> - <input class="btn btn-secondary" type="submit" - id="add_fields" - value="{{ 'Add %s column(s) to index'|trans|format(1) }}"> - </div> - </div> - </fieldset> - <fieldset class="tblFooters"> - <button class="btn btn-secondary" type="submit" id="preview_index_frm">{% trans 'Preview SQL' %}</button> - <input class="btn btn-primary" type="submit" id="save_index_frm" value="{% trans 'Go' %}"> - </fieldset> -</form> diff --git a/srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig b/srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig deleted file mode 100644 index 86a8215..0000000 --- a/srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig +++ /dev/null @@ -1,19 +0,0 @@ -<form id="continueForm" method="post" action="tbl_replace.php" name="continueForm"> - {{ get_hidden_inputs(db, table) }} - <input type="hidden" name="goto" value="{{ goto }}"> - <input type="hidden" name="err_url" value="{{ err_url }}"> - <input type="hidden" name="sql_query" value="{{ sql_query }}"> - - {% if has_where_clause %} - {% for key_id, where_clause in where_clause_array %} - <input type="hidden" name="where_clause[{{ key_id }}]" value=" - {{- where_clause|trim }}"> - {% endfor %} - {% endif %} - - {% set insert_rows %} - <input type="number" name="insert_rows" id="insert_rows" value=" - {{- insert_rows_default }}" min="1"> - {% endset %} - {{ 'Continue insertion with %s rows'|trans|format(insert_rows)|raw }} -</form> diff --git a/srcs/phpmyadmin/templates/table/operations/view.twig b/srcs/phpmyadmin/templates/table/operations/view.twig deleted file mode 100644 index e590532..0000000 --- a/srcs/phpmyadmin/templates/table/operations/view.twig +++ /dev/null @@ -1,31 +0,0 @@ -<!-- VIEW operations --> -<div> - <form method="post" action="view_operations.php"> - {{ get_hidden_inputs(db, table) }} - <input type="hidden" name="reload" value="1"> - <fieldset> - <legend>{% trans 'Operations' %}</legend> - <table> - <!-- Change view name --> - <tr> - <td>{% trans 'Rename view to' %}</td> - <td><input type="text" name="new_name" onfocus="this.select()" - value="{{ table }}" - required> - </td> - </tr> - </table> - </fieldset> - <fieldset class="tblFooters"> - <input type="hidden" name="submitoptions" value="1"> - <input class="btn btn-primary" type="submit" value="{% trans 'Go' %}"> - </fieldset> - </form> -</div> - -<div> - <fieldset class="caution"> - <legend>{% trans 'Delete data or table' %}</legend> - <ul>{{ delete_data_or_table_link | raw }}</ul> - </fieldset> -</div> diff --git a/srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig b/srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig deleted file mode 100644 index 2aae85a..0000000 --- a/srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig +++ /dev/null @@ -1,22 +0,0 @@ -{% if cfg_relation['relwork'] or is_foreign_key_supported %} - <ul id="topmenu2"> - {{ get_html_tab({ - 'icon': 'b_props', - 'link': 'tbl_structure.php', - 'text': 'Table structure'|trans, - 'id': 'table_strucuture_id' - }, url_params) }} - {{ get_html_tab({ - 'icon': 'b_relations', - 'link': 'tbl_relation.php', - 'text': 'Relation view'|trans, - 'id': 'table_relation_id' - }, url_params) }} - </ul> - <div class="clearfloat"></div> -{% endif %} - -<div id="structure_content"> - {% block content %} - {% endblock %} -</div> diff --git a/srcs/phpmyadmin/templates/table/relation/common_form.twig b/srcs/phpmyadmin/templates/table/relation/common_form.twig deleted file mode 100644 index e85c6ce..0000000 --- a/srcs/phpmyadmin/templates/table/relation/common_form.twig +++ /dev/null @@ -1,223 +0,0 @@ -{% extends 'table/page_with_secondary_tabs.twig' %} - -{% block content %} -<form method="post" action="tbl_relation.php"> - {{ get_hidden_inputs(db, table) }} - {# InnoDB #} - {% if is_foreign_key_supported(tbl_storage_engine) %} - <fieldset> - <legend>{% trans 'Foreign key constraints' %}</legend> - <div class="responsivetable jsresponsive"> - <table id="foreign_keys" class="relationalTable"> - <thead><tr> - <th>{% trans 'Actions' %}</th> - <th>{% trans 'Constraint properties' %}</th> - {% if tbl_storage_engine|upper == 'INNODB' %} - <th> - {% trans 'Column' %} - {{ show_hint('Creating a foreign key over a non-indexed column would automatically create an index on it. Alternatively, you can define an index below, before creating the foreign key.'|trans) }} - </th> - {% else %} - <th> - {% trans 'Column' %} - {{ show_hint('Only columns with index will be displayed. You can define an index below.'|trans) }} - </th> - {% endif %} - <th colspan="3"> - {% trans 'Foreign key constraint' %} - ({{ tbl_storage_engine }}) - </th> - </tr> - <tr> - <th></th> - <th></th> - <th></th> - <th>{% trans 'Database' %}</th> - <th>{% trans 'Table' %}</th> - <th>{% trans 'Column' %}</th> - </tr></thead> - {% set i = 0 %} - {% if existrel_foreign is not empty %} - {% for key, one_key in existrel_foreign %} - {# Foreign database dropdown #} - {% set foreign_db = one_key['ref_db_name'] is defined - and one_key['ref_db_name'] is not null - ? one_key['ref_db_name'] : db %} - {% set foreign_table = false %} - {% if foreign_db %} - {% set foreign_table = one_key['ref_table_name'] is defined - and one_key['ref_table_name'] is not null - ? one_key['ref_table_name'] : false %} - {% endif %} - {% set unique_columns = [] %} - {% if foreign_db and foreign_table %} - {% set table_obj = table_get(foreign_table, foreign_db) %} - {% set unique_columns = table_obj.getUniqueColumns(false, false) %} - {% endif %} - {% include 'table/relation/foreign_key_row.twig' with { - 'i': i, - 'one_key': one_key, - 'column_array': column_array, - 'options_array': options_array, - 'tbl_storage_engine': tbl_storage_engine, - 'db': db, - 'table': table, - 'url_params': url_params, - 'databases': databases, - 'foreign_db': foreign_db, - 'foreign_table': foreign_table, - 'unique_columns': unique_columns - } only %} - {% set i = i + 1 %} - {% endfor %} - {% endif %} - {% include 'table/relation/foreign_key_row.twig' with { - 'i': i, - 'one_key': [], - 'column_array': column_array, - 'options_array': options_array, - 'tbl_storage_engine': tbl_storage_engine, - 'db': db, - 'table': table, - 'url_params': url_params, - 'databases': databases, - 'foreign_db': foreign_db, - 'foreign_table': foreign_table, - 'unique_columns': unique_columns - } only %} - {% set i = i + 1 %} - <tr> - <th colspan="6"> - <a class="formelement clearfloat add_foreign_key" href=""> - {% trans '+ Add constraint' %} - </a> - </th> - </tr> - </table> - </div> - </fieldset> - {% endif %} - - {% if cfg_relation['relwork'] %} - {% if is_foreign_key_supported(tbl_storage_engine) %} - {% include 'div_for_slider_effect.twig' with { - 'id': 'ir_div', - 'message': 'Internal relationships'|trans, - 'initial_sliders_state': default_sliders_state - } only %} - {% endif %} - - <fieldset> - <legend> - {% trans 'Internal relationships' %} - {{ show_docu('config', 'cfg_Servers_relation') }} - </legend> - <table id="internal_relations" class="relationalTable"> - <tr> - <th>{% trans 'Column' %}</th> - <th>{% trans 'Internal relation' %} - {% if is_foreign_key_supported(tbl_storage_engine) %} - {{ show_hint('An internal relation is not necessary when a corresponding FOREIGN KEY relation exists.'|trans) }} - {% endif %} - </th> - {% set saved_row_cnt = save_row|length - 1 %} - {% for i in 0..saved_row_cnt %} - {% set myfield = save_row[i]['Field'] %} - {# Use an md5 as array index to avoid having special characters - in the name attribute (see bug #1746964 ) #} - {% set myfield_md5 = column_hash_array[myfield] %} - - {% set foreign_table = false %} - {% set foreign_column = false %} - - {# Database dropdown #} - {% if existrel[myfield] is defined %} - {% set foreign_db = existrel[myfield]['foreign_db'] %} - {% else %} - {% set foreign_db = db %} - {% endif %} - - {# Table dropdown #} - {% set tables = [] %} - {% if foreign_db %} - {% if existrel[myfield] is defined %} - {% set foreign_table = existrel[myfield]['foreign_table'] %} - {% endif %} - {% set tables = dbi.getTables(foreign_db) %} - {% endif %} - - {# Column dropdown #} - {% set unique_columns = [] %} - {% if foreign_db and foreign_table %} - {% if existrel[myfield] is defined %} - {% set foreign_column = existrel[myfield]['foreign_field'] %} - {% endif %} - {% set table_obj = table_get(foreign_table, foreign_db) %} - {% set unique_columns = table_obj.getUniqueColumns(false, false) %} - {% endif %} - - <tr> - <td class="vmiddle"> - <strong>{{ myfield }}</strong> - <input type="hidden" name="fields_name[{{ myfield_md5 }}]" - value="{{ myfield }}"> - </td> - - <td> - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_db[' ~ myfield_md5 ~ ']', - 'title': 'Database'|trans, - 'values': databases, - 'foreign': foreign_db - } only %} - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_table[' ~ myfield_md5 ~ ']', - 'title': 'Table'|trans, - 'values': tables, - 'foreign': foreign_table - } only %} - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_column[' ~ myfield_md5 ~ ']', - 'title': 'Column'|trans, - 'values': unique_columns, - 'foreign': foreign_column - } only %} - </td> - </tr> - {% endfor %} - </table> - </fieldset> - {% if is_foreign_key_supported(tbl_storage_engine) %} - </div> - {% endif %} - {% endif %} - - {% if cfg_relation['displaywork'] %} - {% set disp = get_display_field(db, table) %} - <fieldset> - <label>{% trans 'Choose column to display:' %}</label> - <select name="display_field"> - <option value="">---</option> - {% for row in save_row %} - <option value="{{ row['Field'] }}" - {%- if disp is defined and row['Field'] == disp %} - selected="selected" - {%- endif %}> - {{ row['Field'] }} - </option> - {% endfor %} - </select> - </fieldset> - {% endif %} - - <fieldset class="tblFooters"> - <input class="btn btn-secondary preview_sql" type="button" value="{% trans 'Preview SQL' %}"> - <input class="btn btn-primary" type="submit" value="{% trans 'Save' %}"> - </fieldset> -</form> -{% if foreignKeySupported %} - {{ displayIndexesHtml|raw }} -{% endif %} -{% endblock %} diff --git a/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig b/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig deleted file mode 100644 index ff179bc..0000000 --- a/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig +++ /dev/null @@ -1,9 +0,0 @@ -{{ dropdown_question is not empty ? dropdown_question -}} -<select name="{{ select_name }}"> -{% for one_value, one_label in choices %} - <option value="{{ one_value }}" - {%- if selected_value == one_value %} selected="selected"{% endif %}> - {{ one_label }} - </option> -{% endfor %} -</select> diff --git a/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig b/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig deleted file mode 100644 index 3df6c34..0000000 --- a/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig +++ /dev/null @@ -1,136 +0,0 @@ -<tr> - {# Drop key anchor #} - <td> - {% set js_msg = '' %} - {% set this_params = null %} - {% if one_key['constraint'] is defined %} - {% set drop_fk_query = 'ALTER TABLE ' ~ backquote(db) ~ '.' ~ backquote(table) - ~ ' DROP FOREIGN KEY ' - ~ backquote(one_key['constraint']) ~ ';' - %} - {% set this_params = url_params %} - {% set this_params = { - 'goto': 'tbl_relation.php', - 'back': 'tbl_relation.php', - 'sql_query': drop_fk_query, - 'message_to_show': 'Foreign key constraint %s has been dropped'|trans|format( - one_key['constraint'] - ) - } %} - {% set js_msg = 'ALTER TABLE ' ~ db ~ '.' ~ table ~ ' DROP FOREIGN KEY ' ~ one_key['constraint'] ~ ';'|js_format %} - {% endif %} - {% if one_key['constraint'] is defined %} - <input type="hidden" class="drop_foreign_key_msg" value=" - {{- js_msg }}"> - {% set drop_url = 'sql.php' ~ get_common(this_params) %} - {% set drop_str = get_icon('b_drop', 'Drop'|trans) %} - {{ link_or_button(drop_url, drop_str, {'class': 'drop_foreign_key_anchor ajax'}) }} - {% endif %} - </td> - <td> - <span class="formelement clearfloat"> - <input type="text" name="constraint_name[{{ i }}]" value=" - {{- one_key['constraint'] is defined ? one_key['constraint'] -}} - " placeholder="{% trans 'Constraint name' %}" maxlength="64"> - </span> - <div class="floatleft"> - {# For ON DELETE and ON UPDATE, the default action - is RESTRICT as per MySQL doc; however, a SHOW CREATE TABLE - won't display the clause if it's set as RESTRICT. #} - {% set on_delete = one_key['on_delete'] is defined - ? one_key['on_delete'] : 'RESTRICT' %} - {% set on_update = one_key['on_update'] is defined - ? one_key['on_update'] : 'RESTRICT' %} - <span class="formelement"> - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': 'ON DELETE', - 'select_name': 'on_delete[' ~ i ~ ']', - 'choices': options_array, - 'selected_value': on_delete - } only %} - </span> - <span class="formelement"> - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': 'ON UPDATE', - 'select_name': 'on_update[' ~ i ~ ']', - 'choices': options_array, - 'selected_value': on_update - } only %} - </span> - </div> - </td> - <td> - {% if one_key['index_list'] is defined %} - {% for key, column in one_key['index_list'] %} - <span class="formelement clearfloat"> - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': '', - 'select_name': 'foreign_key_fields_name[' ~ i ~ '][]', - 'choices': column_array, - 'selected_value': column - } only %} - </span> - {% endfor %} - {% else %} - <span class="formelement clearfloat"> - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': '', - 'select_name': 'foreign_key_fields_name[' ~ i ~ '][]', - 'choices': column_array, - 'selected_value': '' - } only %} - </span> - {% endif %} - <a class="formelement clearfloat add_foreign_key_field" data-index=" - {{- i }}" href=""> - {% trans '+ Add column' %} - </a> - </td> - {% set tables = [] %} - {% if foreign_db %} - {% set tables = get_tables(foreign_db, tbl_storage_engine) %} - {% endif %} - <td> - <span class="formelement clearfloat"> - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_db[' ~ i ~ ']', - 'title': 'Database'|trans, - 'values': databases, - 'foreign': foreign_db - } only %} - </span> - </td> - <td> - <span class="formelement clearfloat"> - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_table[' ~ i ~ ']', - 'title': 'Table'|trans, - 'values': tables, - 'foreign': foreign_table - } only %} - </span> - </td> - <td> - {% if foreign_db and foreign_table %} - {% for foreign_column in one_key['ref_index_list'] %} - <span class="formelement clearfloat"> - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_column[' ~ i ~ '][]', - 'title': 'Column'|trans, - 'values': unique_columns, - 'foreign': foreign_column - } only %} - </span> - {% endfor %} - {% else %} - <span class="formelement clearfloat"> - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_column[' ~ i ~ '][]', - 'title': 'Column'|trans, - 'values': [], - 'foreign': '' - } only %} - </span> - {% endif %} - </td> -</tr> diff --git a/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig b/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig deleted file mode 100644 index 9d5f3c9..0000000 --- a/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig +++ /dev/null @@ -1,18 +0,0 @@ -<select name="{{ name }}" title="{{ title }}"> - <option value=""></option> - {% set seen_key = false %} - {% for value in values %} - <option value="{{ value }}" - {%- if foreign is not same as(false) and value == foreign %} - selected="selected" - {%- set seen_key = true -%} - {%- endif %}> - {{ value }} - </option> - {% endfor %} - {% if foreign is not same as(false) and not seen_key %} - <option value="{{ foreign }}" selected="selected"> - {{ foreign }} - </option> - {% endif %} -</select> diff --git a/srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig b/srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig deleted file mode 100644 index b72e530..0000000 --- a/srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig +++ /dev/null @@ -1,3 +0,0 @@ -<select id="ColumnOperator{{ search_index }}" name="criteriaColumnOperators[{{ search_index }}]"> - {{ type_operators|raw }} -</select> diff --git a/srcs/phpmyadmin/templates/table/search/fields_table.twig b/srcs/phpmyadmin/templates/table/search/fields_table.twig deleted file mode 100644 index 8b74939..0000000 --- a/srcs/phpmyadmin/templates/table/search/fields_table.twig +++ /dev/null @@ -1,33 +0,0 @@ -<table class="data"{{ search_type == 'zoom' ? ' id="tableFieldsId"' }}> - <thead> - <tr> - {% if geom_column_flag %} - <th>{% trans 'Function' %}</th> - {% endif %} - <th>{% trans 'Column' %}</th> - <th>{% trans 'Type' %}</th> - <th>{% trans 'Collation' %}</th> - <th>{% trans 'Operator' %}</th> - <th>{% trans 'Value' %}</th> - </tr> - </thead> - <tbody> - {% if search_type == 'zoom' %} - {% include 'table/search/rows_zoom.twig' with { - 'self': self, - 'column_names': column_names, - 'keys': keys, - 'criteria_column_names': criteria_column_names, - 'criteria_column_types': criteria_column_types - } only %} - {% else %} - {% include 'table/search/rows_normal.twig' with { - 'self': self, - 'geom_column_flag': geom_column_flag, - 'column_names': column_names, - 'column_types': column_types, - 'column_collations': column_collations - } only %} - {% endif %} - </tbody> -</table> diff --git a/srcs/phpmyadmin/templates/table/search/form_tag.twig b/srcs/phpmyadmin/templates/table/search/form_tag.twig deleted file mode 100644 index 1017abd..0000000 --- a/srcs/phpmyadmin/templates/table/search/form_tag.twig +++ /dev/null @@ -1,4 +0,0 @@ -<form method="post" action="{{ script_name }}" name="insertForm" id="{{ form_id }}" class="ajax lock-page"> - {{ get_hidden_inputs(db, table) }} - <input type="hidden" name="goto" value="{{ goto }}"> - <input type="hidden" name="back" value="{{ script_name }}"> diff --git a/srcs/phpmyadmin/templates/table/search/geom_func.twig b/srcs/phpmyadmin/templates/table/search/geom_func.twig deleted file mode 100644 index f7a7415..0000000 --- a/srcs/phpmyadmin/templates/table/search/geom_func.twig +++ /dev/null @@ -1,19 +0,0 @@ -{# Displays 'Function' column if it is present #} -<td> - {% set geom_types = get_gis_datatypes() %} - {% if column_types[column_index] in geom_types %} - <select class="geom_func" name="geom_func[{{ column_index }}]"> - {# get the relevant list of GIS functions #} - {% set funcs = get_gis_functions(column_types[column_index], true, true) %} - - {% for func_name, func in funcs %} - {% set name = func['display'] is defined ? func['display'] : func_name %} - <option value="{{ name }}"> - {{ name }} - </option> - {% endfor %} - </select> - {% else %} - - {% endif %} -</td> diff --git a/srcs/phpmyadmin/templates/table/search/input_box.twig b/srcs/phpmyadmin/templates/table/search/input_box.twig deleted file mode 100644 index 5c30535..0000000 --- a/srcs/phpmyadmin/templates/table/search/input_box.twig +++ /dev/null @@ -1,97 +0,0 @@ -{# Get inputbox based on different column types (Foreign key, geometrical, enum) #} -{% if foreigners and search_column_in_foreigners(foreigners, column_name) %} - {% if foreign_data['disp_row'] is iterable %} - <select name="criteriaValues[{{ column_index }}]" - id="{{ column_id }}{{ column_index }}"> - {{ foreign_dropdown( - foreign_data['disp_row'], - foreign_data['foreign_field'], - foreign_data['foreign_display'], - '', - foreign_max_limit - ) }} - </select> - {% elseif foreign_data['foreign_link'] == true %} - <input type="text" - id="{{ column_id }}{{ column_index }}" - name="criteriaValues[{{ column_index }}]" - id="field_{{ column_name_hash }}[{{ column_index }}]" - class="textfield" - {% if criteria_values[column_index] is defined %} - value="{{ criteria_values[column_index] }}" - {% endif %}> - <a class="ajax browse_foreign" href="browse_foreigners.php" data-post=" - {{- get_common({'db': db, 'table': table}, '') -}} - &field={{ column_name|url_encode }}&fieldkey= - {{- column_index }}&fromsearch=1"> - {{ titles['Browse']|replace({"'": "\\'"})|raw }} - </a> - {% endif %} -{% elseif column_type in get_gis_datatypes() %} - <input type="text" - name="criteriaValues[{{ column_index }}]" - size="40" - class="textfield" - id="field_{{ column_index }}"> - {% if in_fbs %} - {% set edit_url = 'gis_data_editor.php' ~ get_common() %} - {% set edit_str = get_icon('b_edit', 'Edit/Insert'|trans) %} - <span class="open_search_gis_editor"> - {{ link_or_button(edit_url, edit_str, [], '_blank') }} - </span> - {% endif %} -{% elseif column_type starts with 'enum' - or (column_type starts with 'set' and in_zoom_search_edit) %} - {% set in_zoom_search_edit = false %} - {% set value = column_type|e|slice(5, -1)|replace({''': ''})|split(', ') %} - {% set cnt_value = value|length %} - {# - Enum in edit mode --> dropdown - Enum in search mode --> multiselect - Set in edit mode --> multiselect - Set in search mode --> input (skipped here, so the 'else' section would handle it) - #} - {% if (column_type starts with 'enum' and not in_zoom_search_edit) - or (column_type starts with 'set' and in_zoom_search_edit) %} - <select name="criteriaValues[{{ column_index }}]" - id="{{ column_id }}{{ column_index }}"> - {% else %} - <select name="criteriaValues[{{ column_index }}]" - id="{{ column_id }}{{ column_index }}" - multiple="multiple" - size="{{ min(3, cnt_value) }}"> - {% endif %} - {# Add select options #} - <option value=""></option> - {% for i in 0..cnt_value - 1 %} - {% if criteria_values[column_index] is defined - and criteria_values[column_index] is iterable - and value[i] in criteria_values[column_index] %} - <option value="{{ value[i]|raw }}" selected> - {{ value[i]|raw }} - </option> - {% else %} - <option value="{{ value[i]|raw }}"> - {{ value[i]|raw }} - </option> - {% endif %} - {% endfor %} - </select> -{% else %} - {% set the_class = 'textfield' %} - {% if column_type == 'date' %} - {% set the_class = the_class ~ ' datefield' %} - {% elseif column_type == 'datetime' or column_type starts with 'timestamp' %} - {% set the_class = the_class ~ ' datetimefield' %} - {% elseif column_type starts with 'bit' %} - {% set the_class = the_class ~ ' bit' %} - {% endif %} - <input type="text" - name="criteriaValues[{{ column_index }}]" - size="40" - class="{{ the_class }}" - id="{{ column_id }}{{ column_index }}" - {% if criteria_values[column_index] is defined %} - value="{{ criteria_values[column_index] }}" - {%- endif %}> -{% endif %} diff --git a/srcs/phpmyadmin/templates/table/search/replace_preview.twig b/srcs/phpmyadmin/templates/table/search/replace_preview.twig deleted file mode 100644 index e7a2423..0000000 --- a/srcs/phpmyadmin/templates/table/search/replace_preview.twig +++ /dev/null @@ -1,39 +0,0 @@ -<form method="post" - action="tbl_find_replace.php" - name="previewForm" - id="previewForm"> - {{ get_hidden_inputs(db, table) }} - <input type="hidden" name="replace" value="true"> - <input type="hidden" name="columnIndex" value="{{ column_index }}"> - <input type="hidden" name="findString" value="{{ find }}"> - <input type="hidden" name="replaceWith" value="{{ replace_with }}"> - <input type="hidden" name="useRegex" value="{{ use_regex }}"> - - <fieldset id="fieldset_find_replace_preview"> - <legend>{% trans 'Find and replace - preview' %}</legend> - <table id="previewTable"> - <thead> - <tr> - <th>{% trans 'Count' %}</th> - <th>{% trans 'Original string' %}</th> - <th>{% trans 'Replaced string' %}</th> - </tr> - </thead> - <tbody> - {% if result is iterable %} - {% for row in result %} - <tr> - <td class="right">{{ row[2] }}</td>{# count #} - <td>{{ row[0] }}</td>{# original #} - <td>{{ row[1] }}</td>{# replaced #} - </tr> - {% endfor %} - {% endif %} - </tbody> - </table> - </fieldset> - - <fieldset class="tblFooters"> - <input class="btn btn-secondary" type="submit" name="replace" value="{% trans 'Replace' %}"> - </fieldset> -</form> diff --git a/srcs/phpmyadmin/templates/table/search/rows_normal.twig b/srcs/phpmyadmin/templates/table/search/rows_normal.twig deleted file mode 100644 index 5e21efa..0000000 --- a/srcs/phpmyadmin/templates/table/search/rows_normal.twig +++ /dev/null @@ -1,39 +0,0 @@ -{% for column_index in 0..column_names|length - 1 %} - <tr class="noclick"> - {# If 'Function' column is present trying to change comment #} - {% if geom_column_flag %} - {% include 'table/search/geom_func.twig' with { - 'column_index': column_index, - 'column_types': column_types - } only %} - {% endif %} - {# Displays column's name, type, collation and value #} - <th> - {{ column_names[column_index] }} - </th> - {% set properties = self.getColumnProperties(column_index, column_index) %} - <td dir="ltr"> - {{ properties['type'] }} - </td> - <td> - {{ properties['collation'] }} - </td> - <td> - {{ properties['func']|raw }} - </td> - {# here, the data-type attribute is needed for a date/time picker #} - <td data-type="{{ properties['type'] }}"> - {{ properties['value']|raw }} - {# Displays hidden fields #} - <input type="hidden" - name="criteriaColumnNames[{{ column_index }}]" - value="{{ column_names[column_index] }}"> - <input type="hidden" - name="criteriaColumnTypes[{{ column_index }}]" - value="{{ column_types[column_index] }}"> - <input type="hidden" - name="criteriaColumnCollations[{{ column_index }}]" - value="{{ column_collations[column_index] }}"> - </td> - </tr> -{% endfor %} diff --git a/srcs/phpmyadmin/templates/table/search/rows_zoom.twig b/srcs/phpmyadmin/templates/table/search/rows_zoom.twig deleted file mode 100644 index dc46f1d..0000000 --- a/srcs/phpmyadmin/templates/table/search/rows_zoom.twig +++ /dev/null @@ -1,74 +0,0 @@ -{# Get already set search criteria (if any) #} -{% set type = [] %} -{% set collation = [] %} -{% set func = [] %} -{% set value = [] %} - -{% for i in 0..3 %} - {# After X-Axis and Y-Axis column rows, display additional criteria option #} - {% if i == 2 %} - <tr> - <td> - {% trans 'Additional search criteria' %} - </td> - </tr> - {% endif %} - <tr class="noclick"> - <th> - <select name="criteriaColumnNames[]" id="tableid_{{ i }}" > - <option value="pma_null"> - {% trans 'None' %} - </option> - {% for j in 0..column_names|length - 1 %} - {% if criteria_column_names[i] is defined - and criteria_column_names[i] == column_names[j] %} - <option value="{{ column_names[j] }}" selected="selected"> - {{ column_names[j] }} - </option> - {% else %} - <option value="{{ column_names[j] }}"> - {{ column_names[j] }} - </option> - {% endif %} - {% endfor %} - </select> - </th> - {% if criteria_column_names[i] is defined - and criteria_column_names[i] != 'pma_null' %} - {% set key = keys[criteria_column_names[i]] %} - {% set properties = self.getColumnProperties(i, key) %} - {% set type = type|merge({i: properties['type']}) %} - {% set collation = collation|merge({i: properties['collation']}) %} - {% set func = func|merge({i: properties['func']}) %} - {% set value = value|merge({i: properties['value']}) %} - {% endif %} - {# Column type #} - <td dir="ltr"> - {{ type[i] is defined ? type[i] }} - </td> - {# Column Collation #} - <td> - {{ collation[i] is defined ? collation[i] }} - </td> - {# Select options for column operators #} - <td> - {{ func[i] is defined ? func[i]|raw }} - </td> - {# Inputbox for search criteria value #} - <td> - </td> - <td> - {{ value[i] is defined ? value[i]|raw }} - {# Displays hidden fields #} - <input type="hidden" - name="criteriaColumnTypes[{{ i }}]" - id="types_{{ i }}" - {%- if criteria_column_types[i] is defined %} - value="{{ criteria_column_types[i] }}" - {%- endif %}> - <input type="hidden" - name="criteriaColumnCollations[{{ i }}]" - id="collations_{{ i }}"> - </td> - </tr> -{% endfor %} diff --git a/srcs/phpmyadmin/templates/table/search/selection_form.twig b/srcs/phpmyadmin/templates/table/search/selection_form.twig deleted file mode 100644 index 2ba4d60..0000000 --- a/srcs/phpmyadmin/templates/table/search/selection_form.twig +++ /dev/null @@ -1,226 +0,0 @@ -{% if search_type == 'zoom' %} - {% include 'table/search/form_tag.twig' with { - 'script_name': 'tbl_zoom_select.php', - 'form_id': 'zoom_search_form', - 'db': db, - 'table': table, - 'goto': goto - } only %} - <fieldset id="fieldset_zoom_search"> - <fieldset id="inputSection"> - <legend> - {% trans 'Do a "query by example" (wildcard: "%") for two different columns' %} - </legend> - {% include 'table/search/fields_table.twig' with { - 'self': self, - 'search_type': search_type, - 'geom_column_flag': geom_column_flag, - 'column_names': column_names, - 'column_types': column_types, - 'column_collations': column_collations, - 'keys' : keys, - 'criteria_column_names': criteria_column_names, - 'criteria_column_types': criteria_column_types - } only %}<table class="data"> - {# Select options for data label #} - <tr> - <td> - <label for="dataLabel"> - {% trans 'Use this column to label each point' %} - </label> - </td> - <td> - <select name="dataLabel" id="dataLabel" > - <option value = ""> - {% trans 'None' %} - </option> - {% for i in 0..column_names|length - 1 %} - {% if data_label is defined and data_label == column_names[i]|e %} - <option value="{{ column_names[i] }}" selected="selected"> - {{ column_names[i] }} - </option> - {% else %} - <option value="{{ column_names[i] }}" > - {{ column_names[i] }} - </option> - {% endif %} - {% endfor %} - </select> - </td> - </tr> - {# Inputbox for changing default maximum rows to plot #} - <tr> - <td> - <label for="maxRowPlotLimit"> - {% trans 'Maximum rows to plot' %} - </label> - </td> - <td> - <input type="number" - name="maxPlotLimit" - id="maxRowPlotLimit" - required="required" - value="{{ max_plot_limit }}"> - </td> - </tr> - </table> - </fieldset> - </fieldset> -{% elseif search_type == 'normal' %} - {% include 'table/search/form_tag.twig' with { - 'script_name': 'tbl_select.php', - 'form_id': 'tbl_search_form', - 'db': db, - 'table': table, - 'goto': goto - } only %} - <fieldset id="fieldset_table_search"> - <fieldset id="fieldset_table_qbe"> - <legend> - {% trans 'Do a "query by example" (wildcard: "%")' %} - </legend> - <div class="responsivetable jsresponsive"> - {% include 'table/search/fields_table.twig' with { - 'self': self, - 'search_type': search_type, - 'geom_column_flag': geom_column_flag, - 'column_names': column_names, - 'column_types': column_types, - 'column_collations': column_collations, - 'criteria_column_names': criteria_column_names, - 'criteria_column_types': criteria_column_types - } only %} - </div> - <div id="gis_editor"></div> - <div id="popup_background"></div> - </fieldset> - {% include 'div_for_slider_effect.twig' with { - 'id': 'searchoptions', - 'message': 'Options'|trans, - 'initial_sliders_state': default_sliders_state - } only %} - - {# Displays columns select list for selecting distinct columns in the search #} - <fieldset id="fieldset_select_fields"> - <legend> - {% trans 'Select columns (at least one):' %} - </legend> - <select name="columnsToDisplay[]" - size="{{ min(column_names|length, 10) }}" - multiple="multiple"> - {% for each_field in column_names %} - <option value="{{ each_field }}" - selected="selected"> - {{ each_field }} - </option> - {% endfor %} - </select> - <input type="checkbox" name="distinct" value="DISTINCT" id="oDistinct"> - <label for="oDistinct">DISTINCT</label> - </fieldset> - - {# Displays input box for custom 'Where' clause to be used in the search #} - <fieldset id="fieldset_search_conditions"> - <legend> - <em>{% trans 'Or' %}</em> - {% trans 'Add search conditions (body of the "where" clause):' %} - </legend> - {{ show_mysql_docu('Functions') }} - <input type="text" name="customWhereClause" class="textfield" size="64"> - </fieldset> - - {# Displays option of changing default number of rows displayed per page #} - <fieldset id="fieldset_limit_rows"> - <legend>{% trans 'Number of rows per page' %}</legend> - <input type="number" - name="session_max_rows" - required="required" - min="1" - value="{{ max_rows }}" - class="textfield"> - </fieldset> - - {# Displays option for ordering search results by a column value (Asc or Desc) #} - <fieldset id="fieldset_display_order"> - <legend>{% trans 'Display order:' %}</legend> - <select name="orderByColumn"><option value="--nil--"></option> - {% for each_field in column_names %} - <option value="{{ each_field }}"> - {{ each_field }} - </option> - {% endfor %} - </select> - - {{ get_radio_fields( - 'order', - { - 'ASC': 'Ascending'|trans, - 'DESC': 'Descending'|trans - }, - 'ASC', - false, - true, - 'formelement' - ) }} - - </fieldset> - <div class="clearfloat"></div> - </fieldset> -{% elseif search_type == 'replace' %} - {% include 'table/search/form_tag.twig' with { - 'script_name': 'tbl_find_replace.php', - 'form_id': 'find_replace_form', - 'db': db, - 'table': table, - 'goto': goto - } only %} - <fieldset id="fieldset_find_replace"> - <fieldset id="fieldset_find"> - <legend> - {% trans 'Find and replace' %} - </legend>{% trans 'Find:' %} - <input type="text" value="" name="find" required> - {% trans 'Replace with:' %} - <input type="text" value="" name="replaceWith"> - - {% trans 'Column:' %} - <select name="columnIndex"> - {% for i in 0..column_names|length - 1 %} - {% set type = types[column_names[i]] %} - - {% if sql_types.getTypeClass(type) == 'CHAR' %} - <option value="{{ i }}"> - {{- column_names[i] -}} - </option> - {% endif %} - {% endfor %} - </select> - - {% include 'checkbox.twig' with { - 'html_field_id': 'useRegex', - 'html_field_name': 'useRegex', - 'label': 'Use regular expression'|trans, - 'checked': false, - 'onclick': false - } only %} - </fieldset> - </fieldset> -{% else %} - {% include 'table/search/form_tag.twig' with { - 'script_name': '', - 'form_id': '', - 'db': db, - 'table': table, - 'goto': goto - } only %} -{% endif %} - -{# Displays selection form's footer elements #} - <fieldset class="tblFooters"> - <input class="btn btn-primary" type="submit" - name="{{ search_type == 'zoom' ? 'zoom_submit' : 'submit' }}" - {{ search_type == 'zoom' ? 'id="inputFormSubmitId"' }} - value="{% trans 'Go' %}"> - </fieldset> -</form> -<div id="sqlqueryresultsouter"></div> diff --git a/srcs/phpmyadmin/templates/table/search/zoom_result_form.twig b/srcs/phpmyadmin/templates/table/search/zoom_result_form.twig deleted file mode 100644 index 7543f85..0000000 --- a/srcs/phpmyadmin/templates/table/search/zoom_result_form.twig +++ /dev/null @@ -1,86 +0,0 @@ -<form method="post" action="tbl_zoom_select.php" name="displayResultForm" id="zoom_display_form" class="ajax"> - {{ get_hidden_inputs(db, table) }} - <input type="hidden" name="goto" value="{{ goto }}"> - <input type="hidden" name="back" value="tbl_zoom_select.php"> - - <fieldset id="displaySection"> - <legend>{% trans 'Browse/Edit the points' %}</legend> - - {# JSON encode the data(query result) #} - <center> - {% if zoom_submit and data is not empty %} - <div id="resizer"> - <center> - <a id="help_dialog" href="#"> - {% trans 'How to use' %} - </a> - </center> - <div id="querydata" class="hide"> - {{ data_json }} - </div> - <div id="querychart"></div> - <button class="button-reset"> - {% trans 'Reset zoom' %} - </button> - </div> - {% endif %} - </center> - - {# Displays rows in point edit form #} - <div id="dataDisplay" class="hide"> - <table> - <thead> - <tr> - <th>{% trans 'Column' %}</th> - <th>{% trans 'Null' %}</th> - <th>{% trans 'Value' %}</th> - </tr> - </thead> - <tbody> - {% for column_index in 0..column_names|length - 1 %} - {% set field_popup = column_names[column_index] %} - {% set foreign_data = get_foreign_data( - foreigners, - field_popup, - false, - '', - '' - ) %} - <tr class="noclick"> - <th>{{ column_names[column_index] }}</th> - {# Null checkbox if column can be null #} - <th> - {% if column_null_flags[column_index] == 'YES' %} - <input type="checkbox" class="checkbox_null" - name="criteriaColumnNullFlags[{{ column_index }}]" - id="edit_fields_null_id_{{ column_index }}"> - {% endif %} - </th> - {# Column's Input box #} - <th> - {% include 'table/search/input_box.twig' with { - 'str': '', - 'column_type': column_types[column_index], - 'column_id': column_types[column_index] ? 'edit_fieldID_' : 'fieldID_', - 'in_zoom_search_edit': true, - 'foreigners': foreigners, - 'column_name': field_popup, - 'column_name_hash': column_name_hashes[field_popup], - 'foreign_data': foreign_data, - 'table': table, - 'column_index': column_index, - 'foreign_max_limit': foreign_max_limit, - 'criteria_values': '', - 'db': db, - 'titles': titles, - 'in_fbs': false - } only %} - </th> - </tr> - {% endfor %} - </tbody> - </table> - </div> - <input type="hidden" id="queryID" name="sql_query"> - </fieldset> -</form> diff --git a/srcs/phpmyadmin/templates/table/structure/action_row_in_structure_table.twig b/srcs/phpmyadmin/templates/table/structure/action_row_in_structure_table.twig deleted file mode 100644 index d9c629c..0000000 --- a/srcs/phpmyadmin/templates/table/structure/action_row_in_structure_table.twig +++ /dev/null @@ -1,31 +0,0 @@ -<li class="{{ class }}"> -{% if type == 'text' - or type == 'blob' - or tbl_storage_engine == 'ARCHIVE' - or has_field %} - {{ titles['No' ~ action]|raw }} -{% else %} - <a rel="samepage" class="ajax add_key print_ignore - {%- if has_link_class %} - add_primary_key_anchor - {%- elseif action == 'Index' %} - add_index_anchor - {%- elseif action == 'Unique' %} - add_unique_anchor - {%- elseif action == 'Spatial' %} - add_spatial_anchor - {%- endif %}" href="tbl_structure.php" data-post="{{ url_query|raw -}} - &add_key=1&sql_query= - {{- ('ALTER TABLE ' ~ - backquote(table) ~ - (is_primary ? (primary ? ' DROP PRIMARY KEY,')) ~ - ' ' ~ - syntax ~ - '(' ~ - backquote(row['Field']) ~ - ');')|url_encode -}} - &message_to_show={{ message|format(row['Field']|e)|url_encode }}"> - {{ titles[action]|raw }} - </a> -{% endif %} -</li> diff --git a/srcs/phpmyadmin/templates/table/structure/display_partitions.twig b/srcs/phpmyadmin/templates/table/structure/display_partitions.twig deleted file mode 100644 index b10a0bc..0000000 --- a/srcs/phpmyadmin/templates/table/structure/display_partitions.twig +++ /dev/null @@ -1,145 +0,0 @@ -<div id="partitions"> - <fieldset> - <legend> - {% trans 'Partitions' %} - {{ show_mysql_docu('partitioning') }} - </legend> - {% if partitions is empty %} - {{ 'No partitioning defined!'|trans|notice }} - {% else %} - <p> - {% trans 'Partitioned by:' %} - <code>{{ partition_method }}({{ partition_expression }})</code> - </p> - {% if has_sub_partitions %} - <p> - {% trans 'Sub partitioned by:' %} - <code>{{ sub_partition_method }}({{ sub_partition_expression }})</code> - <p> - {% endif %} - <table> - <thead> - <tr> - <th colspan="2">#</th> - <th>{% trans 'Partition' %}</th> - {% if has_description %} - <th>{% trans 'Expression' %}</th> - {% endif %} - <th>{% trans 'Rows' %}</th> - <th>{% trans 'Data length' %}</th> - <th>{% trans 'Index length' %}</th> - <th>{% trans 'Comment' %}</th> - <th colspan="{{ range_or_list ? '7' : '6' }}"> - {% trans 'Action' %} - </th> - </tr> - </thead> - <tbody> - {% for partition in partitions %} - <tr class="noclick{{ has_sub_partitions ? ' marked' }}"> - {% if has_sub_partitions %} - <td>{{ partition.getOrdinal() }}</td> - <td></td> - {% else %} - <td colspan="2">{{ partition.getOrdinal() }}</td> - {% endif %} - <th>{{ partition.getName() }}</th> - {% if has_description %} - <td> - <code> - {{- partition.getExpression() -}} - {{- partition.getMethod() == 'LIST' ? ' IN (' : ' < ' -}} - {{- partition.getDescription() -}} - {{- partition.getMethod() == 'LIST' ? ')' -}} - </code> - </td> - {% endif %} - <td class="value">{{ partition.getRows() }}</td> - <td class="value"> - {% set data_length = format_byte_down( - partition.getDataLength(), - 3, - 1 - ) %} - <span>{{ data_length[0] }}</span> - <span class="unit">{{ data_length[1] }}</span> - </td> - <td class="value"> - {% set index_length = format_byte_down( - partition.getIndexLength(), - 3, - 1 - ) %} - <span>{{ index_length[0] }}</span> - <span class="unit">{{ index_length[1] }}</span> - </td> - <td>{{ partition.getComment() }}</td> - {% for action, icon in action_icons %} - <td> - <a href="tbl_structure.php" data-post="{{ url_query -}} - &partition_maintenance=1&sql_query= - {{- ("ALTER TABLE " ~ backquote(table) ~ " " ~ action - ~ " PARTITION " ~ partition.getName())|url_encode }}" - id="partition_action_{{ action }}" - name="partition_action_{{ action }}" - class="ajax"> - {{ icon|raw }} - </a> - </td> - {% endfor %} - - {% if has_sub_partitions %} - {% for sub_partition in partition.getSubPartitions() %} - <tr class="noclick"> - <td></td> - <td>{{ sub_partition.getOrdinal() }}</td> - <td>{{ sub_partition.getName() }}</td> - {% if has_description %} - <td></td> - {% endif %} - <td class="value">{{ sub_partition.getRows() }}</td> - <td class="value"> - {% set data_length = format_byte_down( - sub_partition.getDataLength(), - 3, - 1 - ) %} - <span>{{ data_length[0] }}</span> - <span class="unit">{{ data_length[1] }}</span> - </td> - <td class="value"> - {% set index_length = format_byte_down( - sub_partition.getIndexLength(), - 3, - 1 - ) %} - <span>{{ index_length[0] }}</span> - <span class="unit">{{ index_length[1] }}</span> - </td> - <td>{{ sub_partition.getComment() }}</td> - <td colspan="{{ range_or_list ? '7' : '6' }}"></td> - </tr> - {% endfor %} - {% endif %} - </tr> - {% endfor %} - </tbody> - </table> - {% endif %} - </fieldset> - <fieldset class="tblFooters print_ignore"> - <form action="tbl_structure.php" method="post"> - {{ get_hidden_inputs(db, table) }} - <input type="hidden" name="edit_partitioning" value="true"> - {% if partitions is empty %} - <input class="btn btn-secondary" type="submit" name="edit_partitioning" value="{% trans 'Partition table' %}"> - {% else %} - {{ link_or_button(remove_url, 'Remove partitioning'|trans, { - 'class': 'button ajax', - 'id': 'remove_partitioning' - }) }} - <input class="btn btn-secondary" type="submit" name="edit_partitioning" value="{% trans 'Edit partitioning' %}"> - {% endif %} - </form> - </fieldset> -</div> diff --git a/srcs/phpmyadmin/templates/table/structure/display_structure.twig b/srcs/phpmyadmin/templates/table/structure/display_structure.twig deleted file mode 100644 index 16e11db..0000000 --- a/srcs/phpmyadmin/templates/table/structure/display_structure.twig +++ /dev/null @@ -1,516 +0,0 @@ -{% extends 'table/page_with_secondary_tabs.twig' %} -{% block content %} -<form method="post" action="tbl_structure.php" name="fieldsForm" id="fieldsForm" - class="ajax{{ hide_structure_actions ? ' HideStructureActions' }}"> - {{ get_hidden_inputs(db, table) }} - <input type="hidden" name="table_type" value= - {%- if db_is_system_schema -%} - "information_schema" - {%- elseif tbl_is_view -%} - "view" - {%- else -%} - "table" - {%- endif %}> - <div class="responsivetable"> - <table id="tablestructure" class="data topmargin"> - {# Table header #} - <thead> - <tr> - <th class="print_ignore"></th> - <th>#</th> - <th>{% trans 'Name' %}</th> - <th>{% trans 'Type' %}</th> - <th>{% trans 'Collation' %}</th> - <th>{% trans 'Attributes' %}</th> - <th>{% trans 'Null' %}</th> - <th>{% trans 'Default' %}</th> - {% if show_column_comments -%} - <th>{% trans 'Comments' %}</th> - {%- endif %} - <th>{% trans 'Extra' %}</th> - {# @see table/structure.js, function moreOptsMenuResize() #} - {% if not db_is_system_schema and not tbl_is_view %} - <th colspan="{{ show_icons('ActionLinksMode') ? '8' : '9' -}} - " class="action print_ignore">{% trans 'Action' %}</th> - {% endif %} - </tr> - </thead> - <tbody> - {# Table body #} - {% set rownum = 0 %} - {% for row in fields %} - {% set rownum = rownum + 1 %} - - {% set extracted_columnspec = extracted_columnspecs[rownum] %} - {% set field_name = row['Field']|e %} - {# For column comments #} - {% set comments = row_comments[rownum] %} - {# Underline commented fields and display a hover-title (CSS only) #} - - <tr> - <td class="center print_ignore"> - <input type="checkbox" class="checkall" name="selected_fld[]" value="{{ row['Field'] }}" id="checkbox_row_{{ rownum }}"> - </td> - <td class="right">{{ rownum }}</td> - <th class="nowrap"> - <label for="checkbox_row_{{ rownum }}"> - {% if displayed_fields[rownum].comment is defined %} - <span class="commented_column" title="{{ displayed_fields[rownum].comment }}">{{ displayed_fields[rownum].text }}</span> - {% else %} - {{ displayed_fields[rownum].text }} - {% endif %} - {{ displayed_fields[rownum].icon|raw }} - </label> - </th> - <td{{ 'set' != extracted_columnspec['type'] and 'enum' != extracted_columnspec['type'] ? ' class="nowrap"' }}> - <bdo dir="ltr" lang="en"> - {{ extracted_columnspec['displayed_type']|raw }} - {% if relation_commwork and relation_mimework and browse_mime - and mime_map[row['Field']]['mimetype'] is defined %} - <br>{% trans 'Media (MIME) type:' %} {{ mime_map[row['Field']]['mimetype']|replace({'_': '/'})|lower }} - {% endif %} - </bdo> - </td> - <td> - {% if row['Collation'] is not empty %} - <dfn title="{{ collations[row['Collation']].description }}">{{ collations[row['Collation']].name }}</dfn> - {% endif %} - </td> - <td class="column_attribute nowrap">{{ attributes[rownum] }}</td> - <td>{{ row['Null'] == 'YES' ? 'Yes'|trans : 'No'|trans }}</td> - <td class="nowrap"> - {% if row['Default'] is not null %} - {% if extracted_columnspec['type'] == 'bit' %} - {{ row['Default']|convert_bit_default_value }} - {% else %} - {{ row['Default'] }} - {% endif %} - {% elseif row['Null'] == 'YES' %} - <em>NULL</em> - {% else %} - <em>{% trans %}None{% context %}None for default{% endtrans %}</em> - {% endif %} - </td> - {% if show_column_comments %} - <td> - {{ comments }} - </td> - {% endif %} - <td class="nowrap">{{ row['Extra']|upper }}</td> - {% if not tbl_is_view and not db_is_system_schema %} - <td class="edit center print_ignore"> - <a class="change_column_anchor ajax" href="tbl_structure.php - {{- url_query }}&field={{ row['Field']|url_encode }}&change_column=1"> - {{ titles['Change']|raw }} - </a> - </td> - <td class="drop center print_ignore"> - <a class="drop_column_anchor ajax" href="sql.php" data-post="{{ url_query }}&sql_query= - {{- ('ALTER TABLE ' ~ backquote(table) - ~ ' DROP ' ~ backquote(row['Field']) ~ ';')|url_encode -}} - &dropped_column={{ row['Field']|url_encode }}&purge=1&message_to_show= - {{- ('Column %s has been dropped.'|trans|format(row['Field']|e))|url_encode }}"> - {{ titles['Drop']|raw }} - </a> - </td> - {% endif %} - - {% if not tbl_is_view and not db_is_system_schema %} - {% set type = extracted_columnspec['print_type'] is not empty ? extracted_columnspec['print_type'] %} - <td class="print_ignore"> - <ul class="table-structure-actions resizable-menu"> - {% if hide_structure_actions %} - <li class="submenu shown"> - <a href="#" class="tab nowrap">{{ get_icon('b_more', 'More'|trans) }}</a> - <ul> - {% endif %} - {# Add primary #} - {% include 'table/structure/action_row_in_structure_table.twig' with { - 'type': type, - 'tbl_storage_engine': tbl_storage_engine, - 'class': 'primary nowrap', - 'has_field': primary and primary.hasColumn(field_name), - 'has_link_class': true, - 'url_query': url_query, - 'primary': primary, - 'syntax': 'ADD PRIMARY KEY', - 'message': 'A primary key has been added on %s.'|trans, - 'action': 'Primary', - 'titles': titles, - 'row': row, - 'is_primary': true, - 'table': table - } only %} - - {# Add unique #} - {% include 'table/structure/action_row_in_structure_table.twig' with { - 'type': type, - 'tbl_storage_engine': tbl_storage_engine, - 'class': 'add_unique unique nowrap', - 'has_field': field_name in columns_with_unique_index, - 'has_link_class': false, - 'url_query': url_query, - 'primary': primary, - 'syntax': 'ADD UNIQUE', - 'message': 'An index has been added on %s.'|trans, - 'action': 'Unique', - 'titles': titles, - 'row': row, - 'is_primary': false, - 'table': table - } only %} - - {# Add index #} - {% include 'table/structure/action_row_in_structure_table.twig' with { - 'type': type, - 'tbl_storage_engine': tbl_storage_engine, - 'class': 'add_index nowrap', - 'has_field': false, - 'has_link_class': false, - 'url_query': url_query, - 'primary': primary, - 'syntax': 'ADD INDEX', - 'message': 'An index has been added on %s.'|trans, - 'action': 'Index', - 'titles': titles, - 'row': row, - 'is_primary': false, - 'table': table - } only %} - - {# Add spatial #} - {% set spatial_types = [ - 'geometry', - 'point', - 'linestring', - 'polygon', - 'multipoint', - 'multilinestring', - 'multipolygon', - 'geomtrycollection' - ] %} - {% include 'table/structure/action_row_in_structure_table.twig' with { - 'type': type, - 'tbl_storage_engine': tbl_storage_engine, - 'class': 'spatial nowrap', - 'has_field': type not in spatial_types and - (tbl_storage_engine == 'MYISAM' or mysql_int_version >= 50705), - 'has_link_class': false, - 'url_query': url_query, - 'primary': primary, - 'syntax': 'ADD SPATIAL', - 'message': 'An index has been added on %s.'|trans, - 'action': 'Spatial', - 'titles': titles, - 'row': row, - 'is_primary': false, - 'table': table - } only %} - - {# FULLTEXT is possible on TEXT, CHAR and VARCHAR #} - <li class="fulltext nowrap"> - {% if tbl_storage_engine is not empty and ( - tbl_storage_engine == 'MYISAM' - or tbl_storage_engine == 'ARIA' - or tbl_storage_engine == 'MARIA' - or (tbl_storage_engine == 'INNODB' and mysql_int_version >= 50604) - ) and ('text' in type or 'char' in type) %} - <a rel="samepage" class="ajax add_key add_fulltext_anchor" href="tbl_structure.php" - data-post="{{- url_query|raw }}&add_key=1&sql_query= - {{- ('ALTER TABLE ' ~ backquote(table) - ~ ' ADD FULLTEXT(' ~ backquote(row['Field']) - ~ ');')|url_encode }}&message_to_show= - {{- ('An index has been added on %s.'|trans|format(row['Field']|e))|url_encode }}"> - {{ titles['IdxFulltext']|raw }} - </a> - {% else %} - {{ titles['NoIdxFulltext']|raw }} - {% endif %} - </li> - - {# Distinct value action #} - <li class="browse nowrap"> - <a href="sql.php" data-post="{{ url_query|raw }}&sql_query= - {{- ('SELECT COUNT(*) AS ' ~ backquote('Rows'|trans) - ~ ', ' ~ backquote(row['Field']) - ~ ' FROM ' ~ backquote(table) - ~ ' GROUP BY ' ~ backquote(row['Field']) - ~ ' ORDER BY ' ~ backquote(row['Field']))|url_encode -}} - &is_browse_distinct=1"> - {{ titles['DistinctValues']|raw }} - </a> - </li> - {% if central_columns_work %} - <li class="browse nowrap"> - {% if row['Field'] in central_list %} - <a href="#" class="central_columns remove_button"> - {{ get_icon('centralColumns_delete', 'Remove from central columns'|trans) }} - </a> - {% else %} - <a href="#" class="central_columns add_button"> - {{ get_icon('centralColumns_add', 'Add to central columns'|trans) }} - </a> - {% endif %} - </li> - {% endif %} - {% if hide_structure_actions %} - </ul> - </li> - {% endif %} - </ul> - </td> - {% endif %} - </tr> - {% endfor %} - </tbody> - </table> - </div> - <div class="print_ignore"> - {% include 'select_all.twig' with { - 'pma_theme_image': pma_theme_image, - 'text_dir': text_dir, - 'form_name': 'fieldsForm' - } only %} - - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Browse'|trans, - 'b_browse', - 'browse' - ) }} - - {% if not tbl_is_view and not db_is_system_schema %} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit change_columns_anchor ajax', - 'Change'|trans, - 'b_edit', - 'change' - ) }} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Drop'|trans, - 'b_drop', - 'drop' - ) }} - - {% if tbl_storage_engine != 'ARCHIVE' %} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Primary'|trans, - 'b_primary', - 'primary' - ) }} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Unique'|trans, - 'b_unique', - 'unique' - ) }} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Index'|trans, - 'b_index', - 'index' - ) }} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Fulltext'|trans, - 'b_ftext', - 'ftext' - ) }} - - {% if tbl_storage_engine is not empty and ( - tbl_storage_engine == 'MYISAM' - or tbl_storage_engine == 'ARIA' - or tbl_storage_engine == 'MARIA') %} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Fulltext'|trans, - 'b_ftext', - 'ftext' - ) }} - {% endif %} - - {% if central_columns_work %} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Add to central columns'|trans, - 'centralColumns_add', - 'add_to_central_columns' - ) }} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Remove from central columns'|trans, - 'centralColumns_delete', - 'remove_from_central_columns' - ) }} - {% endif %} - {% endif %} - {% endif %} - </div> -</form> -<hr class="print_ignore"> -<div id="move_columns_dialog" class="hide" title="{% trans 'Move columns' %}"> - <p>{% trans 'Move the columns by dragging them up and down.' %}</p> - <form action="tbl_structure.php" name="move_column_form" id="move_column_form"> - <div> - {{ get_hidden_inputs(db, table) }} - <ul></ul> - </div> - </form> -</div> -{# Work on the table #} -<div id="structure-action-links"> - {% if tbl_is_view and not db_is_system_schema %} - {% set edit_view_url = 'view_create.php' ~ edit_view_url %} - {{ link_or_button( - edit_view_url, - get_icon('b_edit', 'Edit view'|trans, true) - ) }} - {% endif %} - <a href="#" id="printView">{{ get_icon('b_print', 'Print'|trans, true) }}</a> - {% if not tbl_is_view and not db_is_system_schema %} - {# Only display propose table structure for MySQL < 8.0 #} - {% if mysql_int_version < 80000 or is_mariadb %} - <a href="sql.php" data-post="{{ url_query|raw }}&session_max_rows=all&sql_query= - {{- ('SELECT * FROM ' ~ backquote(table) ~ ' PROCEDURE ANALYSE()')|url_encode -}} - " style="margin-right: 0;"> - {{ get_icon( - 'b_tblanalyse', - 'Propose table structure'|trans, - true - ) }} - </a> - {{ show_mysql_docu('procedure_analyse') }} - {% endif %} - {% if is_active %} - <a href="tbl_tracking.php{{ url_query|raw }}"> - {{ get_icon('eye', 'Track table'|trans, true) }} - </a> - {% endif %} - <a href="#" id="move_columns_anchor"> - {{ get_icon('b_move', 'Move columns'|trans, true) }} - </a> - <a href="normalization.php{{ url_query|raw }}"> - {{ get_icon('normalize', 'Normalize'|trans, true) }} - </a> - {% endif %} - {% if tbl_is_view and not db_is_system_schema %} - {% if is_active %} - <a href="tbl_tracking.php{{ url_query|raw }}"> - {{ get_icon('eye', 'Track view'|trans, true) }} - </a> - {% endif %} - {% endif %} -</div> -{% if not tbl_is_view and not db_is_system_schema %} - <form method="post" action="tbl_addfield.php" id="addColumns" name="addColumns"> - {{ get_hidden_inputs(db, table) }} - {% if show_icons('ActionLinksMode') %} - {{ get_image('b_insrow', 'Add column'|trans) }} - {% endif %} - {% set num_fields -%} - <input type="number" name="num_fields" value="1" onfocus="this.select()" min="1" required> - {%- endset %} - {{ 'Add %s column(s)'|trans|format(num_fields)|raw }} - <input type="hidden" name="field_where" value="after"> - {# I tried displaying the drop-down inside the label but with Firefox the drop-down was blinking #} - <select name="after_field"> - <option value="first" data-pos="first"> - {% trans 'at beginning of table' %} - </option> - {% for one_column_name in columns_list %} - <option value="{{ one_column_name }}" - {{- loop.revindex0 == 0 ? ' selected="selected"' }}> - {{ 'after %s'|trans|format(one_column_name) }} - </option> - {% endfor %} - </select> - <input class="btn btn-primary" type="submit" value="{% trans 'Go' %}"> - </form> -{% endif %} - -{# Displays indexes #} -{% if not tbl_is_view and not db_is_system_schema - and 'ARCHIVE' != tbl_storage_engine %} - {{ displayIndexesHtml|raw }} -{% endif %} - -{# Display partition details #} -{% if have_partitioning %} - {# Detect partitioning #} - {% if partition_names is not empty and partition_names[0] is not null %} - {% set first_partition = partitions[0] %} - {% set range_or_list = first_partition.getMethod() == 'RANGE' - or first_partition.getMethod() == 'RANGE COLUMNS' - or first_partition.getMethod() == 'LIST' - or first_partition.getMethod() == 'LIST COLUMNS' %} - {% set sub_partitions = first_partition.getSubPartitions() %} - {% set has_sub_partitions = first_partition.hasSubPartitions() %} - {% if has_sub_partitions %} - {% set first_sub_partition = sub_partitions[0] %} - {% endif %} - - {% set action_icons = { - 'ANALYZE': get_icon('b_search', 'Analyze'|trans), - 'CHECK': get_icon('eye', 'Check'|trans), - 'OPTIMIZE': get_icon('normalize', 'Optimize'|trans), - 'REBUILD': get_icon('s_tbl', 'Rebuild'|trans), - 'REPAIR': get_icon('b_tblops', 'Repair'|trans), - 'TRUNCATE': get_icon('b_empty', 'Truncate'|trans), - } %} - {% if range_or_list %} - {% set action_icons = action_icons|merge({'DROP': get_icon('b_drop', 'Drop'|trans)}) %} - {% endif %} - - {# open Slider Effect div #} - {% include 'div_for_slider_effect.twig' with { - 'id': 'partitions-2', - 'message': 'Partitions'|trans, - 'initial_sliders_state': default_sliders_state - } only %} - - {% set remove_sql = 'ALTER TABLE ' ~ backquote(table) ~ ' REMOVE PARTITIONING' %} - {% set remove_url = 'sql.php' ~ url_query ~ '&sql_query=' ~ remove_sql|url_encode %} - - {% include 'table/structure/display_partitions.twig' with { - 'db': db, - 'table': table, - 'url_query': url_query, - 'partitions': partitions, - 'partition_method': first_partition.getMethod(), - 'partition_expression': first_partition.getExpression(), - 'has_description': first_partition.getDescription() is not empty, - 'has_sub_partitions': has_sub_partitions, - 'sub_partition_method': has_sub_partitions ? first_sub_partition.getMethod(), - 'sub_partition_expression': has_sub_partitions ? first_sub_partition.getExpression(), - 'action_icons': action_icons, - 'range_or_list': range_or_list, - 'remove_url': remove_url - } only %} - {% else %} - {% include 'table/structure/display_partitions.twig' with { - 'db': db, - 'table': table - } only %} - {% endif %} - {# For closing Slider effect div #} - </div> -{% endif %} - -{# Displays Space usage and row statistics #} -{% if show_stats %} - {{ table_stats|raw }} -{% endif %} -<div class="clearfloat"></div> -{% endblock %} diff --git a/srcs/phpmyadmin/templates/table/structure/display_table_stats.twig b/srcs/phpmyadmin/templates/table/structure/display_table_stats.twig deleted file mode 100644 index 01c74ae..0000000 --- a/srcs/phpmyadmin/templates/table/structure/display_table_stats.twig +++ /dev/null @@ -1,169 +0,0 @@ -<div id="tablestatistics"> - <fieldset> - <legend>{% trans 'Information' %}</legend> - {% if showtable['TABLE_COMMENT'] %} - <p> - <strong>{% trans 'Table comments:' %}</strong> - {{ showtable['TABLE_COMMENT'] }} - </p> - {% endif %} - <a id="showusage"></a> - - {% if not tbl_is_view and not db_is_system_schema %} - <table id="tablespaceusage" class="width100 data"> - <caption class="tblHeaders">{% trans 'Space usage' %}</caption> - <tbody> - <tr> - <th class="name">{% trans 'Data' %}</th> - <td class="value">{{ data_size }}</td> - <td class="unit">{{ data_unit }}</td> - </tr> - - {% if index_size is defined %} - <tr> - <th class="name">{% trans 'Index' %}</th> - <td class="value">{{ index_size }}</td> - <td class="unit">{{ index_unit }}</td> - </tr> - {% endif %} - - {% if free_size is defined %} - <tr> - <th class="name">{% trans 'Overhead' %}</th> - <td class="value">{{ free_size }}</td> - <td class="unit">{{ free_unit }}</td> - </tr> - <tr> - <th class="name">{% trans 'Effective' %}</th> - <td class="value">{{ effect_size }}</td> - <td class="unit">{{ effect_unit }}</td> - </tr> - {% endif %} - - {% if tot_size is defined and mergetable == false %} - <tr> - <th class="name">{% trans 'Total' %}</th> - <td class="value">{{ tot_size }}</td> - <td class="unit">{{ tot_unit }}</td> - </tr> - {% endif %} - - {# Optimize link if overhead #} - {% if free_size is defined - and (tbl_storage_engine == 'MYISAM' - or tbl_storage_engine == 'ARIA' - or tbl_storage_engine == 'MARIA' - or tbl_storage_engine == 'BDB') - or (tbl_storage_engine == 'INNODB' and innodb_file_per_table == true) %} - <tr class="tblFooters print_ignore"> - <td colspan="3" class="center"> - <a href="sql.php" data-post="{{ url_query }}&pos=0&sql_query= - {{- ('OPTIMIZE TABLE ' ~ backquote(table))|url_encode }}"> - {{ get_icon('b_tbloptimize', 'Optimize table'|trans) }} - </a> - </td> - </tr> - {% endif %} - </tbody> - </table> - {% endif %} - - {% set avg_size = avg_size is defined ? avg_size : null %} - {% set avg_unit = avg_unit is defined ? avg_unit : null %} - <table id="tablerowstats" class="width100 data"> - <caption class="tblHeaders">{% trans 'Row statistics' %}</caption> - <tbody> - {% if showtable['Row_format'] is defined %} - <tr> - <th class="name">{% trans 'Format' %}</th> - {% if showtable['Row_format'] == 'Fixed' %} - <td class="value">{% trans 'static' %}</td> - {% elseif showtable['Row_format'] == 'Dynamic' %} - <td class="value">{% trans 'dynamic' %}</td> - {% else %} - <td class="value">{{ showtable['Row_format'] }}</td> - {% endif %} - </tr> - {% endif %} - - {% if showtable['Create_options'] is not empty %} - <tr> - <th class="name">{% trans 'Options' %}</th> - {% if showtable['Create_options'] == 'partitioned' %} - <td class="value">{% trans 'partitioned' %}</td> - {% else %} - <td class="value">{{ showtable['Create_options'] }}</td> - {% endif %} - </tr> - {% endif %} - - {% if table_collation is not empty %} - <tr> - <th class="name">{% trans 'Collation' %}</th> - <td class="value"> - <dfn title="{{ table_collation.description }}"> - {{ table_collation.name }} - </dfn> - </td> - </tr> - {% endif %} - - {% if not is_innodb and showtable['Rows'] is defined %} - <tr> - <th class="name">{% trans 'Rows' %}</th> - <td class="value">{{ format_number(showtable['Rows'], 0) }}</td> - </tr> - {% endif %} - - {% if not is_innodb - and showtable['Avg_row_length'] is defined - and showtable['Avg_row_length'] > 0 %} - <tr> - <th class="name">{% trans 'Row length' %}</th> - {% set avg_row_length = format_byte_down(showtable['Avg_row_length'], 6, 1) %} - <td class="value">{{ avg_row_length[0] }} {{ avg_row_length[1] }}</td> - </tr> - {% endif %} - - {% if not is_innodb - and showtable['Data_length'] is defined - and showtable['Rows'] is defined - and showtable['Rows'] > 0 - and mergetable == false %} - <tr> - <th class="name">{% trans 'Row size' %}</th> - <td class="value">{{ avg_size }} {{ avg_unit }}</td> - </tr> - {% endif %} - - {% if showtable['Auto_increment'] is defined %} - <tr> - <th class="name">{% trans 'Next autoindex' %}</th> - <td class="value">{{ format_number(showtable['Auto_increment'], 0) }}</td> - </tr> - {% endif %} - - {% if showtable['Create_time'] is defined %} - <tr> - <th class="name">{% trans 'Creation' %}</th> - <td class="value">{{ localised_date(showtable['Create_time']|date('U')) }}</td> - </tr> - {% endif %} - - {% if showtable['Update_time'] is defined %} - <tr> - <th class="name">{% trans 'Last update' %}</th> - <td class="value">{{ localised_date(showtable['Update_time']|date('U')) }}</td> - </tr> - {% endif %} - - {% if showtable['Check_time'] is defined %} - <tr> - <th class="name">{% trans 'Last check' %}</th> - <td class="value">{{ localised_date(showtable['Check_time']|date('U')) }}</td> - </tr> - {% endif %} - </tbody> - </table> - </fieldset> -</div> diff --git a/srcs/phpmyadmin/templates/table/structure/partition_definition_form.twig b/srcs/phpmyadmin/templates/table/structure/partition_definition_form.twig deleted file mode 100644 index 7cf5e8d..0000000 --- a/srcs/phpmyadmin/templates/table/structure/partition_definition_form.twig +++ /dev/null @@ -1,14 +0,0 @@ -<form action="tbl_structure.php" method="post"> - {{ get_hidden_inputs(db, table) }} - <input type="hidden" name="edit_partitioning" value="true"> - - <fieldset> - <legend>{% trans 'Edit partitioning' %}</legend> - {% include 'columns_definitions/partitions.twig' with { - 'partition_details': partition_details - } only %} - </fieldset> - <fieldset class="tblFooters"> - <input class="btn btn-primary" type="submit" name="save_partitioning" value="{% trans 'Save' %}"> - </fieldset> -</form> diff --git a/srcs/phpmyadmin/templates/table/tracking/main.twig b/srcs/phpmyadmin/templates/table/tracking/main.twig deleted file mode 100644 index ff6c5c4..0000000 --- a/srcs/phpmyadmin/templates/table/tracking/main.twig +++ /dev/null @@ -1,132 +0,0 @@ -{% if selectable_tables_num_rows > 0 %} - <form method="post" action="tbl_tracking.php{{ url_query|raw }}"> - {{ get_hidden_inputs(db, table) }} - <select name="table" class="autosubmit"> - {% for entry in selectable_tables_entries %} - <option value="{{ entry.table_name }}" - {{- entry.table_name == selected_table ? ' selected' }}> - {{ entry.db_name }}.{{ entry.table_name }} - {% if entry.is_tracked %} - ({% trans 'active' %}) - {% else %} - ({% trans 'not active' %}) - {% endif %} - </option> - {% endfor %} - </select> - <input type="hidden" name="show_versions_submit" value="1"> - </form> -{% endif %} -<br> -{% if last_version > 0 %} - <form method="post" action="tbl_tracking.php" name="versionsForm" id="versionsForm" class="ajax"> - {{ get_hidden_inputs(db, table) }} - <table id="versions" class="data"> - <thead> - <tr> - <th></th> - <th>{% trans 'Version' %}</th> - <th>{% trans 'Created' %}</th> - <th>{% trans 'Updated' %}</th> - <th>{% trans 'Status' %}</th> - <th>{% trans 'Action' %}</th> - <th>{% trans 'Show' %}</th> - </tr> - </thead> - <tbody> - {% for version in versions %} - <tr> - <td class="center"> - <input type="checkbox" name="selected_versions[]" - class="checkall" id="selected_versions_{{- version['version']|escape }}" - value="{{- version['version']|escape }}"> - </td> - <td class="floatright"> - <label for="selected_versions_{{- version['version']|escape }}"> - <b>{{ version['version']|escape }}</b> - </label> - </td> - <td>{{ version['date_created']|escape }}</td> - <td>{{ version['date_updated']|escape }}</td> - {% if version['tracking_active'] == 1 %} - {% set last_version_status = 1 %} - <td>{% trans 'active' %}</td> - {% else %} - {% set last_version_status = 0 %} - <td>{% trans 'not active' %}</td> - {% endif %} - <td> - <a class="delete_version_anchor ajax" href="tbl_tracking.php" data-post=" - {{- get_common(url_params|merge({ - 'version': version['version'], - 'submit_delete_version': true - }), '') }}"> - {{ get_icon('b_drop', 'Delete version'|trans) }} - </a> - </td> - <td> - <a href="tbl_tracking.php" data-post=" - {{- get_common(url_params|merge({ - 'version': version['version'], - 'report': 'true' - }), '') }}"> - {{ get_icon('b_report', 'Tracking report'|trans) }} - </a> - <a href="tbl_tracking.php" data-post=" - {{- get_common(url_params|merge({ - 'version': version['version'], - 'snapshot': 'true' - }), '') }}"> - {{ get_icon('b_props', 'Structure snapshot'|trans) }} - </a> - </td> - </tr> - {% endfor %} - </tbody> - </table> - {% include 'select_all.twig' with { - 'pma_theme_image': pmaThemeImage, - 'text_dir': text_dir, - 'form_name': 'versionsForm', - } only %} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Delete version'|trans, - 'b_drop', - 'delete_version' - ) }} - </form> - {% set last_version_element = versions|first %} - <div> - <form method="post" action="tbl_tracking.php{{ url_query|raw }}"> - {{ get_hidden_inputs(db, table) }} - <fieldset> - <legend> - {% if last_version_element['tracking_active'] == 0 %} - {% set legend = 'Activate tracking for %s'|trans %} - {% set value = 'activate_now' %} - {% set button = 'Activate now'|trans %} - {% else %} - {% set legend = 'Deactivate tracking for %s'|trans %} - {% set value = 'deactivate_now' %} - {% set button = 'Deactivate now'|trans %} - {% endif %} - - {{ legend|format(db ~ '.' ~ table) }} - </legend> - <input type="hidden" name="version" value="{{ last_version }}"> - <input type="hidden" name="toggle_activation" value="{{ value }}"> - <input class="btn btn-secondary" type="submit" value="{{ button }}"> - </fieldset> - </form> - </div> -{% endif %} -{% include 'create_tracking_version.twig' with { - 'url_query': url_query, - 'last_version': last_version, - 'db': db, - 'selected': [table], - 'type': type, - 'default_statements': default_statements, -} only %} diff --git a/srcs/phpmyadmin/templates/table/tracking/report_table.twig b/srcs/phpmyadmin/templates/table/tracking/report_table.twig deleted file mode 100644 index fe00526..0000000 --- a/srcs/phpmyadmin/templates/table/tracking/report_table.twig +++ /dev/null @@ -1,27 +0,0 @@ -<table id="{{ table_id }}" class="data"> - <thead> - <tr> - <th>{% trans %}#{% context %}Number{% endtrans %}</th> - <th>{% trans 'Date' %}</th> - <th>{% trans 'Username' %}</th> - <th>{{ header_message }}</th> - <th>{% trans 'Action' %}</th> - </tr> - </thead> - <tbody> - {% for entry in entries %} - <tr class="noclick"> - <td class="right"><small>{{ entry.line_number }}</small></td> - <td><small>{{ entry.date }}</small></td> - <td><small>{{ entry.username }}</small></td> - <td>{{ entry.formated_statement|raw }}</td> - <td class="nowrap"> - <a class="delete_entry_anchor ajax" href="tbl_tracking.php" data-post=" - {{- entry.url_params|raw }}"> - {{ drop_image_or_text|raw }} - </a> - </td> - </tr> - {% endfor %} - </tbody> -</table> diff --git a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig deleted file mode 100644 index 4ef8c21..0000000 --- a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig +++ /dev/null @@ -1,56 +0,0 @@ -<h3>{% trans 'Structure' %}</h3> -<table id="tablestructure" class="data"> - <thead> - <tr> - <th>{% trans %}#{% context %}Number{% endtrans %}</th> - <th>{% trans 'Column' %}</th> - <th>{% trans 'Type' %}</th> - <th>{% trans 'Collation' %}</th> - <th>{% trans 'Null' %}</th> - <th>{% trans 'Default' %}</th> - <th>{% trans 'Extra' %}</th> - <th>{% trans 'Comment' %}</th> - </tr> - </thead> - <tbody> - {% set index = 1 %} - {% for field in columns %} - <tr class="noclick"> - <td>{{ index }}</td> - {% set index = index + 1 %} - <td> - <strong> - {{ field['Field'] }} - {% if field['Key'] == 'PRI' %} - {{ get_image('b_primary', 'Primary'|trans) }} - {% elseif field['Key'] is not empty %} - {{ get_image('bd_primary', 'Index'|trans) }} - {% endif %} - </strong> - </td> - <td>{{ field['Type'] }}</td> - <td>{{ field['Collation'] }}</td> - <td>{{ field['Null'] == 'YES' ? 'Yes'|trans : 'No'|trans }}</td> - <td> - {% if field['Default'] is defined %} - {% set extracted_columnspec = extract_column_spec(field['Type']) %} - {% if extracted_columnspec['type'] == 'bit' %} - {# here, $field['Default'] contains something like b'010' #} - {{ field['Default']|convert_bit_default_value }} - {% else %} - {{ field['Default'] }} - {% endif %} - {% else %} - {% if field['Null'] == 'YES' %} - <em>NULL</em> - {% else %} - <em>{% trans %}None{% context %}None for default{% endtrans %}</em> - {% endif %} - {% endif %} - </td> - <td>{{ field['Extra'] }}</td> - <td>{{ field['Comment'] }}</td> - </tr> - {% endfor %} - </tbody> -</table> diff --git a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig deleted file mode 100644 index a919252..0000000 --- a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig +++ /dev/null @@ -1,33 +0,0 @@ -<h3>{% trans 'Indexes' %}</h3> -<table id="tablestructure_indexes" class="data"> - <thead> - <tr> - <th>{% trans 'Keyname' %}</th> - <th>{% trans 'Type' %}</th> - <th>{% trans 'Unique' %}</th> - <th>{% trans 'Packed' %}</th> - <th>{% trans 'Column' %}</th> - <th>{% trans 'Cardinality' %}</th> - <th>{% trans 'Collation' %}</th> - <th>{% trans 'Null' %}</th> - <th>{% trans 'Comment' %}</th> - </tr> - </thead> - <tbody> - {% for index in indexes %} - <tr class="noclick"> - <td> - <strong>{{ index['Key_name'] }}</strong> - </td> - <td>{{ index['Index_type'] }}</td> - <td>{{ index['Non_unique'] == 0 ? 'Yes'|trans : 'No'|trans }}</td> - <td>{{ index['Packed'] != '' ? 'Yes'|trans : 'No'|trans }}</td> - <td>{{ index['Column_name'] }}</td> - <td>{{ index['Cardinality'] }}</td> - <td>{{ index['Collation'] }}</td> - <td>{{ index['Null'] }}</td> - <td>{{ index['Comment'] }}</td> - </tr> - {% endfor %} - </tbody> -</table> |
