Hey Shaiya developers Help with this

[[DEV]Wan]

Hello everyone I have dc rollback after buying something in itemall + dc11
After relog got the stuff disappeared Im already changed the Shaiya files DB And keep the Dc idk what I do now check this SS
It's possible someone help me please
In-game

my ep is 5.4

After After-Relog

2 weeks ago can not fixed

help the next---- Sorry for my bad English

Add me in skype live:dudinhas047

[perlisson]

Do not you even get tired of embarrassing yourself?

[SnickQ]

Why you not put logs in to spoiler and we have to waste our time to download yours logs?
Solution 1:

Solution 2:

USE PS_GameData
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

create Proc [dbo].[usp_Save_User_BuyPointItems2]
@ID int,
@CharID int, @oint int, @Code varchar(20), @ate datetime

AS

SET NOCOUNT ON
--SET XACT_ABORT ON

DECLARE @ype int
DECLARE @ int
DECLARE @Point int
DECLARE @OrderNumber int
DECLARE @Value int

SET @ = 0

SET @ype = 1 -- ??

BEGIN DISTRIBUTED TRANSACTION

/*========================================
??? ??
??? ?? ?? ?? UID ? ?? ?? UID? ??? ???? ???.
procRequestOrderProductByGame

???? UID @buyClientUserNumber BIGINT
???? UID @veClientUserNumber BIGINT
????? @itemCode VARCHAR(50)
?? ?? @Code SMALLINT OUTPUT
?? ? ?? @cashBalanceAfterOrder INT OUTPUT
???? @orderNumber INT OUTPUT

resultCode
0 ??
1 ????
2 ?? ??? ???? ??
3 ?? ???? ???? ??
5 DB??
6 ????
=========================================*/
EXEC @Value = game.PS_UserData.dbo.usp_Update_UserPoint @ID, @oint
IF ( @Value < 0 )
BEGIN
GOTO ERROR
END

/*IF ( @ <> 0 )
BEGIN
INSERT INTO PointErrorLog( UserUID, CharID, ProductCode, Ret) VALUES( @ID, @CharID, @Code, @ )
GOTO ERROR
END
---------------------------------------------
*/

-- ??? ?? ??
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate,RemainPoint,OrderNumber)
VALUES @ype @ID,@CharID @oint @Code @ate @Point,@OrderNumber)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

[[DEV]Wan]

Originally Posted by perlisson

Do not you even get tired of embarrassing yourself?

man please respect the post if you do not want see my post please quit the epvpers lol im want only a Help