PHP SJB_Rating::canRate Examples

Example #1

File: Rating.php Project: Maxlander/shixi

 public static function setRaiting($rate, $listing_sid, $user_id)
 {
     if ($rate < 1 || $rate > 5 || !SJB_Rating::canRate($listing_sid)) {
         return false;
     }
     SJB_DB::query("INSERT INTO rating VALUES (NULL, '{$user_id}', '{$listing_sid}', '{$rate}', NOW())");
     $result = SJB_DB::query("SELECT COUNT(*) AS `num` , ROUND((SUM(vote) / COUNT(*)), 1) AS rating FROM `rating` WHERE `listing_id` = ?n ", $listing_sid);
     $row = array_shift($result);
     return array('rating' => $row['rating'], 'total' => $row['num']);
 }