20250526 130341 : requested url:/fightclub/callbackfv.php
250526130341000000 : json:{"code":"SUCCESS","desc":null,"stage":"DONE","transactionType":"SUBSCRIBE","refId":"8bb8d95a-9adf-48ba-93f2-4e307b23ffbe","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-26T10:33:41.492184896","endTime":null,"expiryTime":null,"numberOfRetries":0,"amount":0.0,"collectedAmount":0.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250526 130341SUCCESS
refId=20250526 1303418bb8d95a-9adf-48ba-93f2-4e307b23ffbe
subscriberId=20250526 130341166052494006
transactionType=20250526 130341SUBSCRIBE
productId=20250526 130341d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250526 1303410
collectedAmount  charging=20250526 1303410
msisdn=20250526 130341166052494006
request_id=20250526 130341
result=20250526 130341
dn_status=20250526 130341
Called url=20250526 130341http://3.109.77.77/fightclub/send_payment_request_ff.php?msisdn=166052494006&productId=d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
Called url payment=20250526 130342

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

20250526 130342 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250526 130342 : pubid:
20250526 130342 : subid:
20250526 130342 : campid:
20250526 130342 : subscriptionid:
20250526 130342 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250526 130342 : voiceid:215
20250526 130342: pubidget=select regdate as regdate from tbl_activation_gamingbox_enscke_gbzul where msisdn=166052494006 order by id desc limit 1 
20250526 130346 : requested url:/fightclub/callbackfv.php
250526130346000000 : json:{"code":"SUCCESS","desc":"DeliveredToTerminal","stage":"DONE","transactionType":"SENDSMS_MT","refId":"72f60d51-f743-4b2b-a442-bba7512786ca_1748244822682","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-26 10:33:43","endTime":"2025-05-26T10:33:46.313307652","expiryTime":"2025-05-27 10:33:43","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=20250526 130346SUCCESS
refId=20250526 13034672f60d51-f743-4b2b-a442-bba7512786ca_1748244822682
subscriberId=20250526 130346166052494006
transactionType=20250526 130346SENDSMS_MT
productId=20250526 130346d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250526 1303460
collectedAmount  charging=20250526 1303460
msisdn=20250526 130346166052494006
request_id=20250526 130346
result=20250526 130346
dn_status=20250526 130346
20250526 130346 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250526 130346 : pubid:
20250526 130346 : subid:
20250526 130346 : campid:
20250526 130346 : subscriptionid:
20250526 130346 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250526 130346 : voiceid:215
20250526 154122 : requested url:/fightclub/callbackfv.php
250526154122000000 : json:{"code":null,"desc":null,"stage":"DONE","transactionType":"UNSUBSCRIBE","refId":"6beecffa-c077-478e-bb3b-34852d0cbbec_1748254281878","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-26T13:11:21.878375108","endTime":null,"expiryTime":null,"numberOfRetries":0,"amount":0.0,"collectedAmount":0.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250526 154122
refId=20250526 1541226beecffa-c077-478e-bb3b-34852d0cbbec_1748254281878
subscriberId=20250526 154122166052494006
transactionType=20250526 154122UNSUBSCRIBE
productId=20250526 154122d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250526 1541220
collectedAmount  charging=20250526 1541220
msisdn=20250526 154122166052494006
request_id=20250526 154122
result=20250526 154122
dn_status=20250526 154122
20250526 154122 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250526 154122 : pubid:
20250526 154122 : subid:
20250526 154122 : campid:
20250526 154122 : subscriptionid:
20250526 154122 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250526 154122 : voiceid:215
20250526 154122: checkfentryno=select * from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1 
20250526 154122: voiceid=215 
20250526 154122:querydel=insert into pending_delete_affc(entrydate,msisdn,regdate,campid) values 
		(now(),'166052494006','2025-05-12 16:58:37','')
20250526 154122: 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

20250526 154122: 20250526 030522 Query2:delete from  tbl_subscription_trans_africom_affc where msisdn='166052494006'
20250526 154122: 20250526 030522 Query2:delete from  tbl_activation_gamingbox_enscke_gbzul where msisdn='166052494006'