Ep.5 Shaiya item mall Error= 0

2012-09-05 06:58:39 PS_DBAGENT__system log start (DBAgent01)

2012-09-05 06:58:42 connect game, Name=



2012-09-05 06:58:42 connect game, Name=



2012-09-05 07:01:14 SaveBuyPointItem 1024 tyu qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(2,1024,30000,'B1_DispersionLoop','2012-09-05 07:01:14')}

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_User_BuyPointItems_NCash]    Script Date: 9/6/2012 4:08:40 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


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



ALTER Proc [dbo].[usp_Save_User_BuyPointItems_NCash]

@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@UseDate datetime

AS

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,@UseDate)
IF( @@ERROR<>0)
BEGIN
	GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF