$menu->registerMenu("rownum", "Rowcount", $defaultget . "mode=main&submode=rownum&" . SID, "images/rowcount.gif");
$menu->registerMenu("rename1", "Rename", $defaultget . "mode=main&submode=rename1&" . SID, "images/rename.gif");
$menu->registerMenu("truncate1", "Truncate", $defaultget . "mode=main&submode=truncate1&" . SID, "images/truncate.gif");
$menu->registerMenu("drop1", "Drop", $defaultget . "mode=main&submode=drop1&" . SID, "images/drop.gif");
$menu->selectMenu($submode);
$menu->renderHTML();
$html = $menu->getHTML();
unset($menu);
$html .= "<br>";
/*
$html.="<a href=\"".$defaultget."mode=main&submode=analyze&".SID."\">".
"<img border=0 src=\"images/analyze.gif\" alt=\"Analyze Table $Tablename\" width=32 height=32><br>Analyze</a>";
$html.="</td><td align=center>";
*/
$menu = new MenuBar();
$menu->registerMenu("main", "Main", $defaultget . "mode=main&" . SID);
$menu->registerMenu("column", "Column Data", $defaultget . "mode=column&" . SID);
$menu->registerMenu("indizes", "Indizes", $defaultget . "mode=indizes&" . SID);
$menu->registerMenu("info", "Table Info", $defaultget . "mode=info&" . SID);
$menu->registerMenu("content", "Table Content", $defaultget . "mode=content&" . SID);
$menu->registerMenu("constraints", "Constraints", $defaultget . "mode=constraints&" . SID);
$menu->registerMenu("triggers", "Triggers", $defaultget . "mode=triggers&" . SID);
$menu->selectMenu($mode);
$menu->renderHTML();
$html .= $menu->getHTML();
unset($menu);
$html .= "<h1> Database " . $DB->Name($Server) . " - Table " . $Tablename . "</h1>";
// different views
switch ($mode) {
case "column":
switch ($submode) {
* 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");
$defaultget = getData("PHP_SELF") . "?Server={$Server}&";
$mode = getData("mode");
$submode = getData("submode");
if (!$mode) {
$mode = "main";
}
$Sortorder = getData("Sortorder");
$Sortfield = getData("Sortfield");
$menu = new MenuBar();
$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);
* 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");
$Tablespacename = getData("Tablespacename");
$Tablespacenameurl = rawurlencode($Tablespacename);
$Sortorder = getData("Sortorder");
$Sortfield = getData("Sortfield");
$mode = getData("mode");
$submode = getData("submode");
$defaultget = getData("PHP_SELF") . "?Server={$Server}&Tablespacename={$Tablespacenameurl}&";
$menu = new MenuBar();
$menu->registerMenu("info", "Overview", $defaultget . "mode=info&" . SID);
$menu->registerMenu("datafiles", "Datafiles", $defaultget . "mode=datafiles&" . SID);
//$menu->registerMenu("users", "Users", $defaultget."mode=users&".SID);
$menu->selectMenu($mode);
$menu->renderHTML();
$html = $menu->getHTML();
unset($menu);
$html .= "<h1> Database " . $DB->Name($Server) . " - Tablespace " . $Tablespacename . "</h1>";
// different views
switch ($mode) {
case "info":
switch ($submode) {
default:
$tblsp = new Tablespace($Server);
$tblsp->setName($Tablespacename);
$tblsp->getData();