ERROR 10053 VERIFY NAME

Good night. Somebody can help me with my problem? i used shen's file and l later of use sql script i have this problem: when i want create some character and verify his name i have this error "error 10053" and server go down
Sorry about my bad english.
INFO: SQL 2008 R2
Shen's file
Database: "ShaiyaServerFiles EP6 2016 Full"

PS_GAME REGISTER:2018-01-30 03:07:10 PS_GAME__system log start (Game01) [GERMANY]

2018-01-30 03:07:10 RandomOption Error : ItemID=24070, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24111, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24112, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24118, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24119, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24125, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24126, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24154, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24240, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24249, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24250, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24251, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24252, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24253, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=24254, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=39070, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=39111, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=39112, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=39118, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=39119, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=39125, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=39126, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=39154, byServer=2, Wis=0

2018-01-30 03:07:10 RandomOption Error : ItemID=39240, byServer=2, Wis=0

2018-01-30 03:07:17 connect mgr 1416

2018-01-30 03:07:17 Server Version : 11093000

2018-01-30 03:07:17 connect dbagent 360

2018-01-30 03:07:17 connect gamelog 1424

2018-01-30 03:07:17 Market End -----------------------

2018-01-30 03:07:18 Start CWorldSendThread=4172

Module list:

C:\ShaiyaServer\PSM_Client\bin\ps_game.exe, loaded at 0x00400000 - 11/09/14 17:10:08

2018-01-30 03:07:25 <Console input> /nprotectoff

2018-01-30 03:07:25 <Console output> cmd NProtect off ok


thank you so much to everyone!

easy use this script it will work fine

[Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by Wa7dani easy use this script it will work fine [Only registered and activated users can see links. Click Here To Register...]

Hi,
had the same problem some days ago. I just see an Instant Level Script? Was changed from an normal Char Create procedure?

sorry but this script don't work. Thank you so much of your answer. Somebody can help me with other idea?

use ps_gamedefs
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO




create Proc [dbo].[AvailiableCharName] @[Only registered and activated users can see links. Click Here To Register...] varchar(20), @[Only registered and activated users can see links. Click Here To Register...]iable int OUTPUT

AS

SET NOCOUNT ON

set @[Only registered and activated users can see links. Click Here To Register...]iable=1

if exists(select * from ps_gamedata.dbo.chars where charname @[Only registered and activated users can see links. Click Here To Register...])
begin
set @[Only registered and activated users can see links. Click Here To Register...]iable=0
end





return

SET NOCOUNT OFF




GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

Update ps_gamedefs.dbo.items Set server = 0 where ReqWis = 0


For RandomOption Error

I was use it and not works. Thank you. I have other question, somebody know how i can edit my shaiya server to add new gear? i saw some tutorial for recolor but don't work for me or i don't unsderstand, idk. Someoney can give me any tutorial? and how i can make patch for get this gear on my server n.n