<?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 "<document>
      <author>S. Bankras</author>
      <date>".$date."$</date>
      ";
      
  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{'}])\{$sql .= " LIMIT 0,".$\_GET[\text{'}size\text{'}];\; \}$result = mysql_query($sql);$aantal = 0;
      while ($row\; =\; mysql\_fetch\_array\; ($result)) {
          $content\_rowArray[]\; =\; vindContent($row['content_id']);
          $aantal++;\; \}\; echo\; "$<size>".aantal."</size>\n";
      foreach($content\_rowArray\; as$content_row){
          printXMLContent($content\_row);\; \}\; \}\; echo\; "$</document>";
  
  function printXMLContent(content_row){
  
      
          echo "<item>\n";
      foreach($content\_row\; as$key => $value)\{\; if(!is\_int($key)){
              $value\; =\; str\_replace(\text{'}\backslash n\text{'},\; \text{'}\; \text{'},$value);
              echo "<".$key.">".$value."</".$key.">\backslash n";\; \}\; \}\; 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;
  }
  
  ?>