Changeset 27414 for extensions/physical2virtual/main.inc.php

Timestamp:

Feb 19, 2014, 10:23:02 AM (10 years ago)

Author:

JanisV

Message:

Fixed updating representative image for virtual albums

File:

• extensions/physical2virtual/main.inc.php (modified) (3 diffs)

extensions/physical2virtual/main.inc.php

@@ -37 +37 @@
 {
   $query = '
-SELECT DISTINCT virt_category_id AS id
+SELECT DISTINCT virt_category_id AS id, representative_picture_id
   FROM '.PHY2VIRT_CATEGORIES_TABLE.'
+  JOIN '.CATEGORIES_TABLE.' ON '.PHY2VIRT_CATEGORIES_TABLE.'.virt_category_id = '.CATEGORIES_TABLE.'.id
   WHERE phy_category_id = '.$phy_category['id'].'
 ;';
@@ -44 +45 @@
   if (!empty($virt_category))
   {
-    return $virt_category; /// add $virt_cat['representative_picture_id']
+    return $virt_category;
   }
   
@@ -104 +105 @@
       FROM '.CATEGORIES_TABLE.' cat
       WHERE cat.dir IS NOT NULL
+    )
+  ;';
+  pwg_query($query);
+  $query = '
+    DELETE FROM '.PHY2VIRT_CATEGORIES_TABLE.'
+    WHERE virt_category_id NOT IN (
+      SELECT cat.id
+      FROM '.CATEGORIES_TABLE.' cat
+      WHERE cat.dir NOT NULL
     )
   ;';