Advanced search  

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

Pages: [1]   Go Down

Author Topic: How can I change the order of the pics ?  (Read 1729 times)

0 Members and 1 Guest are viewing this topic.

Heroe

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 124
    • abroadbg.com
How can I change the order of the pics ?
« 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

:)

Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.