20251214 002348 : requested url:/gameverse/idtl/callback_itg.php
20251214 002348 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"0oJLlRbSC5ITLcYaSVw_rduGn_urWo2YVsn5MO-VDwZBEs3noQyeXWc=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 002348 : mobile encrypted_msisdn:0oJLlRbSC5ITLcYaSVw_rduGn_urWo2YVsn5MO-VDwZBEs3noQyeXWc=
20251214 002348 : mobile keyword:UNREG FUNZONE2
20251214 002348 : mobile dr_status:1
20251214 002348 output={"msisdn":"6281240595483"}

20251214 002348 msisdn=6281240595483
20251214 002348 outsideloop msisdn=6281240595483
20251214 002348 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281240595483' order by  id desc limit 1
Querydel:20251214 002348: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-12 14:58:33',now(),'6281240595483','UNREG FUNZONE2')
Queryt:20251214 002348: delete from tbl_subscription_Telkomsel_id where msisdn='6281240595483'
20251214 024938 : requested url:/gameverse/idtl/callback_itg.php
20251214 024938 : json:{"adnetid":"96014","clickid":"251214024918000000","dr_status":"0","encrypted_msisdn":"aD24gaYUVCRy1Bw1yVstSAp3j63GVymS996OAbD6vVTN5ZQhEIXexpY=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17656607591919542790"}
20251214 024938 : mobile encrypted_msisdn:aD24gaYUVCRy1Bw1yVstSAp3j63GVymS996OAbD6vVTN5ZQhEIXexpY=
20251214 024938 : mobile keyword:REG FUNZONE2
20251214 024938 : mobile dr_status:0
20251214 024938 output={"msisdn":"6281243097020"}

20251214 024938 msisdn=6281243097020
20251214 024938 outsideloop msisdn=6281243097020
20251214 024938 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214024918000000' order by id desc limit 1
20251214 024938 subid=693dd855eaa5e3034582567b
20251214 024938 pubid=2
Query:20251214 024938: 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,'2','693dd855eaa5e3034582567b','5','LOW-BL','0','subs','6281243097020','251214024918000000','WEB17656607591919542790','REG FUNZONE2')
Query:20251214 024938: 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,'2','693dd855eaa5e3034582567b','5','LOW-BL','0','subs','6281243097020','251214024918000000','WEB17656607591919542790','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693dd855eaa5e3034582567b&campid=5:251214024940000000: 20251214 021240 output:200
20251214 032711 : requested url:/gameverse/idtl/callback_itg.php
20251214 032711 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"J2b2YO4D21f1wpT1mnGL-IlHee0zIlMns7CwChcw6JWxCDjG_HBvmfk=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 032711 : mobile encrypted_msisdn:J2b2YO4D21f1wpT1mnGL-IlHee0zIlMns7CwChcw6JWxCDjG_HBvmfk=
20251214 032711 : mobile keyword:UNREG FUNZONE2
20251214 032711 : mobile dr_status:1
20251214 032711 output={"msisdn":"6281233706639"}

20251214 032711 msisdn=6281233706639
20251214 032711 outsideloop msisdn=6281233706639
20251214 032711 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281233706639' order by  id desc limit 1
Querydel:20251214 032711: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-26 00:37:03',now(),'6281233706639','UNREG FUNZONE2')
Queryt:20251214 032711: delete from tbl_subscription_Telkomsel_id where msisdn='6281233706639'
20251214 035159 : requested url:/gameverse/idtl/callback_itg.php
20251214 035159 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"TluRdTFr1w7QPFaLbPC-XQTL22G5_MfxpoIoEy9dZg6V_LNQZ53NfpU=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 035159 : mobile encrypted_msisdn:TluRdTFr1w7QPFaLbPC-XQTL22G5_MfxpoIoEy9dZg6V_LNQZ53NfpU=
20251214 035159 : mobile keyword:UNREG FUNZONE2
20251214 035159 : mobile dr_status:1
20251214 035159 output={"msisdn":"6281243097020"}

20251214 035159 msisdn=6281243097020
20251214 035159 outsideloop msisdn=6281243097020
20251214 035159 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281243097020' order by  id desc limit 1
Querydel:20251214 035159: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-14 02:49:38',now(),'6281243097020','UNREG FUNZONE2')
Queryt:20251214 035159: delete from tbl_subscription_Telkomsel_id where msisdn='6281243097020'
20251214 040707 : requested url:/gameverse/idtl/callback_itg.php
20251214 040707 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"vv5-S8RFTp0Sa15VnjUy1x33xFWo1z32kS8jz3221XDBy8LxIXjpHrs=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 040707 : mobile encrypted_msisdn:vv5-S8RFTp0Sa15VnjUy1x33xFWo1z32kS8jz3221XDBy8LxIXjpHrs=
20251214 040707 : mobile keyword:UNREG FUNZONE2
20251214 040707 : mobile dr_status:1
20251214 040707 output={"msisdn":"6281213988993"}

20251214 040707 msisdn=6281213988993
20251214 040707 outsideloop msisdn=6281213988993
20251214 040707 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281213988993' order by  id desc limit 1
Querydel:20251214 040707: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-07 10:31:24',now(),'6281213988993','UNREG FUNZONE2')
Queryt:20251214 040707: delete from tbl_subscription_Telkomsel_id where msisdn='6281213988993'
20251214 040858 : requested url:/gameverse/idtl/callback_itg.php
20251214 040858 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"xJFSnxlbp89jQq4z08-Bc3HvSC2BfiTTCsxjkN_wyCU8fyLCTZbZeNY=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 040858 : mobile encrypted_msisdn:xJFSnxlbp89jQq4z08-Bc3HvSC2BfiTTCsxjkN_wyCU8fyLCTZbZeNY=
20251214 040858 : mobile keyword:REG FUNZONE2
20251214 040858 : mobile dr_status:1
20251214 040858 output={"msisdn":"6281328577224"}

20251214 040858 msisdn=6281328577224
20251214 040858 outsideloop msisdn=6281328577224
20251214 040858 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281328577224' order by  id desc limit 1
Query:20251214 040858: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281328577224'
Query:20251214 040859: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-24 18:28:51',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281328577224','','','REG FUNZONE2')
20251214 042854 : requested url:/gameverse/idtl/callback_itg.php
20251214 042854 : json:{"adnetid":"96014","clickid":"251214042805000000","dr_status":"0","encrypted_msisdn":"PmZjRxQ22PHTnO6Nl1gs_1jsrDa8yV5Z5BXKk5iUtMB8X1qC9mRFg_8=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17656667041291139943"}
20251214 042854 : mobile encrypted_msisdn:PmZjRxQ22PHTnO6Nl1gs_1jsrDa8yV5Z5BXKk5iUtMB8X1qC9mRFg_8=
20251214 042854 : mobile keyword:REG FUNZONE2
20251214 042854 : mobile dr_status:0
20251214 042854 output={"msisdn":"6282364539616"}

20251214 042854 msisdn=6282364539616
20251214 042854 outsideloop msisdn=6282364539616
20251214 042854 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214042805000000' order by id desc limit 1
20251214 042854 subid=693def781ecdab03417e7b1a
20251214 042854 pubid=2
Query:20251214 042854: 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,'2','693def781ecdab03417e7b1a','5','LOW-BL','0','subs','6282364539616','251214042805000000','WEB17656667041291139943','REG FUNZONE2')
Query:20251214 042854: 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,'2','693def781ecdab03417e7b1a','5','LOW-BL','0','subs','6282364539616','251214042805000000','WEB17656667041291139943','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693def781ecdab03417e7b1a&campid=5:251214042857000000: 20251214 041257 output:200
20251214 043740 : requested url:/gameverse/idtl/callback_itg.php
20251214 043740 : json:{"adnetid":"96014","clickid":"251214043737000000","dr_status":"0","encrypted_msisdn":"HrWWknHlDj7zfL0eEMGowd3LzKWUFi-o0L6mwanQw6cIAguxZ-RGjw==","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17656672571186820048"}
20251214 043740 : mobile encrypted_msisdn:HrWWknHlDj7zfL0eEMGowd3LzKWUFi-o0L6mwanQw6cIAguxZ-RGjw==
20251214 043740 : mobile keyword:REG FUNZONE2
20251214 043740 : mobile dr_status:0
20251214 043740 output={"msisdn":"628133024633"}

20251214 043740 msisdn=628133024633
20251214 043740 outsideloop msisdn=628133024633
20251214 043740 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214043737000000' order by id desc limit 1
20251214 043740 subid=693df1b83defea0349b429b8
20251214 043740 pubid=2
Query:20251214 043740: 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,'2','693df1b83defea0349b429b8','5','LOW-BL','0','subs','628133024633','251214043737000000','WEB17656672571186820048','REG FUNZONE2')
Query:20251214 043740: 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,'2','693df1b83defea0349b429b8','5','LOW-BL','0','subs','628133024633','251214043737000000','WEB17656672571186820048','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693df1b83defea0349b429b8&campid=5:251214043742000000: 20251214 041242 output:200
20251214 045809 : requested url:/gameverse/idtl/callback_itg.php
20251214 045809 : json:
20251214 045809 : mobile encrypted_msisdn:
20251214 045809 : mobile keyword:
20251214 045809 : mobile dr_status:
20251214 045809 output=Error: Invalid data (too short)
20251214 045809 msisdn=
20251214 045809 outsideloop msisdn=
20251214 045938 : requested url:/gameverse/idtl/callback_itg.php
20251214 045938 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"HMkLDXzqd0GkbSp3roTD0bvD7gGc2oSvGVstFgK7fUqBUsO-ktiIKwQ=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 045938 : mobile encrypted_msisdn:HMkLDXzqd0GkbSp3roTD0bvD7gGc2oSvGVstFgK7fUqBUsO-ktiIKwQ=
20251214 045938 : mobile keyword:UNREG FUNZONE2
20251214 045938 : mobile dr_status:1
20251214 045938 output={"msisdn":"6282228163164"}

20251214 045938 msisdn=6282228163164
20251214 045938 outsideloop msisdn=6282228163164
20251214 045938 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282228163164' order by  id desc limit 1
Querydel:20251214 045938: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-11 18:24:42',now(),'6282228163164','UNREG FUNZONE2')
Queryt:20251214 045938: delete from tbl_subscription_Telkomsel_id where msisdn='6282228163164'
20251214 055731 : requested url:/gameverse/idtl/callback_itg.php
20251214 055731 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Lzk7a6GXPgjuNvxgp9jkcpIW3JCQMBxcfmt7VTRQ_zelBFK7D4U3A44=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 055731 : mobile encrypted_msisdn:Lzk7a6GXPgjuNvxgp9jkcpIW3JCQMBxcfmt7VTRQ_zelBFK7D4U3A44=
20251214 055731 : mobile keyword:UNREG FUNZONE2
20251214 055731 : mobile dr_status:1
20251214 055731 output={"msisdn":"6281241015940"}

20251214 055731 msisdn=6281241015940
20251214 055731 outsideloop msisdn=6281241015940
20251214 055731 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281241015940' order by  id desc limit 1
Querydel:20251214 055731: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-08-24 08:09:01',now(),'6281241015940','UNREG FUNZONE2')
Queryt:20251214 055731: delete from tbl_subscription_Telkomsel_id where msisdn='6281241015940'
20251214 061230 : requested url:/gameverse/idtl/callback_itg.php
20251214 061230 : json:{"adnetid":"96014","clickid":"251214061212000000","dr_status":"0","encrypted_msisdn":"ZHYfYlRK2Tmp7ASzSB5Cr2xw9cjlzM2bybXh06q_dlUlESiDFJZjZeA=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1765672936686005529"}
20251214 061230 : mobile encrypted_msisdn:ZHYfYlRK2Tmp7ASzSB5Cr2xw9cjlzM2bybXh06q_dlUlESiDFJZjZeA=
20251214 061230 : mobile keyword:REG FUNZONE2
20251214 061230 : mobile dr_status:0
20251214 061230 output={"msisdn":"6281219673968"}

20251214 061230 msisdn=6281219673968
20251214 061230 outsideloop msisdn=6281219673968
20251214 061230 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214061212000000' order by id desc limit 1
20251214 061230 subid=693e07e2c2dff40342dd81e9
20251214 061230 pubid=2
Query:20251214 061230: 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,'2','693e07e2c2dff40342dd81e9','5','LOW-BL','0','subs','6281219673968','251214061212000000','WEB1765672936686005529','REG FUNZONE2')
Query:20251214 061230: 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,'2','693e07e2c2dff40342dd81e9','5','LOW-BL','0','subs','6281219673968','251214061212000000','WEB1765672936686005529','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693e07e2c2dff40342dd81e9&campid=5:251214061233000000: 20251214 061233 output:200
20251214 061556 : requested url:/gameverse/idtl/callback_itg.php
20251214 061556 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"VasT5bzdj8gjnxLJxlP0u1VuAzm6-QRYzpGTo2_Syd-BB_GItExFOqE=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 061556 : mobile encrypted_msisdn:VasT5bzdj8gjnxLJxlP0u1VuAzm6-QRYzpGTo2_Syd-BB_GItExFOqE=
20251214 061556 : mobile keyword:UNREG FUNZONE2
20251214 061556 : mobile dr_status:1
20251214 061556 output={"msisdn":"6281249885351"}

20251214 061556 msisdn=6281249885351
20251214 061556 outsideloop msisdn=6281249885351
20251214 061556 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281249885351' order by  id desc limit 1
Querydel:20251214 061556: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6281249885351','UNREG FUNZONE2')
Queryt:20251214 061556: delete from tbl_subscription_Telkomsel_id where msisdn='6281249885351'
20251214 061918 : requested url:/gameverse/idtl/callback_itg.php
20251214 061918 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"xUcTDlfTPRLI5i29ZzYlH4TrVJMASghKaX_l3g49j8J-yp66PlRhJqs=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 061918 : mobile encrypted_msisdn:xUcTDlfTPRLI5i29ZzYlH4TrVJMASghKaX_l3g49j8J-yp66PlRhJqs=
20251214 061918 : mobile keyword:UNREG FUNZONE2
20251214 061918 : mobile dr_status:1
20251214 061918 output={"msisdn":"6282337449227"}

