hey guys i got this at the moment
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[lin_SetAquireSkill] ( @char_id INT, @subjob_id INT, @skill_id INT, @skill_level TINYINT ) AS DECLARE @subjob_acu INT SET NOCOUNT ON set @subjob_acu = 0 WHILE (@subjob_acu < 3) BEGIN SET @subjob_acu = @subjob_acu + 1 IF EXISTS(SELECT skill_lev FROM user_skill WHERE char_id = @char_id AND skill_id = @skill_id AND subjob_id = @subjob_acu) UPDATE user_skill SET skill_lev = @skill_level WHERE char_id = @char_id AND skill_id = @skill_id AND subjob_id <= @subjob_acu ELSE INSERT INTO user_skill (char_id, subjob_id, skill_id, skill_lev) VALUES (@char_id, @subjob_acu, @skill_id, @skill_level); IF NOT EXISTS(SELECT skill_id FROM user_skill WHERE char_id = @char_id AND skill_id = @skill_id AND skill_lev = @skill_level AND subjob_id = 0) INSERT INTO user_skill (char_id, subjob_id, skill_id, skill_lev) VALUES (@char_id, 0, @skill_id, @skill_level); END
i would like to do the same thing but with out changing the skin of the character
as now i can change subclass with out changing the skin but skills desapierd with subclass :(