{

/**

var $default_source = './libraries/config.default.php';

/**

var $default = array();

/**

var $base_settings = array();

/**

var $settings = array();

/**

var $source = '';

/**

var $source_mtime = 0;

var $default_source_mtime = 0;

var $set_mtime = 0;

/**

var $error_config_file = false;

/**

var $error_config_default_file = false;

/**

var $default_server = array();

/**

var $done = false;

/**

public function __construct($source = null)

{

$this->settings = array();

// functions need to refresh in case of config file changed goes in

// PMA\libraries\Config::load()

$this->load($source);

// other settings, independent from config file, comes in

$this->checkSystem();

$this->base_settings = $this->settings;

}

/**

public function checkSystem()

{

$this->set('PMA_VERSION', '4.8.0-dev');

/* Major version */

$this->set(

'PMA_MAJOR_VERSION',

implode('.', array_slice(explode('.', $this->get('PMA_VERSION'), 3), 0, 2))

);

$this->checkWebServerOs();

$this->checkWebServer();

$this->checkGd2();

$this->checkClient();

$this->checkUpload();

$this->checkUploadSize();

$this->checkOutputCompression();

}

/**

public function checkOutputCompression()

{

// If zlib output compression is set in the php configuration file, no

// output buffering should be run

if (@ini_get('zlib.output_compression')) {

$this->set('OBGzip', false);

}

// enable output-buffering (if set to 'auto')

if (strtolower($this->get('OBGzip')) == 'auto') {

$this->set('OBGzip', true);

}

}

/**

private function _setClientPlatform($user_agent)

{

if (mb_strstr($user_agent, 'Win')) {

$this->set('PMA_USR_OS', 'Win');

} elseif (mb_strstr($user_agent, 'Mac')) {

$this->set('PMA_USR_OS', 'Mac');

} elseif (mb_strstr($user_agent, 'Linux')) {

$this->set('PMA_USR_OS', 'Linux');

} elseif (mb_strstr($user_agent, 'Unix')) {

$this->set('PMA_USR_OS', 'Unix');

} elseif (mb_strstr($user_agent, 'OS/2')) {

$this->set('PMA_USR_OS', 'OS/2');

} else {

$this->set('PMA_USR_OS', 'Other');

}

}

/**

public function checkClient()

{

if (Core::getenv('HTTP_USER_AGENT')) {

$HTTP_USER_AGENT = Core::getenv('HTTP_USER_AGENT');

} else {

$HTTP_USER_AGENT = '';

}

// 1. Platform

$this->_setClientPlatform($HTTP_USER_AGENT);

// 2. browser and version

// (must check everything else before Mozilla)

$is_mozilla = preg_match(

'@Mozilla/([0-9]\.[0-9]{1,2})@',

$HTTP_USER_AGENT,

$mozilla_version

);

if (preg_match(

'@Opera(/| )([0-9]\.[0-9]{1,2})@',

$HTTP_USER_AGENT,

$log_version

)) {

$this->set('PMA_USR_BROWSER_VER', $log_version[2]);

$this->set('PMA_USR_BROWSER_AGENT', 'OPERA');

} elseif (preg_match(

'@(MS)?IE ([0-9]{1,2}\.[0-9]{1,2})@',

$HTTP_USER_AGENT,

$log_version

)) {

$this->set('PMA_USR_BROWSER_VER', $log_version[2]);

$this->set('PMA_USR_BROWSER_AGENT', 'IE');

} elseif (preg_match(

'@Trident/(7)\.0@',

$HTTP_USER_AGENT,

$log_version

)) {

$this->set('PMA_USR_BROWSER_VER', intval($log_version[1]) + 4);

$this->set('PMA_USR_BROWSER_AGENT', 'IE');

} elseif (preg_match(

'@OmniWeb/([0-9]{1,3})@',

$HTTP_USER_AGENT,

$log_version

)) {

$this->set('PMA_USR_BROWSER_VER', $log_version[1]);

$this->set('PMA_USR_BROWSER_AGENT', 'OMNIWEB');

// Konqueror 2.2.2 says Konqueror/2.2.2

// Konqueror 3.0.3 says Konqueror/3

} elseif (preg_match(

'@(Konqueror/)(.*)(;)@',

$HTTP_USER_AGENT,

$log_version

)) {

$this->set('PMA_USR_BROWSER_VER', $log_version[2]);

$this->set('PMA_USR_BROWSER_AGENT', 'KONQUEROR');

// must check Chrome before Safari

} elseif ($is_mozilla

&& preg_match('@Chrome/([0-9.]*)@', $HTTP_USER_AGENT, $log_version)

) {

$this->set('PMA_USR_BROWSER_VER', $log_version[1]);

$this->set('PMA_USR_BROWSER_AGENT', 'CHROME');

// newer Safari

} elseif ($is_mozilla

&& preg_match('@Version/(.*) Safari@', $HTTP_USER_AGENT, $log_version)

) {

$this->set(

'PMA_USR_BROWSER_VER', $log_version[1]

);

$this->set('PMA_USR_BROWSER_AGENT', 'SAFARI');

// older Safari

} elseif ($is_mozilla

&& preg_match('@Safari/([0-9]*)@', $HTTP_USER_AGENT, $log_version)

) {

$this->set(

'PMA_USR_BROWSER_VER', $mozilla_version[1] . '.' . $log_version[1]

);

$this->set('PMA_USR_BROWSER_AGENT', 'SAFARI');

// Firefox

} elseif (! mb_strstr($HTTP_USER_AGENT, 'compatible')

&& preg_match('@Firefox/([\w.]+)@', $HTTP_USER_AGENT, $log_version)

) {

$this->set(

'PMA_USR_BROWSER_VER', $log_version[1]

);

$this->set('PMA_USR_BROWSER_AGENT', 'FIREFOX');

} elseif (preg_match('@rv:1\.9(.*)Gecko@', $HTTP_USER_AGENT)) {

$this->set('PMA_USR_BROWSER_VER', '1.9');

$this->set('PMA_USR_BROWSER_AGENT', 'GECKO');

} elseif ($is_mozilla) {

$this->set('PMA_USR_BROWSER_VER', $mozilla_version[1]);

$this->set('PMA_USR_BROWSER_AGENT', 'MOZILLA');

} else {

$this->set('PMA_USR_BROWSER_VER', 0);

$this->set('PMA_USR_BROWSER_AGENT', 'OTHER');

}

}

/**

public function checkGd2()

{

if ($this->get('GD2Available') == 'yes') {

$this->set('PMA_IS_GD2', 1);

return;

}

if ($this->get('GD2Available') == 'no') {

$this->set('PMA_IS_GD2', 0);

return;

}

if (!@function_exists('imagecreatetruecolor')) {

$this->set('PMA_IS_GD2', 0);

return;

}

if (@function_exists('gd_info')) {

$gd_nfo = gd_info();

if (mb_strstr($gd_nfo["GD Version"], '2.')) {

$this->set('PMA_IS_GD2', 1);

} else {

$this->set('PMA_IS_GD2', 0);

}

} else {

$this->set('PMA_IS_GD2', 0);

}

}

/**

public function checkWebServer()

{

// some versions return Microsoft-IIS, some Microsoft/IIS

// we could use a preg_match() but it's slower

if (Core::getenv('SERVER_SOFTWARE')

&& stristr(Core::getenv('SERVER_SOFTWARE'), 'Microsoft')

&& stristr(Core::getenv('SERVER_SOFTWARE'), 'IIS')

) {

$this->set('PMA_IS_IIS', 1);

} else {

$this->set('PMA_IS_IIS', 0);

}

}

/**

public function checkWebServerOs()

{

// Default to Unix or Equiv

$this->set('PMA_IS_WINDOWS', 0);

// If PHP_OS is defined then continue

if (defined('PHP_OS')) {

if (stristr(PHP_OS, 'win') && !stristr(PHP_OS, 'darwin')) {

// Is it some version of Windows

$this->set('PMA_IS_WINDOWS', 1);

} elseif (stristr(PHP_OS, 'OS/2')) {

// Is it OS/2 (No file permissions like Windows)

$this->set('PMA_IS_WINDOWS', 1);

}

}

}

/**

public function isGitRevision()

{

if (!$this->get('ShowGitRevision')) {

return false;

}

// caching

if (isset($_SESSION['is_git_revision'])) {

if ($_SESSION['is_git_revision']) {

$this->set('PMA_VERSION_GIT', 1);

}

return $_SESSION['is_git_revision'];

}

// find out if there is a .git folder

$git_folder = '.git';

if (! @file_exists($git_folder)

|| ! @file_exists($git_folder . '/config')

) {

$_SESSION['is_git_revision'] = false;

return false;

}

$_SESSION['is_git_revision'] = true;

return true;

}

/**

public function checkGitRevision()

{

// find out if there is a .git folder

$git_folder = '.git';

if (! $this->isGitRevision()) {

return;

}

if (! $ref_head = @file_get_contents($git_folder . '/HEAD')) {

return;

}

$branch = false;

// are we on any branch?

if (strstr($ref_head, '/')) {

// remove ref: prefix

$ref_head = substr(trim($ref_head), 5);

if (substr($ref_head, 0, 11) === 'refs/heads/') {

$branch = substr($ref_head, 11);

} else {

$branch = basename($ref_head);

}

$ref_file = $git_folder . '/' . $ref_head;

if (@file_exists($ref_file)) {

$hash = @file_get_contents($ref_file);

if (! $hash) {

return;

}

$hash = trim($hash);

} else {

// deal with packed refs

$packed_refs = @file_get_contents($git_folder . '/packed-refs');

if (! $packed_refs) {

return;

}

// split file to lines

$ref_lines = explode("\n", $packed_refs);

foreach ($ref_lines as $line) {

// skip comments

if ($line[0] == '#') {

continue;

}

// parse line

$parts = explode(' ', $line);

// care only about named refs

if (count($parts) != 2) {

continue;

}

// have found our ref?

if ($parts[1] == $ref_head) {

$hash = $parts[0];

break;

}

}

if (! isset($hash)) {

// Could not find ref

return;

}

}

} else {

$hash = trim($ref_head);

}

$commit = false;

if (! preg_match('/^[0-9a-f]{40}$/i', $hash)) {

$commit = false;

} elseif (isset($_SESSION['PMA_VERSION_COMMITDATA_' . $hash])) {

$commit = $_SESSION['PMA_VERSION_COMMITDATA_' . $hash];

} elseif (function_exists('gzuncompress')) {

$git_file_name = $git_folder . '/objects/'

. substr($hash, 0, 2) . '/' . substr($hash, 2);

if (file_exists($git_file_name) ) {

if (! $commit = @file_get_contents($git_file_name)) {

return;

}

$commit = explode("\0", gzuncompress($commit), 2);

$commit = explode("\n", $commit[1]);

$_SESSION['PMA_VERSION_COMMITDATA_' . $hash] = $commit;

} else {

$pack_names = array();

// work with packed data

$packs_file = $git_folder . '/objects/info/packs';

if (file_exists($packs_file)

&& $packs = @file_get_contents($packs_file)

) {

// File exists. Read it, parse the file to get the names of the

// packs. (to look for them in .git/object/pack directory later)

foreach (explode("\n", $packs) as $line) {

// skip blank lines

if (strlen(trim($line)) == 0) {

continue;

}

// skip non pack lines

if ($line[0] != 'P') {

continue;

}

// parse names

$pack_names[] = substr($line, 2);

}

} else {

// '.git/objects/info/packs' file can be missing

// (atlease in mysGit)

// File missing. May be we can look in the .git/object/pack

// directory for all the .pack files and use that list of

// files instead

$dirIterator = new DirectoryIterator(

$git_folder . '/objects/pack'

);

foreach ($dirIterator as $file_info) {

$file_name = $file_info->getFilename();

// if this is a .pack file

if ($file_info->isFile() && substr($file_name, -5) == '.pack'

) {

$pack_names[] = $file_name;

}

}

}

$hash = strtolower($hash);

foreach ($pack_names as $pack_name) {

$index_name = str_replace('.pack', '.idx', $pack_name);

// load index

$index_data = @file_get_contents(

$git_folder . '/objects/pack/' . $index_name

);

if (! $index_data) {

continue;

}

// check format

if (substr($index_data, 0, 4) != "\377tOc") {

continue;

}

// check version

$version = unpack('N', substr($index_data, 4, 4));

if ($version[1] != 2) {

continue;

}

// parse fanout table

$fanout = unpack(

"N*",

substr($index_data, 8, 256 * 4)

);

// find where we should search

$firstbyte = intval(substr($hash, 0, 2), 16);

// array is indexed from 1 and we need to get

// previous entry for start

if ($firstbyte == 0) {

$start = 0;

} else {

$start = $fanout[$firstbyte];

}

$end = $fanout[$firstbyte + 1];

// stupid linear search for our sha

$found = false;

$offset = 8 + (256 * 4);

for ($position = $start; $position < $end; $position++) {

$sha = strtolower(

bin2hex(

substr($index_data, $offset + ($position * 20), 20)

)

);

if ($sha == $hash) {

$found = true;

break;

}

}

if (! $found) {

continue;

}

// read pack offset

$offset = 8 + (256 * 4) + (24 * $fanout[256]);

$pack_offset = unpack(

'N',

substr($index_data, $offset + ($position * 4), 4)

);

$pack_offset = $pack_offset[1];

// open pack file

$pack_file = fopen(

$git_folder . '/objects/pack/' . $pack_name, 'rb'

);

if ($pack_file === false) {

continue;

}

// seek to start

fseek($pack_file, $pack_offset);

// parse header

$header = ord(fread($pack_file, 1));

$type = ($header >> 4) & 7;

$hasnext = ($header & 128) >> 7;

$size = $header & 0xf;

$offset = 4;

while ($hasnext) {

$byte = ord(fread($pack_file, 1));

$size |= ($byte & 0x7f) << $offset;

$hasnext = ($byte & 128) >> 7;

$offset += 7;

}

// we care only about commit objects

if ($type != 1) {

continue;

}

// read data

$commit = fread($pack_file, $size);

$commit = gzuncompress($commit);

$commit = explode("\n", $commit);

$_SESSION['PMA_VERSION_COMMITDATA_' . $hash] = $commit;

fclose($pack_file);

}

}

}

// check if commit exists in Github

if ($commit !== false

&& isset($_SESSION['PMA_VERSION_REMOTECOMMIT_' . $hash])

) {

$is_remote_commit = $_SESSION['PMA_VERSION_REMOTECOMMIT_' . $hash];

} else {

$link = 'https://www.phpmyadmin.net/api/commit/' . $hash . '/';

$is_found = Util::httpRequest($link, "GET");

switch($is_found) {

case false:

$is_remote_commit = false;

$_SESSION['PMA_VERSION_REMOTECOMMIT_' . $hash] = false;

break;

case null:

// no remote link for now, but don't cache this as Github is down

$is_remote_commit = false;

break;

default:

$is_remote_commit = true;

$_SESSION['PMA_VERSION_REMOTECOMMIT_' . $hash] = true;

if ($commit === false) {

// if no local commit data, try loading from Github

$commit_json = json_decode($is_found);

}

break;

}

}

$is_remote_branch = false;

if ($is_remote_commit && $branch !== false) {

// check if branch exists in Github

if (isset($_SESSION['PMA_VERSION_REMOTEBRANCH_' . $hash])) {

$is_remote_branch = $_SESSION['PMA_VERSION_REMOTEBRANCH_' . $hash];

} else {

$link = 'https://www.phpmyadmin.net/api/tree/' . $branch . '/';

$is_found = Util::httpRequest($link, "GET", true);

switch($is_found) {

case true:

$is_remote_branch = true;

$_SESSION['PMA_VERSION_REMOTEBRANCH_' . $hash] = true;

break;

case false:

$is_remote_branch = false;

$_SESSION['PMA_VERSION_REMOTEBRANCH_' . $hash] = false;

break;

case null:

// no remote link for now, but don't cache this as Github is down

$is_remote_branch = false;

break;

}

}

}

if ($commit !== false) {

$author = array('name' => '', 'email' => '', 'date' => '');

$committer = array('name' => '', 'email' => '', 'date' => '');

do {

$dataline = array_shift($commit);

$datalinearr = explode(' ', $dataline, 2);

$linetype = $datalinearr[0];

if (in_array($linetype, array('author', 'committer'))) {

$user = $datalinearr[1];

preg_match('/([^<]+)<([^>]+)> ([0-9]+)( [^ ]+)?/', $user, $user);

$user2 = array(

'name' => trim($user[1]),

'email' => trim($user[2]),

'date' => date('Y-m-d H:i:s', $user[3]));

if (isset($user[4])) {

$user2['date'] .= $user[4];

}

$$linetype = $user2;

}

} while ($dataline != '');

$message = trim(implode(' ', $commit));

} elseif (isset($commit_json) && isset($commit_json->author) && isset($commit_json->committer)) {

$author = array(

'name' => $commit_json->author->name,

'email' => $commit_json->author->email,

'date' => $commit_json->author->date);

$committer = array(

'name' => $commit_json->committer->name,

'email' => $commit_json->committer->email,

'date' => $commit_json->committer->date);

$message = trim($commit_json->message);

} else {

return;

}

$this->set('PMA_VERSION_GIT', 1);

$this->set('PMA_VERSION_GIT_COMMITHASH', $hash);

$this->set('PMA_VERSION_GIT_BRANCH', $branch);

$this->set('PMA_VERSION_GIT_MESSAGE', $message);

$this->set('PMA_VERSION_GIT_AUTHOR', $author);

$this->set('PMA_VERSION_GIT_COMMITTER', $committer);

$this->set('PMA_VERSION_GIT_ISREMOTECOMMIT', $is_remote_commit);

$this->set('PMA_VERSION_GIT_ISREMOTEBRANCH', $is_remote_branch);

}

/**

public function loadDefaults()

{

$cfg = array();

if (! @file_exists($this->default_source)) {

$this->error_config_default_file = true;

return false;

}

$old_error_reporting = error_reporting(0);

ob_start();

$GLOBALS['pma_config_loading'] = true;

$eval_result = include $this->default_source;

$GLOBALS['pma_config_loading'] = false;

ob_end_clean();

error_reporting($old_error_reporting);

if ($eval_result === false) {

$this->error_config_default_file = true;

return false;

}

$this->default_source_mtime = filemtime($this->default_source);

$this->default_server = $cfg['Servers'][1];

unset($cfg['Servers']);

$this->default = $cfg;

$this->settings = array_replace_recursive($this->settings, $cfg);

$this->error_config_default_file = false;

return true;

}

/**

public function load($source = null)

{

$this->loadDefaults();

if (null !== $source) {

$this->setSource($source);

}

/**

$this->checkFontsize();

if (! $this->checkConfigSource()) {

// even if no config file, set collation_connection

$this->checkCollationConnection();

return false;

}

$cfg = array();

/**

$old_error_reporting = error_reporting(0);

ob_start();

$GLOBALS['pma_config_loading'] = true;

$eval_result = include $this->getSource();

$GLOBALS['pma_config_loading'] = false;

ob_end_clean();

error_reporting($old_error_reporting);

if ($eval_result === false) {

$this->error_config_file = true;

} else {

$this->error_config_file = false;

$this->source_mtime = filemtime($this->getSource());

}

/**

$matched_keys = array_filter(

array_keys($cfg),

function ($key) {return strpos($key, '/') === false;}

);

$cfg = array_intersect_key($cfg, array_flip($matched_keys));

/**

if (!empty($cfg['DefaultTabTable'])) {

$cfg['DefaultTabTable'] = str_replace(

'_properties',

'',

str_replace(

'tbl_properties.php',

'tbl_sql.php',

$cfg['DefaultTabTable']

)

);

}

if (!empty($cfg['DefaultTabDatabase'])) {

$cfg['DefaultTabDatabase'] = str_replace(

'_details',

'',

str_replace(

'db_details.php',

'db_sql.php',

$cfg['DefaultTabDatabase']

)

);

}

$this->settings = array_replace_recursive($this->settings, $cfg);

// Handling of the collation must be done after merging of $cfg

// (from config.inc.php) so that $cfg['DefaultConnectionCollation']

// can have an effect.

$this->checkCollationConnection();

return true;

}

/**

private function _saveConnectionCollation($config_data)

{

// just to shorten the lines

$collation = 'collation_connection';

if (isset($GLOBALS[$collation])

&& (isset($_COOKIE['pma_collation_connection'])

|| isset($_POST[$collation]))

) {

if ((! isset($config_data[$collation])

&& $GLOBALS[$collation] != 'utf8_general_ci')

|| isset($config_data[$collation])

&& $GLOBALS[$collation] != $config_data[$collation]

) {

$this->setUserValue(

null,

$collation,

$GLOBALS[$collation],

'utf8_general_ci'

);

}

} else {

// read collation from settings

if (isset($config_data[$collation])) {

$GLOBALS[$collation]

= $config_data[$collation];

$this->setCookie(

'pma_collation_connection',

$GLOBALS[$collation]

);

}

}

}

/**

public function loadUserPreferences()

{

// index.php should load these settings, so that phpmyadmin.css.php

// will have everything available in session cache

$server = isset($GLOBALS['server'])

? $GLOBALS['server']

: (!empty($GLOBALS['cfg']['ServerDefault'])

? $GLOBALS['cfg']['ServerDefault']

: 0);

$cache_key = 'server_' . $server;

if ($server > 0 && !defined('PMA_MINIMUM_COMMON')) {

$config_mtime = max($this->default_source_mtime, $this->source_mtime);

// cache user preferences, use database only when needed

if (! isset($_SESSION['cache'][$cache_key]['userprefs'])

|| $_SESSION['cache'][$cache_key]['config_mtime'] < $config_mtime

) {

// load required libraries

include_once './libraries/user_preferences.lib.php';

$prefs = PMA_loadUserprefs();

$_SESSION['cache'][$cache_key]['userprefs']

= PMA_applyUserprefs($prefs['config_data']);

$_SESSION['cache'][$cache_key]['userprefs_mtime'] = $prefs['mtime'];

$_SESSION['cache'][$cache_key]['userprefs_type'] = $prefs['type'];

$_SESSION['cache'][$cache_key]['config_mtime'] = $config_mtime;

}

} elseif ($server == 0

|| ! isset($_SESSION['cache'][$cache_key]['userprefs'])

) {

$this->set('user_preferences', false);

return;

}

$config_data = $_SESSION['cache'][$cache_key]['userprefs'];

// type is 'db' or 'session'

$this->set(

'user_preferences',

$_SESSION['cache'][$cache_key]['userprefs_type']

);

$this->set(

'user_preferences_mtime',

$_SESSION['cache'][$cache_key]['userprefs_mtime']

);

// backup some settings

$org_fontsize = '';

if (isset($this->settings['fontsize'])) {

$org_fontsize = $this->settings['fontsize'];

}

// load config array

$this->settings = array_replace_recursive($this->settings, $config_data);

$GLOBALS['cfg'] = array_replace_recursive($GLOBALS['cfg'], $config_data);

if (defined('PMA_MINIMUM_COMMON')) {

return;

}

// settings below start really working on next page load, but

// changes are made only in index.php so everything is set when

// in frames

// save theme

/** @var ThemeManager $tmanager */

