15-02-2025 09:48:00 am username=>u531 -- token=>lwrvcu -- announcement_id=>4489 -- plan_id=>894 -- contact_numbers=>9551362239 -- 15-02-2025 09:48:00 am username=>u531 -- token=>lwrvcu -- announcement_id=>4489 -- plan_id=>894 -- contact_numbers=>8686360372 -- 15-02-2025 01:22:06 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9254021578,9254066197 -- announcement_id=>4512 -- 15-02-2025 01:22:06 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_4512__35_35_30_0.11_49_2_30_1739557800 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', '20250215131916pm3437267710.wav', 'A', '4512', '', '1739605926', 'C', '35', 'S', 'api_1739605765_u4_voice_718.wav','35','25','23','','promo','answered','static','30','0.11','49','2','30','0' , 'admin,u4') again_get_cID=> 23515 sql_contact_insert=> INSERT INTO voice_compaign_detail_23515(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23515', '9254021578', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_23515 SET status='S', sent_date='1739605927', sarv_api_uniqueid='23515_1' WHERE id='1' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23515(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23515', '9254066197', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_23515 SET status='S', sent_date='1739605927', sarv_api_uniqueid='23515_2' WHERE id='2' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='23515' 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', '23515', '0.44', 'D', '1739605928', '0.11', '2', 'answered','30') 15-02-2025 03:53:39 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4520 -- caller_id=>8985705878 -- contact_numbers=>9963022227 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 15-02-2025 03:53:39 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_4520__35_35_15_0.16_7_1_15_1739557800 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', 'a74215325e5d410a899b4e1c7542b8a5.mp3', 'A', '4520', '', '1739615020', 'C', '35', 'S', 'api_1739614730_u635_voice_581.wav','35','1050','13','','promo','answered','static','15','0.16','7','1','15','0' , 'admin,u635') again_get_cID=> 23557 sql_contact_insert=> INSERT INTO voice_compaign_detail_23557(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23557', '9963022227', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23557 SET status='S', sent_date='1739615020', sarv_api_uniqueid='23557_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='23557' 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', '23557', '0.16', 'D', '1739615021', '0.16', '1', 'answered','15') 15-02-2025 03:54:35 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4520 -- caller_id=>8985705878 -- contact_numbers=>9963022227,9642325055,9908947904 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 15-02-2025 03:54:35 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_4520__35_35_15_0.16_7_1_15_1739557800 compaign_id=> 23557 sql_contact_insert=> INSERT INTO voice_compaign_detail_23557(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23557', '9963022227', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23557 SET status='S', sent_date='1739615077', sarv_api_uniqueid='23557_2' WHERE id='2' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23557(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('23557', '9642325055', 'S', '-3', '0', 'N', 'N', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}' ) sql_contact_update=> UPDATE voice_compaign_detail_23557 SET status='S', sent_date='1739615077', sarv_api_uniqueid='23557_3' WHERE id='3' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23557(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23557', '9908947904', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23557 SET status='S', sent_date='1739615077', sarv_api_uniqueid='23557_4' WHERE id='4' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u635' AND type='D' AND compaign_id='23557' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.48 WHERE id=93960 LIMIT 1 15-02-2025 03:56:37 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4520 -- caller_id=>8985705878 -- contact_numbers=>9963022227,9642325055,9908947904,8985705878,7396066679,9949792933 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 15-02-2025 03:56:37 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_4520__35_35_15_0.16_7_1_15_1739557800 compaign_id=> 23557 sql_contact_insert=> INSERT INTO voice_compaign_detail_23557(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23557', '9963022227', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23557 SET status='S', sent_date='1739615198', sarv_api_uniqueid='23557_5' WHERE id='5' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23557(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('23557', '9642325055', 'S', '-3', '0', 'N', 'N', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}' ) sql_contact_update=> UPDATE voice_compaign_detail_23557 SET status='S', sent_date='1739615198', sarv_api_uniqueid='23557_6' WHERE id='6' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23557(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23557', '9908947904', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23557 SET status='S', sent_date='1739615198', sarv_api_uniqueid='23557_7' WHERE id='7' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23557(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23557', '8985705878', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23557 SET status='S', sent_date='1739615198', sarv_api_uniqueid='23557_8' WHERE id='8' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23557(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23557', '7396066679', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23557 SET status='S', sent_date='1739615198', sarv_api_uniqueid='23557_9' WHERE id='9' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_23557(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23557', '9949792933', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23557 SET status='S', sent_date='1739615198', sarv_api_uniqueid='23557_10' WHERE id='10' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u635' AND type='D' AND compaign_id='23557' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.96 WHERE id=93960 LIMIT 1 15-02-2025 04:16:11 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4522 -- caller_id=>8985705878 -- contact_numbers=>7396066679 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 15-02-2025 04:16:11 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_4522__35_35_15_0.16_7_1_15_1739557800 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', '1fa4c552cad045c38d8e9589fca4e559.mp3', 'A', '4522', '', '1739616371', 'C', '35', 'S', 'api_1739616370_u635_voice_585.wav','35','1050','13','','promo','answered','static','15','0.16','7','1','15','0' , 'admin,u635') again_get_cID=> 23562 sql_contact_insert=> INSERT INTO voice_compaign_detail_23562(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23562', '7396066679', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23562 SET status='S', sent_date='1739616372', sarv_api_uniqueid='23562_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='23562' 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', '23562', '0.16', 'D', '1739616372', '0.16', '1', 'answered','15') 15-02-2025 04:17:54 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4523 -- caller_id=>8985705878 -- contact_numbers=>99630222227 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 15-02-2025 04:18:54 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4524 -- caller_id=>8985705878 -- contact_numbers=>8985705878 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 15-02-2025 04:18:54 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_4524__35_35_15_0.16_7_1_15_1739557800 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', 'ee78f8422cab47daa26264e1a1882e76.mp3', 'A', '4524', '', '1739616534', 'C', '35', 'S', 'api_1739616533_u635_voice_120.wav','35','1050','13','','promo','answered','static','15','0.16','7','1','15','0' , 'admin,u635') again_get_cID=> 23565 sql_contact_insert=> INSERT INTO voice_compaign_detail_23565(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23565', '8985705878', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23565 SET status='S', sent_date='1739616535', sarv_api_uniqueid='23565_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='23565' 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', '23565', '0.16', 'D', '1739616535', '0.16', '1', 'answered','15') 15-02-2025 04:39:29 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>null -- caller_id=>8985705878 -- contact_numbers=>7396066679 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 15-02-2025 05:52:48 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4530 -- caller_id=>8985705878 -- contact_numbers=>8985705878 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 15-02-2025 05:52:48 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_4530__35_35_15_0.16_4_1_15_1739557800 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', '46f7ddfd666743d1bc5c041aec7fa4c3.mp3', 'A', '4530', '', '1739622169', 'C', '35', 'S', 'api_1739622168_u635_voice_494.wav','35','1050','13','','promo','answered','static','15','0.16','4','1','15','0' , 'admin,u635') again_get_cID=> 23604 sql_contact_insert=> INSERT INTO voice_compaign_detail_23604(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23604', '8985705878', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23604 SET status='S', sent_date='1739622169', sarv_api_uniqueid='23604_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='23604' 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', '23604', '0.16', 'D', '1739622170', '0.16', '1', 'answered','15') 15-02-2025 05:53:38 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4531 -- caller_id=>8985705878 -- contact_numbers=>9030855545 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} -- 15-02-2025 05:53:38 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u635_1050_13_A_4531__35_35_15_0.16_5_1_15_1739557800 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', 'd83136bff35f40feac567045ff400001.mp3', 'A', '4531', '', '1739622219', 'C', '35', 'S', 'api_1739622218_u635_voice_617.wav','35','1050','13','','promo','answered','static','15','0.16','5','1','15','0' , 'admin,u635') again_get_cID=> 23606 sql_contact_insert=> INSERT INTO voice_compaign_detail_23606(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('23606', '9030855545', 'P', '35', '0', '{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"}') sql_contact_update=> UPDATE voice_compaign_detail_23606 SET status='S', sent_date='1739622220', sarv_api_uniqueid='23606_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='23606' 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', '23606', '0.16', 'D', '1739622220', '0.16', '1', 'answered','15') 15-02-2025 06:02:17 pm username=>u86 -- token=>alFAFK -- plan_id=>1054 -- announcement_id=>567 -- caller_id=>2 -- contact_numbers=>9838078783 -- retry_json=>{"FNA":"2","FBZ":"2","FCG":"2","FFL":"1"} -- dtmf_wait=>2 -- dtmf_wait_time=>2 -- 15-02-2025 06:02:17 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u86_1054_17_A_567__35_35_15_0.09_27_2_15_DTMFWT_2_1739557800 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 ,dtmf_wait_time , uphierarchy) VALUES( 'u86', '10 months11.mp3', 'A', '567', '', '1739622737', 'C', '35', 'S', '1728128005_u86_voice.wav','35','1054','17','','promo','answered','static','15','0.09','27','2','15','0' , 2 , 'admin,sr3,u86') again_get_cID=> 23608 sql_contact_insert=> INSERT INTO voice_compaign_detail_23608(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('23608', '9838078783', 'S', '-3', '0', 'N', 'N', '{"FNA":"2","FBZ":"2","FCG":"2","FFL":"1"}' ) sql_contact_update=> UPDATE voice_compaign_detail_23608 SET status='S', sent_date='1739622738', sarv_api_uniqueid='23608_1' WHERE id='1' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u86' AND type='D' AND compaign_id='23608' 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('u86', 'user', '23608', '0.18', 'D', '1739622738', '0.09', '2', 'answered','15') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr3' AND type='D' AND compaign_id='23608' 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('sr3', 'superreseller', '23608', '0.14', 'D', '1739622738', '0.07', '2', 'answered','15') 15-02-2025 10:08:26 pm username=>u635 -- token=>VFnIeT -- plan_id=>1050 -- announcement_id=>4534 -- caller_id=>8985705878 -- contact_numbers=>9030402242 -- retry_json=>{"FNA":"1","FBZ":0,"FCG":"2","FFL":"1"} --