diff options
| author | xgizzmo <xgizzmo@ampache> | 2007-09-10 23:44:58 +0000 |
|---|---|---|
| committer | xgizzmo <xgizzmo@ampache> | 2007-09-10 23:44:58 +0000 |
| commit | 8edeba995590a2c75d0ce55d431c6fd5190817da (patch) | |
| tree | ef8fe27026722424bf49232ac7225c1faeb643f6 /lib/class/rating.class.php | |
| parent | f89098d3ac6ea2045f34c586d1433ca40e6df9c7 (diff) | |
| download | ampache-8edeba995590a2c75d0ce55d431c6fd5190817da.tar.gz ampache-8edeba995590a2c75d0ce55d431c6fd5190817da.tar.bz2 ampache-8edeba995590a2c75d0ce55d431c6fd5190817da.zip | |
fixed a rating issue
Diffstat (limited to 'lib/class/rating.class.php')
| -rw-r--r-- | lib/class/rating.class.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/lib/class/rating.class.php b/lib/class/rating.class.php index ff7b940d..c963b5f0 100644 --- a/lib/class/rating.class.php +++ b/lib/class/rating.class.php @@ -64,7 +64,7 @@ class Rating { $user_id = Dba::escape($user_id); - $sql = "SELECT `rating` FROM `rating` WHERE `user`='$user_id' AND `object_id`='$this->id' AND `object_type`='$this->type'"; + $sql = "SELECT `score` FROM `rating` WHERE `user`='$user_id' AND `object_id`='$this->id' AND `object_type`='$this->type'"; $db_results = Dba::query($sql); $results = Dba::fetch_assoc($db_results); @@ -82,7 +82,7 @@ class Rating { */ public function get_average() { - $sql = "SELECT `rating` FROM `rating` WHERE `object_id`='$this->id' AND `object_type`='$this->type'"; + $sql = "SELECT `score` FROM `rating` WHERE `object_id`='$this->id' AND `object_type`='$this->type'"; $db_results = Dba::query($sql); $i = 0; @@ -123,11 +123,11 @@ class Rating { $db_results = Dba::query($sql); if ($existing = Dba::fetch_assoc($db_results)) { - $sql = "UPDATE `rating` SET `rating`='$score' WHERE `id`='" . $existing['id'] . "'"; + $sql = "UPDATE `rating` SET `score`='$score' WHERE `id`='" . $existing['id'] . "'"; $db_results = Dba::query($sql); } else { - $sql = "INSERT INTO `rating` (`object_id`,`object_type`,`rating`,`user`) VALUES " . + $sql = "INSERT INTO `rating` (`object_id`,`object_type`,`score`,`user`) VALUES " . " ('$this->id','$this->type','$score','" . $GLOBALS['user']->id . "')"; $db_results = Dba::query($sql); } |