Changeset 12414 for extensions

Timestamp:

Oct 12, 2011, 5:23:38 PM (13 years ago)

Author:

plg

Message:

bug fixed: correctly sort by date availability, id is not reliable

File:

• extensions/PWG_Stuffs/trunk/modules/Recent/main.inc.php (modified) (2 diffs)

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

@@ -41 +41 @@
 $query .= '
     '.$forbidden.'
-    ORDER BY i.id DESC
+    ORDER BY  date_available DESC, i.id DESC
     LIMIT 0, '.$datas['nb_images'].'
   ;';
@@ -54 +54 @@
   FROM '.IMAGES_TABLE.'
   WHERE id IN ('.implode(',', $selection).')
-  ORDER BY id DESC
+  ORDER BY  date_available DESC, id DESC
 ;';
   $result = pwg_query($query);