Why you not put logs in to spoiler and we have to waste our time to download yours logs?
Solution 1:
[Only registered and activated users can see links. Click Here To Register...]
Solution 2:
USE PS_GameData
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create Proc [dbo].[usp_Save_User_BuyPointItems2]
@
[Only registered and activated users can see links. Click Here To Register...]ID int,
@CharID int, @
[Only registered and activated users can see links. Click Here To Register...]oint int, @
[Only registered and activated users can see links. Click Here To Register...]Code varchar(20), @
[Only registered and activated users can see links. Click Here To Register...]ate datetime
AS
SET NOCOUNT ON
--SET XACT_ABORT ON
DECLARE @
[Only registered and activated users can see links. Click Here To Register...]ype int
DECLARE @
[Only registered and activated users can see links. Click Here To Register...] int
DECLARE @
[Only registered and activated users can see links. Click Here To Register...]Point int
DECLARE @OrderNumber int
DECLARE @
[Only registered and activated users can see links. Click Here To Register...]Value int
SET @
[Only registered and activated users can see links. Click Here To Register...] = 0
SET @
[Only registered and activated users can see links. Click Here To Register...]ype = 1 -- ??
BEGIN DISTRIBUTED TRANSACTION
/*========================================
??? ??
??? ?? ?? ?? UID ? ?? ?? UID? ??? ???? ???.
procRequestOrderProductByGame
???? UID @buyClientUserNumber BIGINT
???? UID @
[Only registered and activated users can see links. Click Here To Register...]veClientUserNumber BIGINT
????? @itemCode VARCHAR(50)
?? ?? @
[Only registered and activated users can see links. Click Here To Register...]Code SMALLINT OUTPUT
?? ? ?? @cashBalanceAfterOrder INT OUTPUT
???? @orderNumber INT OUTPUT
resultCode
0 ??
1 ????
2 ?? ??? ???? ??
3 ?? ???? ???? ??
5 DB??
6 ????
=========================================*/
EXEC @
[Only registered and activated users can see links. Click Here To Register...]Value = game.PS_UserData.dbo.usp_Update_UserPoint @
[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...]oint
IF ( @
[Only registered and activated users can see links. Click Here To Register...]Value < 0 )
BEGIN
GOTO ERROR
END
/*IF ( @
[Only registered and activated users can see links. Click Here To Register...] <> 0 )
BEGIN
INSERT INTO PointErrorLog( UserUID, CharID, ProductCode, Ret) VALUES( @
[Only registered and activated users can see links. Click Here To Register...]ID, @CharID, @
[Only registered and activated users can see links. Click Here To Register...]Code, @
[Only registered and activated users can see links. Click Here To Register...] )
GOTO ERROR
END
---------------------------------------------
*/
-- ??? ?? ??
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate,RemainPoint,OrderNumber)
VALUES @
[Only registered and activated users can see links. Click Here To Register...]ype @
[Only registered and activated users can see links. Click Here To Register...]ID,@CharID @
[Only registered and activated users can see links. Click Here To Register...]oint @
[Only registered and activated users can see links. Click Here To Register...]Code @
[Only registered and activated users can see links. Click Here To Register...]ate @
[Only registered and activated users can see links. Click Here To Register...]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
