Gecko [ 167.86.127.34 ]

Name	Size	Permission
bfShapeFiles	[ DIR ]	drwxr-xr-x
config	[ DIR ]	drwxr-xr-x
controllers	[ DIR ]	drwxr-xr-x
dbi	[ DIR ]	drwxr-xr-x
di	[ DIR ]	drwxr-xr-x
engines	[ DIR ]	drwxr-xr-x
gis	[ DIR ]	drwxr-xr-x
navigation	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
properties	[ DIR ]	drwxr-xr-x
rte	[ DIR ]	drwxr-xr-x
sql-parser	[ DIR ]	drwxr-xr-x
Advisor.php	15.13 KB	-rw-r--r--
Config.php	54.7 KB	-rw-r--r--
Console.php	14.82 KB	-rw-r--r--
DatabaseInterface.php	95.6 KB	-rw-r--r--
DbList.php	1.9 KB	-rw-r--r--
DbQbe.php	68.87 KB	-rw-r--r--
DbSearch.php	17.21 KB	-rw-r--r--
DisplayResults.php	206 KB	-rw-r--r--
Error.php	12.7 KB	-rw-r--r--
ErrorHandler.php	16.48 KB	-rw-r--r--
File.php	18.82 KB	-rw-r--r--
Font.php	4.24 KB	-rw-r--r--
Footer.php	10.52 KB	-rw-r--r--
Header.php	25.34 KB	-rw-r--r--
Index.php	23.79 KB	-rw-r--r--
IndexColumn.php	4.46 KB	-rw-r--r--
Language.php	4.27 KB	-rw-r--r--
LanguageManager.php	20.75 KB	-rw-r--r--
Linter.php	5.02 KB	-rw-r--r--
ListAbstract.php	3.15 KB	-rw-r--r--
ListDatabase.php	4.62 KB	-rw-r--r--
Menu.php	21.14 KB	-rw-r--r--
Message.php	18.67 KB	-rw-r--r--
OutputBuffering.php	3.59 KB	-rw-r--r--
PDF.php	3.94 KB	-rw-r--r--
Partition.php	7.26 KB	-rw-r--r--
Psr4Autoloader.php	4.85 KB	-rw-r--r--
RecentFavoriteTable.php	11.78 KB	-rw-r--r--
Response.php	12.61 KB	-rw-r--r--
SavedSearches.php	11.67 KB	-rw-r--r--
Scripts.php	7.38 KB	-rw-r--r--
ServerStatusData.php	15.72 KB	-rw-r--r--
StorageEngine.php	13.61 KB	-rw-r--r--
SubPartition.php	3.52 KB	-rw-r--r--
SysInfo.php	799 B	-rw-r--r--
SysInfoLinux.php	1.92 KB	-rw-r--r--
SysInfoSunOS.php	1.86 KB	-rw-r--r--
SysInfoWINNT.php	3.08 KB	-rw-r--r--
SystemDatabase.php	3.66 KB	-rw-r--r--
Table.php	88.12 KB	-rw-r--r--
Template.php	4.45 KB	-rw-r--r--
Theme.php	11.34 KB	-rw-r--r--
ThemeManager.php	12.91 KB	-rw-r--r--
Tracker.php	30.35 KB	-rw-r--r--
Types.php	6.08 KB	-rw-r--r--
TypesMySQL.php	17.26 KB	-rw-r--r--
Util.php	172.46 KB	-rw-r--r--
VersionInformation.php	7.87 KB	-rw-r--r--
ZipFile.php	6.63 KB	-rw-r--r--
advisor.lib.php	1.6 KB	-rw-r--r--
advisory_rules.txt	25.94 KB	-rw-r--r--
autoloader.php	450 B	-rw-r--r--
bookmark.lib.php	8.5 KB	-rw-r--r--
browse_foreigners.lib.php	9.83 KB	-rw-r--r--
central_columns.lib.php	49.38 KB	-rw-r--r--
charset_conversion.lib.php	3.54 KB	-rw-r--r--
check_user_privileges.lib.php	10.65 KB	-rw-r--r--
cleanup.lib.php	1.29 KB	-rw-r--r--
common.inc.php	34.38 KB	-rw-r--r--
config.default.php	66.5 KB	-rw-r--r--
config.values.php	10.17 KB	-rw-r--r--
core.lib.php	29.94 KB	-rw-r--r--
create_addfield.lib.php	15.68 KB	-rw-r--r--
database_interface.inc.php	2.63 KB	-rw-r--r--
db_common.inc.php	3.12 KB	-rw-r--r--
db_designer.lib.php	10.4 KB	-rw-r--r--
db_table_exists.lib.php	3.21 KB	-rw-r--r--
display_change_password.lib.ph...	5.45 KB	-rw-r--r--
display_create_table.lib.php	1.53 KB	-rw-r--r--
display_export.lib.php	38.11 KB	-rw-r--r--
display_git_revision.lib.php	3.04 KB	-rw-r--r--
display_import.lib.php	24.34 KB	-rw-r--r--
display_import_ajax.lib.php	3.13 KB	-rw-r--r--
display_select_lang.lib.php	2.36 KB	-rw-r--r--
error.inc.php	1.21 KB	-rw-r--r--
error_report.lib.php	10.25 KB	-rw-r--r--
export.lib.php	35.16 KB	-rw-r--r--
file_listing.lib.php	2.37 KB	-rw-r--r--
iconv_wrapper.lib.php	3.88 KB	-rw-r--r--
import.lib.php	50.64 KB	-rw-r--r--
index.lib.php	1.37 KB	-rw-r--r--
information_schema_relations.l...	10.95 KB	-rw-r--r--
insert_edit.lib.php	112.79 KB	-rw-r--r--
ip_allow_deny.lib.php	9.35 KB	-rw-r--r--
js_escape.lib.php	4.43 KB	-rw-r--r--
kanji-encoding.lib.php	4.46 KB	-rw-r--r--
language_stats.inc.php	1.45 KB	-rw-r--r--
logging.lib.php	521 B	-rw-r--r--
mime.lib.php	704 B	-rw-r--r--
mult_submits.inc.php	10.64 KB	-rw-r--r--
mult_submits.lib.php	20.44 KB	-rw-r--r--
mysql_charsets.inc.php	4.09 KB	-rw-r--r--
mysql_charsets.lib.php	10.47 KB	-rw-r--r--
mysql_relations.lib.php	5.12 KB	-rw-r--r--
normalization.lib.php	33.98 KB	-rw-r--r--
opendocument.lib.php	7.94 KB	-rw-r--r--
operations.lib.php	73.64 KB	-rw-r--r--
parse_analyze.lib.php	2.12 KB	-rw-r--r--
plugin_interface.lib.php	19.69 KB	-rw-r--r--
pmd_common.php	24.2 KB	-rw-r--r--
relation.lib.php	68.41 KB	-rw-r--r--
relation_cleanup.lib.php	13.84 KB	-rw-r--r--
replication.inc.php	8.82 KB	-rw-r--r--
replication_gui.lib.php	37.45 KB	-rw-r--r--
sanitizing.lib.php	6.3 KB	-rw-r--r--
select_server.lib.php	3.4 KB	-rw-r--r--
server_common.inc.php	1.22 KB	-rw-r--r--
server_common.lib.php	1.92 KB	-rw-r--r--
server_privileges.lib.php	179.22 KB	-rw-r--r--
server_status.lib.php	9.92 KB	-rw-r--r--
server_status_advisor.lib.php	1.89 KB	-rw-r--r--
server_status_monitor.lib.php	26.22 KB	-rw-r--r--
server_status_processes.lib.ph...	9.57 KB	-rw-r--r--
server_status_queries.lib.php	4.86 KB	-rw-r--r--
server_status_variables.lib.ph...	28.95 KB	-rw-r--r--
server_user_groups.lib.php	12.8 KB	-rw-r--r--
server_users.lib.php	1.35 KB	-rw-r--r--
session.inc.php	5.22 KB	-rw-r--r--
session.lib.php	735 B	-rw-r--r--
special_schema_links.lib.php	17.51 KB	-rw-r--r--
sql.lib.php	77.51 KB	-rw-r--r--
sql_query_form.lib.php	15.71 KB	-rw-r--r--
string.lib.php	800 B	-rw-r--r--
stringMb.lib.php	1.86 KB	-rw-r--r--
stringNative.lib.php	6.82 KB	-rw-r--r--
sysinfo.lib.php	1.34 KB	-rw-r--r--
tbl_columns_definition_form.in...	13.55 KB	-rw-r--r--
tbl_common.inc.php	1.3 KB	-rw-r--r--
tbl_info.inc.php	3.54 KB	-rw-r--r--
tbl_partition_definition.inc.p...	5.55 KB	-rw-r--r--
tracking.lib.php	54.93 KB	-rw-r--r--
transformations.lib.php	14.63 KB	-rw-r--r--
url_generating.lib.php	6.77 KB	-rw-r--r--
user_preferences.inc.php	2.38 KB	-rw-r--r--
user_preferences.lib.php	8.17 KB	-rw-r--r--
util.lib.php	749 B	-rw-r--r--
vendor_config.php	2.49 KB	-rw-r--r--
zip_extension.lib.php	5.38 KB	-rw-r--r--

