}
$tree = new HTMLTree($GLOBALS[HTMLTREE_GET_VAR]);
} else {
$tree = new Tree();
}
$tree->setForeignFrame("phpmain");
$tree->setIconPath("images");
$serverroot = $tree->openTree("Databases Overview", "main.php?" . SID);
for ($Server = 0; $Server < count($DB->DBDatas); $Server++) {
// build the serverfolder
${"root" . $Server} = $tree->addFolder($serverroot, $DB->User($Server) . "@" . $DB->Name($Server), "database_detail.php?Server={$Server}&" . SID);
//functions
if ($CF->get("ENABLE_FUNCTIONS")) {
$functions = $tree->addFolder(${"root" . $Server}, "Functions", "");
if (!$CF->get("ENABLE_HTML_TREE") || in_array($functions, $tree->opened)) {
$func = new OraFunction($Server);
$func->getNames();
foreach ($func->names as $username => $names) {
$usernameraw = rawurlencode($username);
$user = $tree->addFolder($functions, $username . " (" . count($names) . ")", "func_main.php?Server={$Server}&User={$usernameraw}&" . SID);
if (is_array($names)) {
foreach ($names as $name) {
$tree->addDocument($user, $name, "func_detail.php?Server={$Server}&Functionname={$name}&User={$usernameraw}&" . SID);
}
}
}
$func->destruct();
} else {
// insert one object
$tree->addFolder($functions, 0, 0);
}
begin : Sam Nov 25 18:08:45 CET 2000
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");
$User = getData("User");
$func = new OraFunction($Server);
$func->getDatas($User);
$html = "<H1> Database " . $DB->Name($Server) . " - Function overview of User {$User}</H1>\n";
$html .= "<TABLE BORDER=0>\n<TR><TH>Name</TH><TH>Created</TH><TH>Last Modified</TH><TH>Status</TH></TR>\n";
$x = 0;
if (is_array($func->datas[$User])) {
foreach ($func->datas[$User] as $funct) {
$html .= $x % 2 ? "<tr bgcolor=\"#EEEEEE\" valign=top>" : "<tr bgcolor=\"#CCCCCC\" valign=top>";
$html .= "<td class=data><b>" . $funct["OBJECT_NAME"] . "</b></td>";
$html .= "<td>" . $funct["CREATED"] . "</td>";
$html .= "<td>" . $funct["LASTMODIFIED"] . "</td>";
$html .= "<td>" . $funct["STATUS"] . "</td>";
$html .= "</tr>";
$x++;
}
}
***************************************************************************/
/***************************************************************************
* *
* 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");
$Functionname = getData("Functionname");
$html = "<h1> Database " . $DB->Name($Server) . " - Function " . $Functionname . "</h1>";
if ($Functionname) {
$func = new OraFunction($Server);
$func->setOwner($User);
$func->setName($Functionname);
$func->getData();
$html .= "<table border=0><tr><th>Tag</th><th>Value</th></tr>";
$html .= "<tr><td>Name</td><td>" . $func->name . "</td></tr>";
$html .= "<tr><td>Owner</td><td>" . $func->owner . "</td></tr>";
$html .= "<tr><td>Created</td><td>" . $func->created . "</td></tr>";
$html .= "<tr><td>Last Modified</td><td>" . $func->lastmodified . "</td></tr>";
$html .= "<tr><td>Status</td><td>" . $func->status . "</td></tr>";
$html .= "</table>";
$html .= "<P><B>Function body:</b><br>";
$html .= nl2br($func->sql) . "<br>";
$html .= "</P>";
}
$page = new Page("Function Properties");
