home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
PC World 2001 August
/
PCWorld_2001-08_cd.bin
/
Komunikace
/
phptriad
/
phptriadsetup2-11.exe
/
htdocs
/
phpMyAdmin
/
main.php
< prev
next >
Wrap
PHP Script
|
2000-08-20
|
6KB
|
184 lines
<?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");
?>