Sort order in "Edit pics" Sort order in "Edit pics"
 

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

Sort order in "Edit pics"

Started by DanielS, July 06, 2004, 12:57:56 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

DanielS

July 06, 2004, 12:57:56 PM
I have a large collection of pics in one album. I want to delete old pics, but the sort order is alphabetical (despite of "By date" in Control Panel"), and I cannot change it. Where can I set sort order on "Edit Pics" page?

Joachim Müller

#1
July 10, 2004, 04:30:43 PM
Quote from: DanielS on July 06, 2004, 12:57:56 PMWhere can I set sort order on "Edit Pics" page?
Not at all in the user interface, you'll have to look into the code and modify the query.

GauGau

DanielS

#2
July 16, 2004, 06:20:55 PM Last Edit: July 17, 2004, 11:33:06 AM by DanielS
I cannot edit the code, because i'm total newbie in PHP!
Please, tell me, what and wnere should I edit?
I know, that this is in "editpics.php"...

By the way, I can provide you with a good russian translation of Coppermine, that I made for my site. Do you need it?

Joachim Müller

#3
July 17, 2004, 12:34:05 PM
Quote from: DanielS on July 16, 2004, 06:20:55 PMBy the way, I can provide you with a good russian translation of Coppermine, that I made for my site. Do you need it?
Sure, translations are always welcome. Please refer to http://forum.coppermine-gallery.net/index.php?topic=4623.0 on this issue.

Haven't looked into this in detail, but I think, the code in question is
Code Select
    $sql =  "SELECT * ".
                        "FROM {$CONFIG['TABLE_PICTURES']} ".
                        "WHERE approved = 'NO' ".
                        "ORDER BY pid ".
                        "LIMIT $start, $count";

GauGau
Print
Go Up Pages1
User actions