Changeset 11827 for trunk/include/ws_functions.inc.php

Timestamp:

Jul 25, 2011, 8:04:50 PM (13 years ago)

Author:

rvelices

Message:

feature 2384: improve average rating calculation (still need to update language files)

File:

• trunk/include/ws_functions.inc.php (modified) (2 diffs)

trunk/include/ws_functions.inc.php

@@ -782 +782 @@
   }
   //------------------------------------------------------------- related rates
-  $query = '
+        $rating = array('score'=>$image_row['average_rate'], 'count'=>0, 'average'=>null);
+        if (isset($rating['score']))
+        {
+                $query = '
 SELECT COUNT(rate) AS count
      , ROUND(AVG(rate),2) AS average
@@ -788 +791 @@
   WHERE element_id = '.$image_row['id'].'
 ;';
-  $rating = pwg_db_fetch_assoc(pwg_query($query));
-  $rating['count'] = (int)$rating['count'];
+                $row = pwg_db_fetch_assoc(pwg_query($query));
+                $rating['score'] = (float)$rating['score'];
+                $rating['average'] = (float)$row['average'];
+                $rating['count'] = (int)$row['count'];
+        }
 
   //---------------------------------------------------------- related comments