23-01-2025 08:41:03 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7454092508 -- announcement_id=>3704 -- 23-01-2025 09:45:07 am username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>821827294 -- announcement_id=>3704 -- 23-01-2025 10:56:00 am username=>u531 -- token=>lwrvcu -- announcement_id=>3708 -- plan_id=>894 -- contact_numbers=>9790515061 -- 23-01-2025 10:56:00 am username=>u531 -- token=>lwrvcu -- announcement_id=>3708 -- plan_id=>894 -- contact_numbers=>9597280269 -- 23-01-2025 10:56:00 am username=>u531 -- token=>lwrvcu -- announcement_id=>3708 -- plan_id=>894 -- contact_numbers=>8686360372 -- 23-01-2025 10:56:00 am username=>u531 -- token=>lwrvcu -- announcement_id=>3708 -- plan_id=>894 -- contact_numbers=>9677886319 -- 23-01-2025 10:56:00 am username=>u531 -- token=>lwrvcu -- announcement_id=>3708 -- plan_id=>894 -- contact_numbers=>9551362239 -- 23-01-2025 10:56:00 am username=>u531 -- token=>lwrvcu -- announcement_id=>3708 -- plan_id=>894 -- contact_numbers=>8838186584 -- 23-01-2025 10:56:01 am username=>u531 -- token=>lwrvcu -- announcement_id=>3708 -- plan_id=>894 -- contact_numbers=>9014597079 -- 23-01-2025 10:56:00 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3708__35_35_30_0.3_41_3_30_1737570600 compaign_id=> 18777 sql_contact_insert=> INSERT INTO voice_compaign_detail_18777(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('18777', '9597280269', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_18777 SET status='S', sent_date='1737609961', sarv_api_uniqueid='18777_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='18777' 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', '18777', '0.6', 'D', '1737609962', '0.3', '2', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18777' 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', '18777', '0.26', 'D', '1737609962', '0.13', '2', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18777' AND no_of_pulse='3' 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', '18777', '0.165', 'D', '1737609962', '0.055', '3', 'answered','15') 23-01-2025 10:56:00 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3708__35_35_30_0.3_41_3_30_1737570600 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', 'hosur_sda_students_1.mp3', 'A', '3708', '', '1737609961', 'C', '35', 'S', 'api_1737609777_u531_voice_357.wav','35','894','56','','promo','answered','static','30','0.3','41','2','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 18777 sql_contact_insert=> INSERT INTO voice_compaign_detail_18777(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18777', '8686360372', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18777 SET status='S', sent_date='1737609961', sarv_api_uniqueid='18777_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='18777' 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', '18777', '0.6', 'D', '1737609962', '0.3', '2', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18777' 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', '18777', '0.26', 'D', '1737609962', '0.13', '2', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18777' AND no_of_pulse='3' 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', '18777', '0.165', 'D', '1737609962', '0.055', '3', 'answered','15') 23-01-2025 10:56:00 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3708__35_35_30_0.3_41_3_30_1737570600 compaign_id=> 18777 sql_contact_insert=> INSERT INTO voice_compaign_detail_18777(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18777', '9790515061', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18777 SET status='S', sent_date='1737609961', sarv_api_uniqueid='18777_3' WHERE id='3' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.6 WHERE id=75424 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.26 WHERE id=75426 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18777' AND no_of_pulse='3' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.165 WHERE id=75428 LIMIT 1 23-01-2025 10:56:01 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3708__35_35_30_0.3_41_3_30_1737570600 compaign_id=> 18777 sql_contact_insert=> INSERT INTO voice_compaign_detail_18777(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18777', '9677886319', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18777 SET status='S', sent_date='1737609962', sarv_api_uniqueid='18777_4' WHERE id='4' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.6 WHERE id=75424 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.26 WHERE id=75426 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18777' AND no_of_pulse='3' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.165 WHERE id=75428 LIMIT 1 23-01-2025 10:56:01 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3708__35_35_30_0.3_41_3_30_1737570600 compaign_id=> 18777 sql_contact_insert=> INSERT INTO voice_compaign_detail_18777(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18777', '9014597079', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18777 SET status='S', sent_date='1737609962', sarv_api_uniqueid='18777_5' WHERE id='5' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.6 WHERE id=75424 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.26 WHERE id=75426 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18777' AND no_of_pulse='3' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.165 WHERE id=75428 LIMIT 1 23-01-2025 10:56:01 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3708__35_35_30_0.3_41_3_30_1737570600 compaign_id=> 18777 sql_contact_insert=> INSERT INTO voice_compaign_detail_18777(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18777', '8838186584', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18777 SET status='S', sent_date='1737609962', sarv_api_uniqueid='18777_6' WHERE id='6' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.6 WHERE id=75424 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.26 WHERE id=75426 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18777' AND no_of_pulse='3' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.165 WHERE id=75428 LIMIT 1 23-01-2025 10:56:01 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3708__35_35_30_0.3_41_3_30_1737570600 compaign_id=> 18777 sql_contact_insert=> INSERT INTO voice_compaign_detail_18777(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18777', '9551362239', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18777 SET status='S', sent_date='1737609962', sarv_api_uniqueid='18777_7' WHERE id='7' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.6 WHERE id=75424 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.26 WHERE id=75426 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18777' AND no_of_pulse='3' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.165 WHERE id=75428 LIMIT 1 23-01-2025 11:21:00 am username=>u531 -- token=>lwrvcu -- announcement_id=>3708 -- plan_id=>894 -- contact_numbers=>9551362239 -- 23-01-2025 11:21:00 amget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3708__35_35_30_0.3_41_3_30_1737570600 compaign_id=> 18777 sql_contact_insert=> INSERT INTO voice_compaign_detail_18777(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18777', '9551362239', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18777 SET status='S', sent_date='1737611461', sarv_api_uniqueid='18777_8' WHERE id='8' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.6 WHERE id=75424 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18777' AND no_of_pulse='2' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.26 WHERE id=75426 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18777' AND no_of_pulse='3' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.165 WHERE id=75428 LIMIT 1 23-01-2025 12:27:45 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=> 919557765848 -- announcement_id=>3707 -- 23-01-2025 12:27:45 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3707__35_35_30_0.11_49_2_30_1737570600 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', '20250122232952pm6051218803.wav', 'A', '3707', '', '1737615465', 'C', '35', 'S', 'api_1737568801_u4_voice_655.wav','35','25','23','','promo','answered','static','30','0.11','49','2','30','0' , 'admin,u4') again_get_cID=> 18798 sql_contact_insert=> INSERT INTO voice_compaign_detail_18798(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18798', '9557765848', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18798 SET status='S', sent_date='1737615466', sarv_api_uniqueid='18798_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='18798' 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', '18798', '0.22', 'D', '1737615467', '0.11', '2', 'answered','30') 23-01-2025 12:28:21 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9620004302 -- announcement_id=>3707 -- 23-01-2025 12:28:21 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3707__35_35_30_0.11_49_2_30_1737570600 compaign_id=> 18798 sql_contact_insert=> INSERT INTO voice_compaign_detail_18798(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18798', '9620004302', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18798 SET status='S', sent_date='1737615502', sarv_api_uniqueid='18798_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='18798' 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=75506 LIMIT 1 23-01-2025 12:28:52 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9520004302 -- announcement_id=>3707 -- 23-01-2025 12:28:52 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3707__35_35_30_0.11_49_2_30_1737570600 compaign_id=> 18798 sql_contact_insert=> INSERT INTO voice_compaign_detail_18798(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18798', '9520004302', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18798 SET status='S', sent_date='1737615534', sarv_api_uniqueid='18798_3' WHERE id='3' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18798' 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=75506 LIMIT 1 23-01-2025 12:29:43 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=> 919520004302 -- announcement_id=>3707 -- 23-01-2025 12:29:43 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3707__35_35_30_0.11_49_2_30_1737570600 compaign_id=> 18798 sql_contact_insert=> INSERT INTO voice_compaign_detail_18798(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18798', '9520004302', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18798 SET status='S', sent_date='1737615585', sarv_api_uniqueid='18798_4' WHERE id='4' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18798' 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=75506 LIMIT 1 23-01-2025 12:32:43 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9520004302 -- announcement_id=>3707 -- 23-01-2025 12:32:43 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3707__35_35_30_0.11_49_2_30_1737570600 compaign_id=> 18798 sql_contact_insert=> INSERT INTO voice_compaign_detail_18798(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18798', '9520004302', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18798 SET status='S', sent_date='1737615764', sarv_api_uniqueid='18798_5' WHERE id='5' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18798' 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=75506 LIMIT 1 23-01-2025 12:33:57 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=> 919897574717 -- announcement_id=>3707 -- 23-01-2025 12:33:57 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3707__35_35_30_0.11_49_2_30_1737570600 compaign_id=> 18798 sql_contact_insert=> INSERT INTO voice_compaign_detail_18798(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18798', '9897574717', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18798 SET status='S', sent_date='1737615839', sarv_api_uniqueid='18798_6' WHERE id='6' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18798' 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=75506 LIMIT 1 23-01-2025 12:34:32 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=> 919897574717 -- announcement_id=>3707 -- 23-01-2025 12:34:32 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3707__35_35_30_0.11_49_2_30_1737570600 compaign_id=> 18798 sql_contact_insert=> INSERT INTO voice_compaign_detail_18798(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18798', '9897574717', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18798 SET status='S', sent_date='1737615874', sarv_api_uniqueid='18798_7' WHERE id='7' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18798' 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=75506 LIMIT 1 23-01-2025 03:44:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3721 -- plan_id=>894 -- contact_numbers=>8925214148 -- 23-01-2025 03:44:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3721__35_35_30_0.3_4_1_30_1737570600 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', 'Standard_1.mp3', 'A', '3721', '', '1737627240', 'C', '35', 'S', 'api_1737627176_u531_voice_225.wav','35','894','56','','promo','answered','static','30','0.3','4','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 18843 sql_contact_insert=> INSERT INTO voice_compaign_detail_18843(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18843', '8925214148', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18843 SET status='S', sent_date='1737627241', sarv_api_uniqueid='18843_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='18843' 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', '18843', '0.3', 'D', '1737627241', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18843' 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', '18843', '0.13', 'D', '1737627241', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18843' 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', '18843', '0.055', 'D', '1737627241', '0.055', '1', 'answered','15') 23-01-2025 03:46:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3721 -- plan_id=>894 -- contact_numbers=>8925214148 -- 23-01-2025 03:46:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3721__35_35_30_0.3_4_1_30_1737570600 compaign_id=> 18843 sql_contact_insert=> INSERT INTO voice_compaign_detail_18843(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18843', '8925214148', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18843 SET status='S', sent_date='1737627361', sarv_api_uniqueid='18843_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='18843' 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=75701 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18843' 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=75702 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18843' 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=75703 LIMIT 1 23-01-2025 03:50:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3721 -- plan_id=>894 -- contact_numbers=>8925214148 -- 23-01-2025 03:50:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3721 -- plan_id=>894 -- contact_numbers=>8943049602 -- 23-01-2025 03:50:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3721__35_35_30_0.3_4_1_30_1737570600 compaign_id=> 18843 sql_contact_insert=> INSERT INTO voice_compaign_detail_18843(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18843', '8943049602', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18843 SET status='S', sent_date='1737627601', sarv_api_uniqueid='18843_3' WHERE id='3' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18843' 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=75701 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18843' 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=75702 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18843' 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=75703 LIMIT 1 23-01-2025 03:50:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3721__35_35_30_0.3_4_1_30_1737570600 compaign_id=> 18843 sql_contact_insert=> INSERT INTO voice_compaign_detail_18843(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18843', '8925214148', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18843 SET status='S', sent_date='1737627601', sarv_api_uniqueid='18843_4' WHERE id='4' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18843' 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=75701 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18843' 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=75702 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18843' 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=75703 LIMIT 1 23-01-2025 03:53:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3721 -- plan_id=>894 -- contact_numbers=>8925214148 -- 23-01-2025 03:53:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3721 -- plan_id=>894 -- contact_numbers=>9843049602 -- 23-01-2025 03:53:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3721__35_35_30_0.3_4_1_30_1737570600 compaign_id=> 18843 sql_contact_insert=> INSERT INTO voice_compaign_detail_18843(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('18843', '9843049602', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_18843 SET status='S', sent_date='1737627781', sarv_api_uniqueid='18843_6' WHERE id='6' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18843' 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=75701 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18843' 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=75702 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18843' 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=75703 LIMIT 1 23-01-2025 03:53:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3721__35_35_30_0.3_4_1_30_1737570600 compaign_id=> 18843 sql_contact_insert=> INSERT INTO voice_compaign_detail_18843(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18843', '8925214148', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18843 SET status='S', sent_date='1737627781', sarv_api_uniqueid='18843_5' WHERE id='5' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18843' 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=75701 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18843' 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=75702 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18843' 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=75703 LIMIT 1 23-01-2025 03:57:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3721 -- plan_id=>894 -- contact_numbers=>9843049602 -- 23-01-2025 03:57:04 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3721 -- plan_id=>894 -- contact_numbers=>9843049602 -- 23-01-2025 03:57:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3721__35_35_30_0.3_4_1_30_1737570600 compaign_id=> 18843 sql_contact_insert=> INSERT INTO voice_compaign_detail_18843(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('18843', '9843049602', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_18843 SET status='S', sent_date='1737628022', sarv_api_uniqueid='18843_7' WHERE id='7' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18843' 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=75701 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18843' 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=75702 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18843' 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=75703 LIMIT 1 23-01-2025 03:57:04 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3721__35_35_30_0.3_4_1_30_1737570600 compaign_id=> 18843 sql_contact_insert=> INSERT INTO voice_compaign_detail_18843(compaign_id, mobile_no, status, api_id, whitelist_status, report, user_report,retry) VALUES('18843', '9843049602', 'S', '-3', '0', 'N', 'N', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}' ) sql_contact_update=> UPDATE voice_compaign_detail_18843 SET status='S', sent_date='1737628026', sarv_api_uniqueid='18843_8' WHERE id='8' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u531' AND type='D' AND compaign_id='18843' 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=75701 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18843' 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=75702 LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18843' 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=75703 LIMIT 1 23-01-2025 04:11:28 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7682827532,8053497080 -- announcement_id=>3720 -- 23-01-2025 04:11:29 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3720__35_35_30_0.11_29_1_30_1737570600 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', '20250123154014pm9581757859.wav', 'A', '3720', '', '1737628889', 'C', '35', 'S', 'api_1737627018_u4_voice_776.wav','35','25','23','','promo','answered','static','30','0.11','29','1','30','0' , 'admin,u4') again_get_cID=> 18846 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '7682827532', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737628890', sarv_api_uniqueid='18846_1' WHERE id='1' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '8053497080', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737628890', sarv_api_uniqueid='18846_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='18846' 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('u4', 'user', '18846', '0.22', 'D', '1737628890', '0.11', '1', 'answered','30') 23-01-2025 04:15:46 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>6372575744 -- announcement_id=>3720 -- 23-01-2025 04:15:46 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3720__35_35_30_0.11_29_1_30_1737570600 compaign_id=> 18846 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '6372575744', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737629147', sarv_api_uniqueid='18846_3' WHERE id='3' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18846' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=75713 LIMIT 1 23-01-2025 04:16:54 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9861129129 -- announcement_id=>3720 -- 23-01-2025 04:16:54 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3720__35_35_30_0.11_29_1_30_1737570600 compaign_id=> 18846 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '9861129129', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737629217', sarv_api_uniqueid='18846_4' WHERE id='4' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18846' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=75713 LIMIT 1 23-01-2025 04:22:38 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9861129129 -- announcement_id=>3722 -- 23-01-2025 04:22:38 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3722__35_35_30_0.11_28_1_30_1737570600 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', '20250123161042pm5625672857.wav', 'A', '3722', '', '1737629559', 'C', '35', 'S', 'api_1737628849_u4_voice_500.wav','35','25','23','','promo','answered','static','30','0.11','28','1','30','0' , 'admin,u4') again_get_cID=> 18849 sql_contact_insert=> INSERT INTO voice_compaign_detail_18849(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18849', '9861129129', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18849 SET status='S', sent_date='1737629560', sarv_api_uniqueid='18849_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='18849' 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('u4', 'user', '18849', '0.11', 'D', '1737629560', '0.11', '1', 'answered','30') 23-01-2025 04:27:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3724 -- plan_id=>894 -- contact_numbers=>8072301606 -- 23-01-2025 04:27:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3724__35_35_30_0.3_79_6_30_1737570600 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', 'Dream_English_Traditional_ABC01_UNEqTGI.wav', 'A', '3724', '', '1737629820', 'C', '35', 'S', 'api_1737629754_u531_voice_518.wav','35','894','56','','promo','answered','static','30','0.3','79','3','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 18850 sql_contact_insert=> INSERT INTO voice_compaign_detail_18850(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18850', '8072301606', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18850 SET status='S', sent_date='1737629821', sarv_api_uniqueid='18850_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='18850' AND no_of_pulse='3' 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', '18850', '0.9', 'D', '1737629821', '0.3', '3', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18850' AND no_of_pulse='3' 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', '18850', '0.39', 'D', '1737629821', '0.13', '3', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18850' AND no_of_pulse='6' 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', '18850', '0.33', 'D', '1737629821', '0.055', '6', 'answered','15') 23-01-2025 04:28:56 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>700861443 -- announcement_id=>3720 -- 23-01-2025 04:30:24 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7008614443 -- announcement_id=>3720 -- 23-01-2025 04:30:24 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3720__35_35_30_0.11_29_1_30_1737570600 compaign_id=> 18846 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '7008614443', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737630027', sarv_api_uniqueid='18846_5' WHERE id='5' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18846' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=75713 LIMIT 1 23-01-2025 04:32:53 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7008614443 -- announcement_id=>3722 -- 23-01-2025 04:32:53 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3722__35_35_30_0.11_28_1_30_1737570600 compaign_id=> 18849 sql_contact_insert=> INSERT INTO voice_compaign_detail_18849(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18849', '7008614443', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18849 SET status='S', sent_date='1737630175', sarv_api_uniqueid='18849_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='18849' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=75718 LIMIT 1 23-01-2025 04:36:19 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>8249015887 -- announcement_id=>3720 -- 23-01-2025 04:36:19 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3720__35_35_30_0.11_29_1_30_1737570600 compaign_id=> 18846 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '8249015887', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737630381', sarv_api_uniqueid='18846_6' WHERE id='6' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18846' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=75713 LIMIT 1 23-01-2025 04:40:47 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>6372575744,9861129129 -- announcement_id=>3720 -- 23-01-2025 04:40:47 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3720__35_35_30_0.11_29_1_30_1737570600 compaign_id=> 18846 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '6372575744', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737630648', sarv_api_uniqueid='18846_7' WHERE id='7' LIMIT 1 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '9861129129', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737630648', sarv_api_uniqueid='18846_8' WHERE id='8' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18846' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.22 WHERE id=75713 LIMIT 1 23-01-2025 04:44:38 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7608050288 -- announcement_id=>3720 -- 23-01-2025 04:44:38 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3720__35_35_30_0.11_29_1_30_1737570600 compaign_id=> 18846 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '7608050288', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737630879', sarv_api_uniqueid='18846_9' WHERE id='9' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18846' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=75713 LIMIT 1 23-01-2025 04:46:59 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7064991001 -- announcement_id=>3720 -- 23-01-2025 04:46:59 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3720__35_35_30_0.11_29_1_30_1737570600 compaign_id=> 18846 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '7064991001', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737631020', sarv_api_uniqueid='18846_10' WHERE id='10' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18846' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=75713 LIMIT 1 23-01-2025 04:49:44 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>9937314156 -- announcement_id=>3720 -- 23-01-2025 04:49:44 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3720__35_35_30_0.11_29_1_30_1737570600 compaign_id=> 18846 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '9937314156', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737631185', sarv_api_uniqueid='18846_11' WHERE id='11' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18846' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=75713 LIMIT 1 23-01-2025 05:00:37 pm username=>u4 -- token=>ruNtks -- plan_id=>25 -- contact_numbers=>7608050288 -- announcement_id=>3720 -- 23-01-2025 05:00:37 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u4_25_23_A_3720__35_35_30_0.11_29_1_30_1737570600 compaign_id=> 18846 sql_contact_insert=> INSERT INTO voice_compaign_detail_18846(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18846', '7608050288', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18846 SET status='S', sent_date='1737631838', sarv_api_uniqueid='18846_12' WHERE id='12' LIMIT 1 sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='u4' AND type='D' AND compaign_id='18846' AND no_of_pulse='1' AND plan_type='answered' LIMIT 1 sql_i_update=> UPDATE voice_compaign_credit_invoices SET amount=amount+0.11 WHERE id=75713 LIMIT 1 23-01-2025 05:13:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3726 -- plan_id=>894 -- contact_numbers=>9789890137 -- 23-01-2025 05:13:00 pmget_user_limit=> USER_IVR_CAMPAIGN_ID_KEY=> u531_894_56_A_3726__35_35_30_0.3_5_1_30_1737570600 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', 'audio7182375412698019936.wav', 'A', '3726', '', '1737632580', 'C', '35', 'S', 'api_1737632544_u531_voice_995.wav','35','894','56','','promo','answered','static','30','0.3','5','1','30','0' , 'admin,sr83,sr195,u531') again_get_cID=> 18869 sql_contact_insert=> INSERT INTO voice_compaign_detail_18869(compaign_id, mobile_no, status, api_id, whitelist_status, retry) VALUES('18869', '9789890137', 'P', '35', '0', '{"FNA":0,"FBZ":0,"FCG":0,"FFL":0}') sql_contact_update=> UPDATE voice_compaign_detail_18869 SET status='S', sent_date='1737632581', sarv_api_uniqueid='18869_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='18869' 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', '18869', '0.3', 'D', '1737632581', '0.3', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr195' AND type='D' AND compaign_id='18869' 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', '18869', '0.13', 'D', '1737632581', '0.13', '1', 'answered','30') sql_i_select=> SELECT * FROM voice_compaign_credit_invoices WHERE user_id='sr83' AND type='D' AND compaign_id='18869' 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', '18869', '0.055', 'D', '1737632581', '0.055', '1', 'answered','15') 23-01-2025 09:30:00 pm username=>u531 -- token=>lwrvcu -- announcement_id=>3708 -- plan_id=>894 -- contact_numbers=>9551362239 --