Refactor - Extract method

Signed-off-by: Madhura Jayaratne <madhura.cj@gmail.com>

1 files changed, 2 insertions, 52 deletions

diff --git a/db_designer.php b/db_designer.php
index bfb029eb33..3f0a4cf088 100644
--- a/db_designer.php
+++ b/db_designer.php
@@ -81,58 +81,8 @@ if (isset($_REQUEST['operation'])) {
         $response->isSuccess($success);
         $response->addJSON('message', $message);
     } elseif ($_REQUEST['operation'] == 'save_setting_value') {
-        $cfgRelation = PMA_getRelationsParam();
-
-        $cfgDesigner = array(
-            'user'  => $GLOBALS['cfg']['Server']['user'],
-            'db'    => $cfgRelation['db'],
-            'table' => $cfgRelation['designer_settings']
-        );
-        if (! empty($cfgDesigner['user'])
-            && ! empty($cfgDesigner['db'])
-            && ! empty($cfgDesigner['table'])
-            && $GLOBALS['cfgRelation']['designersettingswork']
-        ) {
-            $orig_data_query = 'SELECT ' . PMA_Util::backquote('settings_data')
-                . ' FROM `' . $cfgDesigner['db'] . '`.`' . $cfgDesigner['table']
-                . '` WHERE ' . PMA_Util::backquote('username') . ' = "'
-                . $cfgDesigner['user'] . '"';
-
-            $orig_data = $GLOBALS['dbi']->fetchSingleRow(
-                $orig_data_query, $GLOBALS['controllink']
-            );
-
-            $success = false;
-
-            if (isset($orig_data)
-                && ! empty($orig_data)
-                && $orig_data
-            ) {
-                $orig_data = json_decode($orig_data['settings_data'], true);
-                $orig_data[$_REQUEST['index']] = $_REQUEST['value'];
-                $orig_data = json_encode($orig_data);
-
-                $save_query = 'UPDATE `' . $cfgDesigner['db'] . '`.`'
-                    . $cfgDesigner['table'] . '` SET '
-                    . PMA_Util::backquote('settings_data') . ' = \''
-                    . $orig_data . '\' WHERE ' . PMA_Util::backquote('username')
-                    . ' = "' . $cfgDesigner['user'] . '";';
-
-                $success = PMA_queryAsControlUser($save_query);
-            } else {
-                $save_data = array($_REQUEST['index'] => $_REQUEST['value']);
-
-                $query = 'INSERT INTO ' . PMA_Util::backquote($cfgDesigner['db'])
-                    . '.' . PMA_Util::backquote($cfgDesigner['table'])
-                    . ' VALUES("' . PMA_Util::sqlAddSlashes($cfgDesigner['user'])
-                    . '", \''
-                    . PMA_Util::sqlAddSlashes(json_encode($save_data)) . '\');';
-
-                $success = PMA_queryAsControlUser($query);
-            }
-
-            $response->isSuccess($success);
-        }
+        $success = PMA_saveDesignerSetting($_REQUEST['index'], $_REQUEST['value']);
+        $response->isSuccess($success);
     }
 
     return;