Fiesta Private Server 100JC Script

Hier ist der Script f�r die Level 100 JC.

Den Script als SQL Anfrage in die Datenbank einschreiben.

-->>>>>>>>> Bitte mit thanks bewerten, und kein Kommentar schreiben mit: Danke! <<<<<<<<< -------

USE [World00_Character]
GO
/****** Object: StoredProcedure [dbo].[p_Char_Logout] Script Date: 10/08/2011 16:20:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[p_Char_Logout]
/*
Character logout
2004.6 By CJC
Input:
nCharNo = To be logout
nPlayMin = Play minute at this time
output:
0 = error
1 = work ok
*/
@nCharNo int,
@nPlayMin int,
@nRet int OUTPUT
AS
SET NOCOUNT ON
UPDATE tCharacter
SET nPlayMin = nPlayMin + @nPlayMin
WHERE nCharNo = @nCharNo
SET @nRet = @@ROWCOUNT

-- JobChange Script START

IF (SELECT COUNT(*) FROM [World00_Character].[dbo].[tCharacter] WHERE [nCharNo] = @nCharNo AND nLevel >= 100 and (SELECT COUNT(*) from [World00_Character].[dbo].[tCharacterShape] where nCharNo = @nCharNo and (nClass = 3 or nClass = 10 or nClass = 17 or nClass = 24)) > 0) > 0
BEGIN

--Gladiator
IF (SELECT COUNT(*) FROM [World00_Character].[dbo].[tQuest] WHERE [nCharNo] = @nCharNo AND [nQuestNo] = 739 AND [nStatus] = 2) > 0
BEGIN
UPDATE [World00_Character].[dbo].[tCharacterShape] SET nClass = 4 WHERE nCharNo = @nCharNo;
END
ELSE
BEGIN

--Knight
IF (SELECT COUNT(*) FROM [World00_Character].[dbo].[tQuest] WHERE [nCharNo] = @nCharNo AND [nQuestNo] = 740 AND [nStatus] = 2) > 0
BEGIN
UPDATE [World00_Character].[dbo].[tCharacterShape] SET nClass = 5 WHERE nCharNo = @nCharNo;
END
ELSE
BEGIN

--HolyKnight
IF (SELECT COUNT(*) FROM [World00_Character].[dbo].[tQuest] WHERE [nCharNo] = @nCharNo AND [nQuestNo] = 741 AND [nStatus] = 2) > 0
BEGIN
UPDATE [World00_Character].[dbo].[tCharacterShape] SET nClass = 11 WHERE nCharNo = @nCharNo;
END
ELSE
BEGIN

--Guardian
IF (SELECT COUNT(*) FROM [World00_Character].[dbo].[tQuest] WHERE [nCharNo] = @nCharNo AND [nQuestNo] = 742 AND [nStatus] = 2) > 0
BEGIN
UPDATE [World00_Character].[dbo].[tCharacterShape] SET nClass = 12 WHERE nCharNo = @nCharNo;
END
ELSE
BEGIN

--Sharpshooter
IF (SELECT COUNT(*) FROM [World00_Character].[dbo].[tQuest] WHERE [nCharNo] = @nCharNo AND ([nQuestNo] = 743 OR [nQuestNo] = 747) AND [nStatus] = 2) > 0
BEGIN
UPDATE [World00_Character].[dbo].[tCharacterShape] SET nClass = 18 WHERE nCharNo = @nCharNo;
END
ELSE
BEGIN

--Ranger
IF (SELECT COUNT(*) FROM [World00_Character].[dbo].[tQuest] WHERE [nCharNo] = @nCharNo AND ([nQuestNo] = 744 OR [nQuestNo] = 748) AND [nStatus] = 2) > 0
BEGIN
UPDATE [World00_Character].[dbo].[tCharacterShape] SET nClass = 19 WHERE nCharNo = @nCharNo;
END
ELSE
BEGIN

--Warlock
IF (SELECT COUNT(*) FROM [World00_Character].[dbo].[tQuest] WHERE [nCharNo] = @nCharNo AND [nQuestNo] = 745 AND [nStatus] = 2) > 0
BEGIN
UPDATE [World00_Character].[dbo].[tCharacterShape] SET nClass = 25 WHERE nCharNo = @nCharNo;
END
ELSE
BEGIN

--Wizard
IF (SELECT COUNT(*) FROM [World00_Character].[dbo].[tQuest] WHERE [nCharNo] = @nCharNo AND [nQuestNo] = 746 AND [nStatus] = 2) > 0
BEGIN
UPDATE [World00_Character].[dbo].[tCharacterShape] SET nClass = 26 WHERE nCharNo = @nCharNo;
END
END
END
END
END
END
END
END
END

-- end