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: Uploaded Files  (Read 4710 times)

0 Members and 1 Guest are viewing this topic.

trackman

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 50
Uploaded Files
« on: December 13, 2005, 12:34:37 am »

What I have been experiencing is that uploaded files have been placed into the last uploads by the time they are uploaded, so if I upload some files after I approve the previous files they don't show up on the main page of last uploads. Is there anyway of when approving files, they show up on the main page first before any others.

Hope you understand

trackman ;D
« Last Edit: December 13, 2005, 10:19:06 pm by Nibbler »
Logged

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1609
  • Paul V.
Re: Uploaded Files
« Reply #1 on: December 13, 2005, 03:31:12 am »

No, I don't understand.  Files are shown in "last uploads" in order by upload time.  Are you saying you want files to use the approval time instead? 
Logged

Nibbler

  • Guest
Re: Uploaded Files
« Reply #2 on: December 13, 2005, 06:40:12 pm »

editpics.php, find

Code: [Select]
$update .= ", approved = 'YES'";
change to

Code: [Select]
$update .= ", approved = 'YES', ctime = UNIX_TIMESTAMP()";
Logged

trackman

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 50
Re: Uploaded Files
« Reply #3 on: December 13, 2005, 09:32:31 pm »

Thanks Nibbler, but they are still showing by approval not upload time ???
Logged

Nibbler

  • Guest
Re: Uploaded Files
« Reply #4 on: December 13, 2005, 09:40:16 pm »

Fix include/functions.inc.php too then

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

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

trackman

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 50
Re: Uploaded Files
« Reply #5 on: December 13, 2005, 10:14:22 pm »

Thanks Nibbler, sorted ;D
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.