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();
***************************************************************************/ /*************************************************************************** * * * 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"); $User = getData("User"); $Userurl = rawurlencode($User); $tbl = new Table($Server); $tbl->getDatas($User); $html = "<H1> Database " . $DB->Name($Server) . " - Table overview of User {$User}</H1>\n"; $dtbl = new DataTable($Server); $dtbl->setSorting(0); $dtbl->setData($tbl->datas[$User]); unset($tbl); $dtbl->setColorToggle(1); $dtbl->setDataLink("TABLE_NAME", "tbl_detail.php?Server={$Server}&Tablename=\$value&User={$Userurl}&" . SID); $dtbl->renderHTML(); $html .= $dtbl->getHTML(); unset($dtbl); $page = new Page("Table Overview"); $page->setHead(); $page->setBody(); $page->setSQL(); $page->setBody($html); $page->Display();
$html .= $tbl->getHTML(); unset($tbl); } // end submode content break; case "triggers": switch ($submode) { default: $tbl = new DataTable($Server); $tbl->setSql(sprintf("select TRIGGER_NAME \"Trigger Name\", TRIGGER_TYPE \"Type\", " . "status \"Status\", triggering_event \"Triggering on\" " . "from all_triggers where table_name='%s' and table_owner='%s'", $Tablename, $User)); $tbl->setSorting(1); $tbl->setSort($Sortfield, $Sortorder); $tbl->loadData(); $tbl->setColorToggle(1); if ($CF->get("ENABLE_TRIGGERS")) { $tbl->setDataLink("Trigger Name", "tri_detail.php?Server={$Server}&Triggername=\$value&User={$Userurl}&" . SID); } $tbl->renderHTML($defaultget . "mode={$mode}&" . SID); $html .= $tbl->getHTML(); unset($tbl); } // end submode content break; case "main": switch ($submode) { case "rownum": $html .= "<h1>Number of Rows</h1>"; $tbl = new DataTable($Server); $tbl->setSql("SELECT COUNT(*) FROM {$User}.{$Tablename}"); $tbl->loadData(); $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) { default: } // end switch submode break; } $page = new Page("Tablespace Management - " . $Tablespacename);