Changeset 18134 for branches

Timestamp:

2009/06/20 18:44:34 (15 years ago)

Author:

Seasoft

Message:

PostgreSQL 7.4 に対応する試み。

• フォーラムにて kurota 様のご報告。 http://xoops.ec-cube.net/modules/newbb/viewtopic.php?topic_id=4146&post_id=18102
• r17601, r18023 による影響。
• PostgreSQL 7.4 での動作テストは行なっておりません。

Location:

branches/comu-ver2/data/class

Files:

• helper/SC_Helper_DB.php (modified) (2 diffs)
• pages/admin/products/LC_Page_Admin_Products_ProductRank.php (modified) (2 diffs)

branches/comu-ver2/data/class/helper/SC_Helper_DB.php

@@ -1759 +1759 @@
         
         if ($temp_table) {
-            $table = 'dtb_order_temp';
+            $tgt_table = 'dtb_order_temp';
             $sql_where = 'WHERE order_temp_id = ?';
         } else {
-            $table = 'dtb_order';
+            $tgt_table = 'dtb_order';
             $sql_where = 'WHERE order_id = ?';
         }
@@ -1768 +1768 @@
         $sql = <<< __EOS__
             UPDATE
-                $table tgt
+                {$tgt_table}
             SET
-                 payment_method = (SELECT payment_method FROM dtb_payment WHERE payment_id = tgt.payment_id)
-                ,deliv_time = (SELECT deliv_time FROM dtb_delivtime WHERE time_id = tgt.deliv_time_id AND deliv_id = tgt.deliv_id)
+                 payment_method = (SELECT payment_method FROM dtb_payment WHERE payment_id = {$tgt_table}.payment_id)
+                ,deliv_time = (SELECT deliv_time FROM dtb_delivtime WHERE time_id = {$tgt_table}.deliv_time_id AND deliv_id = {$tgt_table}.deliv_id)
             $sql_where
 __EOS__;

branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php

@@ -96 +96 @@
         case 'renumber':
             $sql = <<< __EOS__
-                UPDATE dtb_product_categories tgt
+                UPDATE dtb_product_categories
                 SET
                     rank =
@@ -102 +102 @@
                             SELECT COUNT(*)
                             FROM dtb_product_categories t_in
-                            WHERE t_in.category_id = tgt.category_id
+                            WHERE t_in.category_id = dtb_product_categories.category_id
                                 AND (
-                                    t_in.rank < tgt.rank
+                                    t_in.rank < dtb_product_categories.rank
                                     OR (
-                                        t_in.rank = tgt.rank
-                                        AND t_in.product_id < tgt.product_id
+                                        t_in.rank = dtb_product_categories.rank
+                                        AND t_in.product_id < dtb_product_categories.product_id
                                     )
                                 )
                         ) + 1
-                WHERE tgt.category_id = ?
+                WHERE dtb_product_categories.category_id = ?
 __EOS__;
             $objQuery->query($sql, array($_POST['parent_category_id']));