Somebody help me fix Silk system

[ntabkpro]

I used Athena filter. But Reward silk system per hour is not working..


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]
@erID varchar(64),
@_level int,
@ID varchar(64),
@Level int
AS

BEGIN
/*
EXAMPLE CODE, FOR REWARD LEVEL RESTRICT
IF @_level < 100)
BEGIN
RETURN;
END
*/


DECLARE @ bigint = (SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WITH(NOLOCK) WHERE StrUserID = @erID);


IF NOT EXISTS(SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[SK_silk] WITH(NOLOCK) WHERE JID = @)
BEGIN
--- INSERT THEIR SHIT
INSERT INTO [SRO_VT_ACCOUNT].[dbo].[SK_silk] (JID, silk_own, silk_gift, silk_point) VALUES @, 0, 0, 0);
END

/*
EXAMPLE CODE:
IF @level BETWEEN 0 AND 50)
BEGIN
-- Higher reward for level 0-50?
SET @Level = 32;
END
*/

IF @ID = 'silk')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_own = (silk_own + @Level) WHERE JID = @;
END

ELSE IF @ID = 'gift')
BEGIN
--- fyll refund oqe?
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_gift = (silk_gift + @Level) WHERE JID = @;
END

ELSE IF @ID = 'point')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_point = (silk_point + @Level) WHERE JID = @;
END

ELSE
BEGIN
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN_CHEST] @, @ID, 0, @Level;
END
END

Solved

Originally Posted by ntabkpro

I used Athena filter. But Reward silk system per hour is not working..


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]
@erID varchar(64),
@_level int,
@ID varchar(64),
@Level int
AS

BEGIN
/*
EXAMPLE CODE, FOR REWARD LEVEL RESTRICT
IF @_level < 100)
BEGIN
RETURN;
END
*/


DECLARE @ bigint = (SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WITH(NOLOCK) WHERE StrUserID = @erID);


IF NOT EXISTS(SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[SK_silk] WITH(NOLOCK) WHERE JID = @)
BEGIN
--- INSERT THEIR SHIT
INSERT INTO [SRO_VT_ACCOUNT].[dbo].[SK_silk] (JID, silk_own, silk_gift, silk_point) VALUES @, 0, 0, 0);
END

/*
EXAMPLE CODE:
IF @level BETWEEN 0 AND 50)
BEGIN
-- Higher reward for level 0-50?
SET @Level = 32;
END
*/

IF @ID = 'silk')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_own = (silk_own + @Level) WHERE JID = @;
END

ELSE IF @ID = 'gift')
BEGIN
--- fyll refund oqe?
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_gift = (silk_gift + @Level) WHERE JID = @;
END

ELSE IF @ID = 'point')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_point = (silk_point + @Level) WHERE JID = @;
END

ELSE
BEGIN
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN_CHEST] @, @ID, 0, @Level;
END
END

[revldo1]

bro you do every 1 mint give you 1 silk do the time every 60mint or 59 1=60 sec not 1h

[arg3n7s]

Better use filter

[!Apple]

Originally Posted by ntabkpro

I used Athena filter. But Reward silk system per hour is not working..


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]
@erID varchar(64),
@_level int,
@ID varchar(64),
@Level int
AS

BEGIN
/*
EXAMPLE CODE, FOR REWARD LEVEL RESTRICT
IF @_level < 100)
BEGIN
RETURN;
END
*/


DECLARE @ bigint = (SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WITH(NOLOCK) WHERE StrUserID = @erID);


IF NOT EXISTS(SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[SK_silk] WITH(NOLOCK) WHERE JID = @)
BEGIN
--- INSERT THEIR SHIT
INSERT INTO [SRO_VT_ACCOUNT].[dbo].[SK_silk] (JID, silk_own, silk_gift, silk_point) VALUES @, 0, 0, 0);
END

/*
EXAMPLE CODE:
IF @level BETWEEN 0 AND 50)
BEGIN
-- Higher reward for level 0-50?
SET @Level = 32;
END
*/

IF @ID = 'silk')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_own = (silk_own + @Level) WHERE JID = @;
END

ELSE IF @ID = 'gift')
BEGIN
--- fyll refund oqe?
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_gift = (silk_gift + @Level) WHERE JID = @;
END

ELSE IF @ID = 'point')
BEGIN
UPDATE [SRO_VT_ACCOUNT].[dbo].[SK_silk] SET silk_point = (silk_point + @Level) WHERE JID = @;
END

ELSE
BEGIN
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN_CHEST] @, @ID, 0, @Level;
END
END

Solved

use Silk/h program is good