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
Quote:
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 |
