Reset Stats and Skill

09/13/2019 19:31 erasmojosepzo#1
Can anyone tell me if this will work ...
I'm new to SQL, learning.

 
-----------Reset STATUS---------------------
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ID tinyint,
@[Only registered and activated users can see links. Click Here To Register...] Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint, @[Only registered and activated users can see links. Click Here To Register...] Tinyint,
@Job Tinyint, @[Only registered and activated users can see links. Click Here To Register...] Tinyint,
@Level Smallint,
@[Only registered and activated users can see links. Click Here To Register...]point Smallint, @[Only registered and activated users can see links. Click Here To Register...] Smallint,
@[Only registered and activated users can see links. Click Here To Register...] Smallint,
@Dex Smallint, @[Only registered and activated users can see links. Click Here To Register...] Smallint,
@Int Smallint,
@Luc Smallint,
@[Only registered and activated users can see links. Click Here To Register...] Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint
SET @ItemID = @[Only registered and activated users can see links. Click Here To Register...]
IF (@ActionType='112' and @[Only registered and activated users can see links. Click Here To Register...]='10090')
BEGIN
IF @Grow = 3 -- Ultimate mode
BEGIN
-- Status
IF @Job = 0
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = (16 + @Level)
SET @[Only registered and activated users can see links. Click Here To Register...] = 9
SET @int = 8
SET @[Only registered and activated users can see links. Click Here To Register...] = 7
SET @dex = 12
SET @luc = 15
END
ELSE IF @Job = 1
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 10
SET @[Only registered and activated users can see links. Click Here To Register...] = (14 + @Level)
SET @int = 10
SET @[Only registered and activated users can see links. Click Here To Register...] = 10
SET @dex = 9
SET @luc = 14
END
ELSE IF @Job = 2
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 10
SET @[Only registered and activated users can see links. Click Here To Register...] = 9
SET @int = 7
SET @[Only registered and activated users can see links. Click Here To Register...] = 8
SET @dex = (15 + @Level)
SET @luc = 12
END
ELSE IF @Job = 3
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 11
SET @[Only registered and activated users can see links. Click Here To Register...] = 10
SET @int = 7
SET @[Only registered and activated users can see links. Click Here To Register...] = 10
SET @dex = 14
SET @luc = (13 + @Level)
END
ELSE IF @job = 4
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 7
SET @[Only registered and activated users can see links. Click Here To Register...] = 9
SET @int = (17 + @Level)
SET @[Only registered and activated users can see links. Click Here To Register...] = 12
SET @dex = 13
SET @luc = 9
END
ELSE IF @job = 5
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 8
SET @[Only registered and activated users can see links. Click Here To Register...] = 10
SET @int = 12
SET @[Only registered and activated users can see links. Click Here To Register...] = (16 + @Level)
SET @dex = 9
SET @luc = 12
END
END
END
Set @[Only registered and activated users can see links. Click Here To Register...]point = (9 * @Level)
Update PS_GameData.dbo.Chars
Set @CharID=@CharID

Sorry my bad English(google)
09/13/2019 21:03 erasmojosepzo#2
Quote:
Originally Posted by failpvper View Post
no. there are several syntax errors. are your stat and skill resets not working? i'm just trying to understand why you would need this procedure. ^^
It's working perfectly up to level 79. My problem is with level 80. Reset Skill is working for 5 points. I work with 7 points.
Note: Server Level Up