[Sommaire] [Imprimer]

   1  <?php
   2  
   3  if (!defined('e107_INIT')) { exit; }
   4  
   5      $LIST_CAPTION = $arr[0];
   6      $LIST_DISPLAYSTYLE = ($arr[2] ? "" : "none");
   7  
   8      if($mode == "new_page" || $mode == "new_menu" ){
   9          $lvisit = $this -> getlvisit();
  10          $qry = " AND download_datestamp>".$lvisit;
  11      }else{
  12          $qry = " ";
  13      }
  14  
  15      $bullet = $this -> getBullet($arr[6], $mode);
  16  
  17      $mp = MPREFIX;
  18      $qry = "SELECT download_id, download_name, download_author, download_datestamp, {$mp}download_category.download_category_id, {$mp}download_category.download_category_name, {$mp}download_category.download_category_class FROM {$mp}download LEFT JOIN {$mp}download_category ON {$mp}download.download_category={$mp}download_category.download_category_id WHERE download_category_class REGEXP '".e_CLASS_REGEXP."' AND download_class REGEXP '".e_CLASS_REGEXP."' AND {$mp}download.download_active != '0' ".$qry." ORDER BY download_datestamp DESC LIMIT 0,".intval($arr[7])." ";
  19  
  20      $downloads = $sql -> db_Select_gen($qry);
  21      if($downloads == 0) {
  22          $LIST_DATA = LIST_DOWNLOAD_2;
  23      }else{
  24          while($row = $sql -> db_Fetch()){
  25  
  26              $rowheading    = $this -> parse_heading($row['download_name'], $mode);
  27              $ICON        = $bullet;
  28              $HEADING    = "<a href='".e_BASE."download.php?view.".$row['download_id']."' title='".$row['download_name']."'>".$rowheading."</a>";
  29              $AUTHOR        = ($arr[3] ? $row['download_author'] : "");
  30              //$AUTHOR    = ($arr[3] ? (USERID ? "<a href='".e_BASE."user.php?id.".$row['download_author_id']."'>".$row['download_author']."</a>" : $row['download_author']) : "");
  31              $CATEGORY    = ($arr[4] ? "<a href='".e_BASE."download.php?list.".$row['download_category_id']."'>".$row['download_category_name']."</a>" : "");
  32              $DATE        = ($arr[5] ? $this -> getListDate($row['download_datestamp'], $mode) : "");
  33              $INFO        = "";
  34              $LIST_DATA[$mode][] = array( $ICON, $HEADING, $AUTHOR, $CATEGORY, $DATE, $INFO );
  35          }
  36      }
  37  
  38  ?>