Advanced search  


cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.

Pages: [1]   Go Down

Author Topic: Last Additions box in index.php  (Read 2206 times)

0 Members and 1 Guest are viewing this topic.


  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Last Additions box in index.php
« on: October 10, 2006, 10:16:33 am »

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:

I have tried to edit the ctime in the database


  • Guest
Re: Last Additions box in index.php
« Reply #1 on: October 10, 2006, 12:20:28 pm »

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

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";
Pages: [1]   Go Up

Page created in 0.016 seconds with 20 queries.