ERROR 10053 VERIFY NAME

[dorado1234]

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!

[Wa7dani]

easy use this script it will work fine

[{Skrillex}]

Originally Posted by Wa7dani

easy use this script it will work fine

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

[dorado1234]

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

[Jatsuetu]

use ps_gamedefs
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO




create Proc [dbo].[AvailiableCharName] @ varchar(20), @iable int OUTPUT

AS

SET NOCOUNT ON

set @iable=1

if exists(select * from ps_gamedata.dbo.chars where charname @)
begin
set @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

[dorado1234]

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