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");
$tri = new Trigger($Server);
$tri->getDatas($User);
$html = "<H1> Database " . $DB->Name($Server) . " - Trigger overview of User {$User}</H1>\n";
$html .= "<TABLE BORDER=0>\n<TR><TH>Name</TH><TH>Type</TH><TH>On</TH><TH>Status</TH></TR>\n";
$x = 0;
if (is_array($tri->datas[$User])) {
foreach ($tri->datas[$User] as $trigger) {
$html .= $x % 2 ? "<tr bgcolor=\"#EEEEEE\" valign=top>" : "<tr bgcolor=\"#CCCCCC\" valign=top>";
$html .= "<td class=data><b>" . $trigger["TRIGGER_NAME"] . "</b></td>";
$html .= "<td>" . $trigger["TYPE"] . "</td>";
$html .= "<td>" . $trigger["TABLE_OWNER"] . "." . $trigger["TABLE_NAME"] . "</td>";
$html .= "<td>" . $trigger["STATUS"] . "</td>";
$html .= "</tr>";
$x++;
}
}
$html .= "</table>";
