İnstant level Eror

[rustem147]

How can I fix this error, emergency aid

[Mark.Teal1982]

try this one this is the one I used when my server was up and running

 Spoiler

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

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,
@CharID int = 0,
@NameCnt tinyint = 0

AS

SET NOCOUNT ON

DECLARE @Ret int
IF @Grow = 0 -- Easy mode
BEGIN
SET @Grow = 3
SET @Level = 15
SET @StatPoint = 135
SET @SkillPoint = 9999
SET @money = 10000000

IF @Job = 0
BEGIN
SET @Str = 19
END
ELSE IF @Job = 1
BEGIN
SET @rec = 17
END
ELSE IF @Job = 2
BEGIN
SET @dex = 20
END
ELSE IF @Job = 3
BEGIN
SET @luc = 17
END
ELSE IF @job = 4
BEGIN
SET @int = 20
END
ELSE IF @job = 5
BEGIN
SET @wis = 18
END

END

ELSE IF @Grow = 1 -- normal mode
BEGIN
SET @Grow = 3
SET @Level = 30
SET @StatPoint = 270
SET @SkillPoint = 9999
SET @money = 10000000

IF @Job = 0
BEGIN
SET @Str = 39
END
ELSE IF @Job = 1
BEGIN
SET @rec = 37
END
ELSE IF @Job = 2
BEGIN
SET @dex = 40
END
ELSE IF @Job = 3
BEGIN
SET @luc = 37
END
ELSE IF @job = 4
BEGIN
SET @int = 40
END
ELSE IF @job = 5
BEGIN
SET @wis = 39
END

END

ELSE IF @Grow = 2 -- Hard mode
BEGIN
SET @Grow = 3
SET @Level = 60
SET @StatPoint = 540
SET @SkillPoint = 9999
SET @money = 10000000

IF @Job = 0
BEGIN
SET @Str = 78
END
ELSE IF @Job = 1
BEGIN
SET @rec = 74
END
ELSE IF @Job = 2
BEGIN
SET @dex = 80
END
ELSE IF @Job = 3
BEGIN
SET @luc = 74
END
ELSE IF @job = 4
BEGIN
SET @int = 80
END
ELSE IF @job = 5
BEGIN
SET @wis = 78
END

END
ELSE IF @Grow = 3 -- Ultimate mode
BEGIN
SET @Grow = 3
SET @Level = 1
SET @StatPoint = 0
SET @SkillPoint = 9999
SET @money = 10000000
END

SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0
SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)

-- AUTO TAGS BY: ALCATRAZ --------------------------------------------------------------------
DECLARE @Status int, @Admin bit

SET @Status = (SELECT [Status] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

SET @CharName = CASE
WHEN @Status = 16 THEN '[ADM]' + @CharName
WHEN @Status = 32 THEN '[GM]' + @CharName
WHEN @Status = 48 THEN '[GMA]' + @CharName
WHEN @Status = 64 THEN '[GS]' + @CharName
WHEN @Status = 80 THEN '[GST]' + @CharName
END--------------------------------------------------------------------------------------------

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

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, @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, 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

my auto tag script is also in there but you can easily remove it if you wanted

auto level 15
auto level 30
auto level 60
pve level 1

[sony65]

Past this script in your database for no bug

 Spoiler

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]

@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
IF @Grow = 0 -- Easy mode
BEGIN
SET @Grow = 3
SET @Level = 15
SET @StatPoint = 126
SET @SkillPoint = 9999
SET @money = 700000000

IF @Job = 0
BEGIN
SET @Str = 28
END
ELSE IF @Job = 1
BEGIN
SET @rec = 26
END
ELSE IF @Job = 2
BEGIN
SET @dex = 33
END
ELSE IF @Job = 3
BEGIN
SET @luc = 27
END
ELSE IF @job = 4
BEGIN
SET @int = 29
END
ELSE IF @job = 5
BEGIN
SET @wis = 28
END

END

ELSE IF @Grow = 1 -- normal mode
BEGIN
SET @Grow = 3
SET @Level = 15
SET @StatPoint = 261
SET @SkillPoint = 9999
SET @money = 700000000

IF @Job = 0
BEGIN
SET @Str = 43
END
ELSE IF @Job = 1
BEGIN
SET @rec = 41
END
ELSE IF @Job = 2
BEGIN
SET @dex = 48
END
ELSE IF @Job = 3
BEGIN
SET @luc = 42
END
ELSE IF @job = 4
BEGIN
SET @int = 44
END
ELSE IF @job = 5
BEGIN
SET @wis = 43
END

END

ELSE IF @Grow = 2 -- Hard mode
BEGIN
SET @Grow = 3
SET @Level = 100
SET @StatPoint = 810
SET @SkillPoint = 9999
SET @money = 700000000

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END


END


ELSE IF @Grow = 3 -- Ultimate mode
BEGIN
SET @Grow = 3
SET @Level = 100
SET @StatPoint = 810
SET @SkillPoint = 9999
SET @money = 700000000

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END
END
SET @CharName = LTRIM(RTRIM(@CharName))
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

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, @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, 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

[rustem147]

How can I fix this problem ?

[SkuulCandy]

Just remove auto tag system:
You can edit this query for you need.

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 05/23/2015 22:25:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/******Query ******/

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,


@CharID int = 0,
@NameCnt tinyint = 0

AS

SET NOCOUNT ON

DECLARE @Ret int
IF @Grow = 0 -- Lv 15
BEGIN
SET @Grow = 3
SET @Level = 15
SET @StatPoint = 126
SET @SkillPoint = 9999
SET @money = 700000000

IF @Job = 0
BEGIN
SET @Str = 28
END
ELSE IF @Job = 1
BEGIN
SET @rec = 26
END
ELSE IF @Job = 2
BEGIN
SET @dex = 33
END
ELSE IF @Job = 3
BEGIN
SET @luc = 27
END
ELSE IF @job = 4
BEGIN 
SET @int = 29
END
ELSE IF @job = 5
BEGIN
SET @wis = 28
END

END

ELSE IF @Grow = 1 -- Lv 30
BEGIN
SET @Grow = 3
SET @Level = 30
SET @StatPoint = 261
SET @SkillPoint = 9999
SET @money = 700000000

IF @Job = 0
BEGIN
SET @Str = 43
END
ELSE IF @Job = 1
BEGIN
SET @rec = 41
END
ELSE IF @Job = 2
BEGIN
SET @dex = 48
END
ELSE IF @Job = 3
BEGIN
SET @luc = 42
END
ELSE IF @job = 4
BEGIN 
SET @int = 44
END
ELSE IF @job = 5
BEGIN
SET @wis = 43
END

END

ELSE IF @Grow = 2 -- Lv 60
BEGIN
SET @Grow = 3
SET @Level = 60
SET @StatPoint = 531
SET @SkillPoint = 9999
SET @money = 700000000

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN 
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END


END


ELSE IF @Grow = 3 -- Level 80
BEGIN
SET @Grow = 3
SET @Level = 80
SET @StatPoint = 711
SET @SkillPoint = 9999
SET @money = 700000000

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN 
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END
END
SET @CharName = LTRIM(RTRIM(@CharName))
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

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, @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, 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

Regards,