CREATE TABLE [SubStack](
[char_id] [int] NOT NULL DEFAULT 0,
[baseClass0] [int] NOT NULL DEFAULT -1,
[baseClass1] [int] NOT NULL DEFAULT -1,
[baseClass2] [int] NOT NULL DEFAULT -1,
[baseClass3] [int] NOT NULL DEFAULT -1,
[stackClass0] [int] NOT NULL DEFAULT -1,
[stackClass1] [int] NOT NULL DEFAULT -1,
[stackClass2] [int] NOT NULL DEFAULT -1,
[stackClass3] [int] NOT NULL DEFAULT -1
) ON [PRIMARY]
GO
CREATE PROCEDURE lin_SaveSubStack
(
@charId INT,
@classIndex INT,
@baseClass INT,
@stackClass INT
)
AS
SET NOCOUNT ON;
IF @classIndex = 0
BEGIN
UPDATE [SubStack] SET [baseClass0] = @baseClass, [stackClass0] = @stackClass WHERE [char_id] = @charId
IF @@ROWCOUNT=0
BEGIN
INSERT INTO [SubStack] ([char_id], [baseClass0], [stackClass0] ) VALUES (@charId, @baseClass, @stackClass )
END
END
ELSE IF @classIndex = 1
BEGIN
UPDATE [SubStack] SET [baseClass1] = @baseClass, [stackClass1] = @stackClass WHERE [char_id] = @charId
IF @@ROWCOUNT=0
BEGIN
INSERT INTO [SubStack] ([char_id], [baseClass1], [stackClass1] ) VALUES (@charId, @baseClass, @stackClass )
END
END
ELSE IF @classIndex = 2
BEGIN
UPDATE [SubStack] SET [baseClass2] = @baseClass, [stackClass2] = @stackClass WHERE [char_id] = @charId
IF @@ROWCOUNT=0
BEGIN
INSERT INTO [SubStack] ([char_id], [baseClass2], [stackClass2] ) VALUES (@charId, @baseClass, @stackClass )
END
END
ELSE IF @classIndex = 3
BEGIN
UPDATE [SubStack] SET [baseClass3] = @baseClass, [stackClass3] = @stackClass WHERE [char_id] = @charId
IF @@ROWCOUNT=0
BEGIN
INSERT INTO [SubStack] ([char_id], [baseClass3], [stackClass3] ) VALUES (@charId, @baseClass, @stackClass )
END
END
GO