<?PHP
  error_reporting(E_ALL);
  
  //include('extern/class.rss20.php');
  
  class Rss {
  
          var $core;$//var Rss20;
          
          function Rss (&$core)\; \{$this->core = &$core;$//this->Rss20 = new rss20();
          }
          
          function getFeeds () {
          
                  $arrFeeds\; =\; array();$sql = "SELECT *
                                  FROM rss_feeds";
                  $rssQueryResults\; =$this->core->Db->getQueryResults($sql);\; for\; ($i = 0 ; rssQueryResults) ; $i++)\; \{$arrFeeds[] = array("id"                => $rssQueryResults[$i]['id'],
                                                                  "title"                => $rssQueryResults[$i]['title'],
                                                                  "url"                => $rssQueryResults[$i]['url'] );                        
                          
                  }
                  
                  //$arrFeeds[]\; =\; array("id"\; =>\; 1\; ,\; "title"\; =>\; \text{'}Test\text{'}\; ,\; "url"\; =>\; \text{'}news.nationalgeographic.com/rss/global\_warming.rss\text{'});$
                  
                  return arrFeeds;        
          }
          
          function getFeedList () {
                  
                  $arrFeeds\; =$this->getFeeds();
  
                  $selected\; =\; \text{'}\text{'};$list = '';
                  
                  $list\; .=\; \text{'}$<option value="">Select feed</option>';
                  
                  foreach (arrFeeds as $feed)\; \{$list .= '<option value="index.php?FeedId='.$feed[\text{'}id\text{'}].\text{'}">\text{'}.$feed['name'].'</option>';
                  }        
                  return $list;\; \}\; function\; ajaxGetFeedItem\; ()\; \{$contentId = $\_GET[\text{'}ContentId\text{'}];$sql = "SELECT content_title, content_binary
                                  FROM content
                                  WHERE content_id = ".$contentId."\; ";$contentQueryResult = $this->core->Db->getQueryResult($sql);
                                  
                  echo $contentQueryResult[\text{'}content\_title\text{'}].\text{'}$%^'.$contentQueryResult[\text{'}content\_binary\text{'}].\text{'}$%^'.$contentId.\text{'}!@\#\text{'};\; \}\; function\; getFeedItems\; ()\; \{$arrFeedItems = array();
                  
                  $sql\; =\; "SELECT\; content\_id\; FROM\; content\_type\_article\; WHERE\; rss\_article\; =\; 1\; ORDER\; BY\; content\_type\_article\_id\; desc\; LIMIT\; 10";$articleQueryResults = $this->core->Db->getQueryResults($sql);
                  
                  for ($i\; =\; 0\; ;$i < count($articleQueryResults)\; ;$i++) {
                          $sql\; =\; "SELECT\; content\_title\; FROM\; content\; WHERE\; content\_id\; =\; ".$articleQueryResults[$i][\text{'}content\_id\text{'}]."\; ";$contentQueryResult = $this->core->Db->getQueryResult($sql);
                          
                          $arrFeedItems[]\; =\; array("content\_id"\; =>$articleQueryResults[$i][\text{'}content\_id\text{'}],\; "title"\; =>$this->core->Common->cutText($contentQueryResult[\text{'}content\_title\text{'}],\; 55)\; );\; \}\; return$arrFeedItems;        
          }
          
          function putRssInDb () {
                  
                  $arrFeeds\; =$this->getFeeds();
                  $arrFeedItems\; =\; array();$numberFeedItemsAdded = 0;
                  $numberFeedItemsAlreadyInDb\; =\; 0;\; for\; ($i = 0 ; arrFeeds) ; $i++)\; \{$this->Rss20 = new rss20();
                          $this->Rss20->newfile($arrFeeds[$i][\text{'}url\text{'}]);$// lees een externe feed (zonder caching)
                          this->Rss20->parse(); // parse de XML-file
                          $items\; =$this->Rss20->get_items(0);
                          
                          foreach ($items\; as$item) {
                                  $arrFeedItems[]\; =$this->getModifiedRssFeed($arrFeeds[$i]['url'], $arrFeeds[$i]['title'], $item);\; \}\; shuffle($arrFeedItems);
                          $this->Rss20->free\_parser();\; unset($items);
                          
                  }
                  
                  for ($i\; =\; 0\; ;$i < count($arrFeedItems)\; ;$i++) {
                  
                          $sql\; =\; "SELECT\; *\; FROM\; content\; WHERE\; content\_sourceurl\; =\; \text{'}".$arrFeedItems[$i][\text{'}link\text{'}]."\text{'}\; ";\; if\; ($this->core->Db->getQueryNumRows($sql)\; ==\; 1)\; \{$numberFeedItemsAlreadyInDb++;
                                  continue;
                          }
                          
                          $sql\; =\; "INSERT\; INTO\; content\; (content\_title\; ,\; content\_source\_name\; ,\; content\_date\; ,\; content\_date\_added\; ,\; content\_binary\; ,\; content\_state\; ,\; content\_type\; ,\; content\_sourceurl)\; VALUES\; (\text{'}".addslashes($arrFeedItems[$i][\text{'}title\text{'}])."\text{'}\; ,\; \text{'}".$arrFeedItems[$i][\text{'}sourcename\text{'}]."\text{'}\; ,\; \text{'}".$arrFeedItems[$i][\text{'}pub\_date\text{'}]."\text{'}\; ,\; NOW()\; ,\; \text{'}".addslashes($arrFeedItems[$i][\text{'}description\text{'}])."\text{'}\; ,\; \text{'}".$arrFeedItems[$i][\text{'}content\_state\text{'}]."\text{'}\; ,\; \text{'}article\text{'}\; ,\; \text{'}".$arrFeedItems[$i][\text{'}link\text{'}]."\text{'})";$this->core->Db->doQuery($sql);$contentId = $this->core->Db->getLastInsertedId();$sql = "INSERT INTO content_type_article (content_id , rss_article)
                                          VALUES (".$contentId."\; ,\; 1)";$this->core->Db->doQuery($sql);$sql = "INSERT INTO content_matrix (content_id , health , politics , wildlife , energy , business , climate , pollution , technology , lifestyle , environment , region)
                                          VALUES (".$contentId."\; ,\; ".$arrFeedItems[$i][\text{'}arr\_content\_matrix\text{'}][\text{'}health\text{'}]."\; ,\; ".$arrFeedItems[$i][\text{'}arr\_content\_matrix\text{'}][\text{'}politics\text{'}]."\; ,\; ".$arrFeedItems[$i][\text{'}arr\_content\_matrix\text{'}][\text{'}wildlife\text{'}]."\; ,\; ".$arrFeedItems[$i][\text{'}arr\_content\_matrix\text{'}][\text{'}energy\text{'}]."\; ,\; ".$arrFeedItems[$i][\text{'}arr\_content\_matrix\text{'}][\text{'}business\text{'}]."\; ,\; ".$arrFeedItems[$i][\text{'}arr\_content\_matrix\text{'}][\text{'}climate\text{'}]."\; ,\; ".$arrFeedItems[$i][\text{'}arr\_content\_matrix\text{'}][\text{'}pollution\text{'}]."\; ,\; ".$arrFeedItems[$i][\text{'}arr\_content\_matrix\text{'}][\text{'}technology\text{'}]."\; ,\; ".$arrFeedItems[$i][\text{'}arr\_content\_matrix\text{'}][\text{'}lifestyle\text{'}]."\; ,\; ".$arrFeedItems[$i][\text{'}arr\_content\_matrix\text{'}][\text{'}environment\text{'}]."\; ,\; \text{'}".$arrFeedItems[$i][\text{'}region\text{'}]."\text{'}\; )";$this->core->Db->doQuery($sql);$numberFeedItemsAdded++;                        
                          
                  }
                  
                  echo 'Number feed items added: '.$numberFeedItemsAdded;\; echo\; \text{'}$<br>Number feed items already in db: '.numberFeedItemsAlreadyInDb;
                  
          }
          
          function getModifiedRssFeed ($feedUrl,$feedTitle, $item)\; \{$result = array();
                  
                  $result[\text{'}sourcename\text{'}]\; =$feedTitle.'(feed)';
                  
                  switch ($feedUrl)\; \{\; case\; \text{'}www.climateark.org/rss/climate.xml\text{'}:$result['title'] = $item[\text{'}title\text{'}];$result['description'] = trim(strip_tags($item[\text{'}description\text{'}]));$result['link'] = $item[\text{'}link\text{'}];$result['author'] = $item[\text{'}author\text{'}];$result['pub_date'] = $item[\text{'}pubDate\text{'}];$arrContentMatrix = $this->getContentMatrix($item['title'].$item[\text{'}description\text{'}]);$result['arr_content_matrix'] = $arrContentMatrix[\text{'}arr\_content\_matrix\text{'}];$result['content_state'] = $arrContentMatrix[\text{'}content\_state\text{'}];\; preg\_match("/.*\backslash |(.*)\backslash |(.*)/",$item['category'], $matches);$result['region'] = $matches[1].\text{'}\; -\; \text{'}.$matches[2];
                                  
                                  break;
                          case 'www.globalwarming.org/news/all/feed':
                                  $result[\text{'}title\text{'}]\; =$item['title'];
                                  $result[\text{'}link\text{'}]\; =$item['link'];
                                  $result[\text{'}description\text{'}]\; =\; trim(strip\_tags($item['description']));
                                  $result[\text{'}author\text{'}]\; =\; \text{'}\text{'};$result['region'] = ''; // wordt niet gegeven
                                  $result[\text{'}pub\_date\text{'}]\; =$item['pubDate'];
                                  
                                  $arrContentMatrix\; =$this->getContentMatrix($item[\text{'}title\text{'}].$item['description']);
                                  $result[\text{'}arr\_content\_matrix\text{'}]\; =$arrContentMatrix['arr_content_matrix'];
                                  $result[\text{'}content\_state\text{'}]\; =$arrContentMatrix['content_state'];                
                                                  
                                  break;
                          case 'newsrss.bbc.co.uk/rss/newsonline_world_edition/science/nature/rss.xml':
                                  $result[\text{'}title\text{'}]\; =$item['title'];
                                  $result[\text{'}description\text{'}]\; =\; trim(strip\_tags($item['description']));
                                  $result[\text{'}link\text{'}]\; =$item['link'];
                                  $result[\text{'}author\text{'}]\; =\; \text{'}\text{'};$result['region'] = '';        
                                  $result[\text{'}pub\_date\text{'}]\; =$item['pubDate'];
                                  
                                  $arrContentMatrix\; =$this->getContentMatrix($item[\text{'}title\text{'}].$item['description']);
                                  $result[\text{'}arr\_content\_matrix\text{'}]\; =$arrContentMatrix['arr_content_matrix'];
                                  $result[\text{'}content\_state\text{'}]\; =$arrContentMatrix['content_state'];        
                                  
                                  break;
                          case 'dsc.discovery.com/news/subjects/earth/xml/top-stories.xml':
                                  $result[\text{'}title\text{'}]\; =$item['title'];
                                  $result[\text{'}link\text{'}]\; =$item['link'];
                                  $result[\text{'}description\text{'}]\; =\; trim(strip\_tags($item['description']));
                                  $result[\text{'}author\text{'}]\; =\; \text{'}\text{'};$result['region'] = '';
                                  $result[\text{'}pub\_date\text{'}]\; =$item['pubDate'];
                                  
                                  $arrContentMatrix\; =$this->getContentMatrix($item[\text{'}title\text{'}].$item['description']);
                                  $result[\text{'}arr\_content\_matrix\text{'}]\; =$arrContentMatrix['arr_content_matrix'];
                                  $result[\text{'}content\_state\text{'}]\; =$arrContentMatrix['content_state'];        
                                          
                                  break;
                          case 'news.nationalgeographic.com/rss/global_warming.rss':
                                  $result[\text{'}title\text{'}]\; =$item['title'];
                                  $result[\text{'}link\text{'}]\; =$item['link'];
                                  $result[\text{'}description\text{'}]\; =\; trim(strip\_tags($item['description']));
                                  $result[\text{'}author\text{'}]\; =\; \text{'}\text{'};$result['region'] = '';        
                                  $result[\text{'}pub\_date\text{'}]\; =$item['pubDate'];
                                  
                                  $arrContentMatrix\; =$this->getContentMatrix($item[\text{'}title\text{'}].$item['description']);
                                  $result[\text{'}arr\_content\_matrix\text{'}]\; =$arrContentMatrix['arr_content_matrix'];
                                  $result[\text{'}content\_state\text{'}]\; =$arrContentMatrix['content_state'];
                                          
                                  break;                
                          default:
                                  // wanneer de rss feed hier nog niet is opgenomen
                                  $result[\text{'}title\text{'}]\; =$item['title'];
                                  $result[\text{'}link\text{'}]\; =$item['link'];
                                  $result[\text{'}description\text{'}]\; =\; trim(strip\_tags($item['description']));
                                  $result[\text{'}author\text{'}]\; =\; \text{'}\text{'};$result['region'] = '';        
                                  $result[\text{'}pub\_date\text{'}]\; =$item['pubDate'];
                                  
                                  $arrContentMatrix\; =$this->getContentMatrix($item[\text{'}title\text{'}].$item['description']);
                                  $result[\text{'}arr\_content\_matrix\text{'}]\; =$arrContentMatrix['arr_content_matrix'];
                                  $result[\text{'}content\_state\text{'}]\; =$arrContentMatrix['content_state'];
                                                                  
                  }
                  
                  return $result;\; \}\; function\; getContentMatrix\; ($contentString) {
                  
                  $arrContentMatrix\; =\; array();$contentState = 3;
                  
                  $arrContentMatrix[\text{'}health\text{'}]\; =\; 0;$arrContentMatrix['politics'] = 0;
                  $arrContentMatrix[\text{'}wildlife\text{'}]\; =\; 0;$arrContentMatrix['energy'] = 0;
                  $arrContentMatrix[\text{'}business\text{'}]\; =\; 0;$arrContentMatrix['climate'] = 0;
                  $arrContentMatrix[\text{'}pollution\text{'}]\; =\; 0;$arrContentMatrix['technology'] = 0;
                  $arrContentMatrix[\text{'}lifestyle\text{'}]\; =\; 0;$arrContentMatrix['environment'] = 0;
                  
                  // De title en descripstion van de feed item kunnen woorden bevatten waaruit de cotegorie afgeleid kan worden
                  $healthRegex\; =\; "/health/";$politicsRegex = "/political|politics/";
                  $wildlifeRegex\; =\; "/wildlife|animals|animal|beer/";$energyRegex = "/energy|solarpower|greenenergy|green\senergy/";
                  $businessRegex\; =\; "/business|money|dollar/";$climateRegex = "/climate|weather/";
                  $pollutionRegex\; =\; "/pollution|waste/";$technologyRegex = "/technology|technological/";
                  $lifestyleRegex\; =\; "/lifestyle/";$environmentRegex = "/environment/";
                  
                  if (preg_match($politicsRegex,$contentString)) {
                          $arrContentMatrix[\text{'}health\text{'}]\; =\; 1;$contentState = 1;
                  }
  
                  if (preg_match($healthRegex,$contentString)) {
                          $arrContentMatrix[\text{'}politics\text{'}]\; =\; 1;$contentState = 1;
                  }
                  
                  if (preg_match($wildlifeRegex,$contentString)) {
                          $arrContentMatrix[\text{'}wildlife\text{'}]\; =\; 1;$contentState = 1;
                  }
                  
                  if (preg_match($energyRegex,$contentString)) {
                          $arrContentMatrix[\text{'}energy\text{'}]\; =\; 1;$contentState = 1;
                  }
                  
                  if (preg_match($businessRegex,$contentString)) {
                          $arrContentMatrix[\text{'}business\text{'}]\; =\; 1;$contentState = 1;
                  }
          
                  if (preg_match($climateRegex,$contentString)) {
                          $arrContentMatrix[\text{'}climate\text{'}]\; =\; 1;$contentState = 1;
                  }
                  
                  if (preg_match($pollutionRegex,$contentString)) {
                          $arrContentMatrix[\text{'}pollution\text{'}]\; =\; 1;$contentState = 1;
                  }
                  
                  if (preg_match($technologyRegex,$contentString)) {
                          $arrContentMatrix[\text{'}technology\text{'}]\; =\; 1;$contentState = 1;
                  }
                  
                  if (preg_match($lifestyleRegex,$contentString)) {
                          $arrContentMatrix[\text{'}lifestyle\text{'}]\; =\; 1;$contentState = 1;
                  }
                  
                  if (preg_match($environmentRegex,$contentString)) {
                          $arrContentMatrix[\text{'}environment\text{'}]\; =\; 1;$contentState = 1;
                  }
                  
                  $result[\text{'}arr\_content\_matrix\text{'}]\; =$arrContentMatrix;
                  $result[\text{'}content\_state\text{'}]\; =$contentState;
                  
                  return $result;\; \}\; \}\; ?>$