$_REQUEST['document'] = $row_spam['vTitle'] . " " . $row_spam['tQuestion'];
}
}
}
//$_REQUEST['document']=$row_spam['vTitle'];
//echo " doc==". $_REQUEST['document'];
train();
$val = $row_spam['nDeptId'];
$var_machineip = $row_spam['vMachineIP'];
$var_message_main = $row_spam['tQuestion'];
$sql = "insert into sptbl_spam_tickets(nSpamTicketId,nDeptId,vTitle,tQuestion,dPostDate,vMachineIP)\r\n\t\t\t\t\tvalues('','" . $val . "','" . mysql_real_escape_string($row_spam['vTitle']) . "','" . mysql_real_escape_string($var_message_main) . "',now(),\r\n\t\t\t\t\t'" . mysql_real_escape_string($var_machineip) . "')";
executeQuery($sql, $conn);
}
}
$message = "";
deleteChecked($var_list, $message);
$message = "<font color=\"red\">" . $updatedtickets . MESSAGE_RECORD_MOVED_SUCCESSFULLY . "</font><br>";
}
if ($_POST["del"] == "UP") {
$frm_status = $_POST['cmbStatus'];
$updatedtickets = 0;
for ($i = 0; $i < count($_POST["chkDeleteTickets"]); $i++) {
$var_ticketid = mysql_real_escape_string($_POST["chkDeleteTickets"][$i]);
$update_flag = false;
$sql = " Select * from sptbl_lookup where vLookUpName IN('MailFromName','MailFromMail',";
$sql .= "'MailReplyName','MailReplyMail','Emailfooter','Emailheader','MailEscalation','HelpdeskTitle')";
$result = executeSelect($sql, $conn);
if (mysql_num_rows($result) > 0) {
while ($row2 = mysql_fetch_array($result)) {
switch ($row2["vLookUpName"]) {
case "MailFromName":
} //end mail admin
//end mail escalated
if ($frm_status == "closed")// Mail send to user on ticket close
{
sendMailUserTicketClose($mail_refno,$var_helpdesktitle);
}// Mail send to user on ticket close ends
$var_message = MESSAGE_RECORD_UPDATED;
$flag_msg = "class='msg_success'";
}
}
}
mysql_free_result($rs);
}else if ($_POST["mt"] == "D") {
$tickettobedelete=$_POST['delid'];
deleteChecked($tickettobedelete,$message);
if($flag_del == true) {
//header("Location:tickets.php?mt=y&tp=a&stylename=STYLETICKETS&styleminus=minus1&styleplus=plus1&msg=deleted");
?>
<script type='text/javascript'>
window.location.href = "tickets.php?mt=y&tp=a&stylename=STYLETICKETS&styleminus=minus1&styleplus=plus1&msg=deleted";
</script>
<?php
exit;
}
}else if ($_POST["mt"] == "f") { // forward email starts here
// echo '<pre>'; print_r($_POST); echo '</pre>'; exit;
$var_staffid = $_SESSION["sess_staffid"];
$sql ="select tSignature from sptbl_staffs where nStaffId='".mysql_real_escape_string($var_staffid)."'";
