20250516 154943 : requested url:/fightclub/callbackfv.php
250516154943000000 : json:{"code":"SUCCESS","desc":"PaymentSuccess","stage":"DONE","transactionType":"CHARGE","refId":"77e56a8a-7932-485d-9885-aa848bd6ed4a_1747390782063","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-16 13:19:42","endTime":"2025-05-16T13:19:43.367297767","expiryTime":"2025-05-17 13:19:42","numberOfRetries":0,"amount":20.0,"collectedAmount":20.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250516 154943SUCCESS
refId=20250516 15494377e56a8a-7932-485d-9885-aa848bd6ed4a_1747390782063
subscriberId=20250516 154943166052494006
transactionType=20250516 154943CHARGE
productId=20250516 154943d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250516 15494320
collectedAmount  charging=20250516 15494320
msisdn=20250516 154943166052494006
request_id=20250516 154943
result=20250516 154943
dn_status=20250516 154943
20250516 154943 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250516 154943 : pubid:
20250516 154943 : subid:
20250516 154943 : campid:
20250516 154943 : subscriptionid:
20250516 154943 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250516 154943 : voiceid:215
20250516 154943 : Querypub:select  id from tbl_subscription_gamingbox_enscke_gbzul where msisdn='166052494006' order by id desc limit 1
20250516 174416 : requested url:/fightclub/callbackfv.php
250516174416000000 : json:{"code":null,"desc":null,"stage":"DONE","transactionType":"UNSUBSCRIBE","refId":"798c35b3-b648-4533-93c0-f0ccb03f88a2_1747397656144","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-16T15:14:16.144384057","endTime":null,"expiryTime":null,"numberOfRetries":0,"amount":0.0,"collectedAmount":0.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250516 174416
refId=20250516 174416798c35b3-b648-4533-93c0-f0ccb03f88a2_1747397656144
subscriberId=20250516 174416166052494006
transactionType=20250516 174416UNSUBSCRIBE
productId=20250516 174416d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250516 1744160
collectedAmount  charging=20250516 1744160
msisdn=20250516 174416166052494006
request_id=20250516 174416
result=20250516 174416
dn_status=20250516 174416
20250516 174416 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250516 174416 : pubid:
20250516 174416 : subid:
20250516 174416 : campid:
20250516 174416 : subscriptionid:
20250516 174416 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250516 174416 : voiceid:215
20250516 174416: checkfentryno=select * from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1 
20250516 174416: voiceid=215 
20250516 174416:querydel=insert into pending_delete_affc(entrydate,msisdn,regdate,campid) values 
		(now(),'166052494006','2025-05-12 16:58:37','')
20250516 174416: INSERT INTO tbl_subscription_trans_africom_affc (msisdn,regdate,validitydate,lastupdatedate,statuss,campid) 
	  select '166052494006',regdate,validitydate,now(),'deactivated',campid from tbl_subscription_trans_africom_affc where msisdn='166052494006' order by id desc limit 1

20250516 174416: 20250516 050516 Query2:delete from  tbl_subscription_trans_africom_affc where msisdn='166052494006'
20250516 174416: 20250516 050516 Query2:delete from  tbl_activation_gamingbox_enscke_gbzul where msisdn='166052494006'