Help with this

07/15/2018 14:39 [DEV]Wan#1

hello epvpers maybe my server running good without dc+11 idk after im executed the script of [Dev]HoaX got my itemall crashing im alrady changing db and server files not working keep dc idk how to fix It maybe im trying all post of epvpers noone working Thank you

07/15/2018 19:45 momocruz#2

" maybe " you have trying

07/16/2018 00:15 [DEV]Wan#3

Quote:

Originally Posted by momocruz

" maybe " you have trying

what mean

07/16/2018 00:39 [MXD]Takeshi#4

Quote:

Originally Posted by [DEV]Wan

what mean

:facepalm: you write maybe, so you didnt test it.... why ask in forum something before test urself what happens...

07/16/2018 01:13 [DEV]Wan#5

Quote:

Originally Posted by [MXD]Takeshi

:facepalm: you write maybe, so you didnt test it.... why ask in forum something before test urself what happens...

really im testing mean Lol

07/16/2018 08:17 SnickQ#6

Quote:

Originally Posted by [DEV]Wan

really im testing mean Lol

No you don't
I bet you didn't use stred proc from this itemmallfix which I sent you.

Code:

USE PS_GameData
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

create   Proc [dbo].[usp_Save_User_BuyPointItems2]

 [MENTION=2805776]UserU[/MENTION]ID int,
@CharID int,
 [MENTION=3541082]usep[/MENTION]oint int,
@ProductCode varchar(20),
 [MENTION=1469793]used[/MENTION]ate datetime

AS

SET NOCOUNT ON
--SET XACT_ABORT ON

DECLARE [MENTION=5706904]uset[/MENTION]ype 	int
DECLARE @Ret 		int
DECLARE @RemainPoint  	int
DECLARE @OrderNumber 	int
DECLARE [MENTION=326673]return[/MENTION]Value int

SET @Ret = 0

SET [MENTION=5706904]uset[/MENTION]ype = 1 -- ??

BEGIN DISTRIBUTED TRANSACTION

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

???? UID       @buyClientUserNumber               BIGINT
???? UID       @receiveClientUserNumber           BIGINT
?????         @itemCode                          VARCHAR(50)
?? ??          @resultCode                        SMALLINT           	OUTPUT
?? ? ??       @cashBalanceAfterOrder             INT                      	OUTPUT
????	   @orderNumber			      INT			OUTPUT

resultCode
0            ??
1            ????
2            ?? ??? ???? ??
3            ?? ???? ???? ??
5            DB??
6            ????
=========================================*/
EXEC [MENTION=326673]return[/MENTION]Value = game.PS_UserData.dbo.usp_Update_UserPoint [MENTION=2805776]UserU[/MENTION]ID, [MENTION=3541082]usep[/MENTION]oint
IF ( [MENTION=326673]return[/MENTION]Value < 0 )
BEGIN
	GOTO ERROR
END

/*IF ( @Ret <> 0 )
BEGIN  
	INSERT INTO PointErrorLog( UserUID, CharID, ProductCode, Ret) 	VALUES( [MENTION=2805776]UserU[/MENTION]ID, @CharID, @ProductCode, @Ret )
	GOTO ERROR
END
---------------------------------------------
*/

-- ??? ?? ??
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate,RemainPoint,OrderNumber)
VALUES [MENTION=5706904]uset[/MENTION]ype [MENTION=2805776]UserU[/MENTION]ID,@CharID [MENTION=3541082]usep[/MENTION]oint,@ProductCode [MENTION=1469793]used[/MENTION]ate,@RemainPoint,@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

07/16/2018 18:05 [DEV]Wan#7

Quote:

Originally Posted by SnickQ

No you don't
I bet you didn't use stred proc from this itemmallfix which I sent you.

Code:

USE PS_GameData
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

create   Proc [dbo].[usp_Save_User_BuyPointItems2]

 [MENTION=2805776]UserU[/MENTION]ID int,
@CharID int,
 [MENTION=3541082]usep[/MENTION]oint int,
@ProductCode varchar(20),
 [MENTION=1469793]used[/MENTION]ate datetime

AS

SET NOCOUNT ON
--SET XACT_ABORT ON

DECLARE [MENTION=5706904]uset[/MENTION]ype 	int
DECLARE @Ret 		int
DECLARE @RemainPoint  	int
DECLARE @OrderNumber 	int
DECLARE [MENTION=326673]return[/MENTION]Value int

SET @Ret = 0

SET [MENTION=5706904]uset[/MENTION]ype = 1 -- ??

BEGIN DISTRIBUTED TRANSACTION

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

???? UID       @buyClientUserNumber               BIGINT
???? UID       @receiveClientUserNumber           BIGINT
?????         @itemCode                          VARCHAR(50)
?? ??          @resultCode                        SMALLINT           	OUTPUT
?? ? ??       @cashBalanceAfterOrder             INT                      	OUTPUT
????	   @orderNumber			      INT			OUTPUT

resultCode
0            ??
1            ????
2            ?? ??? ???? ??
3            ?? ???? ???? ??
5            DB??
6            ????
=========================================*/
EXEC [MENTION=326673]return[/MENTION]Value = game.PS_UserData.dbo.usp_Update_UserPoint [MENTION=2805776]UserU[/MENTION]ID, [MENTION=3541082]usep[/MENTION]oint
IF ( [MENTION=326673]return[/MENTION]Value < 0 )
BEGIN
	GOTO ERROR
END

/*IF ( @Ret <> 0 )
BEGIN  
	INSERT INTO PointErrorLog( UserUID, CharID, ProductCode, Ret) 	VALUES( [MENTION=2805776]UserU[/MENTION]ID, @CharID, @ProductCode, @Ret )
	GOTO ERROR
END
---------------------------------------------
*/

-- ??? ?? ??
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate,RemainPoint,OrderNumber)
VALUES [MENTION=5706904]uset[/MENTION]ype [MENTION=2805776]UserU[/MENTION]ID,@CharID [MENTION=3541082]usep[/MENTION]oint,@ProductCode [MENTION=1469793]used[/MENTION]ate,@RemainPoint,@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

check Pm