aboutsummaryrefslogtreecommitdiff
path: root/srcs/phpmyadmin/templates/table/relation
diff options
context:
space:
mode:
authorCharles Cabergs <me@cacharle.xyz>2020-07-27 10:05:23 +0200
committerCharles Cabergs <me@cacharle.xyz>2020-07-27 10:05:23 +0200
commit5bf66662a9bdd62c5bccab15e607cd95cfb8fcab (patch)
tree39a1a4629749056191c05dfd899f931701b7acf3 /srcs/phpmyadmin/templates/table/relation
parent5afd237bbd22028b85532b8c0b3fcead49a00764 (diff)
downloadft_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/relation')
-rw-r--r--srcs/phpmyadmin/templates/table/relation/common_form.twig223
-rw-r--r--srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig9
-rw-r--r--srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig136
-rw-r--r--srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig18
4 files changed, 0 insertions, 386 deletions
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>