Changeset 14921 for branches/rel/data

Timestamp:

2007/06/26 12:04:18 (17 years ago)

Author:

uehara

Message:

商品登録CSV改修
MySQLのauto_incrementバグに対応

Location:

branches/rel/data

Files:

• class/SC_Query.php (modified) (1 diff)
• conf/conf.php (modified) (1 diff)

branches/rel/data/class/SC_Query.php

@@ -419 +419 @@
     }
     
-    // auto_increment¤ò¼èÆÀ¤¹¤ë
-    function get_auto_increment($table_name){
-        // ¥í¥Ã¥¯¤¹¤ë
-        $this->BEGIN();
-        
-        // ¼¡¤ÎIncrement¤ò¼èÆÀ
-        $arrRet = $this->getAll("SHOW TABLE STATUS LIKE ?", array($table_name));
-        $auto_inc_no = $arrRet[0]["Auto_increment"];
-        
-        // Ãͤò¥«¥¦¥ó¥È¥¢¥Ã¥×¤·¤Æ¤ª¤¯
-        $this->conn->query("ALTER TABLE $table_name AUTO_INCREMENT=?" , $auto_inc_no + 1);
-        
-        // ²ò½ü¤¹¤ë
-        $this->COMMIT();
-        
-        return $auto_inc_no;
-    }
+    // auto_increment¤ò¼èÆÀ¤¹¤ë
+    function get_auto_increment($table_name){
+        // ¥í¥Ã¥¯¤¹¤ë
+        $this->query("LOCK TABLES $table_name WRITE");
+        
+        // ¼¡¤ÎIncrement¤ò¼èÆÀ
+        $arrRet = $this->getAll("SHOW TABLE STATUS LIKE ?", array($table_name));
+        $auto_inc_no = $arrRet[0]["Auto_increment"];
+        
+        // Ãͤò¥«¥¦¥ó¥È¥¢¥Ã¥×¤·¤Æ¤ª¤¯
+        $this->conn->query("ALTER TABLE $table_name AUTO_INCREMENT=?" , $auto_inc_no + 1);
+        
+        // ²ò½ü¤¹¤ë
+        $this->query('UNLOCK TABLES');
+        
+        return $auto_inc_no;
+    }
 }
 

branches/rel/data/conf/conf.php

@@ -172 +172 @@
 define("DEFAULT_PASSWORD", "UAhgGR3L");
 //¤ª¤¹¤¹¤á¾¦ÉÊ¿ô
-define ("RECOMMEND_PRODUCT_MAX", 5);
+define ("RECOMMEND_PRODUCT_MAX", 6);
 
 //Ê̤ΤªÆϤ±ÀèºÇÂçÅÐÏ¿¿ô