by Freddy_rixcom » Tue Jul 21, 2009 8:00 am
Hi all
monitoring work of server and agents, I knew today that callbacks don't insert correctly record if it was an escape char in the comment text.
i changhe the following string
$stmt="INSERT INTO vicidial_callbacks (lead_id,list_id,campaign_id,status,entry_time,callback_time,user,recipient,comments,user_group) values('$lead_id','$list_id','$campaign','ACTIVE','$NOW_TIME','$CallBackDatETimE','$user','$recipient','$comments','$user_group');";
to a new one like this
$stmt="INSERT INTO vicidial_callbacks (lead_id,list_id,campaign_id,status,entry_time,callback_time,user,recipient,comments,user_group) values('$lead_id','$list_id','$campaign','ACTIVE','$NOW_TIME','$CallBackDatETimE','$user','$recipient','".addslashes($comments)."','$user_group');";
Now it works perfectly.
See you soon.
HI all