Бафы

/****** 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_id
END  
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

ALTER TABLE user_ActiveSkill ADD
    s21 int NULL,
    l21 tinyint NULL,
    d21 int NULL,
    s22 int NULL,
    l22 tinyint NULL,
    d22 int NULL,
    s23 int NULL,
    l23 tinyint NULL,
    d23 int NULL,
    s24 int NULL,
    l24 tinyint NULL,
    d24 int NULL,
    c21 tinyint NULL,
    c22 tinyint NULL,
    c23 tinyint NULL,
    c24 tinyint NULL
GO