<?php     
defined('C5_EXECUTE') or die(_("Access Denied."));
$site = 'http://'.$_SERVER["SERVER_NAME"];
 
 
      function translateFrom($text) {
         // old stuff. Can remove in a later version.
         $text = str_replace('href="{[CCM:BASE_URL]}', 'href="' . BASE_URL . DIR_REL, $text);
         $text = str_replace('src="{[CCM:REL_DIR_FILES_UPLOADED]}', 'src="' . BASE_URL . REL_DIR_FILES_UPLOADED, $text);
 
         // we have the second one below with the backslash due to a screwup in the
         // 5.1 release. Can remove in a later version.
 
         $text = preg_replace(
            array(
               '/{\[CCM:BASE_URL\]}/i',
               '/{CCM:BASE_URL}/i'),
            array(
               BASE_URL . DIR_REL,
               BASE_URL . DIR_REL)
            , $text);
 
         // now we add in support for the links
 
         $text = preg_replace(
            array(
            '/{CCM:CID_([0-9]+)}/i'),
            array(),            
            $text);
 
         // now we add in support for the files
 
         $text = preg_replace_callback(
            array(
            '/{CCM:FID_([0-9]+)}/i'),
            "replaceFileID",            
            $text);
 
         return $text;
      }
 
      function replaceFileID($match) {
         $fID = $match[1];
         if ($fID > 0) {
            $path = File::getRelativePathFromID($fID);
            return $path;
         }
      }
 
      function replaceCollectionID($match) {
         $cID = $match[1];
         if ($cID > 0) {
            $path = Page::getCollectionPathFromID($cID);
            if (URL_REWRITING == true) {
               $path = DIR_REL . $path;
            } else {
               $path = DIR_REL . '/' . DISPATCHER_FILENAME . $path;
            }
            return $path;
         }
      }
 
      function getBPath($path){
         $db = Loader::db();
         $r = $db->Execute("SELECT cPath FROM PagePaths WHERE cID = '$path' ");
         while ($row = $r->FetchRow()) {
         $pIDp = $row['cPath'];
         return $pIDp ;
         }
      }
 
      function grabURL($site, $cParentID) {
         $url = $site.View::url(getBPath($cParentID));
         return $url;
      }
 
      function getID($ctID){
         $db = Loader::db();
         $r = $db->Execute("select cParentID from btAddNews where ctID= '$ctID'");
         while ($row = $r->FetchRow()) {
         $cParentID = $row['cParentID'];
         return $cParentID;
         }
      }
 
      function getBlockPath($path){
         $db = Loader::db();
         $r = $db->Execute("SELECT cPath FROM PagePaths WHERE cID = '$path' ");
         while ($row = $r->FetchRow()) {
            $pIDp = $row['cPath'];
            return $pIDp ;
         }
      }
 
      function rssInfo($bID, $site, $cID) {
         $db = Loader::db();
         $r = $db->Execute("select bID, ctID, rssTitle, rssDescription from btNewsList where bID = '$bID'");
         while ($row = $r->FetchRow()) {
                $url = $site.View::url(getBlockPath($cID)).'index.php?cID='.getID($cID) ;
               $rssInfo =  '<title>'.$row['rssTitle'].'</title>';
               $rssInfo .=  '<link>'.$url.'</link>';
               $rssInfo .= '<description>'.$row['rssDescription'].'</description>';
               echo $rssInfo;
            }
         }
 
 
      function getFeed($ctID, $site) {
 
         $strip = array("&nbsp;","&");
                        $rplace = array(" ","and");
 
         $db = Loader::db();
 
      //grab the block ID number from the main C5 block list   
         $gb= $db->Query("SELECT btID FROM BlockTypes WHERE btHandle = 'add_news'" );
         $row= $gb->FetchRow();
         $gb = $row['btID'];
      //grab all blocks, including versioned, from the AddNews block table   , and order them by the start date
         $g = $db->query("SELECT bID FROM btAddNews ORDER BY sdt DESC");
         while ($row = $g->FetchRow()){
 
            $bID = $row['bID'];
      //for each block, grab it's collection ID and its version ID from the CollectionVersion table      
            $bcv = $db->query("SELECT cID, cvID FROM CollectionVersionBlocks  WHERE bID = '$bID'");
               while ($row = $bcv->FetchRow()){
                  $cbcID = $row['cID'];
                  $cbaID = $row['cvID'];
               }
      //now for each block, check it's collection version ID against the highest collection version for the collection in resides in         
            $bcvID = $db->query("SELECT cvID, MAX(cvID)  FROM CollectionVersionBlocks  WHERE cID = '$cbcID' GROUP BY cvID");
               while ($row = $bcvID->FetchRow()){
               $cbmID = $row['MAX(cvID)'];
               }
 
 
            if($cbaID<$cbmID){
      //if the collection version it resides in is not the latest, then do nothing         
            }else{
 
      //if the collection version is the lates, add it to the list   
         if ($ctID == 'All Categories'){
         $r = $db->Execute("SELECT * FROM btAddNews WHERE bID = '$bID' AND sdt<=CURDATE() AND (edt IS NULL OR edt>=CURDATE())");
         }else{
         $r = $db->Execute("SELECT * FROM btAddNews WHERE bID = '$bID' AND ctID='$ctID' AND sdt<=CURDATE() AND (edt IS NULL OR edt>=CURDATE())   ");
         }
          $row=$r->FetchRow();
 
               $feed = '<item>';
               $feed .= '<title>'.$row['title'].'</title>';
               $feed .= '<link>'.$site.View::url(getBlockPath($cParentID)).'index.php?cID='.$row['cParentID'].'</link>';
               $feed .= '<description>'.htmlspecialchars(strip_tags($row['content'])).'</description>';
               $feed .='</item>';
               echo str_replace($strip,$rplace,$feed);
            }
         }
      }
 
      header('Content-type: text/xml');
 
?>
      <rss version="2.0">
        <channel>      
<?php     
         $batch = rssInfo($_GET['bID'], $site,  $_GET['ctID']);
         $batch .= getFeed($_GET['ctID'], $site);
         echo $batch;
?>
            </channel>
      </rss>