27-03-2025 10:37:44 am username=>sr62 -- token=>8wsys8 -- announcement_id=>4196 -- caller_id=>1234567890 -- plan_id=>1037 -- contact_numbers=>9942294332 -- 27-03-2025 10:37:44 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr62_1037_3_A_4196__29_29_30_0.15_5_1_30_1743013800 compaign_id=> sql_comp_insert=> INSERT INTO voice_compaign_summary(user_id, filename, compaign_type, announcement_id, sender_id, start_date, status, alloted_api, api_type, voice_file,gateway_id, user_voice_plan_id,voice_plan_id,caller_id,delivery_route,delivery_type,delivery_cli,pulse,pulse_rate,duration,credits_per_sms,user_pulse,ext_duration , uphierarchy) VALUES( 'sr62', 'vsmsdemo-cobra1.mp3', 'A', '4196', '', '1743052065', 'C', '29', 'S', '1738912242_sr62_voice_upload.wav','29','1037','3','','trans','answered','static','30','0.15','5','1','30','0' , 'admin,sr62') again_get_cID=> 30998 sql_contact_insert=> INSERT INTO voice_compaign_detail_30998(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('30998', '9942294332', 'P', '29', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_30998 SET status='S', sent_date='1743052065', sarv_api_uniqueid='30998_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr62' AND type='D' AND compaign_id='30998' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('sr62', 'superreseller', '30998', '0.15', 'D', '1743052065', '0.15', '1', 'answered','30') 27-03-2025 12:13:02 pm username=>sr190 -- token=>5REKc4 -- announcement_id=>5709 -- plan_id=>790 -- contact_numbers=>917738341288 -- retry_json=>{"FNA":"1","FBZ":"1","FCG":"2","FFL":"2"} -- 27-03-2025 12:13:02 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr190_790_17_A_5709__35_35_15_0.08_24_2_15_1743013800 compaign_id=> sql_comp_insert=> INSERT INTO voice_compaign_summary(user_id, filename, compaign_type, announcement_id, sender_id, start_date, status, alloted_api, api_type, voice_file,gateway_id, user_voice_plan_id,voice_plan_id,caller_id,delivery_route,delivery_type,delivery_cli,pulse,pulse_rate,duration,credits_per_sms,user_pulse,ext_duration , uphierarchy) VALUES( 'sr190', '2833951742887495_convertedHINDIEXPIRY.mp3', 'A', '5709', '', '1743057783', 'C', '35', 'S', 'api_1742887499_sr190_voice_662.wav','35','790','17','','promo','answered','static','15','0.08','24','2','15','0' , 'admin,sr190') again_get_cID=> 31053 sql_contact_insert=> INSERT INTO voice_compaign_detail_31053(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31053', '7738341288', 'P', '35', '0', '{"FNA":"1","FBZ":"1","FCG":"2","FFL":"2"}') sql_contact_update=> UPDATE voice_compaign_detail_31053 SET status='S', sent_date='1743057784', sarv_api_uniqueid='31053_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr190' AND type='D' AND compaign_id='31053' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('sr190', 'superreseller', '31053', '0.16', 'D', '1743057784', '0.08', '2', 'answered','15') 27-03-2025 12:49:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>5762 -- plan_id=>894 -- contact_numbers=>8056003157 -- 27-03-2025 12:49:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_5762__35_35_30_0.3_4_1_30_1743013800 compaign_id=> sql_comp_insert=> INSERT INTO voice_compaign_summary(user_id, filename, compaign_type, announcement_id, sender_id, start_date, status, alloted_api, api_type, voice_file,gateway_id, user_voice_plan_id,voice_plan_id,caller_id,delivery_route,delivery_type,delivery_cli,pulse,pulse_rate,duration,credits_per_sms,user_pulse,ext_duration , uphierarchy) VALUES( 'u531', 'audio8169141117683483391.wav', 'A', '5762', '', '1743059941', 'C', '35', 'S', 'api_1742986121_u531_voice_396.wav','35','894','56','','promo','answered','static','30','0.3','4','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 31066 sql_contact_insert=> INSERT INTO voice_compaign_detail_31066(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31066', '8056003157', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31066 SET status='S', sent_date='1743059941', sarv_api_uniqueid='31066_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='31066' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('u531', 'user', '31066', '0.3', 'D', '1743059942', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='31066' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('sr195', 'superreseller', '31066', '0.13', 'D', '1743059942', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='31066' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('sr83', 'superreseller', '31066', '0.055', 'D', '1743059942', '0.055', '1', 'answered','15') 27-03-2025 01:16:40 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8275677838 -- announcement_id=>5780 -- 27-03-2025 01:16:40 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_5780__35_35_30_0.11_42_2_30_1743013800 compaign_id=> sql_comp_insert=> INSERT INTO voice_compaign_summary(user_id, filename, compaign_type, announcement_id, sender_id, start_date, status, alloted_api, api_type, voice_file,gateway_id, user_voice_plan_id,voice_plan_id,caller_id,delivery_route,delivery_type,delivery_cli,pulse,pulse_rate,duration,credits_per_sms,user_pulse,ext_duration , uphierarchy) VALUES( 'u4', '20250327120730pm7823781453.wav', 'A', '5780', '', '1743061601', 'C', '35', 'S', 'api_1743057479_u4_voice_459.wav','35','25','23','','promo','answered','static','30','0.11','42','2','30','0' , 'admin,u4') again_get_cID=> 31073 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8275677838', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743061602', sarv_api_uniqueid='31073_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='31073' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('u4', 'user', '31073', '0.22', 'D', '1743061602', '0.11', '2', 'answered','30') 27-03-2025 01:37:12 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>5784 -- caller_id=>8985705878 -- contact_numbers=>8985705878 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 27-03-2025 01:37:12 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_5784__35_35_15_0.16_5_1_15_1743013800 compaign_id=> sql_comp_insert=> INSERT INTO voice_compaign_summary(user_id, filename, compaign_type, announcement_id, sender_id, start_date, status, alloted_api, api_type, voice_file,gateway_id, user_voice_plan_id,voice_plan_id,caller_id,delivery_route,delivery_type,delivery_cli,pulse,pulse_rate,duration,credits_per_sms,user_pulse,ext_duration , uphierarchy) VALUES( 'u635', '7f7b15d9abc041d6a6951a44e8568da2.mp3', 'A', '5784', '', '1743062832', 'C', '35', 'S', 'api_1743062831_u635_voice_352.wav','35','1050','13','','promo','answered','static','15','0.16','5','1','15','0' , 'admin,u635') again_get_cID=> 31080 sql_contact_insert=> INSERT INTO voice_compaign_detail_31080(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31080', '8985705878', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_31080 SET status='S', sent_date='1743062833', sarv_api_uniqueid='31080_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u635' AND type='D' AND compaign_id='31080' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('u635', 'user', '31080', '0.16', 'D', '1743062833', '0.16', '1', 'answered','15') 27-03-2025 01:39:02 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9423122942,9373255983,7507575548,7798304306,9623203386,8007742196,9423711075,9579349282,9850539184,8275844188,8275530430,7066180179,9673674219,9420919010,9881335821,9850762731,9325420304,9421817018,9921165363,9421050817,9145733035,9823905499,9421314647,9422577863,9529827094,9422912773,9405130567,8956093927,7798202972,9673757928,9421733305,9765822520,8605302085,9420758751,9403414309,7776952682,8888015469,9403424836,9623834233,9421734132,8805049554,9637810509,9405491407,9923752379,9420846479,9595464648,9923705599,9822042614,9921470904,9309751436 -- announcement_id=>5780 -- 27-03-2025 01:39:02 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_5780__35_35_30_0.11_42_2_30_1743013800 compaign_id=> 31073 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9423122942', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062944', sarv_api_uniqueid='31073_2' WHERE id='2' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9373255983', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062944', sarv_api_uniqueid='31073_3' WHERE id='3' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7507575548', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062944', sarv_api_uniqueid='31073_4' WHERE id='4' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7798304306', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062944', sarv_api_uniqueid='31073_5' WHERE id='5' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9623203386', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062944', sarv_api_uniqueid='31073_6' WHERE id='6' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8007742196', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062944', sarv_api_uniqueid='31073_7' WHERE id='7' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9423711075', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062944', sarv_api_uniqueid='31073_8' WHERE id='8' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9579349282', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062944', sarv_api_uniqueid='31073_9' WHERE id='9' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9850539184', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_10' WHERE id='10' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8275844188', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_11' WHERE id='11' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8275530430', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_12' WHERE id='12' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7066180179', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_13' WHERE id='13' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9673674219', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_14' WHERE id='14' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9420919010', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_15' WHERE id='15' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9881335821', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_16' WHERE id='16' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9850762731', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_17' WHERE id='17' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9325420304', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_18' WHERE id='18' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31073', '9421817018', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_19' WHERE id='19' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9921165363', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_20' WHERE id='20' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9421050817', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_21' WHERE id='21' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9145733035', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_22' WHERE id='22' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31073', '9823905499', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_23' WHERE id='23' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9421314647', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_24' WHERE id='24' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9422577863', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_25' WHERE id='25' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9529827094', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_26' WHERE id='26' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9422912773', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_27' WHERE id='27' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9405130567', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062945', sarv_api_uniqueid='31073_28' WHERE id='28' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31073', '8956093927', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_29' WHERE id='29' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7798202972', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_30' WHERE id='30' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9673757928', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_31' WHERE id='31' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9421733305', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_32' WHERE id='32' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9765822520', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_33' WHERE id='33' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8605302085', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_34' WHERE id='34' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9420758751', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_35' WHERE id='35' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9403414309', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_36' WHERE id='36' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7776952682', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_37' WHERE id='37' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8888015469', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_38' WHERE id='38' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9403424836', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_39' WHERE id='39' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9623834233', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_40' WHERE id='40' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9421734132', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_41' WHERE id='41' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31073', '8805049554', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_42' WHERE id='42' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31073', '9637810509', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_43' WHERE id='43' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9405491407', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_44' WHERE id='44' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9923752379', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_45' WHERE id='45' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9420846479', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_46' WHERE id='46' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31073', '9595464648', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_47' WHERE id='47' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9923705599', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062946', sarv_api_uniqueid='31073_48' WHERE id='48' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9822042614', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062947', sarv_api_uniqueid='31073_49' WHERE id='49' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9921470904', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062947', sarv_api_uniqueid='31073_50' WHERE id='50' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9309751436', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062947', sarv_api_uniqueid='31073_51' WHERE id='51' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='31073' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+11 WHERE id=125602 LIMIT 1 27-03-2025 01:39:08 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9404523370,9326937446,9921030645,9421732581,9309875856,7057087049,9403703726,8275529333,8007354941,9421731048,9158460820,8007114869,8550999982,9421922759,9423422817,9403446607,9423668666,9423667721,9657882739,9404623431,7875062688,8657477284,9404534683,9420168705,7083026783,8888747867,7020116232,9405505828,9421417244,7721914804,7744884572,8308076839,9545709909,9421985450,7038937476,7020725147,9405131444,9421857911,7350597745,9623318167,7020962071,9403009998,8308340413,9420357627,9767708090,9423122597,7499844780,9823120752,9379777731 -- announcement_id=>5780 -- 27-03-2025 01:39:08 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_5780__35_35_30_0.11_42_2_30_1743013800 compaign_id=> 31073 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9404523370', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062950', sarv_api_uniqueid='31073_52' WHERE id='52' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9326937446', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062950', sarv_api_uniqueid='31073_53' WHERE id='53' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9921030645', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062950', sarv_api_uniqueid='31073_54' WHERE id='54' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9421732581', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062950', sarv_api_uniqueid='31073_55' WHERE id='55' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9309875856', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062950', sarv_api_uniqueid='31073_56' WHERE id='56' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7057087049', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062950', sarv_api_uniqueid='31073_57' WHERE id='57' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9403703726', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062950', sarv_api_uniqueid='31073_58' WHERE id='58' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8275529333', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062950', sarv_api_uniqueid='31073_59' WHERE id='59' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8007354941', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062950', sarv_api_uniqueid='31073_60' WHERE id='60' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9421731048', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062950', sarv_api_uniqueid='31073_61' WHERE id='61' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31073', '9158460820', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_62' WHERE id='62' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8007114869', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_63' WHERE id='63' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8550999982', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_64' WHERE id='64' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9421922759', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_65' WHERE id='65' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9423422817', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_66' WHERE id='66' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9403446607', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_67' WHERE id='67' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9423668666', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_68' WHERE id='68' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9423667721', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_69' WHERE id='69' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9657882739', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_70' WHERE id='70' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9404623431', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_71' WHERE id='71' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7875062688', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_72' WHERE id='72' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8657477284', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_73' WHERE id='73' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9404534683', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_74' WHERE id='74' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9420168705', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_75' WHERE id='75' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7083026783', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_76' WHERE id='76' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8888747867', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_77' WHERE id='77' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7020116232', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062951', sarv_api_uniqueid='31073_78' WHERE id='78' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9405505828', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_79' WHERE id='79' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9421417244', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_80' WHERE id='80' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7721914804', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_81' WHERE id='81' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7744884572', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_82' WHERE id='82' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8308076839', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_83' WHERE id='83' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9545709909', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_84' WHERE id='84' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9421985450', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_85' WHERE id='85' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7038937476', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_86' WHERE id='86' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7020725147', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_87' WHERE id='87' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9405131444', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_88' WHERE id='88' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9421857911', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_89' WHERE id='89' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7350597745', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_90' WHERE id='90' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9623318167', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_91' WHERE id='91' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7020962071', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_92' WHERE id='92' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9403009998', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_93' WHERE id='93' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '8308340413', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_94' WHERE id='94' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31073', '9420357627', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_95' WHERE id='95' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9767708090', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_96' WHERE id='96' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9423122597', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062952', sarv_api_uniqueid='31073_97' WHERE id='97' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '7499844780', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062953', sarv_api_uniqueid='31073_98' WHERE id='98' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9823120752', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062953', sarv_api_uniqueid='31073_99' WHERE id='99' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31073(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31073', '9379777731', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31073 SET status='S', sent_date='1743062953', sarv_api_uniqueid='31073_100' WHERE id='100' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='31073' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+10.78 WHERE id=125602 LIMIT 1 27-03-2025 02:37:54 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8275677838 -- announcement_id=>5785 -- 27-03-2025 02:37:55 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_5785__35_35_30_0.11_38_2_30_1743013800 compaign_id=> sql_comp_insert=> INSERT INTO voice_compaign_summary(user_id, filename, compaign_type, announcement_id, sender_id, start_date, status, alloted_api, api_type, voice_file,gateway_id, user_voice_plan_id,voice_plan_id,caller_id,delivery_route,delivery_type,delivery_cli,pulse,pulse_rate,duration,credits_per_sms,user_pulse,ext_duration , uphierarchy) VALUES( 'u4', '20250327141629pm4404761691.wav', 'A', '5785', '', '1743066475', 'C', '35', 'S', 'api_1743065195_u4_voice_911.wav','35','25','23','','promo','answered','static','30','0.11','38','2','30','0' , 'admin,u4') again_get_cID=> 31097 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275677838', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066476', sarv_api_uniqueid='31097_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='31097' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('u4', 'user', '31097', '0.22', 'D', '1743066476', '0.11', '2', 'answered','30') 27-03-2025 02:40:03 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9422607008,8275186320,9422615324,9420511920,8928707046,9403603632,9373379427,9422999001,7620536716,8275717178,8975510465,9403238473,9404175171,9850549441,7020018679,9765271457,8275631836,9623567121,9527794249,9579197070,9764486607,9403929598,9404834823,9422720632,9420845291,9404360350,8275188657,8275598870,7020266985,7743812498,9834868488,8928126737,9423844355,9404385705,9545386319,9421304554,9823874086,8550944865,9922403986,9130568081,8698152135,9403002591,7218439121,9403213495,9420846061,9420511011,7038121365,8275814633,8975868048,7827023345 -- announcement_id=>5785 -- 27-03-2025 02:40:03 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_5785__35_35_30_0.11_38_2_30_1743013800 compaign_id=> 31097 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9422607008', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_2' WHERE id='2' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275186320', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_3' WHERE id='3' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9422615324', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_4' WHERE id='4' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9420511920', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_5' WHERE id='5' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8928707046', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_6' WHERE id='6' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9403603632', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_7' WHERE id='7' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9373379427', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_8' WHERE id='8' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9422999001', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_9' WHERE id='9' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7620536716', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_10' WHERE id='10' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275717178', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_11' WHERE id='11' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '8975510465', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_12' WHERE id='12' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '9403238473', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_13' WHERE id='13' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9404175171', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_14' WHERE id='14' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9850549441', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066605', sarv_api_uniqueid='31097_15' WHERE id='15' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7020018679', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066606', sarv_api_uniqueid='31097_16' WHERE id='16' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9765271457', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066606', sarv_api_uniqueid='31097_17' WHERE id='17' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275631836', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066606', sarv_api_uniqueid='31097_18' WHERE id='18' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '9623567121', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066606', sarv_api_uniqueid='31097_19' WHERE id='19' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '9527794249', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066606', sarv_api_uniqueid='31097_20' WHERE id='20' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9579197070', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066606', sarv_api_uniqueid='31097_21' WHERE id='21' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9764486607', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066606', sarv_api_uniqueid='31097_22' WHERE id='22' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '9403929598', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066606', sarv_api_uniqueid='31097_23' WHERE id='23' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9404834823', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066606', sarv_api_uniqueid='31097_24' WHERE id='24' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9422720632', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_25' WHERE id='25' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9420845291', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_26' WHERE id='26' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9404360350', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_27' WHERE id='27' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275188657', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_28' WHERE id='28' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275598870', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_29' WHERE id='29' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7020266985', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_30' WHERE id='30' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7743812498', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_31' WHERE id='31' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9834868488', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_32' WHERE id='32' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8928126737', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_33' WHERE id='33' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '9423844355', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_34' WHERE id='34' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9404385705', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_35' WHERE id='35' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9545386319', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_36' WHERE id='36' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9421304554', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066607', sarv_api_uniqueid='31097_37' WHERE id='37' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9823874086', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066608', sarv_api_uniqueid='31097_38' WHERE id='38' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8550944865', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066608', sarv_api_uniqueid='31097_39' WHERE id='39' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9922403986', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066608', sarv_api_uniqueid='31097_40' WHERE id='40' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9130568081', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066608', sarv_api_uniqueid='31097_41' WHERE id='41' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8698152135', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066608', sarv_api_uniqueid='31097_42' WHERE id='42' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9403002591', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066608', sarv_api_uniqueid='31097_43' WHERE id='43' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7218439121', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066608', sarv_api_uniqueid='31097_44' WHERE id='44' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9403213495', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066608', sarv_api_uniqueid='31097_45' WHERE id='45' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9420846061', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066609', sarv_api_uniqueid='31097_46' WHERE id='46' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9420511011', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066609', sarv_api_uniqueid='31097_47' WHERE id='47' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7038121365', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066609', sarv_api_uniqueid='31097_48' WHERE id='48' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275814633', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066609', sarv_api_uniqueid='31097_49' WHERE id='49' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8975868048', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066609', sarv_api_uniqueid='31097_50' WHERE id='50' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '7827023345', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066609', sarv_api_uniqueid='31097_51' WHERE id='51' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='31097' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+11 WHERE id=125685 LIMIT 1 27-03-2025 02:40:10 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8275845007,8275814648,9404824935,9545634351,7447560417,8275351862,7666582972,9403418820,8055841472,7304304466,9922874538,9403236501,9403299807,8378894842,9623098778,8806797805,7972529374,8999772091,9421713215,9527649452,7507547662,9850604186,9404229349,9403417247,8275182473,9607747651,9067179050,7588411719,9764111842,8275840400,9373035965,9404205917,7887697681,9579228924,8698958102,8788169522,9637696879,9011013562,8657255477,9404825182,9834855358,7588772641,7588772175,9356415912,9674235264,6352801067,9096243242,8698033731,9765596665,7980009320 -- announcement_id=>5785 -- 27-03-2025 02:40:11 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_5785__35_35_30_0.11_38_2_30_1743013800 compaign_id=> 31097 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275845007', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066612', sarv_api_uniqueid='31097_52' WHERE id='52' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275814648', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066612', sarv_api_uniqueid='31097_53' WHERE id='53' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9404824935', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066612', sarv_api_uniqueid='31097_54' WHERE id='54' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9545634351', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_55' WHERE id='55' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7447560417', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_56' WHERE id='56' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275351862', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_57' WHERE id='57' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7666582972', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_58' WHERE id='58' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '9403418820', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_59' WHERE id='59' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8055841472', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_60' WHERE id='60' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7304304466', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_61' WHERE id='61' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9922874538', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_62' WHERE id='62' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '9403236501', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_63' WHERE id='63' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9403299807', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_64' WHERE id='64' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8378894842', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_65' WHERE id='65' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9623098778', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_66' WHERE id='66' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8806797805', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_67' WHERE id='67' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7972529374', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_68' WHERE id='68' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8999772091', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_69' WHERE id='69' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9421713215', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_70' WHERE id='70' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '9527649452', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_71' WHERE id='71' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7507547662', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_72' WHERE id='72' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9850604186', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_73' WHERE id='73' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9404229349', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_74' WHERE id='74' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9403417247', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_75' WHERE id='75' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275182473', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066613', sarv_api_uniqueid='31097_76' WHERE id='76' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9607747651', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_77' WHERE id='77' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9067179050', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_78' WHERE id='78' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7588411719', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_79' WHERE id='79' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9764111842', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_80' WHERE id='80' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8275840400', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_81' WHERE id='81' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9373035965', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_82' WHERE id='82' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9404205917', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_83' WHERE id='83' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7887697681', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_84' WHERE id='84' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9579228924', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_85' WHERE id='85' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8698958102', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_86' WHERE id='86' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8788169522', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_87' WHERE id='87' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9637696879', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_88' WHERE id='88' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9011013562', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_89' WHERE id='89' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8657255477', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_90' WHERE id='90' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9404825182', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_91' WHERE id='91' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9834855358', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_92' WHERE id='92' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7588772641', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_93' WHERE id='93' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31097', '7588772175', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_94' WHERE id='94' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9356415912', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_95' WHERE id='95' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9674235264', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_96' WHERE id='96' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '6352801067', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066614', sarv_api_uniqueid='31097_97' WHERE id='97' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9096243242', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066615', sarv_api_uniqueid='31097_98' WHERE id='98' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '8698033731', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066615', sarv_api_uniqueid='31097_99' WHERE id='99' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9765596665', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066615', sarv_api_uniqueid='31097_100' WHERE id='100' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '7980009320', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066615', sarv_api_uniqueid='31097_101' WHERE id='101' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='31097' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+11 WHERE id=125685 LIMIT 1 27-03-2025 02:40:19 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9921721465 -- announcement_id=>5785 -- 27-03-2025 02:40:20 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_5785__35_35_30_0.11_38_2_30_1743013800 compaign_id=> 31097 sql_contact_insert=> INSERT INTO voice_compaign_detail_31097(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31097', '9921721465', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31097 SET status='S', sent_date='1743066622', sarv_api_uniqueid='31097_102' WHERE id='102' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='31097' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.22 WHERE id=125685 LIMIT 1 27-03-2025 02:46:09 pm username=>sr62 -- token=>8wsys8 -- announcement_id=>4196 -- caller_id=>1234567890 -- plan_id=>1037 -- contact_numbers=>8943478282 -- 27-03-2025 02:46:09 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr62_1037_3_A_4196__29_29_30_0.15_5_1_30_1743013800 compaign_id=> 30998 sql_contact_insert=> INSERT INTO voice_compaign_detail_30998(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('30998', '8943478282', 'P', '29', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_30998 SET status='S', sent_date='1743066970', sarv_api_uniqueid='30998_2' WHERE id='2' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr62' AND type='D' AND compaign_id='30998' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.15 WHERE id=125238 LIMIT 1 27-03-2025 03:01:10 pm username=>sr190 -- token=>5REKc4 -- announcement_id=>5709 -- plan_id=>790 -- contact_numbers=>918278876726 -- retry_json=>{"FNA":"1","FBZ":"1","FCG":"2","FFL":"2"} -- 27-03-2025 03:01:10 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr190_790_17_A_5709__35_35_15_0.08_24_2_15_1743013800 compaign_id=> 31053 sql_contact_insert=> INSERT INTO voice_compaign_detail_31053(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31053', '8278876726', 'P', '35', '0', '{"FNA":"1","FBZ":"1","FCG":"2","FFL":"2"}') sql_contact_update=> UPDATE voice_compaign_detail_31053 SET status='S', sent_date='1743067873', sarv_api_uniqueid='31053_2' WHERE id='2' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr190' AND type='D' AND compaign_id='31053' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.16 WHERE id=125505 LIMIT 1 27-03-2025 05:03:02 pm username=>sr190 -- token=>5REKc4 -- announcement_id=>5709 -- plan_id=>790 -- contact_numbers=>919572304239 -- retry_json=>{"FNA":"1","FBZ":"1","FCG":"2","FFL":"2"} -- 27-03-2025 05:03:02 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> sr190_790_17_A_5709__35_35_15_0.08_24_2_15_1743013800 compaign_id=> 31053 sql_contact_insert=> INSERT INTO voice_compaign_detail_31053(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31053', '9572304239', 'P', '35', '0', '{"FNA":"1","FBZ":"1","FCG":"2","FFL":"2"}') sql_contact_update=> UPDATE voice_compaign_detail_31053 SET status='S', sent_date='1743075184', sarv_api_uniqueid='31053_3' WHERE id='3' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr190' AND type='D' AND compaign_id='31053' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.16 WHERE id=125505 LIMIT 1 27-03-2025 05:04:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3674 -- plan_id=>894 -- contact_numbers=>8523935848 -- 27-03-2025 05:04:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3674 -- plan_id=>894 -- contact_numbers=>8072301606 -- 27-03-2025 05:04:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3674__35_35_30_0.3_48_4_30_1743013800 compaign_id=> 31149 sql_contact_insert=> INSERT INTO voice_compaign_detail_31149(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31149', '8523935848', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31149 SET status='S', sent_date='1743075241', sarv_api_uniqueid='31149_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='31149' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('u531', 'user', '31149', '0.6', 'D', '1743075242', '0.3', '2', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='31149' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('sr195', 'superreseller', '31149', '0.26', 'D', '1743075242', '0.13', '2', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='31149' AND no_of_pulse='4' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('sr83', 'superreseller', '31149', '0.22', 'D', '1743075242', '0.055', '4', 'answered','15') 27-03-2025 05:04:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3674__35_35_30_0.3_48_4_30_1743013800 compaign_id=> sql_comp_insert=> INSERT INTO voice_compaign_summary(user_id, filename, compaign_type, announcement_id, sender_id, start_date, status, alloted_api, api_type, voice_file,gateway_id, user_voice_plan_id,voice_plan_id,caller_id,delivery_route,delivery_type,delivery_cli,pulse,pulse_rate,duration,credits_per_sms,user_pulse,ext_duration , uphierarchy) VALUES( 'u531', 'YouTube_Audio_Playback.mp3', 'A', '3674', '', '1743075241', 'C', '35', 'S', 'api_1737439038_u531_voice_757.wav','35','894','56','','promo','answered','static','30','0.3','48','2','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 31149 sql_contact_insert=> INSERT INTO voice_compaign_detail_31149(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('31149', '8072301606', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_31149 SET status='S', sent_date='1743075241', sarv_api_uniqueid='31149_2' WHERE id='2' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='31149' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('u531', 'user', '31149', '0.6', 'D', '1743075242', '0.3', '2', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='31149' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('sr195', 'superreseller', '31149', '0.26', 'D', '1743075242', '0.13', '2', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='31149' AND no_of_pulse='4' AND plan_type='answered' LIMIT 1 sql_i=>INSERT INTO voice_compaign_credit_invoices(user_id, user_type, compaign_id, amount, type, create_date, pulse_rate, no_of_pulse, plan_type, pulse) VALUES('sr83', 'superreseller', '31149', '0.22', 'D', '1743075242', '0.055', '4', 'answered','15') 27-03-2025 05:19:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>5762 -- plan_id=>894 -- contact_numbers=>8056003157 -- 27-03-2025 05:19:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_5762__35_35_30_0.3_4_1_30_1743013800 compaign_id=> 31066 sql_contact_insert=> INSERT INTO voice_compaign_detail_31066(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('31066', '8056003157', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_31066 SET status='S', sent_date='1743076141', sarv_api_uniqueid='31066_2' WHERE id='2' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='31066' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.3 WHERE id=125536 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='31066' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.13 WHERE id=125537 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='31066' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.055 WHERE id=125538 LIMIT 1