Help with this

[[DEV]Wan]

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

[momocruz]

" maybe " you have trying

[[DEV]Wan]

Originally Posted by momocruz

" maybe " you have trying

what mean

[[MXD]Takeshi]

Originally Posted by [DEV]Wan

what mean

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

[[DEV]Wan]

Originally Posted by [MXD]Takeshi

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

really im testing mean Lol

[SnickQ]

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.

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

[[DEV]Wan]

Originally Posted by SnickQ

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

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