Changeset 12401 for extensions/PWG_Stuffs/trunk/modules/BestRated/main.inc.php

Timestamp:

Oct 10, 2011, 6:37:18 PM (13 years ago)

Author:

patdenice

Message:

Best rated module is now compatible with piwigo 2.3

File:

• extensions/PWG_Stuffs/trunk/modules/BestRated/main.inc.php (modified) (3 diffs)

extensions/PWG_Stuffs/trunk/modules/BestRated/main.inc.php

@@ -24 +24 @@
   );
 
-$query ='
+$query = '
 SELECT DISTINCT(i.id)
   FROM '.IMAGES_TABLE.' AS i
     INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id
     INNER JOIN '.CATEGORIES_TABLE.' AS c ON ic.category_id = c.id
-  WHERE i.average_rate IS NOT NULL';
+  WHERE i.rating_score IS NOT NULL';
 
 if (isset($page['category']))
@@ -40 +40 @@
 $query .= '
       '.$forbidden.'
-      ORDER BY i.average_rate DESC, i.id ASC
-    LIMIT 0, '.$datas['nb_images'].'
-  ;';
+  ORDER BY i.rating_score DESC, i.id DESC
+  LIMIT 0, '.$datas['nb_images'].'
+;';
 
 $pictures = array();
@@ -127 +127 @@
     }
 
-    if ($conf['show_thumbnail_caption'])
-    {// name of the picture
-      if (isset($row['name']) and $row['name'] != '')
-      {
-        $name = $row['name'];
-      }
-      else
-      {
-        $name = str_replace('_', ' ', get_filename_wo_extension($row['file']));
-      }
+    if (isset($row['name']) and $row['name'] != '')
+    {
+      $name = $row['name'];
+    }
+    else
+    {
+      $name = str_replace('_', ' ', get_filename_wo_extension($row['file']));
+    }
 
-      $tpl_var['NAME'] = '('.$row['average_rate'].') '.$name;
-    }
+    $tpl_var['NAME'] = '('.$row['rating_score'].') '.$name;
 
     if ( isset($nb_comments_of) )