20251108 014413 : requested url:/gameverse/idtl/callback_itg.php 20251108 014413 : json:{"adnetid":"96014","clickid":"251108014359000000","dr_status":"0","encrypted_msisdn":"ucqrv8n4wf7HVAsBRtz4gWfhQ_f_W3rJJmuDlQ3baNgV7z0CmOFgazs=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625464451796224565"} 20251108 014413 : mobile encrypted_msisdn:ucqrv8n4wf7HVAsBRtz4gWfhQ_f_W3rJJmuDlQ3baNgV7z0CmOFgazs= 20251108 014413 : mobile keyword:REG FUNZONE2 20251108 014413 : mobile dr_status:0 20251108 014413 output={"msisdn":"6285314364394"} 20251108 014413 msisdn=6285314364394 20251108 014413 outsideloop msisdn=6285314364394 20251108 014413 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108014359000000' order by id desc limit 1 20251108 014413 subid=690e5306509f8b03567957e1 20251108 014413 pubid=2 Query:20251108 014413: 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','690e5306509f8b03567957e1','5','LOW-BL','0','subs','6285314364394','251108014359000000','WEB17625464451796224565','REG FUNZONE2') Query:20251108 014413: 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','690e5306509f8b03567957e1','5','LOW-BL','0','subs','6285314364394','251108014359000000','WEB17625464451796224565','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690e5306509f8b03567957e1&campid=5:251108014413000000: 20251108 011113 output:200 20251108 032236 : requested url:/gameverse/idtl/callback_itg.php 20251108 032236 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"JkbP-VgAj-pZR_QFGYMddvOfa9K7o-_eWhcCZY9IE2_qePXQg94-Z5g=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 032236 : mobile encrypted_msisdn:JkbP-VgAj-pZR_QFGYMddvOfa9K7o-_eWhcCZY9IE2_qePXQg94-Z5g= 20251108 032236 : mobile keyword:UNREG FUNZONE2 20251108 032236 : mobile dr_status:1 20251108 032236 output={"msisdn":"6282218123296"} 20251108 032236 msisdn=6282218123296 20251108 032236 outsideloop msisdn=6282218123296 20251108 032236 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282218123296' order by id desc limit 1 Querydel:20251108 032236: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-07 13:57:19',now(),'6282218123296','UNREG FUNZONE2') Queryt:20251108 032236: delete from tbl_subscription_Telkomsel_id where msisdn='6282218123296' 20251108 032656 : requested url:/gameverse/idtl/callback_itg.php 20251108 032656 : json:{"adnetid":"96014","clickid":"251108032651000000","dr_status":"0","encrypted_msisdn":"FQAZ8LavYsuoPk-ZMQUqfQQ5IGahdXb9Hvtq-S0-n9IOnzNtk1TzZOc=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625526111245664913"} 20251108 032656 : mobile encrypted_msisdn:FQAZ8LavYsuoPk-ZMQUqfQQ5IGahdXb9Hvtq-S0-n9IOnzNtk1TzZOc= 20251108 032656 : mobile keyword:REG FUNZONE2 20251108 032656 : mobile dr_status:0 20251108 032656 output={"msisdn":"6285167650449"} 20251108 032656 msisdn=6285167650449 20251108 032656 outsideloop msisdn=6285167650449 20251108 032656 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108032651000000' order by id desc limit 1 20251108 032656 subid=690e6b2216b94f0345275842 20251108 032656 pubid=2 Query:20251108 032656: 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','690e6b2216b94f0345275842','5','LOW-BL','0','subs','6285167650449','251108032651000000','WEB17625526111245664913','REG FUNZONE2') Query:20251108 032656: 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','690e6b2216b94f0345275842','5','LOW-BL','0','subs','6285167650449','251108032651000000','WEB17625526111245664913','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690e6b2216b94f0345275842&campid=5:251108032657000000: 20251108 031157 output:200 20251108 034111 : requested url:/gameverse/idtl/callback_itg.php 20251108 034111 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"hlslv38nfn1Ajjsi16U5GVp88CzeNRnZ-cRyLHv30XCn7PZ7j9LPPFo=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 034111 : mobile encrypted_msisdn:hlslv38nfn1Ajjsi16U5GVp88CzeNRnZ-cRyLHv30XCn7PZ7j9LPPFo= 20251108 034111 : mobile keyword:UNREG FUNZONE2 20251108 034111 : mobile dr_status:1 20251108 034111 output={"msisdn":"6285314364394"} 20251108 034111 msisdn=6285314364394 20251108 034111 outsideloop msisdn=6285314364394 20251108 034111 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285314364394' order by id desc limit 1 Querydel:20251108 034111: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-08 01:44:13',now(),'6285314364394','UNREG FUNZONE2') Queryt:20251108 034111: delete from tbl_subscription_Telkomsel_id where msisdn='6285314364394' 20251108 035225 : requested url:/gameverse/idtl/callback_itg.php 20251108 035225 : json:{"adnetid":"96014","clickid":"251108035145000000","dr_status":"0","encrypted_msisdn":"8Jp9E9xIXJyoqDsW29fNH7nJ8UUaY0aWS0t5TY-IXz2_LV1yYDYoZQ==","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762554126130433889"} 20251108 035225 : mobile encrypted_msisdn:8Jp9E9xIXJyoqDsW29fNH7nJ8UUaY0aWS0t5TY-IXz2_LV1yYDYoZQ== 20251108 035225 : mobile keyword:REG FUNZONE2 20251108 035225 : mobile dr_status:0 20251108 035225 output={"msisdn":"628132165620"} 20251108 035225 msisdn=628132165620 20251108 035225 outsideloop msisdn=628132165620 20251108 035225 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108035145000000' order by id desc limit 1 20251108 035225 subid=690e70f6509f8b03568ff739 20251108 035225 pubid=2 Query:20251108 035225: 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','690e70f6509f8b03568ff739','5','LOW-BL','0','subs','628132165620','251108035145000000','WEB1762554126130433889','REG FUNZONE2') Query:20251108 035225: 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','690e70f6509f8b03568ff739','5','LOW-BL','0','subs','628132165620','251108035145000000','WEB1762554126130433889','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690e70f6509f8b03568ff739&campid=5:251108035225000000: 20251108 031125 output:200 20251108 041316 : requested url:/gameverse/idtl/callback_itg.php 20251108 041316 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"1gWXeUi6_zrTD-qfa10o6FrotoCiwwalBiJuDE4zl77LgnPVgsOT3RY=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 041316 : mobile encrypted_msisdn:1gWXeUi6_zrTD-qfa10o6FrotoCiwwalBiJuDE4zl77LgnPVgsOT3RY= 20251108 041316 : mobile keyword:REG FUNZONE2 20251108 041316 : mobile dr_status:1 20251108 041316 output={"msisdn":"6282227274833"} 20251108 041316 msisdn=6282227274833 20251108 041316 outsideloop msisdn=6282227274833 20251108 041316 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282227274833' order by id desc limit 1 Query:20251108 041316: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282227274833' Query:20251108 041316: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-30 16:51:12',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282227274833','','','REG FUNZONE2') 20251108 052718 : requested url:/gameverse/idtl/callback_itg.php 20251108 052718 : json:{"adnetid":"96014","clickid":"251108052707000000","dr_status":"0","encrypted_msisdn":"ALYolWvUeZCaynTySzT1AE-6dGBHpXwYQEAtLq-9xT6LOJJUOPmASGg=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762559829835755784"} 20251108 052718 : mobile encrypted_msisdn:ALYolWvUeZCaynTySzT1AE-6dGBHpXwYQEAtLq-9xT6LOJJUOPmASGg= 20251108 052718 : mobile keyword:REG FUNZONE2 20251108 052718 : mobile dr_status:0 20251108 052718 output={"msisdn":"6282233135583"} 20251108 052718 msisdn=6282233135583 20251108 052718 outsideloop msisdn=6282233135583 20251108 052718 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108052707000000' order by id desc limit 1 20251108 052718 subid=690e87512cac8f033f658b4e 20251108 052718 pubid=2 Query:20251108 052718: 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','690e87512cac8f033f658b4e','5','LOW-BL','0','subs','6282233135583','251108052707000000','WEB1762559829835755784','REG FUNZONE2') Query:20251108 052718: 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','690e87512cac8f033f658b4e','5','LOW-BL','0','subs','6282233135583','251108052707000000','WEB1762559829835755784','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690e87512cac8f033f658b4e&campid=5:251108052721000000: 20251108 051121 output:200 20251108 063833 : requested url:/gameverse/idtl/callback_itg.php 20251108 063833 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"pYP3BP6Ka5y20ozVoyRgC-MhRbGNuo_B5KIDdggcrOqOYHoioJBCMgQ=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 063833 : mobile encrypted_msisdn:pYP3BP6Ka5y20ozVoyRgC-MhRbGNuo_B5KIDdggcrOqOYHoioJBCMgQ= 20251108 063833 : mobile keyword:UNREG FUNZONE2 20251108 063833 : mobile dr_status:1 20251108 063833 output={"msisdn":"6285211179723"} 20251108 063833 msisdn=6285211179723 20251108 063833 outsideloop msisdn=6285211179723 20251108 063833 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285211179723' order by id desc limit 1 Querydel:20251108 063833: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-08-10 19:58:57',now(),'6285211179723','UNREG FUNZONE2') Queryt:20251108 063833: delete from tbl_subscription_Telkomsel_id where msisdn='6285211179723' 20251108 064107 : requested url:/gameverse/idtl/callback_itg.php 20251108 064107 : json:{"adnetid":"96014","clickid":"251108064100000000","dr_status":"0","encrypted_msisdn":"IbBjaNiHaap-Rog-BDzaFKWpzuYfLVCMZb3GOy8zyhYmykoI43SlpH8=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762564261496684591"} 20251108 064107 : mobile encrypted_msisdn:IbBjaNiHaap-Rog-BDzaFKWpzuYfLVCMZb3GOy8zyhYmykoI43SlpH8= 20251108 064107 : mobile keyword:REG FUNZONE2 20251108 064107 : mobile dr_status:0 20251108 064107 output={"msisdn":"6285198021723"} 20251108 064107 msisdn=6285198021723 20251108 064107 outsideloop msisdn=6285198021723 20251108 064107 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108064100000000' order by id desc limit 1 20251108 064107 subid=690e98a335958e034f9fd354 20251108 064107 pubid=2 Query:20251108 064107: 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','690e98a335958e034f9fd354','5','LOW-BL','0','subs','6285198021723','251108064100000000','WEB1762564261496684591','REG FUNZONE2') Query:20251108 064107: 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','690e98a335958e034f9fd354','5','LOW-BL','0','subs','6285198021723','251108064100000000','WEB1762564261496684591','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690e98a335958e034f9fd354&campid=5:251108064109000000: 20251108 061109 output:200 20251108 070923 : requested url:/gameverse/idtl/callback_itg.php 20251108 070923 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"bcc_FjHSvguX1p1j6lWXt1PQ2e9-Pn6JzJqaEqRq2J9KxflWkMm1xt0=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 070923 : mobile encrypted_msisdn:bcc_FjHSvguX1p1j6lWXt1PQ2e9-Pn6JzJqaEqRq2J9KxflWkMm1xt0= 20251108 070923 : mobile keyword:REG FUNZONE1 20251108 070923 : mobile dr_status:1 20251108 070923 output={"msisdn":"6282313968525"} 20251108 070923 msisdn=6282313968525 20251108 070923 outsideloop msisdn=6282313968525 20251108 070923 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282313968525' order by id desc limit 1 Query:20251108 070923: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282313968525' Query:20251108 070923: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-07-29 17:54:13',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282313968525','','','REG FUNZONE1') 20251108 071344 : requested url:/gameverse/idtl/callback_itg.php 20251108 071344 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"SmxG4g2LG2yjtLaRUna8b9wY7hxPUvoY8ax0fBkpkwCOj7h7RgaUFWo=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071344 : mobile encrypted_msisdn:SmxG4g2LG2yjtLaRUna8b9wY7hxPUvoY8ax0fBkpkwCOj7h7RgaUFWo= 20251108 071344 : mobile keyword:REG FUNZONE2 20251108 071344 : mobile dr_status:1 20251108 071344 output={"msisdn":"6285248162887"} 20251108 071344 msisdn=6285248162887 20251108 071344 outsideloop msisdn=6285248162887 20251108 071344 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285248162887' order by id desc limit 1 Query:20251108 071344: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285248162887' Query:20251108 071344: 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 15:34:25',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285248162887','','','REG FUNZONE2') 20251108 071346 : requested url:/gameverse/idtl/callback_itg.php 20251108 071346 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"vwK_a4lVS8EddAXOykkpq0Teyknym9m_qhwob4AZAGQPw09gNPLwDAE=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071346 : mobile encrypted_msisdn:vwK_a4lVS8EddAXOykkpq0Teyknym9m_qhwob4AZAGQPw09gNPLwDAE= 20251108 071346 : mobile keyword:REG FUNZONE2 20251108 071346 : mobile dr_status:1 20251108 071346 output={"msisdn":"6282147514471"} 20251108 071346 msisdn=6282147514471 20251108 071346 outsideloop msisdn=6282147514471 20251108 071346 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282147514471' order by id desc limit 1 Query:20251108 071346: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282147514471' Query:20251108 071346: 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 02:13:47',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282147514471','','','REG FUNZONE2') 20251108 071351 : requested url:/gameverse/idtl/callback_itg.php 20251108 071351 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"c8rcR01Bgx4eFQDAEfeFT3Ohjqb-xB0VM1pIt8lNwHjUjcZXFKe3DwQ=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071351 : mobile encrypted_msisdn:c8rcR01Bgx4eFQDAEfeFT3Ohjqb-xB0VM1pIt8lNwHjUjcZXFKe3DwQ= 20251108 071351 : mobile keyword:REG FUNZONE2 20251108 071351 : mobile dr_status:1 20251108 071351 output={"msisdn":"6285134188323"} 20251108 071351 msisdn=6285134188323 20251108 071351 outsideloop msisdn=6285134188323 20251108 071351 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285134188323' order by id desc limit 1 Query:20251108 071351: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285134188323' Query:20251108 071351: 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 05:53:49',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285134188323','','','REG FUNZONE2') 20251108 071357 : requested url:/gameverse/idtl/callback_itg.php 20251108 071357 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"psfZeUAkX9DvkoidfeCoBNFqWhWIQ8oPrhsrMuSvA2sUjfdY3Lt9XA==","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071357 : mobile encrypted_msisdn:psfZeUAkX9DvkoidfeCoBNFqWhWIQ8oPrhsrMuSvA2sUjfdY3Lt9XA== 20251108 071357 : mobile keyword:REG FUNZONE2 20251108 071357 : mobile dr_status:1 20251108 071357 output={"msisdn":"628113949029"} 20251108 071357 msisdn=628113949029 20251108 071357 outsideloop msisdn=628113949029 20251108 071357 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='628113949029' order by id desc limit 1 Query:20251108 071357: 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:20251108 071357: 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') 20251108 071357 : requested url:/gameverse/idtl/callback_itg.php 20251108 071357 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"DCYjYHpzLf-Hg6XSToFjG4EkwYebjb1WXIGn_6tpIYM_8UszuJqKX4I=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071357 : mobile encrypted_msisdn:DCYjYHpzLf-Hg6XSToFjG4EkwYebjb1WXIGn_6tpIYM_8UszuJqKX4I= 20251108 071357 : mobile keyword:REG FUNZONE2 20251108 071357 : mobile dr_status:1 20251108 071357 output={"msisdn":"6285215703075"} 20251108 071357 msisdn=6285215703075 20251108 071357 outsideloop msisdn=6285215703075 20251108 071357 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285215703075' order by id desc limit 1 Query:20251108 071357: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285215703075' Query:20251108 071357: 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 03:38:42',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285215703075','','','REG FUNZONE2') 20251108 071409 : requested url:/gameverse/idtl/callback_itg.php 20251108 071409 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"VOn8zxYUW4ZBiJFkVdC6xIe7J5l58dfM4MAQnj6ODgfQbOeN9fZ4WuU=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071409 : mobile encrypted_msisdn:VOn8zxYUW4ZBiJFkVdC6xIe7J5l58dfM4MAQnj6ODgfQbOeN9fZ4WuU= 20251108 071409 : mobile keyword:REG FUNZONE2 20251108 071409 : mobile dr_status:1 20251108 071409 output={"msisdn":"6282284606252"} 20251108 071409 msisdn=6282284606252 20251108 071409 outsideloop msisdn=6282284606252 20251108 071409 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282284606252' order by id desc limit 1 Query:20251108 071409: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282284606252' Query:20251108 071409: 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 07:09:41',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282284606252','','','REG FUNZONE2') 20251108 071444 : requested url:/gameverse/idtl/callback_itg.php 20251108 071444 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"pCDeg18N2ohzEy1hzb5WbqtVMgQc1xJwm6CIHheP5Ho5EU11CT9gBJM=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071444 : mobile encrypted_msisdn:pCDeg18N2ohzEy1hzb5WbqtVMgQc1xJwm6CIHheP5Ho5EU11CT9gBJM= 20251108 071444 : mobile keyword:REG FUNZONE2 20251108 071444 : mobile dr_status:1 20251108 071444 output={"msisdn":"6282145364460"} 20251108 071444 msisdn=6282145364460 20251108 071444 outsideloop msisdn=6282145364460 20251108 071444 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282145364460' order by id desc limit 1 Query:20251108 071444: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282145364460' Query:20251108 071445: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-12 12:25:46',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282145364460','','','REG FUNZONE2') 20251108 071448 : requested url:/gameverse/idtl/callback_itg.php 20251108 071448 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"ClvyaxP2aftxCEPwejJeRbjsxmQxmZsOng_Q1acDWhMmAIyOIl_StLI=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071448 : mobile encrypted_msisdn:ClvyaxP2aftxCEPwejJeRbjsxmQxmZsOng_Q1acDWhMmAIyOIl_StLI= 20251108 071448 : mobile keyword:REG FUNZONE2 20251108 071448 : mobile dr_status:1 20251108 071448 output={"msisdn":"6285298140700"} 20251108 071448 msisdn=6285298140700 20251108 071448 outsideloop msisdn=6285298140700 20251108 071448 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285298140700' order by id desc limit 1 Query:20251108 071448: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285298140700' Query:20251108 071448: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-12 20:27:01',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285298140700','','','REG FUNZONE2') 20251108 071458 : requested url:/gameverse/idtl/callback_itg.php 20251108 071458 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"piWl7XPOFkYbWmr04l1jdgKNoVbchrHRxylHmu9kyhhkMc6Ei44utrg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071458 : mobile encrypted_msisdn:piWl7XPOFkYbWmr04l1jdgKNoVbchrHRxylHmu9kyhhkMc6Ei44utrg= 20251108 071458 : mobile keyword:REG FUNZONE2 20251108 071458 : mobile dr_status:1 20251108 071458 output={"msisdn":"6281324902784"} 20251108 071458 msisdn=6281324902784 20251108 071458 outsideloop msisdn=6281324902784 20251108 071458 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281324902784' order by id desc limit 1 Query:20251108 071458: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281324902784' Query:20251108 071458: 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 04:48:11',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281324902784','','','REG FUNZONE2') 20251108 071502 : requested url:/gameverse/idtl/callback_itg.php 20251108 071502 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"gI4thyV48F8n_-AmG1U9BV7oYZCY65RjCmDbeQFM109S5A3XtzGzpIw=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071502 : mobile encrypted_msisdn:gI4thyV48F8n_-AmG1U9BV7oYZCY65RjCmDbeQFM109S5A3XtzGzpIw= 20251108 071502 : mobile keyword:REG FUNZONE2 20251108 071502 : mobile dr_status:1 20251108 071502 output={"msisdn":"6282372036650"} 20251108 071502 msisdn=6282372036650 20251108 071502 outsideloop msisdn=6282372036650 20251108 071502 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282372036650' order by id desc limit 1 Query:20251108 071502: 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:20251108 071502: 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') 20251108 071518 : requested url:/gameverse/idtl/callback_itg.php 20251108 071518 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"AlcAxiLO1mNQcSzOOlNiASuX3LHL0lBj1GrW4l6ks4WGtScDnU8cLYI=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071518 : mobile encrypted_msisdn:AlcAxiLO1mNQcSzOOlNiASuX3LHL0lBj1GrW4l6ks4WGtScDnU8cLYI= 20251108 071518 : mobile keyword:REG FUNZONE2 20251108 071518 : mobile dr_status:1 20251108 071518 output={"msisdn":"6282245708746"} 20251108 071518 msisdn=6282245708746 20251108 071518 outsideloop msisdn=6282245708746 20251108 071518 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282245708746' order by id desc limit 1 Query:20251108 071518: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282245708746' Query:20251108 071518: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-27 12:59:28',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282245708746','','','REG FUNZONE2') 20251108 071523 : requested url:/gameverse/idtl/callback_itg.php 20251108 071523 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"_SadwUz5ZvUcAvgoYd8pigfJnixxuWulNmAme8tHwNva9t8PCuTwGss=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 071523 : mobile encrypted_msisdn:_SadwUz5ZvUcAvgoYd8pigfJnixxuWulNmAme8tHwNva9t8PCuTwGss= 20251108 071523 : mobile keyword:REG FUNZONE2 20251108 071523 : mobile dr_status:1 20251108 071523 output={"msisdn":"6282315914467"} 20251108 071523 msisdn=6282315914467 20251108 071523 outsideloop msisdn=6282315914467 20251108 071523 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282315914467' order by id desc limit 1 Query:20251108 071523: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282315914467' Query:20251108 071523: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-30 22:18:11',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282315914467','','','REG FUNZONE2') 20251108 072034 : requested url:/gameverse/idtl/callback_itg.php 20251108 072034 : json:{"adnetid":"96014","clickid":"251108072028000000","dr_status":"0","encrypted_msisdn":"6cND49FM8_9Ky1Zu2x8yq728iYo-xHYnp0SYNgaAsAajAjMVJ5NINd8=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625666281172037535"} 20251108 072034 : mobile encrypted_msisdn:6cND49FM8_9Ky1Zu2x8yq728iYo-xHYnp0SYNgaAsAajAjMVJ5NINd8= 20251108 072034 : mobile keyword:REG FUNZONE2 20251108 072034 : mobile dr_status:0 20251108 072034 output={"msisdn":"6282224233867"} 20251108 072034 msisdn=6282224233867 20251108 072034 outsideloop msisdn=6282224233867 20251108 072034 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108072028000000' order by id desc limit 1 20251108 072034 subid=690ea1e320fd5a034195785f 20251108 072034 pubid=2 Query:20251108 072034: 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','690ea1e320fd5a034195785f','5','LOW-BL','0','subs','6282224233867','251108072028000000','WEB17625666281172037535','REG FUNZONE2') Query:20251108 072034: 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','690ea1e320fd5a034195785f','5','LOW-BL','0','subs','6282224233867','251108072028000000','WEB17625666281172037535','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ea1e320fd5a034195785f&campid=5:251108072037000000: 20251108 071137 output:200 20251108 072419 : requested url:/gameverse/idtl/callback_itg.php 20251108 072419 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"WXzo14uCz6q3aI_VGRbrieResxoIUZi-_qlCwHOfhKQG40M-yOzggpk=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 072419 : mobile encrypted_msisdn:WXzo14uCz6q3aI_VGRbrieResxoIUZi-_qlCwHOfhKQG40M-yOzggpk= 20251108 072419 : mobile keyword:REG FUNZONE2 20251108 072419 : mobile dr_status:1 20251108 072419 output={"msisdn":"6281244958948"} 20251108 072419 msisdn=6281244958948 20251108 072419 outsideloop msisdn=6281244958948 20251108 072419 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281244958948' order by id desc limit 1 Query:20251108 072419: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281244958948' Query:20251108 072419: 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 16:33:50',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281244958948','','','REG FUNZONE2') 20251108 072419 : requested url:/gameverse/idtl/callback_itg.php 20251108 072419 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"WG2bBJT9tZttjebDKYJ638l-xSy5pRSnG_dIMdYtcOtEmLkUrjqobLI=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 072419 : mobile encrypted_msisdn:WG2bBJT9tZttjebDKYJ638l-xSy5pRSnG_dIMdYtcOtEmLkUrjqobLI= 20251108 072419 : mobile keyword:REG FUNZONE2 20251108 072419 : mobile dr_status:1 20251108 072419 output={"msisdn":"6282281265139"} 20251108 072419 msisdn=6282281265139 20251108 072419 outsideloop msisdn=6282281265139 20251108 072419 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282281265139' order by id desc limit 1 Query:20251108 072419: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282281265139' Query:20251108 072419: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-26 06:17:01',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282281265139','','','REG FUNZONE2') 20251108 072423 : requested url:/gameverse/idtl/callback_itg.php 20251108 072423 : json:{"adnetid":"96014","clickid":"251108072415000000","dr_status":"0","encrypted_msisdn":"I0dNMNJKq49N2hwxG3anKTaTkbUFDrsc4FM28yfDVUo99LEgdFSw9sU=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762566856399568721"} 20251108 072423 : mobile encrypted_msisdn:I0dNMNJKq49N2hwxG3anKTaTkbUFDrsc4FM28yfDVUo99LEgdFSw9sU= 20251108 072423 : mobile keyword:REG FUNZONE2 20251108 072423 : mobile dr_status:0 20251108 072423 output={"msisdn":"6281362473306"} 20251108 072423 msisdn=6281362473306 20251108 072423 outsideloop msisdn=6281362473306 20251108 072423 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108072415000000' order by id desc limit 1 20251108 072423 subid=690ea2c66e7ca003524dea8b 20251108 072423 pubid=2 Query:20251108 072423: 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','690ea2c66e7ca003524dea8b','5','LOW-BL','0','subs','6281362473306','251108072415000000','WEB1762566856399568721','REG FUNZONE2') Query:20251108 072423: 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','690ea2c66e7ca003524dea8b','5','LOW-BL','0','subs','6281362473306','251108072415000000','WEB1762566856399568721','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ea2c66e7ca003524dea8b&campid=5:251108072425000000: 20251108 071125 output:200 20251108 072428 : requested url:/gameverse/idtl/callback_itg.php 20251108 072428 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"U5sbc-c_I7PcYtnSeJS73QLMyKuVaKAr41KHl02bfsW43eRZjDXfKsk=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 072428 : mobile encrypted_msisdn:U5sbc-c_I7PcYtnSeJS73QLMyKuVaKAr41KHl02bfsW43eRZjDXfKsk= 20251108 072428 : mobile keyword:REG FUNZONE2 20251108 072428 : mobile dr_status:1 20251108 072428 output={"msisdn":"6282198594947"} 20251108 072428 msisdn=6282198594947 20251108 072428 outsideloop msisdn=6282198594947 20251108 072428 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282198594947' order by id desc limit 1 Query:20251108 072428: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282198594947' Query:20251108 072428: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values (now(),DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282198594947','','','REG FUNZONE2') 20251108 072459 : requested url:/gameverse/idtl/callback_itg.php 20251108 072459 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"VpZNm88GMFaAQ8Ry1EzSjzXMn2NyMQR_9DFv5g21UBiBEyBXQiUKem8=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 072459 : mobile encrypted_msisdn:VpZNm88GMFaAQ8Ry1EzSjzXMn2NyMQR_9DFv5g21UBiBEyBXQiUKem8= 20251108 072459 : mobile keyword:REG FUNZONE2 20251108 072459 : mobile dr_status:1 20251108 072459 output={"msisdn":"6285234299755"} 20251108 072459 msisdn=6285234299755 20251108 072459 outsideloop msisdn=6285234299755 20251108 072459 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285234299755' order by id desc limit 1 Query:20251108 072459: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285234299755' Query:20251108 072459: 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 04:43:45',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285234299755','','','REG FUNZONE2') 20251108 072501 : requested url:/gameverse/idtl/callback_itg.php 20251108 072501 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"BwVkYf6TpfHCCIwEyLs6SEfMHSIIeBW-kkkXvvrv9CrknPkwiWrrmIQ=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 072501 : mobile encrypted_msisdn:BwVkYf6TpfHCCIwEyLs6SEfMHSIIeBW-kkkXvvrv9CrknPkwiWrrmIQ= 20251108 072501 : mobile keyword:REG FUNZONE2 20251108 072501 : mobile dr_status:1 20251108 072501 output={"msisdn":"6282396753688"} 20251108 072501 msisdn=6282396753688 20251108 072501 outsideloop msisdn=6282396753688 20251108 072501 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282396753688' order by id desc limit 1 Query:20251108 072501: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282396753688' Query:20251108 072501: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-17 19:17:54',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282396753688','','','REG FUNZONE2') 20251108 072504 : requested url:/gameverse/idtl/callback_itg.php 20251108 072504 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"wKoFWfY1bqokXT5DH7DevBbNalOHq1bSdhdbjcFrhNeLMJMmZLTHi-A=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 072504 : mobile encrypted_msisdn:wKoFWfY1bqokXT5DH7DevBbNalOHq1bSdhdbjcFrhNeLMJMmZLTHi-A= 20251108 072504 : mobile keyword:REG FUNZONE2 20251108 072504 : mobile dr_status:1 20251108 072504 output={"msisdn":"6282214450203"} 20251108 072504 msisdn=6282214450203 20251108 072504 outsideloop msisdn=6282214450203 20251108 072504 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282214450203' order by id desc limit 1 Query:20251108 072504: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282214450203' Query:20251108 072505: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-08-12 15:10:00',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282214450203','','','REG FUNZONE2') 20251108 072508 : requested url:/gameverse/idtl/callback_itg.php 20251108 072508 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"qcXOnCmZM-tkisDCmgTsSO1ZERg9LZNAJtKRwsHGRQL0mPMNpaD0szY=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 072508 : mobile encrypted_msisdn:qcXOnCmZM-tkisDCmgTsSO1ZERg9LZNAJtKRwsHGRQL0mPMNpaD0szY= 20251108 072508 : mobile keyword:REG FUNZONE2 20251108 072508 : mobile dr_status:1 20251108 072508 output={"msisdn":"6282145231235"} 20251108 072508 msisdn=6282145231235 20251108 072508 outsideloop msisdn=6282145231235 20251108 072508 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282145231235' order by id desc limit 1 Query:20251108 072508: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282145231235' Query:20251108 072508: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-08-15 15:35:45',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282145231235','','','REG FUNZONE2') 20251108 072519 : requested url:/gameverse/idtl/callback_itg.php 20251108 072519 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"2xfVCpf6eWqkZq1Ziar_-UGTDGth_tFou9Gd9QqVFkp9na3IpLAwchY=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 072519 : mobile encrypted_msisdn:2xfVCpf6eWqkZq1Ziar_-UGTDGth_tFou9Gd9QqVFkp9na3IpLAwchY= 20251108 072519 : mobile keyword:REG FUNZONE2 20251108 072519 : mobile dr_status:1 20251108 072519 output={"msisdn":"6285379990888"} 20251108 072519 msisdn=6285379990888 20251108 072519 outsideloop msisdn=6285379990888 20251108 072519 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285379990888' order by id desc limit 1 Query:20251108 072519: 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:20251108 072519: 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') 20251108 072933 : requested url:/gameverse/idtl/callback_itg.php 20251108 072933 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"PQuipF9mAMKeam3kUGLMrcqVrudVsIsl2_f5lHVsd701KGfPxVy945g=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 072933 : mobile encrypted_msisdn:PQuipF9mAMKeam3kUGLMrcqVrudVsIsl2_f5lHVsd701KGfPxVy945g= 20251108 072933 : mobile keyword:REG FUNZONE1 20251108 072933 : mobile dr_status:1 20251108 072933 output={"msisdn":"6281321892277"} 20251108 072933 msisdn=6281321892277 20251108 072933 outsideloop msisdn=6281321892277 20251108 072933 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281321892277' order by id desc limit 1 Query:20251108 072933: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281321892277' Query:20251108 072933: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-07-31 18:30:42',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6281321892277','','','REG FUNZONE1') 20251108 073243 : requested url:/gameverse/idtl/callback_itg.php 20251108 073243 : json:{"adnetid":"96014","clickid":"251108073236000000","dr_status":"0","encrypted_msisdn":"xTvDyEJ24EY7lxhUBGd_1-IHx2kMHJjUYKct70NJirGIPVGcuLq3A3g=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625673571795025900"} 20251108 073243 : mobile encrypted_msisdn:xTvDyEJ24EY7lxhUBGd_1-IHx2kMHJjUYKct70NJirGIPVGcuLq3A3g= 20251108 073243 : mobile keyword:REG FUNZONE2 20251108 073243 : mobile dr_status:0 20251108 073243 output={"msisdn":"6285373667598"} 20251108 073243 msisdn=6285373667598 20251108 073243 outsideloop msisdn=6285373667598 20251108 073243 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108073236000000' order by id desc limit 1 20251108 073243 subid=690ea4bb50efbb0346f68b75 20251108 073243 pubid=2 Query:20251108 073243: 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','690ea4bb50efbb0346f68b75','5','LOW-BL','0','subs','6285373667598','251108073236000000','WEB17625673571795025900','REG FUNZONE2') Query:20251108 073243: 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','690ea4bb50efbb0346f68b75','5','LOW-BL','0','subs','6285373667598','251108073236000000','WEB17625673571795025900','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ea4bb50efbb0346f68b75&campid=5:251108073245000000: 20251108 071145 output:200 20251108 073715 : requested url:/gameverse/idtl/callback_itg.php 20251108 073715 : json:{"adnetid":"96014","clickid":"251108073712000000","dr_status":"0","encrypted_msisdn":"eDxIy-BezIvSKsQhMxJvQDLT3CtXthOYl9MM69YUQzbJHs3u69nhjm0=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762567633885562732"} 20251108 073715 : mobile encrypted_msisdn:eDxIy-BezIvSKsQhMxJvQDLT3CtXthOYl9MM69YUQzbJHs3u69nhjm0= 20251108 073715 : mobile keyword:REG FUNZONE2 20251108 073715 : mobile dr_status:0 20251108 073715 output={"msisdn":"6285270088899"} 20251108 073715 msisdn=6285270088899 20251108 073715 outsideloop msisdn=6285270088899 20251108 073715 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108073712000000' order by id desc limit 1 20251108 073715 subid=690ea5cf3d600b0342b2a006 20251108 073715 pubid=2 Query:20251108 073715: 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','690ea5cf3d600b0342b2a006','5','LOW-BL','0','subs','6285270088899','251108073712000000','WEB1762567633885562732','REG FUNZONE2') Query:20251108 073715: 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','690ea5cf3d600b0342b2a006','5','LOW-BL','0','subs','6285270088899','251108073712000000','WEB1762567633885562732','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ea5cf3d600b0342b2a006&campid=5:251108073717000000: 20251108 071117 output:200 20251108 075022 : requested url:/gameverse/idtl/callback_itg.php 20251108 075022 : json:{"adnetid":"96014","clickid":"251108075013000000","dr_status":"0","encrypted_msisdn":"sGZYSpidNVp7ZxVfuLGVEVdD8-BFTj7f23SzqlhvNn4GGXIZ04t8NPU=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625684141208800595"} 20251108 075022 : mobile encrypted_msisdn:sGZYSpidNVp7ZxVfuLGVEVdD8-BFTj7f23SzqlhvNn4GGXIZ04t8NPU= 20251108 075022 : mobile keyword:REG FUNZONE2 20251108 075022 : mobile dr_status:0 20251108 075022 output={"msisdn":"6285134111423"} 20251108 075022 msisdn=6285134111423 20251108 075022 outsideloop msisdn=6285134111423 20251108 075022 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108075013000000' order by id desc limit 1 20251108 075022 subid=690ea8dde9975f03414f4f45 20251108 075022 pubid=2 Query:20251108 075022: 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','690ea8dde9975f03414f4f45','5','LOW-BL','0','subs','6285134111423','251108075013000000','WEB17625684141208800595','REG FUNZONE2') Query:20251108 075022: 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','690ea8dde9975f03414f4f45','5','LOW-BL','0','subs','6285134111423','251108075013000000','WEB17625684141208800595','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ea8dde9975f03414f4f45&campid=5:251108075024000000: 20251108 071124 output:200 20251108 075053 : requested url:/gameverse/idtl/callback_itg.php 20251108 075053 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"z-GeWmeF9QxkOln1GEG6VuftjEJUvON9KeJAFoFLJjF92rib3PPnAtg=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 075053 : mobile encrypted_msisdn:z-GeWmeF9QxkOln1GEG6VuftjEJUvON9KeJAFoFLJjF92rib3PPnAtg= 20251108 075053 : mobile keyword:REG FUNZONE1 20251108 075053 : mobile dr_status:1 20251108 075053 output={"msisdn":"6282198962128"} 20251108 075053 msisdn=6282198962128 20251108 075053 outsideloop msisdn=6282198962128 20251108 075053 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282198962128' order by id desc limit 1 Query:20251108 075053: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282198962128' Query:20251108 075054: 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 15:50:55',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282198962128','','','REG FUNZONE1') 20251108 075105 : requested url:/gameverse/idtl/callback_itg.php 20251108 075105 : json:{"adnetid":"96014","clickid":"251108075049000000","dr_status":"0","encrypted_msisdn":"uHTSpumsX32WFhHg8ZAk-QSPM_N_cnMMpr5ktjGjAtKgqNwKEQGlZaU=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625684501323286757"} 20251108 075105 : mobile encrypted_msisdn:uHTSpumsX32WFhHg8ZAk-QSPM_N_cnMMpr5ktjGjAtKgqNwKEQGlZaU= 20251108 075105 : mobile keyword:REG FUNZONE2 20251108 075105 : mobile dr_status:0 20251108 075105 output={"msisdn":"6285126916533"} 20251108 075105 msisdn=6285126916533 20251108 075105 outsideloop msisdn=6285126916533 20251108 075105 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108075049000000' order by id desc limit 1 20251108 075105 subid=690ea90016aac90343e46808 20251108 075105 pubid=2 Query:20251108 075105: 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','690ea90016aac90343e46808','5','LOW-BL','0','subs','6285126916533','251108075049000000','WEB17625684501323286757','REG FUNZONE2') Query:20251108 075105: 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','690ea90016aac90343e46808','5','LOW-BL','0','subs','6285126916533','251108075049000000','WEB17625684501323286757','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ea90016aac90343e46808&campid=5:251108075105000000: 20251108 071105 output:200 20251108 075405 : requested url:/gameverse/idtl/callback_itg.php 20251108 075405 : json:{"adnetid":"96014","clickid":"251108075358000000","dr_status":"0","encrypted_msisdn":"FMJaG97fhyLz19_WOS6KOWEJ-QlpreYvwDzPFPKkIcTF8qagKZa5Jg0=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762568639696375718"} 20251108 075405 : mobile encrypted_msisdn:FMJaG97fhyLz19_WOS6KOWEJ-QlpreYvwDzPFPKkIcTF8qagKZa5Jg0= 20251108 075405 : mobile keyword:REG FUNZONE2 20251108 075405 : mobile dr_status:0 20251108 075405 output={"msisdn":"6281336197747"} 20251108 075405 msisdn=6281336197747 20251108 075405 outsideloop msisdn=6281336197747 20251108 075405 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108075358000000' order by id desc limit 1 20251108 075405 subid=690ea9bd95b75503482224e3 20251108 075405 pubid=2 Query:20251108 075405: 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','690ea9bd95b75503482224e3','5','LOW-BL','0','subs','6281336197747','251108075358000000','WEB1762568639696375718','REG FUNZONE2') Query:20251108 075405: 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','690ea9bd95b75503482224e3','5','LOW-BL','0','subs','6281336197747','251108075358000000','WEB1762568639696375718','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ea9bd95b75503482224e3&campid=5:251108075405000000: 20251108 071105 output:200 20251108 093233 : requested url:/gameverse/idtl/callback_itg.php 20251108 093233 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Yd_4rVsncgDHjdkNzIQCkhj5-A66cq9NQeSl0ZMmLmZbaPHSP2ZzrD4=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 093233 : mobile encrypted_msisdn:Yd_4rVsncgDHjdkNzIQCkhj5-A66cq9NQeSl0ZMmLmZbaPHSP2ZzrD4= 20251108 093233 : mobile keyword:UNREG FUNZONE2 20251108 093233 : mobile dr_status:1 20251108 093233 output={"msisdn":"6281235102064"} 20251108 093233 msisdn=6281235102064 20251108 093233 outsideloop msisdn=6281235102064 20251108 093233 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281235102064' order by id desc limit 1 Querydel:20251108 093233: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6281235102064','UNREG FUNZONE2') Queryt:20251108 093233: delete from tbl_subscription_Telkomsel_id where msisdn='6281235102064' 20251108 102352 : requested url:/gameverse/idtl/callback_itg.php 20251108 102352 : json:{"adnetid":"96014","clickid":"251108102346000000","dr_status":"0","encrypted_msisdn":"bV2nkgocXAPcua89oqtw13hs8F_78fdTVx-eTjRZrAqEjKvDjKBH2uI=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762577626783094048"} 20251108 102352 : mobile encrypted_msisdn:bV2nkgocXAPcua89oqtw13hs8F_78fdTVx-eTjRZrAqEjKvDjKBH2uI= 20251108 102352 : mobile keyword:REG FUNZONE2 20251108 102352 : mobile dr_status:0 20251108 102352 output={"msisdn":"6282277187872"} 20251108 102352 msisdn=6282277187872 20251108 102352 outsideloop msisdn=6282277187872 20251108 102352 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108102346000000' order by id desc limit 1 20251108 102352 subid=690eccd935958e034fc9f04b 20251108 102352 pubid=2 Query:20251108 102352: 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','690eccd935958e034fc9f04b','5','LOW-BL','0','subs','6282277187872','251108102346000000','WEB1762577626783094048','REG FUNZONE2') Query:20251108 102352: 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','690eccd935958e034fc9f04b','5','LOW-BL','0','subs','6282277187872','251108102346000000','WEB1762577626783094048','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690eccd935958e034fc9f04b&campid=5:251108102352000000: 20251108 101152 output:200 20251108 103357 : requested url:/gameverse/idtl/callback_itg.php 20251108 103357 : json:{"adnetid":"96014","clickid":"251108103346000000","dr_status":"0","encrypted_msisdn":"qQYWKpYRWJhDh_r37UYVf6NB3JWzVWdcKAy5_wXPYIA0xTCrvpM6Pvg=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625782281314533658"} 20251108 103357 : mobile encrypted_msisdn:qQYWKpYRWJhDh_r37UYVf6NB3JWzVWdcKAy5_wXPYIA0xTCrvpM6Pvg= 20251108 103357 : mobile keyword:REG FUNZONE2 20251108 103357 : mobile dr_status:0 20251108 103357 output={"msisdn":"6282386861889"} 20251108 103357 msisdn=6282386861889 20251108 103357 outsideloop msisdn=6282386861889 20251108 103357 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108103346000000' order by id desc limit 1 20251108 103357 subid=690ecf3116b94f03408267a4 20251108 103357 pubid=2 Query:20251108 103357: 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','690ecf3116b94f03408267a4','5','LOW-BL','0','subs','6282386861889','251108103346000000','WEB17625782281314533658','REG FUNZONE2') Query:20251108 103357: 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','690ecf3116b94f03408267a4','5','LOW-BL','0','subs','6282386861889','251108103346000000','WEB17625782281314533658','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ecf3116b94f03408267a4&campid=5:251108103359000000: 20251108 101159 output:200 20251108 103827 : requested url:/gameverse/idtl/callback_itg.php 20251108 103827 : json:{"adnetid":"96014","clickid":"251108103805000000","dr_status":"0","encrypted_msisdn":"QgP0HDtnVJ-zZVpOd8SH05bqIU2WaJtobPtMbAriYExoht3O2WixN0U=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB176257848581439076"} 20251108 103827 : mobile encrypted_msisdn:QgP0HDtnVJ-zZVpOd8SH05bqIU2WaJtobPtMbAriYExoht3O2WixN0U= 20251108 103827 : mobile keyword:REG FUNZONE2 20251108 103827 : mobile dr_status:0 20251108 103827 output={"msisdn":"6282171226486"} 20251108 103827 msisdn=6282171226486 20251108 103827 outsideloop msisdn=6282171226486 20251108 103827 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108103805000000' order by id desc limit 1 20251108 103827 subid=690ed0337ba4760348895cf6 20251108 103827 pubid=2 Query:20251108 103827: 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','690ed0337ba4760348895cf6','5','LOW-BL','0','subs','6282171226486','251108103805000000','WEB176257848581439076','REG FUNZONE2') Query:20251108 103827: 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','690ed0337ba4760348895cf6','5','LOW-BL','0','subs','6282171226486','251108103805000000','WEB176257848581439076','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ed0337ba4760348895cf6&campid=5:251108103829000000: 20251108 101129 output:200 20251108 105219 : requested url:/gameverse/idtl/callback_itg.php 20251108 105219 : json:{"adnetid":"96014","clickid":"251108105208000000","dr_status":"0","encrypted_msisdn":"GiYvMfe3Ruw6RKU26RQWI4rrsrte-Ru9CUYvA-evdtCIw7FOenfqi_8=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625793292110285806"} 20251108 105219 : mobile encrypted_msisdn:GiYvMfe3Ruw6RKU26RQWI4rrsrte-Ru9CUYvA-evdtCIw7FOenfqi_8= 20251108 105219 : mobile keyword:REG FUNZONE2 20251108 105219 : mobile dr_status:0 20251108 105219 output={"msisdn":"6282261899085"} 20251108 105219 msisdn=6282261899085 20251108 105219 outsideloop msisdn=6282261899085 20251108 105219 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108105208000000' order by id desc limit 1 20251108 105219 subid=690ed37f6b0bb20345bcf967 20251108 105219 pubid=2 Query:20251108 105219: 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','690ed37f6b0bb20345bcf967','5','LOW-BL','0','subs','6282261899085','251108105208000000','WEB17625793292110285806','REG FUNZONE2') Query:20251108 105219: 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','690ed37f6b0bb20345bcf967','5','LOW-BL','0','subs','6282261899085','251108105208000000','WEB17625793292110285806','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ed37f6b0bb20345bcf967&campid=5:251108105221000000: 20251108 101121 output:200 20251108 110114 : requested url:/gameverse/idtl/callback_itg.php 20251108 110114 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"NIQlMVLvNLXgi9XmPdirZgIZaq6Zt2XrrtadcFNWfhEmHWXnz_mjA4Y=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 110114 : mobile encrypted_msisdn:NIQlMVLvNLXgi9XmPdirZgIZaq6Zt2XrrtadcFNWfhEmHWXnz_mjA4Y= 20251108 110114 : mobile keyword:UNREG FUNZONE2 20251108 110114 : mobile dr_status:1 20251108 110114 output={"msisdn":"6282277187872"} 20251108 110114 msisdn=6282277187872 20251108 110114 outsideloop msisdn=6282277187872 20251108 110114 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282277187872' order by id desc limit 1 Querydel:20251108 110114: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-08 10:23:52',now(),'6282277187872','UNREG FUNZONE2') Queryt:20251108 110114: delete from tbl_subscription_Telkomsel_id where msisdn='6282277187872' 20251108 113347 : requested url:/gameverse/idtl/callback_itg.php 20251108 113347 : json:{"adnetid":"96014","clickid":"251108113337000000","dr_status":"1","encrypted_msisdn":"sOIkcGtsZoE77wfCCpMuf-bEraaAl_FAcCbj162eS3AHSLvuiCy1vXk=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762581818563862439"} 20251108 113347 : mobile encrypted_msisdn:sOIkcGtsZoE77wfCCpMuf-bEraaAl_FAcCbj162eS3AHSLvuiCy1vXk= 20251108 113347 : mobile keyword:REG FUNZONE2 20251108 113347 : mobile dr_status:1 20251108 113347 output={"msisdn":"6282343665005"} 20251108 113347 msisdn=6282343665005 20251108 113347 outsideloop msisdn=6282343665005 20251108 113347 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108113337000000' order by id desc limit 1 20251108 113347 subid=690edd3823cb3d0340c5e8f1 20251108 113347 pubid=2 Query:20251108 113347: insert into tbl_subscription_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values (now(),DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'2','690edd3823cb3d0340c5e8f1','5','FSC-BL','1','subs','6282343665005','251108113337000000','WEB1762581818563862439','REG FUNZONE2') Query:20251108 113347: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values (now(),DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'2','690edd3823cb3d0340c5e8f1','5','FSC-BL','1','subs','6282343665005','251108113337000000','WEB1762581818563862439','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690edd3823cb3d0340c5e8f1&campid=5:251108113349000000: 20251108 111149 output:200 20251108 115018 : requested url:/gameverse/idtl/callback_itg.php 20251108 115018 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"FAvt_kVIR853Vm-HPWw5hJHoBCYyPYqCn3AyOW4xc4Sc_y_PEA1sF_4=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 115018 : mobile encrypted_msisdn:FAvt_kVIR853Vm-HPWw5hJHoBCYyPYqCn3AyOW4xc4Sc_y_PEA1sF_4= 20251108 115018 : mobile keyword:UNREG FUNZONE2 20251108 115018 : mobile dr_status:1 20251108 115018 output={"msisdn":"6285211861719"} 20251108 115018 msisdn=6285211861719 20251108 115018 outsideloop msisdn=6285211861719 20251108 115018 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285211861719' order by id desc limit 1 Querydel:20251108 115018: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6285211861719','UNREG FUNZONE2') Queryt:20251108 115018: delete from tbl_subscription_Telkomsel_id where msisdn='6285211861719' 20251108 120513 : requested url:/gameverse/idtl/callback_itg.php 20251108 120513 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"2LeAJ3WqlacXrAjGkft3K7z8Si8RyvpvZJqp9J1K0z3EzjAQUqdcckQ=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 120513 : mobile encrypted_msisdn:2LeAJ3WqlacXrAjGkft3K7z8Si8RyvpvZJqp9J1K0z3EzjAQUqdcckQ= 20251108 120513 : mobile keyword:REG FUNZONE1 20251108 120513 : mobile dr_status:1 20251108 120513 output={"msisdn":"6285147077465"} 20251108 120513 msisdn=6285147077465 20251108 120513 outsideloop msisdn=6285147077465 20251108 120513 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285147077465' order by id desc limit 1 Query:20251108 120513: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285147077465' Query:20251108 120513: 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 10:10:45',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6285147077465','','','REG FUNZONE1') 20251108 121025 : requested url:/gameverse/idtl/callback_itg.php 20251108 121025 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"bn6q7_7RabHTSY47a1xI4W6-t76G4m7vy7DwWz6Lc_96w1DPXk2pkrU=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 121025 : mobile encrypted_msisdn:bn6q7_7RabHTSY47a1xI4W6-t76G4m7vy7DwWz6Lc_96w1DPXk2pkrU= 20251108 121025 : mobile keyword:REG FUNZONE2 20251108 121025 : mobile dr_status:1 20251108 121025 output={"msisdn":"6282196628006"} 20251108 121025 msisdn=6282196628006 20251108 121025 outsideloop msisdn=6282196628006 20251108 121025 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282196628006' order by id desc limit 1 Query:20251108 121025: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282196628006' Query:20251108 121025: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-15 10:02:14',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282196628006','','','REG FUNZONE2') 20251108 121029 : requested url:/gameverse/idtl/callback_itg.php 20251108 121029 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"8IyOkdrAn-6EETnWPcsSzLq9BSrPoatuXC7SdGmZxkrgV2g7f64mfw0=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 121029 : mobile encrypted_msisdn:8IyOkdrAn-6EETnWPcsSzLq9BSrPoatuXC7SdGmZxkrgV2g7f64mfw0= 20251108 121029 : mobile keyword:REG FUNZONE2 20251108 121029 : mobile dr_status:1 20251108 121029 output={"msisdn":"6282279773632"} 20251108 121029 msisdn=6282279773632 20251108 121029 outsideloop msisdn=6282279773632 20251108 121029 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282279773632' order by id desc limit 1 Query:20251108 121029: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282279773632' Query:20251108 121029: 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 05:05:35',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282279773632','','','REG FUNZONE2') 20251108 121030 : requested url:/gameverse/idtl/callback_itg.php 20251108 121030 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"pq9zk-iHF_1g4MQ5HZMoWiWngFVa5_r7W-esuiEfJpKeiY7RobAVev4=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 121030 : mobile encrypted_msisdn:pq9zk-iHF_1g4MQ5HZMoWiWngFVa5_r7W-esuiEfJpKeiY7RobAVev4= 20251108 121030 : mobile keyword:REG FUNZONE2 20251108 121030 : mobile dr_status:1 20251108 121030 output={"msisdn":"6285216900878"} 20251108 121030 msisdn=6285216900878 20251108 121030 outsideloop msisdn=6285216900878 20251108 121030 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285216900878' order by id desc limit 1 Query:20251108 121030: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285216900878' Query:20251108 121030: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-12 20:06:18',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285216900878','','','REG FUNZONE2') 20251108 121043 : requested url:/gameverse/idtl/callback_itg.php 20251108 121043 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"dX4RnuQWytQxDXbJSHjy_swWYClbJ6PI8nKVTBZkmClFvBzsLdUn1w==","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 121043 : mobile encrypted_msisdn:dX4RnuQWytQxDXbJSHjy_swWYClbJ6PI8nKVTBZkmClFvBzsLdUn1w== 20251108 121043 : mobile keyword:REG FUNZONE2 20251108 121043 : mobile dr_status:1 20251108 121043 output={"msisdn":"628116488821"} 20251108 121043 msisdn=628116488821 20251108 121043 outsideloop msisdn=628116488821 20251108 121043 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='628116488821' order by id desc limit 1 20251108 121043 : requested url:/gameverse/idtl/callback_itg.php 20251108 121043 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"RIMuyJtF6xlZmKTs45rt7ZGWzAKyA3iSbPMN37CLfAlpVJi3gnqpPSE=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 121043 : mobile encrypted_msisdn:RIMuyJtF6xlZmKTs45rt7ZGWzAKyA3iSbPMN37CLfAlpVJi3gnqpPSE= 20251108 121043 : mobile keyword:REG FUNZONE2 20251108 121043 : mobile dr_status:1 Query:20251108 121043: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='628116488821' 20251108 121043 output={"msisdn":"6285280666706"} 20251108 121043 msisdn=6285280666706 20251108 121043 outsideloop msisdn=6285280666706 20251108 121043 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285280666706' order by id desc limit 1 Query:20251108 121043: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285280666706' Query:20251108 121043: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-27 11:40:10',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','628116488821','','','REG FUNZONE2') Query:20251108 121043: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-27 10:33:25',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285280666706','','','REG FUNZONE2') 20251108 121046 : requested url:/gameverse/idtl/callback_itg.php 20251108 121046 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"yG7-n6J5Sp0ntAvyfaDeKOXXixD__x0H2RCECcr37fkCOKA7oiT9tw8=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 121046 : mobile encrypted_msisdn:yG7-n6J5Sp0ntAvyfaDeKOXXixD__x0H2RCECcr37fkCOKA7oiT9tw8= 20251108 121046 : mobile keyword:REG FUNZONE2 20251108 121046 : mobile dr_status:1 20251108 121046 output={"msisdn":"6285294568842"} 20251108 121046 msisdn=6285294568842 20251108 121046 outsideloop msisdn=6285294568842 20251108 121046 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285294568842' order by id desc limit 1 Query:20251108 121046: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285294568842' Query:20251108 121046: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-27 02:27:27',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285294568842','','','REG FUNZONE2') 20251108 121050 : requested url:/gameverse/idtl/callback_itg.php 20251108 121050 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"dQg-v55eDsoJFt2G4-inzSyeu_0F6qwA58arbkmMEF-YQlnDxcA7kes=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 121050 : mobile encrypted_msisdn:dQg-v55eDsoJFt2G4-inzSyeu_0F6qwA58arbkmMEF-YQlnDxcA7kes= 20251108 121050 : mobile keyword:REG FUNZONE2 20251108 121050 : mobile dr_status:1 20251108 121050 output={"msisdn":"6281312194421"} 20251108 121050 msisdn=6281312194421 20251108 121050 outsideloop msisdn=6281312194421 20251108 121050 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281312194421' order by id desc limit 1 Query:20251108 121050: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281312194421' Query:20251108 121050: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-30 08:24:17',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281312194421','','','REG FUNZONE2') 20251108 121053 : requested url:/gameverse/idtl/callback_itg.php 20251108 121053 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Hxwbr9yXgFd64KicpVqRxDQvLZgnit9nPlPgcJQmfAoALbvVkIQYfw==","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 121053 : mobile encrypted_msisdn:Hxwbr9yXgFd64KicpVqRxDQvLZgnit9nPlPgcJQmfAoALbvVkIQYfw== 20251108 121053 : mobile keyword:REG FUNZONE2 20251108 121053 : mobile dr_status:1 20251108 121053 output={"msisdn":"628126548189"} 20251108 121053 msisdn=628126548189 20251108 121053 outsideloop msisdn=628126548189 20251108 121053 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='628126548189' order by id desc limit 1 Query:20251108 121053: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='628126548189' Query:20251108 121053: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-30 11:53:03',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','628126548189','','','REG FUNZONE2') 20251108 121057 : requested url:/gameverse/idtl/callback_itg.php 20251108 121057 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"sPQ8ctzoisrWtRAH5mERNXV_ReU2BhbLIoqgsc3O-wvTaAORZaXQZUg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 121057 : mobile encrypted_msisdn:sPQ8ctzoisrWtRAH5mERNXV_ReU2BhbLIoqgsc3O-wvTaAORZaXQZUg= 20251108 121057 : mobile keyword:REG FUNZONE2 20251108 121057 : mobile dr_status:1 20251108 121057 output={"msisdn":"6281346025711"} 20251108 121057 msisdn=6281346025711 20251108 121057 outsideloop msisdn=6281346025711 20251108 121057 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281346025711' order by id desc limit 1 Query:20251108 121057: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281346025711' Query:20251108 121057: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-10-03 19:52:47',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281346025711','','','REG FUNZONE2') 20251108 121058 : requested url:/gameverse/idtl/callback_itg.php 20251108 121058 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"jq4seZbLYsfr8LLupxuygnhWyt3VcLlmBSXkhYzA4R9FzudG7Kow_90=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 121058 : mobile encrypted_msisdn:jq4seZbLYsfr8LLupxuygnhWyt3VcLlmBSXkhYzA4R9FzudG7Kow_90= 20251108 121058 : mobile keyword:REG FUNZONE2 20251108 121058 : mobile dr_status:1 20251108 121058 output={"msisdn":"6281337387758"} 20251108 121058 msisdn=6281337387758 20251108 121058 outsideloop msisdn=6281337387758 20251108 121058 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281337387758' order by id desc limit 1 Query:20251108 121058: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281337387758' Query:20251108 121058: 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 05:05:58',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281337387758','','','REG FUNZONE2') 20251108 121138 : requested url:/gameverse/idtl/callback_itg.php 20251108 121138 : json:{"adnetid":"96014","clickid":"251108121130000000","dr_status":"0","encrypted_msisdn":"kdL_OuJvV9KqnFOE5BciMJGKn3DWreZLFn9aMXptOP_71do6zUUd8EA=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762584091876783603"} 20251108 121138 : mobile encrypted_msisdn:kdL_OuJvV9KqnFOE5BciMJGKn3DWreZLFn9aMXptOP_71do6zUUd8EA= 20251108 121138 : mobile keyword:REG FUNZONE2 20251108 121138 : mobile dr_status:0 20251108 121138 output={"msisdn":"6285133761462"} 20251108 121138 msisdn=6285133761462 20251108 121138 outsideloop msisdn=6285133761462 20251108 121138 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108121130000000' order by id desc limit 1 20251108 121138 subid=690ee619284fed03443ff6a2 20251108 121138 pubid=2 Query:20251108 121138: 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','690ee619284fed03443ff6a2','5','LOW-BL','0','subs','6285133761462','251108121130000000','WEB1762584091876783603','REG FUNZONE2') Query:20251108 121138: 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','690ee619284fed03443ff6a2','5','LOW-BL','0','subs','6285133761462','251108121130000000','WEB1762584091876783603','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ee619284fed03443ff6a2&campid=5:251108121140000000: 20251108 121140 output:200 20251108 121301 : requested url:/gameverse/idtl/callback_itg.php 20251108 121301 : json:{"adnetid":"96014","clickid":"251108121251000000","dr_status":"0","encrypted_msisdn":"GBcFjp4u9Jgx7fZK2jDs-EZVFFy7HjmSb0zNwaYA8EOaAM1lk52EyR4=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762584172357994121"} 20251108 121301 : mobile encrypted_msisdn:GBcFjp4u9Jgx7fZK2jDs-EZVFFy7HjmSb0zNwaYA8EOaAM1lk52EyR4= 20251108 121301 : mobile keyword:REG FUNZONE2 20251108 121301 : mobile dr_status:0 20251108 121301 output={"msisdn":"6282183330997"} 20251108 121301 msisdn=6282183330997 20251108 121301 outsideloop msisdn=6282183330997 20251108 121301 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108121251000000' order by id desc limit 1 20251108 121301 subid=690ee66a64310303413328b9 20251108 121301 pubid=2 Query:20251108 121301: 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','690ee66a64310303413328b9','5','LOW-BL','0','subs','6282183330997','251108121251000000','WEB1762584172357994121','REG FUNZONE2') Query:20251108 121301: 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','690ee66a64310303413328b9','5','LOW-BL','0','subs','6282183330997','251108121251000000','WEB1762584172357994121','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690ee66a64310303413328b9&campid=5:251108121303000000: 20251108 121103 output:200 20251108 122006 : requested url:/gameverse/idtl/callback_itg.php 20251108 122006 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"ABe0ujhaFGS1I5J2vlWO34wD-nA-gie2k-oLKAzWvu01jaL_9WPvv_w=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 122006 : mobile encrypted_msisdn:ABe0ujhaFGS1I5J2vlWO34wD-nA-gie2k-oLKAzWvu01jaL_9WPvv_w= 20251108 122006 : mobile keyword:REG FUNZONE2 20251108 122006 : mobile dr_status:1 20251108 122006 output={"msisdn":"6282172263012"} 20251108 122006 msisdn=6282172263012 20251108 122006 outsideloop msisdn=6282172263012 20251108 122006 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282172263012' order by id desc limit 1 Query:20251108 122006: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282172263012' Query:20251108 122007: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-26 07:16:55',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282172263012','','','REG FUNZONE2') 20251108 122010 : requested url:/gameverse/idtl/callback_itg.php 20251108 122010 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"mQ9eHMCASFGiwVriIk8N55Ed4-pXk7AC5dRw2sj97hzQ29e0RqxDXvU=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 122010 : mobile encrypted_msisdn:mQ9eHMCASFGiwVriIk8N55Ed4-pXk7AC5dRw2sj97hzQ29e0RqxDXvU= 20251108 122010 : mobile keyword:REG FUNZONE2 20251108 122010 : mobile dr_status:1 20251108 122010 output={"msisdn":"6282275818929"} 20251108 122010 msisdn=6282275818929 20251108 122010 outsideloop msisdn=6282275818929 20251108 122010 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282275818929' order by id desc limit 1 Query:20251108 122010: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282275818929' Query:20251108 122011: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-26 21:19:49',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282275818929','','','REG FUNZONE2') 20251108 122016 : requested url:/gameverse/idtl/callback_itg.php 20251108 122016 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"uL6LgnvFcBIftC0moJWHnVDX0MufgrkHqW_rlPi3kNUICW87LfFtGtQ=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 122016 : mobile encrypted_msisdn:uL6LgnvFcBIftC0moJWHnVDX0MufgrkHqW_rlPi3kNUICW87LfFtGtQ= 20251108 122016 : mobile keyword:REG FUNZONE2 20251108 122016 : mobile dr_status:1 20251108 122016 output={"msisdn":"6281283441763"} 20251108 122016 msisdn=6281283441763 20251108 122016 outsideloop msisdn=6281283441763 20251108 122016 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281283441763' order by id desc limit 1 Query:20251108 122016: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281283441763' Query:20251108 122016: 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 04:52:30',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281283441763','','','REG FUNZONE2') 20251108 122118 : requested url:/gameverse/idtl/callback_itg.php 20251108 122118 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"UxiemoBNhg5itKf_EgL6J2UPt9uJVfDALQ8Xz0V_f0HqoNG5e31wG2E=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 122118 : mobile encrypted_msisdn:UxiemoBNhg5itKf_EgL6J2UPt9uJVfDALQ8Xz0V_f0HqoNG5e31wG2E= 20251108 122118 : mobile keyword:REG FUNZONE2 20251108 122118 : mobile dr_status:1 20251108 122118 output={"msisdn":"6282329597853"} 20251108 122118 msisdn=6282329597853 20251108 122118 outsideloop msisdn=6282329597853 20251108 122118 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282329597853' order by id desc limit 1 Query:20251108 122118: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282329597853' Query:20251108 122118: 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 13:27:13',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282329597853','','','REG FUNZONE2') 20251108 122121 : requested url:/gameverse/idtl/callback_itg.php 20251108 122121 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"eYoSAtlJ1cONAYk-Fvtsk5EdfDO8RLrbaDbLbkOMUyapg0y4xCEmxf8=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 122121 : mobile encrypted_msisdn:eYoSAtlJ1cONAYk-Fvtsk5EdfDO8RLrbaDbLbkOMUyapg0y4xCEmxf8= 20251108 122121 : mobile keyword:REG FUNZONE2 20251108 122121 : mobile dr_status:1 20251108 122121 output={"msisdn":"6281274169850"} 20251108 122121 msisdn=6281274169850 20251108 122121 outsideloop msisdn=6281274169850 20251108 122121 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281274169850' order by id desc limit 1 Query:20251108 122121: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281274169850' Query:20251108 122121: 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 17:53:13',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281274169850','','','REG FUNZONE2') 20251108 122126 : requested url:/gameverse/idtl/callback_itg.php 20251108 122126 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"ZPi5Ak5_egboGzHzpuq5JDTnBHtaTPrIFJbLHdqloVS4cuNsznxq-kA=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 122126 : mobile encrypted_msisdn:ZPi5Ak5_egboGzHzpuq5JDTnBHtaTPrIFJbLHdqloVS4cuNsznxq-kA= 20251108 122126 : mobile keyword:REG FUNZONE2 20251108 122126 : mobile dr_status:1 20251108 122126 output={"msisdn":"6282111144126"} 20251108 122126 msisdn=6282111144126 20251108 122126 outsideloop msisdn=6282111144126 20251108 122126 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282111144126' order by id desc limit 1 Query:20251108 122126: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282111144126' Query:20251108 122127: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-08-24 09:08:27',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282111144126','','','REG FUNZONE2') 20251108 122551 : requested url:/gameverse/idtl/callback_itg.php 20251108 122551 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Jr10sLGnuqFSAN2CWmoV0-N7_pF51vtPK8C-OUOQk-FTgYMLvbGngeo=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 122551 : mobile encrypted_msisdn:Jr10sLGnuqFSAN2CWmoV0-N7_pF51vtPK8C-OUOQk-FTgYMLvbGngeo= 20251108 122551 : mobile keyword:REG FUNZONE1 20251108 122551 : mobile dr_status:1 20251108 122551 output={"msisdn":"6282384046920"} 20251108 122551 msisdn=6282384046920 20251108 122551 outsideloop msisdn=6282384046920 20251108 122551 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282384046920' order by id desc limit 1 Query:20251108 122551: 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:20251108 122551: 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') 20251108 124854 : requested url:/gameverse/idtl/callback_itg.php 20251108 124854 : json:{"adnetid":"96014","clickid":"251108124831000000","dr_status":"1","encrypted_msisdn":"vdD_BlJAU6HObMMUBQm__y8pl-P0YImm1VyyMURfWJVAKkYUm0hPW7A=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762586318534520437"} 20251108 124854 : mobile encrypted_msisdn:vdD_BlJAU6HObMMUBQm__y8pl-P0YImm1VyyMURfWJVAKkYUm0hPW7A= 20251108 124854 : mobile keyword:REG FUNZONE2 20251108 124854 : mobile dr_status:1 20251108 124854 output={"msisdn":"6281245538363"} 20251108 124854 msisdn=6281245538363 20251108 124854 outsideloop msisdn=6281245538363 20251108 124854 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108124831000000' order by id desc limit 1 20251108 124854 subid=690eeec4284fed034445df7f 20251108 124854 pubid=2 Query:20251108 124854: insert into tbl_subscription_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values (now(),DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'2','690eeec4284fed034445df7f','5','FSC-BL','1','subs','6281245538363','251108124831000000','WEB1762586318534520437','REG FUNZONE2') Query:20251108 124854: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values (now(),DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'2','690eeec4284fed034445df7f','5','FSC-BL','1','subs','6281245538363','251108124831000000','WEB1762586318534520437','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690eeec4284fed034445df7f&campid=5:251108124856000000: 20251108 121156 output:200 20251108 131938 : requested url:/gameverse/idtl/callback_itg.php 20251108 131938 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"ATRU-odt4P79mykYrWVCBuQhX_UGyOemZD74HHFrWWRiPT0NJmM5p5E=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 131938 : mobile encrypted_msisdn:ATRU-odt4P79mykYrWVCBuQhX_UGyOemZD74HHFrWWRiPT0NJmM5p5E= 20251108 131938 : mobile keyword:UNREG FUNZONE2 20251108 131938 : mobile dr_status:1 20251108 131938 output={"msisdn":"6285325923850"} 20251108 131938 msisdn=6285325923850 20251108 131938 outsideloop msisdn=6285325923850 20251108 131938 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285325923850' order by id desc limit 1 Querydel:20251108 131938: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6285325923850','UNREG FUNZONE2') Queryt:20251108 131938: delete from tbl_subscription_Telkomsel_id where msisdn='6285325923850' 20251108 132332 : requested url:/gameverse/idtl/callback_itg.php 20251108 132332 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"dv83pkC0AoukpE5IaD19GeflU6IRR2DQCTgMR5TYl6Wib7xZa7C_11c=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 132332 : mobile encrypted_msisdn:dv83pkC0AoukpE5IaD19GeflU6IRR2DQCTgMR5TYl6Wib7xZa7C_11c= 20251108 132332 : mobile keyword:UNREG FUNZONE2 20251108 132332 : mobile dr_status:1 20251108 132332 output={"msisdn":"6282299347237"} 20251108 132332 msisdn=6282299347237 20251108 132332 outsideloop msisdn=6282299347237 20251108 132332 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282299347237' order by id desc limit 1 Querydel:20251108 132332: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-10-05 23:10:23',now(),'6282299347237','UNREG FUNZONE2') Queryt:20251108 132332: delete from tbl_subscription_Telkomsel_id where msisdn='6282299347237' 20251108 140504 : requested url:/gameverse/idtl/callback_itg.php 20251108 140504 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"cn4j4NTsGyXcjbOwdAtJGUrClx2yT4RtnJmf1OqPDGQfv8Ybr4Xmia8=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 140504 : mobile encrypted_msisdn:cn4j4NTsGyXcjbOwdAtJGUrClx2yT4RtnJmf1OqPDGQfv8Ybr4Xmia8= 20251108 140504 : mobile keyword:REG FUNZONE2 20251108 140504 : mobile dr_status:1 20251108 140504 output={"msisdn":"6282213712616"} 20251108 140504 msisdn=6282213712616 20251108 140504 outsideloop msisdn=6282213712616 20251108 140504 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282213712616' order by id desc limit 1 Query:20251108 140504: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282213712616' Query:20251108 140504: 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 06:41:46',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282213712616','','','REG FUNZONE2') 20251108 140551 : requested url:/gameverse/idtl/callback_itg.php 20251108 140551 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"KStkEQyzJNT8gdu6EwcL2_1BCmp78f_8-HSC64ZV_Nxw89d_zjDGMRc=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 140551 : mobile encrypted_msisdn:KStkEQyzJNT8gdu6EwcL2_1BCmp78f_8-HSC64ZV_Nxw89d_zjDGMRc= 20251108 140551 : mobile keyword:REG FUNZONE2 20251108 140551 : mobile dr_status:1 20251108 140551 output={"msisdn":"6281252721770"} 20251108 140551 msisdn=6281252721770 20251108 140551 outsideloop msisdn=6281252721770 20251108 140551 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281252721770' order by id desc limit 1 Query:20251108 140551: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281252721770' Query:20251108 140551: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-28 17:22:24',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281252721770','','','REG FUNZONE2') 20251108 140557 : requested url:/gameverse/idtl/callback_itg.php 20251108 140557 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"zMzqcwOcSptuE9rGJjR7j3bo9nCSYQAHZNq1U9FdPtwhvK5OLq_KdYg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 140557 : mobile encrypted_msisdn:zMzqcwOcSptuE9rGJjR7j3bo9nCSYQAHZNq1U9FdPtwhvK5OLq_KdYg= 20251108 140557 : mobile keyword:REG FUNZONE2 20251108 140557 : mobile dr_status:1 20251108 140557 output={"msisdn":"6285183852413"} 20251108 140557 msisdn=6285183852413 20251108 140557 outsideloop msisdn=6285183852413 20251108 140557 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285183852413' order by id desc limit 1 Query:20251108 140557: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285183852413' Query:20251108 140557: 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 18:18:08',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285183852413','','','REG FUNZONE2') 20251108 140604 : requested url:/gameverse/idtl/callback_itg.php 20251108 140604 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"loWhty_5_oXRr1Gs526NWuvE4yYc2QUn3Ia4vb7bzfskKi0-8zjOn8M=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 140604 : mobile encrypted_msisdn:loWhty_5_oXRr1Gs526NWuvE4yYc2QUn3Ia4vb7bzfskKi0-8zjOn8M= 20251108 140604 : mobile keyword:REG FUNZONE2 20251108 140604 : mobile dr_status:1 20251108 140604 output={"msisdn":"6282118437221"} 20251108 140604 msisdn=6282118437221 20251108 140604 outsideloop msisdn=6282118437221 20251108 140604 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282118437221' order by id desc limit 1 Query:20251108 140604: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282118437221' Query:20251108 140604: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-08-23 11:25:11',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282118437221','','','REG FUNZONE2') 20251108 140634 : requested url:/gameverse/idtl/callback_itg.php 20251108 140634 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"dWBbvhI98cqiSD_cLU2gKB_rVGQ0UP6zbDQ531BumlIQBoG9Fd0XhM4=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 140634 : mobile encrypted_msisdn:dWBbvhI98cqiSD_cLU2gKB_rVGQ0UP6zbDQ531BumlIQBoG9Fd0XhM4= 20251108 140634 : mobile keyword:REG FUNZONE2 20251108 140634 : mobile dr_status:1 20251108 140634 output={"msisdn":"6282313081083"} 20251108 140634 msisdn=6282313081083 20251108 140634 outsideloop msisdn=6282313081083 20251108 140634 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282313081083' order by id desc limit 1 Query:20251108 140634: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282313081083' Query:20251108 140635: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-08-11 02:31:50',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282313081083','','','REG FUNZONE2') 20251108 140647 : requested url:/gameverse/idtl/callback_itg.php 20251108 140647 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"tEV56LT8-6smu6e6JMRnAGkwbWdubAK63zmQVwr9212tlIcywkMfNyA=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 140647 : mobile encrypted_msisdn:tEV56LT8-6smu6e6JMRnAGkwbWdubAK63zmQVwr9212tlIcywkMfNyA= 20251108 140647 : mobile keyword:REG FUNZONE2 20251108 140647 : mobile dr_status:1 20251108 140647 output={"msisdn":"6282254672905"} 20251108 140647 msisdn=6282254672905 20251108 140647 outsideloop msisdn=6282254672905 20251108 140647 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282254672905' order by id desc limit 1 Query:20251108 140647: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282254672905' Query:20251108 140647: 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 18:44:50',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282254672905','','','REG FUNZONE2') 20251108 141422 : requested url:/gameverse/idtl/callback_itg.php 20251108 141422 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"IXnUF9qah9KaeuO50vMIMpi2ktWfZfRGzI0tajjo02yIN9OsdPMsBg==","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 141422 : mobile encrypted_msisdn:IXnUF9qah9KaeuO50vMIMpi2ktWfZfRGzI0tajjo02yIN9OsdPMsBg== 20251108 141422 : mobile keyword:UNREG FUNZONE2 20251108 141422 : mobile dr_status:1 20251108 141422 output={"msisdn":"628111151558"} 20251108 141422 msisdn=628111151558 20251108 141422 outsideloop msisdn=628111151558 20251108 141422 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='628111151558' order by id desc limit 1 Querydel:20251108 141422: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-07 13:37:11',now(),'628111151558','UNREG FUNZONE2') Queryt:20251108 141422: delete from tbl_subscription_Telkomsel_id where msisdn='628111151558' 20251108 142311 : requested url:/gameverse/idtl/callback_itg.php 20251108 142311 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"KuhX6lFkv6DUWHw1XU5MsVpGdKKFQ9PpvWi88ZL0rEMRVwpS62pifto=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 142311 : mobile encrypted_msisdn:KuhX6lFkv6DUWHw1XU5MsVpGdKKFQ9PpvWi88ZL0rEMRVwpS62pifto= 20251108 142311 : mobile keyword:UNREG FUNZONE2 20251108 142311 : mobile dr_status:1 20251108 142311 output={"msisdn":"6282236321455"} 20251108 142311 msisdn=6282236321455 20251108 142311 outsideloop msisdn=6282236321455 20251108 142311 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282236321455' order by id desc limit 1 Querydel:20251108 142311: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6282236321455','UNREG FUNZONE2') Queryt:20251108 142311: delete from tbl_subscription_Telkomsel_id where msisdn='6282236321455' 20251108 142428 : requested url:/gameverse/idtl/callback_itg.php 20251108 142428 : json:{"adnetid":"96014","clickid":"251108142408000000","dr_status":"0","encrypted_msisdn":"lnlYKuAdP5HZer1QUbTuPg3o8pc7xwkExr8uDHZYpx2QxUx3ATIO0VQ=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625920591701344725"} 20251108 142428 : mobile encrypted_msisdn:lnlYKuAdP5HZer1QUbTuPg3o8pc7xwkExr8uDHZYpx2QxUx3ATIO0VQ= 20251108 142428 : mobile keyword:REG FUNZONE2 20251108 142428 : mobile dr_status:0 20251108 142428 output={"msisdn":"6281354089121"} 20251108 142428 msisdn=6281354089121 20251108 142428 outsideloop msisdn=6281354089121 20251108 142428 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108142408000000' order by id desc limit 1 20251108 142428 subid=690f052d3d600b0342fd8323 20251108 142428 pubid=2 Query:20251108 142428: 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','690f052d3d600b0342fd8323','5','LOW-BL','0','subs','6281354089121','251108142408000000','WEB17625920591701344725','REG FUNZONE2') Query:20251108 142428: 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','690f052d3d600b0342fd8323','5','LOW-BL','0','subs','6281354089121','251108142408000000','WEB17625920591701344725','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f052d3d600b0342fd8323&campid=5:251108142428000000: 20251108 021128 output:200 20251108 142443 : requested url:/gameverse/idtl/callback_itg.php 20251108 142443 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"KzbC2gYF0IrieEZp9vPkFZeapNCXEX8m3z9vA26E1Y70nbKaCsn9Z7k=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 142443 : mobile encrypted_msisdn:KzbC2gYF0IrieEZp9vPkFZeapNCXEX8m3z9vA26E1Y70nbKaCsn9Z7k= 20251108 142443 : mobile keyword:REG FUNZONE1 20251108 142443 : mobile dr_status:1 20251108 142443 output={"msisdn":"6282179234852"} 20251108 142443 msisdn=6282179234852 20251108 142443 outsideloop msisdn=6282179234852 20251108 142443 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282179234852' order by id desc limit 1 Query:20251108 142443: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282179234852' Query:20251108 142443: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-07-30 12:19:04',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282179234852','','','REG FUNZONE1') 20251108 142547 : requested url:/gameverse/idtl/callback_itg.php 20251108 142547 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"QS1GavNu8y9SDAOE55Nzxzyqf9B1pMIU2UDDF36zoVfMvtha86sZqPE=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 142547 : mobile encrypted_msisdn:QS1GavNu8y9SDAOE55Nzxzyqf9B1pMIU2UDDF36zoVfMvtha86sZqPE= 20251108 142547 : mobile keyword:REG FUNZONE1 20251108 142547 : mobile dr_status:1 20251108 142547 output={"msisdn":"6285230315537"} 20251108 142547 msisdn=6285230315537 20251108 142547 outsideloop msisdn=6285230315537 20251108 142547 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285230315537' order by id desc limit 1 Query:20251108 142547: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285230315537' Query:20251108 142547: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-08-05 17:15:31',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6285230315537','','','REG FUNZONE1') 20251108 145311 : requested url:/gameverse/idtl/callback_itg.php 20251108 145311 : json:{"adnetid":"96014","clickid":"251108145304000000","dr_status":"0","encrypted_msisdn":"Twx-WyqeLKbA4x5j_V_rKGJJdkKbXzqsj-Zr4b5nBqbeSNXRfskGBNI=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625937841202443055"} 20251108 145311 : mobile encrypted_msisdn:Twx-WyqeLKbA4x5j_V_rKGJJdkKbXzqsj-Zr4b5nBqbeSNXRfskGBNI= 20251108 145311 : mobile keyword:REG FUNZONE2 20251108 145311 : mobile dr_status:0 20251108 145311 output={"msisdn":"6285378310050"} 20251108 145311 msisdn=6285378310050 20251108 145311 outsideloop msisdn=6285378310050 20251108 145311 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108145304000000' order by id desc limit 1 20251108 145311 subid=690f0bf7509f8b0356089814 20251108 145311 pubid=2 Query:20251108 145311: 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','690f0bf7509f8b0356089814','5','LOW-BL','0','subs','6285378310050','251108145304000000','WEB17625937841202443055','REG FUNZONE2') Query:20251108 145311: 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','690f0bf7509f8b0356089814','5','LOW-BL','0','subs','6285378310050','251108145304000000','WEB17625937841202443055','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f0bf7509f8b0356089814&campid=5:251108145311000000: 20251108 021111 output:200 20251108 150417 : requested url:/gameverse/idtl/callback_itg.php 20251108 150417 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"fecYw3hIon7ZImm6tgigUJGQ7i0swibX5lEWQR1qJ_JH61laJmbTt8g=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 150417 : mobile encrypted_msisdn:fecYw3hIon7ZImm6tgigUJGQ7i0swibX5lEWQR1qJ_JH61laJmbTt8g= 20251108 150417 : mobile keyword:REG FUNZONE2 20251108 150417 : mobile dr_status:1 20251108 150417 output={"msisdn":"6282220128498"} 20251108 150417 msisdn=6282220128498 20251108 150417 outsideloop msisdn=6282220128498 20251108 150417 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282220128498' order by id desc limit 1 Query:20251108 150417: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282220128498' Query:20251108 150417: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-30 07:46:18',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282220128498','','','REG FUNZONE2') 20251108 150507 : requested url:/gameverse/idtl/callback_itg.php 20251108 150507 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"JvYf75kknNYgFaudtsj8c5qqeAhFvCArJK5eMS79nm6RGR4o-yFLQfs=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 150507 : mobile encrypted_msisdn:JvYf75kknNYgFaudtsj8c5qqeAhFvCArJK5eMS79nm6RGR4o-yFLQfs= 20251108 150507 : mobile keyword:REG FUNZONE2 20251108 150507 : mobile dr_status:1 20251108 150507 output={"msisdn":"6281356675092"} 20251108 150507 msisdn=6281356675092 20251108 150507 outsideloop msisdn=6281356675092 20251108 150507 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281356675092' order by id desc limit 1 Query:20251108 150507: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281356675092' Query:20251108 150507: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-10-09 13:49:42',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281356675092','','','REG FUNZONE2') 20251108 150744 : requested url:/gameverse/idtl/callback_itg.php 20251108 150744 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"vGaczpWGDv5vps0mhbvN8gLDUiVp4Ke9FlLkTxzTp9Bvx5pox756XDQ=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 150744 : mobile encrypted_msisdn:vGaczpWGDv5vps0mhbvN8gLDUiVp4Ke9FlLkTxzTp9Bvx5pox756XDQ= 20251108 150744 : mobile keyword:REG FUNZONE2 20251108 150744 : mobile dr_status:1 20251108 150744 output={"msisdn":"6282221238676"} 20251108 150744 msisdn=6282221238676 20251108 150744 outsideloop msisdn=6282221238676 20251108 150744 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282221238676' order by id desc limit 1 Query:20251108 150744: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282221238676' Query:20251108 150744: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values (now(),DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282221238676','','','REG FUNZONE2') 20251108 155504 : requested url:/gameverse/idtl/callback_itg.php 20251108 155504 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"EcTAxulLAHFBioLvlAtbp493LKLm6SMQQjfxHD3KfWtB2APoanyC7DA=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 155504 : mobile encrypted_msisdn:EcTAxulLAHFBioLvlAtbp493LKLm6SMQQjfxHD3KfWtB2APoanyC7DA= 20251108 155504 : mobile keyword:UNREG FUNZONE2 20251108 155504 : mobile dr_status:1 20251108 155504 output={"msisdn":"6282116528062"} 20251108 155504 msisdn=6282116528062 20251108 155504 outsideloop msisdn=6282116528062 20251108 155504 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282116528062' order by id desc limit 1 Querydel:20251108 155504: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-08-20 08:27:49',now(),'6282116528062','UNREG FUNZONE2') Queryt:20251108 155504: delete from tbl_subscription_Telkomsel_id where msisdn='6282116528062' 20251108 162257 : requested url:/gameverse/idtl/callback_itg.php 20251108 162257 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"XaSUttknLN6xnH3MSkGi8UfTNeVXabsyYEUZ-HXlYW7Cd_2ZM6LwLfs=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 162257 : mobile encrypted_msisdn:XaSUttknLN6xnH3MSkGi8UfTNeVXabsyYEUZ-HXlYW7Cd_2ZM6LwLfs= 20251108 162257 : mobile keyword:UNREG FUNZONE2 20251108 162257 : mobile dr_status:1 20251108 162257 output={"msisdn":"6281210193544"} 20251108 162257 msisdn=6281210193544 20251108 162257 outsideloop msisdn=6281210193544 20251108 162257 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281210193544' order by id desc limit 1 Querydel:20251108 162257: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-09-04 11:54:06',now(),'6281210193544','UNREG FUNZONE2') Queryt:20251108 162257: delete from tbl_subscription_Telkomsel_id where msisdn='6281210193544' 20251108 162746 : requested url:/gameverse/idtl/callback_itg.php 20251108 162746 : json:{"adnetid":"96014","clickid":"251108162740000000","dr_status":"0","encrypted_msisdn":"8oYD79s5b96DFdVAB9zimMPwUza0flE3THSbg-un6Lbk-QNOBmimgWM=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17625994601701508793"} 20251108 162746 : mobile encrypted_msisdn:8oYD79s5b96DFdVAB9zimMPwUza0flE3THSbg-un6Lbk-QNOBmimgWM= 20251108 162746 : mobile keyword:REG FUNZONE2 20251108 162746 : mobile dr_status:0 20251108 162746 output={"msisdn":"6281358090082"} 20251108 162746 msisdn=6281358090082 20251108 162746 outsideloop msisdn=6281358090082 20251108 162746 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108162740000000' order by id desc limit 1 20251108 162746 subid=690f222380adf803458fa42e 20251108 162746 pubid=2 Query:20251108 162746: 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','690f222380adf803458fa42e','5','LOW-BL','0','subs','6281358090082','251108162740000000','WEB17625994601701508793','REG FUNZONE2') Query:20251108 162746: 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','690f222380adf803458fa42e','5','LOW-BL','0','subs','6281358090082','251108162740000000','WEB17625994601701508793','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f222380adf803458fa42e&campid=5:251108162746000000: 20251108 041146 output:200 20251108 164136 : requested url:/gameverse/idtl/callback_itg.php 20251108 164136 : json:{"adnetid":"96014","clickid":"251108164127000000","dr_status":"0","encrypted_msisdn":"DTLrt0YTIighWLnhxE6FX-xrOz7gHlXSP2degGagRUQ6pK6xngzL_Oc=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17626002881738483399"} 20251108 164136 : mobile encrypted_msisdn:DTLrt0YTIighWLnhxE6FX-xrOz7gHlXSP2degGagRUQ6pK6xngzL_Oc= 20251108 164136 : mobile keyword:REG FUNZONE2 20251108 164136 : mobile dr_status:0 20251108 164136 output={"msisdn":"6281329591845"} 20251108 164136 msisdn=6281329591845 20251108 164136 outsideloop msisdn=6281329591845 20251108 164136 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108164127000000' order by id desc limit 1 20251108 164136 subid=690f255ea7bddd03499dcac1 20251108 164136 pubid=2 Query:20251108 164136: 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','690f255ea7bddd03499dcac1','5','LOW-BL','0','subs','6281329591845','251108164127000000','WEB17626002881738483399','REG FUNZONE2') Query:20251108 164136: 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','690f255ea7bddd03499dcac1','5','LOW-BL','0','subs','6281329591845','251108164127000000','WEB17626002881738483399','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f255ea7bddd03499dcac1&campid=5:251108164138000000: 20251108 041138 output:200 20251108 164628 : requested url:/gameverse/idtl/callback_itg.php 20251108 164628 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"7NGqRtRGfa_Y70CoiLCrX8np0zG3rH_M1OJzm1htTfGm1qw7Qtz5C1c=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 164628 : mobile encrypted_msisdn:7NGqRtRGfa_Y70CoiLCrX8np0zG3rH_M1OJzm1htTfGm1qw7Qtz5C1c= 20251108 164628 : mobile keyword:UNREG FUNZONE2 20251108 164628 : mobile dr_status:1 20251108 164628 output={"msisdn":"6281329591845"} 20251108 164628 msisdn=6281329591845 20251108 164628 outsideloop msisdn=6281329591845 20251108 164628 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281329591845' order by id desc limit 1 Querydel:20251108 164628: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-08 16:41:36',now(),'6281329591845','UNREG FUNZONE2') Queryt:20251108 164628: delete from tbl_subscription_Telkomsel_id where msisdn='6281329591845' 20251108 165825 : requested url:/gameverse/idtl/callback_itg.php 20251108 165825 : json:{"adnetid":"96014","clickid":"251108165800000000","dr_status":"0","encrypted_msisdn":"1bUtOJtDhytKnti5tsxIETn7TonYw7U-XXkabI6i1GI6CqbGJUalkoI=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17626012861686959165"} 20251108 165825 : mobile encrypted_msisdn:1bUtOJtDhytKnti5tsxIETn7TonYw7U-XXkabI6i1GI6CqbGJUalkoI= 20251108 165825 : mobile keyword:REG FUNZONE2 20251108 165825 : mobile dr_status:0 20251108 165825 output={"msisdn":"6282369415201"} 20251108 165825 msisdn=6282369415201 20251108 165825 outsideloop msisdn=6282369415201 20251108 165825 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108165800000000' order by id desc limit 1 20251108 165825 subid=690f293ea1be210346bd0bb9 20251108 165825 pubid=2 Query:20251108 165825: 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','690f293ea1be210346bd0bb9','5','LOW-BL','0','subs','6282369415201','251108165800000000','WEB17626012861686959165','REG FUNZONE2') Query:20251108 165825: 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','690f293ea1be210346bd0bb9','5','LOW-BL','0','subs','6282369415201','251108165800000000','WEB17626012861686959165','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f293ea1be210346bd0bb9&campid=5:251108165827000000: 20251108 041127 output:200 20251108 171003 : requested url:/gameverse/idtl/callback_itg.php 20251108 171003 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"GIqNgsvIa2qLo3o0xt76QDV-ix8yLp0ibTLGApbIXsi9w47rzaExCRY=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 171003 : mobile encrypted_msisdn:GIqNgsvIa2qLo3o0xt76QDV-ix8yLp0ibTLGApbIXsi9w47rzaExCRY= 20251108 171003 : mobile keyword:REG FUNZONE1 20251108 171003 : mobile dr_status:1 20251108 171003 output={"msisdn":"6282199078236"} 20251108 171003 msisdn=6282199078236 20251108 171003 outsideloop msisdn=6282199078236 20251108 171003 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282199078236' order by id desc limit 1 Query:20251108 171003: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282199078236' Query:20251108 171003: 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 16:39:10',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282199078236','','','REG FUNZONE1') 20251108 171009 : requested url:/gameverse/idtl/callback_itg.php 20251108 171009 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"EmZtpHnXQU1R9G3ko0HeQ-rGj336FIn5pYLVVvS8HXcykS_ThV0SMu8=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 171009 : mobile encrypted_msisdn:EmZtpHnXQU1R9G3ko0HeQ-rGj336FIn5pYLVVvS8HXcykS_ThV0SMu8= 20251108 171009 : mobile keyword:REG FUNZONE1 20251108 171009 : mobile dr_status:1 20251108 171009 output={"msisdn":"6285225149737"} 20251108 171009 msisdn=6285225149737 20251108 171009 outsideloop msisdn=6285225149737 20251108 171009 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285225149737' order by id desc limit 1 Query:20251108 171009: 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:20251108 171009: 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') 20251108 171131 : requested url:/gameverse/idtl/callback_itg.php 20251108 171131 : json:{"adnetid":"96014","clickid":"251108171126000000","dr_status":"0","encrypted_msisdn":"fDiq7_O2nh0dck0zRAGj__j7yNQ3rlR5qF6aTKKosAkRw5lsGZDeCYQ=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB176260208730601414"} 20251108 171131 : mobile encrypted_msisdn:fDiq7_O2nh0dck0zRAGj__j7yNQ3rlR5qF6aTKKosAkRw5lsGZDeCYQ= 20251108 171131 : mobile keyword:REG FUNZONE2 20251108 171131 : mobile dr_status:0 20251108 171131 output={"msisdn":"6282233364798"} 20251108 171131 msisdn=6282233364798 20251108 171131 outsideloop msisdn=6282233364798 20251108 171131 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108171126000000' order by id desc limit 1 20251108 171131 subid=690f2c6577cca50349ecf09f 20251108 171131 pubid=2 Query:20251108 171131: 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','690f2c6577cca50349ecf09f','5','LOW-BL','0','subs','6282233364798','251108171126000000','WEB176260208730601414','REG FUNZONE2') Query:20251108 171131: 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','690f2c6577cca50349ecf09f','5','LOW-BL','0','subs','6282233364798','251108171126000000','WEB176260208730601414','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f2c6577cca50349ecf09f&campid=5:251108171133000000: 20251108 051133 output:200 20251108 171451 : requested url:/gameverse/idtl/callback_itg.php 20251108 171451 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"MNPqp9lEeQeSH40kzPjyMGEsN9U5VwoUcuiBRubM6EsYdVDeMYkukiY=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 171451 : mobile encrypted_msisdn:MNPqp9lEeQeSH40kzPjyMGEsN9U5VwoUcuiBRubM6EsYdVDeMYkukiY= 20251108 171451 : mobile keyword:REG FUNZONE2 20251108 171451 : mobile dr_status:1 20251108 171451 output={"msisdn":"6285222254499"} 20251108 171451 msisdn=6285222254499 20251108 171451 outsideloop msisdn=6285222254499 20251108 171451 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285222254499' order by id desc limit 1 Query:20251108 171451: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285222254499' Query:20251108 171451: 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 14:42:54',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285222254499','','','REG FUNZONE2') 20251108 171506 : requested url:/gameverse/idtl/callback_itg.php 20251108 171506 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"JMg62dKzS2HvAs8lyORySGk7OujaX9CBYo238n2dmf-dFFr8VNPOl-s=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 171506 : mobile encrypted_msisdn:JMg62dKzS2HvAs8lyORySGk7OujaX9CBYo238n2dmf-dFFr8VNPOl-s= 20251108 171506 : mobile keyword:REG FUNZONE2 20251108 171506 : mobile dr_status:1 20251108 171506 output={"msisdn":"6282122665424"} 20251108 171506 msisdn=6282122665424 20251108 171506 outsideloop msisdn=6282122665424 20251108 171506 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282122665424' order by id desc limit 1 Query:20251108 171506: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282122665424' Query:20251108 171506: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-08-25 12:05:12',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282122665424','','','REG FUNZONE2') 20251108 171537 : requested url:/gameverse/idtl/callback_itg.php 20251108 171537 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"VRzp858bt1l9a36XLXMTVrfOG08ZmFNi_Yn7E-sslOlkypwrD2QjiN0=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 171537 : mobile encrypted_msisdn:VRzp858bt1l9a36XLXMTVrfOG08ZmFNi_Yn7E-sslOlkypwrD2QjiN0= 20251108 171537 : mobile keyword:REG FUNZONE2 20251108 171537 : mobile dr_status:1 20251108 171537 output={"msisdn":"6282181382716"} 20251108 171537 msisdn=6282181382716 20251108 171537 outsideloop msisdn=6282181382716 20251108 171537 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282181382716' order by id desc limit 1 Query:20251108 171537: 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:20251108 171537: 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') 20251108 171632 : requested url:/gameverse/idtl/callback_itg.php 20251108 171632 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"4l3XnzdWMqtW7MSnXkry3yOSo9l8v5GhRaBiJNtUZPkubi3k3BrwjEA=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 171632 : mobile encrypted_msisdn:4l3XnzdWMqtW7MSnXkry3yOSo9l8v5GhRaBiJNtUZPkubi3k3BrwjEA= 20251108 171632 : mobile keyword:REG FUNZONE2 20251108 171632 : mobile dr_status:1 20251108 171632 output={"msisdn":"6281239961553"} 20251108 171632 msisdn=6281239961553 20251108 171632 outsideloop msisdn=6281239961553 20251108 171632 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281239961553' order by id desc limit 1 Query:20251108 171632: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281239961553' Query:20251108 171632: 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 16:20:15',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281239961553','','','REG FUNZONE2') 20251108 171700 : requested url:/gameverse/idtl/callback_itg.php 20251108 171700 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"84e3iKEZk68lwKaSKLCjJxY8t8uk69nLg-JytZM5O0JYutVFL5k68t8=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 171700 : mobile encrypted_msisdn:84e3iKEZk68lwKaSKLCjJxY8t8uk69nLg-JytZM5O0JYutVFL5k68t8= 20251108 171700 : mobile keyword:REG FUNZONE2 20251108 171700 : mobile dr_status:1 20251108 171700 output={"msisdn":"6281252326538"} 20251108 171700 msisdn=6281252326538 20251108 171700 outsideloop msisdn=6281252326538 20251108 171700 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281252326538' order by id desc limit 1 Query:20251108 171700: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281252326538' Query:20251108 171700: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-10-12 08:33:18',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281252326538','','','REG FUNZONE2') 20251108 172623 : requested url:/gameverse/idtl/callback_itg.php 20251108 172623 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Rl5wH9KHWqdQ1secMW9UYeENs3s8p1ddrFYCg2f4nsfo280tpRX9p0w=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 172623 : mobile encrypted_msisdn:Rl5wH9KHWqdQ1secMW9UYeENs3s8p1ddrFYCg2f4nsfo280tpRX9p0w= 20251108 172623 : mobile keyword:REG FUNZONE2 20251108 172623 : mobile dr_status:1 20251108 172623 output={"msisdn":"6282198274734"} 20251108 172623 msisdn=6282198274734 20251108 172623 outsideloop msisdn=6282198274734 20251108 172623 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282198274734' order by id desc limit 1 Query:20251108 172623: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282198274734' Query:20251108 172623: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-26 13:20:43',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282198274734','','','REG FUNZONE2') 20251108 172646 : requested url:/gameverse/idtl/callback_itg.php 20251108 172646 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"u1_IKVeNuEhINoGdZW3jDwgXlQ3SmZlxshhyc6Pz-ZNt_gW3ZTdRUWU=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 172646 : mobile encrypted_msisdn:u1_IKVeNuEhINoGdZW3jDwgXlQ3SmZlxshhyc6Pz-ZNt_gW3ZTdRUWU= 20251108 172646 : mobile keyword:REG FUNZONE2 20251108 172646 : mobile dr_status:1 20251108 172646 output={"msisdn":"6282197081401"} 20251108 172646 msisdn=6282197081401 20251108 172646 outsideloop msisdn=6282197081401 20251108 172646 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282197081401' order by id desc limit 1 Query:20251108 172646: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282197081401' Query:20251108 172646: 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 07:18:12',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282197081401','','','REG FUNZONE2') 20251108 172727 : requested url:/gameverse/idtl/callback_itg.php 20251108 172727 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"DrgHXZ4hGz3ZBDiTwGPexgqu6Sxh4DKBsfQMbnBS5UoVIpiY1EXeyV4=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 172727 : mobile encrypted_msisdn:DrgHXZ4hGz3ZBDiTwGPexgqu6Sxh4DKBsfQMbnBS5UoVIpiY1EXeyV4= 20251108 172727 : mobile keyword:REG FUNZONE2 20251108 172727 : mobile dr_status:1 20251108 172727 output={"msisdn":"6281215303962"} 20251108 172727 msisdn=6281215303962 20251108 172727 outsideloop msisdn=6281215303962 20251108 172727 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281215303962' order by id desc limit 1 Query:20251108 172727: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281215303962' Query:20251108 172727: 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 01:35:58',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281215303962','','','REG FUNZONE2') 20251108 172806 : requested url:/gameverse/idtl/callback_itg.php 20251108 172806 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"WokQv_lJTBDkgivMBrWYqNJ3OQ538PZhODrWo2nNpCAmmczaVJp3w1E=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 172806 : mobile encrypted_msisdn:WokQv_lJTBDkgivMBrWYqNJ3OQ538PZhODrWo2nNpCAmmczaVJp3w1E= 20251108 172806 : mobile keyword:REG FUNZONE2 20251108 172806 : mobile dr_status:1 20251108 172806 output={"msisdn":"6281266435352"} 20251108 172806 msisdn=6281266435352 20251108 172806 outsideloop msisdn=6281266435352 20251108 172806 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281266435352' order by id desc limit 1 Query:20251108 172806: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281266435352' Query:20251108 172806: 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 20:07:38',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281266435352','','','REG FUNZONE2') 20251108 173212 : requested url:/gameverse/idtl/callback_itg.php 20251108 173212 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"fA27l2x_Pb6VrygHpCEwOwHJM-zoATWaHXZajZeIxIbozNSi05cabQA=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 173212 : mobile encrypted_msisdn:fA27l2x_Pb6VrygHpCEwOwHJM-zoATWaHXZajZeIxIbozNSi05cabQA= 20251108 173212 : mobile keyword:REG FUNZONE1 20251108 173212 : mobile dr_status:1 20251108 173212 output={"msisdn":"6282213479214"} 20251108 173212 msisdn=6282213479214 20251108 173212 outsideloop msisdn=6282213479214 20251108 173212 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282213479214' order by id desc limit 1 Query:20251108 173212: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282213479214' Query:20251108 173212: 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 11:51:54',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282213479214','','','REG FUNZONE1') 20251108 173308 : requested url:/gameverse/idtl/callback_itg.php 20251108 173308 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"TVPXC2MXqX-W_z5MfpcmtwPgZRqgaM9RGDrRt_lVtDX_Xmkvxcv5hGo=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 173308 : mobile encrypted_msisdn:TVPXC2MXqX-W_z5MfpcmtwPgZRqgaM9RGDrRt_lVtDX_Xmkvxcv5hGo= 20251108 173308 : mobile keyword:REG FUNZONE1 20251108 173308 : mobile dr_status:1 20251108 173308 output={"msisdn":"6281238519160"} 20251108 173308 msisdn=6281238519160 20251108 173308 outsideloop msisdn=6281238519160 20251108 173308 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281238519160' order by id desc limit 1 Query:20251108 173308: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281238519160' Query:20251108 173308: 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 06:08:15',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6281238519160','','','REG FUNZONE1') 20251108 173921 : requested url:/gameverse/idtl/callback_itg.php 20251108 173921 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"-V7uX9MmYL14HgZ3Sxk0WJY9mUvCRRQLesV3j8rV88LTzgm0tXPzRq8=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 173921 : mobile encrypted_msisdn:-V7uX9MmYL14HgZ3Sxk0WJY9mUvCRRQLesV3j8rV88LTzgm0tXPzRq8= 20251108 173921 : mobile keyword:REG FUNZONE2 20251108 173921 : mobile dr_status:1 20251108 173921 output={"msisdn":"6281271607699"} 20251108 173921 msisdn=6281271607699 20251108 173921 outsideloop msisdn=6281271607699 20251108 173921 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281271607699' order by id desc limit 1 Query:20251108 173921: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281271607699' Query:20251108 173921: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values (now(),DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281271607699','','','REG FUNZONE2') 20251108 173929 : requested url:/gameverse/idtl/callback_itg.php 20251108 173929 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"4NKgf2yWpMq7tboEsbGJt2JwPApyMztNtntO_JI2jQbK321Pzti_bLQ=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 173929 : mobile encrypted_msisdn:4NKgf2yWpMq7tboEsbGJt2JwPApyMztNtntO_JI2jQbK321Pzti_bLQ= 20251108 173929 : mobile keyword:UNREG FUNZONE2 20251108 173929 : mobile dr_status:1 20251108 173929 output={"msisdn":"6285385830825"} 20251108 173929 msisdn=6285385830825 20251108 173929 outsideloop msisdn=6285385830825 20251108 173929 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285385830825' order by id desc limit 1 Querydel:20251108 173929: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-10-06 17:06:49',now(),'6285385830825','UNREG FUNZONE2') Queryt:20251108 173929: delete from tbl_subscription_Telkomsel_id where msisdn='6285385830825' 20251108 175936 : requested url:/gameverse/idtl/callback_itg.php 20251108 175936 : json:{"adnetid":"96014","clickid":"251108175915000000","dr_status":"0","encrypted_msisdn":"RuBHLtM6dhH_NoU_ka-vO4T9j6RG8BovKP492xCicMAJMk4z8CG-ehY=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762604970913933606"} 20251108 175936 : mobile encrypted_msisdn:RuBHLtM6dhH_NoU_ka-vO4T9j6RG8BovKP492xCicMAJMk4z8CG-ehY= 20251108 175936 : mobile keyword:REG FUNZONE2 20251108 175936 : mobile dr_status:0 20251108 175936 output={"msisdn":"6282294233450"} 20251108 175936 msisdn=6282294233450 20251108 175936 outsideloop msisdn=6282294233450 20251108 175936 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108175915000000' order by id desc limit 1 20251108 175936 subid=690f379a80adf803459d4061 20251108 175936 pubid=2 Query:20251108 175936: 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','690f379a80adf803459d4061','5','LOW-BL','0','subs','6282294233450','251108175915000000','WEB1762604970913933606','REG FUNZONE2') Query:20251108 175936: 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','690f379a80adf803459d4061','5','LOW-BL','0','subs','6282294233450','251108175915000000','WEB1762604970913933606','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f379a80adf803459d4061&campid=5:251108175938000000: 20251108 051138 output:200 20251108 180117 : requested url:/gameverse/idtl/callback_itg.php 20251108 180117 : json:{"adnetid":"96014","clickid":"251108180108000000","dr_status":"0","encrypted_msisdn":"s5g58-bF3yO9fSIFxdv76crLnnBuPO22vDGdVavuMDIKgJdBXgoj0bU=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762605069426770046"} 20251108 180117 : mobile encrypted_msisdn:s5g58-bF3yO9fSIFxdv76crLnnBuPO22vDGdVavuMDIKgJdBXgoj0bU= 20251108 180117 : mobile keyword:REG FUNZONE2 20251108 180117 : mobile dr_status:0 20251108 180117 output={"msisdn":"6281338240877"} 20251108 180117 msisdn=6281338240877 20251108 180117 outsideloop msisdn=6281338240877 20251108 180117 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108180108000000' order by id desc limit 1 20251108 180117 subid=690f380b303fec03405cf9d0 20251108 180117 pubid=2 Query:20251108 180117: 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','690f380b303fec03405cf9d0','5','LOW-BL','0','subs','6281338240877','251108180108000000','WEB1762605069426770046','REG FUNZONE2') Query:20251108 180117: 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','690f380b303fec03405cf9d0','5','LOW-BL','0','subs','6281338240877','251108180108000000','WEB1762605069426770046','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f380b303fec03405cf9d0&campid=5:251108180119000000: 20251108 061119 output:200 20251108 180315 : requested url:/gameverse/idtl/callback_itg.php 20251108 180315 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"AVD3gIIfVAMAwkIU1HZs4qxB0GoZH955gLIl6CRHzPA5yGK6P_BG25U=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 180315 : mobile encrypted_msisdn:AVD3gIIfVAMAwkIU1HZs4qxB0GoZH955gLIl6CRHzPA5yGK6P_BG25U= 20251108 180315 : mobile keyword:REG FUNZONE2 20251108 180315 : mobile dr_status:1 20251108 180315 output={"msisdn":"6282335401118"} 20251108 180315 msisdn=6282335401118 20251108 180315 outsideloop msisdn=6282335401118 20251108 180315 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282335401118' order by id desc limit 1 Query:20251108 180315: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282335401118' Query:20251108 180315: 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 10:23:21',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282335401118','','','REG FUNZONE2') 20251108 180454 : requested url:/gameverse/idtl/callback_itg.php 20251108 180454 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"M3n7qtPd5m_x4EdHXCGCJzudOB8ck8ejmRxw0zAKkarfsycFaW1FH_M=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 180454 : mobile encrypted_msisdn:M3n7qtPd5m_x4EdHXCGCJzudOB8ck8ejmRxw0zAKkarfsycFaW1FH_M= 20251108 180454 : mobile keyword:REG FUNZONE2 20251108 180454 : mobile dr_status:1 20251108 180454 output={"msisdn":"6281373813916"} 20251108 180454 msisdn=6281373813916 20251108 180454 outsideloop msisdn=6281373813916 20251108 180454 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281373813916' order by id desc limit 1 Query:20251108 180454: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281373813916' Query:20251108 180454: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-08-08 19:18:41',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281373813916','','','REG FUNZONE2') 20251108 180526 : requested url:/gameverse/idtl/callback_itg.php 20251108 180526 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Qb0hU7mYO57Thbq0YwtkLyp2Ct63qlOi9dk81gYCJz6t3WzveRSC_Yg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 180526 : mobile encrypted_msisdn:Qb0hU7mYO57Thbq0YwtkLyp2Ct63qlOi9dk81gYCJz6t3WzveRSC_Yg= 20251108 180526 : mobile keyword:REG FUNZONE2 20251108 180526 : mobile dr_status:1 20251108 180526 output={"msisdn":"6281210419687"} 20251108 180526 msisdn=6281210419687 20251108 180526 outsideloop msisdn=6281210419687 20251108 180526 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281210419687' order by id desc limit 1 Query:20251108 180526: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281210419687' Query:20251108 180527: 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 08:45:29',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281210419687','','','REG FUNZONE2') 20251108 180702 : requested url:/gameverse/idtl/callback_itg.php 20251108 180702 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"vRtm05aoOmd7mNIo4gpk56AD4GjAOzWaER6_Z8mpFmHESAscpcaox9g=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 180702 : mobile encrypted_msisdn:vRtm05aoOmd7mNIo4gpk56AD4GjAOzWaER6_Z8mpFmHESAscpcaox9g= 20251108 180702 : mobile keyword:UNREG FUNZONE2 20251108 180702 : mobile dr_status:1 20251108 180702 output={"msisdn":"6281210419687"} 20251108 180702 msisdn=6281210419687 20251108 180702 outsideloop msisdn=6281210419687 20251108 180702 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281210419687' order by id desc limit 1 Querydel:20251108 180702: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-08-20 08:45:29',now(),'6281210419687','UNREG FUNZONE2') Queryt:20251108 180702: delete from tbl_subscription_Telkomsel_id where msisdn='6281210419687' 20251108 181350 : requested url:/gameverse/idtl/callback_itg.php 20251108 181350 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"LxBbs99LKKuVLQd24y6bebtsJ1CrvbSKLXBvZGZ0yA0S_lYeejgj1tg=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 181350 : mobile encrypted_msisdn:LxBbs99LKKuVLQd24y6bebtsJ1CrvbSKLXBvZGZ0yA0S_lYeejgj1tg= 20251108 181350 : mobile keyword:REG FUNZONE2 20251108 181350 : mobile dr_status:1 20251108 181350 output={"msisdn":"6285242624431"} 20251108 181350 msisdn=6285242624431 20251108 181350 outsideloop msisdn=6285242624431 20251108 181350 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285242624431' order by id desc limit 1 Query:20251108 181350: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285242624431' Query:20251108 181350: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-10-28 08:48:28',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285242624431','','','REG FUNZONE2') 20251108 181628 : requested url:/gameverse/idtl/callback_itg.php 20251108 181628 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"tk3HrR8NEZNPqAX66bok8TTouFv9UGPLdfAJYjB0O6UzxRI9giFMNGY=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 181628 : mobile encrypted_msisdn:tk3HrR8NEZNPqAX66bok8TTouFv9UGPLdfAJYjB0O6UzxRI9giFMNGY= 20251108 181628 : mobile keyword:REG FUNZONE2 20251108 181628 : mobile dr_status:1 20251108 181628 output={"msisdn":"6282338228793"} 20251108 181628 msisdn=6282338228793 20251108 181628 outsideloop msisdn=6282338228793 20251108 181628 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282338228793' order by id desc limit 1 Query:20251108 181628: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282338228793' Query:20251108 181628: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-10-10 18:19:13',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282338228793','','','REG FUNZONE2') 20251108 181903 : requested url:/gameverse/idtl/callback_itg.php 20251108 181903 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"sBuV-sIlkEtziHs9MxafRvyCC5UcTdp9_CxO8-bNypEqvdeDHRnuuAw=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 181903 : mobile encrypted_msisdn:sBuV-sIlkEtziHs9MxafRvyCC5UcTdp9_CxO8-bNypEqvdeDHRnuuAw= 20251108 181903 : mobile keyword:REG FUNZONE1 20251108 181903 : mobile dr_status:1 20251108 181903 output={"msisdn":"6281339818655"} 20251108 181903 msisdn=6281339818655 20251108 181903 outsideloop msisdn=6281339818655 20251108 181903 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281339818655' order by id desc limit 1 Query:20251108 181903: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281339818655' Query:20251108 181903: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-08-02 10:03:14',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6281339818655','','','REG FUNZONE1') 20251108 182028 : requested url:/gameverse/idtl/callback_itg.php 20251108 182028 : json:{"adnetid":"96014","clickid":"251108182011000000","dr_status":"0","encrypted_msisdn":"zVsNI-ndTOQ_tCElb_nLeWrpUkw7lHJgGuuPo6pN3q09w9VTPjF1p0A=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762606213719904946"} 20251108 182028 : mobile encrypted_msisdn:zVsNI-ndTOQ_tCElb_nLeWrpUkw7lHJgGuuPo6pN3q09w9VTPjF1p0A= 20251108 182028 : mobile keyword:REG FUNZONE2 20251108 182028 : mobile dr_status:0 20251108 182028 output={"msisdn":"6282291383392"} 20251108 182028 msisdn=6282291383392 20251108 182028 outsideloop msisdn=6282291383392 20251108 182028 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108182011000000' order by id desc limit 1 20251108 182028 subid=690f3c82be80f9034562c1b7 20251108 182028 pubid=2 Query:20251108 182028: 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','690f3c82be80f9034562c1b7','5','LOW-BL','0','subs','6282291383392','251108182011000000','WEB1762606213719904946','REG FUNZONE2') Query:20251108 182028: 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','690f3c82be80f9034562c1b7','5','LOW-BL','0','subs','6282291383392','251108182011000000','WEB1762606213719904946','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f3c82be80f9034562c1b7&campid=5:251108182030000000: 20251108 061130 output:200 20251108 182718 : requested url:/gameverse/idtl/callback_itg.php 20251108 182718 : json:{"adnetid":"96014","clickid":"251108182713000000","dr_status":"0","encrypted_msisdn":"_JxV-cZ4MIYeNqMadDpIIUva0IyOpVfQNGKRtBSEo7XVFn6sSTonxyg=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762606634232885390"} 20251108 182718 : mobile encrypted_msisdn:_JxV-cZ4MIYeNqMadDpIIUva0IyOpVfQNGKRtBSEo7XVFn6sSTonxyg= 20251108 182718 : mobile keyword:REG FUNZONE2 20251108 182718 : mobile dr_status:0 20251108 182718 output={"msisdn":"6285333354494"} 20251108 182718 msisdn=6285333354494 20251108 182718 outsideloop msisdn=6285333354494 20251108 182718 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108182713000000' order by id desc limit 1 20251108 182718 subid=690f3e2841215e0344d1a4c0 20251108 182718 pubid=2 Query:20251108 182718: 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','690f3e2841215e0344d1a4c0','5','LOW-BL','0','subs','6285333354494','251108182713000000','WEB1762606634232885390','REG FUNZONE2') Query:20251108 182718: 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','690f3e2841215e0344d1a4c0','5','LOW-BL','0','subs','6285333354494','251108182713000000','WEB1762606634232885390','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f3e2841215e0344d1a4c0&campid=5:251108182720000000: 20251108 061120 output:200 20251108 184124 : requested url:/gameverse/idtl/callback_itg.php 20251108 184124 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"qGaFIE2_OSwhfgaE0M_OfCRYEA2lKHPr29t_uFkhQ3ZucG2t9nI7LFU=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 184124 : mobile encrypted_msisdn:qGaFIE2_OSwhfgaE0M_OfCRYEA2lKHPr29t_uFkhQ3ZucG2t9nI7LFU= 20251108 184124 : mobile keyword:UNREG FUNZONE2 20251108 184124 : mobile dr_status:1 20251108 184124 output={"msisdn":"6281371790943"} 20251108 184124 msisdn=6281371790943 20251108 184124 outsideloop msisdn=6281371790943 20251108 184124 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281371790943' order by id desc limit 1 Querydel:20251108 184124: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6281371790943','UNREG FUNZONE2') Queryt:20251108 184124: delete from tbl_subscription_Telkomsel_id where msisdn='6281371790943' 20251108 185102 : requested url:/gameverse/idtl/callback_itg.php 20251108 185102 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"cL4Ati92b3dfbv5jpW2bWUypIE9cie1AlUAs6Ypaebgcx8Q5RQHGeRw=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 185102 : mobile encrypted_msisdn:cL4Ati92b3dfbv5jpW2bWUypIE9cie1AlUAs6Ypaebgcx8Q5RQHGeRw= 20251108 185102 : mobile keyword:UNREG FUNZONE2 20251108 185102 : mobile dr_status:1 20251108 185102 output={"msisdn":"6282246139232"} 20251108 185102 msisdn=6282246139232 20251108 185102 outsideloop msisdn=6282246139232 20251108 185102 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282246139232' order by id desc limit 1 Querydel:20251108 185102: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6282246139232','UNREG FUNZONE2') Queryt:20251108 185102: delete from tbl_subscription_Telkomsel_id where msisdn='6282246139232' 20251108 185844 : requested url:/gameverse/idtl/callback_itg.php 20251108 185844 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"LqEU_NcyjN7PMdwO9R778gRrdkLmZZoLe_3DBf3SXZcBNmiN1x_90FM=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 185844 : mobile encrypted_msisdn:LqEU_NcyjN7PMdwO9R778gRrdkLmZZoLe_3DBf3SXZcBNmiN1x_90FM= 20251108 185844 : mobile keyword:UNREG FUNZONE2 20251108 185844 : mobile dr_status:1 20251108 185844 output={"msisdn":"6285333354494"} 20251108 185844 msisdn=6285333354494 20251108 185844 outsideloop msisdn=6285333354494 20251108 185844 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285333354494' order by id desc limit 1 Querydel:20251108 185844: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values ('2025-11-08 18:27:18',now(),'6285333354494','UNREG FUNZONE2') Queryt:20251108 185844: delete from tbl_subscription_Telkomsel_id where msisdn='6285333354494' 20251108 190556 : requested url:/gameverse/idtl/callback_itg.php 20251108 190556 : json:{"adnetid":"96014","clickid":"251108190538000000","dr_status":"0","encrypted_msisdn":"x-qeDGQ7cDcu2gLvnWfWaVLlvvpKJj5SULVCPbfUYRsyn3tFfEu4dWc=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17626089381069147028"} 20251108 190556 : mobile encrypted_msisdn:x-qeDGQ7cDcu2gLvnWfWaVLlvvpKJj5SULVCPbfUYRsyn3tFfEu4dWc= 20251108 190556 : mobile keyword:REG FUNZONE2 20251108 190556 : mobile dr_status:0 20251108 190556 output={"msisdn":"6282211539175"} 20251108 190556 msisdn=6282211539175 20251108 190556 outsideloop msisdn=6282211539175 20251108 190556 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108190538000000' order by id desc limit 1 20251108 190556 subid=690f4729303fec034068844d 20251108 190556 pubid=2 Query:20251108 190556: 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','690f4729303fec034068844d','5','LOW-BL','0','subs','6282211539175','251108190538000000','WEB17626089381069147028','REG FUNZONE2') Query:20251108 190556: 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','690f4729303fec034068844d','5','LOW-BL','0','subs','6282211539175','251108190538000000','WEB17626089381069147028','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f4729303fec034068844d&campid=5:251108190556000000: 20251108 071156 output:200 20251108 193048 : requested url:/gameverse/idtl/callback_itg.php 20251108 193048 : json:{"adnetid":"96014","clickid":"251108193038000000","dr_status":"0","encrypted_msisdn":"AEG0DMR1H9oihhe5uJtBcbLbUuWQRmpVH-2l24e8NO5l_IHhjY1mJ3w=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762610439466105462"} 20251108 193048 : mobile encrypted_msisdn:AEG0DMR1H9oihhe5uJtBcbLbUuWQRmpVH-2l24e8NO5l_IHhjY1mJ3w= 20251108 193048 : mobile keyword:REG FUNZONE2 20251108 193048 : mobile dr_status:0 20251108 193048 output={"msisdn":"6282296628673"} 20251108 193048 msisdn=6282296628673 20251108 193048 outsideloop msisdn=6282296628673 20251108 193048 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108193038000000' order by id desc limit 1 20251108 193048 subid=690f4d053d600b03422fb8b9 20251108 193048 pubid=2 Query:20251108 193048: 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','690f4d053d600b03422fb8b9','5','LOW-BL','0','subs','6282296628673','251108193038000000','WEB1762610439466105462','REG FUNZONE2') Query:20251108 193048: 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','690f4d053d600b03422fb8b9','5','LOW-BL','0','subs','6282296628673','251108193038000000','WEB1762610439466105462','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f4d053d600b03422fb8b9&campid=5:251108193048000000: 20251108 071148 output:200 20251108 203937 : requested url:/gameverse/idtl/callback_itg.php 20251108 203937 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"GpGH7UIrp6c2sqW5N5qIkIWATVAaywSirDfBNXwbRPAQDHrdIRKq5A8=","keyword":"REG FUNZONE1","req_type":"renewal","trx_id":""} 20251108 203937 : mobile encrypted_msisdn:GpGH7UIrp6c2sqW5N5qIkIWATVAaywSirDfBNXwbRPAQDHrdIRKq5A8= 20251108 203937 : mobile keyword:REG FUNZONE1 20251108 203937 : mobile dr_status:1 20251108 203937 output={"msisdn":"6282239120586"} 20251108 203937 msisdn=6282239120586 20251108 203937 outsideloop msisdn=6282239120586 20251108 203937 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282239120586' order by id desc limit 1 Query:20251108 203937: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=2220.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282239120586' Query:20251108 203937: 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 14:45:39',DATE_SUB(now(), INTERVAL -3 DAY),now(),2220.00,'','','','RENEW-SUCCESS','1','renewal','6282239120586','','','REG FUNZONE1') 20251108 204446 : requested url:/gameverse/idtl/callback_itg.php 20251108 204446 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"_0QfAmTlYunWO_QjfpQUReRqG4a-8151JRdQKbCl2xj3xD1G42xSPw==","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 204446 : mobile encrypted_msisdn:_0QfAmTlYunWO_QjfpQUReRqG4a-8151JRdQKbCl2xj3xD1G42xSPw== 20251108 204446 : mobile keyword:REG FUNZONE2 20251108 204446 : mobile dr_status:1 20251108 204446 output={"msisdn":"628115252277"} 20251108 204446 msisdn=628115252277 20251108 204446 outsideloop msisdn=628115252277 20251108 204446 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='628115252277' order by id desc limit 1 Query:20251108 204446: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='628115252277' Query:20251108 204447: 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 18:36:06',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','628115252277','','','REG FUNZONE2') 20251108 204450 : requested url:/gameverse/idtl/callback_itg.php 20251108 204450 : json:{"adnetid":"96014","clickid":"251108204444000000","dr_status":"0","encrypted_msisdn":"rvGCRVbL77UoKRhQ7Zp8ZXJis2W-dsUm-GvvOEPmEcKVGrGzvHhm8vo=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762614884627378866"} 20251108 204450 : mobile encrypted_msisdn:rvGCRVbL77UoKRhQ7Zp8ZXJis2W-dsUm-GvvOEPmEcKVGrGzvHhm8vo= 20251108 204450 : mobile keyword:REG FUNZONE2 20251108 204450 : mobile dr_status:0 20251108 204450 output={"msisdn":"6282334199041"} 20251108 204450 msisdn=6282334199041 20251108 204450 outsideloop msisdn=6282334199041 20251108 204450 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108204444000000' order by id desc limit 1 20251108 204450 subid=690f5e6305027b0348c14270 20251108 204450 pubid=2 Query:20251108 204450: 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','690f5e6305027b0348c14270','5','LOW-BL','0','subs','6282334199041','251108204444000000','WEB1762614884627378866','REG FUNZONE2') Query:20251108 204450: 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','690f5e6305027b0348c14270','5','LOW-BL','0','subs','6282334199041','251108204444000000','WEB1762614884627378866','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f5e6305027b0348c14270&campid=5:251108204450000000: 20251108 081150 output:200 20251108 204857 : requested url:/gameverse/idtl/callback_itg.php 20251108 204857 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"M_-FGLANtZ5XeIGqa_OfnAPInsOthsYfDYmJ0vMpwK-MbytJQVTWRTk=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 204857 : mobile encrypted_msisdn:M_-FGLANtZ5XeIGqa_OfnAPInsOthsYfDYmJ0vMpwK-MbytJQVTWRTk= 20251108 204857 : mobile keyword:UNREG FUNZONE2 20251108 204857 : mobile dr_status:1 20251108 204857 output={"msisdn":"6282330525556"} 20251108 204857 msisdn=6282330525556 20251108 204857 outsideloop msisdn=6282330525556 20251108 204857 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282330525556' order by id desc limit 1 Querydel:20251108 204858: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6282330525556','UNREG FUNZONE2') Queryt:20251108 204858: delete from tbl_subscription_Telkomsel_id where msisdn='6282330525556' 20251108 205602 : requested url:/gameverse/idtl/callback_itg.php 20251108 205602 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"4hk5dLubOFDWrAK1qscW7PwZBHdst6IS07UlFs0-YRq2qyrvbyVSepk=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 205602 : mobile encrypted_msisdn:4hk5dLubOFDWrAK1qscW7PwZBHdst6IS07UlFs0-YRq2qyrvbyVSepk= 20251108 205602 : mobile keyword:REG FUNZONE2 20251108 205602 : mobile dr_status:1 20251108 205602 output={"msisdn":"6282254494427"} 20251108 205602 msisdn=6282254494427 20251108 205602 outsideloop msisdn=6282254494427 20251108 205602 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282254494427' order by id desc limit 1 Query:20251108 205602: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282254494427' Query:20251108 205602: 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 08:45:27',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282254494427','','','REG FUNZONE2') 20251108 205634 : requested url:/gameverse/idtl/callback_itg.php 20251108 205634 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"FAU30s1KNfhJAMb7Ji_6eFpjD1ZpJDY2C9Gf6c4tjD-PqOhb_i8tIhM=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 205634 : mobile encrypted_msisdn:FAU30s1KNfhJAMb7Ji_6eFpjD1ZpJDY2C9Gf6c4tjD-PqOhb_i8tIhM= 20251108 205634 : mobile keyword:REG FUNZONE2 20251108 205634 : mobile dr_status:1 20251108 205634 output={"msisdn":"6285255994436"} 20251108 205634 msisdn=6285255994436 20251108 205634 outsideloop msisdn=6285255994436 20251108 205634 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285255994436' order by id desc limit 1 Query:20251108 205634: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285255994436' Query:20251108 205634: 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 07:15:06',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285255994436','','','REG FUNZONE2') 20251108 205750 : requested url:/gameverse/idtl/callback_itg.php 20251108 205750 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"JSg-_RsJbBojUoj1UA4teWuHHXBBN3l8ARWPtm06K2nEiinCkBl2DBo=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 205750 : mobile encrypted_msisdn:JSg-_RsJbBojUoj1UA4teWuHHXBBN3l8ARWPtm06K2nEiinCkBl2DBo= 20251108 205750 : mobile keyword:REG FUNZONE2 20251108 205750 : mobile dr_status:1 20251108 205750 output={"msisdn":"6281212283792"} 20251108 205750 msisdn=6281212283792 20251108 205750 outsideloop msisdn=6281212283792 20251108 205750 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6281212283792' order by id desc limit 1 Query:20251108 205750: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6281212283792' Query:20251108 205750: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-08-24 14:40:13',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6281212283792','','','REG FUNZONE2') 20251108 213248 : requested url:/gameverse/idtl/callback_itg.php 20251108 213248 : json:{"adnetid":"96014","clickid":"251108213243000000","dr_status":"0","encrypted_msisdn":"lpS0DZTa4PP3ude3cWPPcaOmIbhcYF8n_8N2NpmZrvopBdgLVhbBK6M=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17626177651628647895"} 20251108 213248 : mobile encrypted_msisdn:lpS0DZTa4PP3ude3cWPPcaOmIbhcYF8n_8N2NpmZrvopBdgLVhbBK6M= 20251108 213248 : mobile keyword:REG FUNZONE2 20251108 213248 : mobile dr_status:0 20251108 213248 output={"msisdn":"6282230840716"} 20251108 213248 msisdn=6282230840716 20251108 213248 outsideloop msisdn=6282230840716 20251108 213248 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108213243000000' order by id desc limit 1 20251108 213248 subid=690f69a2509f8b03564c5309 20251108 213248 pubid=2 Query:20251108 213248: 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','690f69a2509f8b03564c5309','5','LOW-BL','0','subs','6282230840716','251108213243000000','WEB17626177651628647895','REG FUNZONE2') Query:20251108 213248: 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','690f69a2509f8b03564c5309','5','LOW-BL','0','subs','6282230840716','251108213243000000','WEB17626177651628647895','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f69a2509f8b03564c5309&campid=5:251108213250000000: 20251108 091150 output:200 20251108 213853 : requested url:/gameverse/idtl/callback_itg.php 20251108 213853 : json:{"adnetid":"96014","clickid":"251108213849000000","dr_status":"0","encrypted_msisdn":"uwjDJ_NB2AyJtb2ZzW7n8lFXYhXjaX88ihiabD8Bo7QhXwzadXpI42U=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17626181301631080681"} 20251108 213853 : mobile encrypted_msisdn:uwjDJ_NB2AyJtb2ZzW7n8lFXYhXjaX88ihiabD8Bo7QhXwzadXpI42U= 20251108 213853 : mobile keyword:REG FUNZONE2 20251108 213853 : mobile dr_status:0 20251108 213853 output={"msisdn":"6281357431873"} 20251108 213853 msisdn=6281357431873 20251108 213853 outsideloop msisdn=6281357431873 20251108 213853 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108213849000000' order by id desc limit 1 20251108 213853 subid=690f6b11e456020347063887 20251108 213853 pubid=2 Query:20251108 213853: 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','690f6b11e456020347063887','5','LOW-BL','0','subs','6281357431873','251108213849000000','WEB17626181301631080681','REG FUNZONE2') Query:20251108 213853: 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','690f6b11e456020347063887','5','LOW-BL','0','subs','6281357431873','251108213849000000','WEB17626181301631080681','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f6b11e456020347063887&campid=5:251108213855000000: 20251108 091155 output:200 20251108 215148 : requested url:/gameverse/idtl/callback_itg.php 20251108 215148 : json:{"adnetid":"96014","clickid":"251108215141000000","dr_status":"0","encrypted_msisdn":"kcEP3HhUCfeHtaADsitErfQ6Ceg9NbzLaGSaToe3SOc2PeK4yVlr784=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762618902415685855"} 20251108 215148 : mobile encrypted_msisdn:kcEP3HhUCfeHtaADsitErfQ6Ceg9NbzLaGSaToe3SOc2PeK4yVlr784= 20251108 215148 : mobile keyword:REG FUNZONE2 20251108 215148 : mobile dr_status:0 20251108 215148 output={"msisdn":"6282124151250"} 20251108 215148 msisdn=6282124151250 20251108 215148 outsideloop msisdn=6282124151250 20251108 215148 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108215141000000' order by id desc limit 1 20251108 215148 subid=690f6e14284fed03434f9f79 20251108 215148 pubid=2 Query:20251108 215148: 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','690f6e14284fed03434f9f79','5','LOW-BL','0','subs','6282124151250','251108215141000000','WEB1762618902415685855','REG FUNZONE2') Query:20251108 215148: 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','690f6e14284fed03434f9f79','5','LOW-BL','0','subs','6282124151250','251108215141000000','WEB1762618902415685855','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f6e14284fed03434f9f79&campid=5:251108215150000000: 20251108 091150 output:200 20251108 224205 : requested url:/gameverse/idtl/callback_itg.php 20251108 224205 : json:{"adnetid":"96014","clickid":"251108224157000000","dr_status":"0","encrypted_msisdn":"-Igt1LQ4d3GGqt6chFVzG1GOdlaRBPaGEia8f4ciDUQQPLHz4WxU0oc=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB17626219181747188332"} 20251108 224205 : mobile encrypted_msisdn:-Igt1LQ4d3GGqt6chFVzG1GOdlaRBPaGEia8f4ciDUQQPLHz4WxU0oc= 20251108 224205 : mobile keyword:REG FUNZONE2 20251108 224205 : mobile dr_status:0 20251108 224205 output={"msisdn":"6282228477425"} 20251108 224205 msisdn=6282228477425 20251108 224205 outsideloop msisdn=6282228477425 20251108 224205 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108224157000000' order by id desc limit 1 20251108 224205 subid=690f79dcc1503903428803cc 20251108 224205 pubid=2 Query:20251108 224205: 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','690f79dcc1503903428803cc','5','LOW-BL','0','subs','6282228477425','251108224157000000','WEB17626219181747188332','REG FUNZONE2') Query:20251108 224205: 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','690f79dcc1503903428803cc','5','LOW-BL','0','subs','6282228477425','251108224157000000','WEB17626219181747188332','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f79dcc1503903428803cc&campid=5:251108224207000000: 20251108 101107 output:200 20251108 231427 : requested url:/gameverse/idtl/callback_itg.php 20251108 231427 : json:{"adnetid":"96014","clickid":"251108231416000000","dr_status":"0","encrypted_msisdn":"ZMB4SL9Wf-72O2VYdLoJCUWKRBJcyEGKmBG73e3JYK2neA6CwuoiZUk=","keyword":"REG FUNZONE2","req_type":"subs","trx_id":"WEB1762623863509578639"} 20251108 231427 : mobile encrypted_msisdn:ZMB4SL9Wf-72O2VYdLoJCUWKRBJcyEGKmBG73e3JYK2neA6CwuoiZUk= 20251108 231427 : mobile keyword:REG FUNZONE2 20251108 231427 : mobile dr_status:0 20251108 231427 output={"msisdn":"6281254944676"} 20251108 231427 msisdn=6281254944676 20251108 231427 outsideloop msisdn=6281254944676 20251108 231427 : Querypub:select pubid as pubid,subid as subid , campid as campid from tbl_wapidentify_idtelcmsel where referid='251108231416000000' order by id desc limit 1 20251108 231427 subid=690f816c473c320347a764f7 20251108 231427 pubid=2 Query:20251108 231427: 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','690f816c473c320347a764f7','5','LOW-BL','0','subs','6281254944676','251108231416000000','WEB1762623863509578639','REG FUNZONE2') Query:20251108 231427: 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','690f816c473c320347a764f7','5','LOW-BL','0','subs','6281254944676','251108231416000000','WEB1762623863509578639','REG FUNZONE2') sp_subuser_or callback sent http://3.109.77.77:8080/postback/callback?clickid=690f816c473c320347a764f7&campid=5:251108231429000000: 20251108 111129 output:200 20251108 231825 : requested url:/gameverse/idtl/callback_itg.php 20251108 231825 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"ObItdKRXK1yUYGgRKoRlLSBNIZr9MlZ6uQTZsvPCr9w9pru8V-PgwZk=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 231825 : mobile encrypted_msisdn:ObItdKRXK1yUYGgRKoRlLSBNIZr9MlZ6uQTZsvPCr9w9pru8V-PgwZk= 20251108 231825 : mobile keyword:REG FUNZONE2 20251108 231825 : mobile dr_status:1 20251108 231825 output={"msisdn":"6282233035779"} 20251108 231825 msisdn=6282233035779 20251108 231825 outsideloop msisdn=6282233035779 20251108 231825 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282233035779' order by id desc limit 1 Query:20251108 231825: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282233035779' Query:20251108 231825: 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 11:48:25',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282233035779','','','REG FUNZONE2') 20251108 231848 : requested url:/gameverse/idtl/callback_itg.php 20251108 231848 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"a5QfsO-ihhsorqYbylwGaSzBEPE_rvyG0cCUCH5jdAaUi0UC36JYLUI=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 231848 : mobile encrypted_msisdn:a5QfsO-ihhsorqYbylwGaSzBEPE_rvyG0cCUCH5jdAaUi0UC36JYLUI= 20251108 231848 : mobile keyword:REG FUNZONE2 20251108 231848 : mobile dr_status:1 20251108 231848 output={"msisdn":"6282122278758"} 20251108 231848 msisdn=6282122278758 20251108 231848 outsideloop msisdn=6282122278758 20251108 231848 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282122278758' order by id desc limit 1 Query:20251108 231848: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282122278758' Query:20251108 231848: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-09-27 08:36:06',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282122278758','','','REG FUNZONE2') 20251108 231945 : requested url:/gameverse/idtl/callback_itg.php 20251108 231945 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"Q-GEfPLgMPlXpyT1zXAsqrcf-T-CqvbPkP5tpe4PCHB_ZymmMu9xQDA=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 231945 : mobile encrypted_msisdn:Q-GEfPLgMPlXpyT1zXAsqrcf-T-CqvbPkP5tpe4PCHB_ZymmMu9xQDA= 20251108 231945 : mobile keyword:REG FUNZONE2 20251108 231945 : mobile dr_status:1 20251108 231945 output={"msisdn":"6282152781276"} 20251108 231945 msisdn=6282152781276 20251108 231945 outsideloop msisdn=6282152781276 20251108 231945 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6282152781276' order by id desc limit 1 Query:20251108 231945: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6282152781276' Query:20251108 231945: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values ('2025-10-09 16:48:10',DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6282152781276','','','REG FUNZONE2') 20251108 232254 : requested url:/gameverse/idtl/callback_itg.php 20251108 232254 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"TGXn65TE6DsX8pym3hDLXVESGWvKsDmwVI48o4z3NRlBxyu2A1Pqd24=","keyword":"REG FUNZONE2","req_type":"renewal","trx_id":""} 20251108 232254 : mobile encrypted_msisdn:TGXn65TE6DsX8pym3hDLXVESGWvKsDmwVI48o4z3NRlBxyu2A1Pqd24= 20251108 232254 : mobile keyword:REG FUNZONE2 20251108 232254 : mobile dr_status:1 20251108 232254 output={"msisdn":"6285255864442"} 20251108 232254 msisdn=6285255864442 20251108 232254 outsideloop msisdn=6285255864442 20251108 232254 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285255864442' order by id desc limit 1 Query:20251108 232254: update tbl_subscription_Telkomsel_id set validitydate=DATE_SUB(now(), INTERVAL -3 DAY),lastupdatedate=now(),price=3330.00,statuss='RENEW-SUCCESS' WHERE msisdn='6285255864442' Query:20251108 232254: insert into tbl_subscription_trans_Telkomsel_id(regdate,validitydate,lastupdatedate,price,pubid,subid,campid,statuss,statuscode,status,msisdn,uniqueid,trxId,keyword) values (now(),DATE_SUB(now(), INTERVAL -3 DAY),now(),3330.00,'','','','RENEW-SUCCESS','1','renewal','6285255864442','','','REG FUNZONE2') 20251108 232533 : requested url:/gameverse/idtl/callback_itg.php 20251108 232533 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"-86pe-IbMXu7pxe1D8X6qKCMFq3kk29L5uJDdi0hdyAkpsErS3s37Ho=","keyword":"UNREG FUNZONE2","req_type":"unsubs","trx_id":""} 20251108 232533 : mobile encrypted_msisdn:-86pe-IbMXu7pxe1D8X6qKCMFq3kk29L5uJDdi0hdyAkpsErS3s37Ho= 20251108 232533 : mobile keyword:UNREG FUNZONE2 20251108 232533 : mobile dr_status:1 20251108 232533 output={"msisdn":"6285255864442"} 20251108 232533 msisdn=6285255864442 20251108 232533 outsideloop msisdn=6285255864442 20251108 232533 : Querypubrenew:select * from tbl_subscription_Telkomsel_id where msisdn='6285255864442' order by id desc limit 1 Querydel:20251108 232533: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6285255864442','UNREG FUNZONE2') Queryt:20251108 232533: delete from tbl_subscription_Telkomsel_id where msisdn='6285255864442'