SigFiesta/SQL Scripts/CreateCharacter_GiveInventory.sql

<EFBFBD><EFBFBD>USE [World00_Character]
GO
/****** Object:  StoredProcedure [dbo].[p_Char_Create]    Script Date: 6/28/2023 5:33:49 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*
Character Create 
2004.6 By CJC
 input:
   All Args
 output: 
   nCharNo = 1~? <EFBFBD><EFBFBD>1<EFBFBD><EFBFBD> <EFBFBD>έ<EFBFBD>X<EFBFBD> <EFBFBD><EFBFBD>8<EFBFBD>(<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> = 0 )
           =  0 <EFBFBD>έ<EFBFBD> <EFBFBD><EFBFBD>1<EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD>
           = -1 t<EFBFBD><EFBFBD><EFBFBD>  <EFBFBD><EFBFBD>X<EFBFBD> <EFBFBD><EFBFBD>o<EFBFBD><EFBFBD><EFBFBD> <EFBFBD>έ<EFBFBD>t<EFBFBD> <EFBFBD><EFBFBD>L<EFBFBD>.
           = -2 <EFBFBD>έ<EFBFBD> xƨ<EFBFBD> 0<EFBFBD>]<EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD>
           = -3 <EFBFBD>έ<EFBFBD> 5<EFBFBD>X<EFBFBD> 0<EFBFBD>]<EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD>
2010.10.7 By kodong
  <EFBFBD><EFBFBD>ܭ 貕ͤ<EFBFBD> <EFBFBD>¤<EFBFBD>\<EFBFBD> <EFBFBD><EFBFBD><EFBFBD>\<EFBFBD> x<EFBFBD>\<EFBFBD> <EFBFBD>\<EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD>
*/
ALTER PROCEDURE [dbo].[p_Char_Create] 
	@nUserNo int,			-- 1	1 ~ ?
	@nCreateWorld tinyint,	-- 2	0 ~ ?
	@nAdminLevel tinyint,	-- 3	0=USER, 1~?=GM Level 1~?
	@nSlotNo tinyint,		-- 4	0 ~ 5
	@sID nvarchar(40),		-- 5  
	@nRace tinyint,			-- 6	0 = Human, 1 = Elf, 2 = Dark elf
	@nClass tinyint,		-- 7	1 = Fighter,4 = Cleric, 7 = Archer, 10 = Mage
	@nGender tinyint,		-- 8	0 = Male, 1 = Female
	@nHairType tinyint,		-- 9	0 ~ ?
	@nHairColor tinyint,	-- 10	0 ~ ?
	@nFaceShape tinyint,	-- 11	0 ~ ?
	@nCharNo int OUTPUT     -- 12
AS
BEGIN
	SET NOCOUNT ON
	-- <EFBFBD><EFBFBD><EFBFBD><EFBFBD>T<EFBFBD>ܴ |<EFBFBD><EFBFBD><EFBFBD> 8<EFBFBD><EFBFBD>
	SET @nCharNo = 0

	/*-------------------------------------------------------------------------------------
	Project: FiestaHeroes - NA2016
	Author: xkl

	If the account is admin (nAuthID = 9), then make the character have 100 admin power.
	------------------------------------------------------------------------------------*/
	DECLARE @nAuthID INT = (SELECT nAuthID FROM Account..tUser WHERE nUserNo = @nUserNo)
	
	IF @nAuthID = 9
	BEGIN
		SET @nAdminLevel = 100
	END


	/*-------------------------------------------------------------------------------------
	 Continue as normal ~ 
	------------------------------------------------------------------------------------*/

	-- t<EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD>X<EFBFBD> t<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>o<EFBFBD><EFBFBD><EFBFBD> <EFBFBD>έ<EFBFBD>t<EFBFBD> <EFBFBD>ǔ<EFBFBD><EFBFBD><EFBFBD> U<EFBFBD>x<EFBFBD>
	IF EXISTS (SELECT nUserNo FROM tCharacter(NOLOCK) WHERE nUserNo = @nUserNo AND nSlotNo = @nSlotNo AND bDeleted = 0)
	BEGIN
		SET @nCharNo = -1
		RETURN
	END
	-- <EFBFBD>έ<EFBFBD> <EFBFBD><EFBFBD>1<EFBFBD>
	
	IF EXISTS (SELECT sID FROM tCharacter(NOLOCK) WHERE sID = @sID)
		BEGIN
		RETURN
		END
		ELSE
	-- <EFBFBD>έ<EFBFBD> <EFBFBD><EFBFBD>1<EFBFBD>
	
	BEGIN TRAN
	IF EXISTS (SELECT sID FROM tCharacter(NOLOCK) WHERE sID = @sID)
		BEGIN
		RETURN
		END
		ELSE
	INSERT tCharacter (  nUserNo,  nSlotNo,  sID,  nCreateWorld,  nAdminLevel )
	VALUES            ( @nUserNo, @nSlotNo, @sID, @nCreateWorld, @nAdminLevel )
	IF @@ERROR <> 0
	BEGIN
		ROLLBACK TRAN
		RETURN
	END
	SET @nCharNo = @@IDENTITY
	-- <EFBFBD>έ<EFBFBD> xƨ<EFBFBD> 8<EFBFBD><EFBFBD>
	INSERT tCharacterShape (  nCharNo,  nRace,  nClass,  nGender,  nHairType,  nHairColor,  nFaceShape )
	VALUES                 ( @nCharNo, @nRace, @nClass, @nGender, @nHairType, @nHairColor, @nFaceShape ) 
	IF @@ERROR <> 0
	BEGIN
		ROLLBACK TRAN
		SET @nCharNo = -2
		RETURN
	END
	-- <EFBFBD>έ<EFBFBD> 5<EFBFBD>X<EFBFBD> 8<EFBFBD><EFBFBD>
	INSERT tCharacterOptions (  nCharNo )
	VALUES                   ( @nCharNo )
	IF @@ERROR <> 0
	BEGIN
		ROLLBACK TRAN
		SET @nCharNo = -3
		RETURN
	END
	-- <EFBFBD>έ<EFBFBD> <EFBFBD><EFBFBD>1<EFBFBD> 1<EFBFBD><EFBFBD><EFBFBD>
	INSERT tCharacterChargedBuffer (nCharNo,nKey,nID,dUseDate,dEndDate)
	VALUES (@nCharNo,0,827,'2023-01-01 00:00:00.000','2255-12-31 23:59:00.000')
	INSERT tCharacterChargedBuffer (nCharNo,nKey,nID,dUseDate,dEndDate)
	VALUES (@nCharNo,1,827,'2023-01-01 00:00:00.000','2255-12-31 23:59:00.000')
	IF @@ERROR <> 0
	BEGIN
		ROLLBACK TRAN
		SET @nCharNo = -3
		RETURN
	END
	-- 2010.10.7
	-- kodong
	-- <EFBFBD><EFBFBD>\<EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD> 貕ͤ<EFBFBD> <EFBFBD>¤<EFBFBD>\<EFBFBD><EFBFBD><EFBFBD> X<EFBFBD>t<EFBFBD> <EFBFBD>0<EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD>
	DECLARE @nRet int
	SET @nRet = 0
	EXEC usp_Character_initKeyMap @nCharNo, @nRet output
	IF @@ERROR <> 0 OR @nRet <> 0 BEGIN
		ROLLBACK TRAN
		SET @nCharNo = -4
		RETURN
	END
	ELSE BEGIN
		COMMIT TRAN
	END
END