Help me please. Thank you
This is my table Create_Char_R
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 07/14/2015 08:01:21 ******/
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]
@ServerID tinyint,
@UserID varchar(12),
@UserUID int,
@CharName varchar(50) ,
@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex Tinyint,
@Level Smallint,
@Statpoint Smallint,
@Skillpoint Smallint,
@Str Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint,
@Wis Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,
/* 여기까지 인자값 주어져야 함 */
/* SP 내부 참조용 변수 */
@CharID int = 0,
@NameCnt tinyint = 0
AS
SET NOCOUNT ON
DECLARE @Ret int
SET @CharName = LTRIM(RTRIM(@CharName))
SET @SkillPoint = 5
SET @Ret = 0
SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)
IF(@NameCnt <> 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
DECLARE @MaxLevel int
SET @MaxLevel=60
SET @Str = (
CASE
WHEN @Family=0 AND @Job=0 THEN @Str + (@MaxLevel-1)
WHEN @Family=3 AND @Job=0 THEN @Str + (@MaxLevel-1) ELSE @Str END)
SET @Rec = (
CASE
WHEN @Family=0 AND @Job=1 THEN @Rec + (@MaxLevel-1)
WHEN @Family=3 AND @Job=1 THEN @Rec + (@MaxLevel-1) ELSE @Rec END)
SET @Dex = (
CASE
WHEN @Family=1 AND @Job=2 THEN @Dex + (@MaxLevel-1)
WHEN @Family=2 AND @Job=2 THEN @Dex + (@MaxLevel-1) ELSE @Dex END)
SET @Luc = (
CASE
WHEN @Family=1 AND @Job=3 THEN @Luc + (@MaxLevel-1)
WHEN @Family=3 AND @Job=3 THEN @Luc + (@MaxLevel-1) ELSE @Luc END)
SET @Int = (
CASE
WHEN @Family=1 AND @Job=4 THEN @Int + (@MaxLevel-1)
WHEN @Family=2 AND @Job=4 THEN @Int + (@MaxLevel-1) ELSE @Int END)
SET @Wis = (
CASE
WHEN @Family=0 AND @Job=5 THEN @Wis + (@MaxLevel-1)
WHEN @Family=2 AND @Job=5 THEN @Wis + (@MaxLevel-1) ELSE @Wis END)
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(@ServerID,@UserID, @UserUID, @CharName, @Slot, @Family, 3,
@Hair, @Face, @Size, @Job, @Sex, 60, 531, 999,
@Str, @Dex, @Rec, @Int, @Luc, @Wis, @HP, @MP, @SP, @Map, @Dir, @Exp, 500000,
@PosX, @PosY, @Posz, @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
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 07/14/2015 08:01:21 ******/
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]
@ServerID tinyint,
@UserID varchar(12),
@UserUID int,
@CharName varchar(50) ,
@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex Tinyint,
@Level Smallint,
@Statpoint Smallint,
@Skillpoint Smallint,
@Str Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint,
@Wis Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,
/* 여기까지 인자값 주어져야 함 */
/* SP 내부 참조용 변수 */
@CharID int = 0,
@NameCnt tinyint = 0
AS
SET NOCOUNT ON
DECLARE @Ret int
SET @CharName = LTRIM(RTRIM(@CharName))
SET @SkillPoint = 5
SET @Ret = 0
SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)
IF(@NameCnt <> 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
DECLARE @MaxLevel int
SET @MaxLevel=60
SET @Str = (
CASE
WHEN @Family=0 AND @Job=0 THEN @Str + (@MaxLevel-1)
WHEN @Family=3 AND @Job=0 THEN @Str + (@MaxLevel-1) ELSE @Str END)
SET @Rec = (
CASE
WHEN @Family=0 AND @Job=1 THEN @Rec + (@MaxLevel-1)
WHEN @Family=3 AND @Job=1 THEN @Rec + (@MaxLevel-1) ELSE @Rec END)
SET @Dex = (
CASE
WHEN @Family=1 AND @Job=2 THEN @Dex + (@MaxLevel-1)
WHEN @Family=2 AND @Job=2 THEN @Dex + (@MaxLevel-1) ELSE @Dex END)
SET @Luc = (
CASE
WHEN @Family=1 AND @Job=3 THEN @Luc + (@MaxLevel-1)
WHEN @Family=3 AND @Job=3 THEN @Luc + (@MaxLevel-1) ELSE @Luc END)
SET @Int = (
CASE
WHEN @Family=1 AND @Job=4 THEN @Int + (@MaxLevel-1)
WHEN @Family=2 AND @Job=4 THEN @Int + (@MaxLevel-1) ELSE @Int END)
SET @Wis = (
CASE
WHEN @Family=0 AND @Job=5 THEN @Wis + (@MaxLevel-1)
WHEN @Family=2 AND @Job=5 THEN @Wis + (@MaxLevel-1) ELSE @Wis END)
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(@ServerID,@UserID, @UserUID, @CharName, @Slot, @Family, 3,
@Hair, @Face, @Size, @Job, @Sex, 60, 531, 999,
@Str, @Dex, @Rec, @Int, @Luc, @Wis, @HP, @MP, @SP, @Map, @Dir, @Exp, 500000,
@PosX, @PosY, @Posz, @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
i just do it. Change 60 to 1






