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: XP Web Publishing Wizard Client and Album Order  (Read 1952 times)

0 Members and 1 Guest are viewing this topic.

meriturva

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
XP Web Publishing Wizard Client and Album Order
« 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
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.