<?xml version="1.0"?>
  <?php
  
   header ("content-type: text/xml");
  
  mysql_connect("tornado","mwg400","48458749") or die ("Kan niet connecten.");
  $tabellen\; =\; mysql\_list\_tables(\; "mwg400-dbs");\; mysql\_select\_db("mwg400-dbs")\; or\; die\; ("Verdorie,\; kan\; de\; database\; niet\; openen");$now = mktime();
      $date\; =\; date("d-m-Y,\; H:i:s",$now);
   echo "
  <rss version='2.0'>
  
  <channel>
  <description/>
  <link>www.few.vu.nl/~ystaal/mmc/getrss.php</link>
  <title>MMC RSS Feed [".ucwords($\_GET[\text{'}category\text{'}])."]$</title>
      ";
      
  if(_GET['content_id']){
      $content\_row\; =\; vindContent($_GET['content_id']);
      printXMLContent($content\_row);\; \}\; if($_GET['category']){ 
  
      $sql\; =\; "SELECT\; content\_id\; FROM\; content\_matrix\; WHERE\; ".$_GET['category']." = 1 ORDER BY content_id DESC";
      if($\_GET[\text{'}size\text{'}])\{$size = $\_GET[\text{'}size\text{'}];\; \}\; else\; \{$size = 100;
      }
      $result\; =\; mysql\_query($sql);
      $aantal\; =\; 0;\; while\; ($row = mysql_fetch_array ($result))\; \{\; echo\; "\backslash nGEVONDEN\; ID:\; ".$row['content_id'];
          if(size){
              $content\_rowArray[]\; =\; vindContent($row['content_id']);
              $aantal++;\; \}\; \}$// echo "<size>".aantal."</size>\n";
      for($i\; =\; 0;$i < $aantal;$i++){
          printXMLContent($content\_rowArray[$i]);
      }        
  }
  
          echo "</channel>
  </rss>";
  
  function printXMLContent($content\_row)\{\; echo\; "$<item>\n";
     echo "
     <title>".content_row['content_title']."</title>
  <link>www.few.vu.nl/~ystaal/mmc/getmooicontent.php?content_id=".$content_row['content_id']."</link>
  <description>".$content\_row[\text{'}content\_binary\text{'}]."$</description>
     ";
      
          echo "</item>\n";
  }
  
  function vindContent(content_id){
      $now\; =\; mktime();$date = date("d-m-Y, H:i:s",$now);$result = mysql_query("SELECT * FROM content WHERE content_id = ".$content\_id);$content_row = mysql_fetch_array ($result);$categoryString = $categoryArray\; =\; null;$result2 = mysql_query("SELECT * FROM content_matrix WHERE content_id = ".$content\_id);\; while\; ($row2 = mysql_fetch_array ($result2))\; \{\; foreach($row2 as $key\; =>$value){
                  if(key) && ($key\; !=\; \text{'}content\_id\text{'}))\{$categoryArray[] = $key;\; \}\; \}\; \}$keywordString = $keywordArray\; =\; null;$result2 = mysql_query("SELECT keyword_id FROM content_keywords WHERE content_id = ".$content\_id);\; while\; ($row2 = mysql_fetch_array ($result2))\; \{$result3 = mysql_query("SELECT keyword_name FROM keywords WHERE keyword_id = ".$row2[\text{'}keyword\_id\text{'}]);\; while\; ($row3 = mysql_fetch_array ($result3))\; \{$keywordArray[] = $row3[\text{'}keyword\_name\text{'}];\; \}\; \}$content_row['content_binary']   = strip($content\_row[\text{'}content\_binary\text{'}]);$content_row['derived_keywordstring'] = implode(", ", $keywordArray);$content_row['derived_categorystring'] = implode(", ", $categoryArray);\; return$content_row;
  }
  /*
  else {
  
      
      Tellertje en loop om de tabellen te tonen.
      
      echo "<fieldset><legend><b>List of all tables in the database</b></legend>";
      $i=0;\; while\; ($i < mysql_num_rows($tabellen))\{$t_name[$i]\; =\; mysql\_tablename\; ($tabellen, $i);\; echo\; "$<a target='goalWin' href='getdb.php?table=".t_name[$i].\; "\text{'}>".$t_name[$i]."$</a><br />\n";
          i++;
      }   
      echo "</fieldset>";
      mysql_free_result ($result);\; \}\; if(!$_GET['table']){
  ?>
  <hr />
  Created for MMC2007
  <div>
    <img
          src="http://www.w3.org/Icons/valid-xhtml10"
          alt="Valid XHTML 1.0 Transitional" height="31" width="88" /></a>
          </div>
  </body>
  </html>
  <?php 
  } 
  */
  
  function strip($text)\{$text = str_replace("&ndash;", "&#45;",$text);$text = str_replace("&acirc;", "NULL",$text);$text = str_replace("&Acirc;", "NULL",$text);\; return$text;
  }
  
  ?>