Somebody help me fix Silk system

06/16/2019 20:29 ntabkpro#1
I used Athena filter. But Reward silk system per hour is not working..
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
And procedure here


USE [ATHENA]
GO
/****** Object: StoredProcedure [dbo].[_RewardSystem] Script Date: 6/17/2019 1:20:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_RewardSystem]
@[Only registered and activated users can see links. Click Here To Register...]erID varchar(64),
@[Only registered and activated users can see links. Click Here To Register...]_level int,
@[Only registered and activated users can see links. Click Here To Register...]ID varchar(64),
@[Only registered and activated users can see links. Click Here To Register...]Level int
AS

BEGIN
/*
EXAMPLE CODE, FOR REWARD LEVEL RESTRICT
IF @[Only registered and activated users can see links. Click Here To Register...]_level < 100)
BEGIN
RETURN;
END
*/


DECLARE @[Only registered and activated users can see links. Click Here To Register...] bigint = (SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WITH(NOLOCK) WHERE StrUserID = @[Only registered and activated users can see links. Click Here To Register...]erID);


IF NOT EXISTS(SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[SK_silk] WITH(NOLOCK) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...])
BEGIN
--- INSERT THEIR SHIT
INSERT INTO [SRO_VT_ACCOUNT].[dbo].[SK_silk] (JID, silk_own, silk_gift, silk_point) VALUES @[Only registered and activated users can see links. Click Here To Register...], 0, 0, 0);
END

/*
EXAMPLE CODE:
IF @[Only registered and activated users can see links. Click Here To Register...]level BETWEEN 0 AND 50)
BEGIN
-- Higher reward for level 0-50?
SET @[Only registered and activated users can see links. Click Here To Register...]Level = 32;
END
*/

IF @[Only registered and activated users can see links. Click Here To Register...]ID = 'silk')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_own = (silk_own + @[Only registered and activated users can see links. Click Here To Register...]Level) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...];
END

ELSE IF @[Only registered and activated users can see links. Click Here To Register...]ID = 'gift')
BEGIN
--- fyll refund oqe?
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_gift = (silk_gift + @[Only registered and activated users can see links. Click Here To Register...]Level) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...];
END

ELSE IF @[Only registered and activated users can see links. Click Here To Register...]ID = 'point')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_point = (silk_point + @[Only registered and activated users can see links. Click Here To Register...]Level) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...];
END

ELSE
BEGIN
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN_CHEST] @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ID, 0, @[Only registered and activated users can see links. Click Here To Register...]Level;
END
END

Solved :)

Quote:
Originally Posted by ntabkpro View Post
I used Athena filter. But Reward silk system per hour is not working..
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
And procedure here


USE [ATHENA]
GO
/****** Object: StoredProcedure [dbo].[_RewardSystem] Script Date: 6/17/2019 1:20:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_RewardSystem]
@[Only registered and activated users can see links. Click Here To Register...]erID varchar(64),
@[Only registered and activated users can see links. Click Here To Register...]_level int,
@[Only registered and activated users can see links. Click Here To Register...]ID varchar(64),
@[Only registered and activated users can see links. Click Here To Register...]Level int
AS

BEGIN
/*
EXAMPLE CODE, FOR REWARD LEVEL RESTRICT
IF @[Only registered and activated users can see links. Click Here To Register...]_level < 100)
BEGIN
RETURN;
END
*/


DECLARE @[Only registered and activated users can see links. Click Here To Register...] bigint = (SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WITH(NOLOCK) WHERE StrUserID = @[Only registered and activated users can see links. Click Here To Register...]erID);


IF NOT EXISTS(SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[SK_silk] WITH(NOLOCK) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...])
BEGIN
--- INSERT THEIR SHIT
INSERT INTO [SRO_VT_ACCOUNT].[dbo].[SK_silk] (JID, silk_own, silk_gift, silk_point) VALUES @[Only registered and activated users can see links. Click Here To Register...], 0, 0, 0);
END

