Reset Stats and Skill

[erasmojosepzo]

Can anyone tell me if this will work ...
I'm new to SQL, learning.

-----------Reset STATUS---------------------

DECLARE @ID tinyint,

@ Tinyint,

@Family Tinyint,

@Grow Tinyint,

@Hair Tinyint,

@Face Tinyint, @ Tinyint,

@Job Tinyint, @ Tinyint,

@Level Smallint,

@point Smallint, @ Smallint,

@ Smallint,

@Dex Smallint, @ Smallint,

@Int Smallint,

@Luc Smallint,

@ 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 = @

IF (@ActionType='112' and @='10090')

BEGIN

IF @Grow = 3 -- Ultimate mode

BEGIN

-- Status

IF @Job = 0

BEGIN

SET @ = (16 + @Level)

SET @ = 9

SET @int = 8

SET @ = 7

SET @dex = 12

SET @luc = 15

END

ELSE IF @Job = 1

BEGIN

SET @ = 10

SET @ = (14 + @Level)

SET @int = 10

SET @ = 10

SET @dex = 9

SET @luc = 14

END

ELSE IF @Job = 2

BEGIN

SET @ = 10

SET @ = 9

SET @int = 7

SET @ = 8

SET @dex = (15 + @Level)

SET @luc = 12

END

ELSE IF @Job = 3

BEGIN

SET @ = 11

SET @ = 10

SET @int = 7

SET @ = 10

SET @dex = 14

SET @luc = (13 + @Level)

END

ELSE IF @job = 4

BEGIN

SET @ = 7

SET @ = 9

SET @int = (17 + @Level)

SET @ = 12

SET @dex = 13

SET @luc = 9

END

ELSE IF @job = 5

BEGIN

SET @ = 8

SET @ = 10

SET @int = 12

SET @ = (16 + @Level)

SET @dex = 9

SET @luc = 12

END

END

END

Set @point = (9 * @Level)

Update PS_GameData.dbo.Chars

Set @CharID=@CharID

Sorry my bad English(google)

[erasmojosepzo]

Originally Posted by failpvper

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