[HELP]DC and rollback if store item in WH

08/15/2011 00:37 cosong#1

Hello guyz.

I have i some problem with DBs. My logs do not have any errors, but, if any toon stored item in WH and after play sometimes or try to log out he got ERROR 0, if toon log in again character are already rollback to back time (various time 10-30 min). All items and moves and quests are got deleted to back because character got rollback. My PS_DBAGENT log are clear, not have any errors, but have some querty names: Example:

Code:

--<begin>2011-08-14 15:27:38,toon,61,toon,180

{?=call usp_Save_Char_Info_E(180,11, 70,7, 7,9,9,18,14,9, 995,818,155, 2,204, 157251797,9619, 1025.432739,55.922813,1007.791138, 0,200,0,0,0, 0,0,0,0)}

EXEC usp_Save_User_StoredMoney_E 1,61,0

{?=call Usp_Save_User_StoredItem_Add_E(1,61,3322795783488667648, 0, 43004,43,4, 0, 0,0,0,0,0,0,'', 1, '2011-08-14 15:04:41', 'V')}

{?=call Usp_Save_Char_Skill_Mod_E(180,6,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,14,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,365,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,32,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,192,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,132,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,50,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,52,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,191,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,117,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,109,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(180,29,1,0)}

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

{?=call Usp_Save_Char_ApplySkill_Add_E2(180,116,1,1444)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(180,123,1,534)}

EXEC usp_Save_Char_QuickSlot_Del_E 180

EXEC usp_Save_Char_QuickSlot_Add_E 180,0,0,100,29

EXEC usp_Save_Char_QuickSlot_Add_E 180,0,1,100,52

EXEC usp_Save_Char_QuickSlot_Add_E 180,0,2,100,50

EXEC usp_Save_Char_QuickSlot_Add_E 180,0,9,100,109

EXEC usp_Save_Char_QuickSlot_Add_E 180,10,0,100,132

EXEC usp_Save_Char_QuickSlot_Add_E 180,10,1,100,117

EXEC usp_Save_Char_QuickSlot_Add_E 180,10,2,100,191

--<end>2011-08-14 15:27:38,toon,61,toon,180

If not store any items in WH so not have any problem. Can help me anyone please? I think problem in usp_Save_Char_Info_E or Usp_Save_User_StoredItem_Add_E. But if i try cope this procedure from others DB's it to not fix it problem. What me wrong guyz?

Thank you.:(

Daily bump, guyz no any info?

08/17/2011 02:27 cosong#2

Bump

Guyz any have same problem?

02/19/2017 16:39 jecan#3

Hi, I have the same problem, try to solve it, but I can not figure out what happens if someone has the fix, thank you

02/20/2017 20:44 jecan#4

Hello, I solve the problem, I share it with you.

Use the following query

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_User_StoredItem_Add_E] Script Date: 02/20/2017 20:38:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

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

ALTER Proc [dbo].[usp_Save_User_StoredItem_Add_E]
@[Only registered and activated users can see links. Click Here To Register...]ID tinyint, @[Only registered and activated users can see links. Click Here To Register...]ID int,
@ItemUID bigint, @[Only registered and activated users can see links. Click Here To Register...] tinyint,
@ItemID int, @[Only registered and activated users can see links. Click Here To Register...] tinyint, @[Only registered and activated users can see links. Click Here To Register...]ID tinyint, @[Only registered and activated users can see links. Click Here To Register...] smallint,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@Maketime datetime2,
@Maketype char(1)

AS

--SET NOCOUNT ON

INSERT INTO UserStoredItems
(ServerID, UserUID, Slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...], @ItemID, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ID, @ItemUID, @[Only registered and activated users can see links. Click Here To Register...], @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

04/01/2018 16:37 [PH]KEO(DEV)#5

Quote:

Originally Posted by jecan

Hello, I solve the problem, I share it with you.

Use the following query

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_User_StoredItem_Add_E] Script Date: 02/20/2017 20:38:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

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

ALTER Proc [dbo].[usp_Save_User_StoredItem_Add_E]
@[Only registered and activated users can see links. Click Here To Register...]ID tinyint, @[Only registered and activated users can see links. Click Here To Register...]ID int,
@ItemUID bigint, @[Only registered and activated users can see links. Click Here To Register...] tinyint,
@ItemID int, @[Only registered and activated users can see links. Click Here To Register...] tinyint, @[Only registered and activated users can see links. Click Here To Register...]ID tinyint, @[Only registered and activated users can see links. Click Here To Register...] smallint,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@Maketime datetime2,
@Maketype char(1)

AS

--SET NOCOUNT ON

INSERT INTO UserStoredItems
(ServerID, UserUID, Slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...], @ItemID, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]ID, @ItemUID, @[Only registered and activated users can see links. Click Here To Register...], @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

this is working?