Changeset 2309 for trunk/include/picture_rate.inc.php

Timestamp:

Apr 26, 2008, 1:38:04 AM (16 years ago)

Author:

rvelices

Message:

• less mysql queries on picture page (under some circumstances)

File:

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

trunk/include/picture_rate.inc.php

@@ -29 +29 @@
 if ($conf['rate'])
 {
-  $query = '
+  if ( NULL != $picture['current']['average_rate'] )
+  {
+    $query = '
 SELECT COUNT(rate) AS count
      , ROUND(AVG(rate),2) AS average
@@ -36 +38 @@
   WHERE element_id = '.$picture['current']['id'].'
 ;';
-  $row = mysql_fetch_array(pwg_query($query));
+    $row = mysql_fetch_array(pwg_query($query));
+  }
+  else
+  { // avg rate null -> no rate -> no need to query db
+    $row = array( 'count'=>0, 'average'=>NULL, 'std'=>NULL );
+  }
   $template->assign('rate_summary', $row);