<?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);