main.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @version $Id$
   6  * @package phpMyAdmin
   7  */
   8
   9 /**
  10  * Gets some core libraries and displays a top message if required
  11  */
  12 define('PMA_COLORPICKER', true);
  13 require_once './libraries/common.inc.php';
  14
  15 $GLOBALS['js_include'][] = 'colorpicker/js/colorpicker.js';
  16 $GLOBALS['js_include'][] = 'main_custom_color.js';
  17
  18 // Handles some variables that may have been sent by the calling script
  19 $GLOBALS['db'] = '';
  20 $GLOBALS['table'] = '';
  21 $show_query = '1';
  22 require_once './libraries/header.inc.php';
  23
  24 // Any message to display?
  25 if (! empty($message)) {
  26     PMA_showMessage($message);
  27     unset($message);
  28 }
  29
  30 $common_url_query =  PMA_generate_common_url('', '');
  31
  32 // when $server > 0, a server has been chosen so we can display
  33 // all MySQL-related information
  34 if ($server > 0) {
  35     require './libraries/server_common.inc.php';
  36     require './libraries/StorageEngine.class.php';
  37     require './libraries/server_links.inc.php';
  38
  39     // Use the verbose name of the server instead of the hostname
  40     // if a value is set
  41     $server_info = '';
  42     if (! empty($cfg['Server']['verbose'])) {
  43         $server_info .= htmlspecialchars($cfg['Server']['verbose']);
  44         if ($GLOBALS['cfg']['ShowServerInfo']) {
  45             $server_info .= ' (';
  46         }
  47     }
  48     if ($GLOBALS['cfg']['ShowServerInfo'] || empty($cfg['Server']['verbose'])) {
  49         $server_info .= PMA_DBI_get_host_info();
  50     }
  51     if (! empty($cfg['Server']['verbose']) && $GLOBALS['cfg']['ShowServerInfo']) {
  52     $server_info .= ')';
  53     }
  54     $mysql_cur_user_and_host = PMA_DBI_fetch_value('SELECT USER();');
  55
  56     // should we add the port info here?
  57     $short_server_info = (!empty($GLOBALS['cfg']['Server']['verbose'])
  58                     ? $GLOBALS['cfg']['Server']['verbose']
  59                     : $GLOBALS['cfg']['Server']['host']);
  60 }
  61
  62 echo '<div id="maincontainer">' . "\n";
  63 echo '<div id="main_pane_left">';
  64
  65 if ($server > 0
  66  || (! $cfg['LeftDisplayServers'] && count($cfg['Servers']) > 1)) {
  67     echo '<div class="group">';
  68     echo '<h2>' . __('Actions') . '</h2>';
  69     echo '<ul>';
  70
  71     /**
  72      * Displays the MySQL servers choice form
  73      */
  74     if (! $cfg['LeftDisplayServers']
  75      && (count($cfg['Servers']) > 1 || $server == 0 && count($cfg['Servers']) == 1)) {
  76         echo '<li id="li_select_server">';
  77         require_once './libraries/select_server.lib.php';
  78         PMA_select_server(true, true);
  79         echo '</li>';
  80     }
  81
  82     /**
  83      * Displays the mysql server related links
  84      */
  85     if ($server > 0) {
  86         require_once './libraries/check_user_privileges.lib.php';
  87
  88         // Logout for advanced authentication
  89         if ($cfg['Server']['auth_type'] != 'config') {
  90             if ($cfg['ShowChgPassword']) {
  91                 PMA_printListItem(__('Change password'), 'li_change_password',
  92                     './user_password.php?' . $common_url_query);
  93             }
  94
  95             $http_logout = ($cfg['Server']['auth_type'] == 'http')
  96                          ? '<a href="./Documentation.html#login_bug" target="documentation">'
  97                             . ($cfg['ReplaceHelpImg'] ? '<img class="icon" src="' . $pmaThemeImage . 'b_info.png" width="11" height="11" alt="Info" />' : '(*)') . '</a>'
  98                          : '';
  99             PMA_printListItem('<strong>' . __('Log out') . '</strong> ' . $http_logout,
 100                 'li_log_out',
 101                 './index.php?' . $common_url_query . '&amp;old_usr=' . urlencode($PHP_AUTH_USER), null, '_parent');
 102         } // end if
 103     } // end of if ($server > 0)
 104
 105     echo '</ul>';
 106     echo '</div>';
 107 }
 108
 109
 110 if ($server > 0) {
 111     echo '<div class="group">';
 112     echo '<h2>MySQL ' . $short_server_info . '</h2>';
 113     echo '<ul>' . "\n";
 114
 115     if ($cfg['ShowCreateDb']) {
 116         echo '<li id="li_create_database">';
 117         require './libraries/display_create_database.lib.php';
 118         echo '</li>' . "\n";
 119     }
 120
 121     echo '    <li id="li_select_mysql_collation">';
 122     echo '        <form method="post" action="index.php" target="_parent">' . "\n"
 123        . PMA_generate_common_hidden_inputs(null, null, 4, 'collation_connection')
 124        . '            <label for="select_collation_connection">' . "\n"
 125        . '                ' . __('MySQL connection collation') . ': ' . "\n"
 126        . '            </label>' . "\n"
 127        . PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_COLLATION, 'collation_connection', 'select_collation_connection', $collation_connection, true, 4, true)
 128        . '            <noscript><input type="submit" value="' . __('Go') . '" /></noscript>' . "\n"
 129        // put the doc link in the form so that it appears on the same line
 130        . PMA_showMySQLDocu('MySQL_Database_Administration', 'Charset-connection') . "\n"
 131        . '        </form>' . "\n"
 132        . '    </li>' . "\n";
 133
 134     echo '  </ul>';
 135     echo ' </div>';
 136 }
 137
 138 echo '<div class="group">';
 139 echo '<h2>' . __('Interface') . '</h2>';
 140 echo '  <ul>';
 141
 142 // Displays language selection combo
 143 if (empty($cfg['Lang'])) {
 144     echo '<li id="li_select_lang">';
 145     require_once './libraries/display_select_lang.lib.php';
 146     PMA_select_language();
 147     echo '</li>';
 148 }
 149
 150 // ThemeManager if available
 151
 152 if ($GLOBALS['cfg']['ThemeManager']) {
 153     echo '<li id="li_select_theme">';
 154     echo $_SESSION['PMA_Theme_Manager']->getHtmlSelectBox();
 155     echo '</li>';
 156
 157     // see js/main_custom_color.js
 158     echo '<li id="li_custom_color" class="hide">';
 159     echo PMA_escapeJsString(__('Custom color')) . ': ';
 160     echo '<form name="colorform" id="colorform" method="post" action="index.php" target="_parent">';
 161     echo PMA_generate_common_hidden_inputs();
 162     echo '<input type="hidden" id="custom_color" name="custom_color" value="" />';
 163     echo '<input type="submit" name="custom_color_reset" value="' . __('Reset') . '" />';
 164     echo '</form>';
 165     echo '<div id="colorSelector">';
 166     echo '</div>';
 167     echo '</li>';
 168 }
 169 echo '<li id="li_select_fontsize">';
 170 echo PMA_Config::getFontsizeForm();
 171 echo '</li>';
 172
 173 echo '</ul>';
 174
 175 // User preferences
 176
 177 echo '<ul>';
 178 echo PMA_printListItem(__('More settings'), 'li_user_preferences',
 179                     './prefs_manage.php?' . $common_url_query);
 180 echo '<ul>';
 181
 182 echo '</div>';
 183
 184
 185 echo '</div>';
 186 echo '<div id="main_pane_right">';
 187
 188
 189 if ($server > 0 && $GLOBALS['cfg']['ShowServerInfo']) {
 190     echo '<div class="group">';
 191     echo '<h2>MySQL</h2>';
 192     echo '<ul>' . "\n";
 193     PMA_printListItem(__('Server') . ': ' . $server_info, 'li_server_info');
 194     PMA_printListItem(__('Server version') . ': ' . PMA_MYSQL_STR_VERSION, 'li_server_version');
 195     PMA_printListItem(__('Protocol version') . ': ' . PMA_DBI_get_proto_info(),
 196         'li_mysql_proto');
 197     PMA_printListItem(__('User') . ': ' . htmlspecialchars($mysql_cur_user_and_host),
 198         'li_user_info');
 199
 200     echo '    <li id="li_select_mysql_charset">';
 201     echo '        ' . __('MySQL charset') . ': '
 202        . '        <span xml:lang="en" dir="ltr">'
 203        . '           ' . $mysql_charsets_descriptions[$mysql_charset_map[strtolower($charset)]] . "\n"
 204        . '           (' . $mysql_charset_map[strtolower($charset)] . ')' . "\n"
 205        . '        </span>' . "\n"
 206        . '    </li>' . "\n";
 207     echo '  </ul>';
 208     echo ' </div>';
 209 }
 210
 211 if ($GLOBALS['cfg']['ShowServerInfo'] || $GLOBALS['cfg']['ShowPhpInfo']) {
 212     echo '<div class="group">';
 213     echo '<h2>' . __('Web server') . '</h2>';
 214     echo '<ul>';
 215     if ($GLOBALS['cfg']['ShowServerInfo']) {
 216         PMA_printListItem($_SERVER['SERVER_SOFTWARE'], 'li_web_server_software');
 217
 218         if ($server > 0) {
 219             PMA_printListItem(__('MySQL client version') . ': ' . PMA_DBI_get_client_info(),
 220                 'li_mysql_client_version');
 221             PMA_printListItem(__('PHP extension') . ': ' . $GLOBALS['cfg']['Server']['extension'],
 222                 'li_used_php_extension');
 223         }
 224     }
 225
 226     if ($cfg['ShowPhpInfo']) {
 227         PMA_printListItem(__('Show PHP information'), 'li_phpinfo', './phpinfo.php?' . $common_url_query);
 228     }
 229     echo '  </ul>';
 230     echo ' </div>';
 231 }
 232
 233 echo '<div class="group">';
 234 echo '<h2>phpMyAdmin</h2>';
 235 echo '<ul>';
 236 PMA_printListItem(__('Version information') . ': ' . PMA_VERSION, 'li_pma_version');
 237 PMA_printListItem(__('Documentation'), 'li_pma_docs', 'Documentation.html', null, '_blank');
 238 PMA_printListItem(__('Wiki'), 'li_pma_wiki', 'http://wiki.phpmyadmin.net', null, '_blank');
 239
 240 // does not work if no target specified, don't know why
 241 PMA_printListItem(__('Official Homepage'), 'li_pma_homepage', 'http://www.phpMyAdmin.net/', null, '_blank');
 242 ?>
 243     <li><bdo xml:lang="en" dir="ltr">
 244         [<a href="changelog.php" target="_blank">ChangeLog</a>]
 245         [<a href="http://phpmyadmin.git.sourceforge.net/git/gitweb-index.cgi"
 246             target="_blank">Git</a>]
 247         [<a href="http://sourceforge.net/mail/?group_id=23067"
 248             target="_blank">Lists</a>]
 249         </bdo>
 250     </li>
 251     </ul>
 252  </div>
 253
 254 </div>
 255
 256 <?php
 257 /**
 258  * BUG: MSIE needs two <br /> here, otherwise it will not extend the outer div to the
 259  * full height of the inner divs
 260  */
 261 ?>
 262 <br class="clearfloat" />
 263 <br class="clearfloat" />
 264 </div>
 265
 266 <?php
 267 /**
 268  * Warning if using the default MySQL privileged account
 269  * modified: 2004-05-05 mkkeck
 270  */
 271 if ($server != 0
 272  && $cfg['Server']['user'] == 'root'
 273  && $cfg['Server']['password'] == '') {
 274     trigger_error(__('Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user \'root\'.'), E_USER_WARNING);
 275 }
 276
 277 /**
 278  * Nijel: As we try to handle charsets by ourself, mbstring overloads just
 279  * break it, see bug 1063821.
 280  */
 281 if (@extension_loaded('mbstring') && @ini_get('mbstring.func_overload') > 1) {
 282     trigger_error(__('You have enabled mbstring.func_overload in your PHP configuration. This option is incompatible with phpMyAdmin and might cause some data to be corrupted!'), E_USER_WARNING);
 283 }
 284
 285 /**
 286  * Nijel: mbstring is used for handling multibyte inside parser, so it is good
 287  * to tell user something might be broken without it, see bug #1063149.
 288  */
 289 if (! @extension_loaded('mbstring')) {
 290     trigger_error(__('The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.'), E_USER_WARNING);
 291 }
 292
 293 /**
 294  * Check whether session.gc_maxlifetime limits session validity.
 295  */
 296 $gc_time = (int)@ini_get('session.gc_maxlifetime');
 297 if ($gc_time < $GLOBALS['cfg']['LoginCookieValidity'] ) {
 298     trigger_error(PMA_Message::decodeBB(__('Your PHP parameter [a@http://php.net/manual/en/session.configuration.php#ini.session.gc-maxlifetime@]session.gc_maxlifetime[/a] is lower that cookie validity configured in phpMyAdmin, because of this, your login will expire sooner than configured in phpMyAdmin.')), E_USER_WARNING);
 299 }
 300
 301 /**
 302  * Check if user does not have defined blowfish secret and it is being used.
 303  */
 304 if (!empty($_SESSION['auto_blowfish_secret']) &&
 305         empty($GLOBALS['cfg']['blowfish_secret'])) {
 306     trigger_error(__('The configuration file now needs a secret passphrase (blowfish_secret).'), E_USER_WARNING);
 307 }
 308
 309 /**
 310  * Check for existence of config directory which should not exist in
 311  * production environment.
 312  */
 313 if (file_exists('./config')) {
 314     trigger_error(__('Directory [code]config[/code], which is used by the setup script, still exists in your phpMyAdmin directory. You should remove it once phpMyAdmin has been configured.'), E_USER_WARNING);
 315 }
 316
 317 /**
 318  * Check whether relations are supported.
 319  */
 320 if ($server > 0) {
 321     require_once './libraries/relation.lib.php';
 322     $cfgRelation = PMA_getRelationsParam();
 323     if(!$cfgRelation['allworks'] && $cfg['PmaNoRelation_DisableWarning'] == false) {
 324         $message = PMA_Message::notice(__('The additional features for working with linked tables have been deactivated. To find out why click %shere%s.'));
 325         $message->addParam('<a href="' . $cfg['PmaAbsoluteUri'] . 'chk_rel.php?' . $common_url_query . '">', false);
 326         $message->addParam('</a>', false);
 327         /* Show error if user has configured something, notice elsewhere */
 328         if (!empty($cfg['Servers'][$server]['pmadb'])) {
 329             $message->isError(true);
 330         }
 331         $message->display();
 332     } // end if
 333 }
 334
 335 /**
 336  * Show warning when javascript support is missing.
 337  */
 338 echo '<noscript>';
 339 $message = PMA_Message::notice(__('Javascript support is missing or disabled in your browser, some phpMyAdmin functionality will be missing. For example navigation frame will not refresh automatically.'));
 340 $message->isError(true);
 341 $message->display();
 342 echo '</noscript>';
 343
 344 /**
 345  * Warning about different MySQL library and server version
 346  * (a difference on the third digit does not count).
 347  * If someday there is a constant that we can check about mysqlnd, we can use it instead
 348  * of strpos().
 349  * If no default server is set, PMA_DBI_get_client_info() is not defined yet.
 350  */
 351 if (function_exists('PMA_DBI_get_client_info')) {
 352     $_client_info = PMA_DBI_get_client_info();
 353     if ($server > 0 && strpos($_client_info, 'mysqlnd') === false && substr(PMA_MYSQL_CLIENT_API, 0, 3) != substr(PMA_MYSQL_INT_VERSION, 0, 3)) {
 354         trigger_error(PMA_sanitize(sprintf(__('Your PHP MySQL library version %s differs from your MySQL server version %s. This may cause unpredictable behavior.'),
 355                 $_client_info,
 356                 substr(PMA_MYSQL_STR_VERSION, 0, strpos(PMA_MYSQL_STR_VERSION . '-', '-')))),
 357             E_USER_NOTICE);
 358     }
 359     unset($_client_info);
 360 }
 361
 362 /**
 363  * Warning about Suhosin
 364  */
 365 if ($cfg['SuhosinDisableWarning'] == false && @ini_get('suhosin.request.max_value_length')) {
 366     trigger_error(PMA_sanitize(sprintf(__('Server running with Suhosin. Please refer to %sdocumentation%s for possible issues.'), '[a@./Documentation.html#faq1_38@_blank]', '[/a]')), E_USER_WARNING);
 367     }
 368
 369 /**
 370  * prints list item for main page
 371  *
 372  * @param   string  $name   displayed text
 373  * @param   string  $id     id, used for css styles
 374  * @param   string  $url    make item as link with $url as target
 375  * @param   string  $mysql_help_page  display a link to MySQL's manual
 376  * @param   string  $target special target for $url
 377  */
 378 function PMA_printListItem($name, $id = null, $url = null, $mysql_help_page = null, $target = null)
 379 {
 380     echo '<li id="' . $id . '">';
 381     if (null !== $url) {
 382         echo '<a href="' . $url . '"';
 383         if (null !== $target) {
 384            echo ' target="' . $target . '"';
 385         }
 386         echo '>';
 387     }
 388
 389     echo $name;
 390
 391     if (null !== $url) {
 392         echo '</a>' . "\n";
 393     }
 394     if (null !== $mysql_help_page) {
 395         echo PMA_showMySQLDocu('', $mysql_help_page);
 396     }
 397     echo '</li>';
 398 }
 399
 400 /**
 401  * Displays the footer
 402  */
 403 require_once './libraries/footer.inc.php';
 404 ?>