[Sommaire] [Imprimer]

   1  <?php
   2  /**
   3  * @version $Id: mod_stats.php 87 2005-09-15 23:12:03Z eddieajau $
   4  * @package Joomla
   5  * @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
   6  * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
   7  * Joomla! is free software. This version may have been modified pursuant
   8  * to the GNU General Public License, and as distributed it includes or
   9  * is derivative of works licensed under the GNU General Public License or
  10  * other free or open source software licenses.
  11  * See COPYRIGHT.php for copyright notices and details.
  12  */
  13  
  14  // no direct access
  15  defined( '_VALID_MOS' ) or die( 'Restricted access' );
  16  
  17  $query = "SELECT menutype, COUNT(id) AS numitems"
  18  . "\n FROM #__menu"
  19  . "\n WHERE published = 1"
  20  . "\n GROUP BY menutype"
  21  ;
  22  $database->setQuery( $query );
  23  $rows = $database->loadObjectList();
  24  ?>
  25  <table class="adminlist">
  26      <tr>
  27          <th class="title" width="80%">
  28              Menu
  29          </th>
  30          <th class="title">
  31              # Items
  32          </th>
  33      </tr>
  34  <?php
  35  foreach ($rows as $row) {
  36      $link = 'index2.php?option=com_menus&amp;menutype='. $row->menutype;
  37      ?>
  38      <tr>
  39          <td>
  40              <a href="<?php echo $link; ?>">
  41                  <?php echo $row->menutype;?></a>
  42          </td>
  43          <td>
  44              <?php echo $row->numitems;?>
  45          </td>
  46      </tr>
  47  <?php
  48  }
  49  ?>
  50  <tr>
  51      <th colspan="2">
  52      </th>
  53  </tr>
  54  </table>