[Sommaire] [Imprimer]

   1  <?php
   2  /* Copyright (C) 2003 Rodolphe Quiedeville <rodolphe@quiedeville.org>
   3   *
   4   * This program is free software; you can redistribute it and/or modify
   5   * it under the terms of the GNU General Public License as published by
   6   * the Free Software Foundation; either version 2 of the License, or
   7   * (at your option) any later version.
   8   *
   9   * This program is distributed in the hope that it will be useful,
  10   * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12   * GNU General Public License for more details.
  13   *
  14   * You should have received a copy of the GNU General Public License
  15   * along with this program; if not, write to the Free Software
  16   * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  17   *
  18   * $Id: sqltables.php,v 1.7 2004/10/23 16:57:27 eldy Exp $
  19   * $Source: /cvsroot/dolibarr/dolibarr/htdocs/admin/sqltables.php,v $
  20   *
  21   */
  22  
  23  /*!    \file htdocs/admin/sqltables.php
  24          \brief      Page d'administration/configuration des tables sql
  25          \version    $Revision: 1.7 $
  26  */
  27  
  28  require ("./pre.inc.php");
  29  
  30  $langs->load("admin");
  31  
  32  if (!$user->admin)
  33    accessforbidden();
  34  
  35  
  36  llxHeader();
  37  
  38  print_barre_liste("Liste des tables", $page, "sqltables.php");
  39  
  40  $sql = "SELECT name, loaded FROM ".MAIN_DB_PREFIX."sqltables";
  41  
  42  print "<table class=\"noborder\" width=\"100%\">";
  43  print '<tr class="liste_titre">';
  44  print '<td>'.$langs->trans("Name").'</td>';
  45  print '<td align="center">Chargée</td>';
  46  print '<td align="center">'.$langs->trans("Action").'</td>';
  47    print "</tr>\n";
  48   
  49  if ( $db->query($sql) ) {
  50    $num = $db->num_rows();
  51    $i = 0;
  52  
  53    $var=True;
  54    while ($i < $num) {
  55      $objp = $db->fetch_object();
  56      $var=!$var;
  57      print "<tr $bc[$var]>";
  58      print "<td>$objp->name</td>\n";
  59      print '<td align="center">'.$objp->loaded."</td>\n";
  60  
  61      if ($objp->loaded) 
  62        {
  63      print '<td align="center"><a href="'.$PHPSELF.'?action=drop">Supprimer</td>';
  64        }
  65      else 
  66        {
  67      print '<td align="center"><a href="'.$PHPSELF.'?action=create">Créer</td>';
  68        }
  69      print "</tr>\n";
  70      $i++;
  71    }
  72    $db->free();
  73  }
  74  
  75  print "</table>";
  76  
  77  
  78  $db->close();
  79  
  80  llxFooter("<em>Derni&egrave;re modification $Date: 2004/10/23 16:57:27 $ r&eacute;vision $Revision: 1.7 $</em>");
  81  ?>