/***************************************************************************
* *
* 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");
$Triggername = getData("Triggername");
$html = "<h1> Database " . $DB->Name($Server) . " - Trigger " . $Triggername . "</h1>";
if ($Triggername) {
$tri = new Trigger($Server);
$tri->setOwner($User);
$tri->setName($Triggername);
$tri->getData();
$html .= "<table border=0><tr><th>Tag</th><th>Value</th></tr>";
$html .= "<tr><td>Name</td><td>" . $tri->name . "</td></tr>";
$html .= "<tr><td>Owner</td><td>" . $tri->owner . "</td></tr>";
$html .= "<tr><td>Type</td><td>" . $tri->trigger_type . "</td></tr>";
$html .= "<tr><td>Triggering Event</td><td>" . $tri->triggering_event . "</td></tr>";
$html .= "<tr><td>On</td><td>" . $tri->table_owner . "." . $tri->table_name . "</td></tr>";
$html .= "<tr><td>Referencing Names</td><td>" . $tri->referencing_names . "</td></tr>";
$html .= "<tr><td>When Clause</td><td>" . $tri->when_clause . "</td></tr>";
$html .= "<tr><td>Status</td><td>" . $tri->status . "</td></tr>";
$html .= "</table>";
$html .= "<P><B>Trigger body:</b><br>";
$html .= "CREATE OR REPLACE TRIGGER " . $tri->description . "<br>" . nl2br($tri->trigger_body);
$html .= "</P>";
