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
:)