Sort order in "Edit pics"

[DanielS]

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]

Where 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]

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]

By 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 Expand

    $sql =  "SELECT * ".
                        "FROM {$CONFIG['TABLE_PICTURES']} ".
                        "WHERE approved = 'NO' ".
                        "ORDER BY pid ".
                        "LIMIT $start, $count";

GauGau