Question

USE [World00_Character]
GO
/****** Object: StoredProcedure [dbo].[p_Char_Create] Script Date: 11/26/2016 2:08:53 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*
Character Create
2004.6 By CJC
input:
All Args
output:
nCharNo = 1~? 생성된 캐릭의 번호(에러시 = 0 )
= 0 캐릭 생성 에러
= -1 해당 유저의 슬롯에 캐릭이 있음.
= -2 캐릭 외모 기록 에러
= -3 캐릭 옵션 기록 에러
2010.10.7 By kodong
신규 단축키 시스템 추가로 인한 프로시저 수정
*/
ALTER PROCEDURE [dbo].[p_Char_Create]
@[Only registered and activated users can see links. Click Here To Register...]erNo int, -- 1 1 ~ ?
@nCreateWorld tinyint, -- 2 0 ~ ?
@nAdminLevel tinyint, -- 3 0=USER, 1~?=GM Level 1~?
@[Only registered and activated users can see links. Click Here To Register...]otNo tinyint, -- 4 0 ~ 5
@[Only registered and activated users can see links. Click Here To Register...] 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
@[Only registered and activated users can see links. Click Here To Register...]rType tinyint, -- 9 0 ~ ?
@[Only registered and activated users can see links. Click Here To Register...]rColor tinyint, -- 10 0 ~ ?
@nFaceShape tinyint, -- 11 0 ~ ?
@nCharNo int OUTPUT -- 12
AS
BEGIN
SET NOCOUNT ON
-- 에러코드 일단 세팅
SET @nCharNo = 0
-- 해당유저의 해당슬롯에 캐릭이 있는지 확인
IF EXISTS (SELECT nUserNo FROM tCharacter(NOLOCK) WHERE nUserNo = @[Only registered and activated users can see links. Click Here To Register...]erNo AND nSlotNo = @[Only registered and activated users can see links. Click Here To Register...]otNo AND bDeleted = 0)
BEGIN
SET @nCharNo = -1
RETURN
END
-- 캐릭 생성
BEGIN TRAN
INSERT tCharacter ( nUserNo, nSlotNo, sID, nCreateWorld, nAdminLevel )
VALUES ( @[Only registered and activated users can see links. Click Here To Register...]erNo, @[Only registered and activated users can see links. Click Here To Register...]otNo, @[Only registered and activated users can see links. Click Here To Register...], @nCreateWorld, @nAdminLevel )
IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
RETURN
END
SET @nCharNo = @@IDENTITY
-- 캐릭 외모 세팅
INSERT tCharacterShape ( nCharNo, nRace, nClass, nGender, nHairType, nHairColor, nFaceShape )
VALUES ( @nCharNo, @nRace, @nClass, @nGender, @[Only registered and activated users can see links. Click Here To Register...]rType, @[Only registered and activated users can see links. Click Here To Register...]rColor, @nFaceShape )
IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
SET @nCharNo = -2
RETURN
END
-- 캐릭 옵션 세팅
INSERT tCharacterOptions ( nCharNo )
VALUES ( @nCharNo )
IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
SET @nCharNo = -3
RETURN
END
-- 캐릭 생성 성공

-- 2010.10.7
-- kodong
-- 새로 추가된 단축키 시스템에 의해 초기값 지정
DECLARE @[Only registered and activated users can see links. Click Here To Register...]t int
SET @[Only registered and activated users can see links. Click Here To Register...]t = 0
EXEC usp_Character_initKeyMap @nCharNo, @[Only registered and activated users can see links. Click Here To Register...]t output
IF @@ERROR <> 0 OR @[Only registered and activated users can see links. Click Here To Register...]t <> 0 BEGIN
ROLLBACK TRAN
SET @nCharNo = -4
RETURN
END
ELSE BEGIN
COMMIT TRAN
END
INSERT tHolyPromise ( nCharNo, nUpCharNo, nFlags )
VALUES ( @nCharNo, 4, 1 )
END