20251214 061918 msisdn=6282337449227
20251214 061918 outsideloop msisdn=6282337449227
20251214 061918 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282337449227' order by  id desc limit 1
Querydel:20251214 061918: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6282337449227','UNREG FUNZONE2')
Queryt:20251214 061918: delete from tbl_subscription_Telkomsel_id where msisdn='6282337449227'
20251214 062219 : requested url:/gameverse/idtl/callback_itg.php
20251214 062219 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Fg6hCYX28W_EkhaTmtIcCgRb898r8yNnBF6legb5y3mCTjD6s6I1xQM=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 062219 : mobile encrypted_msisdn:Fg6hCYX28W_EkhaTmtIcCgRb898r8yNnBF6legb5y3mCTjD6s6I1xQM=
20251214 062219 : mobile keyword:UNREG FUNZONE2
20251214 062219 : mobile dr_status:1
20251214 062219 output={"msisdn":"6281219673968"}

20251214 062219 msisdn=6281219673968
20251214 062219 outsideloop msisdn=6281219673968
20251214 062219 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281219673968' order by  id desc limit 1
Querydel:20251214 062219: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-14 06:12:30',now(),'6281219673968','UNREG FUNZONE2')
Queryt:20251214 062219: delete from tbl_subscription_Telkomsel_id where msisdn='6281219673968'
20251214 063231 : requested url:/gameverse/idtl/callback_itg.php
20251214 063231 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"CWT-FicfCwb2tfmjfpj33ACujG3jWJl2A7Pfujm_91rDSubXQyy84LI=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""}
20251214 063231 : mobile encrypted_msisdn:CWT-FicfCwb2tfmjfpj33ACujG3jWJl2A7Pfujm_91rDSubXQyy84LI=
20251214 063231 : mobile keyword:REG FUNZONE1
20251214 063231 : mobile dr_status:1
20251214 063231 output={"msisdn":"6285225149737"}

20251214 063231 msisdn=6285225149737
20251214 063231 outsideloop msisdn=6285225149737
20251214 063231 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285225149737' order by  id desc limit 1
Query:20251214 063231: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285225149737'
Query:20251214 063231: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-01 00:59:50',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6285225149737','','','REG FUNZONE1')
20251214 063608 : requested url:/gameverse/idtl/callback_itg.php
20251214 063608 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"iYSQOcyVYYZt9JQlnuSLYwKmRkgzB-Lnb-tXzedv7eHm9w9iRvHRAQ==","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063608 : mobile encrypted_msisdn:iYSQOcyVYYZt9JQlnuSLYwKmRkgzB-Lnb-tXzedv7eHm9w9iRvHRAQ==
20251214 063608 : mobile keyword:REG FUNZONE2
20251214 063608 : mobile dr_status:1
20251214 063608 output={"msisdn":"628113949029"}

20251214 063608 msisdn=628113949029
20251214 063608 outsideloop msisdn=628113949029
20251214 063608 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='628113949029' order by  id desc limit 1
Query:20251214 063608: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='628113949029'
Query:20251214 063608: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-13 18:21:40',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','628113949029','','','REG FUNZONE2')
20251214 063621 : requested url:/gameverse/idtl/callback_itg.php
20251214 063621 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"R1SazYGosw_1Db8WfLMxzYT-6gwbndnsWKGXfRjWTO4SiY7_7Zr1yug=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063621 : mobile encrypted_msisdn:R1SazYGosw_1Db8WfLMxzYT-6gwbndnsWKGXfRjWTO4SiY7_7Zr1yug=
20251214 063621 : mobile keyword:REG FUNZONE2
20251214 063621 : mobile dr_status:1
20251214 063621 output={"msisdn":"6282321296851"}

20251214 063621 msisdn=6282321296851
20251214 063621 outsideloop msisdn=6282321296851
20251214 063621 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282321296851' order by  id desc limit 1
Query:20251214 063621: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282321296851'
Query:20251214 063621: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-16 17:04:50',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282321296851','','','REG FUNZONE2')
20251214 063651 : requested url:/gameverse/idtl/callback_itg.php
20251214 063651 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"fOevhKYzUtmgsdmi3Qv2wXhJQr2vZvdCLPFTgW5EhQQt-vhj3MRzS0w=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063651 : mobile encrypted_msisdn:fOevhKYzUtmgsdmi3Qv2wXhJQr2vZvdCLPFTgW5EhQQt-vhj3MRzS0w=
20251214 063651 : mobile keyword:REG FUNZONE2
20251214 063651 : mobile dr_status:1
20251214 063651 output={"msisdn":"6285136176241"}

20251214 063651 msisdn=6285136176241
20251214 063651 outsideloop msisdn=6285136176241
20251214 063651 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285136176241' order by  id desc limit 1
Query:20251214 063651: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285136176241'
Query:20251214 063651: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-21 13:19:29',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285136176241','','','REG FUNZONE2')
20251214 063651 : requested url:/gameverse/idtl/callback_itg.php
20251214 063651 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"-FkjGvsCnfMSMK6BG163MCdM6mCEBg6QwgiGRj9ur7zcC90Ed-ZKimg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063651 : mobile encrypted_msisdn:-FkjGvsCnfMSMK6BG163MCdM6mCEBg6QwgiGRj9ur7zcC90Ed-ZKimg=
20251214 063651 : mobile keyword:REG FUNZONE2
20251214 063651 : mobile dr_status:1
20251214 063651 output={"msisdn":"6285199015778"}

20251214 063651 msisdn=6285199015778
20251214 063651 outsideloop msisdn=6285199015778
20251214 063651 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285199015778' order by  id desc limit 1
Query:20251214 063651: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285199015778'
Query:20251214 063651: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-24 13:15:27',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285199015778','','','REG FUNZONE2')
20251214 063651 : requested url:/gameverse/idtl/callback_itg.php
20251214 063651 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"rNg1Fijqydi0c3B3fgrqzxkI_j2QEzbB4Q_9J-rM5THt72fGxW_KZWM=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063651 : mobile encrypted_msisdn:rNg1Fijqydi0c3B3fgrqzxkI_j2QEzbB4Q_9J-rM5THt72fGxW_KZWM=
20251214 063651 : mobile keyword:REG FUNZONE2
20251214 063651 : mobile dr_status:1
20251214 063651 output={"msisdn":"6282372036650"}

20251214 063651 msisdn=6282372036650
20251214 063651 outsideloop msisdn=6282372036650
20251214 063651 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282372036650' order by  id desc limit 1
Query:20251214 063651: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282372036650'
Query:20251214 063652: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-18 20:23:37',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282372036650','','','REG FUNZONE2')
20251214 063743 : requested url:/gameverse/idtl/callback_itg.php
20251214 063743 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"1JrFf4R3pU4zf0fjq0ysvpdHbQx0c8YcvQ9xL0r2SPej3S5aZX-LUyw=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063743 : mobile encrypted_msisdn:1JrFf4R3pU4zf0fjq0ysvpdHbQx0c8YcvQ9xL0r2SPej3S5aZX-LUyw=
20251214 063743 : mobile keyword:REG FUNZONE2
20251214 063743 : mobile dr_status:1
20251214 063743 output={"msisdn":"6281210141431"}

20251214 063743 msisdn=6281210141431
20251214 063743 outsideloop msisdn=6281210141431
20251214 063743 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281210141431' order by  id desc limit 1
Query:20251214 063743: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281210141431'
Query:20251214 063743: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-14 01:40:02',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281210141431','','','REG FUNZONE2')
20251214 063743 : requested url:/gameverse/idtl/callback_itg.php
20251214 063743 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Oy6Vggglyx3LzyhRgxwo_gTaSOO7hFVZuYHrz7ShAtjYoNrvbrQ-OQ==","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063743 : mobile encrypted_msisdn:Oy6Vggglyx3LzyhRgxwo_gTaSOO7hFVZuYHrz7ShAtjYoNrvbrQ-OQ==
20251214 063743 : mobile keyword:REG FUNZONE2
20251214 063743 : mobile dr_status:1
20251214 063743 output={"msisdn":"628129893770"}

20251214 063743 msisdn=628129893770
20251214 063743 outsideloop msisdn=628129893770
20251214 063743 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='628129893770' order by  id desc limit 1
Query:20251214 063743: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='628129893770'
Query:20251214 063743: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-14 04:39:34',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','628129893770','','','REG FUNZONE2')
20251214 063744 : requested url:/gameverse/idtl/callback_itg.php
20251214 063744 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"jAwItiVynu7j3CZv1a4GYZkX-bwt_hyPcRKA5T6XMaMsS7zJJ5E4Dr0=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063744 : mobile encrypted_msisdn:jAwItiVynu7j3CZv1a4GYZkX-bwt_hyPcRKA5T6XMaMsS7zJJ5E4Dr0=
20251214 063744 : mobile keyword:REG FUNZONE2
20251214 063744 : mobile dr_status:1
20251214 063744 output={"msisdn":"6281385467929"}

20251214 063744 msisdn=6281385467929
20251214 063744 outsideloop msisdn=6281385467929
20251214 063744 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281385467929' order by  id desc limit 1
Query:20251214 063744: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281385467929'
20251214 063744 : requested url:/gameverse/idtl/callback_itg.php
20251214 063744 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"YhSPr0KDYPTzzujVCfPsPpmKgeE4aFJA5NrHmOIXy82dEFENyxznDVE=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063744 : mobile encrypted_msisdn:YhSPr0KDYPTzzujVCfPsPpmKgeE4aFJA5NrHmOIXy82dEFENyxznDVE=
20251214 063744 : mobile keyword:REG FUNZONE2
20251214 063744 : mobile dr_status:1
20251214 063744 output={"msisdn":"6281210213002"}

20251214 063744 msisdn=6281210213002
20251214 063744 outsideloop msisdn=6281210213002
20251214 063744 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281210213002' order by  id desc limit 1
Query:20251214 063744: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281210213002'
Query:20251214 063744: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-14 01:51:27',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281385467929','','','REG FUNZONE2')
Query:20251214 063744: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-14 01:45:47',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281210213002','','','REG FUNZONE2')
20251214 063757 : requested url:/gameverse/idtl/callback_itg.php
20251214 063757 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Q8znoQNg7MGIectPAfl-S5vtcKO2dnPvSqemtNZ9NX8BpxuuFFjcmGU=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063757 : mobile encrypted_msisdn:Q8znoQNg7MGIectPAfl-S5vtcKO2dnPvSqemtNZ9NX8BpxuuFFjcmGU=
20251214 063757 : mobile keyword:REG FUNZONE2
20251214 063757 : mobile dr_status:1
20251214 063757 output={"msisdn":"6282158141672"}

20251214 063757 msisdn=6282158141672
20251214 063757 outsideloop msisdn=6282158141672
20251214 063757 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282158141672' order by  id desc limit 1
Query:20251214 063757: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282158141672'
Query:20251214 063757: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-11 10:52:44',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282158141672','','','REG FUNZONE2')
20251214 063758 : requested url:/gameverse/idtl/callback_itg.php
20251214 063758 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"_rnnAM_o2GY0I09z9RMgfRp6n8p0P1Br3ewkVGS5na2z5O0k1yfkKlo=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063758 : mobile encrypted_msisdn:_rnnAM_o2GY0I09z9RMgfRp6n8p0P1Br3ewkVGS5na2z5O0k1yfkKlo=
20251214 063758 : mobile keyword:REG FUNZONE2
20251214 063758 : mobile dr_status:1
20251214 063758 output={"msisdn":"6281316055595"}

20251214 063758 msisdn=6281316055595
20251214 063758 outsideloop msisdn=6281316055595
20251214 063758 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281316055595' order by  id desc limit 1
Query:20251214 063758: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281316055595'
Query:20251214 063758: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-11 05:09:47',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281316055595','','','REG FUNZONE2')
20251214 063758 : requested url:/gameverse/idtl/callback_itg.php
20251214 063758 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"m8S_UU9OqpBFHxCREc1IWif-b8sY0KtMKUXEylgUbugqPCRKkk7BCtg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063758 : mobile encrypted_msisdn:m8S_UU9OqpBFHxCREc1IWif-b8sY0KtMKUXEylgUbugqPCRKkk7BCtg=
20251214 063758 : mobile keyword:REG FUNZONE2
20251214 063758 : mobile dr_status:1
20251214 063758 output={"msisdn":"6282288563858"}

20251214 063758 msisdn=6282288563858
20251214 063758 outsideloop msisdn=6282288563858
20251214 063758 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282288563858' order by  id desc limit 1
Query:20251214 063758: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282288563858'
Query:20251214 063758: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-11 03:52:54',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282288563858','','','REG FUNZONE2')
20251214 063759 : requested url:/gameverse/idtl/callback_itg.php
20251214 063759 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"g_DuWptD5gK6Ujzoh9H-p9coIL_a7ox9mCBBqbNMF2j64UXZaAQCmeI=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 063759 : mobile encrypted_msisdn:g_DuWptD5gK6Ujzoh9H-p9coIL_a7ox9mCBBqbNMF2j64UXZaAQCmeI=
20251214 063759 : mobile keyword:REG FUNZONE2
20251214 063759 : mobile dr_status:1
20251214 063759 output={"msisdn":"6285219917355"}

20251214 063759 msisdn=6285219917355
20251214 063759 outsideloop msisdn=6285219917355
20251214 063759 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285219917355' order by  id desc limit 1
Query:20251214 063759: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285219917355'
Query:20251214 063759: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-08 09:45:41',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285219917355','','','REG FUNZONE2')
20251214 063836 : requested url:/gameverse/idtl/callback_itg.php
20251214 063836 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"7P-oezoyjOVpOOf8TtLbWTmQ-6OCewprDKXZya76ID42ijuoBmqxf00=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 063836 : mobile encrypted_msisdn:7P-oezoyjOVpOOf8TtLbWTmQ-6OCewprDKXZya76ID42ijuoBmqxf00=
20251214 063836 : mobile keyword:UNREG FUNZONE2
20251214 063836 : mobile dr_status:1
20251214 063836 output={"msisdn":"6282158141672"}

20251214 063836 msisdn=6282158141672
20251214 063836 outsideloop msisdn=6282158141672
20251214 063836 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282158141672' order by  id desc limit 1
Querydel:20251214 063836: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-11 10:52:44',now(),'6282158141672','UNREG FUNZONE2')
Queryt:20251214 063836: delete from tbl_subscription_Telkomsel_id where msisdn='6282158141672'
20251214 064438 : requested url:/gameverse/idtl/callback_itg.php
20251214 064438 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"sRlUtSZyj-uRjzY-tmgTG0QtN-lzoqOIr9RQ_jtcm2oOKXWyPrLDxg0=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""}
20251214 064438 : mobile encrypted_msisdn:sRlUtSZyj-uRjzY-tmgTG0QtN-lzoqOIr9RQ_jtcm2oOKXWyPrLDxg0=
20251214 064438 : mobile keyword:REG FUNZONE1
20251214 064438 : mobile dr_status:1
20251214 064438 output={"msisdn":"6282369422783"}

