Changeset 5251 for temp/trunk

Timestamp:

2006/09/20 14:30:04 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/conf/conf.php (modified) (2 diffs)
• html/admin/products/product_class.php (modified) (1 diff)

temp/trunk/data/conf/conf.php

@@ -765 +765 @@
         FROM (SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2
         FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) AS T1 LEFT JOIN dtb_products_class AS T2 
-        ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) ',
+        ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) vw_cross_products_class ',
 
     "vw_products_nonclass" => '
@@ -780 +780 @@
         FROM dtb_products_class WHERE classcategory_id1 = 0 AND classcategory_id2 = 0) 
         AS T2
-        ON T1.product_id = T2.product_id_sub) ',
+        ON T1.product_id = T2.product_id_sub) vw_products_nonclass',
     
     "vw_products_allclass" => '

temp/trunk/html/admin/products/product_class.php

@@ -55 +55 @@
     $where = "product_id = ? AND NOT (classcategory_id1 = 0 AND classcategory_id2 = 0)";
     $objQuery->setOrder("rank1 DESC, rank2 DESC");
-    $arrRet = $objQuery->select("*", "vw_cross_products_class", $where, array($_POST['product_id']));
+    $arrRet = $objQuery->select("*", "vw_cross_products_class AS crs_prd", $where, array($_POST['product_id']));
     
     if(count($arrRet) > 0) {