Changeset 5260 for temp/trunk

Timestamp:

2006/09/20 14:47:06 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/conf/conf.php (modified) (1 diff)
• data/lib/slib.php (modified) (1 diff)
• html/products/detail.php (modified) (1 diff)
• html/products/list.php (modified) (1 diff)

temp/trunk/data/conf/conf.php

@@ -851 +851 @@
         AS T3 LEFT JOIN dtb_classcategory AS T4
         ON T3.classcategory_id2 = T4.classcategory_id) AS T5 LEFT JOIN dtb_products AS T6
-        ON product_id_sub = T6.product_id) vw_product_class ',
+        ON product_id_sub = T6.product_id) ',
 
     "vw_category_count" => '

temp/trunk/data/lib/slib.php

@@ -1123 +1123 @@
     $objQuery = new SC_Query();
     $col = "product_id, deliv_fee, name, product_code, main_list_image, main_image, price01, price02, point_rate, product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited, sale_limit, sale_unlimited";
-    $table = "vw_product_class";
+    $table = "vw_product_class AS prdcls";
     $where = "product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ?";
     $objQuery->setorder("rank1 DESC, rank2 DESC");

temp/trunk/html/products/detail.php

@@ -326 +326 @@
         $objQuery = new SC_Query();
         $col = "product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited";
-        $table = "vw_product_class";
+        $table = "vw_product_class AS prdcls";
         $where = "product_id = ?";
         $objQuery->setorder("rank1 DESC, rank2 DESC");

temp/trunk/html/products/list.php

@@ -352 +352 @@
         $objQuery = new SC_Query();
         $col = "product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited";
-        $table = "vw_product_class AS prdcls";
+        $table = "vw_product_class ";
         $where = "product_id = ?";
         $objQuery->setorder("rank1 DESC, rank2 DESC");