topical media & game development

topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _
portal-classes-core.rating.php

  <?php 

  

  class Rating  {

  

          var  $core;

          

          function Rating(&$ core) {

                   $this->core = &$ core;

                   $this->core->Db->connectDb();

          

          }

          

          function showRating() {$ content_id                 =          $_GET['ContentId'];$ grayRating                        =         5;

                   $query_getRating        =         "SELECT * , 

                                                                  AVG(`user_content_rating_emotionalvalue`) ,

                                                                  AVG(`user_content_rating_qualityvalue`) 

                                                                  FROM user_content_rating

                                                                  WHERE content_id = ".$ content_id."

                                                                  GROUP BY `content_id`";

                   $getRating                         =$ this->core->Db->getQueryResults( $query_getRating);$ emotionalAverage        =         $getRating[0]['AVG(`user_content_rating_emotionalvalue`)'];$ qualityAverage                =          $getRating[0]['AVG(`user_content_rating_qualityvalue`)'];$ qualityAverage                =         round( $qualityAverage);$ grayRating                        =         $grayRating        -$ qualityAverage;

  

                  if ( $emotionalAverage == "Negative") {$ emoString = "<div class=\"icons\"><img src=\"images/neg_rating_16.gif\" alt=\"\" width=\"16\" height=\"16\" /></div>";

                  

                  } else {

                          

                           $emoString = "$ <div class=\"icons\"><img src=\"images/pos_rating_16.gif\" alt=\"\" width=\"16\" height=\"16\" /></div>";

                  }

  

                  for (i=0;  $i<$ qualityAverage;  $i++) {$ ratingString .= "<img src=\"images/star_on.png\" alt=\"\" width=\"15\" height=\"15\" />";

                  

                  }

                  for ( $i=0;$ i< $grayRating;$ i++) {

                           $ratingString .= "$ <img src=\"images/star_off.png\" alt=\"\" width=\"15\" height=\"15\" />";

                  }

                  

                  this->core->PageComm->setPageCommVar("showEmoRating",  $emoString );$ this->core->PageComm->setPageCommVar("showQualRating", $ratingString);

          

          }

  

          function setRating() {

          

                  if ($ _COOKIE['user_Id'] != NULL) {        

                           $userId                         =$ _COOKIE['user_Id'];

                           $articleId           =$ _GET['ContentId'];        

                          

                  //         $feeling                =$ _GET['Result'];

                          

                           $query_countUser        =         "SELECT * 

                                                                          FROM user_content_rating 

                                                                          WHERE user_id = ".$ userId." 

                                                                          AND content_id = ". $articleId.";";$ voting =  $this->core->Db->getQueryResults($ query_countUser);

                          if (( $voting[0]['user_content_rating_emotionalvalue'] == NULL) || ($ voting[0]['user_content_rating_qualityvalue'] == NULL)) {

                          

                                  if ( $voting[0]['user_content_rating_emotionalvalue'] == NULL) {$ stringEmo = "<div class=\"rateText\">Rate this item:</div>

                                  <div class=\"icons\"><img border=\"0\" src=\"images/pos_rating_16.gif\" alt=\"positive_rating\" width=\"16\" height=\"16\" /></a>