İnstant level Eror

rustem147 · 05/20/2015, 18:30

How can I fix this error, emergency aid

Mark.Teal1982 · 05/20/2015, 20:08

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

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 · 05/21/2015, 05:28

Past this script in your database for no bug

Spoiler

rustem147 · 05/23/2015, 21:36

How can I fix this problem ?

SkuulCandy · 05/23/2015, 22:31

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

Spoiler

Code:

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,