Print

[tysoh]

I have recently batched upload many wallpapers into the database, however I have changed the timestamp for individual wallpaper. But when I view the homepage, the Last additions box doesnt sort my wallpapers according to the last upload date: http://www.tyzon.net/gallery/index.php


I have tried to edit the ctime in the database

[Nibbler]

Last additions does not sort by ctime. It sorts by pid which is more efficient. You can change it in include/functions.inc.php

Code: [Select]

$query = "SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' $META_ALBUM_SET ORDER BY pid DESC $limit";
change pid to ctime

Code: [Select]

$query = "SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' $META_ALBUM_SET ORDER BY ctime DESC $limit";