IM DC

[SkuulCandy]

Hi i have a problem with my item mall,
when i buy any things, my account DC, NOT game service.
I use ep5 ps_game, ep5 client, sql 2008

Erorr log :

 Spoiler

2015-09-04 15:38:32 <Console input> /nprotectoff

2015-09-04 15:38:32 <Console output> cmd NProtect off ok

2015-09-04 15:39:34 connect mgr 1024

2015-09-04 15:39:34 connect dbagent 1056

2015-09-04 15:39:34 connect dbagent2 1060

2015-09-04 15:39:34 connect gamelog 1072

2015-09-04 15:39:34 Market End -----------------------

2015-09-04 15:39:35 Load Shaiya.SData 2

2015-09-04 15:39:56 error exp min usern=admin,charn=Sharyn, level=80,exp=0,exppv=1

2015-09-04 15:40:45 discon client: (104, 1236) T=000:01:00:000, RC=6,RCS=0, RB=69,RBS=1, SC=36,SCS=0, SB=1922,SBS=30

2015-09-04 15:41:13 error exp over usern=lovan,charn=Tod, level=80,exp=1,exppn=1

Distributed Transaction Coordinator IS RUNNING

3 days ago, my item mall worked...
and i haven't modified any things in Cash.Sdata ^^ the same into ps_game.

"Error" with exp ?
My EXPDEFS have for level 71-80 value 1 in EXP column and only grow UM.

71 4 1
72 4 1
73 4 1
...

Thanks

[SnickQ]

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_User_BuyPointItems_NCash]    Script Date: 2014-01-21 19:10:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****** Shoping Mall	Fixed by sandolkakos	Website: http://www.universalgamesonline.com.br ******/



ALTER Proc [dbo].[usp_Save_User_BuyPointItems_NCash]

@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@textDate varchar(30)

AS

DECLARE @UseTime datetime
set @UseTime=CONVERT(datetime, @textDate, 120) 

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @UseType int
DECLARE @ReturnValue int

SET @UseType = 1 -- ??

BEGIN DISTRIBUTED TRANSACTION


EXEC @ReturnValue = PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
IF ( @ReturnValue < 0 )
BEGIN
GOTO ERROR
END
-- ??? ??(Old, ?? UPDATE? ???? ????? ?? ???)
--UPDATE PS_UserData.dbo.Users_Master SET Point=Point-@UsePoint WHERE UserUID=@UserUID
--IF( @@ERROR<>0 OR @@ROWCOUNT=0)
--BEGIN
--	GOTO ERROR
--END

-- ??? ?? ??
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(@UseType,@UserUID,@CharID,@UsePoint,@ProductCode,@textDate)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

If this not help change your ps_gamelog.exe

[SkuulCandy]

Sql query doesn't fix, but i have change all .exe without ps_agme and .dll and it's fixed.
Thanks SnickQ