Care2007/include/inc_news_get.php

   1 <?php
   2 /*------begin------ This protection code was suggested by Luki R. luki@karet.org ---- */
   3 if (eregi("inc_news_get.php",$PHP_SELF))
   4         die('<meta http-equiv="refresh" content="0; url=../">');
   5 /*------end------*/
   6
   7 $dbtable='care_news_article';
   8 $today=date('Y-m-d');
   9
  10 /* Establish db connection */
  11 if(!isset($db) || !$db) include_once($root_path.'include/inc_db_makelink.php');
  12
  13 if($dblink_ok)
  14 {
  15
  16                 $str_sql="SELECT nr,title,preface,body,pic_mime FROM ".$dbtable."
  17                                         WHERE dept_nr=".$dept_nr;
  18
  19                 $stat_pending=" AND status<>'pending'";
  20                 $order_by_desc=" ORDER BY create_time DESC";
  21
  22                 for($i=1;$i<=$news_num_stop;$i++)
  23                 {
  24                   $sql=$str_sql." AND art_num='".$i."'";
  25                   $publish_when=" AND publish_date='".$today."'";
  26           if(defined('MODERATE_NEWS') && (MODERATE_NEWS==1))
  27                   {
  28                          $sql.=$publish_when.$stat_pending;
  29           }
  30                   else
  31                   {
  32                      $sql.=$publish_when;
  33                   }
  34
  35                   $sql.=$order_by_desc;
  36
  37                         if($ergebnis=$db->Execute($sql))
  38                 {
  39                                 if($rows=$ergebnis->RecordCount())
  40                                 {
  41                                         $art[$i]=$ergebnis->FetchRow();
  42                                 }
  43                                 else // if no file found get the last entry
  44                                 {
  45
  46                                   $sql=$str_sql." AND art_num='".$i."'";
  47                                   $publish_when=" AND publish_date<'".$today."'";
  48
  49                                   if(defined('MODERATE_NEWS') && (MODERATE_NEWS==1))
  50                           {
  51                                         $sql.=$publish_when.$stat_pending;
  52                   }
  53                           else
  54                           {
  55                                         $sql.=$publish_when;
  56                                   }
  57
  58                                   $sql.=$order_by_desc;
  59
  60                                    if($ergebnis=$db->Execute($sql))
  61                            {
  62                                           if($rows=$ergebnis->RecordCount())
  63                                           {
  64                                                 $art[$i]=$ergebnis->FetchRow();
  65                                           }
  66                                    }
  67                                 }
  68                         }
  69                 }
  70   } else { echo "$LDDbNoLink $sql<br>"; }
  71
  72 ?>