$tmanager = ThemeManager::getInstance();

if ($tmanager->getThemeCookie() || isset($_REQUEST['set_theme'])) {

if ((! isset($config_data['ThemeDefault'])

&& $tmanager->theme->getId() != 'original')

|| isset($config_data['ThemeDefault'])

&& $config_data['ThemeDefault'] != $tmanager->theme->getId()

) {

// new theme was set in common.inc.php

$this->setUserValue(

null,

'ThemeDefault',

$tmanager->theme->getId(),

'original'

);

}

} else {

// no cookie - read default from settings

if ($this->settings['ThemeDefault'] != $tmanager->theme->getId()

&& $tmanager->checkTheme($this->settings['ThemeDefault'])

) {

$tmanager->setActiveTheme($this->settings['ThemeDefault']);

$tmanager->setThemeCookie();

}

}

// save font size

if ((! isset($config_data['fontsize'])

&& $org_fontsize != '82%')

|| isset($config_data['fontsize'])

&& $org_fontsize != $config_data['fontsize']

) {

$this->setUserValue(null, 'fontsize', $org_fontsize, '82%');

}

// save language

if (isset($_COOKIE['pma_lang']) || isset($_POST['lang'])) {

if ((! isset($config_data['lang'])

&& $GLOBALS['lang'] != 'en')

|| isset($config_data['lang'])

&& $GLOBALS['lang'] != $config_data['lang']

) {

$this->setUserValue(null, 'lang', $GLOBALS['lang'], 'en');

}

} else {

// read language from settings

if (isset($config_data['lang'])) {

$language = LanguageManager::getInstance()->getLanguage(

$config_data['lang']

);

if ($language !== false) {