Changeset 2435 for trunk/include/functions_rate.inc.php

Timestamp:

Jul 15, 2008, 3:29:23 AM (16 years ago)

Author:

rvelices

Message:

• image rating on picture page done through ajax (tested safari/ie 6&7/ff)

File:

• trunk/include/functions_rate.inc.php (modified) (3 diffs)

trunk/include/functions_rate.inc.php

@@ -37 +37 @@
       or !in_array($rate, $conf['rate_items']))
   {
-    return;
+    return false;
   }
 
@@ -44 +44 @@
   if ($user_anonymous and !$conf['rate_anonymous'])
   {
-    return;
+    return false;
   }
 
@@ -119 +119 @@
   // update of images.average_rate field
   $query = '
-SELECT ROUND(AVG(rate),2) AS average_rate
+SELECT COUNT(rate) AS count
+     , ROUND(AVG(rate),2) AS average
+     , ROUND(STD(rate),2) AS stdev
   FROM '.RATE_TABLE.'
   WHERE element_id = '.$image_id.'
 ;';
-  $row = mysql_fetch_array(pwg_query($query));
+  $row = mysql_fetch_assoc(pwg_query($query));
   $query = '
 UPDATE '.IMAGES_TABLE.'
-  SET average_rate = '.$row['average_rate'].'
+  SET average_rate = '.$row['average'].'
   WHERE id = '.$image_id.'
 ;';
   pwg_query($query);
+  return $row;
 }