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>