20250530 132753 : requested url:/fightclub/callbackfv.php
250530132753000000 : json:{"code":null,"desc":null,"stage":"DONE","transactionType":"UNSUBSCRIBE","refId":"a8f970d0-d2b5-4b7d-9b1f-ddec8eb4a464_1748591872935","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-30T10:57:52.935793074","endTime":null,"expiryTime":null,"numberOfRetries":0,"amount":0.0,"collectedAmount":0.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250530 132753
refId=20250530 132753a8f970d0-d2b5-4b7d-9b1f-ddec8eb4a464_1748591872935
subscriberId=20250530 132753166052494006
transactionType=20250530 132753UNSUBSCRIBE
productId=20250530 132753d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250530 1327530
collectedAmount  charging=20250530 1327530
msisdn=20250530 132753166052494006
request_id=20250530 132753
result=20250530 132753
dn_status=20250530 132753
20250530 132753 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250530 132753 : pubid:
20250530 132753 : subid:
20250530 132753 : campid:
20250530 132753 : subscriptionid:
20250530 132753 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250530 132753 : voiceid:215
20250530 132753: checkfentryno=select * from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1 
20250530 132753: voiceid=215 
20250530 132753:querydel=insert into pending_delete_affc(entrydate,msisdn,regdate,campid) values 
		(now(),'166052494006','2025-05-12 16:58:37','')
20250530 132753: 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

20250530 132753: 20250530 010553 Query2:delete from  tbl_subscription_trans_africom_affc where msisdn='166052494006'
20250530 132753: 20250530 010553 Query2:delete from  tbl_activation_gamingbox_enscke_gbzul where msisdn='166052494006'