Advanced search  

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

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.

tysoh

  • 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: http://www.tyzon.net/gallery/index.php


I have tried to edit the ctime in the database
Logged

Nibbler

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

Page created in 0.02 seconds with 20 queries.