prefs_manage.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * User preferences management page
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 declare(strict_types=1);
   9
  10 use PhpMyAdmin\Config\ConfigFile;
  11 use PhpMyAdmin\Config\Forms\User\UserFormList;
  12 use PhpMyAdmin\Core;
  13 use PhpMyAdmin\File;
  14 use PhpMyAdmin\Message;
  15 use PhpMyAdmin\Relation;
  16 use PhpMyAdmin\Response;
  17 use PhpMyAdmin\Template;
  18 use PhpMyAdmin\ThemeManager;
  19 use PhpMyAdmin\UserPreferences;
  20 use PhpMyAdmin\UserPreferencesHeader;
  21
  22 if (! defined('ROOT_PATH')) {
  23     define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
  24 }
  25
  26 global $containerBuilder;
  27
  28 /**
  29  * Gets some core libraries and displays a top message if required
  30  */
  31 require_once ROOT_PATH . 'libraries/common.inc.php';
  32
  33 /** @var Template $template */
  34 $template = $containerBuilder->get('template');
  35 /** @var Relation $relation */
  36 $relation = $containerBuilder->get('relation');
  37
  38 $userPreferences = new UserPreferences();
  39
  40 $cf = new ConfigFile($GLOBALS['PMA_Config']->base_settings);
  41 $userPreferences->pageInit($cf);
  42 $response = Response::getInstance();
  43
  44 $error = '';
  45 if (isset($_POST['submit_export'], $_POST['export_type']) && $_POST['export_type'] == 'text_file') {
  46     // export to JSON file
  47     $response->disable();
  48     $filename = 'phpMyAdmin-config-' . urlencode(Core::getenv('HTTP_HOST')) . '.json';
  49     Core::downloadHeader($filename, 'application/json');
  50     $settings = $userPreferences->load();
  51     echo json_encode($settings['config_data'], JSON_PRETTY_PRINT);
  52     exit;
  53 } elseif (isset($_POST['submit_export'], $_POST['export_type']) && $_POST['export_type'] == 'php_file') {
  54     // export to JSON file
  55     $response->disable();
  56     $filename = 'phpMyAdmin-config-' . urlencode(Core::getenv('HTTP_HOST')) . '.php';
  57     Core::downloadHeader($filename, 'application/php');
  58     $settings = $userPreferences->load();
  59     echo '/* ' . __('phpMyAdmin configuration snippet') . " */\n\n";
  60     echo '/* ' . __('Paste it to your config.inc.php') . " */\n\n";
  61     foreach ($settings['config_data'] as $key => $val) {
  62         echo '$cfg[\'' . str_replace('/', '\'][\'', $key) . '\'] = ';
  63         echo var_export($val, true) . ";\n";
  64     }
  65     exit;
  66 } elseif (isset($_POST['submit_get_json'])) {
  67     $settings = $userPreferences->load();
  68     $response->addJSON('prefs', json_encode($settings['config_data']));
  69     $response->addJSON('mtime', $settings['mtime']);
  70     exit;
  71 } elseif (isset($_POST['submit_import'])) {
  72     // load from JSON file
  73     $json = '';
  74     if (isset($_POST['import_type'], $_FILES['import_file'])
  75         && $_POST['import_type'] == 'text_file'
  76         && $_FILES['import_file']['error'] == UPLOAD_ERR_OK
  77         && is_uploaded_file($_FILES['import_file']['tmp_name'])
  78     ) {
  79         $import_handle = new File($_FILES['import_file']['tmp_name']);
  80         $import_handle->checkUploadedFile();
  81         if ($import_handle->isError()) {
  82             $error = $import_handle->getError();
  83         } else {
  84             // read JSON from uploaded file
  85             $json = $import_handle->getRawContent();
  86         }
  87     } else {
  88         // read from POST value (json)
  89         $json = isset($_POST['json']) ? $_POST['json'] : null;
  90     }
  91
  92     // hide header message
  93     $_SESSION['userprefs_autoload'] = true;
  94
  95     $config = json_decode($json, true);
  96     $return_url = isset($_POST['return_url']) ? $_POST['return_url'] : null;
  97     if (! is_array($config)) {
  98         if (! isset($error)) {
  99             $error = __('Could not import configuration');
 100         }
 101     } else {
 102         // sanitize input values: treat them as though
 103         // they came from HTTP POST request
 104         $form_display = new UserFormList($cf);
 105         $new_config = $cf->getFlatDefaultConfig();
 106         if (! empty($_POST['import_merge'])) {
 107             $new_config = array_merge($new_config, $cf->getConfigArray());
 108         }
 109         $new_config = array_merge($new_config, $config);
 110         $_POST_bak = $_POST;
 111         foreach ($new_config as $k => $v) {
 112             $_POST[str_replace('/', '-', $k)] = $v;
 113         }
 114         $cf->resetConfigData();
 115         $all_ok = $form_display->process(true, false);
 116         $all_ok = $all_ok && ! $form_display->hasErrors();
 117         $_POST = $_POST_bak;
 118
 119         if (! $all_ok && isset($_POST['fix_errors'])) {
 120             $form_display->fixErrors();
 121             $all_ok = true;
 122         }
 123         if (! $all_ok) {
 124             // mimic original form and post json in a hidden field
 125             echo UserPreferencesHeader::getContent($template, $relation);
 126
 127             echo $template->render('preferences/manage/error', [
 128                 'form_errors' => $form_display->displayErrors(),
 129                 'json' => $json,
 130                 'import_merge' => isset($_POST['import_merge']) ? $_POST['import_merge'] : null,
 131                 'return_url' => $return_url,
 132             ]);
 133             exit;
 134         }
 135
 136         // check for ThemeDefault
 137         $params = [];
 138         $tmanager = ThemeManager::getInstance();
 139         if (isset($config['ThemeDefault'])
 140             && $tmanager->theme->getId() != $config['ThemeDefault']
 141             && $tmanager->checkTheme($config['ThemeDefault'])
 142         ) {
 143             $tmanager->setActiveTheme($config['ThemeDefault']);
 144             $tmanager->setThemeCookie();
 145         }
 146         if (isset($config['lang'])
 147             && $config['lang'] != $GLOBALS['lang']
 148         ) {
 149             $params['lang'] = $config['lang'];
 150         }
 151
 152         // save settings
 153         $result = $userPreferences->save($cf->getConfigArray());
 154         if ($result === true) {
 155             if ($return_url) {
 156                 $query = PhpMyAdmin\Util::splitURLQuery($return_url);
 157                 $return_url = parse_url($return_url, PHP_URL_PATH);
 158
 159                 foreach ($query as $q) {
 160                     $pos = mb_strpos($q, '=');
 161                     $k = mb_substr($q, 0, $pos);
 162                     if ($k == 'token') {
 163                         continue;
 164                     }
 165                     $params[$k] = mb_substr($q, $pos + 1);
 166                 }
 167             } else {
 168                 $return_url = 'prefs_manage.php';
 169             }
 170             // reload config
 171             $GLOBALS['PMA_Config']->loadUserPreferences();
 172             $userPreferences->redirect($return_url, $params);
 173             exit;
 174         } else {
 175             $error = $result;
 176         }
 177     }
 178 } elseif (isset($_POST['submit_clear'])) {
 179     $result = $userPreferences->save([]);
 180     if ($result === true) {
 181         $params = [];
 182         $GLOBALS['PMA_Config']->removeCookie('pma_collaction_connection');
 183         $GLOBALS['PMA_Config']->removeCookie('pma_lang');
 184         $userPreferences->redirect('prefs_manage.php', $params);
 185         exit;
 186     } else {
 187         $error = $result;
 188     }
 189     exit;
 190 }
 191
 192 $response = Response::getInstance();
 193 $header   = $response->getHeader();
 194 $scripts  = $header->getScripts();
 195 $scripts->addFile('config.js');
 196
 197 echo UserPreferencesHeader::getContent($template, $relation);
 198 if ($error) {
 199     if (! $error instanceof Message) {
 200         $error = Message::error($error);
 201     }
 202     $error->getDisplay();
 203 }
 204
 205 echo $template->render('preferences/manage/main', [
 206     'error' => $error,
 207     'max_upload_size' => $GLOBALS['max_upload_size'],
 208     'exists_setup_and_not_exists_config' => @file_exists(ROOT_PATH . 'setup/index.php') && ! @file_exists(CONFIG_FILE),
 209 ]);
 210
 211 if ($response->isAjax()) {
 212     $response->addJSON('disableNaviSettings', true);
 213 } else {
 214     define('PMA_DISABLE_NAVI_SETTINGS', true);
 215 }