Code Editor : user_preferences.lib.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Functions for displaying user preferences pages
 *
 * @package PhpMyAdmin
 */
use PMA\libraries\config\ConfigFile;
use PMA\libraries\Message;

if (! defined('PHPMYADMIN')) {
    exit;
}

/**
 * Common initialization for user preferences modification pages
 *
 * @param ConfigFile $cf Config file instance
 *
 * @return void
 */
function PMA_userprefsPageInit(ConfigFile $cf)
{
    $forms_all_keys = PMA_readUserprefsFieldNames($GLOBALS['forms']);
    $cf->resetConfigData(); // start with a clean instance
    $cf->setAllowedKeys($forms_all_keys);
    $cf->setCfgUpdateReadMapping(
        array(
            'Server/hide_db' => 'Servers/1/hide_db',
            'Server/only_db' => 'Servers/1/only_db'
        )
    );
    $cf->updateWithGlobalConfig($GLOBALS['cfg']);
}

/**
 * Loads user preferences
 *
 * Returns an array:
 * * config_data - path => value pairs
 * * mtime - last modification time
 * * type - 'db' (config read from pmadb) or 'session' (read from user session)
 *
 * @return array
 */
function PMA_loadUserprefs()
{
    $cfgRelation = PMA_getRelationsParam();
    if (! $cfgRelation['userconfigwork']) {
        // no pmadb table, use session storage
        if (! isset($_SESSION['userconfig'])) {
            $_SESSION['userconfig'] = array(
                'db' => array(),
                'ts' => time());
        }
        return array(
            'config_data' => $_SESSION['userconfig']['db'],
            'mtime' => $_SESSION['userconfig']['ts'],
            'type' => 'session');
    }
    // load configuration from pmadb
    $query_table = PMA\libraries\Util::backquote($cfgRelation['db']) . '.'
        . PMA\libraries\Util::backquote($cfgRelation['userconfig']);
    $query = 'SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts'
        . ' FROM ' . $query_table
        . ' WHERE `username` = \''
        . $GLOBALS['dbi']->escapeString($cfgRelation['user'])
        . '\'';
    $row = $GLOBALS['dbi']->fetchSingleRow($query, 'ASSOC', $GLOBALS['controllink']);

return array(
        'config_data' => $row ? (array)json_decode($row['config_data']) : array(),
        'mtime' => $row ? $row['ts'] : time(),
        'type' => 'db');
}

