$str .= $private."</td></tr>";
}
$str .= "<tr align='left' class='listingmaintext'>
<td colspan='2'> </td>
<td colspan='2'> </td>
</tr>
</table></td>
</tr>";
$str .= "</table>";
} //end else correspondance section
}
}
// $var_replymatter=$var_signature."\n######################################\n".replacestr($var_replymatter);
$var_ereplymatter=$var_signature."<br>######################################<br>".replacestrforemail($var_replymatter);
// $var_qtrp=$var_signature."\n######################################\n".$var_replymatter;
$var_fromName = utf8_encode($_SESSION['sess_staffname']);
$var_email = $var_forward_email;
$var_mail_body = $var_emailheader."<br>Hi ,<br>";
$var_mail_body .= "<br><br>";
$var_mail_body .= $var_forward_comments."<br><br>";
$var_mail_body .= $str."<br><br>";
$var_mail_body .= "<br><br>".$var_ereplymatter;
$var_mail_body .= "<br>" . utf8_encode($var_helpdesktitle) . "<br>".$var_emailfooter;
$var_body = $var_mail_body;
$var_subject = TEXT_EMAIL_FORWARDED_SUB;
$Headers="From: $var_fromName <$var_fromMail>\n";
$sql .= "sptbl_tickets as t where r.nTicketId=t.nTicketId and r.nReplyId='" . mysql_real_escape_string($var_rid) . "'";
$result = executeSelect($sql, $conn);
if (mysql_num_rows($result) > 0) {
$var_row = mysql_fetch_array($result);
$var_deptid = $var_row["nDeptid"];
$var_tickettitle = $var_row["vTitle"];
$var_tqusetion = $var_row["tQuestion"];
$var_refno = $var_row["vRefNo"];
$var_userid = $var_row["nUserId"];
$var_replymatter = $var_row["tReply"];
$var_status = $var_row["vStatus"];
} else {
$var_message = "<font color=red>" . MESSAGE_RECORD_ERROR . "</font>";
}
$var_replymatter = $var_signature . "\n######################################\n" . replacestr($var_replymatter);
$var_ereplymatter = $var_signature . "\n######################################\n" . replacestrforemail($var_replymatter);
$var_qtrp = $var_signature . "\n######################################\n" . $var_replymatter;
} else {
if ($var_rp == "r") {
$var_staffid = $_SESSION["sess_staffid"];
$sql = "select tSignature from sptbl_staffs where nStaffId='" . mysql_real_escape_string($var_staffid) . "'";
$result = executeSelect($sql, $conn);
$var_row = mysql_fetch_array($result);
$var_signature = $var_row["tSignature"];
mysql_free_result($result);
$sql = "select nDeptid,vTitle,nUserId,tQuestion,vRefNo,vStatus from sptbl_tickets where nTicketId='" . mysql_real_escape_string($var_tid) . "'";
$result = executeSelect($sql, $conn);
if (mysql_num_rows($result) > 0) {
$var_row = mysql_fetch_array($result);
$var_deptid = $var_row["nDeptid"];
$var_tickettitle = $var_row["vTitle"];