Shaiya dont save changes

[Sh1nra]

Hello epvp,

Shaiya don't save my changes

Logs:

--<begin>2012-11-07 23:53:12,Shinra,10245,[ADM]Shinra,5024

{?=call usp_Save_Char_Info_E(5024,65535, 0,5, 7,9,9,17,14,9, 3891,4078,552, 2,250, 20062681,0, 174.876587,117.044655,394.379028, 0,200,0,0,0, 0,0,0,0)}

EXEC usp_Save_User_StoredMoney_E 1,10245,52427420

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275284138688512, 0,0, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275284138950656, 0,1, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275284139016192, 0,2, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275284139081728, 0,3, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275284139147264, 0,4, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275361448099840, 0,5, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275202534309888, 0,7, 0, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275520362020864, 0,8, 0, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275520361889792, 0,9, 0, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275520361955328, 0,10, 0, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Del_E(5024,'3661282783151587328',0)}

{?=call Usp_Save_Char_Item_Add_E(5024,3661282783151587328, 1,1, 40255,40,255, 0, 0,0,0,0,0,0,'', 1, '2012-11-07 23:53:11', 'S')}

{?=call Usp_Save_Char_Item_Del_E(5024,'3661282783151652864',0)}

{?=call Usp_Save_Char_Item_Add_E(5024,3661282783151652864, 1,2, 40255,40,255, 0, 0,0,0,0,0,0,'', 1, '2012-11-07 23:53:11', 'S')}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661271912589361152, 1,14, 1200, 0,0,0,0,0,0,'±ao???àì??',1)}

{?=call Usp_Save_Char_ApplySkill_Del_E(5024,0,0,1)}

EXEC usp_Save_Char_QuickSlot_Del_E 5024

--<end>2012-11-07 23:53:12,Shinra,10245,[ADM]Shinra,5024

I tried to repair the Procedures but it was not helpful >.<

What can i do now ? o_O

[nephren]

usp_save_char_Item_add_e auch schon gefixed?
Oder andere Stored Procedures ?

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_Char_Item_Add_E] Script Date: 11/08/2012 06:05:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E 스크립트 날짜: 2006-04-11 오후 10:57:16 ******/


ALTER Proc [dbo].[usp_Save_Char_Item_Add_E]

@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@Maketime datetime,
@Maketype char(1)

AS

--SET NOCOUNT ON

IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END

INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)

IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

--SET NOCOUNT OFF

[Sh1nra]

Ja habe alle gefixxt die mir die logs anzeigen.

Habe sie von ner anderen Datenbank genommen wo ich mir sicher bin das es klappt..

Ok habs problem gefunden sry ^^

2012-11-08 10:55:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 65535., SQL STATE: 22003, NATIVE ERROR: 220 (0xDC)

2012-11-08 10:55:20 ::SaveCharacter 5024 [ADM]Shinra ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(5024,65535, 0,5, 7,9,9,17,14,9, -18528,-24373,31609, 2,297, 20062681,0, 189.547272,115.245277,388.143799, 0,200,0,0,0, 0,0,0,0, 0,0)}

2012-11-08 10:55:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 65535., SQL STATE: 22003, NATIVE ERROR: 220 (0xDC)

2012-11-08 10:55:20 ::SaveCharacter 5024 [ADM]Shinra ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(5024,65535, 0,5, 7,9,9,17,14,9, -18528,-24373,31609, 2,297, 20062681,0, 189.547272,115.245277,388.143799, 0,200,0,0,0, 0,0,0,0, 0,0)}

[Shaiya-Raze]

hat sich erledigt^^