<?PHP

  error_reporting(E_ALL);

  

  class Content {

  

          var core) {

                  core;

          }

          

          

          function setTopItems () {

                                  

                  if (isset($\_GET[\text{'}TopItemsNumber\text{'}]))\; \{$topItemNumber = $\_GET[\text{'}TopItemsNumber\text{'}];\; \}\; else\; \{$topItemNumber = 1;

                  }                        

                  

                  if (topItemNumber > 5 || empty($topItemNumber))\; \{$topItemNumber = 1;

                  }

                  

                  $topItemNumber--;$// -1 omdat limit bij 0 begint.

                  

                  sql = "SELECT content_id

                                  FROM user_content_rating

                                  WHERE content_id IN (        SELECT content_id

                                                                                  FROM content

                                                                                  WHERE content_type = 'video')

                                  ORDER BY user_content_rating_qualityvalue DESC

                                  LIMIT ".$topItemNumber.",1";\; if\; ($this->core->Db->getQueryNumRows($sql)\; ==\; 0)\; \{$// Er staat niets in de tabel , duhhhhhh , nu een random content_id

                          sql = "SELECT content_id

                                          FROM content

                                          WHERE content_type = 'video'

                                          ORDER BY rand()

                                          LIMIT 1";

                          $queryResult\; =$this->core->Db->getQueryResult($sql);$contentId = $queryResult[\text{'}content\_id\text{'}];\; \}\; else\; \{$queryResult = $this->core->Db->getQueryResult($sql);

                          $contentId\; =$queryResult['content_id'];

                  }

                  

                  $sql\; =\; "SELECT\; *\; FROM\; content\; WHERE\; content\_id\; =\; ".$contentId." ";

                  $queryResult\; =$this->core->Db->getQueryResult($sql);$/* Oud toen het nog over alle type content ging

                  // Wat voor plaatje moet er komen?

                  switch (queryResult['content_type']) {

                          case 'audio':

                                  $firstWord\; =\; \text{'}AUDIO\text{'};$imageUrl = '<img src="img/audio.jpg" width="475" height="150" />';

                                  break;

                          case 'video':

                                  $firstWord\; =\; \text{'}VIDEO\text{'};$imageUrl = '<img src="img/video.jpg" width="475" height="150" />';

                                  break;

                          case 'picture':

                                  $firstWord\; =\; \text{'}PICTURE\text{'};$imageUrl = '<img src="img/picture.jpg" width="475" height="150" />';

                                  break;

                          case 'article':

                                  $firstWord\; =\; \text{'}ARTICLE\text{'};$imageUrl = '<img src="img/article.jpg" width="475" height="150" />';

                                  break;

                          default:

                                  $imageUrl\; =\; \text{'}$<img src="img/article.jpg" width="475" height="150" />';

                                  firstWord = 'FOUT';

                  }

                  

                  $text\; =$firstWord.' - '.$this->core->Common->cutText($queryResult['content_binary'], 280);

  		*/

                  

                  if ($queryResult[\text{'}content\_source\_name\text{'}]\; ==\; \text{'}Youtube\text{'})\; \{$videoCode = $queryResult[\text{'}content\_binary\text{'}];\; \}\; else\; \{$videoCode = '        <OBJECT id="mediaPlayer" width="400" height="300" 

                                                        classid="CLSID:22d6f312-b0f6-11d0-94ab-0080c74c7e95" 

                                                        codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701"

                                                        standby="Loading Microsoft Windows Media Player components..." type="application/x-oleobject">

                                                        <param name="fileName" value="http://www.few.vu.nl/~casus07/cms/'.$queryResult[\text{'}content\_binary\text{'}].\text{'}">$<param name="animationatStart" value="true">

                                                        <param name="transparentatStart" value="true">

                                                        <param name="autoStart" value="true">

                                                        <param name="showControls" value="true">

                                                        <param name="loop" value="true">

                                                        <EMBED type="application/x-mplayer2"

                                                                  pluginspage="http://microsoft.com/windows/mediaplayer/en/download/"

                                                                  id="mediaPlayer" name="mediaPlayer" displaysize="4" autosize="-1" 

                                                                  bgcolor="darkblue" showcontrols="true" showtracker="-1" 

                                                                  showdisplay="0" showstatusbar="-1" videoborder3d="-1" width="400" height="300"

                                                                  src="http://www.few.vu.nl/~casus07/cms/'.queryResult['content_binary'].'" autostart="true" designtimesp="5311" loop="true">

                                                          </EMBED>

                                                          </OBJECT>';

                  }                

                  

                  queryResult['content_id'];

                  

                  $this->core->PageComm->setPageCommVar(\text{'}top\_items\_text\text{'},$queryResult['content_description']);

                  $this->core->PageComm->setPageCommVar(\text{'}top\_items\_video\_code\text{'},$videoCode);

                  $this->core->PageComm->setPageCommVar(\text{'}top\_items\_link\text{'},$link);

                  

          }

          

          function getLatestPictures () {

                  

                  $result\; =\; array();$sql = "SELECT content_id

                                  FROM content_type_picture

                                  ORDER BY content_type_picture_id DESC

                                  LIMIT 5";

                                  // Eventueel: WHERE rss_article = 0 om de rss feeds eruit te halen

                  $articleQueryResults\; =$this->core->Db->getQueryResults($sql);\; for\; ($i = 0 ; articleQueryResults) ; $i++)\; \{$sql = "SELECT *

                                          FROM content

                                          WHERE content_id = ".$articleQueryResults[$i]['content_id']." ";

                          $contentQueryResult\; =$this->core->Db->getQueryResult($sql);$result[] = array(        "title"                        => $contentQueryResult[\text{'}content\_title\text{'}],\; "content\_id"\; =>$articleQueryResults[$i][\text{'}content\_id\text{'}]\; ,\; "image\_url"\; =>\; \text{'}www.few.vu.nl/~casus07/cms/\text{'}.\$contentQueryResult[\text{'}content\_binary\text{'}]\; );\; \}\; return$result;

                  

                  

          }

          

          function getLatestArticles () {

                  

                  

                  $result\; =\; array();$sql = "SELECT content_id

                                  FROM content_type_article

                                  ORDER BY content_type_article_id DESC

                                  LIMIT 5";

                                  // Eventueel: WHERE rss_article = 0 om de rss feeds eruit te halen

                  $articleQueryResults\; =$this->core->Db->getQueryResults($sql);\; for\; ($i = 0 ; articleQueryResults) ; $i++)\; \{$sql = "SELECT *

                                          FROM content

                                          WHERE content_id = ".$articleQueryResults[$i]['content_id']." ";

                          $contentQueryResult\; =$this->core->Db->getQueryResult($sql);$result[] = array(        "title"                        => $contentQueryResult[\text{'}content\_title\text{'}],\; "text"\; =>$this->core->Common->cutText($contentQueryResult[\text{'}content\_binary\text{'}],\; 150),\; "content\_id"\; =>$articleQueryResults[$i][\text{'}content\_id\text{'}]\; );\; \}\; return$result;                

                  

          }

          

          function getLatestAudio () {

                  

                  $result\; =\; array();$sql = "SELECT content_id

                                  FROM content_type_audio

                                  ORDER BY content_type_audio_id DESC

                                  LIMIT 5";

                                  // Eventueel: WHERE rss_article = 0 om de rss feeds eruit te halen

                  $articleQueryResults\; =$this->core->Db->getQueryResults($sql);\; for\; ($i = 0 ; articleQueryResults) ; $i++)\; \{$sql = "SELECT *

                                          FROM content

                                          WHERE content_id = ".$articleQueryResults[$i]['content_id']." ";

                          $contentQueryResult\; =$this->core->Db->getQueryResult($sql);$result[] = array(        "title"                        => $contentQueryResult[\text{'}content\_title\text{'}],\; "description"\; =>$this->core->Common->cutText($contentQueryResult[\text{'}content\_binary\text{'}],\; 150),\; "content\_id"\; =>$articleQueryResults[$i][\text{'}content\_id\text{'}]\; );\; \}\; return$result;                                

                  

          }        

                  

          function setViewCategoryVars () {

          

                  $result\; =\; array();$arrSelections = array();

                  $whereStatement\; =\; \text{'}\text{'};$category = $\_GET[\text{'}Cat\text{'}];$/*

                  healthSelected = 0;

                  $politicsSelected\; =\; 0;$wildlifeSelected = 0;

                  $energySelected\; =\; 0;$businessSelected = 0;

                  $climateSelected\; =\; 0;$pollutionSelected = 0;

                  $technologySelected\; =\; 0;$lifestyleSelected = 0;

                  $environmentSelected\; =\; 0;\; */$

                  

                  // de switch is niet perse nodig, maar de default is wel handig voor als niet is opgegeven

                  // Ook kan deze functie gebruikt worden om van meerdere categorien de content te krijgen

                  switch (category) {

                          case 'Health':

                                  $arrSelections[]\; =\; \text{'}health\text{'};\; break;\; case\; \text{'}Politics\text{'}:$arrSelections[] = 'politics';

                                  break;

                          case 'Wildlife':

                                  $arrSelections[]\; =\; \text{'}wildlife\text{'};\; break;\; case\; \text{'}Energy\text{'}:$arrSelections[] = 'energy';

                                  break;

                          case 'Business':

                                  $arrSelections[]\; =\; \text{'}business\text{'};\; break;\; case\; \text{'}Climate\text{'}:$arrSelections[] = 'climate';

                                  break;

                          case 'Pollution':

                                  $arrSelections[]\; =\; \text{'}pollution\text{'};\; break;\; case\; \text{'}Technology\text{'}:$arrSelections[] = 'technology';

                                  break;

                          case 'Lifestyle':

                                  $arrSelections[]\; =\; \text{'}lifestyle\text{'};\; break;\; case\; \text{'}Environment\text{'}:$arrSelections[] = 'environment';

                                  break;

                          default:

                                  $arrSelections[]\; =\; \text{'}health\text{'};\; \}\; for\; ($i = 0 ; arrSelections) ; $i++)\; \{\; if\; ($i == 0) {

                                  $whereStatement\; =\; \text{'}WHERE\; \text{'}.$arrSelections[$i].\text{'}\; =\; 1\text{'};\; \}\; else\; \{$whereStatement .= 'AND '.$arrSelections[$i].' = 1';

                          }

                  }                                                                                                                                                                                                                                                                                                                

                          

                  $sql\; =\; "SELECT\; content\_id\; FROM\; content\_matrix\; ".$whereStatement."

                                  ORDER BY content_id DESC

                                  LIMIT 50";

                  $catContentQueryResults\; =$this->core->Db->getQueryResults($sql);\; for\; ($i = 0 ; catContentQueryResults) ; $i++)\; \{$sql = "SELECT *

                                          FROM content

                                          WHERE content_id = ".$catContentQueryResults[$i]['content_id']." ";

                          $contentQueryResult\; =$this->core->Db->getQueryResult($sql);\; switch\; ($contentQueryResult['content_type']) {

                                  case 'picture':

                                  

                                          $result[]\; =\; array(\; "title"\; =>$contentQueryResult['content_title'],

                                                                                  "image_url"                        => 'www.few.vu.nl/~casus07/images/thumb_empty_image.jpg',

                                                                                  "link_url"                        => 'index.php?Page=PictureView&ContentId='.$catContentQueryResults[$i]['content_id'],

                                                                                  "text"                                => 'PICTURE - '.$this->core->Common->cutText($contentQueryResult['content_description'], 150),

                                                                                  "content_id"                => $catContentQueryResults[$i]['content_id'] );

                                          break;

                                          

                                  case 'article':

                                                                  

                                          $result[]\; =\; array(\; "title"\; =>$contentQueryResult['content_title'],

                                                                                  "image_url"                        => 'www.few.vu.nl/~casus07/images/thumb_empty_article.jpg',

                                                                                  "link_url"                        => 'index.php?Page=ArticleView&ContentId='.$catContentQueryResults[$i]['content_id'],

                                                                                  "text"                                => 'ARTICLE - '.$this->core->Common->cutText($contentQueryResult['content_binary'], 150),

                                                                                  "content_id"                => $catContentQueryResults[$i]['content_id'] );

                                          break;

                                          

                                  case 'video':

                                  

                                          $result[]\; =\; array(\; "title"\; =>$contentQueryResult['content_title'],

                                                                                  "image_url"                        => 'www.few.vu.nl/~casus07/images/thumb_empty_video.jpg',

                                                                                  "link_url"                        => 'index.php?Page=VideoView&ContentId='.$catContentQueryResults[$i]['content_id'],

                                                                                  "text"                                => 'VIDEO - '.$this->core->Common->cutText($contentQueryResult['content_description'], 150),

                                                                                  "content_id"                => $catContentQueryResults[$i]['content_id'] );

                                          break;

                                          

                                  case 'audio':

                                  

                                          $result[]\; =\; array(\; "title"\; =>$contentQueryResult['content_title'],

                                                                                  "image_url"                        => 'www.few.vu.nl/~casus07/images/thumb_empty_audio.jpg',

                                                                                  "link_url"                        => 'index.php?Page=AudioView&ContentId='.$catContentQueryResults[$i]['content_id'],

                                                                                  "text"                                => 'VIDEO - '.$this->core->Common->cutText($contentQueryResult['content_description'], 150),

                                                                                  "content_id"                => $catContentQueryResults[$i]['content_id'] );

                                          break;

                                          

                          }                                                                

                  }

                  

                  $this->core->PageComm->setPageCommVar(\text{'}cat\_items\text{'},$result);

                  $this->core->PageComm->setPageCommVar(\text{'}cat\_title\text{'},$category);

                                  

          }

          

          function setArticleView () {

                  

                  $contentId\; =$_GET['ContentId'];

                  

                  $sql\; =\; "SELECT\; *\; FROM\; content\; WHERE\; content\_id\; =\; ".$contentId." ";

                  $contentQueryResult\; =$this->core->Db->getQueryResult($sql);$this->core->PageComm->setPageCommVar('article_title', $contentQueryResult[\text{'}content\_title\text{'}]);$this->core->PageComm->setPageCommVar('article_text', $contentQueryResult[\text{'}content\_binary\text{'}]);$this->core->PageComm->setPageCommVar('article_sourceurl', $contentQueryResult[\text{'}content\_sourceurl\text{'}]);\; \}\; function\; setVideoView\; ()\; \{$contentId = $\_GET[\text{'}ContentId\text{'}];$sql = "SELECT *

                                  FROM content

                                  WHERE content_id = ".$contentId."\; ";$contentQueryResult = $this->core->Db->getQueryResult($sql);

                  

                  

                  if ($contentQueryResult[\text{'}content\_source\_name\text{'}]\; ==\; \text{'}Youtube\text{'})\; \{$videoCode = $contentQueryResult[\text{'}content\_binary\text{'}];\; \}\; else\; \{$videoCode = '        <OBJECT id="mediaPlayer" width="400" height="300" 

                                                        classid="CLSID:22d6f312-b0f6-11d0-94ab-0080c74c7e95" 

                                                        codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701"

                                                        standby="Loading Microsoft Windows Media Player components..." type="application/x-oleobject">

                                                        <param name="fileName" value="http://www.few.vu.nl/~casus07/cms/'.$contentQueryResult[\text{'}content\_binary\text{'}].\text{'}">$<param name="animationatStart" value="true">

                                                        <param name="transparentatStart" value="true">

                                                        <param name="autoStart" value="true">

                                                        <param name="showControls" value="true">

                                                        <param name="loop" value="true">

                                                        <EMBED type="application/x-mplayer2"

                                                                  pluginspage="http://microsoft.com/windows/mediaplayer/en/download/"

                                                                  id="mediaPlayer" name="mediaPlayer" displaysize="4" autosize="-1" 

                                                                  bgcolor="darkblue" showcontrols="true" showtracker="-1" 

                                                                  showdisplay="0" showstatusbar="-1" videoborder3d="-1" width="400" height="300"

                                                                  src="http://www.few.vu.nl/~casus07/cms/'.contentQueryResult['content_binary'].'" autostart="true" designtimesp="5311" loop="true">

                                                          </EMBED>

                                                          </OBJECT>';

                  }

                  

                  

                  $this->core->PageComm->setPageCommVar(\text{'}video\_title\text{'},$contentQueryResult['content_title']);

                  $this->core->PageComm->setPageCommVar(\text{'}video\_description\text{'},$contentQueryResult['content_description']);

                  $this->core->PageComm->setPageCommVar(\text{'}audio\_sourceurl\text{'},$contentQueryResult['content_sourceurl']);

                  $this->core->PageComm->setPageCommVar(\text{'}video\_code\text{'},$videoCode);                

                  

          }

          

          function setAudioView () {

                  

                  $contentId\; =$_GET['ContentId'];

                  

                  $sql\; =\; "SELECT\; *\; FROM\; content\; WHERE\; content\_id\; =\; ".$contentId." ";

                  $contentQueryResult\; =$this->core->Db->getQueryResult($sql);$this->core->PageComm->setPageCommVar('audio_file_url', 'www.few.vu.nl/~casus07/cms/'.$contentQueryResult['content_binary']);

                  $this->core->PageComm->setPageCommVar(\text{'}audio\_title\text{'},$contentQueryResult['content_title']);

                  $this->core->PageComm->setPageCommVar(\text{'}audio\_sourceurl\text{'},$contentQueryResult['content_sourceurl']);

                  $this->core->PageComm->setPageCommVar(\text{'}audio\_description\text{'},$contentQueryResult['content_description']);                

                  

          }

          

          function setPictureView () {

                  

                  $contentId\; =$_GET['ContentId'];

                  

                  $sql\; =\; "SELECT\; *\; FROM\; content\; WHERE\; content\_id\; =\; ".$contentId." ";

                  $contentQueryResult\; =$this->core->Db->getQueryResult($sql);$this->core->PageComm->setPageCommVar('picture_file_url', 'www.few.vu.nl/~casus07/cms/'.$contentQueryResult['content_binary']);

                  $this->core->PageComm->setPageCommVar(\text{'}picture\_title\text{'},$contentQueryResult['content_title']);

                  $this->core->PageComm->setPageCommVar(\text{'}picture\_sourceurl\text{'},$contentQueryResult['content_sourceurl']);

                  $this->core->PageComm->setPageCommVar(\text{'}picture\_description\text{'},$contentQueryResult['content_description']);        

                  

          }

          

      

      

  }

  

  ?>