20251214 064438 msisdn=6282369422783
20251214 064438 outsideloop msisdn=6282369422783
20251214 064438 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282369422783' order by  id desc limit 1
Query:20251214 064438: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282369422783'
Query:20251214 064438: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-07-28 21:05:39',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282369422783','','','REG FUNZONE1')
20251214 064438 : requested url:/gameverse/idtl/callback_itg.php
20251214 064438 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Whi3EhV746fIDetcAQ86w321dHcMfFpa_BunTxoP6H7DJRD1UoUK8Qc=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""}
20251214 064438 : mobile encrypted_msisdn:Whi3EhV746fIDetcAQ86w321dHcMfFpa_BunTxoP6H7DJRD1UoUK8Qc=
20251214 064438 : mobile keyword:REG FUNZONE1
20251214 064438 : mobile dr_status:1
20251214 064438 output={"msisdn":"6282173322604"}

20251214 064438 msisdn=6282173322604
20251214 064438 outsideloop msisdn=6282173322604
20251214 064438 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282173322604' order by  id desc limit 1
Query:20251214 064438: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282173322604'
Query:20251214 064438: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-06 02:54:01',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282173322604','','','REG FUNZONE1')
20251214 065132 : requested url:/gameverse/idtl/callback_itg.php
20251214 065132 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"UyqCivmIpTLW9b_2lzzcC0rlKCD619pI9UraeHPuEHlXhi69lgt6sDI=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 065132 : mobile encrypted_msisdn:UyqCivmIpTLW9b_2lzzcC0rlKCD619pI9UraeHPuEHlXhi69lgt6sDI=
20251214 065132 : mobile keyword:REG FUNZONE2
20251214 065132 : mobile dr_status:1
20251214 065132 output={"msisdn":"6285379990888"}

20251214 065132 msisdn=6285379990888
20251214 065132 outsideloop msisdn=6285379990888
20251214 065132 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285379990888' order by  id desc limit 1
Query:20251214 065132: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285379990888'
Query:20251214 065132: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-21 21:01:59',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285379990888','','','REG FUNZONE2')
20251214 065154 : requested url:/gameverse/idtl/callback_itg.php
20251214 065154 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"E1nAt6i3uSxphi5kXfB6tuOC-KbA5E9hcyL_c6Mf2KEpnlsgS_ehKJg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 065154 : mobile encrypted_msisdn:E1nAt6i3uSxphi5kXfB6tuOC-KbA5E9hcyL_c6Mf2KEpnlsgS_ehKJg=
20251214 065154 : mobile keyword:REG FUNZONE2
20251214 065154 : mobile dr_status:1
20251214 065154 output={"msisdn":"6281351484977"}

20251214 065154 msisdn=6281351484977
20251214 065154 outsideloop msisdn=6281351484977
20251214 065154 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281351484977' order by  id desc limit 1
Query:20251214 065154: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281351484977'
Query:20251214 065154: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-10 21:57:21',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281351484977','','','REG FUNZONE2')
20251214 065306 : requested url:/gameverse/idtl/callback_itg.php
20251214 065306 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"qbV2L8TOPxq3ospit1xv_hlnWgqR4EH-s4HGfnmX3nVA0D9C--F5MW8=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 065306 : mobile encrypted_msisdn:qbV2L8TOPxq3ospit1xv_hlnWgqR4EH-s4HGfnmX3nVA0D9C--F5MW8=
20251214 065306 : mobile keyword:REG FUNZONE2
20251214 065306 : mobile dr_status:1
20251214 065306 output={"msisdn":"6282233107979"}

20251214 065306 msisdn=6282233107979
20251214 065306 outsideloop msisdn=6282233107979
20251214 065306 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282233107979' order by  id desc limit 1
Query:20251214 065306: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282233107979'
Query:20251214 065306: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-11 19:39:42',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282233107979','','','REG FUNZONE2')
20251214 065314 : requested url:/gameverse/idtl/callback_itg.php
20251214 065314 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"ylV-2_mV2baGhPABpEtLHta1GDy0_Odr4usWcJVXRO5x3ZvxSp_ORDg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 065314 : mobile encrypted_msisdn:ylV-2_mV2baGhPABpEtLHta1GDy0_Odr4usWcJVXRO5x3ZvxSp_ORDg=
20251214 065314 : mobile keyword:REG FUNZONE2
20251214 065314 : mobile dr_status:1
20251214 065314 output={"msisdn":"6282375575833"}

20251214 065314 msisdn=6282375575833
20251214 065314 outsideloop msisdn=6282375575833
20251214 065314 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282375575833' order by  id desc limit 1
Query:20251214 065314: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282375575833'
Query:20251214 065314: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-20 03:45:27',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282375575833','','','REG FUNZONE2')
20251214 065910 : requested url:/gameverse/idtl/callback_itg.php
20251214 065910 : json:{"adnetid":"96014","clickid":"251214065906000000","dr_status":"0","encrypted_msisdn":"h-EoYvowcs4Vft_sQJ4PgJVpd3fUiC0sohY1NROwOhF24vkSmceVOtI=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1765675747540844290"}
20251214 065910 : mobile encrypted_msisdn:h-EoYvowcs4Vft_sQJ4PgJVpd3fUiC0sohY1NROwOhF24vkSmceVOtI=
20251214 065910 : mobile keyword:REG FUNZONE2
20251214 065910 : mobile dr_status:0
20251214 065910 output={"msisdn":"6281377040553"}

20251214 065910 msisdn=6281377040553
20251214 065910 outsideloop msisdn=6281377040553
20251214 065910 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214065906000000' order by id desc limit 1
20251214 065910 subid=693e12e18abcec0341de7cca
20251214 065910 pubid=2
Query:20251214 065910: 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,'2','693e12e18abcec0341de7cca','5','LOW-BL','0','subs','6281377040553','251214065906000000','WEB1765675747540844290','REG FUNZONE2')
Query:20251214 065910: 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,'2','693e12e18abcec0341de7cca','5','LOW-BL','0','subs','6281377040553','251214065906000000','WEB1765675747540844290','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693e12e18abcec0341de7cca&campid=5:251214065910000000: 20251214 061210 output:200
20251214 072215 : requested url:/gameverse/idtl/callback_itg.php
20251214 072215 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"q763m5skqyOIA6d7VOClrtvMbdLZwgnVoiTDkYzhvwBRoIhbOF8Jczk=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 072215 : mobile encrypted_msisdn:q763m5skqyOIA6d7VOClrtvMbdLZwgnVoiTDkYzhvwBRoIhbOF8Jczk=
20251214 072215 : mobile keyword:UNREG FUNZONE2
20251214 072215 : mobile dr_status:1
20251214 072215 output={"msisdn":"6285337372042"}

20251214 072215 msisdn=6285337372042
20251214 072215 outsideloop msisdn=6285337372042
20251214 072215 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285337372042' order by  id desc limit 1
Querydel:20251214 072215: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-11 02:42:17',now(),'6285337372042','UNREG FUNZONE2')
Queryt:20251214 072215: delete from tbl_subscription_Telkomsel_id where msisdn='6285337372042'
20251214 072743 : requested url:/gameverse/idtl/callback_itg.php
20251214 072743 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"-rA2K1UT67u9YfZoD5u2hkTWs4Of8zHDG0TQtD-g79fDx1jsl6fGEKU=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 072743 : mobile encrypted_msisdn:-rA2K1UT67u9YfZoD5u2hkTWs4Of8zHDG0TQtD-g79fDx1jsl6fGEKU=
20251214 072743 : mobile keyword:REG FUNZONE2
20251214 072743 : mobile dr_status:1
20251214 072743 output={"msisdn":"6281282349674"}

20251214 072743 msisdn=6281282349674
20251214 072743 outsideloop msisdn=6281282349674
20251214 072743 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281282349674' order by  id desc limit 1
Query:20251214 072743: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281282349674'
Query:20251214 072743: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-18 20:07:46',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281282349674','','','REG FUNZONE2')
20251214 074455 : requested url:/gameverse/idtl/callback_itg.php
20251214 074455 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"MAvX3OGG7TX24bX3LW75nSAj3A9UtRQHiizD3pBvHu5jkmx4ImwXRdE=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 074455 : mobile encrypted_msisdn:MAvX3OGG7TX24bX3LW75nSAj3A9UtRQHiizD3pBvHu5jkmx4ImwXRdE=
20251214 074455 : mobile keyword:UNREG FUNZONE2
20251214 074455 : mobile dr_status:1
20251214 074455 output={"msisdn":"6281232227871"}

20251214 074455 msisdn=6281232227871
20251214 074455 outsideloop msisdn=6281232227871
20251214 074455 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281232227871' order by  id desc limit 1
Querydel:20251214 074456: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-08-26 05:01:23',now(),'6281232227871','UNREG FUNZONE2')
Queryt:20251214 074456: delete from tbl_subscription_Telkomsel_id where msisdn='6281232227871'
20251214 085135 : requested url:/gameverse/idtl/callback_itg.php
20251214 085135 : json:{"adnetid":"96014","clickid":"251214085025000000","dr_status":"0","encrypted_msisdn":"tPPOC-nAGnt6Jb1w9fhu4dL_M59DpiunBl8cjC4qP3bRTfIxiJ5ue4I=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17656824581091730023"}
20251214 085135 : mobile encrypted_msisdn:tPPOC-nAGnt6Jb1w9fhu4dL_M59DpiunBl8cjC4qP3bRTfIxiJ5ue4I=
20251214 085135 : mobile keyword:REG FUNZONE2
20251214 085135 : mobile dr_status:0
20251214 085135 output={"msisdn":"6282180687752"}

20251214 085135 msisdn=6282180687752
20251214 085135 outsideloop msisdn=6282180687752
20251214 085135 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214085025000000' order by id desc limit 1
20251214 085135 subid=693e2cf3b9ab0903440aab8b
20251214 085135 pubid=2
Query:20251214 085135: 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,'2','693e2cf3b9ab0903440aab8b','5','LOW-BL','0','subs','6282180687752','251214085025000000','WEB17656824581091730023','REG FUNZONE2')
Query:20251214 085135: 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,'2','693e2cf3b9ab0903440aab8b','5','LOW-BL','0','subs','6282180687752','251214085025000000','WEB17656824581091730023','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693e2cf3b9ab0903440aab8b&campid=5:251214085135000000: 20251214 081235 output:200
20251214 085155 : requested url:/gameverse/idtl/callback_itg.php
20251214 085155 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Q0mBkqP6CzjttcaOlIicRhLr2_SyI3-OB6l0TdNKbGtiU8VwKNrcrVU=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 085155 : mobile encrypted_msisdn:Q0mBkqP6CzjttcaOlIicRhLr2_SyI3-OB6l0TdNKbGtiU8VwKNrcrVU=
20251214 085155 : mobile keyword:UNREG FUNZONE2
20251214 085155 : mobile dr_status:1
20251214 085155 output={"msisdn":"6282180687752"}

20251214 085155 msisdn=6282180687752
20251214 085155 outsideloop msisdn=6282180687752
20251214 085155 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282180687752' order by  id desc limit 1
Querydel:20251214 085155: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-14 08:51:35',now(),'6282180687752','UNREG FUNZONE2')
Queryt:20251214 085155: delete from tbl_subscription_Telkomsel_id where msisdn='6282180687752'
20251214 091132 : requested url:/gameverse/idtl/callback_itg.php
20251214 091132 : json:{"adnetid":"96014","clickid":"251214091129000000","dr_status":"0","encrypted_msisdn":"e5HZEC6UmiwlpDk6mk1zcqCzqJ5EPBIZdcwoPcgf-E1y200CaL5G19w=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17656836891643578285"}
20251214 091132 : mobile encrypted_msisdn:e5HZEC6UmiwlpDk6mk1zcqCzqJ5EPBIZdcwoPcgf-E1y200CaL5G19w=
20251214 091132 : mobile keyword:REG FUNZONE2
20251214 091132 : mobile dr_status:0
20251214 091132 output={"msisdn":"6285288821130"}

20251214 091132 msisdn=6285288821130
20251214 091132 outsideloop msisdn=6285288821130
20251214 091132 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214091129000000' order by id desc limit 1
20251214 091132 subid=693e31e8858c95035278b04d
20251214 091132 pubid=2
Query:20251214 091132: 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,'2','693e31e8858c95035278b04d','5','LOW-BL','0','subs','6285288821130','251214091129000000','WEB17656836891643578285','REG FUNZONE2')
Query:20251214 091132: 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,'2','693e31e8858c95035278b04d','5','LOW-BL','0','subs','6285288821130','251214091129000000','WEB17656836891643578285','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693e31e8858c95035278b04d&campid=5:251214091132000000: 20251214 091232 output:200
20251214 091209 : requested url:/gameverse/idtl/callback_itg.php
20251214 091209 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"wuucoVhpvODTLK_0nnoe-To3Gfuug8mvRyovrLuDKvVfqZ4lPwwQhxg=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 091209 : mobile encrypted_msisdn:wuucoVhpvODTLK_0nnoe-To3Gfuug8mvRyovrLuDKvVfqZ4lPwwQhxg=
20251214 091209 : mobile keyword:UNREG FUNZONE2
20251214 091209 : mobile dr_status:1
20251214 091209 output={"msisdn":"6285288821130"}

20251214 091209 msisdn=6285288821130
20251214 091209 outsideloop msisdn=6285288821130
20251214 091209 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285288821130' order by  id desc limit 1
Querydel:20251214 091209: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-14 09:11:32',now(),'6285288821130','UNREG FUNZONE2')
Queryt:20251214 091209: delete from tbl_subscription_Telkomsel_id where msisdn='6285288821130'
20251214 094050 : requested url:/gameverse/idtl/callback_itg.php
20251214 094050 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"uZ4fp5ybVZHDav5g6Pqm4lEkd6TyhhxxsK3cOa9lCCQ0Wz3AiejklvE=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 094050 : mobile encrypted_msisdn:uZ4fp5ybVZHDav5g6Pqm4lEkd6TyhhxxsK3cOa9lCCQ0Wz3AiejklvE=
20251214 094050 : mobile keyword:UNREG FUNZONE2
20251214 094050 : mobile dr_status:1
20251214 094050 output={"msisdn":"6281241699387"}

