/****** Object: Stored Procedure dbo.lin_CreateActiveSkill Script Date: 2003-09-20 ?? 11:51:58 Updated by Vampire 2007-11-06 12:43:00 ******/
--by bert for clee
CREATE PROCEDURE [DBO].[lin_CreateActiveSkill]
(
@char_id INT,
@s1 INT, @l1 TINYINT, @d1 INT, @c1 TINYINT,
@s2 INT, @l2 TINYINT, @d2 INT, @c2 TINYINT,
@s3 INT, @l3 TINYINT, @d3 INT, @c3 TINYINT,
@s4 INT, @l4 TINYINT, @d4 INT, @c4 TINYINT,
@s5 INT, @l5 TINYINT, @d5 INT, @c5 TINYINT,
@s6 INT, @l6 TINYINT, @d6 INT, @c6 TINYINT,
@s7 INT, @l7 TINYINT, @d7 INT, @c7 TINYINT,
@s8 INT, @l8 TINYINT, @d8 INT, @c8 TINYINT,
@s9 INT, @l9 TINYINT, @d9 INT, @c9 TINYINT,
@s10 INT,
@l10 TINYINT,
@d10 INT,
@c10 TINYINT,
@s11 INT,
@l11 TINYINT,
@d11 INT,
@c11 TINYINT,
@s12 INT,
@l12 TINYINT,
@d12 INT,
@c12 TINYINT,
@s13 INT,
@l13 TINYINT,
@d13 INT,
@c13 TINYINT,
@s14 INT,
@l14 TINYINT,
@d14 INT,
@c14 TINYINT,
@s15 INT,
@l15 TINYINT,
@d15 INT,
@c15 TINYINT,
@s16 INT,
@l16 TINYINT,
@d16 INT,
@c16 TINYINT,
@s17 INT,
@l17 TINYINT,
@d17 INT,
@c17 TINYINT,
@s18 INT,
@l18 TINYINT,
@d18 INT,
@c18 TINYINT,
@s19 INT,
@l19 TINYINT,
@d19 INT,
@c19 TINYINT,
@s20 INT,
@l20 TINYINT,
@d20 INT,
@c20 TINYINT,
@s21 INT,
@l21 TINYINT,
@d21 INT,
@c21 TINYINT,
@s22 INT,
@l22 TINYINT,
@d22 INT,
@c22 TINYINT,
@s23 INT,
@l23 TINYINT,
@d23 INT,
@c23 TINYINT,
@s24 INT,
@l24 TINYINT,
@d24 INT,
@c24 TINYINT
)
AS
SET NOCOUNT ON
INSERT INTO user_activeskill
(char_id,
s1, l1, d1, c1,
s2, l2, d2, c2,
s3, l3, d3, c3,
s4, l4, d4, c4,
s5, l5, d5, c5,
s6, l6, d6, c6,
s7, l7, d7, c7,
s8, l8, d8, c8,
s9, l9, d9, c9,
s10, l10, d10, c10,
s11, l11, d11, c11,
s12, l12, d12, c12,
s13, l13, d13, c13,
s14, l14, d14, c14,
s15, l15, d15, c15,
s16, l16, d16, c16,
s17, l17, d17, c17,
s18, l18, d18, c18,
s19, l19, d19, c19,
s20, l20, d20, c20,
s21, l21, d21, c21,
s22, l22, d22, c22,
s23, l23, d23, c23,
s24, l24, d24, c24)
VALUES
(
@char_id,
@s1, @l1, @d1, @c1,
@s2, @l2, @d2, @c2,
@s3, @l3, @d3, @c3,
@s4, @l4, @d4, @c4,
@s5, @l5, @d5, @c5,
@s6, @l6, @d6, @c6,
@s7, @l7, @d7, @c7,
@s8, @l8, @d8, @c8,
@s9, @l9, @d9, @c9,
@s10,
@l10,
@d10,
@c10,
@s11,
@l11,
@d11,
@c11,
@s12,
@l12,
@d12,
@c12,
@s13,
@l13,
@d13,
@c13,
@s14,
@l14,
@d14,
@c14,
@s15,
@l15,
@d15,
@c15,
@s16,
@l16,
@d16,
@c16,
@s17,
@l17,
@d17,
@c17,
@s18,
@l18,
@d18,
@c18,
@s19,
@l19,
@d19,
@c19,
@s20,
@l20,
@d20,
@c20,
@s21,
@l21,
@d21,
@c21,
@s22,
@l22,
@d22,
@c22,
@s23,
@l23,
@d23,
@c23,
@s24,
@l24,
@d24,
@c24)
GO
/****** Object: Stored Procedure dbo.lin_UpdateActiveSkill Script Date: 2003-09-20 ?? 11:52:00 Updated by Vampire 2007-11-06 12:43:00 ******/
CREATE PROCEDURE [DBO].[lin_UpdateActiveSkill]
(
@char_id INT,
@s1 INT, @l1 TINYINT, @d1 INT, @c1 TINYINT,
@s2 INT, @l2 TINYINT, @d2 INT, @c2 TINYINT,
@s3 INT, @l3 TINYINT, @d3 INT, @c3 TINYINT,
@s4 INT, @l4 TINYINT, @d4 INT, @c4 TINYINT,
@s5 INT, @l5 TINYINT, @d5 INT, @c5 TINYINT,
@s6 INT, @l6 TINYINT, @d6 INT, @c6 TINYINT,
@s7 INT, @l7 TINYINT, @d7 INT, @c7 TINYINT,
@s8 INT, @l8 TINYINT, @d8 INT, @c8 TINYINT,
@s9 INT, @l9 TINYINT, @d9 INT, @c9 TINYINT,
@s10 INT,
@l10 TINYINT,
@d10 INT,
@c10 TINYINT,
@s11 INT,
@l11 TINYINT,
@d11 INT,
@c11 TINYINT,
@s12 INT,
@l12 TINYINT,
@d12 INT,
@c12 TINYINT,
@s13 INT,
@l13 TINYINT,
@d13 INT,
@c13 TINYINT,
@s14 INT,
@l14 TINYINT,
@d14 INT,
@c14 TINYINT,
@s15 INT,
@l15 TINYINT,
@d15 INT,
@c15 TINYINT,
@s16 INT,
@l16 TINYINT,
@d16 INT,
@c16 TINYINT,
@s17 INT,
@l17 TINYINT,
@d17 INT,
@c17 TINYINT,
@s18 INT,
@l18 TINYINT,
@d18 INT,
@c18 TINYINT,
@s19 INT,
@l19 TINYINT,
@d19 INT,
@c19 TINYINT,
@s20 INT,
@l20 TINYINT,
@d20 INT,
@c20 TINYINT,
@s21 INT,
@l21 TINYINT,
@d21 INT,
@c21 TINYINT,
@s22 INT,
@l22 TINYINT,
@d22 INT,
@c22 TINYINT,
@s23 INT,
@l23 TINYINT,
@d23 INT,
@c23 TINYINT,
@s24 INT,
@l24 TINYINT,
@d24 INT,
@c24 TINYINT
)
AS
SET NOCOUNT ON
IF EXISTS(SELECT * FROM user_activeskill WHERE char_id =
@char_id)
BEGIN
UPDATE user_activeskill
SET
s1 = @s1, l1 = @l1, d1 = @d1, c1 = @c1,
s2 = @s2, l2 = @l2, d2 = @d2, c2 = @c2,
s3 = @s3, l3 = @l3, d3 = @d3, c3 = @c3,
s4 = @s4, l4 = @l4, d4 = @d4, c4 = @c4,
s5 = @s5, l5 = @l5, d5 = @d5, c5 = @c5,
s6 = @s6, l6 = @l6, d6 = @d6, c6 = @c6,
s7 = @s7, l7 = @l7, d7 = @d7, c7 = @c7,
s8 = @s8, l8 = @l8, d8 = @d8, c8 = @c8,
s9 = @s9, l9 = @l9, d9 = @d9, c9 = @c9,
s10 =
@s10, l10 =
@l10, d10 =
@d10, c10 =
@c10,
s11 =
@s11, l11 =
@l11, d11 =
@d11, c11 =
@c11,
s12 =
@s12, l12 =
@l12, d12 =
@d12, c12 =
@c12,
s13 =
@s13, l13 =
@l13, d13 =
@d13, c13 =
@c13,
s14 =
@s14, l14 =
@l14, d14 =
@d14, c14 =
@c14,
s15 =
@s15, l15 =
@l15, d15 =
@d15, c15 =
@c15,
s16 =
@s16, l16 =
@l16, d16 =
@d16, c16 =
@c16,
s17 =
@s17, l17 =
@l17, d17 =
@d17, c17 =
@c17,
s18 =
@s18, l18 =
@l18, d18 =
@d18, c18 =
@c18,
s19 =
@s19, l19 =
@l19, d19 =
@d19, c19 =
@c19,
s20 =
@s20, l20 =
@l20, d20 =
@d20, c20 =
@c20,
s21 =
@s21, l21 =
@l21, d21 =
@d21, c21 =
@c21,
s22 =
@s22, l22 =
@l22, d22 =
@d22, c22 =
@c22,
s23 =
@s23, l23 =
@l23, d23 =
@d23, c23 =
@c23,
s24 =
@s24, l24 =
@l24, d24 =
@d24, c24 =
@c24 WHERE char_id =
@char_idEND
ELSE
BEGIN
INSERT INTO user_activeskill
(char_id,
s1, l1, d1, c1,
s2, l2, d2, c2,
s3, l3, d3, c3,
s4, l4, d4, c4,
s5, l5, d5, c5,
s6, l6, d6, c6,
s7, l7, d7, c7,
s8, l8, d8, c8,
s9, l9, d9, c9,
s10, l10, d10, c10,
s11, l11, d11, c11,
s12, l12, d12, c12,
s13, l13, d13, c13,
s14, l14, d14, c14,
s15, l15, d15, c15,
s16, l16, d16, c16,
s17, l17, d17, c17,
s18, l18, d18, c18,
s19, l19, d19, c19,
s20, l20, d20, c20,
s21, l21, d21, c21,
s22, l22, d22, c22,
s23, l23, d23, c23,
s24, l24, d24, c24)
VALUES
(
@char_id,
@s1, @l1, @d1, @c1,
@s2, @l2, @d2, @c2,
@s3, @l3, @d3, @c3,
@s4, @l4, @d4, @c4,
@s5, @l5, @d5, @c5,
@s6, @l6, @d6, @c6,
@s7, @l7, @d7, @c7,
@s8, @l8, @d8, @c8,
@s9, @l9, @d9, @c9,
@s10,
@l10,
@d10,
@c10,
@s11,
@l11,
@d11,
@c11,
@s12,
@l12,
@d12,
@c12,
@s13,
@l13,
@d13,
@c13,
@s14,
@l14,
@d14,
@c14,
@s15,
@l15,
@d15,
@c15,
@s16,
@l16,
@d16,
@c16,
@s17,
@l17,
@d17,
@c17,
@s18,
@l18,
@d18,
@c18,
@s19,
@l19,
@d19,
@c19,
@s20,
@l20,
@d20,
@c20,
@s21,
@l21,
@d21,
@c21,
@s22,
@l22,
@d22,
@c22,
@s23,
@l23,
@d23,
@c23,
@s24,
@l24,
@d24,
@c24)
END
GO
и еще в skillacure.txt добавь свем классам в автоизучение [s_divine_inspiration4] и будет тебе щастье....
