20250512 165835 : requested url:/fightclub/callbackfv.php
250512165835000000 : json:{"code":"SUCCESS","desc":null,"stage":"DONE","transactionType":"SUBSCRIBE","refId":"0636b9ed-e234-4d9b-8c3f-190440f940ba","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-12T14:28:35.567715421","endTime":null,"expiryTime":null,"numberOfRetries":0,"amount":0.0,"collectedAmount":0.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250512 165835SUCCESS
refId=20250512 1658350636b9ed-e234-4d9b-8c3f-190440f940ba
subscriberId=20250512 165835166052494006
transactionType=20250512 165835SUBSCRIBE
productId=20250512 165835d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250512 1658350
collectedAmount  charging=20250512 1658350
msisdn=20250512 165835166052494006
request_id=20250512 165835
result=20250512 165835
dn_status=20250512 165835
Called url=20250512 165835http://3.109.77.77/fightclub/send_payment_request_ff.php?msisdn=166052494006&productId=d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
Called url payment=20250512 165836

Called url=20250512 165836http://3.109.77.77/fightclub/send_sms_request_ff.php?msisdn=166052494006&productId=d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
Called url url1sms=20250512 165836ok

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

20250512 165837 : requested url:/fightclub/callbackfv.php
250512165837000000 : json:{"code":"FAILURE","desc":"Subscriber number invalid. 41 Subscriber Number is invalid","stage":"FAILED","transactionType":"CHARGE","refId":"be97eb2d-a26c-4bc1-9ec8-36ca5e5ac479_1747049316372","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-12 14:28:36","endTime":"2025-05-12T14:28:37.475926295","expiryTime":"2025-05-13 14:28:36","numberOfRetries":0,"amount":20.0,"collectedAmount":0.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250512 165837FAILURE
refId=20250512 165837be97eb2d-a26c-4bc1-9ec8-36ca5e5ac479_1747049316372
subscriberId=20250512 165837166052494006
transactionType=20250512 165837CHARGE
productId=20250512 165837d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250512 16583720
collectedAmount  charging=20250512 1658370
msisdn=20250512 165837166052494006
request_id=20250512 165837
result=20250512 165837
dn_status=20250512 165837
20250512 165837 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250512 165837 : pubid:
20250512 165837 : subid:
20250512 165837 : campid:
20250512 165837 : subscriptionid:
20250512 165837 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250512 165837 : voiceid:215
20250512 165839 : requested url:/fightclub/callbackfv.php
250512165839000000 : json:{"code":"SUCCESS","desc":"DeliveredToTerminal","stage":"DONE","transactionType":"SENDSMS_MT","refId":"0fbb680e-e707-4120-beea-d6321ff456b3_1747049316853","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-12 14:28:37","endTime":"2025-05-12T14:28:39.601995986","expiryTime":"2025-05-13 14:28:37","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=166052494006","linkId":"","srcAddress":"27405","details":""}
code=20250512 165839SUCCESS
refId=20250512 1658390fbb680e-e707-4120-beea-d6321ff456b3_1747049316853
subscriberId=20250512 165839166052494006
transactionType=20250512 165839SENDSMS_MT
productId=20250512 165839d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250512 1658390
collectedAmount  charging=20250512 1658390
msisdn=20250512 165839166052494006
request_id=20250512 165839
result=20250512 165839
dn_status=20250512 165839
20250512 165839 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250512 165839 : pubid:
20250512 165839 : subid:
20250512 165839 : campid:
20250512 165839 : subscriptionid:
20250512 165839 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250512 165839 : voiceid:215