20251214 094050 msisdn=6281241699387
20251214 094050 outsideloop msisdn=6281241699387
20251214 094050 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281241699387' order by  id desc limit 1
Querydel:20251214 094050: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-08-24 14:28:59',now(),'6281241699387','UNREG FUNZONE2')
Queryt:20251214 094050: delete from tbl_subscription_Telkomsel_id where msisdn='6281241699387'
20251214 094904 : requested url:/gameverse/idtl/callback_itg.php
20251214 094904 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"IMQ33xpJm83BRWNiPTNUaQQlQUzEdAdx4tHNcZ9hH9IbNzIrX-pe9JA=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 094904 : mobile encrypted_msisdn:IMQ33xpJm83BRWNiPTNUaQQlQUzEdAdx4tHNcZ9hH9IbNzIrX-pe9JA=
20251214 094904 : mobile keyword:UNREG FUNZONE2
20251214 094904 : mobile dr_status:1
20251214 094904 output={"msisdn":"6285230381170"}

20251214 094904 msisdn=6285230381170
20251214 094904 outsideloop msisdn=6285230381170
20251214 094904 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285230381170' order by  id desc limit 1
Querydel:20251214 094904: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-13 16:25:48',now(),'6285230381170','UNREG FUNZONE2')
Queryt:20251214 094904: delete from tbl_subscription_Telkomsel_id where msisdn='6285230381170'
20251214 095001 : requested url:/gameverse/idtl/callback_itg.php
20251214 095001 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"RlT9ei2HrE3rPErGqx4hIqkNLZ0Y9v8jE4lV21V28XXY_rD8VHHuHUw=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 095001 : mobile encrypted_msisdn:RlT9ei2HrE3rPErGqx4hIqkNLZ0Y9v8jE4lV21V28XXY_rD8VHHuHUw=
20251214 095001 : mobile keyword:REG FUNZONE2
20251214 095001 : mobile dr_status:1
20251214 095001 output={"msisdn":"6285215196331"}

20251214 095001 msisdn=6285215196331
20251214 095001 outsideloop msisdn=6285215196331
20251214 095001 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285215196331' order by  id desc limit 1
Query:20251214 095001: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285215196331'
Query:20251214 095002: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-12 01:05:30',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285215196331','','','REG FUNZONE2')
20251214 101144 : requested url:/gameverse/idtl/callback_itg.php
20251214 101144 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"76KUpMro3wJtZI5WaMiL9rzpNrvos3-uSUKPBOi-Abf42Mz6O3RY4cM=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 101144 : mobile encrypted_msisdn:76KUpMro3wJtZI5WaMiL9rzpNrvos3-uSUKPBOi-Abf42Mz6O3RY4cM=
20251214 101144 : mobile keyword:UNREG FUNZONE2
20251214 101144 : mobile dr_status:1
20251214 101144 output={"msisdn":"6281295170787"}

20251214 101144 msisdn=6281295170787
20251214 101144 outsideloop msisdn=6281295170787
20251214 101144 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281295170787' order by  id desc limit 1
Querydel:20251214 101144: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-29 04:13:36',now(),'6281295170787','UNREG FUNZONE2')
Queryt:20251214 101144: delete from tbl_subscription_Telkomsel_id where msisdn='6281295170787'
20251214 104149 : requested url:/gameverse/idtl/callback_itg.php
20251214 104149 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"9VTQZfh0vEP1iD_lS97tqQNvW_VOw3zJTvovsIXTcNXzsfnV0YUPUnk=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 104149 : mobile encrypted_msisdn:9VTQZfh0vEP1iD_lS97tqQNvW_VOw3zJTvovsIXTcNXzsfnV0YUPUnk=
20251214 104149 : mobile keyword:UNREG FUNZONE2
20251214 104149 : mobile dr_status:1
20251214 104149 output={"msisdn":"6285285966060"}

20251214 104149 msisdn=6285285966060
20251214 104149 outsideloop msisdn=6285285966060
20251214 104149 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285285966060' order by  id desc limit 1
Querydel:20251214 104149: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-07 09:50:04',now(),'6285285966060','UNREG FUNZONE2')
Queryt:20251214 104149: delete from tbl_subscription_Telkomsel_id where msisdn='6285285966060'
20251214 104436 : requested url:/gameverse/idtl/callback_itg.php
20251214 104436 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"kVsIRqacX1OzlSJ25rjKHOziSypS5EeEqEw-DYEzqUWTe7mMdl3Zyi4=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 104436 : mobile encrypted_msisdn:kVsIRqacX1OzlSJ25rjKHOziSypS5EeEqEw-DYEzqUWTe7mMdl3Zyi4=
20251214 104436 : mobile keyword:UNREG FUNZONE2
20251214 104436 : mobile dr_status:1
20251214 104436 output={"msisdn":"6282315595704"}

20251214 104436 msisdn=6282315595704
20251214 104436 outsideloop msisdn=6282315595704
20251214 104436 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282315595704' order by  id desc limit 1
Querydel:20251214 104436: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-11 13:50:52',now(),'6282315595704','UNREG FUNZONE2')
Queryt:20251214 104436: delete from tbl_subscription_Telkomsel_id where msisdn='6282315595704'
20251214 122804 : requested url:/gameverse/idtl/callback_itg.php
20251214 122804 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"o0x7ZnEnZ3E2zVKuUO7S2iioX8qsq91Jor9BXPgEO9J3d-QXg4P2few=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""}
20251214 122804 : mobile encrypted_msisdn:o0x7ZnEnZ3E2zVKuUO7S2iioX8qsq91Jor9BXPgEO9J3d-QXg4P2few=
20251214 122804 : mobile keyword:REG FUNZONE1
20251214 122804 : mobile dr_status:1
20251214 122804 output={"msisdn":"6281288371544"}

20251214 122804 msisdn=6281288371544
20251214 122804 outsideloop msisdn=6281288371544
20251214 122804 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281288371544' order by  id desc limit 1
Query:20251214 122804: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281288371544'
Query:20251214 122804: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-01 21:01:43',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6281288371544','','','REG FUNZONE1')
20251214 123202 : requested url:/gameverse/idtl/callback_itg.php
20251214 123202 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"j8H8vnDJU_BVlETIVXb2p-B1sTxiiwNUyU2oaRFC-wZQJzXS6V2nKTE=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 123202 : mobile encrypted_msisdn:j8H8vnDJU_BVlETIVXb2p-B1sTxiiwNUyU2oaRFC-wZQJzXS6V2nKTE=
20251214 123202 : mobile keyword:REG FUNZONE2
20251214 123202 : mobile dr_status:1
20251214 123202 output={"msisdn":"6282266026291"}

20251214 123202 msisdn=6282266026291
20251214 123202 outsideloop msisdn=6282266026291
20251214 123202 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282266026291' order by  id desc limit 1
Query:20251214 123202: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282266026291'
Query:20251214 123202: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-07 10:27:06',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282266026291','','','REG FUNZONE2')
20251214 123226 : requested url:/gameverse/idtl/callback_itg.php
20251214 123226 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"WqyizZikGlvGLM061l3IxRJh9eEq7NoRma22ShEC66DMpDWxDnvw40A=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 123226 : mobile encrypted_msisdn:WqyizZikGlvGLM061l3IxRJh9eEq7NoRma22ShEC66DMpDWxDnvw40A=
20251214 123226 : mobile keyword:REG FUNZONE2
20251214 123226 : mobile dr_status:1
20251214 123226 output={"msisdn":"6285378584735"}

20251214 123226 msisdn=6285378584735
20251214 123226 outsideloop msisdn=6285378584735
20251214 123226 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285378584735' order by  id desc limit 1
Query:20251214 123226: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285378584735'
Query:20251214 123226: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-03 15:10:30',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285378584735','','','REG FUNZONE2')
20251214 123335 : requested url:/gameverse/idtl/callback_itg.php
20251214 123335 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"4m1TcOG0E5s2KeVokJswxmBkNU-5dSUDzd-C46iJbL-y76gGifQja4w=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 123335 : mobile encrypted_msisdn:4m1TcOG0E5s2KeVokJswxmBkNU-5dSUDzd-C46iJbL-y76gGifQja4w=
20251214 123335 : mobile keyword:REG FUNZONE2
20251214 123335 : mobile dr_status:1
20251214 123335 output={"msisdn":"6281331148411"}

20251214 123335 msisdn=6281331148411
20251214 123335 outsideloop msisdn=6281331148411
20251214 123335 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281331148411' order by  id desc limit 1
Query:20251214 123335: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281331148411'
Query:20251214 123335: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-26 08:55:30',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281331148411','','','REG FUNZONE2')
20251214 123340 : requested url:/gameverse/idtl/callback_itg.php
20251214 123340 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Jb9BEKYR-G1XqFvJiT7BSXj6ZpPeBRpCil0Lp-Jg12xF9RxaBLx3m48=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 123340 : mobile encrypted_msisdn:Jb9BEKYR-G1XqFvJiT7BSXj6ZpPeBRpCil0Lp-Jg12xF9RxaBLx3m48=
20251214 123340 : mobile keyword:REG FUNZONE2
20251214 123340 : mobile dr_status:1
20251214 123340 output={"msisdn":"6281319119911"}

20251214 123340 msisdn=6281319119911
20251214 123340 outsideloop msisdn=6281319119911
20251214 123340 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281319119911' order by  id desc limit 1
Query:20251214 123340: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281319119911'
Query:20251214 123340: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-14 11:06:25',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281319119911','','','REG FUNZONE2')
20251214 123350 : requested url:/gameverse/idtl/callback_itg.php
20251214 123350 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"8OYNfZ1iNCPR1vmkXSAuwfJVke-aziHrHg5bqhCWDrSr9pn7ifrmKEU=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 123350 : mobile encrypted_msisdn:8OYNfZ1iNCPR1vmkXSAuwfJVke-aziHrHg5bqhCWDrSr9pn7ifrmKEU=
20251214 123350 : mobile keyword:REG FUNZONE2
20251214 123350 : mobile dr_status:1
20251214 123350 output={"msisdn":"6285121151967"}

20251214 123350 msisdn=6285121151967
20251214 123350 outsideloop msisdn=6285121151967
20251214 123350 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285121151967' order by  id desc limit 1
Query:20251214 123350: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285121151967'
Query:20251214 123350: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-05 07:14:17',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285121151967','','','REG FUNZONE2')
20251214 123354 : requested url:/gameverse/idtl/callback_itg.php
20251214 123354 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"io5eOk_1enRDtIdN0yQ6wdoGExpmESYAEv5RFNXK-R2aJpJmYBic_k8=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 123354 : mobile encrypted_msisdn:io5eOk_1enRDtIdN0yQ6wdoGExpmESYAEv5RFNXK-R2aJpJmYBic_k8=
20251214 123354 : mobile keyword:REG FUNZONE2
20251214 123354 : mobile dr_status:1
20251214 123354 output={"msisdn":"6281122222733"}

20251214 123354 msisdn=6281122222733
20251214 123354 outsideloop msisdn=6281122222733
20251214 123354 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281122222733' order by  id desc limit 1
Query:20251214 123354: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281122222733'
20251214 123354 : requested url:/gameverse/idtl/callback_itg.php
20251214 123354 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"khSBp9mACIb1GnS8RXYuENg3oq3B1Dvy_LM6VdYyLgfDQPQWZct5M34=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 123354 : mobile encrypted_msisdn:khSBp9mACIb1GnS8RXYuENg3oq3B1Dvy_LM6VdYyLgfDQPQWZct5M34=
20251214 123354 : mobile keyword:REG FUNZONE2
20251214 123354 : mobile dr_status:1
20251214 123354 output={"msisdn":"6285224982880"}

20251214 123354 msisdn=6285224982880
20251214 123354 outsideloop msisdn=6285224982880
20251214 123354 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285224982880' order by  id desc limit 1
Query:20251214 123354: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285224982880'
Query:20251214 123354: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-11 09:48:46',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281122222733','','','REG FUNZONE2')
Query:20251214 123354: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-11 09:30:45',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285224982880','','','REG FUNZONE2')
20251214 123354 : requested url:/gameverse/idtl/callback_itg.php
20251214 123354 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"9Kbnj63C19UZOMzLPp-RrQohdoC-c3JLB4eUFoOR8BBErRBK_vkj0rc=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 123354 : mobile encrypted_msisdn:9Kbnj63C19UZOMzLPp-RrQohdoC-c3JLB4eUFoOR8BBErRBK_vkj0rc=
20251214 123354 : mobile keyword:REG FUNZONE2
20251214 123354 : mobile dr_status:1
20251214 123354 output={"msisdn":"6282150189810"}

20251214 123354 msisdn=6282150189810
20251214 123354 outsideloop msisdn=6282150189810
20251214 123354 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282150189810' order by  id desc limit 1
Query:20251214 123354: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282150189810'
Query:20251214 123354: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-11 12:28:05',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282150189810','','','REG FUNZONE2')
20251214 123354 : requested url:/gameverse/idtl/callback_itg.php
20251214 123354 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"bNTHYFm4iNMiD9NzY77CoVnL_HVuHPSQjOFlY-gQAshjcG_JkCKVDow=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 123354 : mobile encrypted_msisdn:bNTHYFm4iNMiD9NzY77CoVnL_HVuHPSQjOFlY-gQAshjcG_JkCKVDow=
20251214 123354 : mobile keyword:REG FUNZONE2
20251214 123354 : mobile dr_status:1
20251214 123354 output={"msisdn":"6285343682290"}

20251214 123354 msisdn=6285343682290
20251214 123354 outsideloop msisdn=6285343682290
20251214 123354 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285343682290' order by  id desc limit 1
Query:20251214 123354: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285343682290'
Query:20251214 123354: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-11 11:56:18',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285343682290','','','REG FUNZONE2')
20251214 124246 : requested url:/gameverse/idtl/callback_itg.php
20251214 124246 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"qGmt7mn9SBEE01Nh5Vy1H2nNrM2cKT3mK8KZq5MATiNwJyIix5l1Oz0=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""}
20251214 124246 : mobile encrypted_msisdn:qGmt7mn9SBEE01Nh5Vy1H2nNrM2cKT3mK8KZq5MATiNwJyIix5l1Oz0=
20251214 124246 : mobile keyword:REG FUNZONE1
20251214 124246 : mobile dr_status:1
20251214 124246 output={"msisdn":"6282384046920"}

20251214 124246 msisdn=6282384046920
20251214 124246 outsideloop msisdn=6282384046920
20251214 124246 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282384046920' order by  id desc limit 1
Query:20251214 124246: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282384046920'
Query:20251214 124246: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-07-25 20:59:37',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282384046920','','','REG FUNZONE1')
20251214 125218 : requested url:/gameverse/idtl/callback_itg.php
20251214 125218 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"5Mu_KHJ_ykP93XUQPis3bDB9BOZQOZoLi365mDzLMfopi1jsORUdxnU=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 125218 : mobile encrypted_msisdn:5Mu_KHJ_ykP93XUQPis3bDB9BOZQOZoLi365mDzLMfopi1jsORUdxnU=
20251214 125218 : mobile keyword:REG FUNZONE2
20251214 125218 : mobile dr_status:1
20251214 125218 output={"msisdn":"6285343578115"}

