*   (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);
                $tbl->setSorting(1);