Print Page - Sort order in "Edit pics"

Title: Sort order in "Edit pics"
Post by: DanielS on 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?

Title: Re: Sort order in "Edit pics"
Post by: Joachim Müller on 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

Title: Re: Sort order in "Edit pics"
Post by: DanielS on July 16, 2004, 06:20:55 PM

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?

Title: Re: Sort order in "Edit pics"
Post by: Joachim Müller on 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

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: DanielS on July 06, 2004, 12:57:56 PM