Changeset 12414


Ignore:
Timestamp:
Oct 12, 2011, 5:23:38 PM (9 years ago)
Author:
plg
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/PWG_Stuffs/trunk/modules/Recent/main.inc.php

    r12401 r12414  
    4141$query .= '
    4242    '.$forbidden.'
    43     ORDER BY i.id DESC
     43    ORDER BY  date_available DESC, i.id DESC
    4444    LIMIT 0, '.$datas['nb_images'].'
    4545  ;';
     
    5454  FROM '.IMAGES_TABLE.'
    5555  WHERE id IN ('.implode(',', $selection).')
    56   ORDER BY id DESC
     56  ORDER BY  date_available DESC, id DESC
    5757;';
    5858  $result = pwg_query($query);
Note: See TracChangeset for help on using the changeset viewer.