home *** CD-ROM | disk | FTP | other *** search
- <?php
- /* $Id: main.php,v 1.35 2000/07/31 13:17:27 tobias Exp $ */
-
- if (!isset($message))
- {
- include("header.inc.php");
- }
- else
- {
- show_message($message);
- }
- ?>
-
- <h1><?php echo $strWelcome ?> phpMyAdmin 2.1.0</h1>
- <?php
- if ($server > 0) {
- // Don't display server info if $server==0 (no server selected)
- $res_version = mysql_query("SELECT Version() as version") or mysql_die();
- $row_version = mysql_fetch_array($res_version);
-
- echo "<b>MySQL $row_version[version] $strRunning " . $cfgServer['host'];
- if (!empty($cfgServer['port'])) {
- echo ":" . $cfgServer['port'];
- }
- echo "</b><br>\n";
- }
- ?>
- <div align="left">
- <?php
-
- if (($server > 0) && isset($mode) && ($mode == "reload"))
- {
- $result = mysql_query("FLUSH PRIVILEGES");
- if ($result != 0) {
- echo "<b>$strMySQLReloaded</b>";
- } else {
- echo "<b>$strReloadFailed</b>";
- }
- }
- ?>
- <ul>
- <?php
- if(count($cfgServers) > 1)
- {
- echo "<li>";
- echo '<form action="index.php" target="_top"><select name="server">';
-
- reset($cfgServers);
- while(list($key, $val) = each($cfgServers))
- {
- if(!empty($val['host']))
- {
- echo "<option value=\"$key\"";
- if(!empty($server) && ($server == $key))
- {
- echo " selected";
- }
- echo ">";
- print(!empty($val['verbose']) ? $val['verbose'] : $val['host']);
-
- if(!empty($val['port']))
- {
- echo ":" . $val['port'];
- }
- if(!empty($val['only_db']))
- echo " - ".$val['only_db'];
- echo "\n";
- }
- }
- echo '</select><input type="submit" value="'.$strGo.'"></form>';
- }
-
- if($server > 0)
- {
- // Don't display server-related links if $server==0 (no server selected)
- if(empty($cfgServer['only_db']))
- {
- if($cfgServer['adv_auth'])
- {
- if (empty($cfgServer['port']))
- {
- $dbh = mysql_connect($cfgServer['host'],$cfgServer['stduser'],$cfgServer['stdpass']);
- }
- else
- {
- $dbh = mysql_connect($cfgServer['host'].":".$cfgServer['port'],$cfgServer['stduser'],$cfgServer['stdpass']);
- }
-
- $rs_usr=mysql_db_query("mysql","select * from user where User=\"".$cfgServer['user']."\"",$dbh);
- $result_usr=mysql_fetch_array($rs_usr);
- $rs_db=mysql_db_query("mysql","select * from db where User=\"".$cfgServer['user']."\"",$dbh);
-
- if(mysql_num_rows($rs_db)>0)
- {
- $result_db=mysql_fetch_array($rs_db);
- }
-
- if($result_usr['Create_priv']=='Y')
- {
- $CREATE=TRUE;
- }
- elseif(!empty($result_db) && $result_db['Create_priv']=='Y')
- {
- $CREATE=TRUE;
- }
- else
- {
- $CREATE=FALSE;
- }
-
- if($CREATE)
- {
- ?>
- <li>
- <form method="post" action="db_create.php">
- <?php echo $strCreateNewDatabase;?> <?php print show_docu("manual_Reference.html#Create_database");?><br><input type="Hidden" name="server" value="<?php echo $server; ?>"><input type="hidden" name="reload" value="true"><input type="text" name="db"><input type="submit" value="<?php echo $strCreate; ?>">
- </form>
- <?php
- }
-
- if($result_usr['References_priv']=='Y')
- {
- ?>
- <li><a href="sql.php?server=<?php echo $server;?>&db=mysql&sql_query=<?php echo urlencode("SHOW STATUS");?>">
- <?php echo $strMySQLShowStatus;?></a> <?php print show_docu("manual_Reference.html#Show");?>
-
- <li><a href="sql.php?server=<?php echo $server;?>&db=mysql&sql_query=<?php echo urlencode("SHOW VARIABLES");?>">
- <?php echo $strMySQLShowVars;?></a> <?php print show_docu("manual_Performance.html#Performance");
- }
-
- if($result_usr['Process_priv']=='Y')
- {
- ?>
- <li><a href="sql.php?server=<?php echo $server;?>&db=mysql&sql_query=<?php echo urlencode("SHOW PROCESSLIST");?>">
- <?php echo $strMySQLShowProcess;?></a> <?php print show_docu("manual_Reference.html#Show");
- }
-
- if($result_usr['Reload_priv']=='Y')
- {
- ?>
- <li>
- <a href="main.php?server=<?php echo $server;?>&mode=reload"><?php echo $strReloadMySQL; ?></a> <?php print show_docu("manual_Reference.html#Flush");
- }
- ?>
- <li><a href="index.php?server=<?php echo $server;?>&old_usr=<?php echo $PHP_AUTH_USER;?>" target="_top"><?php echo $strLogout; ?></a>
- <?php
- }
- else
- { //No AdvAuth
- ?>
- <li>
- <form method="post" action="db_create.php">
- <?php echo $strCreateNewDatabase;?> <?php print show_docu("manual_Reference.html#Create_database");?><br><input type="Hidden" name="server" value="<?php echo $server; ?>"><input type="hidden" name="reload" value="true"><input type="text" name="db"><input type="submit" value="<?php echo $strCreate; ?>">
- </form>
- <li><a href="sql.php?server=<?php echo $server;?>&db=mysql&sql_query=<?php echo urlencode("SHOW STATUS");?>">
- <?php echo $strMySQLShowStatus;?></a> <?php print show_docu("manual_Reference.html#Show");?>
- <li><a href="sql.php?server=<?php echo $server;?>&db=mysql&sql_query=<?php echo urlencode("SHOW VARIABLES");?>">
- <?php echo $strMySQLShowVars;?></a> <?php print show_docu("manual_Performance.html#Performance");?>
- <li><a href="sql.php?server=<?php echo $server;?>&db=mysql&sql_query=<?php echo urlencode("SHOW PROCESSLIST");?>">
- <?php echo $strMySQLShowProcess;?></a> <?php print show_docu("manual_Reference.html#Show");?>
- <li>
- <a href="main.php?server=<?php echo $server;?>&mode=reload"><?php echo $strReloadMySQL; ?></a> <?php print show_docu("manual_Reference.html#Flush");
- }
- }
- }
- ?>
-
- <li>
- <a href="http://phpwizard.net/projects/phpMyAdmin/" target="_top">phpMyAdmin-Homepage</a>
- <li>
- <a href="Documentation.html" target="_top">phpMyAdmin <?php print $strDocu;?></a>
- </ul>
- <?php
- if(!get_magic_quotes_gpc())
- {
- print($strEnableMagicQuotes);
- }
- ?>
-
- </div>
-
- <?php
- require ("footer.inc.php");
- ?>