Advanced search  

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]

Pages: [1]   Go Down

Author Topic: How can I change the order of the pics ?  (Read 1187 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.019 seconds with 20 queries.