Changeset 508

Timestamp:

Aug 31, 2004, 11:32:58 PM (20 years ago)

Author:

z0rglub

Message:

if category is best_rated : displays the average rate of the element before
its name

File:

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

trunk/include/category_default.inc.php

@@ -40 +40 @@
 $query = '
 SELECT DISTINCT(id),file,date_available
-       ,tn_ext,name,filesize,storage_category_id
+       ,tn_ext,name,filesize,storage_category_id,average_rate
   FROM '.IMAGES_TABLE.' AS i
     INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=ic.image_id
@@ -79 +79 @@
   {
     $name = str_replace('_', ' ', $file);
+  }
+  if ($page['cat'] == 'best_rated')
+  {
+    $name = '('.$row['average_rate'].') '.$name;
   }