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>' . $strActions . '</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($strChangePassword, '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>' . $strLogout . '</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        . '                ' . $strMySQLConnectionCollation . ': ' . "\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="' . $strGo . '" /></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>' . $strInterface . '</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($strCustomColor) . ': ';
 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="' . $strReset . '" />';
 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 echo '</div>';
 175
 176
 177 echo '</div>';
 178 echo '<div id="main_pane_right">';
 179
 180
 181 if ($server > 0 && $GLOBALS['cfg']['ShowServerInfo']) {
 182     echo '<div class="group">';
 183     echo '<h2>MySQL</h2>';
 184     echo '<ul>' . "\n";
 185     PMA_printListItem($strServer . ': ' . $server_info, 'li_server_info');
 186     PMA_printListItem($strServerVersion . ': ' . PMA_MYSQL_STR_VERSION, 'li_server_version');
 187     PMA_printListItem($strProtocolVersion . ': ' . PMA_DBI_get_proto_info(),
 188         'li_mysql_proto');
 189     PMA_printListItem($strUser . ': ' . htmlspecialchars($mysql_cur_user_and_host),
 190         'li_user_info');
 191
 192     echo '    <li id="li_select_mysql_charset">';
 193     echo '        ' . $strMySQLCharset . ': '
 194        . '        <span xml:lang="en" dir="ltr">'
 195        . '           ' . $mysql_charsets_descriptions[$mysql_charset_map[strtolower($charset)]] . "\n"
 196        . '           (' . $mysql_charset_map[strtolower($charset)] . ')' . "\n"
 197        . '        </span>' . "\n"
 198        . '    </li>' . "\n";
 199     echo '  </ul>';
 200     echo ' </div>';
 201 }
 202
 203 if ($GLOBALS['cfg']['ShowServerInfo'] || $GLOBALS['cfg']['ShowPhpInfo']) {
 204     echo '<div class="group">';
 205     echo '<h2>' . $strWebServer . '</h2>';
 206     echo '<ul>';
 207     if ($GLOBALS['cfg']['ShowServerInfo']) {
 208         PMA_printListItem($_SERVER['SERVER_SOFTWARE'], 'li_web_server_software');
 209
 210         if ($server > 0) {
 211             PMA_printListItem($strMysqlClientVersion . ': ' . PMA_DBI_get_client_info(),
 212                 'li_mysql_client_version');
 213             PMA_printListItem($strPHPExtension . ': ' . $GLOBALS['cfg']['Server']['extension'],
 214                 'li_used_php_extension');
 215         }
 216     }
 217
 218     if ($cfg['ShowPhpInfo']) {
 219         PMA_printListItem($strShowPHPInfo, 'li_phpinfo', './phpinfo.php?' . $common_url_query);
 220     }
 221     echo '  </ul>';
 222     echo ' </div>';
 223 }
 224
 225 echo '<div class="group">';
 226 echo '<h2>phpMyAdmin</h2>';
 227 echo '<ul>';
 228 PMA_printListItem($strVersionInformation . ': ' . PMA_VERSION, 'li_pma_version');
 229 PMA_printListItem($strDocu, 'li_pma_docs', 'Documentation.html', null, '_blank');
 230 PMA_printListItem($strWiki, 'li_pma_wiki', 'http://wiki.phpmyadmin.net', null, '_blank');
 231
 232 // does not work if no target specified, don't know why
 233 PMA_printListItem($strHomepageOfficial, 'li_pma_homepage', 'http://www.phpMyAdmin.net/', null, '_blank');
 234 ?>
 235     <li><bdo xml:lang="en" dir="ltr">
 236         [<a href="changelog.php" target="_blank">ChangeLog</a>]
 237         [<a href="http://phpmyadmin.git.sourceforge.net/git/gitweb-index.cgi"
 238             target="_blank">Git</a>]
 239         [<a href="http://sourceforge.net/mail/?group_id=23067"
 240             target="_blank">Lists</a>]
 241         </bdo>
 242     </li>
 243     </ul>
 244  </div>
 245
 246 </div>
 247
 248 <?php
 249 /**
 250  * BUG: MSIE needs two <br /> here, otherwise it will not extend the outer div to the
 251  * full height of the inner divs
 252  */
 253 ?>
 254 <br class="clearfloat" />
 255 <br class="clearfloat" />
 256 </div>
 257
 258 <?php
 259 /**
 260  * Warning if using the default MySQL privileged account
 261  * modified: 2004-05-05 mkkeck
 262  */
 263 if ($server != 0
 264  && $cfg['Server']['user'] == 'root'
 265  && $cfg['Server']['password'] == '') {
 266     trigger_error($strInsecureMySQL, E_USER_WARNING);
 267 }
 268
 269 /**
 270  * Nijel: As we try to handle charsets by ourself, mbstring overloads just
 271  * break it, see bug 1063821.
 272  */
 273 if (@extension_loaded('mbstring') && @ini_get('mbstring.func_overload') > 1) {
 274     trigger_error($strMbOverloadWarning, E_USER_WARNING);
 275 }
 276
 277 /**
 278  * Nijel: mbstring is used for handling multibyte inside parser, so it is good
 279  * to tell user something might be broken without it, see bug #1063149.
 280  */
 281 if (! @extension_loaded('mbstring')) {
 282     trigger_error($strMbExtensionMissing, E_USER_WARNING);
 283 }
 284
 285 /**
 286  * Check whether session.gc_maxlifetime limits session validity.
 287  */
 288 $gc_time = (int)@ini_get('session.gc_maxlifetime');
 289 if ($gc_time < $GLOBALS['cfg']['LoginCookieValidity'] ) {
 290     trigger_error(PMA_Message::decodeBB($strSessionGCWarning), E_USER_WARNING);
 291 }
 292
 293 /**
 294  * Check if user does not have defined blowfish secret and it is being used.
 295  */
 296 if (!empty($_SESSION['auto_blowfish_secret']) &&
 297         empty($GLOBALS['cfg']['blowfish_secret'])) {
 298     trigger_error($strSecretRequired, E_USER_WARNING);
 299 }
 300
 301 /**
 302  * Check for existence of config directory which should not exist in
 303  * production environment.
 304  */
 305 if (file_exists('./config')) {
 306     trigger_error($strConfigDirectoryWarning, E_USER_WARNING);
 307 }
 308
 309 /**
 310  * Check whether relations are supported.
 311  */
 312 if ($server > 0) {
 313     require_once './libraries/relation.lib.php';
 314     $cfgRelation = PMA_getRelationsParam();
 315     if(!$cfgRelation['allworks'] && $cfg['PmaNoRelation_DisableWarning'] == false) {
 316         $message = PMA_Message::notice('strRelationNotWorking');
 317         $message->addParam('<a href="' . $cfg['PmaAbsoluteUri'] . 'chk_rel.php?' . $common_url_query . '">', false);
 318         $message->addParam('</a>', false);
 319         /* Show error if user has configured something, notice elsewhere */
 320         if (!empty($cfg['Servers'][$server]['pmadb'])) {
 321             $message->isError(true);
 322         }
 323         $message->display();
 324     } // end if
 325 }
 326
 327 /**
 328  * Show warning when javascript support is missing.
 329  */
 330 echo '<noscript>';
 331 $message = PMA_Message::notice('strJavascriptDisabled');
 332 $message->isError(true);
 333 $message->display();
 334 echo '</noscript>';
 335
 336 /**
 337  * Warning about different MySQL library and server version
 338  * (a difference on the third digit does not count).
 339  * If someday there is a constant that we can check about mysqlnd, we can use it instead
 340  * of strpos().
 341  * If no default server is set, PMA_DBI_get_client_info() is not defined yet.
 342  */
 343 if (function_exists('PMA_DBI_get_client_info')) {
 344     $_client_info = PMA_DBI_get_client_info();
 345     if ($server > 0 && strpos($_client_info, 'mysqlnd') === false && substr(PMA_MYSQL_CLIENT_API, 0, 3) != substr(PMA_MYSQL_INT_VERSION, 0, 3)) {
 346         trigger_error(PMA_sanitize(sprintf($strMysqlLibDiffersServerVersion,
 347                 $_client_info,
 348                 substr(PMA_MYSQL_STR_VERSION, 0, strpos(PMA_MYSQL_STR_VERSION . '-', '-')))),
 349             E_USER_NOTICE);
 350     }
 351     unset($_client_info);
 352 }
 353
 354 /**
 355  * Warning about Suhosin
 356  */
 357 if ($cfg['SuhosinDisableWarning'] == false && @ini_get('suhosin.request.max_value_length')) {
 358     trigger_error(PMA_sanitize(sprintf($strSuhosin, '[a@./Documentation.html#faq1_38@_blank]', '[/a]')), E_USER_WARNING);
 359     }
 360
 361 /**
 362  * prints list item for main page
 363  *
 364  * @param   string  $name   displayed text
 365  * @param   string  $id     id, used for css styles
 366  * @param   string  $url    make item as link with $url as target
 367  * @param   string  $mysql_help_page  display a link to MySQL's manual
 368  * @param   string  $target special target for $url
 369  */
 370 function PMA_printListItem($name, $id = null, $url = null, $mysql_help_page = null, $target = null)
 371 {
 372     echo '<li id="' . $id . '">';
 373     if (null !== $url) {
 374         echo '<a href="' . $url . '"';
 375         if (null !== $target) {
 376            echo ' target="' . $target . '"';
 377         }
 378         echo '>';
 379     }
 380
 381     echo $name;
 382
 383     if (null !== $url) {
 384         echo '</a>' . "\n";
 385     }
 386     if (null !== $mysql_help_page) {
 387         echo PMA_showMySQLDocu('', $mysql_help_page);
 388     }
 389     echo '</li>';
 390 }
 391
 392 /**
 393  * Displays the footer
 394  */
 395 require_once './libraries/footer.inc.php';
 396 ?>