/**
 * Saves user preferences
 *
 * @param array $config_array configuration array
 *
 * @return true|PMA\libraries\Message
 */
function PMA_saveUserprefs(array $config_array)
{
    $cfgRelation = PMA_getRelationsParam();
    $server = isset($GLOBALS['server'])
        ? $GLOBALS['server']
        : $GLOBALS['cfg']['ServerDefault'];
    $cache_key = 'server_' . $server;
    if (! $cfgRelation['userconfigwork']) {
        // no pmadb table, use session storage
        $_SESSION['userconfig'] = array(
            'db' => $config_array,
            'ts' => time());
        if (isset($_SESSION['cache'][$cache_key]['userprefs'])) {
            unset($_SESSION['cache'][$cache_key]['userprefs']);
        }
        return true;
    }

// save configuration to pmadb
    $query_table = PMA\libraries\Util::backquote($cfgRelation['db']) . '.'
        . PMA\libraries\Util::backquote($cfgRelation['userconfig']);
    $query = 'SELECT `username` FROM ' . $query_table
        . ' WHERE `username` = \''
        . $GLOBALS['dbi']->escapeString($cfgRelation['user'])
        . '\'';

$has_config = $GLOBALS['dbi']->fetchValue(
        $query, 0, 0, $GLOBALS['controllink']
    );
    $config_data = json_encode($config_array);
    if ($has_config) {
        $query = 'UPDATE ' . $query_table
            . ' SET `timevalue` = NOW(), `config_data` = \''
            . $GLOBALS['dbi']->escapeString($config_data)
            . '\''
            . ' WHERE `username` = \''
            . $GLOBALS['dbi']->escapeString($cfgRelation['user'])
            . '\'';
    } else {
        $query = 'INSERT INTO ' . $query_table
            . ' (`username`, `timevalue`,`config_data`) '
            . 'VALUES (\''
            . $GLOBALS['dbi']->escapeString($cfgRelation['user']) . '\', NOW(), '
            . '\'' . $GLOBALS['dbi']->escapeString($config_data) . '\')';
    }
    if (isset($_SESSION['cache'][$cache_key]['userprefs'])) {
        unset($_SESSION['cache'][$cache_key]['userprefs']);
    }
    if (!$GLOBALS['dbi']->tryQuery($query, $GLOBALS['controllink'])) {
        $message = Message::error(__('Could not save configuration'));
        $message->addMessage('<br /><br />');
        $message->addMessage(
            Message::rawError(
                $GLOBALS['dbi']->getError($GLOBALS['controllink'])
            )
        );
        return $message;
    }
    return true;
}

