xp kill

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 05/19/2012 18:11:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** 개체: 저장 프로시저 dbo.usp_Create_Char_R 스크립트 날짜: 2006-05-30 오후 12:53:23 ******/

ALTER Proc [dbo].[usp_Create_Char_R]

@[Only registered and activated users can see links. Click Here To Register...]ID tinyint,
@[Only registered and activated users can see links. Click Here To Register...] varchar(12),
@[Only registered and activated users can see links. Click Here To Register...]ID int,
@CharName varchar(50) ,

@[Only registered and activated users can see links. Click Here To Register...] Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@[Only registered and activated users can see links. Click Here To Register...] Tinyint,
@Job Tinyint,
@[Only registered and activated users can see links. Click Here To Register...] Tinyint,
@Level Smallint,
@[Only registered and activated users can see links. Click Here To Register...]point Smallint,
@[Only registered and activated users can see links. Click Here To Register...] Smallint,
@[Only registered and activated users can see links. Click Here To Register...] Smallint,
@Dex Smallint, @[Only registered and activated users can see links. Click Here To Register...] Smallint,
@Int Smallint, @[Only registered and activated users can see links. Click Here To Register...] Smallint,
@[Only registered and activated users can see links. Click Here To Register...] Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint, @[Only registered and activated users can see links. Click Here To Register...] Smallint,
@Dir Smallint,
@Exp Int, @[Only registered and activated users can see links. Click Here To Register...] Int, @[Only registered and activated users can see links. Click Here To Register...]x Real, @[Only registered and activated users can see links. Click Here To Register...] Real, @[Only registered and activated users can see links. Click Here To Register...] Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,


/* 여기까지 인자값 주어져야 함 */

/* SP 내부 참조용 변수 */

@CharID int = 0, @[Only registered and activated users can see links. Click Here To Register...]nt tinyint = 0

AS

SET NOCOUNT ON

DECLARE @[Only registered and activated users can see links. Click Here To Register...] int
IF @Grow = 0 -- Easy mode
BEGIN
SET @Grow = 3
SET @Level = 15
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 126
SET @[Only registered and activated users can see links. Click Here To Register...] = 9999
SET @[Only registered and activated users can see links. Click Here To Register...] = 2000000
SET @[Only registered and activated users can see links. Click Here To Register...] = 42
SET @[Only registered and activated users can see links. Click Here To Register...]X = 51.712
SET @[Only registered and activated users can see links. Click Here To Register...] = 1.861
SET @[Only registered and activated users can see links. Click Here To Register...] = 52.937

IF @Job = 0
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 28
END
ELSE IF @Job = 1
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 26
END
ELSE IF @Job = 2
BEGIN
SET @dex = 33
END
ELSE IF @Job = 3
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 27
END
ELSE IF @job = 4
BEGIN
SET @int = 29
END
ELSE IF @job = 5
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 28
END

END

ELSE IF @Grow = 1 -- normal mode
BEGIN
SET @Grow = 3
SET @Level = 30
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 261
SET @[Only registered and activated users can see links. Click Here To Register...] = 9999
SET @[Only registered and activated users can see links. Click Here To Register...] = 2000000
SET @[Only registered and activated users can see links. Click Here To Register...] = 42
SET @[Only registered and activated users can see links. Click Here To Register...]X = 51.712
SET @[Only registered and activated users can see links. Click Here To Register...] = 1.861
SET @[Only registered and activated users can see links. Click Here To Register...] = 52.937

IF @Job = 0
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 43
END
ELSE IF @Job = 1
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 41
END
ELSE IF @Job = 2
BEGIN
SET @dex = 48
END
ELSE IF @Job = 3
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 42
END
ELSE IF @job = 4
BEGIN
SET @int = 44
END
ELSE IF @job = 5
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 43
END

END

ELSE IF @Grow = 2 -- Hard mode
BEGIN
SET @Grow = 3
SET @Level = 60
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 531
SET @[Only registered and activated users can see links. Click Here To Register...] = 9999
SET @[Only registered and activated users can see links. Click Here To Register...] = 2000000
SET @[Only registered and activated users can see links. Click Here To Register...] = 42
SET @[Only registered and activated users can see links. Click Here To Register...]X = 51.712
SET @[Only registered and activated users can see links. Click Here To Register...] = 1.861
SET @[Only registered and activated users can see links. Click Here To Register...] = 52.937

IF @Job = 0
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 73
END
ELSE IF @Job = 1
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 73
END


END


ELSE IF @Grow = 3 -- Ultimate mode
BEGIN
SET @Grow = 3
SET @Level = 70
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 675
SET @[Only registered and activated users can see links. Click Here To Register...] = 9999
SET @[Only registered and activated users can see links. Click Here To Register...] = 2000000
SET @[Only registered and activated users can see links. Click Here To Register...] = 42
SET @[Only registered and activated users can see links. Click Here To Register...]X = 51.712
SET @[Only registered and activated users can see links. Click Here To Register...] = 1.861
SET @[Only registered and activated users can see links. Click Here To Register...] = 52.937

IF @Job = 0
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 73
END
ELSE IF @Job = 1
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 73
END
END
SET @CharName = LTRIM(RTRIM(@CharName))
SET @[Only registered and activated users can see links. Click Here To Register...] = 0



SET @[Only registered and activated users can see links. Click Here To Register...]nt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)

IF @[Only registered and activated users can see links. Click Here To Register...]nt <> 0)
BEGIN
RETURN -2
END
ELSE
BEGIN
IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@CharName AND Del = 1 AND [Level] >10 AND DeleteDate > DATEADD(dd, -7, GETDATE()) )
BEGIN
RETURN -2
END

BEGIN TRANSACTION

INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow,
Hair, Face, [Size], Job, Sex, [Level], StatPoint, SkillPoint,
[Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, Posz, Hg, Vg, Cg, Og, Ig, RenameCnt, RemainTime)

VALUES @[Only registered and activated users can see links. Click Here To Register...]ID @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ID, @CharName, @[Only registered and activated users can see links. Click Here To Register...], @Family, @Grow,
@Hair, @Face, @[Only registered and activated users can see links. Click Here To Register...], @Job, @[Only registered and activated users can see links. Click Here To Register...], @Level, @[Only registered and activated users can see links. Click Here To Register...]Point, @[Only registered and activated users can see links. Click Here To Register...],
@[Only registered and activated users can see links. Click Here To Register...], @Dex, @[Only registered and activated users can see links. Click Here To Register...], @Int, @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...], @HP, @MP, @SP, @[Only registered and activated users can see links. Click Here To Register...], @Dir, @Exp, @[Only registered and activated users can see links. Click Here To Register...],
@[Only registered and activated users can see links. Click Here To Register...]X, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...], @Hg, @Vg, @Cg, @Og, @Ig, 0, 0)

IF( @@ERROR=0 )
BEGIN
COMMIT TRANSACTION
END
ELSE
BEGIN
ROLLBACK TRANSACTION
RETURN -1
END

SET @CharID = IDENT_CURRENT('Chars')
END

RETURN @CharID

SET NOCOUNT OFF