phpmyadmin/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
   9 /**
  10  * Gets some core libraries and displays a top message if required
  11  */
  12 require_once 'libraries/common.inc.php';
  13 require_once 'libraries/user_preferences.lib.php';
  14 require_once 'libraries/config/config_functions.lib.php';
  15 require_once 'libraries/config/messages.inc.php';
  16 require_once 'libraries/config/ConfigFile.class.php';
  17 require_once 'libraries/config/Form.class.php';
  18 require_once 'libraries/config/FormDisplay.class.php';
  19 require 'libraries/config/user_preferences.forms.php';
  20
  21 $cf = new ConfigFile($GLOBALS['PMA_Config']->base_settings);
  22 PMA_userprefsPageInit($cf);
  23
  24 $error = '';
  25 if (isset($_POST['submit_export'])
  26     && filter_input(INPUT_POST, 'export_type') == 'text_file'
  27 ) {
  28     // export to JSON file
  29     PMA_Response::getInstance()->disable();
  30     $filename = 'phpMyAdmin-config-' . urlencode(PMA_getenv('HTTP_HOST')) . '.json';
  31     PMA_downloadHeader($filename, 'application/json');
  32     $settings = PMA_loadUserprefs();
  33     echo json_encode($settings['config_data']);
  34     exit;
  35 } else if (isset($_POST['submit_get_json'])) {
  36     $settings = PMA_loadUserprefs();
  37     $response = PMA_Response::getInstance();
  38     $response->addJSON('prefs', json_encode($settings['config_data']));
  39     $response->addJSON('mtime', $settings['mtime']);
  40     exit;
  41 } else if (isset($_POST['submit_import'])) {
  42     // load from JSON file
  43     $json = '';
  44     if (filter_input(INPUT_POST, 'import_type') == 'text_file'
  45         && isset($_FILES['import_file'])
  46         && $_FILES['import_file']['error'] == UPLOAD_ERR_OK
  47         && is_uploaded_file($_FILES['import_file']['tmp_name'])
  48     ) {
  49         // read JSON from uploaded file
  50         $open_basedir = @ini_get('open_basedir');
  51         $file_to_unlink = '';
  52         $import_file = $_FILES['import_file']['tmp_name'];
  53
  54         // If we are on a server with open_basedir, we must move the file
  55         // before opening it. The doc explains how to create the "./tmp"
  56         // directory
  57         if (!empty($open_basedir)) {
  58             $tmp_subdir = (PMA_IS_WINDOWS ? '.\\tmp\\' : 'tmp/');
  59             if (is_writable($tmp_subdir)) {
  60                 $import_file_new = tempnam($tmp_subdir, 'prefs');
  61                 if (move_uploaded_file($import_file, $import_file_new)) {
  62                     $import_file = $import_file_new;
  63                     $file_to_unlink = $import_file_new;
  64                 }
  65             }
  66         }
  67         $json = file_get_contents($import_file);
  68         if ($file_to_unlink) {
  69             unlink($file_to_unlink);
  70         }
  71     } else {
  72         // read from POST value (json)
  73         $json = filter_input(INPUT_POST, 'json');
  74     }
  75
  76     // hide header message
  77     $_SESSION['userprefs_autoload'] = true;
  78
  79     $config = json_decode($json, true);
  80     $return_url = filter_input(INPUT_POST, 'return_url');
  81     if (! is_array($config)) {
  82         $error = __('Could not import configuration');
  83     } else {
  84         // sanitize input values: treat them as though
  85         // they came from HTTP POST request
  86         $form_display = new FormDisplay($cf);
  87         foreach ($forms as $formset_id => $formset) {
  88             foreach ($formset as $form_name => $form) {
  89                 $form_display->registerForm($formset_id . ': ' . $form_name, $form);
  90             }
  91         }
  92         $new_config = $cf->getFlatDefaultConfig();
  93         if (!empty($_POST['import_merge'])) {
  94             $new_config = array_merge($new_config, $cf->getConfigArray());
  95         }
  96         $new_config = array_merge($new_config, $config);
  97         $_POST_bak = $_POST;
  98         foreach ($new_config as $k => $v) {
  99             $_POST[str_replace('/', '-', $k)] = $v;
 100         }
 101         $cf->resetConfigData();
 102         $all_ok = $form_display->process(true, false);
 103         $all_ok = $all_ok && !$form_display->hasErrors();
 104         $_POST = $_POST_bak;
 105
 106         if (!$all_ok && isset($_POST['fix_errors'])) {
 107             $form_display->fixErrors();
 108             $all_ok = true;
 109         }
 110         if (!$all_ok) {
 111             // mimic original form and post json in a hidden field
 112             include 'libraries/user_preferences.inc.php';
 113             $msg = PMA_Message::error(
 114                 __('Configuration contains incorrect data for some fields.')
 115             );
 116             $msg->display();
 117             echo '<div class="config-form">';
 118             $form_display->displayErrors();
 119             echo '</div>';
 120             echo '<form action="prefs_manage.php" method="post">';
 121             echo PMA_URL_getHiddenInputs() . "\n";
 122             echo '<input type="hidden" name="json" value="'
 123                 . htmlspecialchars($json) . '" />';
 124             echo '<input type="hidden" name="fix_errors" value="1" />';
 125             if (! empty($_POST['import_merge'])) {
 126                 echo '<input type="hidden" name="import_merge" value="1" />';
 127             }
 128             if ($return_url) {
 129                 echo '<input type="hidden" name="return_url" value="'
 130                     . htmlspecialchars($return_url) . '" />';
 131             }
 132             echo '<p>';
 133             echo __('Do you want to import remaining settings?');
 134             echo '</p>';
 135             echo '<input type="submit" name="submit_import" value="'
 136                 . __('Yes') . '" />';
 137             echo '<input type="submit" name="submit_ignore" value="'
 138                 . __('No') . '" />';
 139             echo '</form>';
 140             exit;
 141         }
 142
 143         // check for ThemeDefault and fontsize
 144         $params = array();
 145         if (isset($config['ThemeDefault'])
 146             && $_SESSION['PMA_Theme_Manager']->theme->getId() != $config['ThemeDefault']
 147             && $_SESSION['PMA_Theme_Manager']->checkTheme($config['ThemeDefault'])
 148         ) {
 149             $_SESSION['PMA_Theme_Manager']->setActiveTheme($config['ThemeDefault']);
 150             $_SESSION['PMA_Theme_Manager']->setThemeCookie();
 151         }
 152         if (isset($config['fontsize'])
 153             && $config['fontsize'] != $GLOBALS['PMA_Config']->get('fontsize')
 154         ) {
 155             $params['set_fontsize'] = $config['fontsize'];
 156         }
 157         if (isset($config['lang'])
 158             && $config['lang'] != $GLOBALS['lang']
 159         ) {
 160             $params['lang'] = $config['lang'];
 161         }
 162         if (isset($config['collation_connection'])
 163             && $config['collation_connection'] != $GLOBALS['collation_connection']
 164         ) {
 165             $params['collation_connection'] = $config['collation_connection'];
 166         }
 167
 168         // save settings
 169         $result = PMA_saveUserprefs($cf->getConfigArray());
 170         if ($result === true) {
 171             if ($return_url) {
 172                 $query = explode('&', parse_url($return_url, PHP_URL_QUERY));
 173                 $return_url = parse_url($return_url, PHP_URL_PATH);
 174                 foreach ($query as $q) {
 175                     $pos = strpos($q, '=');
 176                     $k = substr($q, 0, $pos);
 177                     if ($k == 'token') {
 178                         continue;
 179                     }
 180                     $params[$k] = substr($q, $pos+1);
 181                 }
 182             } else {
 183                 $return_url = 'prefs_manage.php';
 184             }
 185             // reload config
 186             $GLOBALS['PMA_Config']->loadUserPreferences();
 187             PMA_userprefsRedirect($return_url, $params);
 188             exit;
 189         } else {
 190             $error = $result;
 191         }
 192     }
 193 } else if (isset($_POST['submit_clear'])) {
 194     $result = PMA_saveUserprefs(array());
 195     if ($result === true) {
 196         $params = array();
 197         if ($GLOBALS['PMA_Config']->get('fontsize') != '82%') {
 198             $GLOBALS['PMA_Config']->removeCookie('pma_fontsize');
 199         }
 200         $GLOBALS['PMA_Config']->removeCookie('pma_collaction_connection');
 201         $GLOBALS['PMA_Config']->removeCookie('pma_lang');
 202         PMA_userprefsRedirect('prefs_manage.php', $params);
 203         exit;
 204     } else {
 205         $error = $result;
 206     }
 207     exit;
 208 }
 209
 210 $response = PMA_Response::getInstance();
 211 $header   = $response->getHeader();
 212 $scripts = $header->getScripts();
 213 $scripts->addFile('config.js');
 214
 215 require 'libraries/user_preferences.inc.php';
 216 if ($error) {
 217     if (!$error instanceof PMA_Message) {
 218         $error = PMA_Message::error($error);
 219     }
 220     $error->display();
 221 }
 222 ?>
 223 <script type="text/javascript">
 224 <?php
 225 PMA_printJsValue("PMA_messages['strSavedOn']", __('Saved on: @DATE@'));
 226 ?>
 227 </script>
 228 <div id="maincontainer">
 229     <div id="main_pane_left">
 230         <div class="group">
 231 <?php
 232 echo '<h2>' . __('Import') . '</h2>'
 233     . '<form class="group-cnt prefs-form disableAjax" name="prefs_import"'
 234     . ' action="prefs_manage.php" method="post" enctype="multipart/form-data">'
 235     . PMA_Util::generateHiddenMaxFileSize($GLOBALS['max_upload_size'])
 236     . PMA_URL_getHiddenInputs()
 237     . '<input type="hidden" name="json" value="" />'
 238     . '<input type="radio" id="import_text_file" name="import_type"'
 239     . ' value="text_file" checked="checked" />'
 240     . '<label for="import_text_file">' . __('Import from file') . '</label>'
 241     . '<div id="opts_import_text_file" class="prefsmanage_opts">'
 242     . '<label for="input_import_file">' . __('Browse your computer:') . '</label>'
 243     . '<input type="file" name="import_file" id="input_import_file" />'
 244     . '</div>'
 245     . '<input type="radio" id="import_local_storage" name="import_type"'
 246     . ' value="local_storage" disabled="disabled" />'
 247     . '<label for="import_local_storage">'
 248     . __('Import from browser\'s storage') . '</label>'
 249     . '<div id="opts_import_local_storage" class="prefsmanage_opts disabled">'
 250     . '<div class="localStorage-supported">'
 251     . __('Settings will be imported from your browser\'s local storage.')
 252     . '<br />'
 253     . '<div class="localStorage-exists">'
 254     . __('Saved on: @DATE@')
 255     . '</div>'
 256     . '<div class="localStorage-empty">';
 257 PMA_Message::notice(__('You have no saved settings!'))->display();
 258 echo  '</div>'
 259     . '</div>'
 260     . '<div class="localStorage-unsupported">';
 261 PMA_Message::notice(
 262     __('This feature is not supported by your web browser')
 263 )->display();
 264 echo '</div>'
 265     . '</div>'
 266     . '<input type="checkbox" id="import_merge" name="import_merge" />'
 267     . '<label for="import_merge">'
 268     . __('Merge with current configuration') . '</label>'
 269     . '<br /><br />'
 270     . '<input type="submit" name="submit_import" value="'
 271     . __('Go') . '" />'
 272     . '</form>'
 273     . '</div>';
 274 if (file_exists('setup/index.php')) {
 275             // show only if setup script is available, allows to disable this message
 276             // by simply removing setup directory
 277             ?>
 278             <div class="group">
 279             <h2><?php echo __('More settings') ?></h2>
 280             <div class="group-cnt">
 281                 <?php
 282                 echo sprintf(__('You can set more settings by modifying config.inc.php, eg. by using %sSetup script%s.'), '<a href="setup/index.php" target="_blank">', '</a>');
 283                 echo PMA_Util::showDocu('setup', 'setup-script');
 284                 ?>
 285             </div>
 286             </div>
 287         <?php
 288 }
 289         ?>
 290     </div>
 291     <div id="main_pane_right">
 292         <div class="group">
 293             <h2><?php echo __('Export') ?></h2>
 294             <div class="click-hide-message group-cnt" style="display:none">
 295                 <?php
 296 PMA_Message::rawSuccess(
 297     __('Configuration has been saved.')
 298 )->display();
 299 echo '</div>'
 300     . '<form class="group-cnt prefs-form disableAjax" name="prefs_export"'
 301     . ' action="prefs_manage.php" method="post">'
 302     . PMA_URL_getHiddenInputs()
 303     . '<div style="padding-bottom:0.5em">'
 304     . '<input type="radio" id="export_text_file" name="export_type"'
 305     . ' value="text_file" checked="checked" />'
 306     . '<label for="export_text_file">' . __('Save as file') . '</label>'
 307     . '<br />'
 308     . '<input type="radio" id="export_local_storage" name="export_type"'
 309     . ' value="local_storage" disabled="disabled" />'
 310     . '<label for="export_local_storage">'
 311     .  __('Save to browser\'s storage') . '</label>'
 312     . '</div>'
 313     . '<div id="opts_export_local_storage" class="prefsmanage_opts disabled">'
 314     . '<span class="localStorage-supported">'
 315     . __('Settings will be saved in your browser\'s local storage.')
 316     . '<div class="localStorage-exists">'
 317     . '<b>' . __('Existing settings will be overwritten!') . '</b>'
 318     . '</div>'
 319     . '</span>'
 320     . '<div class="localStorage-unsupported">';
 321 PMA_Message::notice(
 322     __('This feature is not supported by your web browser')
 323 )->display();
 324 ?>
 325                     </div>
 326                 </div>
 327                 <br />
 328 <?php
 329 echo '<input type="submit" name="submit_export" value="' . __('Go') . '" />';
 330 ?>
 331             </form>
 332         </div>
 333         <div class="group">
 334 <?php
 335 echo '<h2>' . __('Reset') . '</h2>'
 336     . '<form class="group-cnt prefs-form disableAjax" name="prefs_reset"'
 337     . ' action="prefs_manage.php" method="post">'
 338     . PMA_URL_getHiddenInputs()
 339     . __('You can reset all your settings and restore them to default values.')
 340     . '<br /><br />'
 341     . '<input type="submit" name="submit_clear" value="'
 342     . __('Reset') . '" />'
 343     . '</form>';
 344 ?>
 345         </div>
 346     </div>
 347     <br class="clearfloat" />
 348 </div>