forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: tysoh on October 10, 2006, 10:16:33 am

Title: Last Additions box in index.php
Post by: tysoh 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: http://www.tyzon.net/gallery/index.php


I have tried to edit the ctime in the database

Title: Re: Last Additions box in index.php
Post by: Nibbler 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/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";