forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Heroe on January 15, 2009, 03:15:58 pm

Title: How can I change the order of the pics ?
Post by: Heroe on January 15, 2009, 03:15:58 pm
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

Code: [Select]
$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

Code: [Select]
$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

:)