Changeset 22795 for branches/version-2_13-dev/data/class

Timestamp:

2013/05/02 17:16:21 (11 years ago)

Author:

kimoto

Message:

#2213 バックアップ管理 プラグインのテーブルをバックアップできずエラーとなる

クオート文字がmysqlで不適切なので修正しました

Location:

branches/version-2_13-dev/data/class

Files:

• SC_Query.php (modified) (2 diffs)
• pages/admin/system/LC_Page_Admin_System_Bkup.php (modified) (2 diffs)

branches/version-2_13-dev/data/class/SC_Query.php

@@ -30 +30 @@
  * @version $Id$
  */
-class SC_Query 
+class SC_Query
 {
 
@@ -774 +774 @@
     {
         if (strlen($where) <= 0) {
-            $sqlde = 'DELETE FROM "' . $table . '"';
+            $sqlde = 'DELETE FROM ' . $this->conn->quoteIdentifier($table);
         } else {
-            $sqlde = 'DELETE FROM "' . $table . '" WHERE ' . $where;
+            $sqlde = 'DELETE FROM ' . $this->conn->quoteIdentifier($table) . ' WHERE ' . $where;
         }
         $ret = $this->query($sqlde, $arrWhereVal, false, null, MDB2_PREPARE_MANIP);

branches/version-2_13-dev/data/class/pages/admin/system/LC_Page_Admin_System_Bkup.php

@@ -32 +32 @@
  * @version $Id$
  */
-class LC_Page_Admin_System_Bkup extends LC_Page_Admin_Ex 
+class LC_Page_Admin_System_Bkup extends LC_Page_Admin_Ex
 {
 
@@ -320 +320 @@
 
             // 全データを取得
-            $sql = 'SELECT * FROM "' . $table . '"';
+            $sql = 'SELECT * FROM ' . $objQuery->conn->quoteIdentifier($table);
 
             $this->fpOutput =& $fp;