Advanced search  

News:

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.
[more]

Pages: [1]   Go Down

Author Topic: Uploaded Files  (Read 4394 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.017 seconds with 19 queries.