20251214 125218 msisdn=6285343578115
20251214 125218 outsideloop msisdn=6285343578115
20251214 125218 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285343578115' order by  id desc limit 1
Query:20251214 125218: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285343578115'
Query:20251214 125218: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-19 04:03:46',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285343578115','','','REG FUNZONE2')
20251214 125231 : requested url:/gameverse/idtl/callback_itg.php
20251214 125231 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"4fvA9ayB7pQbD3RVYkzPCjf4zfWax1G6RYaHNBAC9oPoOeZdHBE6ylg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 125231 : mobile encrypted_msisdn:4fvA9ayB7pQbD3RVYkzPCjf4zfWax1G6RYaHNBAC9oPoOeZdHBE6ylg=
20251214 125231 : mobile keyword:REG FUNZONE2
20251214 125231 : mobile dr_status:1
20251214 125231 output={"msisdn":"6281234788473"}

20251214 125231 msisdn=6281234788473
20251214 125231 outsideloop msisdn=6281234788473
20251214 125231 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281234788473' order by  id desc limit 1
Query:20251214 125231: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281234788473'
Query:20251214 125231: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-10-14 12:00:07',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281234788473','','','REG FUNZONE2')
20251214 125315 : requested url:/gameverse/idtl/callback_itg.php
20251214 125315 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Ph5v3WZUbzsynCE05DmNVED-ka1sw09kZVXcrqxjvAoDUZZx_Di_nI8=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 125315 : mobile encrypted_msisdn:Ph5v3WZUbzsynCE05DmNVED-ka1sw09kZVXcrqxjvAoDUZZx_Di_nI8=
20251214 125315 : mobile keyword:REG FUNZONE2
20251214 125315 : mobile dr_status:1
20251214 125315 output={"msisdn":"6282190083939"}

20251214 125315 msisdn=6282190083939
20251214 125315 outsideloop msisdn=6282190083939
20251214 125315 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282190083939' order by  id desc limit 1
Query:20251214 125315: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282190083939'
Query:20251214 125315: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-23 03:38:04',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282190083939','','','REG FUNZONE2')
20251214 125407 : requested url:/gameverse/idtl/callback_itg.php
20251214 125407 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"xV2SWfeWu-7X45RvuAs3_0K8kfz4ywYFzzPtcEl1J8m2qi_UgqsBTGc=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 125407 : mobile encrypted_msisdn:xV2SWfeWu-7X45RvuAs3_0K8kfz4ywYFzzPtcEl1J8m2qi_UgqsBTGc=
20251214 125407 : mobile keyword:REG FUNZONE2
20251214 125407 : mobile dr_status:1
20251214 125407 output={"msisdn":"6282184851449"}

20251214 125407 msisdn=6282184851449
20251214 125407 outsideloop msisdn=6282184851449
20251214 125407 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282184851449' order by  id desc limit 1
Query:20251214 125407: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282184851449'
Query:20251214 125407: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-30 08:01:01',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282184851449','','','REG FUNZONE2')
20251214 125849 : requested url:/gameverse/idtl/callback_itg.php
20251214 125849 : json:{"adnetid":"96014","clickid":"251214125842000000","dr_status":"0","encrypted_msisdn":"-W1lC6YG6Z7tY40h-mqaawR7o3U2_ROSOrqiMl5CaeSywu-_ENFGKA==","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17656973231244979598"}
20251214 125849 : mobile encrypted_msisdn:-W1lC6YG6Z7tY40h-mqaawR7o3U2_ROSOrqiMl5CaeSywu-_ENFGKA==
20251214 125849 : mobile keyword:REG FUNZONE2
20251214 125849 : mobile dr_status:0
20251214 125849 output={"msisdn":"628126726476"}

20251214 125849 msisdn=628126726476
20251214 125849 outsideloop msisdn=628126726476
20251214 125849 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214125842000000' order by id desc limit 1
20251214 125849 subid=693e6729b3eab70345819d53
20251214 125849 pubid=2
Query:20251214 125849: 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,'2','693e6729b3eab70345819d53','5','LOW-BL','0','subs','628126726476','251214125842000000','WEB17656973231244979598','REG FUNZONE2')
Query:20251214 125849: 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,'2','693e6729b3eab70345819d53','5','LOW-BL','0','subs','628126726476','251214125842000000','WEB17656973231244979598','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693e6729b3eab70345819d53&campid=5:251214125851000000: 20251214 121251 output:200
20251214 130819 : requested url:/gameverse/idtl/callback_itg.php
20251214 130819 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"dX_JObUK7He-q2t-aSD6FUctCtpeBIdU4KxPMFVWdXepzHW_WP5dA3E=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""}
20251214 130819 : mobile encrypted_msisdn:dX_JObUK7He-q2t-aSD6FUctCtpeBIdU4KxPMFVWdXepzHW_WP5dA3E=
20251214 130819 : mobile keyword:REG FUNZONE1
20251214 130819 : mobile dr_status:1
20251214 130819 output={"msisdn":"6281380130928"}

20251214 130819 msisdn=6281380130928
20251214 130819 outsideloop msisdn=6281380130928
20251214 130819 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281380130928' order by  id desc limit 1
Query:20251214 130819: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281380130928'
Query:20251214 130820: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-07-28 12:42:49',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6281380130928','','','REG FUNZONE1')
20251214 132057 : requested url:/gameverse/idtl/callback_itg.php
20251214 132057 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"AiSolrE6R3f4aFwFNo2xNPBfjo0nSv1Tj7PgZcF-i_zuCeaaNbBQ83Q=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 132057 : mobile encrypted_msisdn:AiSolrE6R3f4aFwFNo2xNPBfjo0nSv1Tj7PgZcF-i_zuCeaaNbBQ83Q=
20251214 132057 : mobile keyword:REG FUNZONE2
20251214 132057 : mobile dr_status:1
20251214 132057 output={"msisdn":"6285191429285"}

20251214 132057 msisdn=6285191429285
20251214 132057 outsideloop msisdn=6285191429285
20251214 132057 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285191429285' order by  id desc limit 1
Query:20251214 132057: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285191429285'
Query:20251214 132057: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-10-25 16:49:40',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285191429285','','','REG FUNZONE2')
20251214 132114 : requested url:/gameverse/idtl/callback_itg.php
20251214 132114 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"gtAezHNW6L1BDTubTB_yhgHhamyanNpJDNuxDOoZEda3fOdo2DeqwXQ=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 132114 : mobile encrypted_msisdn:gtAezHNW6L1BDTubTB_yhgHhamyanNpJDNuxDOoZEda3fOdo2DeqwXQ=
20251214 132114 : mobile keyword:REG FUNZONE2
20251214 132114 : mobile dr_status:1
20251214 132114 output={"msisdn":"6281220652590"}

20251214 132114 msisdn=6281220652590
20251214 132114 outsideloop msisdn=6281220652590
20251214 132114 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281220652590' order by  id desc limit 1
Query:20251214 132114: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281220652590'
Query:20251214 132114: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-15 09:00:09',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281220652590','','','REG FUNZONE2')
20251214 132511 : requested url:/gameverse/idtl/callback_itg.php
20251214 132511 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"sg3bH5Oo2F4xyNdmZsYWuaJqbAiXZkqjmwQqlTp78FUhJEFaSCkfy5E=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 132511 : mobile encrypted_msisdn:sg3bH5Oo2F4xyNdmZsYWuaJqbAiXZkqjmwQqlTp78FUhJEFaSCkfy5E=
20251214 132511 : mobile keyword:REG FUNZONE2
20251214 132511 : mobile dr_status:1
20251214 132511 output={"msisdn":"6281225128613"}

20251214 132511 msisdn=6281225128613
20251214 132511 outsideloop msisdn=6281225128613
20251214 132511 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281225128613' order by  id desc limit 1
Query:20251214 132511: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281225128613'
Query:20251214 132511: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-10-01 17:51:53',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281225128613','','','REG FUNZONE2')
20251214 133941 : requested url:/gameverse/idtl/callback_itg.php
20251214 133941 : json:{"adnetid":"96014","clickid":"251214133934000000","dr_status":"0","encrypted_msisdn":"lT98vUNZpr07ilUddodFKf1UjfronYM4TaEJtORIXPzJRH_QWYXFrNc=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17656997751237642560"}
20251214 133941 : mobile encrypted_msisdn:lT98vUNZpr07ilUddodFKf1UjfronYM4TaEJtORIXPzJRH_QWYXFrNc=
20251214 133941 : mobile keyword:REG FUNZONE2
20251214 133941 : mobile dr_status:0
20251214 133941 output={"msisdn":"6281245785704"}

20251214 133941 msisdn=6281245785704
20251214 133941 outsideloop msisdn=6281245785704
20251214 133941 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214133934000000' order by id desc limit 1
20251214 133941 subid=693e70bcba129c034420d83e
20251214 133941 pubid=2
Query:20251214 133941: 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,'2','693e70bcba129c034420d83e','5','LOW-BL','0','subs','6281245785704','251214133934000000','WEB17656997751237642560','REG FUNZONE2')
Query:20251214 133941: 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,'2','693e70bcba129c034420d83e','5','LOW-BL','0','subs','6281245785704','251214133934000000','WEB17656997751237642560','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693e70bcba129c034420d83e&campid=5:251214133943000000: 20251214 011243 output:200
20251214 140940 : requested url:/gameverse/idtl/callback_itg.php
20251214 140940 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"zB5_bvDngS6Oc-bGYJr4g6B9_sqMV48sJhgzF2izzfOKylgO4Q4FGHk=","keyword":"UNREG FUNZONE1","req_type":"unsubs","trx_id":""}
20251214 140940 : mobile encrypted_msisdn:zB5_bvDngS6Oc-bGYJr4g6B9_sqMV48sJhgzF2izzfOKylgO4Q4FGHk=
20251214 140940 : mobile keyword:UNREG FUNZONE1
20251214 140940 : mobile dr_status:1
20251214 140940 output={"msisdn":"6281257308233"}

20251214 140940 msisdn=6281257308233
20251214 140940 outsideloop msisdn=6281257308233
20251214 140940 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281257308233' order by  id desc limit 1
Querydel:20251214 140940: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-07-27 17:52:37',now(),'6281257308233','UNREG FUNZONE1')
Queryt:20251214 140940: delete from tbl_subscription_Telkomsel_id where msisdn='6281257308233'
20251214 142739 : requested url:/gameverse/idtl/callback_itg.php
20251214 142739 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"6Dhiec3uJwNzG0Gh4-Fzgj4-7o1Ckuaf-xVMd_GTWM-wvK5C-zSBZQ==","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 142739 : mobile encrypted_msisdn:6Dhiec3uJwNzG0Gh4-Fzgj4-7o1Ckuaf-xVMd_GTWM-wvK5C-zSBZQ==
20251214 142739 : mobile keyword:UNREG FUNZONE2
20251214 142739 : mobile dr_status:1
20251214 142739 output={"msisdn":"628126726476"}

20251214 142739 msisdn=628126726476
20251214 142739 outsideloop msisdn=628126726476
20251214 142739 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='628126726476' order by  id desc limit 1
Querydel:20251214 142739: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-14 12:58:49',now(),'628126726476','UNREG FUNZONE2')
Queryt:20251214 142739: delete from tbl_subscription_Telkomsel_id where msisdn='628126726476'
20251214 143106 : requested url:/gameverse/idtl/callback_itg.php
20251214 143106 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"RtD1NQjsgI2CMEF3OOERwnK1QaxkrPygNO3Qg7BM_64IGrW3w5do5TU=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 143106 : mobile encrypted_msisdn:RtD1NQjsgI2CMEF3OOERwnK1QaxkrPygNO3Qg7BM_64IGrW3w5do5TU=
20251214 143106 : mobile keyword:REG FUNZONE2
20251214 143106 : mobile dr_status:1
20251214 143106 output={"msisdn":"6282156244808"}

20251214 143106 msisdn=6282156244808
20251214 143106 outsideloop msisdn=6282156244808
20251214 143106 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282156244808' order by  id desc limit 1
Query:20251214 143106: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282156244808'
Query:20251214 143106: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-20 14:15:50',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282156244808','','','REG FUNZONE2')
20251214 143204 : requested url:/gameverse/idtl/callback_itg.php
20251214 143204 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"HwiiSNuwa49FrnVELYPZQViseE3sQMckbmt959BSrXDQWiAO70QDALg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 143204 : mobile encrypted_msisdn:HwiiSNuwa49FrnVELYPZQViseE3sQMckbmt959BSrXDQWiAO70QDALg=
20251214 143204 : mobile keyword:REG FUNZONE2
20251214 143204 : mobile dr_status:1
20251214 143204 output={"msisdn":"6281276433413"}

20251214 143204 msisdn=6281276433413
20251214 143204 outsideloop msisdn=6281276433413
20251214 143204 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281276433413' order by  id desc limit 1
Query:20251214 143204: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281276433413'
Query:20251214 143204: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-11 07:48:39',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281276433413','','','REG FUNZONE2')
20251214 144947 : requested url:/gameverse/idtl/callback_itg.php
20251214 144947 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"W9Gqxgp3e7esdfX3F-zKtQIHNoyD-XxnWokdnFtRiMuGpDl2vKqUsjw=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 144947 : mobile encrypted_msisdn:W9Gqxgp3e7esdfX3F-zKtQIHNoyD-XxnWokdnFtRiMuGpDl2vKqUsjw=
20251214 144947 : mobile keyword:REG FUNZONE2
20251214 144947 : mobile dr_status:1
20251214 144947 output={"msisdn":"6285213364965"}

20251214 144947 msisdn=6285213364965
20251214 144947 outsideloop msisdn=6285213364965
20251214 144947 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285213364965' order by  id desc limit 1
Query:20251214 144947: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285213364965'
Query:20251214 144947: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-13 15:41:51',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285213364965','','','REG FUNZONE2')
20251214 151849 : requested url:/gameverse/idtl/callback_itg.php
20251214 151849 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"2TE1ZlW-XlcokDbSKeHBD6MYUI2HF3E8Nn_t7MEyp-uqVUFM9ZtkCzg=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 151849 : mobile encrypted_msisdn:2TE1ZlW-XlcokDbSKeHBD6MYUI2HF3E8Nn_t7MEyp-uqVUFM9ZtkCzg=
20251214 151849 : mobile keyword:UNREG FUNZONE2
20251214 151849 : mobile dr_status:1
20251214 151849 output={"msisdn":"6281291879178"}

