🌍
English
Hi P@t,
Concerning [extension by plg] PWG Stuffs, I have a problem with the "Recent pictures" module because I have set:
$conf['order_by_inside_category'] = ' ORDER BY rank ASC, id ASC';
and on PWG_Stuffs/modules/Recent/main.inc.php :
SELECT DISTINCT(i.id) FROM images AS i INNER JOIN image_category AS ic ON i.id = ic.image_id INNER JOIN categories AS c ON ic.category_id = c.id WHERE i.date_available >= SUBDATE( CURRENT_DATE,INTERVAL 7 DAY) ORDER BY date_available DESC, rank ASC, id ASC LIMIT 0, 10 ;
The "rank" is ambiguous (but "id" in the ORDER BY is not ambiguous, I don't understand why)
I don't understand why you don't just perform a:
ORDER BY id DESC
This would avoid the next:
usort($pictures, 'rank_compare');
.
Offline
bug fixed in [Subversion] r8625
Offline
Thanks ;-)
Offline