Changeset 22058 for branches/version-2_12-multilang/data/class/pages/admin/basis/LC_Page_Admin_Basis_Seo.php

Timestamp:

2012/10/22 19:42:42 (11 years ago)

Author:

h_yoshimoto

Message:

#1955 r21998～r22057間のコミットをmerge

Location:

branches/version-2_12-multilang

Files:

• . (modified) (1 prop)
• data/class/pages/admin/basis/LC_Page_Admin_Basis_Seo.php (modified) (1 diff)

branches/version-2_12-multilang/data/class/pages/admin/basis/LC_Page_Admin_Basis_Seo.php

@@ -144 +144 @@
     function lfUpdPageData($arrUpdData = array()) {
         $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $sql = '';
-
-        // SQL生成
-        $sql .= ' UPDATE ';
-        $sql .= '     dtb_pagelayout ';
-        $sql .= ' SET ';
-        $sql .= '     author = ? , ';
-        $sql .= '     description = ? , ';
-        $sql .= '     keyword = ? ';
-        $sql .= ' WHERE ';
-        $sql .= '     device_type_id = ? ';
-        $sql .= '     AND page_id = ? ';
-        $sql .= ' ';
-
-        // SQL実行
-        $ret = $objQuery->query($sql, $arrUpdData);
-
-        return $ret;
+
+        $table = 'dtb_pagelayout';
+        $sqlval = array(
+            'author'        => $arrUpdData[0],
+            'description'   => $arrUpdData[1],
+            'keyword'       => $arrUpdData[2],
+        );
+        $where = 'device_type_id = ? AND page_id = ?';
+        $arrWhereVal = array(
+            $arrUpdData[3],
+            $arrUpdData[4],
+        );
+
+        return $objQuery->update($table, $sqlval, $where, $arrWhereVal);
     }