2 /* vim: set expandtab sw=4 ts=4 sts=4: */
8 use PMA\libraries\RecentFavoriteTable
;
11 * Gets some core libraries and displays a top message if required
13 require_once 'libraries/common.inc.php';
16 * display Git revision if requested
18 require_once 'libraries/display_git_revision.lib.php';
21 * pass variables to child pages
26 'collation_connection',
30 foreach ($drops as $each_drop) {
31 if (array_key_exists($each_drop, $_GET)) {
32 unset($_GET[$each_drop]);
35 unset($drops, $each_drop);
38 * Black list of all scripts to which front-end must submit data.
39 * Such scripts must not be loaded on home page.
42 $target_blacklist = array (
43 'import.php', 'export.php'
46 // If we have a valid target, let's load that script instead
47 if (! empty($_REQUEST['target'])
48 && is_string($_REQUEST['target'])
49 && ! preg_match('/^index/', $_REQUEST['target'])
50 && ! in_array($_REQUEST['target'], $target_blacklist)
51 && in_array($_REQUEST['target'], $goto_whitelist)
53 include $_REQUEST['target'];
57 if (isset($_REQUEST['ajax_request']) && ! empty($_REQUEST['access_time'])) {
62 if (! empty($_REQUEST['db'])) {
64 if (! empty($_REQUEST['table'])) {
65 $page = PMA\libraries\Util
::getScriptNameForOption(
66 $GLOBALS['cfg']['DefaultTabTable'], 'table'
69 $page = PMA\libraries\Util
::getScriptNameForOption(
70 $GLOBALS['cfg']['DefaultTabDatabase'], 'database'
78 * Check if it is an ajax request to reload the recent tables list.
80 if ($GLOBALS['is_ajax_request'] && ! empty($_REQUEST['recent_table'])) {
81 $response = PMA\libraries\Response
::getInstance();
84 RecentFavoriteTable
::getInstance('recent')->getHtmlList()
89 if ($GLOBALS['PMA_Config']->isGitRevision()) {
90 if (isset($_REQUEST['git_revision']) && $GLOBALS['is_ajax_request'] == true) {
91 PMA_printGitRevision();
94 echo '<div id="is_git_revision"></div>';
97 // Handles some variables that may have been sent by the calling script
99 $GLOBALS['table'] = '';
102 // Any message to display?
103 if (! empty($message)) {
104 echo PMA\libraries\Util
::getMessage($message);
108 $common_url_query = PMA_URL_getCommon();
109 $mysql_cur_user_and_host = '';
111 // when $server > 0, a server has been chosen so we can display
112 // all MySQL-related information
114 include 'libraries/server_common.inc.php';
116 // Use the verbose name of the server instead of the hostname
119 if (! empty($cfg['Server']['verbose'])) {
120 $server_info .= htmlspecialchars($cfg['Server']['verbose']);
121 if ($GLOBALS['cfg']['ShowServerInfo']) {
122 $server_info .= ' (';
125 if ($GLOBALS['cfg']['ShowServerInfo'] ||
empty($cfg['Server']['verbose'])) {
126 $server_info .= $GLOBALS['dbi']->getHostInfo();
128 if (! empty($cfg['Server']['verbose']) && $GLOBALS['cfg']['ShowServerInfo']) {
131 $mysql_cur_user_and_host = $GLOBALS['dbi']->fetchValue('SELECT USER();');
133 // should we add the port info here?
134 $short_server_info = (!empty($GLOBALS['cfg']['Server']['verbose'])
135 ?
$GLOBALS['cfg']['Server']['verbose']
136 : $GLOBALS['cfg']['Server']['host']);
139 echo '<div id="maincontainer">' , "\n";
140 // Anchor for favorite tables synchronization.
141 echo RecentFavoriteTable
::getInstance('favorite')->getHtmlSyncFavoriteTables();
142 echo '<div id="main_pane_left">';
143 if ($server > 0 ||
count($cfg['Servers']) > 1
145 if ($cfg['DBG']['demo']) {
146 echo '<div class="group">';
147 echo '<h2>' , __('phpMyAdmin Demo Server') , '</h2>';
148 echo '<p style="margin: 0.5em 1em 0.5em 1em">';
151 'You are using the demo server. You can do anything here, but '
152 . 'please do not change root, debian-sys-maint and pma users. '
153 . 'More information is available at %s.'
155 '<a href="http://demo.phpmyadmin.net/">demo.phpmyadmin.net</a>'
160 echo '<div class="group">';
161 echo '<h2>' , __('General settings') , '</h2>';
165 * Displays the MySQL servers choice form
167 if ($cfg['ServerDefault'] == 0
168 ||
(! $cfg['NavigationDisplayServers']
169 && (count($cfg['Servers']) > 1
170 ||
($server == 0 && count($cfg['Servers']) == 1)))
172 echo '<li id="li_select_server" class="no_bullets" >';
173 include_once 'libraries/select_server.lib.php';
174 echo PMA\libraries\Util
::getImage('s_host.png') , " "
175 , PMA_selectServer(true, true);
180 * Displays the mysql server related links
183 include_once 'libraries/check_user_privileges.lib.php';
185 // Logout for advanced authentication
186 if ($cfg['Server']['auth_type'] != 'config') {
187 if ($cfg['ShowChgPassword']) {
188 $conditional_class = 'ajax';
190 PMA\libraries\Util
::getImage('s_passwd.png') . " " . __(
193 'li_change_password',
194 'user_password.php' . $common_url_query,
197 'change_password_anchor',
203 echo ' <li id="li_select_mysql_collation" class="no_bullets" >';
204 echo ' <form method="post" action="index.php">' , "\n"
205 . PMA_URL_getHiddenInputs(null, null, 4, 'collation_connection')
206 . ' <label for="select_collation_connection">' . "\n"
207 . ' ' . PMA\libraries\Util
::getImage('s_asci.png')
208 . " " . __('Server connection collation') . "\n"
209 // put the doc link in the form so that it appears on the same line
210 . PMA\libraries\Util
::showMySQLDocu('Charset-connection')
214 . PMA_generateCharsetDropdownBox(
215 PMA_CSDROPDOWN_COLLATION
,
216 'collation_connection',
217 'select_collation_connection',
218 $collation_connection,
224 } // end of if ($server > 0)
229 echo '<div class="group">';
230 echo '<h2>' , __('Appearance settings') , '</h2>';
233 // Displays language selection combo
234 if (empty($cfg['Lang']) && count($GLOBALS['available_languages']) > 1) {
235 echo '<li id="li_select_lang" class="no_bullets">';
236 include_once 'libraries/display_select_lang.lib.php';
237 echo PMA\libraries\Util
::getImage('s_lang.png') , " "
238 , PMA_getLanguageSelectorHtml();
242 // ThemeManager if available
244 if ($GLOBALS['cfg']['ThemeManager']) {
245 echo '<li id="li_select_theme" class="no_bullets">';
246 echo PMA\libraries\Util
::getImage('s_theme.png') , " "
247 , $_SESSION['PMA_Theme_Manager']->getHtmlSelectBox();
250 echo '<li id="li_select_fontsize">';
251 echo PMA\libraries\Config
::getFontsizeForm();
261 PMA\libraries\Util
::getImage('b_tblops.png') . " " . __(
264 'li_user_preferences',
265 'prefs_manage.php' . $common_url_query,
278 echo '<div id="main_pane_right">';
281 if ($server > 0 && $GLOBALS['cfg']['ShowServerInfo']) {
283 echo '<div class="group">';
284 echo '<h2>' , __('Database server') , '</h2>';
287 __('Server:') . ' ' . $server_info,
291 __('Server type:') . ' ' . PMA\libraries\Util
::getServerType(),
295 __('Server version:')
297 . PMA_MYSQL_STR_VERSION
. ' - ' . PMA_MYSQL_VERSION_COMMENT
,
301 __('Protocol version:') . ' ' . $GLOBALS['dbi']->getProtoInfo(),
305 __('User:') . ' ' . htmlspecialchars($mysql_cur_user_and_host),
309 echo ' <li id="li_select_mysql_charset">';
310 echo ' ' , __('Server charset:') , ' '
311 . ' <span lang="en" dir="ltr">';
312 echo ' ' , $mysql_charsets_descriptions[$mysql_charset_map['utf-8']];
313 echo ' (' , $mysql_charset_map['utf-8'] , ')'
320 if ($GLOBALS['cfg']['ShowServerInfo'] ||
$GLOBALS['cfg']['ShowPhpInfo']) {
321 echo '<div class="group">';
322 echo '<h2>' , __('Web server') , '</h2>';
324 if ($GLOBALS['cfg']['ShowServerInfo']) {
325 PMA_printListItem($_SERVER['SERVER_SOFTWARE'], 'li_web_server_software');
328 $client_version_str = $GLOBALS['dbi']->getClientInfo();
329 if (preg_match('#\d+\.\d+\.\d+#', $client_version_str)) {
330 $client_version_str = 'libmysql - ' . $client_version_str;
333 __('Database client version:') . ' ' . $client_version_str,
334 'li_mysql_client_version'
337 $php_ext_string = __('PHP extension:') . ' ';
338 if (PMA\libraries\DatabaseInterface
::checkDbExtension('mysqli')) {
339 $extension = 'mysqli';
341 $extension = 'mysql';
343 $php_ext_string .= $extension . ' '
344 . PMA\libraries\Util
::showPHPDocu('book.' . $extension . '.php');
348 'li_used_php_extension'
351 $php_version_string = __('PHP version:') . ' ' . phpversion();
355 'li_used_php_version'
360 if ($cfg['ShowPhpInfo']) {
362 __('Show PHP information'),
364 'phpinfo.php' . $common_url_query,
373 echo '<div class="group pmagroup">';
374 echo '<h2>phpMyAdmin</h2>';
377 // We rely on CSP to allow access to http://www.phpmyadmin.net, but IE lacks
378 // support here and does not allow request to http once using https.
379 if ($GLOBALS['cfg']['VersionCheck']
380 && (! $GLOBALS['PMA_Config']->get('is_https') || PMA_USR_BROWSER_AGENT
!= 'IE')
382 $class = 'jsversioncheck';
385 __('Version information:') . ' <span class="version">' . PMA_VERSION
. '</span>',
396 PMA\libraries\Util
::getDocuLink('index'),
403 PMA_linkURL('http://wiki.phpmyadmin.net/'),
408 // does not work if no target specified, don't know why
410 __('Official Homepage'),
412 PMA_linkURL('http://www.phpMyAdmin.net/'),
419 PMA_linkURL('https://www.phpmyadmin.net/contribute/'),
426 PMA_linkURL('https://www.phpmyadmin.net/support/'),
431 __('List of changes'),
433 'changelog.php' . PMA_URL_getCommon(),
440 'license.php' . PMA_URL_getCommon(),
452 * As we try to handle charsets by ourself, mbstring overloads just
453 * break it, see bug 1063821.
455 if (@extension_loaded
('mbstring') && @ini_get
('mbstring.func_overload') > 1) {
458 'You have enabled mbstring.func_overload in your PHP '
459 . 'configuration. This option is incompatible with phpMyAdmin '
460 . 'and might cause some data to be corrupted!'
467 * mbstring is used for handling multibytes inside parser, so it is good
468 * to tell user something might be broken without it, see bug #1063149.
470 if (! @extension_loaded
('mbstring')) {
473 'The mbstring PHP extension was not found and you seem to be using'
474 . ' a multibyte charset. Without the mbstring extension phpMyAdmin'
475 . ' is unable to split strings correctly and it may result in'
476 . ' unexpected results.'
482 if ($cfg['LoginCookieValidityDisableWarning'] == false) {
484 * Check whether session.gc_maxlifetime limits session validity.
486 $gc_time = (int)@ini_get
('session.gc_maxlifetime');
487 if ($gc_time < $GLOBALS['cfg']['LoginCookieValidity'] ) {
490 'Your PHP parameter [a@http://php.net/manual/en/session.' .
491 'configuration.php#ini.session.gc-maxlifetime@_blank]session.' .
492 'gc_maxlifetime[/a] is lower than cookie validity configured ' .
493 'in phpMyAdmin, because of this, your login might expire sooner ' .
494 'than configured in phpMyAdmin.'
502 * Check whether LoginCookieValidity is limited by LoginCookieStore.
504 if ($GLOBALS['cfg']['LoginCookieStore'] != 0
505 && $GLOBALS['cfg']['LoginCookieStore'] < $GLOBALS['cfg']['LoginCookieValidity']
509 'Login cookie store is lower than cookie validity configured in ' .
510 'phpMyAdmin, because of this, your login will expire sooner than ' .
511 'configured in phpMyAdmin.'
518 * Check if user does not have defined blowfish secret and it is being used.
520 if (! empty($_SESSION['encryption_key'])
521 && empty($GLOBALS['cfg']['blowfish_secret'])
525 'The configuration file now needs a secret passphrase (blowfish_secret).'
532 * Check for existence of config directory which should not exist in
533 * production environment.
535 if (file_exists('config')) {
538 'Directory [code]config[/code], which is used by the setup script, ' .
539 'still exists in your phpMyAdmin directory. It is strongly ' .
540 'recommended to remove it once phpMyAdmin has been configured. ' .
541 'Otherwise the security of your server may be compromised by ' .
542 'unauthorized people downloading your configuration.'
549 $cfgRelation = PMA_getRelationsParam();
550 if (! $cfgRelation['allworks']
551 && $cfg['PmaNoRelation_DisableWarning'] == false
554 'The phpMyAdmin configuration storage is not completely '
555 . 'configured, some extended features have been deactivated. '
556 . '%sFind out why%s. '
558 if ($cfg['ZeroConf'] == true) {
559 $msg_text .= '<br> ' .
561 'Or alternately go to \'Operations\' tab of any database '
562 . 'to set it up there.'
565 $msg = PMA\libraries\Message
::notice($msg_text);
567 '<a href="' . $cfg['PmaAbsoluteUri'] . 'chk_rel.php'
568 . $common_url_query . '">',
571 $msg->addParam('</a>', false);
572 /* Show error if user has configured something, notice elsewhere */
573 if (!empty($cfg['Servers'][$server]['pmadb'])) {
581 * Warning about different MySQL library and server version
582 * (a difference on the third digit does not count).
583 * If someday there is a constant that we can check about mysqlnd,
584 * we can use it instead of strpos().
585 * If no default server is set, $GLOBALS['dbi'] is not defined yet.
586 * We also do not warn if MariaDB is detected, as it has its own version
589 if (isset($GLOBALS['dbi'])
590 && $cfg['ServerLibraryDifference_DisableWarning'] == false
592 $_client_info = $GLOBALS['dbi']->getClientInfo();
594 && mb_strpos($_client_info, 'mysqlnd') === false
595 && mb_strpos(PMA_MYSQL_STR_VERSION
, 'MariaDB') === false
596 && substr(PMA_MYSQL_CLIENT_API
, 0, 3) != substr(
597 PMA_MYSQL_INT_VERSION
, 0, 3
604 'Your PHP MySQL library version %s differs from your ' .
605 'MySQL server version %s. This may cause unpredictable ' .
610 PMA_MYSQL_STR_VERSION
,
612 strpos(PMA_MYSQL_STR_VERSION
. '-', '-')
619 unset($_client_info);
623 * Warning about Suhosin only if its simulation mode is not enabled
625 if ($cfg['SuhosinDisableWarning'] == false
626 && @ini_get
('suhosin.request.max_value_length')
627 && @ini_get
('suhosin.simulation') == '0'
632 'Server running with Suhosin. Please refer to %sdocumentation%s ' .
633 'for possible issues.'
643 * Warning about incomplete translations.
645 * The data file is created while creating release by ./scripts/remove-incomplete-mo
647 if (file_exists('libraries/language_stats.inc.php')) {
648 include 'libraries/language_stats.inc.php';
650 * This message is intentionally not translated, because we're
651 * handling incomplete translations here and focus on english
654 if (isset($GLOBALS['language_stats'][$lang])
655 && $GLOBALS['language_stats'][$lang] < $cfg['TranslationWarningThreshold']
658 'You are using an incomplete translation, please help to make it '
659 . 'better by [a@https://www.phpmyadmin.net/translate/'
660 . '@_blank]contributing[/a].',
667 * prints list item for main page
669 * @param string $name displayed text
670 * @param string $listId id, used for css styles
671 * @param string $url make item as link with $url as target
672 * @param string $mysql_help_page display a link to MySQL's manual
673 * @param string $target special target for $url
674 * @param string $a_id id for the anchor,
675 * used for jQuery to hook in functions
676 * @param string $class class for the li element
677 * @param string $a_class class for the anchor element
681 function PMA_printListItem($name, $listId = null, $url = null,
682 $mysql_help_page = null, $target = null, $a_id = null, $class = null,
685 echo PMA\libraries\Template
::get('list/item')
697 'mysql_help_page' => $mysql_help_page,