Changeset 27414 for extensions/physical2virtual
- Timestamp:
- Feb 19, 2014, 10:23:02 AM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/physical2virtual/main.inc.php
r27413 r27414 37 37 { 38 38 $query = ' 39 SELECT DISTINCT virt_category_id AS id 39 SELECT DISTINCT virt_category_id AS id, representative_picture_id 40 40 FROM '.PHY2VIRT_CATEGORIES_TABLE.' 41 JOIN '.CATEGORIES_TABLE.' ON '.PHY2VIRT_CATEGORIES_TABLE.'.virt_category_id = '.CATEGORIES_TABLE.'.id 41 42 WHERE phy_category_id = '.$phy_category['id'].' 42 43 ;'; … … 44 45 if (!empty($virt_category)) 45 46 { 46 return $virt_category; /// add $virt_cat['representative_picture_id']47 return $virt_category; 47 48 } 48 49 … … 104 105 FROM '.CATEGORIES_TABLE.' cat 105 106 WHERE cat.dir IS NOT NULL 107 ) 108 ;'; 109 pwg_query($query); 110 $query = ' 111 DELETE FROM '.PHY2VIRT_CATEGORIES_TABLE.' 112 WHERE virt_category_id NOT IN ( 113 SELECT cat.id 114 FROM '.CATEGORIES_TABLE.' cat 115 WHERE cat.dir NOT NULL 106 116 ) 107 117 ;';
Note: See TracChangeset
for help on using the changeset viewer.