Discussion DragonNetwork Substack System

[xeL]

Hello,

 

Some one have a SubStack system like Dragon Network? I use the one from  Dayne shared here on MxC but u can't switch between clases after u make subclass.

 

Thank you in advance!

 

 

[hugolez]

here

modify procedure

 

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

 

 

[xeL]

here

modify procedure

 

thanx