Code:
USE [World00_Character]
GO
/****** Object: StoredProcedure [dbo].[p_Quest_Set] Script Date: 05/04/2011 22:03:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[p_Quest_Set]
/*
Quest Set
2004.10 By CJC
input:
see SQL
output:
@nRet 0 = OK,
? = Error code
*/
@nCharNo int,
@nQuestNo int,
@nStatus tinyint,
@sData varbinary(100),
@nRet int OUTPUT
AS
SET NOCOUNT ON
UPDATE tQuest SET
nStatus = @nStatus,
sData = @sData
WHERE nCharNo = @nCharNo AND nQuestNo = @nQuestNo
IF @@ERROR <> 0 OR @@ROWCOUNT = 0
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, @nQuestNo, @nStatus, @sData )
END
SET @nRet = @@ERROR
IF @nQuestNo = 717 AND @nStatus = 2
BEGIN
UPDATE tCharacterShape SET
nClass = 4
WHERE nCharNo = @nCharNo
END
IF @nQuestNo = 717 AND @nStatus = 2
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, 705, 2, @sData )
END
IF @nQuestNo = 718 AND @nStatus = 2
BEGIN
UPDATE tCharacterShape SET
nClass = 5
WHERE nCharNo = @nCharNo
END
IF @nQuestNo = 718 AND @nStatus = 2
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, 704, 2, @sData )
END
IF @nQuestNo = 719 AND @nStatus = 2
BEGIN
UPDATE tCharacterShape SET
nClass = 11
WHERE nCharNo = @nCharNo
END
IF @nQuestNo = 719 AND @nStatus = 2
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, 707, 2, @sData )
END
IF @nQuestNo = 720 AND @nStatus = 2
BEGIN
UPDATE tCharacterShape SET
nClass = 12
WHERE nCharNo = @nCharNo
END
IF @nQuestNo = 720 AND @nStatus = 2
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, 706, 2, @sData )
END
IF @nQuestNo = 721 AND @nStatus = 2
BEGIN
UPDATE tCharacterShape SET
nClass = 18
WHERE nCharNo = @nCharNo
END
IF @nQuestNo = 721 AND @nStatus = 2
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, 709, 2, @sData )
END
IF @nQuestNo = 722 AND @nStatus = 2
BEGIN
UPDATE tCharacterShape SET
nClass = 19
WHERE nCharNo = @nCharNo
END
IF @nQuestNo = 722 AND @nStatus = 2
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, 706, 2, @sData )
END
IF @nQuestNo = 723 AND @nStatus = 2
BEGIN
UPDATE tCharacterShape SET
nClass = 25
WHERE nCharNo = @nCharNo
END
IF @nQuestNo = 723 AND @nStatus = 2
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, 711, 2, @sData )
END
IF @nQuestNo = 724 AND @nStatus = 2
BEGIN
UPDATE tCharacterShape SET
nClass = 26
WHERE nCharNo = @nCharNo
END
IF @nQuestNo = 724 AND @nStatus = 2
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, 710, 2, @sData )
END
IF @nQuestNo = 725 AND @nStatus = 2
BEGIN
UPDATE tCharacterShape SET
nClass = 18
WHERE nCharNo = @nCharNo
END
IF @nQuestNo = 725 AND @nStatus = 2
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, 711, 2, @sData )
END
IF @nQuestNo = 726 AND @nStatus = 2
BEGIN
UPDATE tCharacterShape SET
nClass = 19
WHERE nCharNo = @nCharNo
END
IF @nQuestNo = 726 AND @nStatus = 2
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, 711, 2, @sData )
END
IF @nQuestNo = 749 AND @nStatus = 2
BEGIN
INSERT INTO tSaveLevelBlock (nCharNo) VALUES (@nCharNo)
END
IF @@ERROR <> 0 OR @@ROWCOUNT = 0
BEGIN
INSERT tQuest ( nCharNo, nQuestNo, nStatus, sData )
VALUES ( @nCharNo, @nQuestNo, @nStatus, @sData )
END
-- end