Hi guys! i have a problem
i make this simple produce but i dont know why dosent work
, when i reach the lv 110 nothing happend, and i check the Table _MaxLevelLog and got record but i dont got the silk
Any Hints?
Table:
HTML Code:
CREATE TABLE _MaxLevelLog
(
CharID INT,
LevelCounter INT,
Done BIT
)
Quote:
IF @EventID = 22 AND @Data2 = 110
BEGIN
DECLARE @UserJID int;
DECLARE @MaxLevelCount int = (select max(LevelCounter) from _MaxLevelLog);
DECLARE @SilkTop int;
IF EXISTS (SELECT * FROM _MaxLevelLog WHERE CharID = @CharID )
UPDATE _MaxLevelLog SET LevelCounter = LevelCounter WHERE CharID = @CharID
ELSE
INSERT INTO _MaxLevelLog VALUES (@CharID,(select max(LevelCounter)+1 from _MaxLevelLog),0)
SET @SilkTop = CASE
WHEN @MaxLevelCount <= 50
THEN 200
WHEN @MaxLevelCount <= 100
THEN 100
ELSE 0
END
SELECT @UserJID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @UserJID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @SilkTop where JID = @UserJID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @UserJID, @SilkTop, 0, 0
END
|
fix it the problem was LevelCounter starts in the table with NULL
