1 files changed, 39 insertions, 0 deletions
diff --git a/srcs/phpmyadmin/templates/server/status/advisor/index.twig b/srcs/phpmyadmin/templates/server/status/advisor/index.twig
new file mode 100644
index 0000000..b1bc3a9
--- /dev/null
+++ b/srcs/phpmyadmin/templates/server/status/advisor/index.twig
@@ -0,0 +1,39 @@
+{% extends 'server/status/base.twig' %}
+{% set active = 'advisor' %}
+
+{% block content %}
+
+  {% if data is not empty %}
+    <a href="#openAdvisorInstructions">{{ get_icon('b_help', 'Instructions'|trans) }}</a>
+
+    <div id="statustabs_advisor"></div>
+
+    <div id="advisorInstructionsDialog" class="hide">
+      <p>
+        {% trans %}
+          The Advisor system can provide recommendations on server variables by analyzing the server status variables.
+        {% endtrans %}
+      </p>
+      <p>
+        {% trans %}
+          Do note however that this system provides recommendations based on simple calculations and by rule of thumb which may not necessarily apply to your system.
+        {% endtrans %}
+      </p>
+      <p>
+        {% trans %}
+          Prior to changing any of the configuration, be sure to know what you are changing (by reading the documentation) and how to undo the change. Wrong tuning can have a very negative effect on performance.
+        {% endtrans %}
+      </p>
+      <p>
+        {% trans %}
+          The best way to tune your system would be to change only one setting at a time, observe or benchmark your database, and undo the change if there was no clearly measurable improvement.
+        {% endtrans %}
+      </p>
+    </div>
+
+    <div id="advisorData" class="hide">{{ data }}</div>
+  {% else %}
+    {{ 'Not enough privilege to view the advisor.'|trans|error }}
+  {% endif %}
+
+{% endblock %}