/*
EXAMPLE CODE:
IF @[Only registered and activated users can see links. Click Here To Register...]level BETWEEN 0 AND 50)
BEGIN
-- Higher reward for level 0-50?
SET @[Only registered and activated users can see links. Click Here To Register...]Level = 32;
END
*/

IF @[Only registered and activated users can see links. Click Here To Register...]ID = 'silk')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_own = (silk_own + @[Only registered and activated users can see links. Click Here To Register...]Level) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...];
END

ELSE IF @[Only registered and activated users can see links. Click Here To Register...]ID = 'gift')
BEGIN
--- fyll refund oqe?
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_gift = (silk_gift + @[Only registered and activated users can see links. Click Here To Register...]Level) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...];
END

ELSE IF @[Only registered and activated users can see links. Click Here To Register...]ID = 'point')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_point = (silk_point + @[Only registered and activated users can see links. Click Here To Register...]Level) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...];
END

ELSE
BEGIN
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN_CHEST] @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ID, 0, @[Only registered and activated users can see links. Click Here To Register...]Level;
END
END
06/16/2019 23:53 revldo1#2
bro you do every 1 mint give you 1 silk do the time every 60mint or 59 1=60 sec not 1h
06/18/2019 01:06 arg3n7s#3
Better use filter :rollsafe:
06/25/2019 22:27 !Apple#4
Quote:
Originally Posted by ntabkpro View Post
I used Athena filter. But Reward silk system per hour is not working..
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
And procedure here


USE [ATHENA]
GO
/****** Object: StoredProcedure [dbo].[_RewardSystem] Script Date: 6/17/2019 1:20:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_RewardSystem]
@[Only registered and activated users can see links. Click Here To Register...]erID varchar(64),
@[Only registered and activated users can see links. Click Here To Register...]_level int,
@[Only registered and activated users can see links. Click Here To Register...]ID varchar(64),
@[Only registered and activated users can see links. Click Here To Register...]Level int
AS

BEGIN
/*
EXAMPLE CODE, FOR REWARD LEVEL RESTRICT
IF @[Only registered and activated users can see links. Click Here To Register...]_level < 100)
BEGIN
RETURN;
END
*/


DECLARE @[Only registered and activated users can see links. Click Here To Register...] bigint = (SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WITH(NOLOCK) WHERE StrUserID = @[Only registered and activated users can see links. Click Here To Register...]erID);


IF NOT EXISTS(SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[SK_silk] WITH(NOLOCK) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...])
BEGIN
--- INSERT THEIR SHIT
INSERT INTO [SRO_VT_ACCOUNT].[dbo].[SK_silk] (JID, silk_own, silk_gift, silk_point) VALUES @[Only registered and activated users can see links. Click Here To Register...], 0, 0, 0);
END

/*
EXAMPLE CODE:
IF @[Only registered and activated users can see links. Click Here To Register...]level BETWEEN 0 AND 50)
BEGIN
-- Higher reward for level 0-50?
SET @[Only registered and activated users can see links. Click Here To Register...]Level = 32;
END
*/

IF @[Only registered and activated users can see links. Click Here To Register...]ID = 'silk')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_own = (silk_own + @[Only registered and activated users can see links. Click Here To Register...]Level) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...];
END

ELSE IF @[Only registered and activated users can see links. Click Here To Register...]ID = 'gift')
BEGIN
--- fyll refund oqe?
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_gift = (silk_gift + @[Only registered and activated users can see links. Click Here To Register...]Level) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...];
END

ELSE IF @[Only registered and activated users can see links. Click Here To Register...]ID = 'point')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_point = (silk_point + @[Only registered and activated users can see links. Click Here To Register...]Level) WHERE JID = @[Only registered and activated users can see links. Click Here To Register...];
END

ELSE
BEGIN
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN_CHEST] @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ID, 0, @[Only registered and activated users can see links. Click Here To Register...]Level;
END
END

Solved :)
[Only registered and activated users can see links. Click Here To Register...]

use Silk/h program is good