proposal quick fix for rebuilding search_table even if the

[platal.git] / templates / skin / common.database-debug.tpl

{**************************************************************************}
{*                                                                        *}
{*  Copyright (C) 2003-2007 Polytechnique.org                             *}
{*  http://opensource.polytechnique.org/                                  *}
{*                                                                        *}
{*  This program is free software; you can redistribute it and/or modify  *}
{*  it under the terms of the GNU General Public License as published by  *}
{*  the Free Software Foundation; either version 2 of the License, or     *}
{*  (at your option) any later version.                                   *}
{*                                                                        *}
{*  This program is distributed in the hope that it will be useful,       *}
{*  but WITHOUT ANY WARRANTY; without even the implied warranty of        *}
{*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *}
{*  GNU General Public License for more details.                          *}
{*                                                                        *}
{*  You should have received a copy of the GNU General Public License     *}
{*  along with this program; if not, write to the Free Software           *}
{*  Foundation, Inc.,                                                     *}
{*  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA               *}
{*                                                                        *}
{**************************************************************************}


{foreach item=query from=$trace_data}
{if $query.explain}
{assign var=cols value=$query.explain[0]|@count}
{else}
{assign var=cols value=1}
{/if}
<table class="bicol" style="width: 75%; font-size: smaller; margin-left:2px; margin-top: 3px;">
  <tr class="impair">
    <td colspan="{$cols}">
      <strong>QUERY:</strong>
      <pre style="padding: 0; margin: 0;">{$query.query}</pre>
      <br/>
    </td>
  </tr>
  {if $query.error}
  <tr>
    <td colspan="{$cols}">
      <strong style="color: #f00">ERROR:</strong><br />
      {$query.error|nl2br}
    </td>
  </tr>
  {else}
  <tr>
    <td colspan="{$cols}">
      <strong>INFO:</strong><br />
      {$query.rows} enregistrement{if $query.rows > 1}s{/if} en {$query.exectime}ms
    </td>
  </tr>
  {/if}
{if $query.explain}
  <tr>
    {foreach key=key item=item from=$query.explain[0]}
    <th style="font-size: smaller">{$key}</th>
    {/foreach}
  </tr>
  {foreach item=explain_row from=$query.explain}
  <tr class="impair">
    {foreach item=item from=$explain_row}
    <td class="center" style="font-size: smaller">{$item}</td>
    {/foreach}
  </tr>
  {/foreach}
{/if}
</table>
{/foreach}

{* vim:set et sw=2 sts=2 sws=2 enc=utf-8: *}