20251214 151849 msisdn=6281291879178
20251214 151849 outsideloop msisdn=6281291879178
20251214 151849 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281291879178' order by  id desc limit 1
Querydel:20251214 151849: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-12 06:28:30',now(),'6281291879178','UNREG FUNZONE2')
Queryt:20251214 151849: delete from tbl_subscription_Telkomsel_id where msisdn='6281291879178'
20251214 152555 : requested url:/gameverse/idtl/callback_itg.php
20251214 152555 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"uWWso3dIh1ZKtK1OYJcK1tF6_8ljyDyTpHFhxzvpK3L58qwzqiGzWsU=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 152555 : mobile encrypted_msisdn:uWWso3dIh1ZKtK1OYJcK1tF6_8ljyDyTpHFhxzvpK3L58qwzqiGzWsU=
20251214 152555 : mobile keyword:UNREG FUNZONE2
20251214 152555 : mobile dr_status:1
20251214 152555 output={"msisdn":"6282324762615"}

20251214 152555 msisdn=6282324762615
20251214 152555 outsideloop msisdn=6282324762615
20251214 152555 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282324762615' order by  id desc limit 1
Querydel:20251214 152555: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-12 12:39:36',now(),'6282324762615','UNREG FUNZONE2')
Queryt:20251214 152555: delete from tbl_subscription_Telkomsel_id where msisdn='6282324762615'
20251214 153409 : requested url:/gameverse/idtl/callback_itg.php
20251214 153409 : json:{"adnetid":"96014","clickid":"251214153343000000","dr_status":"0","encrypted_msisdn":"m2o400S66SX9ZYx6Hf715Ic5IfOqAYyo4-g7EN5fR9GfeIX1bX_kLcI=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1765706635860003697"}
20251214 153409 : mobile encrypted_msisdn:m2o400S66SX9ZYx6Hf715Ic5IfOqAYyo4-g7EN5fR9GfeIX1bX_kLcI=
20251214 153409 : mobile keyword:REG FUNZONE2
20251214 153409 : mobile dr_status:0
20251214 153409 output={"msisdn":"6281249645190"}

20251214 153409 msisdn=6281249645190
20251214 153409 outsideloop msisdn=6281249645190
20251214 153409 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214153343000000' order by id desc limit 1
20251214 153409 subid=693e8b7ef6bf890343e76f9f
20251214 153409 pubid=2
Query:20251214 153409: 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,'2','693e8b7ef6bf890343e76f9f','5','LOW-BL','0','subs','6281249645190','251214153343000000','WEB1765706635860003697','REG FUNZONE2')
Query:20251214 153409: 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,'2','693e8b7ef6bf890343e76f9f','5','LOW-BL','0','subs','6281249645190','251214153343000000','WEB1765706635860003697','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693e8b7ef6bf890343e76f9f&campid=5:251214153411000000: 20251214 031211 output:200
20251214 160018 : requested url:/gameverse/idtl/callback_itg.php
20251214 160018 : json:{"adnetid":"96014","clickid":"251214160007000000","dr_status":"0","encrypted_msisdn":"7adynEklc9BJsPSzWMe2SuvH-LhdjvIZQFVdDC3LIO74Djhcxr-pcOg=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1765708208633923101"}
20251214 160018 : mobile encrypted_msisdn:7adynEklc9BJsPSzWMe2SuvH-LhdjvIZQFVdDC3LIO74Djhcxr-pcOg=
20251214 160018 : mobile keyword:REG FUNZONE2
20251214 160018 : mobile dr_status:0
20251214 160018 output={"msisdn":"6282164414995"}

20251214 160018 msisdn=6282164414995
20251214 160018 outsideloop msisdn=6282164414995
20251214 160018 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214160007000000' order by id desc limit 1
20251214 160018 subid=693e91aeba129c03443894a4
20251214 160018 pubid=2
Query:20251214 160018: 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,'2','693e91aeba129c03443894a4','5','LOW-BL','0','subs','6282164414995','251214160007000000','WEB1765708208633923101','REG FUNZONE2')
Query:20251214 160018: 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,'2','693e91aeba129c03443894a4','5','LOW-BL','0','subs','6282164414995','251214160007000000','WEB1765708208633923101','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693e91aeba129c03443894a4&campid=5:251214160020000000: 20251214 041220 output:200
20251214 161443 : requested url:/gameverse/idtl/callback_itg.php
20251214 161443 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"n4zrCDhKxq9vQgPHjuPr3Qaz5icbErERit10MZ2AGgBDfZki7Hohlg==","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 161443 : mobile encrypted_msisdn:n4zrCDhKxq9vQgPHjuPr3Qaz5icbErERit10MZ2AGgBDfZki7Hohlg==
20251214 161443 : mobile keyword:UNREG FUNZONE2
20251214 161443 : mobile dr_status:1
20251214 161443 output={"msisdn":"628116367434"}

20251214 161443 msisdn=628116367434
20251214 161443 outsideloop msisdn=628116367434
20251214 161443 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='628116367434' order by  id desc limit 1
Querydel:20251214 161443: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-08-21 12:36:16',now(),'628116367434','UNREG FUNZONE2')
Queryt:20251214 161443: delete from tbl_subscription_Telkomsel_id where msisdn='628116367434'
20251214 163810 : requested url:/gameverse/idtl/callback_itg.php
20251214 163810 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"TfzODI9oiXYvc6vPmMqg-gQ1sDZLLoAayKux8IsUa6WXAZqrLXGNaXI=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""}
20251214 163810 : mobile encrypted_msisdn:TfzODI9oiXYvc6vPmMqg-gQ1sDZLLoAayKux8IsUa6WXAZqrLXGNaXI=
20251214 163810 : mobile keyword:REG FUNZONE1
20251214 163810 : mobile dr_status:1
20251214 163810 output={"msisdn":"6282269427793"}

20251214 163810 msisdn=6282269427793
20251214 163810 outsideloop msisdn=6282269427793
20251214 163810 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282269427793' order by  id desc limit 1
Query:20251214 163810: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282269427793'
Query:20251214 163810: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-07-26 10:35:19',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282269427793','','','REG FUNZONE1')
20251214 164235 : requested url:/gameverse/idtl/callback_itg.php
20251214 164235 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"GmkNXn1vrYD7yvKMwatzfmlPD2hGzZu8HYLGt9DV_5a8M5zfBBHJVks=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 164235 : mobile encrypted_msisdn:GmkNXn1vrYD7yvKMwatzfmlPD2hGzZu8HYLGt9DV_5a8M5zfBBHJVks=
20251214 164235 : mobile keyword:REG FUNZONE2
20251214 164235 : mobile dr_status:1
20251214 164235 output={"msisdn":"6282299587977"}

20251214 164235 msisdn=6282299587977
20251214 164235 outsideloop msisdn=6282299587977
20251214 164235 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282299587977' order by  id desc limit 1
Query:20251214 164235: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282299587977'
Query:20251214 164235: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-10 14:54:07',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282299587977','','','REG FUNZONE2')
20251214 164244 : requested url:/gameverse/idtl/callback_itg.php
20251214 164244 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"gw34pcb0Z5uWLCH51yRPgKOFFIcWfRlNKz2Dp30wvP2Mrtuzna8oU5Y=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 164244 : mobile encrypted_msisdn:gw34pcb0Z5uWLCH51yRPgKOFFIcWfRlNKz2Dp30wvP2Mrtuzna8oU5Y=
20251214 164244 : mobile keyword:UNREG FUNZONE2
20251214 164244 : mobile dr_status:1
20251214 164244 output={"msisdn":"6282223242036"}

20251214 164244 msisdn=6282223242036
20251214 164244 outsideloop msisdn=6282223242036
20251214 164244 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282223242036' order by  id desc limit 1
Querydel:20251214 164244: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-12 05:11:08',now(),'6282223242036','UNREG FUNZONE2')
Queryt:20251214 164244: delete from tbl_subscription_Telkomsel_id where msisdn='6282223242036'
20251214 164254 : requested url:/gameverse/idtl/callback_itg.php
20251214 164254 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"r9QdAaEV9KLHWVKzWkoxIpBBSrbydtPVszYhODnYq8EqizWWCAMvTNk=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 164254 : mobile encrypted_msisdn:r9QdAaEV9KLHWVKzWkoxIpBBSrbydtPVszYhODnYq8EqizWWCAMvTNk=
20251214 164254 : mobile keyword:REG FUNZONE2
20251214 164254 : mobile dr_status:1
20251214 164254 output={"msisdn":"6282352491501"}

20251214 164254 msisdn=6282352491501
20251214 164254 outsideloop msisdn=6282352491501
20251214 164254 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282352491501' order by  id desc limit 1
Query:20251214 164254: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282352491501'
Query:20251214 164254: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-22 13:44:34',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282352491501','','','REG FUNZONE2')
20251214 164321 : requested url:/gameverse/idtl/callback_itg.php
20251214 164321 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"7O8YUcayO28AGJaj-Xj9eKJNoPVzAkXrofa-iucs_MtJPfE7JJMbnFA=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 164321 : mobile encrypted_msisdn:7O8YUcayO28AGJaj-Xj9eKJNoPVzAkXrofa-iucs_MtJPfE7JJMbnFA=
20251214 164321 : mobile keyword:REG FUNZONE2
20251214 164321 : mobile dr_status:1
20251214 164321 output={"msisdn":"6281351311817"}

20251214 164321 msisdn=6281351311817
20251214 164321 outsideloop msisdn=6281351311817
20251214 164321 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281351311817' order by  id desc limit 1
Query:20251214 164321: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281351311817'
Query:20251214 164321: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-21 16:28:52',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281351311817','','','REG FUNZONE2')
20251214 164337 : requested url:/gameverse/idtl/callback_itg.php
20251214 164337 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"cTpxPFdJi6kga2hCTnBzW-pERy0U9gfFdIuu0Dn_E_Zq24INvLcQg6k=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 164337 : mobile encrypted_msisdn:cTpxPFdJi6kga2hCTnBzW-pERy0U9gfFdIuu0Dn_E_Zq24INvLcQg6k=
20251214 164337 : mobile keyword:REG FUNZONE2
20251214 164337 : mobile dr_status:1
20251214 164337 output={"msisdn":"6281328490629"}

20251214 164337 msisdn=6281328490629
20251214 164337 outsideloop msisdn=6281328490629
20251214 164337 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281328490629' order by  id desc limit 1
Query:20251214 164337: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281328490629'
Query:20251214 164337: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-10-02 22:54:36',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281328490629','','','REG FUNZONE2')
20251214 164434 : requested url:/gameverse/idtl/callback_itg.php
20251214 164434 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"iirfTDgg19NZTWVRzAuFXUu8qi-g_JC44xY91ZUGbFpACLvC0I6tQlE=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 164434 : mobile encrypted_msisdn:iirfTDgg19NZTWVRzAuFXUu8qi-g_JC44xY91ZUGbFpACLvC0I6tQlE=
20251214 164434 : mobile keyword:REG FUNZONE2
20251214 164434 : mobile dr_status:1
20251214 164434 output={"msisdn":"6281293565697"}

20251214 164434 msisdn=6281293565697
20251214 164434 outsideloop msisdn=6281293565697
20251214 164434 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281293565697' order by  id desc limit 1
Query:20251214 164434: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281293565697'
Query:20251214 164434: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-14 16:20:24',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281293565697','','','REG FUNZONE2')
20251214 164435 : requested url:/gameverse/idtl/callback_itg.php
20251214 164435 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"FUZi3l0JOdRbZb7BXmwg7DP39Fd3MuAvRlIcnOOEtpPX_E135GHyJi0=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 164435 : mobile encrypted_msisdn:FUZi3l0JOdRbZb7BXmwg7DP39Fd3MuAvRlIcnOOEtpPX_E135GHyJi0=
20251214 164435 : mobile keyword:REG FUNZONE2
20251214 164435 : mobile dr_status:1
20251214 164435 output={"msisdn":"6281321168914"}

20251214 164435 msisdn=6281321168914
20251214 164435 outsideloop msisdn=6281321168914
20251214 164435 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281321168914' order by  id desc limit 1
Query:20251214 164435: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281321168914'
Query:20251214 164435: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-14 12:39:14',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281321168914','','','REG FUNZONE2')
20251214 164436 : requested url:/gameverse/idtl/callback_itg.php
20251214 164436 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"MtxtRwNbydIdu64blqhmbBdWP4ZISA02GMNPL1g_wneTeDiv6XXgyic=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 164436 : mobile encrypted_msisdn:MtxtRwNbydIdu64blqhmbBdWP4ZISA02GMNPL1g_wneTeDiv6XXgyic=
20251214 164436 : mobile keyword:REG FUNZONE2
20251214 164436 : mobile dr_status:1
20251214 164436 output={"msisdn":"6281321470933"}

20251214 164436 msisdn=6281321470933
20251214 164436 outsideloop msisdn=6281321470933
20251214 164436 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281321470933' order by  id desc limit 1
Query:20251214 164436: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281321470933'
Query:20251214 164436: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-17 16:05:51',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281321470933','','','REG FUNZONE2')
20251214 164437 : requested url:/gameverse/idtl/callback_itg.php
20251214 164437 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"pQFdZRX4UcMA8AO6xqWAAVXSIkd7kmeffIRdeOmMIMllnZgK1n7-6PM=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 164437 : mobile encrypted_msisdn:pQFdZRX4UcMA8AO6xqWAAVXSIkd7kmeffIRdeOmMIMllnZgK1n7-6PM=
20251214 164437 : mobile keyword:REG FUNZONE2
20251214 164437 : mobile dr_status:1
20251214 164437 output={"msisdn":"6281316045976"}

20251214 164437 msisdn=6281316045976
20251214 164437 outsideloop msisdn=6281316045976
20251214 164437 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281316045976' order by  id desc limit 1
Query:20251214 164437: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281316045976'
20251214 164438 : requested url:/gameverse/idtl/callback_itg.php
20251214 164438 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"uB-q2qI6h_Dr8ddjP2n7ZjqCvyNf3gp8ogTP6RTxn_pQAORKz-Ha1vw=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 164438 : mobile encrypted_msisdn:uB-q2qI6h_Dr8ddjP2n7ZjqCvyNf3gp8ogTP6RTxn_pQAORKz-Ha1vw=
20251214 164438 : mobile keyword:REG FUNZONE2
20251214 164438 : mobile dr_status:1
20251214 164438 output={"msisdn":"6281318812988"}

