[Summary view] [Print] [Text view]

   1  <?php
   2  /*=======================================================================
   3   Nuke-Evolution Basic: Enhanced PHP-Nuke Web Portal System
   4   =======================================================================*/
   5  
   6  /************************************************************************/
   7  /* PHP-NUKE: Web Portal System                                          */
   8  /* ===========================                                          */
   9  /*                                                                      */
  10  /* Copyright (c) 2002 by Francisco Burzi                                */
  11  /* http://phpnuke.org                                                   */
  12  /*                                                                      */
  13  /* This program is free software. You can redistribute it and/or modify */
  14  /* it under the terms of the GNU General Public License as published by */
  15  /* the Free Software Foundation; either version 2 of the License.       */
  16  /************************************************************************/
  17  /*         Additional security & Abstraction layer conversion           */
  18  /*                           2003 chatserv                              */
  19  /*      http://www.nukefixes.com -- http://www.nukeresources.com        */
  20  /************************************************************************/
  21  
  22  /*****[CHANGES]**********************************************************
  23  -=[Base]=-
  24        Nuke Patched                             v3.1.0       06/26/2005
  25   ************************************************************************/
  26  
  27  if(!defined('NUKE_EVO')) exit;
  28  
  29  global $prefix, $db;
  30  
  31  $sql = "SELECT id, title FROM ".$prefix."_reviews ORDER BY id DESC LIMIT 0,10";
  32  $result = $db->sql_query($sql);
  33  while (list($id, $title) = $db->sql_fetchrow($result)) {
  34      $id = intval($id);
  35      $title = stripslashes($title);
  36      $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"modules.php?name=Reviews&amp;rop=showcontent&amp;id=$id\">$title</a><br />";
  37  }
  38  $db->sql_freeresult($result);
  39  
  40  ?>