20250514 114130 : requested url:/fightclub/callbackfv.php
250514114130000000 : json:{"code":null,"desc":null,"stage":"DONE","transactionType":"UNSUBSCRIBE","refId":"d1af1381-c077-435c-a86d-bd9726e07b11_1747203090334","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-14T09:11:30.334602512","endTime":null,"expiryTime":null,"numberOfRetries":0,"amount":0.0,"collectedAmount":0.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250514 114130
refId=20250514 114130d1af1381-c077-435c-a86d-bd9726e07b11_1747203090334
subscriberId=20250514 114130166052494006
transactionType=20250514 114130UNSUBSCRIBE
productId=20250514 114130d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250514 1141300
collectedAmount  charging=20250514 1141300
msisdn=20250514 114130166052494006
request_id=20250514 114130
result=20250514 114130
dn_status=20250514 114130
20250514 114130 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250514 114130 : pubid:
20250514 114130 : subid:
20250514 114130 : campid:
20250514 114130 : subscriptionid:
20250514 114130 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250514 114130 : voiceid:215
20250514 114130: checkfentryno=select * from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1 
20250514 114130: voiceid=215 
20250514 114130:querydel=insert into pending_delete_affc(entrydate,msisdn,regdate,campid) values 
		(now(),'166052494006','2025-05-12 16:58:37','')
20250514 114130: 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

20250514 114130: 20250514 110530 Query2:delete from  tbl_subscription_trans_africom_affc where msisdn='166052494006'
20250514 114130: 20250514 110530 Query2:delete from  tbl_activation_gamingbox_enscke_gbzul where msisdn='166052494006'