20251214 164438 msisdn=6281318812988
20251214 164438 outsideloop msisdn=6281318812988
20251214 164438 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281318812988' order by  id desc limit 1
Query:20251214 164438: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281318812988'
Query:20251214 164438: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-14 14:48:35',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281316045976','','','REG FUNZONE2')
Query:20251214 164438: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-17 15:35:39',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281318812988','','','REG FUNZONE2')
20251214 165947 : requested url:/gameverse/idtl/callback_itg.php
20251214 165947 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"IhSHphlxMijHBbdkqwoeNA6E24qgLzxL4y5TCu1B0mxPr3NOGAUZ0G4=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 165947 : mobile encrypted_msisdn:IhSHphlxMijHBbdkqwoeNA6E24qgLzxL4y5TCu1B0mxPr3NOGAUZ0G4=
20251214 165947 : mobile keyword:REG FUNZONE2
20251214 165947 : mobile dr_status:1
20251214 165947 output={"msisdn":"6281393022256"}

20251214 165947 msisdn=6281393022256
20251214 165947 outsideloop msisdn=6281393022256
20251214 165947 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281393022256' order by  id desc limit 1
Query:20251214 165947: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281393022256'
Query:20251214 165947: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-17 22:35:24',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281393022256','','','REG FUNZONE2')
20251214 170156 : requested url:/gameverse/idtl/callback_itg.php
20251214 170156 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"T4-ADOgL7XdFuitanJJAzM4yzVAx_DvxOspf2ol4KgaEa7adTK5jwWU=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 170156 : mobile encrypted_msisdn:T4-ADOgL7XdFuitanJJAzM4yzVAx_DvxOspf2ol4KgaEa7adTK5jwWU=
20251214 170156 : mobile keyword:REG FUNZONE2
20251214 170156 : mobile dr_status:1
20251214 170156 output={"msisdn":"6285136209838"}

20251214 170156 msisdn=6285136209838
20251214 170156 outsideloop msisdn=6285136209838
20251214 170156 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285136209838' order by  id desc limit 1
Query:20251214 170156: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285136209838'
Query:20251214 170156: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-10-02 20:46:44',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285136209838','','','REG FUNZONE2')
20251214 184216 : requested url:/gameverse/idtl/callback_itg.php
20251214 184216 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"yQ0hu1ySVEUol8rjiE1CHXrXFAEA-p3dAXe5HbU9nJeHzSgoEmB6kg0=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 184216 : mobile encrypted_msisdn:yQ0hu1ySVEUol8rjiE1CHXrXFAEA-p3dAXe5HbU9nJeHzSgoEmB6kg0=
20251214 184216 : mobile keyword:UNREG FUNZONE2
20251214 184216 : mobile dr_status:1
20251214 184216 output={"msisdn":"6285245502662"}

20251214 184216 msisdn=6285245502662
20251214 184216 outsideloop msisdn=6285245502662
20251214 184216 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285245502662' order by  id desc limit 1
Querydel:20251214 184216: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-12 16:00:16',now(),'6285245502662','UNREG FUNZONE2')
Queryt:20251214 184216: delete from tbl_subscription_Telkomsel_id where msisdn='6285245502662'
20251214 184436 : requested url:/gameverse/idtl/callback_itg.php
20251214 184436 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"JdouPyFET4DYvOkq1imo1Osq2HypXRnBiY_W8PfondDg2DEaJUHrAxw=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 184436 : mobile encrypted_msisdn:JdouPyFET4DYvOkq1imo1Osq2HypXRnBiY_W8PfondDg2DEaJUHrAxw=
20251214 184436 : mobile keyword:UNREG FUNZONE2
20251214 184436 : mobile dr_status:1
20251214 184436 output={"msisdn":"6281263645100"}

20251214 184436 msisdn=6281263645100
20251214 184436 outsideloop msisdn=6281263645100
20251214 184436 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281263645100' order by  id desc limit 1
Querydel:20251214 184436: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-09-15 08:09:55',now(),'6281263645100','UNREG FUNZONE2')
Queryt:20251214 184436: delete from tbl_subscription_Telkomsel_id where msisdn='6281263645100'
20251214 185206 : requested url:/gameverse/idtl/callback_itg.php
20251214 185206 : json:{"adnetid":"96014","clickid":"251214185202000000","dr_status":"0","encrypted_msisdn":"XN7XqQ4bS8Kp4AyACDyXDXooBl6c_YIDFTvAmJLgYCkuJEkG_76iah8=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1765718522606661689"}
20251214 185206 : mobile encrypted_msisdn:XN7XqQ4bS8Kp4AyACDyXDXooBl6c_YIDFTvAmJLgYCkuJEkG_76iah8=
20251214 185206 : mobile keyword:REG FUNZONE2
20251214 185206 : mobile dr_status:0
20251214 185206 output={"msisdn":"6285381901104"}

20251214 185206 msisdn=6285381901104
20251214 185206 outsideloop msisdn=6285381901104
20251214 185206 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214185202000000' order by id desc limit 1
20251214 185206 subid=693eb9f9334795034406e30a
20251214 185206 pubid=2
Query:20251214 185206: 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,'2','693eb9f9334795034406e30a','5','LOW-BL','0','subs','6285381901104','251214185202000000','WEB1765718522606661689','REG FUNZONE2')
Query:20251214 185206: 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,'2','693eb9f9334795034406e30a','5','LOW-BL','0','subs','6285381901104','251214185202000000','WEB1765718522606661689','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693eb9f9334795034406e30a&campid=5:251214185208000000: 20251214 061208 output:200
20251214 192536 : requested url:/gameverse/idtl/callback_itg.php
20251214 192536 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"7E3IZ78WtY76RWUAIEk7FkPj9QhcrxxSk6kpkIn70uh7YAnYKNR_GaU=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 192536 : mobile encrypted_msisdn:7E3IZ78WtY76RWUAIEk7FkPj9QhcrxxSk6kpkIn70uh7YAnYKNR_GaU=
20251214 192536 : mobile keyword:UNREG FUNZONE2
20251214 192536 : mobile dr_status:1
20251214 192536 output={"msisdn":"6282258960068"}

20251214 192536 msisdn=6282258960068
20251214 192536 outsideloop msisdn=6282258960068
20251214 192536 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282258960068' order by  id desc limit 1
Querydel:20251214 192536: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-23 08:59:07',now(),'6282258960068','UNREG FUNZONE2')
Queryt:20251214 192536: delete from tbl_subscription_Telkomsel_id where msisdn='6282258960068'
20251214 193109 : requested url:/gameverse/idtl/callback_itg.php
20251214 193109 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"BlYfUMLtdWTDG6ihrx7rkKAI_GwSC0effDqPAMMivJoRgzSse5mCaME=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 193109 : mobile encrypted_msisdn:BlYfUMLtdWTDG6ihrx7rkKAI_GwSC0effDqPAMMivJoRgzSse5mCaME=
20251214 193109 : mobile keyword:UNREG FUNZONE2
20251214 193109 : mobile dr_status:1
20251214 193109 output={"msisdn":"6281239709723"}

20251214 193109 msisdn=6281239709723
20251214 193109 outsideloop msisdn=6281239709723
20251214 193109 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281239709723' order by  id desc limit 1
Querydel:20251214 193109: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-08-28 10:10:09',now(),'6281239709723','UNREG FUNZONE2')
Queryt:20251214 193109: delete from tbl_subscription_Telkomsel_id where msisdn='6281239709723'
20251214 195026 : requested url:/gameverse/idtl/callback_itg.php
20251214 195026 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"V6uWXzcQgxZw2qxqnGGdNV_jOpyLmNEiRWfLrjDWnR4PqROIWexgftk=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 195026 : mobile encrypted_msisdn:V6uWXzcQgxZw2qxqnGGdNV_jOpyLmNEiRWfLrjDWnR4PqROIWexgftk=
20251214 195026 : mobile keyword:UNREG FUNZONE2
20251214 195026 : mobile dr_status:1
20251214 195026 output={"msisdn":"6281316195401"}

20251214 195026 msisdn=6281316195401
20251214 195026 outsideloop msisdn=6281316195401
20251214 195026 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281316195401' order by  id desc limit 1
Querydel:20251214 195026: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-08-24 13:19:25',now(),'6281316195401','UNREG FUNZONE2')
Queryt:20251214 195026: delete from tbl_subscription_Telkomsel_id where msisdn='6281316195401'
20251214 195913 : requested url:/gameverse/idtl/callback_itg.php
20251214 195913 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"idWudoIMrOO60a3opMtVm2eOl8eLvf1DEbmxP47h2Y8NcpkRNCdBRb8=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 195913 : mobile encrypted_msisdn:idWudoIMrOO60a3opMtVm2eOl8eLvf1DEbmxP47h2Y8NcpkRNCdBRb8=
20251214 195913 : mobile keyword:UNREG FUNZONE2
20251214 195913 : mobile dr_status:1
20251214 195913 output={"msisdn":"6282164414995"}

20251214 195913 msisdn=6282164414995
20251214 195913 outsideloop msisdn=6282164414995
20251214 195913 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282164414995' order by  id desc limit 1
Querydel:20251214 195913: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-14 16:00:18',now(),'6282164414995','UNREG FUNZONE2')
Queryt:20251214 195913: delete from tbl_subscription_Telkomsel_id where msisdn='6282164414995'
20251214 200718 : requested url:/gameverse/idtl/callback_itg.php
20251214 200718 : json:{"adnetid":"96014","clickid":"251214200714000000","dr_status":"0","encrypted_msisdn":"EVw0o70ARYnTa3XfdUJygU215bDCwr61U11w0rHLAuGOnVSwDnJLgC8=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17657230351829903347"}
20251214 200718 : mobile encrypted_msisdn:EVw0o70ARYnTa3XfdUJygU215bDCwr61U11w0rHLAuGOnVSwDnJLgC8=
20251214 200718 : mobile keyword:REG FUNZONE2
20251214 200718 : mobile dr_status:0
20251214 200718 output={"msisdn":"6285177825244"}

20251214 200718 msisdn=6285177825244
20251214 200718 outsideloop msisdn=6285177825244
20251214 200718 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214200714000000' order by id desc limit 1
20251214 200718 subid=693ecb992efbbd034add2ab4
20251214 200718 pubid=2
Query:20251214 200718: 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,'2','693ecb992efbbd034add2ab4','5','LOW-BL','0','subs','6285177825244','251214200714000000','WEB17657230351829903347','REG FUNZONE2')
Query:20251214 200718: 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,'2','693ecb992efbbd034add2ab4','5','LOW-BL','0','subs','6285177825244','251214200714000000','WEB17657230351829903347','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693ecb992efbbd034add2ab4&campid=5:251214200720000000: 20251214 081220 output:200
20251214 203536 : requested url:/gameverse/idtl/callback_itg.php
20251214 203536 : json:{"adnetid":"96014","clickid":"251214203527000000","dr_status":"0","encrypted_msisdn":"tUEyJ9HQ7_Bpxb0iSyb2IdygrdMmNq-76pWb5QRnK3JiO71NaovoRdQ=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17657247281874268906"}
20251214 203536 : mobile encrypted_msisdn:tUEyJ9HQ7_Bpxb0iSyb2IdygrdMmNq-76pWb5QRnK3JiO71NaovoRdQ=
20251214 203536 : mobile keyword:REG FUNZONE2
20251214 203536 : mobile dr_status:0
20251214 203536 output={"msisdn":"6285184042839"}

20251214 203536 msisdn=6285184042839
20251214 203536 outsideloop msisdn=6285184042839
20251214 203536 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214203527000000' order by id desc limit 1
20251214 203536 subid=693ed236b9ab09034481b046
20251214 203536 pubid=2
Query:20251214 203536: 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,'2','693ed236b9ab09034481b046','5','LOW-BL','0','subs','6285184042839','251214203527000000','WEB17657247281874268906','REG FUNZONE2')
Query:20251214 203536: 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,'2','693ed236b9ab09034481b046','5','LOW-BL','0','subs','6285184042839','251214203527000000','WEB17657247281874268906','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693ed236b9ab09034481b046&campid=5:251214203538000000: 20251214 081238 output:200
20251214 204033 : requested url:/gameverse/idtl/callback_itg.php
20251214 204033 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"ROEM1nErvaYTQSTuVtJIPxVYbKkT_72nZKLWfbZqPMsaK4PJzCxEe-o=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 204033 : mobile encrypted_msisdn:ROEM1nErvaYTQSTuVtJIPxVYbKkT_72nZKLWfbZqPMsaK4PJzCxEe-o=
20251214 204033 : mobile keyword:REG FUNZONE2
20251214 204033 : mobile dr_status:1
20251214 204033 output={"msisdn":"6282181382716"}

20251214 204033 msisdn=6282181382716
20251214 204033 outsideloop msisdn=6282181382716
20251214 204033 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282181382716' order by  id desc limit 1
Query:20251214 204033: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282181382716'
Query:20251214 204033: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-31 15:29:11',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282181382716','','','REG FUNZONE2')
20251214 204209 : requested url:/gameverse/idtl/callback_itg.php
20251214 204209 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"1MhMe8-nVJAc8LscBwqaP7W5Xoba0uGWjQMYHha7AFpi2uM-I2FjihI=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 204209 : mobile encrypted_msisdn:1MhMe8-nVJAc8LscBwqaP7W5Xoba0uGWjQMYHha7AFpi2uM-I2FjihI=
20251214 204209 : mobile keyword:REG FUNZONE2
20251214 204209 : mobile dr_status:1
20251214 204209 output={"msisdn":"6281313717038"}

20251214 204209 msisdn=6281313717038
20251214 204209 outsideloop msisdn=6281313717038
20251214 204209 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281313717038' order by  id desc limit 1
Query:20251214 204209: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281313717038'
Query:20251214 204209: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-14 20:53:00',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281313717038','','','REG FUNZONE2')
20251214 204214 : requested url:/gameverse/idtl/callback_itg.php
20251214 204214 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"zzMQ9Iic8axRZjQSJlI0pNdOWpQDiMCCC6RHlz1AWsGNTY0DZyG48Is=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 204214 : mobile encrypted_msisdn:zzMQ9Iic8axRZjQSJlI0pNdOWpQDiMCCC6RHlz1AWsGNTY0DZyG48Is=
20251214 204214 : mobile keyword:REG FUNZONE2
20251214 204214 : mobile dr_status:1
20251214 204214 output={"msisdn":"6281315785820"}

20251214 204214 msisdn=6281315785820
20251214 204214 outsideloop msisdn=6281315785820
20251214 204214 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281315785820' order by  id desc limit 1
Query:20251214 204214: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281315785820'
Query:20251214 204214: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-11-17 18:26:53',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281315785820','','','REG FUNZONE2')
20251214 204218 : requested url:/gameverse/idtl/callback_itg.php
20251214 204218 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"8UVhQu8I66rO00qv-bnRudxvOss581IEaa9Hm_bYKufpfX4nGIGMbk0=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 204218 : mobile encrypted_msisdn:8UVhQu8I66rO00qv-bnRudxvOss581IEaa9Hm_bYKufpfX4nGIGMbk0=
20251214 204218 : mobile keyword:REG FUNZONE2
20251214 204218 : mobile dr_status:1
20251214 204218 output={"msisdn":"6282281691052"}

