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 PMA_userprefsPageInit();
  22
  23 $error = '';
  24 if (isset($_POST['submit_export'])
  25     && filter_input(INPUT_POST, 'export_type') == 'text_file'
  26 ) {
  27     // export to JSON file
  28     PMA_Response::getInstance()->disable();
  29     $filename = 'phpMyAdmin-config-' . urlencode(PMA_getenv('HTTP_HOST')) . '.json';
  30     PMA_downloadHeader($filename, 'application/json');
  31     $settings = PMA_loadUserprefs();
  32     echo json_encode($settings['config_data']);
  33     exit;
  34 } else if (isset($_POST['submit_get_json'])) {
  35     $settings = PMA_loadUserprefs();
  36     $response = PMA_Response::getInstance();
  37     $response->addJSON('prefs', json_encode($settings['config_data']));
  38     $response->addJSON('mtime', $settings['mtime']);
  39     exit;
  40 } else if (isset($_POST['submit_import'])) {
  41     // load from JSON file
  42     $json = '';
  43     if (filter_input(INPUT_POST, 'import_type') == 'text_file'
  44         && isset($_FILES['import_file'])
  45         && $_FILES['import_file']['error'] == UPLOAD_ERR_OK
  46         && is_uploaded_file($_FILES['import_file']['tmp_name'])
  47     ) {
  48         // read JSON from uploaded file
  49         $open_basedir = @ini_get('open_basedir');
  50         $file_to_unlink = '';
  51         $import_file = $_FILES['import_file']['tmp_name'];
  52
  53         // If we are on a server with open_basedir, we must move the file
  54         // before opening it. The doc explains how to create the "./tmp"
  55         // directory
  56         if (!empty($open_basedir)) {
  57             $tmp_subdir = (PMA_IS_WINDOWS ? '.\\tmp\\' : 'tmp/');
  58             if (is_writable($tmp_subdir)) {
  59                 $import_file_new = tempnam($tmp_subdir, 'prefs');
  60                 if (move_uploaded_file($import_file, $import_file_new)) {
  61                     $import_file = $import_file_new;
  62                     $file_to_unlink = $import_file_new;
  63                 }
  64             }
  65         }
  66         $json = file_get_contents($import_file);
  67         if ($file_to_unlink) {
  68             unlink($file_to_unlink);
  69         }
  70     } else {
  71         // read from POST value (json)
  72         $json = filter_input(INPUT_POST, 'json');
  73     }
  74
  75     // hide header message
  76     $_SESSION['userprefs_autoload'] = true;
  77
  78     $config = json_decode($json, true);
  79     $return_url = filter_input(INPUT_POST, 'return_url');
  80     if (! is_array($config)) {
  81         $error = __('Could not import configuration');
  82     } else {
  83         // sanitize input values: treat them as though
  84         // they came from HTTP POST request
  85         $form_display = new FormDisplay();
  86         foreach ($forms as $formset_id => $formset) {
  87             foreach ($formset as $form_name => $form) {
  88                 $form_display->registerForm($formset_id . ': ' . $form_name, $form);
  89             }
  90         }
  91         $cf = ConfigFile::getInstance();
  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 ($_SESSION['PMA_Theme_Manager']->theme->getId() != 'original') {
 198             $GLOBALS['PMA_Config']->removeCookie(
 199                 $_SESSION['PMA_Theme_Manager']->getThemeCookieName()
 200             );
 201             unset($_SESSION['PMA_Theme_Manager']);
 202             unset($_SESSION['PMA_Theme']);
 203         }
 204         if ($GLOBALS['PMA_Config']->get('fontsize') != '82%') {
 205             $GLOBALS['PMA_Config']->removeCookie('pma_fontsize');
 206         }
 207         $GLOBALS['PMA_Config']->removeCookie('pma_collaction_connection');
 208         $GLOBALS['PMA_Config']->removeCookie('pma_lang');
 209         PMA_userprefsRedirect('prefs_manage.php', $params);
 210         exit;
 211     } else {
 212         $error = $result;
 213     }
 214     exit;
 215 }
 216
 217 $response = PMA_Response::getInstance();
 218 $header   = $response->getHeader();
 219 $scripts = $header->getScripts();
 220 $scripts->addFile('config.js');
 221
 222 require 'libraries/user_preferences.inc.php';
 223 if ($error) {
 224     if (!$error instanceof PMA_Message) {
 225         $error = PMA_Message::error($error);
 226     }
 227     $error->display();
 228 }
 229 ?>
 230 <script type="text/javascript">
 231 <?php
 232 PMA_printJsValue("PMA_messages['strSavedOn']", __('Saved on: @DATE@'));
 233 ?>
 234 </script>
 235 <div id="maincontainer">
 236     <div id="main_pane_left">
 237         <div class="group">
 238             <h2><?php echo __('Import') ?></h2>
 239             <form class="group-cnt prefs-form disableAjax" name="prefs_import" action="prefs_manage.php" method="post" enctype="multipart/form-data">
 240                 <?php
 241                 echo PMA_Util::generateHiddenMaxFileSize($max_upload_size) . "\n";
 242                 echo PMA_URL_getHiddenInputs() . "\n";
 243                 ?>
 244                 <input type="hidden" name="json" value="" />
 245                 <input type="radio" id="import_text_file" name="import_type" value="text_file" checked="checked" />
 246                 <label for="import_text_file"><?php echo __('Import from file') ?></label>
 247                 <div id="opts_import_text_file" class="prefsmanage_opts">
 248                     <label for="input_import_file"><?php echo __('Browse your computer:'); ?></label>
 249                     <input type="file" name="import_file" id="input_import_file" />
 250                 </div>
 251                 <input type="radio" id="import_local_storage" name="import_type" value="local_storage" disabled="disabled" />
 252                 <label for="import_local_storage"><?php echo __('Import from browser\'s storage') ?></label>
 253                 <div id="opts_import_local_storage" class="prefsmanage_opts disabled">
 254                     <div class="localStorage-supported">
 255                         <?php echo __('Settings will be imported from your browser\'s local storage.') ?>
 256                         <br />
 257                         <div class="localStorage-exists">
 258                             <?php echo __('Saved on: @DATE@') ?>
 259                         </div>
 260                         <div class="localStorage-empty">
 261                             <?php  PMA_Message::notice(__('You have no saved settings!'))->display() ?>
 262                         </div>
 263                     </div>
 264                     <div class="localStorage-unsupported">
 265                         <?php PMA_Message::notice(__('This feature is not supported by your web browser'))->display() ?>
 266                     </div>
 267                 </div>
 268
 269                 <input type="checkbox" id="import_merge" name="import_merge" />
 270                 <label for="import_merge"><?php echo __('Merge with current configuration') ?></label>
 271                 <br /><br />
 272                 <input type="submit" name="submit_import" value="<?php echo __('Go'); ?>" />
 273             </form>
 274         </div>
 275         <?php
 276         if (file_exists('setup/index.php')) {
 277             // show only if setup script is available, allows to disable this message
 278             // by simply removing setup directory
 279         ?>
 280         <div class="group">
 281             <h2><?php echo __('More settings') ?></h2>
 282             <div class="group-cnt">
 283                 <?php
 284                 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>');
 285                 echo PMA_Util::showDocu('setup', 'setup-script');
 286                 ?>
 287             </div>
 288         </div>
 289         <?php
 290         }
 291         ?>
 292     </div>
 293     <div id="main_pane_right">
 294         <div class="group">
 295             <h2><?php echo __('Export') ?></h2>
 296             <div class="click-hide-message group-cnt" style="display:none">
 297                 <?php
 298                 PMA_Message::rawSuccess(__('Configuration has been saved'))->display();
 299                 ?>
 300             </div>
 301             <form class="group-cnt prefs-form disableAjax" name="prefs_export" action="prefs_manage.php" method="post">
 302             <?php echo PMA_URL_getHiddenInputs() . "\n" ?>
 303                 <div style="padding-bottom:0.5em">
 304                     <input type="radio" id="export_text_file" name="export_type" value="text_file" checked="checked" />
 305                     <label for="export_text_file"><?php echo __('Save as file') ?></label>
 306                     <br />
 307                     <input type="radio" id="export_local_storage" name="export_type" value="local_storage" disabled="disabled" />
 308                     <label for="export_local_storage"><?php echo __('Save to browser\'s storage') ?></label>
 309                 </div>
 310                 <div id="opts_export_local_storage" class="prefsmanage_opts disabled">
 311                     <span class="localStorage-supported">
 312                         <?php echo __('Settings will be saved in your browser\'s local storage.') ?>
 313                         <span class="localStorage-exists">
 314                             <br /><b><?php echo __('Existing settings will be overwritten!') ?></b>
 315                         </span>
 316                     </span>
 317                     <div class="localStorage-unsupported">
 318                         <?php PMA_Message::notice(__('This feature is not supported by your web browser'))->display() ?>
 319                     </div>
 320                 </div>
 321                 <br />
 322                 <input type="submit" name="submit_export" value="<?php echo __('Go'); ?>" />
 323             </form>
 324         </div>
 325         <div class="group">
 326 <?php
 327 echo '<h2>' . __('Reset') . '</h2>'
 328     . '<form class="group-cnt prefs-form disableAjax" name="prefs_reset"'
 329     . ' action="prefs_manage.php" method="post">'
 330     . PMA_URL_getHiddenInputs()
 331     . __('You can reset all your settings and restore them to default values.')
 332     . '<br /><br />'
 333     . '<input type="submit" name="submit_clear" value="'
 334     . __('Reset') . '" />'
 335     . '</form>';
 336 ?>
 337         </div>
 338     </div>
 339     <br class="clearfloat" />
 340 </div>