Changeset 5250

Timestamp:

2006/09/20 14:28:38 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

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

temp/trunk/data/conf/conf.php

@@ -758 +758 @@
     "vw_cross_class" => '
         (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 ) vw_cross_class ',
+        FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) ',
 
     "vw_cross_products_class" =>'
@@ -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) vw_cross_products_class ',
+        ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) ',
 
     "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) vw_products_nonclass ',
+        ON T1.product_id = T2.product_id_sub) ',
     
     "vw_products_allclass" => '

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

@@ -200 +200 @@
         // µ¬³Ê1¤Èµ¬³Ê2
         $sql = "SELECT * ";
-        $sql.= "FROM vw_cross_class ";
+        $sql.= "FROM vw_cross_class AS crs_cls ";
         $sql.= "WHERE class_id1 = ? AND class_id2 = ? ORDER BY rank1 DESC, rank2 DESC;";
         $arrRet = $objQuery->getall($sql, array($class_id1, $class_id2));
@@ -206 +206 @@
         // µ¬³Ê1¤Î¤ß
         $sql = "SELECT * ";
-        $sql.= "FROM vw_cross_class ";
+        $sql.= "FROM vw_cross_class AS crs_cls ";
         $sql.= "WHERE class_id1 = ? AND class_id2 = 0 ORDER BY rank1 DESC;";
         $arrRet = $objQuery->getall($sql, array($class_id1));