rss = fetch_rss($url); // Read in our sample feed file //$data = @implode("",@file($url)); // Tell feedParser to parse the data $info = $this->rss->items; if(isset($info)) { $this->rss_object = $info; }else { return false; } if(isset($this->rss)) { $this->rss_title = $this->rss->channel["title"]; $this->rss_link = $this->rss->channel["link"]; $this->rss_object = $info; return true; }else { return false; } } /** Function to get the List of Rss feeds * This Function accepts no arguments and returns the listview contents on Sucess * returns "Sorry: It's not possible to reach RSS URL" if fails */ function getListViewRSSHtml() { global $default_charset; if(isset($this->rss_object)) { $i = 0; foreach($this->rss_object as $key=>$item) { $stringConvert = function_exists(iconv) ? @iconv("UTF-8",$default_charset,$item[title]) : $item[title]; $rss_title= ltrim(rtrim($stringConvert)); $i = $i + 1; $shtml .= "".$rss_title."".$this->rss_title.""; if($i == 10) { return $shtml; } } return $shtml; }else { $shtml = "".$mod_strings['LBL_REGRET_MSG'].""; } } /** Function to get the List of Rss feeds in the Customized Home page * This Function accepts maximum entries as arguments and returns the listview contents on Success * returns "Sorry: It's not possible to reach RSS URL" if fails */ function getListViewHomeRSSHtml($maxentries) { $return_value=Array(); $return_more=Array(); if(isset($this->rss_object)) { $y = 0; foreach($this->rss_object as $key=>$item) { $title =$item[title]; $link = $item[link]; if($y == $maxentries) { $return_more=Array("Details"=>$return_value,"More"=>$this->rss_link); return $return_more; } $y = $y + 1; $return_value[]=Array($title,$link); } $return_more=Array("Details"=>$return_value,"More"=>$this->rss_link); return $return_more; }else { return $return_more; } } /** Function to save the Rss Feeds * This Function accepts the RssURl,Starred Status as arguments and * returns true on sucess * returns false if fails */ function saveRSSUrl($url,$makestarred=0) { global $adb; if ($url != "") { $rsstitle = $this->rss_title; if($rsstitle == "") { $rsstitle = $url; } $genRssId = $adb->getUniqueID("vtiger_rss"); $sSQL = "insert into vtiger_rss (RSSID,RSSURL,RSSTITLE,RSSTYPE,STARRED) values (?,?,?,?,?)"; $sparams = array($genRssId, $url, $rsstitle, 0, $makestarred); $result = $adb->pquery($sSQL, $sparams); if($result) { return $genRssId; }else { return false; } } } function getCRMRssFeeds() { global $adb; global $image_path,$theme; $sSQL = "select * from vtiger_rss where rsstype=1"; $result = $adb->pquery($sSQL, array()); while($allrssrow = $adb->fetch_array($result)) { $shtml .= ""; if($allrssrow["starred"] == 1) { $shtml .= " "; }else { $shtml .= " "; } $shtml .= "".$allrssrow[rsstitle].""; $shtml .= " "; } return $shtml; } function getAllRssFeeds() { global $adb; global $image_path; $sSQL = "select * from vtiger_rss where rsstype <> 1"; $result = $adb->pquery($sSQL, array()); while($allrssrow = $adb->fetch_array($result)) { $shtml .= ""; if($allrssrow["starred"] == 1) { $shtml .= " "; }else { $shtml .= " "; } $shtml .= "".$allrssrow[rsstitle]." "; $shtml .= ""; } return $shtml; } /** Function to get the rssurl for the given id * This Function accepts the rssid as argument and returns the rssurl for that id */ function getRssUrlfromId($rssid) { global $adb; if($rssid != "") { $sSQL = "select * from vtiger_rss where rssid=?"; $result = $adb->pquery($sSQL, array($rssid)); $rssrow = $adb->fetch_array($result); if(count($rssrow) > 0) { $rssurl = $rssrow[rssurl]; } } return $rssurl; } function getRSSHeadings($rssid) { global $image_path; global $adb; if($rssid != "") { $sSQL = "select * from vtiger_rss where rssid=?"; $result = $adb->pquery($sSQL, array($rssid)); $rssrow = $adb->fetch_array($result); if(count($rssrow) > 0) { $shtml = "
"; if($rssrow[starred] == 1) { $shtml .= ""; }else { $shtml .= ""; } $shtml .= "rss_object[link]."\"> ".$rssrow[rsstitle]."
"; } } return $shtml; } /** Function to get the StarredRSSFeeds lists * This Function accepts no argument and returns the rss feeds of * the starred Feeds as HTML strings */ function getTopStarredRSSFeeds() { global $adb; global $image_path; $sSQL = "select * from vtiger_rss where starred=1"; $result = $adb->pquery($sSQL, array()); $shtml .= "Add New Rss"; while($allrssrow = $adb->fetch_array($result)) { $shtml .= ""; $shtml .= " ".substr($allrssrow['rsstitle'],0,10)."..."; } return $shtml; } /** Function to get the rssfeed lists for the starred Rss feeds * This Function accepts no argument and returns the rss feeds of * the starred Feeds as HTML strings */ function getStarredRssHTML() { global $adb; global $image_path,$mod_strings; $sSQL = "select * from vtiger_rss where starred=1"; $result = $adb->pquery($sSQL, array()); while($allrssrow = $adb->fetch_array($result)) { if($this->setRSSUrl($allrssrow["rssurl"])) { $rss_html = $this->getListViewRSSHtml(); } $shtml .= $rss_html; if(isset($this->rss_object)) { if(count($this->rss_object) > 10) { $shtml .= " rss_link\">".$mod_strings['LBL_MORE']." "; } } $sreturnhtml[] = $shtml; $shtml = ""; } $recordcount = round((count($sreturnhtml))/2); $j = $recordcount; for($i=0;$i<$recordcount;$i++) { $starredhtml .= $sreturnhtml[$i].$sreturnhtml[$j]; $j = $j + 1; } $starredhtml = "".$starredhtml."
".$mod_strings['LBL_SUBJECT']." ".$mod_strings['LBL_SENDER']."
"; return $starredhtml; } /** Function to get the rssfeed lists for the given rssid * This Function accepts the rssid as argument and returns the rss feeds as HTML strings */ function getSelectedRssHTML($rssid) { global $adb; global $image_path, $mod_strings; $sSQL = "select * from vtiger_rss where rssid=?"; $result = $adb->pquery($sSQL, array($rssid)); while($allrssrow = $adb->fetch_array($result)) { if($this->setRSSUrl($allrssrow["rssurl"])) { $rss_html = $this->getListViewRSSHtml(); } $shtml .= $rss_html; if(isset($this->rss_object)) { if(count($this->rss_object) > 10) { $shtml .= " rss_link\">".$mod_strings['LBL_MORE']." "; } } $sreturnhtml[] = $shtml; $shtml = ""; } $recordcount = round((count($sreturnhtml))/2); $j = $recordcount; for($i=0;$i<$recordcount;$i++) { $starredhtml .= $sreturnhtml[$i].$sreturnhtml[$j]; $j = $j + 1; } $starredhtml = "".$starredhtml."
".$mod_strings['LBL_SUBJECT']." ".$mod_strings['LBL_SENDER']."
"; return $starredhtml; } /** Function to get the Rss Feeds by Category * This Function accepts the RssCategory as argument * and returns the html string for the Rss feeds lists */ function getRSSCategoryHTML() { global $adb; global $image_path; $shtml .= " ".$this->getRssFeedsbyCategory()."
"; return $shtml; } /** Function to get the Rss Feeds for the Given Category * This Function accepts the RssCategory as argument * and returns the html string for the Rss feeds lists */ function getRssFeedsbyCategory() { global $adb; global $image_path,$theme; $sSQL = "select * from vtiger_rss"; $result = $adb->pquery($sSQL, array()); while($allrssrow = $adb->fetch_array($result)) { $shtml .= ""; $shtml .= ""; if($allrssrow["starred"] == 1) { $shtml .= ""; }else { $shtml .= ""; } $shtml .= ""; $shtml .= "".$allrssrow[rsstitle]." "; $shtml .= ""; } return $shtml; } // Function to delete an entity with given Id function trash($module, $id) { global $log, $adb; $del_query = 'DELETE FROM vtiger_rss WHERE rssid=?'; $adb->pquery($del_query, array($id)); } } /** Function to get the rsstitle for the given rssid * This Function accepts the rssid as an optional argument and returns the title * if no id is passed it will return the tittle of the starred rss */ function gerRssTitle($id='') { global $adb; if($id == '') { $query = 'select * from vtiger_rss where starred=1'; $params = array(); } else { $query = 'select * from vtiger_rss where rssid =?'; $params = array($id); } $result = $adb->pquery($query, $params); $title = $adb->query_result($result,0,'rsstitle'); return $title; } ?>