20260322 001051 : requested url:/gameverse/idtl/callback_itg.php
20260322 001051 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"laqsdPRlo7UH2lkjveui6pD6onUTea2WXaRjNuJOtCIeqCrAn6oKoP0=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20260322 001051 : mobile encrypted_msisdn:laqsdPRlo7UH2lkjveui6pD6onUTea2WXaRjNuJOtCIeqCrAn6oKoP0=
20260322 001051 : mobile keyword:UNREG FUNZONE2
20260322 001051 : mobile dr_status:1
20260322 001051 output={"msisdn":"6281210895198"}

20260322 001051 msisdn=6281210895198
20260322 001051 outsideloop msisdn=6281210895198
20260322 001051 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281210895198' order by  id desc limit 1
Querydel:20260322 001051: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-14 10:23:58',now(),'6281210895198','UNREG FUNZONE2')
Queryt:20260322 001051: delete from tbl_subscription_Telkomsel_id where msisdn='6281210895198'
20260322 012612 : requested url:/gameverse/idtl/callback_itg.php
20260322 012612 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"c9_3w9n2sueTtb674z5SGnR8AmBif0rW3YR6ykuuH8Wgw_KM6Tt64HQ=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""}
20260322 012612 : mobile encrypted_msisdn:c9_3w9n2sueTtb674z5SGnR8AmBif0rW3YR6ykuuH8Wgw_KM6Tt64HQ=
20260322 012612 : mobile keyword:REG FUNZONE1
20260322 012612 : mobile dr_status:1
20260322 012612 output={"msisdn":"6282192318463"}

20260322 012612 msisdn=6282192318463
20260322 012612 outsideloop msisdn=6282192318463
20260322 012612 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282192318463' order by  id desc limit 1
Query:20260322 012612: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282192318463'
Query:20260322 012612: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-04 22:43:51',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282192318463','','','REG FUNZONE1')
20260322 012621 : requested url:/gameverse/idtl/callback_itg.php
20260322 012621 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"SM1mTsh3Fr7iPyPDAkciGIrQx2DmKM3-SNf9uZnSTp0IeCuOX_MqXvE=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""}
20260322 012621 : mobile encrypted_msisdn:SM1mTsh3Fr7iPyPDAkciGIrQx2DmKM3-SNf9uZnSTp0IeCuOX_MqXvE=
20260322 012621 : mobile keyword:REG FUNZONE1
20260322 012621 : mobile dr_status:1
20260322 012621 output={"msisdn":"6285321548657"}

20260322 012621 msisdn=6285321548657
20260322 012621 outsideloop msisdn=6285321548657
20260322 012621 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285321548657' order by  id desc limit 1
Query:20260322 012621: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285321548657'
Query:20260322 012621: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-05 14:28:45',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6285321548657','','','REG FUNZONE1')