20250513 120318 : requested url:/fightclub/callbackfv.php
250513120318000000 : json:{"code":null,"desc":null,"stage":"DONE","transactionType":"UNSUBSCRIBE","refId":"919421c4-07cc-41f5-8f16-dab72aa69602_1747117997687","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-13T09:33:17.687410934","endTime":null,"expiryTime":null,"numberOfRetries":0,"amount":0.0,"collectedAmount":0.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250513 120318
refId=20250513 120318919421c4-07cc-41f5-8f16-dab72aa69602_1747117997687
subscriberId=20250513 120318166052494006
transactionType=20250513 120318UNSUBSCRIBE
productId=20250513 120318d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250513 1203180
collectedAmount  charging=20250513 1203180
msisdn=20250513 120318166052494006
request_id=20250513 120318
result=20250513 120318
dn_status=20250513 120318
20250513 120318 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250513 120318 : pubid:
20250513 120318 : subid:
20250513 120318 : campid:
20250513 120318 : subscriptionid:
20250513 120318 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250513 120318 : voiceid:215
20250513 120318: checkfentryno=select * from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1 
20250513 120318: voiceid=215 
20250513 120318:querydel=insert into pending_delete_affc(entrydate,msisdn,regdate,campid) values 
		(now(),'166052494006','2025-05-12 16:58:37','')
20250513 120318: 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

20250513 120318: 20250513 120518 Query2:delete from  tbl_subscription_trans_africom_affc where msisdn='166052494006'
20250513 120318: 20250513 120518 Query2:delete from  tbl_activation_gamingbox_enscke_gbzul where msisdn='166052494006'
20250513 120457 : requested url:/fightclub/callbackfv.php
250513120457000000 : json:{"code":"SUCCESS","desc":null,"stage":"DONE","transactionType":"SUBSCRIBE","refId":"b73ed251-0871-4cae-82c5-255704181396","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-13T09:34:56.859558639","endTime":null,"expiryTime":null,"numberOfRetries":0,"amount":0.0,"collectedAmount":0.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250513 120457SUCCESS
refId=20250513 120457b73ed251-0871-4cae-82c5-255704181396
subscriberId=20250513 120457166052494006
transactionType=20250513 120457SUBSCRIBE
productId=20250513 120457d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250513 1204570
collectedAmount  charging=20250513 1204570
msisdn=20250513 120457166052494006
request_id=20250513 120457
result=20250513 120457
dn_status=20250513 120457
Called url=20250513 120457http://3.109.77.77/fightclub/send_payment_request_ff.php?msisdn=166052494006&productId=d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
Called url payment=20250513 120457

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

20250513 120458 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250513 120458 : pubid:
20250513 120458 : subid:
20250513 120458 : campid:
20250513 120458 : subscriptionid:
20250513 120458 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250513 120458 : voiceid:215
20250513 120458: pubidget=select regdate as regdate from tbl_activation_gamingbox_enscke_gbzul where msisdn=166052494006 order by id desc limit 1 
20250513 120459 : requested url:/fightclub/callbackfv.php
250513120459000000 : json:{"code":"SUCCESS","desc":"PaymentSuccess","stage":"DONE","transactionType":"CHARGE","refId":"898d43ca-ee2e-4e15-a70b-9f57c4166000_1747118097647","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-13 09:34:58","endTime":"2025-05-13T09:34:59.191495861","expiryTime":"2025-05-14 09:34:58","numberOfRetries":0,"amount":20.0,"collectedAmount":20.0,"message":"","linkId":"","srcAddress":"27405","details":""}
code=20250513 120459SUCCESS
refId=20250513 120459898d43ca-ee2e-4e15-a70b-9f57c4166000_1747118097647
subscriberId=20250513 120459166052494006
transactionType=20250513 120459CHARGE
productId=20250513 120459d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250513 12045920
collectedAmount  charging=20250513 12045920
msisdn=20250513 120459166052494006
request_id=20250513 120459
result=20250513 120459
dn_status=20250513 120459
20250513 120459 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250513 120459 : pubid:
20250513 120459 : subid:
20250513 120459 : campid:
20250513 120459 : subscriptionid:
20250513 120459 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250513 120459 : voiceid:215
20250513 120459 : Querypub:select  id from tbl_subscription_gamingbox_enscke_gbzul where msisdn='166052494006' order by id desc limit 1
20250513 120558 : requested url:/fightclub/callbackfv.php
250513120558000000 : json:{"code":"SUCCESS","desc":"DeliveredToTerminal","stage":"DONE","transactionType":"SENDSMS_MT","refId":"d0fe8b5f-d174-41be-9408-395cd806a7cd_1747118098116","productId":"d994b83a-66b7-4555-bf2c-ef4ba6e57e9f","subscriberId":"166052494006","startTime":"2025-05-13 09:34:58","endTime":"2025-05-13T09:35:58.555720240","expiryTime":"2025-05-14 09:34:58","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=20250513 120558SUCCESS
refId=20250513 120558d0fe8b5f-d174-41be-9408-395cd806a7cd_1747118098116
subscriberId=20250513 120558166052494006
transactionType=20250513 120558SENDSMS_MT
productId=20250513 120558d994b83a-66b7-4555-bf2c-ef4ba6e57e9f
amount=20250513 1205580
collectedAmount  charging=20250513 1205580
msisdn=20250513 120558166052494006
request_id=20250513 120558
result=20250513 120558
dn_status=20250513 120558
20250513 120558 : Querypub:select  *  from tbl_wapidentify_africom_affc where msisdn='166052494006' and date(entrydate)=date(now()) order by id desc limit 1
20250513 120558 : pubid:
20250513 120558 : subid:
20250513 120558 : campid:
20250513 120558 : subscriptionid:
20250513 120558 : Querypub:select  id from tbl_activation_affc where msisdn='166052494006' order by id desc limit 1
20250513 120558 : voiceid:215