/**
 * Returns a user preferences array filtered by $cfg['UserprefsDisallow']
 * (blacklist) and keys from user preferences form (whitelist)
 *
 * @param array $config_data path => value pairs
 *
 * @return array
 */
function PMA_applyUserprefs(array $config_data)
{
    $cfg = array();
    $blacklist = array_flip($GLOBALS['cfg']['UserprefsDisallow']);
    if (!$GLOBALS['cfg']['UserprefsDeveloperTab']) {
        // disallow everything in the Developers tab
        $blacklist['DBG/sql'] = true;
    }
    $whitelist = array_flip(PMA_readUserprefsFieldNames());
    // whitelist some additional fields which are custom handled
    $whitelist['ThemeDefault'] = true;
    $whitelist['fontsize'] = true;
    $whitelist['lang'] = true;
    $whitelist['collation_connection'] = true;
    $whitelist['Server/hide_db'] = true;
    $whitelist['Server/only_db'] = true;
    foreach ($config_data as $path => $value) {
        if (! isset($whitelist[$path]) || isset($blacklist[$path])) {
            continue;
        }
        PMA_arrayWrite($path, $cfg, $value);
    }
    return $cfg;
}

/**
 * Reads user preferences field names
 *
 * @param array|null $forms Forms
 *
 * @return array
 */
function PMA_readUserprefsFieldNames(array $forms = null)
{
    static $names;

if (defined('TESTSUITE')) {
        $names = null;
    }

// return cached results
    if ($names !== null) {
        return $names;
    }
    if (is_null($forms)) {
        $forms = array();
        include 'libraries/config/user_preferences.forms.php';
    }
    $names = array();
    foreach ($forms as $formset) {
        foreach ($formset as $form) {
            foreach ($form as $k => $v) {
                $names[] = is_int($k) ? $v : $k;
            }
        }
    }
    return $names;
}

/**
 * Updates one user preferences option (loads and saves to database).
 *
 * No validation is done!
 *
 * @param string $path          configuration
 * @param mixed  $value         value
 * @param mixed  $default_value default value
 *
 * @return void
 */
function PMA_persistOption($path, $value, $default_value)
{
    $prefs = PMA_loadUserprefs();
    if ($value === $default_value) {
        if (isset($prefs['config_data'][$path])) {
            unset($prefs['config_data'][$path]);
        } else {
            return;
        }
    } else {
        $prefs['config_data'][$path] = $value;
    }
    PMA_saveUserprefs($prefs['config_data']);
}

/**
 * Redirects after saving new user preferences
 *
 * @param string $file_name Filename
 * @param array  $params    URL parameters
 * @param string $hash      Hash value
 *
 * @return void
 */
function PMA_userprefsRedirect($file_name,
    $params = null, $hash = null
) {
    // redirect
    $url_params = array('saved' => 1);
    if (is_array($params)) {
        $url_params = array_merge($params, $url_params);
    }
    if ($hash) {
        $hash = '#' . urlencode($hash);
    }
    PMA_sendHeaderLocation('./' . $file_name
        . PMA_URL_getCommon($url_params, '&') . $hash
    );
}

/**
 * Shows form which allows to quickly load
 * settings stored in browser's local storage
 *
 * @return string
 */
function PMA_userprefsAutoloadGetHeader()
{
    if (isset($_REQUEST['prefs_autoload'])
        && $_REQUEST['prefs_autoload'] == 'hide'
    ) {
        $_SESSION['userprefs_autoload'] = true;
        return '';
    }

$script_name = basename(basename($GLOBALS['PMA_PHP_SELF']));
    $return_url = htmlspecialchars(
        $script_name . '?' . http_build_query($_GET, '', '&')
    );

return PMA\libraries\Template::get('prefs_autoload')
        ->render(
            array(
                'hiddenInputs' => PMA_URL_getHiddenInputs(),
                'return_url' => $return_url,
            )
        );
}

${this.title}

Code Editor : user_preferences.lib.php