Last Additions box in index.php Last Additions box in index.php
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Last Additions box in index.php

Started by tysoh, October 10, 2006, 10:16:33 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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

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

change pid to ctime

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