[Sommaire] [Imprimer]

   1  <?php
   2  
   3  if (!defined('e107_INIT')) { exit; }
   4  
   5      if(!$links_install = $sql -> db_Select("plugin", "*", "plugin_path = 'links_page' AND plugin_installflag = '1' ")){
   6          return;
   7      }
   8  
   9      $LIST_CAPTION = $arr[0];
  10      $LIST_DISPLAYSTYLE = ($arr[2] ? "" : "none");
  11  
  12      if($mode == "new_page" || $mode == "new_menu" ){
  13          $lvisit = $this -> getlvisit();
  14          $qry = " l.link_datestamp>".$lvisit." AND ";        
  15      }else{
  16          $qry = "";
  17      }
  18  
  19      $bullet = $this -> getBullet($arr[6], $mode);
  20  
  21      $qry = "
  22      SELECT l.*, c.link_category_id, c.link_category_name
  23      FROM #links_page AS l
  24      LEFT JOIN #links_page_cat AS c ON c.link_category_id = l.link_category
  25      WHERE ".$qry." l.link_class REGEXP '".e_CLASS_REGEXP."' AND c.link_category_class REGEXP '".e_CLASS_REGEXP."'
  26      ORDER BY l.link_datestamp DESC LIMIT 0,".intval($arr[7])." 
  27      ";
  28  
  29      if(!$sql -> db_Select_gen($qry)){
  30          $LIST_DATA = LIST_LINKS_2;
  31      }else{
  32          while($row = $sql -> db_Fetch()){
  33  
  34              $rowheading    = $this -> parse_heading($row['link_name'], $mode);
  35              $ICON        = $bullet;
  36              $HEADING    = "<a href='".$row['link_url']."' target='_blank' title='".$row['link_name']."'>".$rowheading."</a>";
  37              $AUTHOR        = "";
  38              $CATEGORY    = ($arr[4] ? "<a href='".e_PLUGIN."links_page/links.php?cat.".$row['link_category_id']."'>".$row['link_category_name']."</a>" : "");
  39              $DATE        = ($arr[5] ? ($row['link_datestamp'] > 0 ? $this -> getListDate($row['link_datestamp'], $mode) : "") : "");
  40              $INFO        = "";
  41              $LIST_DATA[$mode][] = array( $ICON, $HEADING, $AUTHOR, $CATEGORY, $DATE, $INFO );
  42  
  43          }
  44      }
  45  
  46  ?>