From 747ab5c7fe99ae0029190f3575394e47e4ef5483 Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Fri, 20 Feb 2004 11:48:20 +0000
Subject: [PATCH] explain change de structure parfois ...

---
 templates/database-debug.tpl | 22 ++++++----------------
 1 file changed, 6 insertions(+), 16 deletions(-)

diff --git a/templates/database-debug.tpl b/templates/database-debug.tpl
index 464599d..d678b57 100644
--- a/templates/database-debug.tpl
+++ b/templates/database-debug.tpl
@@ -20,24 +20,14 @@
 </table>
 <table class="bicol" style="width: 75%; font-family: fixed; margin-left: 2px; margin-bottom: 3px; margin-top: -1px;">
   <tr>
-    <th>table</th>
-    <th>type</th>
-    <th>possible_keys</th>
-    <th>key</th>
-    <th>key_len</th>
-    <th>ref</th>
-    <th>rows</th>
-    <th>extra</th>
+    {foreach key=key item=item from=$query.explain}
+    <th>{$key}</th>
+    {/foreach}
   </tr>
   <tr class="impair">
-    <td class="center">{$query.explain.table}</td>
-    <td class="center">{$query.explain.type}</td>
-    <td class="center">{$query.explain.possible_keys}</td>
-    <td class="center">{$query.explain.key}</td>
-    <td class="center">{$query.explain.key_len}</td>
-    <td class="center">{$query.explain.ref}</td>
-    <td class="center">{$query.explain.rows}</td>
-    <td class="center">{$query.explain.Extra}</td>
+    {foreach item=item from=$query.explain}
+    <td class="center">{$item}</td>
+    {/foreach}
   </tr>
 </table>
 {/foreach}
-- 
2.1.4