Uploaded Files

[trackman]

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

[Paver]

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? 

[Nibbler]

editpics.php, find

Code Select Expand

$update .= ", approved = 'YES'";

change to

Code Select Expand

$update .= ", approved = 'YES', ctime = UNIX_TIMESTAMP()";

[trackman]

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

[Nibbler]

Fix include/functions.inc.php too then

Code Select Expand

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

change to

Code Select Expand

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

[trackman]

Thanks Nibbler, sorted