[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3  + ----------------------------------------------------------------------------+
   4  |     e107 website system
   5  |
   6  |     ©Steve Dunstan 2001-2002
   7  |     http://e107.org
   8  |     jalist@e107.org
   9  |
  10  |     Released under the terms and conditions of the
  11  |     GNU General Public License (http://gnu.org).
  12  |
  13  |     $Source: /cvsroot/e107/e107_0.7/e107_plugins/alt_news/alt_news.php,v $
  14  |     $Revision: 1.10 $
  15  |     $Date: 2006/06/02 13:59:40 $
  16  |     $Author: lisa_ $
  17  +----------------------------------------------------------------------------+
  18  */
  19  
  20  if (!defined('e107_INIT')) { exit; }
  21  
  22  require_once(e_HANDLER."news_class.php");
  23  
  24  function alt_news($news_category) {
  25      global $ml, $sql, $aj, $ns;
  26      $ix = new news;
  27      if (strstr(e_QUERY, "cat")) {
  28          $category = $news_category;
  29          if ($category != 0) {
  30              $gen = new convert;
  31              $sql2 = new db;
  32              $sql->db_Select("news_category", "*", "category_id='".intval($category)."'");
  33              list($category_id, $category_name, $category_icon) = $sql->db_Fetch();
  34              $category_name = $aj->tpa($category_name);
  35              if (strstr($category_icon, "../")) {
  36                  $category_icon = str_replace("../", "", e_BASE.$category_icon);
  37              } else {
  38                  $category_icon = THEME.$category_icon;
  39              }
  40  
  41              if ($count = $sql->db_Select("news", "*", "news_category='".intval($category)."' ORDER BY news_datestamp DESC")) {
  42                  while ($row = $sql->db_Fetch()) {
  43                      extract($row);
  44                      if ($news_title == "") {
  45                          $news_title = "Untitled";
  46                      }
  47                      $datestamp = $gen->convert_date($news_datestamp, "short");
  48                      $news_body = strip_tags(substr($news_body, 0, 100))." ...";
  49                      $comment_total = $sql2->db_Count("comments", "(*)", "WHERE comment_item_id='".intval($news_id)."' AND comment_type='0' ");
  50                      $text .= "<div class='mediumtext'>
  51                          <img src='".THEME."images/".(defined("BULLET") ? BULLET : "bullet2.gif")."' alt='bullet' /> ";
  52  
  53                      if ($news_allow_comments) {
  54                          $text .= "<a href='news.php?extend.".$news_id."'>".$news_title."</a>";
  55                      } else {
  56                          $text .= "<a href='comment.php?comment.news.".$news_id."'>".$news_title."</a>";
  57                      }
  58                      $text .= "<br />
  59                          ".LAN_NEWS_100." ".$datestamp." (".LAN_NEWS_99.": ";
  60                      if ($news_allow_comments) {
  61                          $text .= COMMENTOFFSTRING.")";
  62                      } else {
  63                          $text .= $comment_total.")";
  64                      }
  65                      $text .= "</div>
  66                          ".$news_body."
  67                          <br /><br />\n";
  68                  }
  69                  $text = "<img src='$category_icon' alt='' /><br />". LAN_NEWS_307.$count."
  70                      <br /><br />".$text;
  71                  $ns->tablerender(LAN_NEWS_82." '".$category_name."'", $text, 'alt_news');
  72              }
  73          }
  74          return TRUE;
  75      }
  76  
  77      if ($sql->db_Select("news", "*", "news_class<255 AND (news_start=0 || news_start < ".time().") AND (news_end=0 || news_end>".time().") AND news_category='".intval($news_category)."' ORDER BY news_datestamp DESC LIMIT 0,".ITEMVIEW)) {
  78          $sql2 = new db;
  79          while (list($news['news_id'], $news['news_title'], $news['data'], $news['news_extended'], $news['news_datestamp'], $news['admin_id'], $news_category, $news['news_allow_comments'], $news['news_start'], $news['news_end'], $news['news_class']) = $sql->db_Fetch()) {
  80  
  81              if (check_class($news['news_class']) || !$news['news_class']) {
  82  
  83                  if ($news['admin_id'] == 1 && $pref['siteadmin']) {
  84                      $news['admin_name'] = $pref['siteadmin'];
  85                  }
  86                  else if(!$news['admin_name'] = getcachedvars($news['admin_id'])) {
  87                      $sql2->db_Select("user", "user_name", "user_id='".intval($news['admin_id'])."' ");
  88                      list($news['admin_name']) = $sql2->db_Fetch();
  89                      cachevars($news['admin_id'], $news['admin_name']);
  90                  }
  91  
  92                      $sql2->db_Select("news_category", "*", "category_id='".intval($news_category)."' ");
  93  
  94                  list($news['category_id'], $news['category_name'], $news['category_icon']) = $sql2->db_Fetch();
  95                  $news['comment_total'] = $sql2->db_Count("comments", "(*)", "WHERE comment_item_id='".intval($news['news_id'])."' AND comment_type='0' ");
  96                  $ix->render_newsitem($news);
  97              } else {
  98                  if ($pref['subnews_hide_news'] == 1) {
  99                      if ($news['admin_id'] == 1 && $pref['siteadmin']) {
 100                          $news['admin_name'] = $pref['siteadmin'];
 101                      }
 102                      else if(!$news['admin_name'] = getcachedvars($news['admin_id'])) {
 103                          $sql2->db_Select("user", "user_name", "user_id='".intval($news['admin_id'])."' ");
 104                          list($news['admin_name']) = $sql2->db_Fetch();
 105                          cachevars($news['admin_id'], $news['admin_name']);
 106                      }
 107  
 108                      $sql2->db_Select("news_category", "*", "category_id='".intval($news_category)."' ");
 109  
 110                      list($news['category_id'], $news['category_name'], $news['category_icon']) = $sql2->db_Fetch();
 111                      $ix->render_newsitem($news, "", "userclass");
 112                  }
 113              }
 114          }
 115      }
 116  }
 117  
 118  ?>