forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: meriturva on July 13, 2007, 03:03:16 pm

Title: XP Web Publishing Wizard Client and Album Order
Post by: meriturva on July 13, 2007, 03:03:16 pm

I have found in xp_publish.php file a little bug...when you create a new album you assign it a default pos value = 0
When you upload many albums with the xp wizard there is no way to have the albums ordered!

This is the line i have found in function create_album()

Code: [Select]

$query = "INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, uploads, pos) VALUES ('$category', '" . addslashes($_POST['new_alb_name']) . "', 'NO',  '0')";

I have modified the xp_publish.php and now:

Code: [Select]

//Diego corretto bugs
$diegoNum=0;
$query = "SELECT MIN(pos) as minnum FROM {$CONFIG['TABLE_ALBUMS']} WHERE category='$category'";
$resultDiego = cpg_db_query($query);
$rowDiego = mysql_fetch_array($resultDiego);
$diegoNum = $rowDiego["minnum"] - 1;
   
$query = "INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, uploads, pos) VALUES ('$category', '" . addslashes($_POST['new_alb_name']) . "', 'NO',  '$diegoNum')";

So now you are sure that the new albums comes always in first position!

If you know a different and better way to do it please inform me!

Meriturva