How can I change the order of the pics ? How can I change the order of the pics ?
 

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]

Main Menu

How can I change the order of the pics ?

Started by Heroe, January 15, 2009, 03:15:58 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Heroe

Hi my question is how to change the order of the pictures i do search the docs but i find for "How can I change the order of the pics when editing them " i search the forum but i don't find answer

for examle when i open album the pictures/thumbs are showed 1.2.3.4 i want to be 4.1.3.2 because when i uploading pictures i upload 100+ files ore more and  cannot play all day to sort them  :o  i us JUpload to upload my pictures.

i did this changes from the docs

$sql = "SELECT p.*,a.category FROM {$CONFIG['TABLE_PICTURES']} as p ".
                           "INNER JOIN {$CONFIG['TABLE_ALBUMS']} as a ".
                           "ON a.aid=p.aid ".
                           "WHERE p.aid = '$album_id' ".
                           "ORDER BY p.filename LIMIT $start, $count";
                $result = cpg_db_query($sql);


change to

$sql = "SELECT p.*,a.category FROM {$CONFIG['TABLE_PICTURES']} as p ".
                           "INNER JOIN {$CONFIG['TABLE_ALBUMS']} as a ".
                           "ON a.aid=p.aid ".
                           "WHERE p.aid = '$album_id' ".
                           "ORDER BY pid LIMIT $start, $count";
                $result = cpg_db_query($sql);


this is the change the order of the pics when editing them



coppermine 1.4.19
http://abroadbg.com
test account
user ; test
password ; 123654

:)