function audit_comments($lead_id, $list_id, $format, $user, $mel, $NOW_TIME, $link, $server_ip, $session_name, $one_mysql_log, $campaign)
{
$audit_comments_active = audit_comments_active($list_id, $format, $user, $mel, $NOW_TIME, $link, $server_ip, $session_name, $one_mysql_log);
if ($audit_comments_active) {
//Get comment from list
$stmt = "select comments from vicidial_list where lead_id='{$lead_id}' limit 1;";
if ($format == 'debug') {
echo "\n<!-- {$stmt} -->";
}
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-AuditComments2', $user, $server_ip, $session_name, $one_mysql_log);
}
$row = mysql_fetch_row($rslt);
if (strlen($row[0]) > 0) {
$comment = $row[0];
//Put comment in comment table
$stmt = "INSERT INTO vicidial_comments (lead_id,user_id,list_id,campaign_id,comment) VALUES ('{$lead_id}','{$user}','{$list_id}','{$campaign}','{$comment}');";
if ($format == 'debug') {
echo "\n<!-- {$stmt} -->";
}
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-AuditComments3', $user, $server_ip, $session_name, $one_mysql_log);
}
$affected = mysql_affected_rows();
if ($affected > 0) {
$stmt = "UPDATE vicidial_list set comments='' where lead_id='{$lead_id}';";
if ($format == 'debug') {
echo "\n<!-- {$stmt} -->";
}
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-AuditComments4', $user, $server_ip, $session_name, $one_mysql_log);
}
} else {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-AuditCommentsERROR-Comment not moved', $user, $server_ip, $session_name, $one_mysql_log);
echo "\n<!-- 00142-AuditCommentsERROR-Comment not moved -->";
}
}
}
}
$comments = stripslashes(trim("{$row['29']}"));
$called_count = trim("{$row['30']}");
$rank = trim("{$row['32']}");
$owner = trim("{$row['33']}");
$entry_list_id = trim("{$row['34']}");
if ($entry_list_id < 100) {
$entry_list_id = $list_id;
}
}
if ($qc_features_active > 0) {
//Added by Poundteam for Audited Comments
##### if list has audited comments, grab the audited comments
require_once 'audit_comments.php';
$ACcount = '';
$ACcomments = '';
$audit_comments_active = audit_comments_active($list_id, $format, $user, $mel, $NOW_TIME, $link, $server_ip, $session_name, $one_mysql_log);
if ($audit_comments_active) {
get_audited_comments($lead_id, $format, $user, $mel, $NOW_TIME, $link, $server_ip, $session_name, $one_mysql_log);
}
$ACcomments = strip_tags(htmlentities($ACcomments));
$ACcomments = preg_replace("/\r/i", '', $ACcomments);
$ACcomments = preg_replace("/\n/i", '!N', $ACcomments);
//END Added by Poundteam for Audited Comments
}
##### if lead is a callback, grab the callback comments
$CBentry_time = '';
$CBcallback_time = '';
$CBuser = '';
$CBcomments = '';
$CBstatus = 0;
$stmt = "SELECT count(*) FROM vicidial_statuses where status='{$dispo}' and scheduled_callback='Y';";
