halo gan mau tanya dong kalo mau tambahin cash coin gimana ya caranya??
PLEASE SUPPORT US BY CLICK THE ADS LINK, TURN OFF ADBLOCK
OR YOU CAN SUPPORT US THROUGH PAYPAL / SAWERIA
THE FORUM WILL BE SHUT DOWN IN THE END OF THE YEAR
IF WE GOT NO SUPPORT ANYMORE 
![[ASK] Cara tambahin cash coin Empty](https://2img.net/i/empty.gif)
[ASK] Cara tambahin cash coinMay 6th 2020, 13:05Re: [ASK] Cara tambahin cash coinMay 11th 2020, 13:44Code:
/****** Bacuy`s Area ******/
/****** Script add premium, tanpa harus mendelete ******/
/****** jika sudah ada pada table ******/
DECLARE @id VARCHAR(13)
DECLARE @status int
DECLARE @lama int
DECLARE @cash int
/****** Your Name ******/
SET @id = 'strom'
/****** Set 2 for turn on Premium or Set 1 for turn off Premium ******/
SET @status = '2'
/****** How long players get premium service (in days) exemple : 1 for 1 days, 2 for 2 days, 3 for 3days. ******/
SET @lama = '30'
/****** Ini gak perlu di isi, ini query khusus add premium aja ******/
SET @cash = '0'
/************************************************************************************************************************************************/
declare @count numeric(18, 0)
select @count = COUNT(*) from [BILLING].[dbo].[tbl_UserStatus] where id = @id
if (@count = 0)
begin
INSERT INTO [BILLING].[dbo].[tbl_UserStatus]
(
[id],
[Status],
[DTStartPrem],
[DTEndPrem],
[Cash]
)
VALUES
(
@id,
@status,
CONVERT(datetime,GETDATE()),
CONVERT(datetime,GETDATE()+@lama),
@cash
)
end
else
begin
update [BILLING].[dbo].[tbl_UserStatus]
set [Status] = @status,
[DTStartPrem] = CONVERT(datetime,GETDATE()),
[DTEndPrem] = CONVERT(datetime,GETDATE()+@lama),
[Cash] = @cash
where id = @id
end
/***********************************************************************************************************************************************/
Re: [ASK] Cara tambahin cash coinMay 14th 2020, 16:46Re: [ASK] Cara tambahin cash coinJuly 16th 2020, 06:21Re: [ASK] Cara tambahin cash coin