copyright : (C) 2000 by Thomas Fromm
email : tf@tfromm.com
***************************************************************************/
/***************************************************************************
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or *
* (at your option) any later version. *
* *
***************************************************************************/
include "prepend.inc.php";
$Server = getData("Server", "integer");
$Sortorder = getData("Sortorder");
$Sortfield = rawurldecode(getData("Sortfield"));
$html = "<H1> Database " . $DB->Name($Server) . " - Tablespace Overview</H1>\n";
$tbl = new DataTable($Server);
$tbl->setSql("SELECT tablespace_name \"Tablespace Name\", initial_extent \"Initial Extent\", " . "next_extent \"Next Extent\", min_extents \"Min Extents\", max_extents \"Max Extents\", " . "pct_increase \"% Increase\", status \"Status\" FROM dba_tablespaces order by \"Tablespace Name\"");
$tbl->setSorting(1);
$tbl->setSort($Sortfield, $Sortorder);
$tbl->loadData();
$tbl->setColorToggle(1);
$tbl->setDataLink("Tablespace Name", "tblsp_detail.php?Server={$Server}&Tablespacename=\$value&" . SID);
$tbl->renderHTML("tblsp_main.php?Server={$Server}&" . SID);
$html .= $tbl->getHTML();
$page = new Page("Tablespace Overview");
$page->setHead();
$page->setBody();
$page->setSQL();
$page->setBody($html);
$page->Display();
$menu->registerMenu("main", "Main", $defaultget . "mode=main&" . SID);
$menu->selectMenu($mode);
$menu->renderHTML();
$html = $menu->getHTML();
unset($menu);
$html .= "<h1> Database " . $DB->Name($Server) . " - User " . $DB->User($Server) . "</h1>";
// different views
switch ($mode) {
case "main":
switch ($submode) {
case "execute":
$statement = trim(getData("statement"));
$html .= "<form action=\"database_detail.php\" method=\"post\" enctype=\"application/x-www-form-urlencoded\">" . "<input type=\"hidden\" name=\"Server\" value=\"{$Server}\">" . "<input type=\"hidden\" name=\"mode\" value=\"main\">" . "<input type=\"hidden\" name=\"submode\" value=\"execute\">" . "<textarea name=\"statement\" cols=\"80\" rows=\"5\" wrap=\"VIRTUAL\" style=\"width: 400px\">" . $statement . "</textarea><br>" . "<input type=\"Submit\" name=\"BUTTON\" value=\"Execute\">";
$html .= "</form></td></tr></table>";
$tbl = new DataTable($Server);
$tbl->setSql($statement);
$tbl->setSorting(1);
$tbl->setSort($Sortfield, $Sortorder);
$tbl->loadData();
$tbl->setColorToggle(1);
$tbl->renderHTML($defaultget . "mode={$mode}&submode={$submode}&statement=" . rawurlencode($statement) . "&" . SID);
$html .= $tbl->getHTML();
unset($tbl);
break;
default:
$html .= "<P>Execute SQL Statement:<br>" . "<form action=\"database_detail.php\" method=\"post\" enctype=\"application/x-www-form-urlencoded\">" . "<input type=\"hidden\" name=\"Server\" value=\"{$Server}\">" . "<input type=\"hidden\" name=\"mode\" value=\"main\">" . "<input type=\"hidden\" name=\"submode\" value=\"execute\">" . "<textarea name=\"statement\" cols=\"80\" rows=\"5\" wrap=\"VIRTUAL\" style=\"width: 400px\"></textarea><br>" . "<input type=\"Submit\" name=\"BUTTON\" value=\"Execute\">";
$html .= "</form></td></tr></table></p>";
}
break;
default:
}
$tbl = new Datatable($Server);
$tbl->setSorting(0);
$tbl->setData($data);
unset($data);
$tbl->setColorToggle(1);
$tbl->renderHTML();
$html .= $tbl->getHTML();
unset($tbl);
}
// end switch submode
break;
case "datafiles":
switch ($submode) {
default:
$tbl = new DataTable($Server);
$tbl->setSql(sprintf("SELECT file_name \"Filename\", bytes / 1024 \"Kilobytes\", " . "status \"Status\" FROM dba_data_files WHERE tablespace_name = '%s' " . "ORDER BY file_name", $Tablespacename));
$tbl->setSorting(1);
$tbl->setSort($Sortfield, $Sortorder);
$tbl->loadData();
$tbl->setColorToggle(1);
if ($CF->get("ENABLE_DATAFILES")) {
$tbl->setDataLink("Filename", "datafile_detail.php?Server={$Server}&Datafilename=\$value&" . "Tablespacename={$Tablespacenameurl}&" . SID);
}
$tbl->renderHTML($defaultget . "mode={$mode}&" . SID);
$html .= $tbl->getHTML();
unset($tbl);
}
// end switch submode
break;
case "users":
switch ($submode) {
