Changeset 8625 for extensions/PWG_Stuffs/modules

Timestamp:

Jan 12, 2011, 12:38:45 PM (13 years ago)

Author:

plg

Message:

fix bug on RecentPictures module in PWG Stuffs plugin when rank is used in the order by configuration parameter

File:

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

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

@@ -41 +41 @@
 $query .= '
     '.$forbidden.'
-    '. str_replace('ORDER BY ', 'ORDER BY date_available DESC, ', $conf['order_by']).'
+    ORDER BY i.id DESC
     LIMIT 0, '.$datas['nb_images'].'
   ;';
@@ -50 +50 @@
 if (count($selection) > 0)
 {
-  $rank_of = array_flip($selection);
-
   $query = '
 SELECT *
   FROM '.IMAGES_TABLE.'
   WHERE id IN ('.implode(',', $selection).')
+  ORDER BY id DESC
 ;';
   $result = pwg_query($query);
   while ($row = mysql_fetch_assoc($result))
   {
-    $row['rank'] = $rank_of[ $row['id'] ];
-
     array_push($pictures, $row);
   }
-
-  usort($pictures, 'rank_compare');
-  unset($rank_of);
 }