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