Changeset 18134 for branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.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/pages/admin/products/LC_Page_Admin_Products_ProductRank.php (modified) (2 diffs)

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']));