20250716 113938 : requested url:/gameverse/idtl/callback_itg.php
20250716 113938 : json:{"adnetid":"96014","clickid":"250716113914000000","dr_status":"1","encrypted_msisdn":"Xs-zmRpULZ5FKEDXvOs4PI1_e70XOyGjWt9c8mG3erdyTqYUvechD7s=","keyword":"REG FUNZONE1","req_type":"subs","trx_id":"WEB1752646161899168675"}
20250716 113938 : mobile encrypted_msisdn:Xs-zmRpULZ5FKEDXvOs4PI1_e70XOyGjWt9c8mG3erdyTqYUvechD7s=
20250716 113938 : mobile keyword:REG FUNZONE1
20250716 113938 : mobile dr_status:1
20250716 113938 output={"msisdn":"6281213085680"}

20250716 113938 msisdn=6281213085680
20250716 113938 outsideloop msisdn=6281213085680
20250716 113938 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='250716113914000000' order by id desc limit 1
20250716 113938 subid=
20250716 113938 pubid=
Query:20250716 113938: insert into tbl_subscription_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values (now(),DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','FSC-BL','1','subs','6281213085680','250716113914000000','WEB1752646161899168675','REG FUNZONE1')
Query:20250716 113938: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values (now(),DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','FSC-BL','1','subs','6281213085680','250716113914000000','WEB1752646161899168675','REG FUNZONE1')
20250716 125408 : requested url:/gameverse/idtl/callback_itg.php
20250716 125408 : json:
20250716 125408 : mobile encrypted_msisdn:
20250716 125408 : mobile keyword:
20250716 125408 : mobile dr_status:
20250716 125408 output=Error: Invalid data (too short)
20250716 125408 msisdn=
20250716 125408 outsideloop msisdn=
20250716 130008 : requested url:/gameverse/idtl/callback_itg.php
20250716 130008 : json:
20250716 130008 : mobile encrypted_msisdn:
20250716 130008 : mobile keyword:
20250716 130008 : mobile dr_status:
20250716 130008 output=Error: Invalid data (too short)
20250716 130008 msisdn=
20250716 130008 outsideloop msisdn=
20250716 161846 : requested url:/gameverse/idtl/callback_itg.php
20250716 161846 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"bMI658qklv6gB5gmfNyhqNI8osIJ6cCAWlIZZ7R1l88EEptAA4VVAoI=","keyword":"UNREG FUNZONE1","req_type":"unsubs","trx_id":""}
20250716 161846 : mobile encrypted_msisdn:bMI658qklv6gB5gmfNyhqNI8osIJ6cCAWlIZZ7R1l88EEptAA4VVAoI=
20250716 161846 : mobile keyword:UNREG FUNZONE1
20250716 161846 : mobile dr_status:1
20250716 161846 output={"msisdn":"6281213085680"}

20250716 161846 msisdn=6281213085680
20250716 161846 outsideloop msisdn=6281213085680
20250716 161846 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281213085680' order by  id desc limit 1
Querydel:20250716 161846: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-07-16 11:39:38',now(),'6281213085680','UNREG FUNZONE1')
Queryt:20250716 161846: delete from tbl_subscription_Telkomsel_id where msisdn='6281213085680'
20250716 185412 : requested url:/gameverse/idtl/callback_itg.php
20250716 185412 : json:{"adnetid":"96014","clickid":"250716185348000000","dr_status":"0","encrypted_msisdn":"o_txv3Gu8xc1JwPwe15K4IpFx_4mTn-zFCwYucAq5gToAN9wibK6t0k=","keyword":"REG FUNZONE1","req_type":"subs","trx_id":"WEB17526722341401275600"}
20250716 185412 : mobile encrypted_msisdn:o_txv3Gu8xc1JwPwe15K4IpFx_4mTn-zFCwYucAq5gToAN9wibK6t0k=
20250716 185412 : mobile keyword:REG FUNZONE1
20250716 185412 : mobile dr_status:0
20250716 185412 output={"msisdn":"6281213085680"}

20250716 185412 msisdn=6281213085680
20250716 185412 outsideloop msisdn=6281213085680
20250716 185412 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='250716185348000000' order by id desc limit 1
20250716 185412 subid=
20250716 185412 pubid=
Query:20250716 185412: insert into tbl_subscription_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values (now(),DATE_SUB(now(), INTERVAL -0 DAY),now(),0.00,'','','','LOW-BL','0','subs','6281213085680','250716185348000000','WEB17526722341401275600','REG FUNZONE1')
Query:20250716 185412: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values (now(),DATE_SUB(now(), INTERVAL -0 DAY),now(),0.00,'','','','LOW-BL','0','subs','6281213085680','250716185348000000','WEB17526722341401275600','REG FUNZONE1')
20250716 191042 : requested url:/gameverse/idtl/callback_itg.php
20250716 191042 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"OYlkN2j4ngBS_rFTNcvyPS0wCm1XbzX_7XLxkDO9nAb8fOAR9CLhOac=","keyword":"UNREG FUNZONE1","req_type":"unsubs","trx_id":""}
20250716 191042 : mobile encrypted_msisdn:OYlkN2j4ngBS_rFTNcvyPS0wCm1XbzX_7XLxkDO9nAb8fOAR9CLhOac=
20250716 191042 : mobile keyword:UNREG FUNZONE1
20250716 191042 : mobile dr_status:1
20250716 191042 output={"msisdn":"6281213085680"}

20250716 191042 msisdn=6281213085680
20250716 191042 outsideloop msisdn=6281213085680
20250716 191042 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281213085680' order by  id desc limit 1
Querydel:20250716 191042: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-07-16 18:54:12',now(),'6281213085680','UNREG FUNZONE1')
Queryt:20250716 191042: delete from tbl_subscription_Telkomsel_id where msisdn='6281213085680'