20251214 204218 msisdn=6282281691052
20251214 204218 outsideloop msisdn=6282281691052
20251214 204218 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282281691052' order by  id desc limit 1
Query:20251214 204218: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282281691052'
Query:20251214 204219: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-12-11 17:04:07',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282281691052','','','REG FUNZONE2')
20251214 205838 : requested url:/gameverse/idtl/callback_itg.php
20251214 205838 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"tQrpuQaWuqDJMijm34slhgOvTXsaC9HXaYqyTakVtVZ8xCBv8iU0Lmg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 205838 : mobile encrypted_msisdn:tQrpuQaWuqDJMijm34slhgOvTXsaC9HXaYqyTakVtVZ8xCBv8iU0Lmg=
20251214 205838 : mobile keyword:REG FUNZONE2
20251214 205838 : mobile dr_status:1
20251214 205838 output={"msisdn":"6281260664381"}

20251214 205838 msisdn=6281260664381
20251214 205838 outsideloop msisdn=6281260664381
20251214 205838 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281260664381' order by  id desc limit 1
Query:20251214 205838: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281260664381'
Query:20251214 205838: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-10-11 10:23:51',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281260664381','','','REG FUNZONE2')
20251214 205936 : requested url:/gameverse/idtl/callback_itg.php
20251214 205936 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"68Bo5f6OShB1K6mjj86mdPiJ0Z4Vq3lTp2FVURZvivM82znexSnAyvc=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 205936 : mobile encrypted_msisdn:68Bo5f6OShB1K6mjj86mdPiJ0Z4Vq3lTp2FVURZvivM82znexSnAyvc=
20251214 205936 : mobile keyword:REG FUNZONE2
20251214 205936 : mobile dr_status:1
20251214 205936 output={"msisdn":"6281320313522"}

20251214 205936 msisdn=6281320313522
20251214 205936 outsideloop msisdn=6281320313522
20251214 205936 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281320313522' order by  id desc limit 1
Query:20251214 205936: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281320313522'
Query:20251214 205936: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-09-23 05:58:32',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281320313522','','','REG FUNZONE2')
20251214 211259 : requested url:/gameverse/idtl/callback_itg.php
20251214 211259 : json:{"adnetid":"96014","clickid":"251214211145000000","dr_status":"0","encrypted_msisdn":"HUdhj2NIwOunJpg4_AMZFS1rFc5Zugsl4a1WF7TNl9XwgjTchsgWhxY=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17657269171826362637"}
20251214 211259 : mobile encrypted_msisdn:HUdhj2NIwOunJpg4_AMZFS1rFc5Zugsl4a1WF7TNl9XwgjTchsgWhxY=
20251214 211259 : mobile keyword:REG FUNZONE2
20251214 211259 : mobile dr_status:0
20251214 211259 output={"msisdn":"6281353043475"}

20251214 211259 msisdn=6281353043475
20251214 211259 outsideloop msisdn=6281353043475
20251214 211259 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214211145000000' order by id desc limit 1
20251214 211259 subid=693edab88abcec035340fe57
20251214 211259 pubid=2
Query:20251214 211259: 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,'2','693edab88abcec035340fe57','5','LOW-BL','0','subs','6281353043475','251214211145000000','WEB17657269171826362637','REG FUNZONE2')
Query:20251214 211259: 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,'2','693edab88abcec035340fe57','5','LOW-BL','0','subs','6281353043475','251214211145000000','WEB17657269171826362637','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693edab88abcec035340fe57&campid=5:251214211259000000: 20251214 091259 output:200
20251214 212859 : requested url:/gameverse/idtl/callback_itg.php
20251214 212859 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"gxuF-gkHtXPypcos3VP867h67Fv91RYXMsB9CyEGFhMPwAGJhy_vR18=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 212859 : mobile encrypted_msisdn:gxuF-gkHtXPypcos3VP867h67Fv91RYXMsB9CyEGFhMPwAGJhy_vR18=
20251214 212859 : mobile keyword:REG FUNZONE2
20251214 212859 : mobile dr_status:1
20251214 212859 output={"msisdn":"6282173230748"}

20251214 212859 msisdn=6282173230748
20251214 212859 outsideloop msisdn=6282173230748
20251214 212859 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282173230748' order by  id desc limit 1
Query:20251214 212859: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282173230748'
Query:20251214 212859: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-28 05:29:45',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282173230748','','','REG FUNZONE2')
20251214 213157 : requested url:/gameverse/idtl/callback_itg.php
20251214 213157 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"_9cvXwD-Vz26U7_12GoJCNLZLMGJ67DMyfIABkXu64Fp2WWCZKYE7_E=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 213157 : mobile encrypted_msisdn:_9cvXwD-Vz26U7_12GoJCNLZLMGJ67DMyfIABkXu64Fp2WWCZKYE7_E=
20251214 213157 : mobile keyword:REG FUNZONE2
20251214 213157 : mobile dr_status:1
20251214 213157 output={"msisdn":"6285195904300"}

20251214 213157 msisdn=6285195904300
20251214 213157 outsideloop msisdn=6285195904300
20251214 213157 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6285195904300' order by  id desc limit 1
Query:20251214 213157: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285195904300'
Query:20251214 213157: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-10-06 15:51:14',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285195904300','','','REG FUNZONE2')
20251214 213818 : requested url:/gameverse/idtl/callback_itg.php
20251214 213818 : json:{"adnetid":"96014","clickid":"251214213815000000","dr_status":"0","encrypted_msisdn":"EJdF5qEEPcqKZwmxhIQv3flDZ23S6vRy6Wx5oi1_ef1LV7K2VjMI7FU=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1765728496268763926"}
20251214 213818 : mobile encrypted_msisdn:EJdF5qEEPcqKZwmxhIQv3flDZ23S6vRy6Wx5oi1_ef1LV7K2VjMI7FU=
20251214 213818 : mobile keyword:REG FUNZONE2
20251214 213818 : mobile dr_status:0
20251214 213818 output={"msisdn":"6282127837638"}

20251214 213818 msisdn=6282127837638
20251214 213818 outsideloop msisdn=6282127837638
20251214 213818 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214213815000000' order by id desc limit 1
20251214 213818 subid=693ee0ee0b7cad0348ecdc89
20251214 213818 pubid=2
Query:20251214 213818: 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,'2','693ee0ee0b7cad0348ecdc89','5','LOW-BL','0','subs','6282127837638','251214213815000000','WEB1765728496268763926','REG FUNZONE2')
Query:20251214 213818: 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,'2','693ee0ee0b7cad0348ecdc89','5','LOW-BL','0','subs','6282127837638','251214213815000000','WEB1765728496268763926','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693ee0ee0b7cad0348ecdc89&campid=5:251214213819000000: 20251214 091219 output:200
20251214 215521 : requested url:/gameverse/idtl/callback_itg.php
20251214 215521 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"h9FwAYWKypHfxV4NHvGa-JTrQ2v4mea_8M3n8Asb2dTuk-Alr10Zmg8=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 215521 : mobile encrypted_msisdn:h9FwAYWKypHfxV4NHvGa-JTrQ2v4mea_8M3n8Asb2dTuk-Alr10Zmg8=
20251214 215521 : mobile keyword:REG FUNZONE2
20251214 215521 : mobile dr_status:1
20251214 215521 output={"msisdn":"6281367027770"}

20251214 215521 msisdn=6281367027770
20251214 215521 outsideloop msisdn=6281367027770
20251214 215521 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281367027770' order by  id desc limit 1
Query:20251214 215521: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281367027770'
Query:20251214 215521: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-10-01 06:40:57',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281367027770','','','REG FUNZONE2')
20251214 215653 : requested url:/gameverse/idtl/callback_itg.php
20251214 215653 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"-UTVCS7uBL2ODO-LIpNwUam8aENhZgQ_nl9mqocJ0WaAeWhfp-Vgz1A=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 215653 : mobile encrypted_msisdn:-UTVCS7uBL2ODO-LIpNwUam8aENhZgQ_nl9mqocJ0WaAeWhfp-Vgz1A=
20251214 215653 : mobile keyword:UNREG FUNZONE2
20251214 215653 : mobile dr_status:1
20251214 215653 output={"msisdn":"6282127837638"}

20251214 215653 msisdn=6282127837638
20251214 215653 outsideloop msisdn=6282127837638
20251214 215653 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282127837638' order by  id desc limit 1
Querydel:20251214 215653: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-12-14 21:38:18',now(),'6282127837638','UNREG FUNZONE2')
Queryt:20251214 215653: delete from tbl_subscription_Telkomsel_id where msisdn='6282127837638'
20251214 215750 : requested url:/gameverse/idtl/callback_itg.php
20251214 215750 : json:{"adnetid":"96014","clickid":"251214215741000000","dr_status":"0","encrypted_msisdn":"arExh0JHZRtKD0pzUHkvZLfXHsBiH9nbRK0OGysvNMn0d4-hTMBrWsc=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17657296621753409495"}
20251214 215750 : mobile encrypted_msisdn:arExh0JHZRtKD0pzUHkvZLfXHsBiH9nbRK0OGysvNMn0d4-hTMBrWsc=
20251214 215750 : mobile keyword:REG FUNZONE2
20251214 215750 : mobile dr_status:0
20251214 215750 output={"msisdn":"6282280744655"}

20251214 215750 msisdn=6282280744655
20251214 215750 outsideloop msisdn=6282280744655
20251214 215750 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214215741000000' order by id desc limit 1
20251214 215750 subid=693ee57c3f5e8b0348c94ba0
20251214 215750 pubid=2
Query:20251214 215750: 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,'2','693ee57c3f5e8b0348c94ba0','5','LOW-BL','0','subs','6282280744655','251214215741000000','WEB17657296621753409495','REG FUNZONE2')
Query:20251214 215750: 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,'2','693ee57c3f5e8b0348c94ba0','5','LOW-BL','0','subs','6282280744655','251214215741000000','WEB17657296621753409495','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693ee57c3f5e8b0348c94ba0&campid=5:251214215750000000: 20251214 091250 output:200
20251214 220448 : requested url:/gameverse/idtl/callback_itg.php
20251214 220448 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Tsffp8C-sVqg6R45LSMpMBMH4KAFu4G7vBMePUoIrfcf0FaIHf1zkw==","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 220448 : mobile encrypted_msisdn:Tsffp8C-sVqg6R45LSMpMBMH4KAFu4G7vBMePUoIrfcf0FaIHf1zkw==
20251214 220448 : mobile keyword:REG FUNZONE2
20251214 220448 : mobile dr_status:1
20251214 220448 output={"msisdn":"628131585092"}

20251214 220448 msisdn=628131585092
20251214 220448 outsideloop msisdn=628131585092
20251214 220448 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='628131585092' order by  id desc limit 1
Query:20251214 220448: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='628131585092'
Query:20251214 220448: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-20 09:52:56',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','628131585092','','','REG FUNZONE2')
20251214 220503 : requested url:/gameverse/idtl/callback_itg.php
20251214 220503 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"L3ICIvQRLRIS3EVZ2pHRMa6ponk2gzyBEC2uIhASKTKqxA9MxFb84YE=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""}
20251214 220503 : mobile encrypted_msisdn:L3ICIvQRLRIS3EVZ2pHRMa6ponk2gzyBEC2uIhASKTKqxA9MxFb84YE=
20251214 220503 : mobile keyword:REG FUNZONE2
20251214 220503 : mobile dr_status:1
20251214 220503 output={"msisdn":"6282172029730"}

20251214 220503 msisdn=6282172029730
20251214 220503 outsideloop msisdn=6282172029730
20251214 220503 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6282172029730' order by  id desc limit 1
Query:20251214 220503: update  tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282172029730'
Query:20251214 220503: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) 
			values ('2025-08-20 22:02:26',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282172029730','','','REG FUNZONE2')
20251214 233459 : requested url:/gameverse/idtl/callback_itg.php
20251214 233459 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"miWSiR_0j9pnm6kh3ekdZpjMed4zxXN1WCWnrX-fyFFN0ap14ph3lHQ=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""}
20251214 233459 : mobile encrypted_msisdn:miWSiR_0j9pnm6kh3ekdZpjMed4zxXN1WCWnrX-fyFFN0ap14ph3lHQ=
20251214 233459 : mobile keyword:UNREG FUNZONE2
20251214 233459 : mobile dr_status:1
20251214 233459 output={"msisdn":"6281393081806"}

20251214 233459 msisdn=6281393081806
20251214 233459 outsideloop msisdn=6281393081806
20251214 233459 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281393081806' order by  id desc limit 1
Querydel:20251214 233459: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-10-02 14:11:16',now(),'6281393081806','UNREG FUNZONE2')
Queryt:20251214 233459: delete from tbl_subscription_Telkomsel_id where msisdn='6281393081806'
20251214 234055 : requested url:/gameverse/idtl/callback_itg.php
20251214 234055 : json:{"adnetid":"96014","clickid":"251214234051000000","dr_status":"0","encrypted_msisdn":"rIDA_2Rq8aDqcKF8MZrnhWH2mzb5KawelOhECGd69pEO0yBo1ZH1Zac=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1765735851271669066"}
20251214 234055 : mobile encrypted_msisdn:rIDA_2Rq8aDqcKF8MZrnhWH2mzb5KawelOhECGd69pEO0yBo1ZH1Zac=
20251214 234055 : mobile keyword:REG FUNZONE2
20251214 234055 : mobile dr_status:0
20251214 234055 output={"msisdn":"6282249150740"}

20251214 234055 msisdn=6282249150740
20251214 234055 outsideloop msisdn=6282249150740
20251214 234055 : Querypub:select  pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251214234051000000' order by id desc limit 1
20251214 234055 subid=693efdaa3f5e8b0348d95e4d
20251214 234055 pubid=2
Query:20251214 234055: 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,'2','693efdaa3f5e8b0348d95e4d','5','LOW-BL','0','subs','6282249150740','251214234051000000','WEB1765735851271669066','REG FUNZONE2')
Query:20251214 234055: 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,'2','693efdaa3f5e8b0348d95e4d','5','LOW-BL','0','subs','6282249150740','251214234051000000','WEB1765735851271669066','REG FUNZONE2')
sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=693efdaa3f5e8b0348d95e4d&campid=5:251214234057000000: 20251214 111257 output:200