Changeset 18134 for branches/comu-ver2/data/class/helper/SC_Helper_DB.php

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 での動作テストは行なっておりません。

File:

• branches/comu-ver2/data/class/helper/SC_Helper_DB.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__;