XP Web Publishing Wizard Client and Album Order

[meriturva]

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 Expand


$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 Expand


//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