<?php
include "config.php";
if (!check_feature(40)) {
feature_error();
exit;
}
$agency_index = $_REQUEST["agency_index"];
echo "<center><table border=0 width=100%>";
$name = $_REQUEST["name"];
if (strlen($name) <= 0) {
$error = 1;
}
if ($error == 1) {
echo "<tr><td><font face=Arial size=2 color=#CC0000>Error {$error} : The name of the agency was left blank </font></b></td></tr>";
}
$type = $_REQUEST["type"];
$address = mysql_real_escape_string($_REQUEST["address"]);
$contact_phone = $_REQUEST["contact_phone"];
$contact_fax = $_REQUEST["contact_fax"];
$contact_email = $_REQUEST["contact_email"];
$prim_contact = $_REQUEST["prim_contact"];
$prim_phone = $_REQUEST["prim_phone"];
$prim_email = $_REQUEST["prim_email"];
$sec_contact = $_REQUEST["sec_contact"];
$sec_phone = $_REQUEST["sec_phone"];
$sec_email = $_REQUEST["sec_email"];
$comments = mysql_real_escape_string($_REQUEST["comments"]);
$payment_terms = mysql_real_escape_string($_REQUEST["payment_terms"]);
$bank_info = mysql_real_escape_string($_REQUEST["bank_info"]);
if ($error > 0) {
<?php
include_once "config.php";
if (!check_feature(47)) {
feature_error();
exit;
}
$ticket_id = $_REQUEST["ticket_id"];
$project = trim($_REQUEST["project"]);
$action = "DRAFT";
$action_by = $username;
$action_date = mktime();
if (strlen($project) > 0) {
$sql = "insert into rca_master(activity_id,project,action,action_by,action_date)values ('{$ticket_id}','{$project}','{$action}','{$action_by}','{$action_date}')";
$result = mysql_query($sql);
?>
<h3>An RCA has been attached with this ticket with an ID <?php
echo $ticket_id;
?>
<input type="button" value="Close" onclick="window.close()" class=forminputbutton>
<?php
}
<?php
include "config.php";
if (!check_feature(11)) {
feature_error();
exit;
}
$office_index = $_REQUEST["office_index"];
$sql_1 = "select * from asset where office_index={$office_index}";
$result_1 = mysql_query($sql_1);
$result_1_count = mysql_num_rows($result_1);
$sql_2 = "select * from user_master where office_index={$office_index}";
$result_2 = mysql_query($sql_2);
$result_2_count = mysql_num_rows($result_2);
if ($result_1_count or $result_2_count) {
echo "<script type='text/javascript'>";
echo "alert('Cannot Delete Location; There are Assets / Users associated with this Location')";
echo "</script>";
} else {
$sql = "delete from office_locations where office_index='{$office_index}'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
}
?>
<meta http-equiv="Refresh" content="0; URL=office_locations.php">
<?php
include_once "config.php";
if (!check_feature(50)) {
feature_error();
exit;
}
$activity_id = clean_string($_REQUEST["activity_id"]);
$approver = explode("||", $_REQUEST["approver"]);
$approver_name = $approver[0];
$approver_email = $approver[1];
$action = "ADDED";
$action_by = $username;
$action_date = mktime();
$approver_key = "";
if (strlen($approver_email) > 0) {
$sql = "select count(*) from poa_approval_history where activity_id='{$activity_id}'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$item_order = $row[0] + 1;
$sql = "insert into poa_approval_history (activity_id,action,action_by,action_date,item_order,approver_name,approver_email,approver_key) values ('{$activity_id}','{$action}','{$action_by}','{$action_date}','{$item_order}','{$approver_name}','{$approver_email}','{$approver_key}')";
$result = mysql_query($sql);
}
?>
<meta http-equiv="REFRESH" content="0;URL=pa_edit_1.php?activity_id=<?php
echo $activity_id;
?>
">
<?php
include "config.php";
if (!check_feature(9)) {
feature_error();
exit;
}
$SELECTED = "ADD OFFICE LOCATION";
include "header.php";
?>
<form method=POST action=office_locations_add_2.php>
<table border=0 cellpadding=0 cellspacing=0 width=100% bgcolor=#F7F7F7>
<tr>
<td class='tdformlabel'><b> Registered Name & Address</font></b></td>
<td align=right><textarea rows="5" name="address" cols="72" class='formtextarea'></textarea></td>
</tr>
<tr>
<td class='tdformlabel'><b> Location</font></b></td>
<td align=right><input name="country" size="70" class='forminputtext'></td>
</tr>
<tr>
<td class='tdformlabel'><b> Phone</font></b></td>
<td align=right><input name="phone" size="70" class='forminputtext'></td>
</tr>
<tr>
<td class='tdformlabel'><b> Fax</font></b></td>
<td align=right><input name="fax" size="70" class='forminputtext'></td>
</tr>
<tr>
<?php
include "config.php";
if (!check_feature(19)) {
feature_error();
exit;
}
$service = $_REQUEST["service"];
$sql = "delete from services where service='{$service}'";
$result = mysql_query($sql);
$sql = "delete from service_properties where service='{$service}'";
$result = mysql_query($sql);
$sql = "delete from group_service where service='{$service}'";
$result = mysql_query($sql);
?>
<meta http-equiv="Refresh" content="1; URL=service_list.php">
<?php
/*******************************************************************************************************
Auth: Aneesh
Creation Date: 18/05/2012
Function: Display the UI for adding an email and query to insert the details to DB
*******************************************************************************************************/
include "config.php";
if (!check_feature(31)) {
feature_error();
exit;
}
$host_id = $_REQUEST["host_id"];
$hostname = $_REQUEST["hostname"];
$hidden_host_id = $_REQUEST["hidden_host_id"];
$email_id = $_REQUEST["txt_email"];
$email_status = $_REQUEST["select_status"];
$continuos_alerts = $_REQUEST["continuos_alerts"];
$created_time = date('Y-m-d H:i:s');
if ($email_id == "" || $email_status == "") {
$SELECTED = "HOST UP E-MAIL NOTIFICATION : " . $hostname;
include "header.php";
?>
<form method="POST" action="email_add_sysup.php">
<input type="hidden" name="hidden_host_id" value="<?php
echo $host_id;
?>
">
<table border=0 cellpadding=3 cellspacing=1 width=1000 bgcolor=#F7F7F7>
<tr>
<td class='tdformlabel'>
feature_error();
exit;
}
$sql = "insert into business_groups (business_group) values('{$business_group_name}')";
$result = mysql_query($sql);
}
if ($business_group_name != '' && $action == "edit") {
if (!check_feature(14)) {
feature_error();
exit;
}
$sql = "update business_groups set business_group='{$business_group_name}' where business_group_index={$id}";
$result = mysql_query($sql);
}
if ($id != 1 && $action == "delete") {
if (!check_feature(15)) {
feature_error();
exit;
}
$sql = "delete from business_groups where business_group_index='{$id}'";
$result = mysql_query($sql);
$sql = "update user_master set business_group_index='1' where business_group_index='{$id}'";
$result = mysql_query($sql);
?>
<meta http-equiv="Refresh" content="1; URL=business_groups.php">
<?php
}
if ($action == 'edit') {
$sql = "select * from business_groups where business_group_index={$id}";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$query_name = $_REQUEST["query_name"];
$url = "agency_list.php?type=" . $query_type . "&name=" . $query_name . "&status=" . $query_status;
if (strpos($_SERVER['HTTP_REFERER'], "summary_agencies") > 0) {
$url = $_SERVER['HTTP_REFERER'];
}
?>
<table border=0 width=100% cellpadding="0" cellspacing="0" >
<tr>
<td align=left><b><font face="Arial" color="#CC0000" size="2">PLANNED ACTIVITIES</font></b></td>
</tr>
</table>
<br>
<?php
if (check_feature(49)) {
?>
<table border=0 cellpadding=0 cellspacing=0 width=100% bgcolor=#EEEEEE>
<form method=POST action=pa_create.php>
<tr>
<td>
<label style="width: 450px;">Provide a name for the project/activity</label>
<input name="project" size="80" class=forminputtext>
</td>
</tr>
<tr>
<td colspan=2 align=center>
<br><input type=submit value="Create New Activity" name="Submit" class=forminputbutton>
</td>
</tr>
</form>
}
?>
<?php
if (check_feature(44)) {
?>
<tr>
<td width=24><img border=0 src="images/menu_report.png"></a></td>
<td><a class=menulink target="rimmain" href="reports/index.php">Reports</a></td>
</tr>
<?php
}
?>
<?php
if (check_feature(41)) {
?>
<tr>
<td width=24><img border=0 src="images/menu_settings.png"></a></td>
<td><a class=menulink target="rimmain" href="settings/settings.php">Settings</a></td>
</tr>
<?php
}
?>
<tr>
<td width=24><img border=0 src="images/menu_help.png"></a></td>
<td><a target="rimmain" class=menulink href="http://www.ctrl-dock.org/help" target=_blank>Help</a></td>
</tr>
<tr>
<?php
include "config.php";
if (!check_feature(10)) {
feature_error();
exit;
}
$office_index = $_REQUEST["office_index"];
$sql = "select * from office_locations where office_index='{$office_index}'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$SELECTED = "EDIT OFFICE LOCATION : " . $office_index;
include "header.php";
?>
<form method=POST action=office_locations_edit_2.php>
<table border=0 cellpadding=0 cellspacing=0 width=100% bgcolor=#F7F7F7>
<tr>
<td class='tdformlabel'><b> Registered Name and Address</font></b></td>
<td align=right><textarea rows="3" name="address" cols="72" class='formtextarea'><?php
echo $row[1];
?>
</textarea></td>
</tr>
<tr>
<td class='tdformlabel'><b> Location</font></b></td>
<td align=right><input name="country" value="<?php
echo htmlentities($row[2]);
?>
<?php
include "config.php";
if (!check_feature(16)) {
feature_error();
exit;
}
$SELECTED = "SERVICES";
include "header.php";
?>
<table class="reporttable" width=100%>
<tr>
<td colspan=4 align=right>
<a style="text-decoration: none" href="add_service.php">
<font color="#99CC33" face="Arial" size="2"><b>Add Service</font></a>
</td>
</tr>
<tr>
<td class="reportheader">Service Name</td>
<td class="reportheader">Service Description</td>
<td class="reportheader">Edit</td>
<td class="reportheader">Delete</td>
</tr>
<?php
$sql = "select * from services order by service";
$result = mysql_query($sql);
$i = 1;
$row_color = "#FFFFFF";
while ($row = mysql_fetch_row($result)) {
<?php
if (check_feature(51)) {
?>
<tr>
<td>
<?php
include "dash/dash_pending_rca.php";
?>
</td>
</tr>
<?php
}
?>
<?php
if (check_feature(52)) {
?>
<tr>
<td>
<?php
include "dash/dash_pending_pa.php";
?>
</td>
</tr>
<?php
}
?>
<?php
if ($EZASSET == 1) {
<?php
include "config.php";
if (!check_feature(39)) {
feature_error();
exit;
}
echo "<center><table border=0 width=50%>";
$name = $_REQUEST["name"];
if (strlen($name) <= 0) {
$error = 1;
}
// Check if the Name /Code is left blank
if ($error == 1) {
echo "<tr><td><font face=Arial size=2 color=#CC0000>Error {$error} : The agency name was left blank </font></b></td></tr>";
}
$type = $_REQUEST["type"];
$address = mysql_real_escape_string($_REQUEST["address"]);
$contact_phone = $_REQUEST["contact_phone"];
$contact_fax = $_REQUEST["contact_fax"];
$contact_email = $_REQUEST["contact_email"];
$prim_contact = $_REQUEST["prim_contact"];
$prim_phone = $_REQUEST["prim_phone"];
$prim_email = $_REQUEST["prim_email"];
$sec_contact = $_REQUEST["sec_contact"];
$sec_phone = $_REQUEST["sec_phone"];
$sec_email = $_REQUEST["sec_email"];
$comments = mysql_real_escape_string($_REQUEST["comments"]);
$payment_terms = mysql_real_escape_string($_REQUEST["payment_terms"]);
$bank_info = mysql_real_escape_string($_REQUEST["bank_info"]);
if ($error > 0) {
<?php
include "config.php";
if (!check_feature(2)) {
feature_error();
exit;
}
$SELECTED = "ADD A USER";
include "header.php";
?>
<form method=POST action=add_account_2.php>
<table border=0 cellpadding=2 cellspacing=0 width=100%>
<tr><td bgcolor=#666666 colspan=2><font face=Arial size=2 color=White><b> Account Information</b></td></tr>
<tr>
<td class='tdformlabel'>First Name</td>
<td align=right><input name="first_name" size="40" class='forminputtext'></td>
</tr>
<tr>
<td class='tdformlabel'>Last Name</td>
<td align=right><input name="last_name" size="40" class='forminputtext'></td>
</tr>
<tr>
<td class='tdformlabel'>Official E-Mail<?php
if ($ACCOUNT_AS_EMAIL == 1) {
echo "- <i> This will be Username to login";
}
?>
<?php
include "config.php";
if (!check_feature(4)) {
feature_error();
exit;
}
$group = $_REQUEST["group"];
$id = $_REQUEST["id"];
$SELECTED = "SERVICE PROFILE : " . $group;
include "header.php";
?>
<table class="reporttable" border=0 width=900 cellpadding=0 cellspacing=1>
<tr><td align=center valign=top width=300>
<table border=0 width=300>
<tr><td class='reportheader'><b>Available Services</font></b></td></tr>
<tr>
<td align=center>
<form method="POST" action="manage_group_service.php?id=<?php
echo $id;
?>
&group=<?php
echo $group;
?>
&action=add">
<select size=10 name=member[] class='formselect' style=' height: 300px;' multiple>
<?php
$sql = "select service,comments from services where service not in (select service from group_service where group_id='{$id}') order by service";
$result = mysql_query($sql);
<?php
include "config.php";
if (!check_feature(27)) {
feature_error();
exit;
}
$email = $_REQUEST["email"];
$sql = "delete from escalation_email";
$result = mysql_query($sql);
$sql = "insert into escalation_email values ('{$email}')";
$result = mysql_query($sql);
$ticket_type_id = $_REQUEST["ticket_type_id"];
$emg_1 = $_REQUEST["emg_1"];
$hgh_1 = $_REQUEST["hgh_1"];
$med_1 = $_REQUEST["med_1"];
$low_1 = $_REQUEST["low_1"];
$exc_1 = $_REQUEST["exc_1"];
$sql = "update escalations set emergency='{$emg_1}',high='{$hgh_1}',medium='{$med_1}',low='{$low_1}',exception='{$exc_1}' where esc_id='1' and ticket_type_id='{$ticket_type_id}'";
$result = mysql_query($sql);
$emg_2 = $_REQUEST["emg_2"];
$hgh_2 = $_REQUEST["hgh_2"];
$med_2 = $_REQUEST["med_2"];
$low_2 = $_REQUEST["low_2"];
$exc_2 = $_REQUEST["exc_2"];
$sql = "update escalations set emergency='{$emg_2}',high='{$hgh_2}',medium='{$med_2}',low='{$low_2}',exception='{$exc_2}' where esc_id='2' and ticket_type_id='{$ticket_type_id}'";
$result = mysql_query($sql);
$emg_3 = $_REQUEST["emg_3"];
$hgh_3 = $_REQUEST["hgh_3"];
$med_3 = $_REQUEST["med_3"];
$low_3 = $_REQUEST["low_3"];
<?php
include "config.php";
$host_id = $_REQUEST["host_id"];
$hostname = $_REQUEST["hostname"];
if (!check_feature(32)) {
feature_error();
exit;
}
?>
<br><br>
<h3>Kindly confirm if you wish to delete the host : <b><?php
echo $hostname;
?>
</b></h3>
<a href=host_delete.php?host_id=<?php
echo $host_id;
?>
><font face=Arial size=2 color=Red><b>YES</a>
<a href=index.php><font face=Arial size=2 color=Green><b>NO</a>
<?php
include_once "config.php";
include_once "searchasset.php";
if (!check_feature(36)) {
feature_error();
exit;
}
$asset_db = $DATABASE_NAME . "_oa";
?>
<body>
<br>
<table border=0 width=100% cellpadding="2" cellspacing="0" bgcolor=#E5E5E5>
<tr>
<td width="90%" style="border-style: none; border-width: medium" align=left colspan=1>
<font face=Arial size=2 color=#CC0000><b>MANAGE SOFTWARE LICENSES</b></font>
</td>
<td width=10% align=right>
<a href=javascript:history.back()><font face=Arial size=1>BACK</font></a>
</td>
</tr>
</table>
<form name=addasset method="POST" action="add_sw_2.php">
<table border=0 cellpadding=2 cellspacing=0 width=100%>
<tr><td bgcolor=#666666 colspan=2><font face=Arial size=2 color=White><b>Add a Software License</b></td></tr>
<tr>
<td class='tdformlabel'>Software Package with Keys found</td>
<td align=right>
<select class="formselect" size=1 name=package_name>
<?php
$result = mysql_query($sql);
while ($row = mysql_fetch_row($result)) {
echo "<option value='{$row['0']} {$row['1']}||{$row['2']}'>{$row['0']} {$row['1']} - {$row['2']}</option>";
}
?>
</select>
</td>
<td align=left>
<input type=submit value="Add" name="Submit" class=forminputbutton></td>
</form>
</tr>
</table>
<?php
if (check_feature(47)) {
?>
<table border=1 width=100% cellspacing=0 cellpadding=2 style="border-collapse: collapse" bordercolor="#E5E5E5">
<tr>
<td class=reportheader width=50><b>Sl. No.</font></b></td>
<td class=reportheader width=612><b>Approver Name</font></b></td>
<td class=reportheader width=316 colspan=2><b>Approver E-Mail</font></b></td>
</tr>
<?php
$sql = "select record_index,approver_name,approver_email,item_order";
$sql .= " from rca_approval_history where activity_id='{$activity_id}' and action in ('ADDED','DELETED','REJECTED') GROUP BY approver_email HAVING COUNT(approver_email) = 1 order by item_order";
$result = mysql_query($sql);
$record_count = mysql_num_rows($result);
$i = 1;
$prev_record_index = "";
while ($row = mysql_fetch_row($result)) {
<?php
include_once "../include/config.php";
include_once "../include/db.php";
include_once "../include/css/default.css";
include_once "rca_approve.php";
if ($authorized == 0) {
include_once "config.php";
if (!check_feature(51)) {
feature_error();
exit;
}
$activity_id = $_REQUEST["activity_id"];
}
$sql = "select a.project,a.action_by,a.action_date from rca_master a where a.activity_id='{$activity_id}'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$project = $row[0];
$sub_sql = "select first_name,last_name from user_master where username='******'1']}'";
$sub_result = mysql_query($sub_sql);
$sub_row = mysql_fetch_row($sub_result);
$action_by = $sub_row[0] . " " . $sub_row[1];
$action_date = "";
if (strlen($row[2]) > 0) {
$action_date = date("d M Y H:i", $row[2]);
}
$submit_date = $row[2];
$sql = "select activity_id,open_date,attended_date,closure_date,description,symptoms,impact_analysis,ca_root_cause,ca_reason,ca_action,pa_action,recommendations,observations";
$sql .= " from rca_information where activity_id='{$activity_id}' order by record_index DESC limit 1";
$result = mysql_query($sql);
$record_count = mysql_num_rows($result);
<?php
include "config.php";
$SELECTED = "Configure Time Servers";
include "header.php";
if (!check_feature(30)) {
feature_error();
exit;
}
$timeserver = mysql_real_escape_string($_REQUEST["timeserver"]);
$threshold = mysql_real_escape_string($_REQUEST["threshold"]);
$action = mysql_real_escape_string($_REQUEST["action"]);
$sql = "select timeservers,diffthreshold from hosts_timesync_config";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
?>
<form method=POST action=config_timeserver.php?action=save>
<table border=0 cellpadding=1 cellspacing=1 width=100% bgcolor=#F7F7F7>
<tr>
<td class='tdformlabel'><b>Time Servers (Comma Separated Values)</font></b></td>
<td align=right><input value="<?php
echo $row[0];
?>
" name="timeserver" size="40" class='forminputtext'></td>
</tr>
<tr>
<?php
include_once "config.php";
if (!check_feature(43)) {
feature_error();
exit;
}
$id = $_REQUEST["id"];
$group = $_REQUEST["group"];
$member = $_REQUEST["member"];
$action = $_REQUEST["action"];
if ($action == "add") {
for ($i = 0; $i < count($member); $i++) {
$sql = "insert into rim_user_group values ('{$id}','{$member[$i]}')";
$result = mysql_query($sql);
}
}
if ($action == "del") {
for ($i = 0; $i < count($member); $i++) {
$sql = "delete from rim_user_group where group_id='{$id}' and username='******'";
$result = mysql_query($sql);
}
}
?>
<meta http-equiv="refresh" content="0;url=profile_members.php?id=<?php
echo $id;
?>
&group=<?php
echo $group;
?>
">
<?php
include "config.php";
if (!check_feature(18)) {
feature_error();
exit;
}
$service = $_REQUEST["service"];
$sql = "select comments from services where service='{$service}'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$comments = $row[0];
$sql = "select type,url,port,username,password,domain from service_properties where service='{$service}'";
$result = mysql_query($sql);
$count = mysql_num_rows($result);
if ($count > 0) {
$row = mysql_fetch_row($result);
$service_type = $row[0];
$service_url = $row[1];
$service_port = $row[2];
$service_user = $row[3];
$service_pass = $row[4];
$service_domain = $row[5];
} else {
$sql = "INSERT INTO service_properties VALUES('{$service}','{$service_type}','{$service_url}','{$service_port}','{$service_user}','{$service_pass}','{$service_domain}')";
mysql_query($sql);
}
?>
<?php
$SELECTED = "EDIT SERVICE : " . $service;
<?php
include_once "../auth.php";
include_once "../include/features.php";
if (check_feature(33)) {
$read = 1;
$write = 0;
$drop = 1;
}
if (check_feature(42)) {
$read = 1;
$write = 1;
$drop = 1;
}
if ($read == 0 && $write == 0) {
?>
<font face=Arial size=2>This feature is not enabled for your profile</font><?php
exit;
}
$conf_chroot = "files/";
$sopbox = "files/SOPBOX";
if (!file_exists($sopbox)) {
mkdir("{$sopbox}", 0777);
}
$conf_images = 'images';
// Directory that contains the FileManager images
$conf_showdirs = TRUE;
// Show directories in the file list?
$conf_sort_dirs = TRUE;
// Sort the directories by name (otherwise displayed in order of file system)
$conf_resolveid = FALSE;
<?php
include "config.php";
if (!check_feature(38)) {
feature_error();
exit;
}
$SELECTED = "VENDORS / CUSTOMERS";
include "header.php";
?>
<table border=0 width=100% cellpadding="2" cellspacing="0" bgcolor=#C0C0C0>
<tr>
<form method="POST" action="agency_list.php">
<td align=right><font face=Arial size=1 color=white><b>AGENCY</b></td>
<td><input type=text name=name size=60 style="font-family: Arial; font-size: 8pt;"></td>
<td align=right><font face=Arial size=1 color=white><b>TYPE</b></td>
<td>
<select size=1 name=type style="font-size: 8pt; font-family: Arial">
<?php
echo "<option value=%></option>";
$sql = "select * from agency_type order by agency_type";
$result = mysql_query($sql);
while ($row = mysql_fetch_row($result)) {
echo "<option value={$row['0']}>{$row['0']}</option>";
}
?>
</select>
</td>
<?php
include "config.php";
if (!check_feature(37)) {
feature_error();
exit;
}
$system_id = $_REQUEST["id"];
$asset_db = $DATABASE_NAME . "_oa";
mysql_select_db($asset_db, $link);
$sub_sql = "delete from sys_sw_software_key where system_id='{$system_id}'";
$sub_result = mysql_query($sub_sql);
$sub_sql = "delete from system where system_id='{$system_id}'";
$sub_result = mysql_query($sub_sql);
?>
<meta http-equiv="refresh" content="0;url=../OA2/index.php/main/list_devices/1">
<?php
include "config.php";
if (!check_feature(29)) {
feature_error();
exit;
}
$hostname = $_REQUEST["hostname"];
$timedetail = $_REQUEST["timedetail"];
$fromdate = $_REQUEST["fromdate"];
$todate = $_REQUEST["todate"];
$sql = "select host_id from hosts_master where hostname='{$hostname}'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$host_id = $row[0];
?>
<title>Ping Statistics : <?php
echo $hostname;
?>
</title>
<table class="reporttable" width=650 border=0>
<tr><td class='reportdata' colspan=5><b>Ping Statistics : <?php
echo $hostname;
?>
</b></td></tr>
</table>
<table class="reporttable" width=650 cellpadding=4>
<tr><td colspan=6>
<?php
$sql = "select timestamp,nw_status,min,avg,max from hosts_nw_log where host_id='{$host_id}'";
if (strlen($timedetail) > 0) {
<?php
include_once "config.php";
if (!check_feature(48)) {
feature_error();
exit;
}
$base_url = "http://";
if ($HTTPS == 1) {
$base_url = "https://";
}
$base_url .= $_SERVER["SERVER_NAME"] . "/" . $INSTALL_HOME . "rca";
$activity_id = $_REQUEST["activity_id"];
$action = "PENDING APPROVAL";
$action_by = $username;
$action_date = mktime();
$email = $_REQUEST["email"];
$sql = "select record_index,approver_name,approver_email,approver_key,item_order";
$sql .= " from rca_approval_history where activity_id='{$activity_id}' and approver_email='{$email}' order by record_index asc limit 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_row($result)) {
$record_index = $row[0];
$approver_name = $row[1];
$approver_email = $row[2];
$approver_key = random_key();
$sql = "update rca_approval_history set approver_key='{$approver_key}' where record_index='{$record_index}'";
$result = mysql_query($sql);
$item_order = $row[4];
$subject = "RCA APPROVAL REQUEST : {$activity_id}";
$url = $base_url . "/rca_view.php" . "?check_email=" . $approver_email . "&check_key=" . "{$approver_key}";
$body = "\nA Root Cause Analysis (RCA) is pending your approval. Kindly click on the URL : {$url} to view and approve the request.\n\n\n";
<?php
include "config.php";
if (!check_feature(25)) {
feature_error();
exit;
}
$currtimestamp = mktime();
$currentday = date('D', $currtimestamp);
$task_summary = $_REQUEST["task_summary"];
$task_description = $_REQUEST["task_description"];
$task_date = $_REQUEST['schedule_date'];
$task_hr = $_REQUEST['time_hh'];
$task_min = $_REQUEST['time_mm'];
$recurtype = $_REQUEST['recurtype'];
if ($recurtype == "day") {
$factor = 1;
} elseif ($recurtype == "week") {
$factor = 7;
}
$recurvalue = $_REQUEST['recur'];
$scheduledate = date_to_int($task_date);
$scheduledate = $scheduledate + $task_hr * 3600 + $task_min * 60;
if ($recurtype == 'last day of month') {
$lastdate = date('t', $currtimestamp);
// current month no. of days
$currmonth = date('m', $currtimestamp);
$curryear = date('Y', $currtimestamp);
$scheduledate = mktime($task_hr, $task_min, 00, $currmonth, $lastdate, $curryear);
}
$scheduleday = date('D', $scheduledate);
