/***************************************************************************
* *
* 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");
$Procedurename = getData("Procedurename");
$html = "<h1> Database " . $DB->Name($Server) . " - Procedure " . $Procedurename . "</h1>";
if ($Procedurename) {
$proc = new Procedure($Server);
$proc->setOwner($User);
$proc->setName($Procedurename);
$proc->getData();
$html .= "<table border=0><tr><th>Tag</th><th>Value</th></tr>";
$html .= "<tr><td>Name</td><td>" . $proc->name . "</td></tr>";
$html .= "<tr><td>Owner</td><td>" . $proc->owner . "</td></tr>";
$html .= "<tr><td>Created</td><td>" . $proc->created . "</td></tr>";
$html .= "<tr><td>Last Modified</td><td>" . $proc->lastmodified . "</td></tr>";
$html .= "<tr><td>Status</td><td>" . $proc->status . "</td></tr>";
$html .= "</table>";
$html .= "<P><B>Procedure body:</b><br>";
$html .= nl2br($proc->sql) . "<br>";
$html .= "</P>";
}
$page = new Page("Procedure Properties");
$page->setHead();
