2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * User preferences management page
10 * Gets some core libraries and displays a top message if required
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';
21 PMA_userprefsPageInit();
24 if (isset($_POST['submit_export'])
25 && filter_input(INPUT_POST
, 'export_type') == 'text_file'
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']);
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']);
40 } else if (isset($_POST['submit_import'])) {
41 // load from JSON file
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'])
48 // read JSON from uploaded file
49 $open_basedir = @ini_get
('open_basedir');
51 $import_file = $_FILES['import_file']['tmp_name'];
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"
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;
66 $json = file_get_contents($import_file);
67 if ($file_to_unlink) {
68 unlink($file_to_unlink);
71 // read from POST value (json)
72 $json = filter_input(INPUT_POST
, 'json');
75 // hide header message
76 $_SESSION['userprefs_autoload'] = true;
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');
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);
91 $cf = ConfigFile
::getInstance();
92 $new_config = $cf->getFlatDefaultConfig();
93 if (!empty($_POST['import_merge'])) {
94 $new_config = array_merge($new_config, $cf->getConfigArray());
96 $new_config = array_merge($new_config, $config);
98 foreach ($new_config as $k => $v) {
99 $_POST[str_replace('/', '-', $k)] = $v;
101 $cf->resetConfigData();
102 $all_ok = $form_display->process(true, false);
103 $all_ok = $all_ok && !$form_display->hasErrors();
106 if (!$all_ok && isset($_POST['fix_errors'])) {
107 $form_display->fixErrors();
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.')
117 echo '<div class="config-form">';
118 $form_display->displayErrors();
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" />';
129 echo '<input type="hidden" name="return_url" value="'
130 . htmlspecialchars($return_url) . '" />';
133 echo __('Do you want to import remaining settings?');
135 echo '<input type="submit" name="submit_import" value="'
136 . __('Yes') . '" />';
137 echo '<input type="submit" name="submit_ignore" value="'
143 // check for ThemeDefault and fontsize
145 if (isset($config['ThemeDefault'])
146 && $_SESSION['PMA_Theme_Manager']->theme
->getId() != $config['ThemeDefault']
147 && $_SESSION['PMA_Theme_Manager']->checkTheme($config['ThemeDefault'])
149 $_SESSION['PMA_Theme_Manager']->setActiveTheme($config['ThemeDefault']);
150 $_SESSION['PMA_Theme_Manager']->setThemeCookie();
152 if (isset($config['fontsize'])
153 && $config['fontsize'] != $GLOBALS['PMA_Config']->get('fontsize')
155 $params['set_fontsize'] = $config['fontsize'];
157 if (isset($config['lang'])
158 && $config['lang'] != $GLOBALS['lang']
160 $params['lang'] = $config['lang'];
162 if (isset($config['collation_connection'])
163 && $config['collation_connection'] != $GLOBALS['collation_connection']
165 $params['collation_connection'] = $config['collation_connection'];
169 $result = PMA_saveUserprefs($cf->getConfigArray());
170 if ($result === true) {
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);
180 $params[$k] = substr($q, $pos+
1);
183 $return_url = 'prefs_manage.php';
186 $GLOBALS['PMA_Config']->loadUserPreferences();
187 PMA_userprefsRedirect($return_url, $params);
193 } else if (isset($_POST['submit_clear'])) {
194 $result = PMA_saveUserprefs(array());
195 if ($result === true) {
197 if ($_SESSION['PMA_Theme_Manager']->theme
->getId() != 'original') {
198 $GLOBALS['PMA_Config']->removeCookie(
199 $_SESSION['PMA_Theme_Manager']->getThemeCookieName()
201 unset($_SESSION['PMA_Theme_Manager']);
202 unset($_SESSION['PMA_Theme']);
204 if ($GLOBALS['PMA_Config']->get('fontsize') != '82%') {
205 $GLOBALS['PMA_Config']->removeCookie('pma_fontsize');
207 $GLOBALS['PMA_Config']->removeCookie('pma_collaction_connection');
208 $GLOBALS['PMA_Config']->removeCookie('pma_lang');
209 PMA_userprefsRedirect('prefs_manage.php', $params);
217 $response = PMA_Response
::getInstance();
218 $header = $response->getHeader();
219 $scripts = $header->getScripts();
220 $scripts->addFile('config.js');
222 require 'libraries/user_preferences.inc.php';
224 if (!$error instanceof PMA_Message
) {
225 $error = PMA_Message
::error($error);
230 <script type
="text/javascript">
232 PMA_printJsValue("PMA_messages['strSavedOn']", __('Saved on: @DATE@'));
235 <div id
="maincontainer">
236 <div id
="main_pane_left">
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">
241 echo PMA_Util
::generateHiddenMaxFileSize($max_upload_size) . "\n";
242 echo PMA_URL_getHiddenInputs() . "\n";
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" />
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.') ?
>
257 <div
class="localStorage-exists">
258 <?php
echo __('Saved on: @DATE@') ?
>
260 <div
class="localStorage-empty">
261 <?php PMA_Message
::notice(__('You have no saved settings!'))->display() ?
>
264 <div
class="localStorage-unsupported">
265 <?php PMA_Message
::notice(__('This feature is not supported by your web browser'))->display() ?
>
269 <input type
="checkbox" id
="import_merge" name
="import_merge" />
270 <label
for="import_merge"><?php
echo __('Merge with current configuration') ?
></label
>
272 <input type
="submit" name
="submit_import" value
="<?php echo __('Go'); ?>" />
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
281 <h2
><?php
echo __('More settings') ?
></h2
>
282 <div
class="group-cnt">
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');
293 <div id
="main_pane_right">
295 <h2
><?php
echo __('Export') ?
></h2
>
296 <div
class="click-hide-message group-cnt" style
="display:none">
298 PMA_Message
::rawSuccess(__('Configuration has been saved'))->display();
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
>
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
>
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
>
317 <div
class="localStorage-unsupported">
318 <?php PMA_Message
::notice(__('This feature is not supported by your web browser'))->display() ?
>
322 <input type
="submit" name
="submit_export" value
="<?php echo __('Go'); ?>" />
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.')
333 . '<input type="submit" name="submit_clear" value="'
334 . __('Reset') . '" />'
339 <br
class="clearfloat" />