}
// Close the ODBC connection
@odbc_close($connection_id);
// End the UI form to create the trigger
print "</form>\n";
$trig_stmt = $trig_stmt . "for first row begin echo '{$trig_name} fired' end";
include "vapiOpen.php";
if ($vapiConn == 0) {
//@@@@@ Error U-NR-201: Could not connect to Vigilert
$error_number = 201;
echo include "includes/feedback/error_nr_200series.txt";
return;
}
// Create the trigger
$vapi_msg = "";
$result = vl_exec($vapiConn, $trig_stmt);
if ($result == 0) {
$vapi_msg = vl_get_message($vapiConn);
eregi("(Error:)(.*)\$", $vapi_msg, $match);
$vapi_msg = "<div class=error_r>Error A-R-666:" . $match[2] . "</div>";
$vapi_msg .= "<div class=error_r>Unable to create trigger.</div>";
} else {
$vapi_msg = "<div class=message>" . vl_get_message($vapiConn) . "</div>";
// $vapi_msg .= "<div class=message>Created trigger.</div>";
}
vl_close($vapiConn);
print "<FORM NAME=\"manage_triggers\" ACTION=\"manage_triggers.php\" METHOD=\"post\">\n";
print "<INPUT TYPE=\"hidden\" NAME=\"username\" value={$user}>\n";
print "<INPUT TYPE=\"hidden\" NAME=\"phase\" value=\"operation\">\n";
print "<INPUT TYPE=\"hidden\" NAME=\"message\" value=\"{$vapi_msg}\">\n";
print "</FORM>\n";
vl_close($vapiConn);
print "<FORM NAME=\"manage_data_sources\" ACTION=\"manage_data_sources.php\" METHOD=\"post\">";
print "<INPUT TYPE=\"hidden\" NAME=\"phase\" value=\"return\">";
print "<INPUT TYPE=\"hidden\" NAME=\"status\" VALUE=\"{$error}\">";
print "</FORM>";
print "<script language=\"javascript\">";
print "document.manage_data_sources.submit();";
print "</script>";
return;
}
$create_datasrc_lastchar = substr($create_datasrc, strlen($create_datasrc) - 1, 1);
if (strcmp($create_datasrc_lastchar, ",") == 0) {
$create_datasrc_stmt = substr_replace($create_datasrc, ")", strlen($create_datasrc) - 1, 1);
}
// Create the Data Source
$result = vl_exec($vapiConn, $create_datasrc_stmt);
vl_close($vapiConn);
$add_datasrc = $_REQUEST['add_data_source'];
print "<FORM NAME=\"get_datasrc_attr_englishname\" ACTION=\"get_datasrc_attr_englishname.php\" METHOD=\"post\">";
print "<INPUT TYPE=\"hidden\" NAME=\"action\" VALUE=\"add\">";
print "<INPUT TYPE=\"hidden\" NAME=\"add_data_source\" VALUE=\"{$add_datasrc}\">";
} else {
if (strcasecmp($user_action, "Modify") == 0) {
$modify_datasrc = $_REQUEST['modify_data_source'];
print "<FORM NAME=\"get_datasrc_attr_englishname\" ACTION=\"get_datasrc_attr_englishname.php\" METHOD=\"post\">";
print "<INPUT TYPE=\"hidden\" NAME=\"action\" VALUE=\"modify\">";
print "<INPUT TYPE=\"hidden\" NAME=\"modify_data_source\" VALUE=\"{$modify_datasrc}\">";
}
}
print "</FORM>";
print "<script language=\"javascript\">";
}
if ($row_num > 0) {
include "vapiOpen.php";
if ($vapiConn == 0) {
//@@@@@ Error A-NR-201: Could not connect to Vigilert. Host DBMS running? Vigilert service started?
$error_number = 201;
echo include "includes/feedback/error_nr_200series.txt";
return;
}
}
// $error = 1;
$vapi_msg = "";
// Drop all the triggersets for the users (belonging to the usergroup to be deleted)
for ($num_rows = 0; $num_rows < $row_num; $num_rows++) {
$drop_triggerset = "drop triggerset {$user_alias_triggerset[$num_rows]}";
$result = vl_exec($vapiConn, $drop_triggerset);
if ($result == 0) {
$vapi_msg = vl_get_message($vapiConn);
eregi("(Error:)(.*)\$", $vapi_msg, $match);
$vapi_msg = "<div class=error_r>Error A-R-666:" . $match[2] . "</div>";
// $error = 0;
} else {
$vapi_msg .= "<div class=message>" . vl_get_message($vapiConn) . "</div>";
}
}
/*
if($error != 0)
{
$vapi_msg = "<div class=message>" . vl_get_message($vapiConn) . "</div>";
}
*/
$vapi_msg = vl_get_message($vapiConn);
eregi("(Error:)(.*)\$", $vapi_msg, $match);
$vapi_msg = "<div class=error_r>Error A-R-666:" . $match[2] . "</div>";
$vapi_msg .= "<div class=error_r>{$user_action} unsuccessful on Trigger {$modify_trigger}.</div>";
} else {
$vapi_msg = "<div class=message>" . vl_get_message($vapiConn) . "</div>";
// $vapi_msg .= "<div class=message>$user_action successful on Trigger $modify_trigger.</div>";
}
vl_close($vapiConn);
} else {
if (strcasecmp($user_action, "Drop All") == 0) {
$username = $_REQUEST['username'];
$trigger_op = "drop triggerset " . $username;
$result = vl_exec($vapiConn, $trigger_op);
$trigger_op = "create triggerset " . $username;
$result = vl_exec($vapiConn, $trigger_op);
vl_close($vapiConn);
} else {
vl_close($vapiConn);
//@@@@@ Error U-NR-704: Unknown operation
$error_number = 704;
echo include "includes/feedback/error_nr_700series.txt" . $user_action . ".";
return;
}
}
print "<FORM NAME=\"manage_triggers\" ACTION=\"manage_triggers.php\" METHOD=\"post\">";
print "<INPUT TYPE=\"hidden\" NAME=\"username\" VALUE=\"{$username}\">";
print "<INPUT TYPE=\"hidden\" NAME=\"message\" VALUE=\"{$vapi_msg}\">";
print "<INPUT TYPE=\"hidden\" NAME=\"phase\" VALUE=\"operation\">";
print "</FORM>";
print "<script language=\"javascript\">";
if ($stmt_result <= 0) {
//@@@@@ Error A-NR-124: Unable to insert user information into Vigilert Pro user table
$error_number = 124;
echo include "includes/feedback/error_nr_100series.txt";
@odbc_close($connection_id);
return;
}
@odbc_close($connection_id);
include "vapiOpen.php";
if ($vapiConn == 0) {
//@@@@@ Error A-NR-201: Could not connect to Vigilert. Host DBMS running? Vigilert service started?
$error_number = 201;
echo include "includes/feedback/error_nr_200series.txt";
exit;
}
$createTSResult = vl_exec($vapiConn, "create triggerset {$username}");
$vapi_msg = "";
if ($createTSResult == 0) {
$vapi_msg = vl_get_message($vapiConn);
eregi("(Error:)(.*)\$", $vapi_msg, $match);
$vapi_msg = "<div class=error_r>Error A-R-666:" . $match[2] . "</div>";
$vapi_msg .= "<div class=error_r>Unable to add user {$username}.</div>";
} else {
$vapi_msg = "<div class=message>" . vl_get_message($vapiConn) . "</div>";
$vapi_msg .= "<div class=message>Added user {$username}.</div>";
}
vl_close($vapiConn);
print "<FORM NAME=\"manage_users\" ACTION=\"manage_users.php\" METHOD=\"post\">";
print "<INPUT TYPE=\"hidden\" NAME=\"phase\" value=\"operation\">";
print "<INPUT TYPE=\"hidden\" NAME=\"message\" value=\"{$vapi_msg}\">";
print "</FORM>";
// 1. Drop the triggerset for this user (that will in turn drop all the triggers
// created by this user).
// 2. Delete the user from vl_user table.
$user_to_be_del = $_REQUEST['del_user'];
// 1. Drop the triggerset for this user (that will in turn drop all the triggers
// created by this user).
include "vapiOpen.php";
if ($vapiConn == 0) {
//@@@@@ Error A-NR-201: Could not connect to Vigilert. Host DBMS running? Vigilert service started?
$error_number = 201;
echo include "includes/feedback/error_nr_200series.txt";
exit;
}
// As Vigilert Pro creates a triggerset for every user (with the same name as the username),
// the triggerset with the same name as the username needs to be dropped.
$result = vl_exec($vapiConn, "drop triggerset {$user_to_be_del}");
$vapi_msg = "";
if ($result == 0) {
$vapi_msg = vl_get_message($vapiConn);
eregi("(Error:)(.*)\$", $vapi_msg, $match);
$vapi_msg = "<div class=error_r>Error A-R-666:" . $match[2] . "</div>";
$vapi_msg .= "<div class=error_r>Unable to delete user {$user_to_be_del}.</div>";
} else {
$vapi_msg = "<div class=message>" . vl_get_message($vapiConn) . "</div>";
$vapi_msg .= "<div class=message>Deleted user {$user_to_be_del}.</div>";
}
vl_close($vapiConn);
// 2. Delete the user from vl_user table.
$stmt = "delete from vl_user where username = '******'";
$stmt_result = @odbc_exec($connection_id, $stmt);
if ($stmt_result <= 0) {
