20250623 170038 : requested url:/fightclub/callbackfv.php
250623170038000000 : json:{"code":"SUCCESS","desc":null,"stage":"DONE","transactionType":"SUBSCRIBE","refId":"0920ba1b-8e3d-4bbe-b3f2-ed12fac40f40","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"917977490073","startTime":"2025-06-23T14:30:37.750769669","endTime":null,"expiryTime":null,"numberOfRetries":0,"amount":0.0,"collectedAmount":0.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250623 170038SUCCESS
refId=20250623 1700380920ba1b-8e3d-4bbe-b3f2-ed12fac40f40
subscriberId=20250623 170038917977490073
transactionType=20250623 170038SUBSCRIBE
productId=20250623 170038d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250623 1700380
collectedAmount  charging=20250623 1700380
msisdn=20250623 170038917977490073
request_id=20250623 170038
result=20250623 170038
dn_status=20250623 170038
Called url=20250623 170038http://3.109.77.77/fightclub/send_payment_request_ff.php?msisdn=917977490073&productId=d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
Called url payment=20250623 170038

Called url=20250623 170038http://3.109.77.77/fightclub/send_sms_request_ff.php?msisdn=917977490073&productId=d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
Called url url1sms=20250623 170039ok

20250623 170039 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='917977490073' and date(entrydate)=date(now()) order by id desc limit 1
20250623 170039 : pubid:1
20250623 170039 : subid:DjkT6RJzGNaaCWvtetNzkj
20250623 170039 : campid:1
20250623 170039 : Querypub:select  id from tbl_activation_affc where msisdn='917977490073' order by id desc limit 1
20250623 170039 : voiceid:0
20250623 170039:query=INSERT INTO tbl_activation_affc(msisdn,regdate,validitydate,lastupdatedate,statuss,campid,pubid,price,OfferCode) VALUES ('917977490073',now(),DATE_SUB(now(), INTERVAL -1 DAY),now(),'ACT-REQ','1','1',0.0,'d994b83a-66b7-4555-bf2c-ef4ba6e57e9f') 
20250623 170039: querytrans=INSERT INTO tbl_subscription_trans_africom_affc(msisdn,regdate,validitydate,lastupdatedate,statuss,campid,pubid,price,OfferCode) VALUES ('917977490073',now(),DATE_SUB(now(), INTERVAL -1 DAY),now(),'ACT-REQ','1','1',0.0,'d994b83a-66b7-4555-bf2c-ef4ba6e57e9f') 
Called url=20250623 170039http://3.109.77.77/fightclub/send_sms_request_ff.php?msisdn=917977490073
Called url unsub=20250623 170039Failed to parse JSON response or missing data.

called url:20250623 170039: url:http://3.109.77.77:8080/postback/callback?clickid=DjkT6RJzGNaaCWvtetNzkj&campid=1
20250623 170043 : requested url:/fightclub/callbackfv.php
250623170043000000 : json:{"code":"SUCCESS","desc":"DeliveredToTerminal","stage":"DONE","transactionType":"SENDSMS_MT","refId":"5208194b-5647-4ce2-9096-976550449b29_1750678238896","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"917977490073","startTime":"2025-06-23 14:30:39","endTime":"2025-06-23T14:30:43.098014279","expiryTime":"2025-06-24 14:30:39","numberOfRetries":0,"amount":0.0,"collectedAmount":0.0,"message":"Dear Customer, You have successfully subscribed to fightclub service , You can access content through link: http://3.109.77.77/fightclub/index.html?msisdn=917977490073","linkId":"","srcAddress":"27405","details":""}
code=20250623 170043SUCCESS
refId=20250623 1700435208194b-5647-4ce2-9096-976550449b29_1750678238896
subscriberId=20250623 170043917977490073
transactionType=20250623 170043SENDSMS_MT
productId=20250623 170043d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250623 1700430
collectedAmount  charging=20250623 1700430
msisdn=20250623 170043917977490073
request_id=20250623 170043
result=20250623 170043
dn_status=20250623 170043
20250623 170043 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='917977490073' and date(entrydate)=date(now()) order by id desc limit 1
20250623 170043 : pubid:1
20250623 170043 : subid:DjkT6RJzGNaaCWvtetNzkj
20250623 170043 : campid:1
20250623 170043 : Querypub:select  id from tbl_activation_affc where msisdn='917977490073' order by id desc limit 1
20250623 170043 : voiceid:217