[Hamza FiGo]

ونفس المسار بس انزل تحت شوية علي _UPDATE_USER_N_CHAR_GOLD حط الكيوري دا بدل اللي عندك

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_UPDATE_USER_N_CHAR_GOLD]    Script Date: 16/02/2015 05:21:07 م ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
ALTER  PROCEDURE [dbo].[_UPDATE_USER_N_CHAR_GOLD]
@UserJID 		AS INT,
@NewGold_User	AS BIGINT,
@CharID			AS INT,
@NewGold_Char	AS BIGINT
AS
	IF (@NewGold_User < 0 OR @NewGold_Char < 0)
	BEGIN
		RETURN -1
	END
BEGIN TRANSACTION
	
	UPDATE _AccountJID SET Gold = @NewGold_User WHERE JID = @UserJID
	IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
	BEGIN
		ROLLBACK TRANSACTION
		RETURN -2
	END
	UPDATE _Char SET RemainGold = @NewGold_Char WHERE CharID = @CharID
	IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
	BEGIN
		ROLLBACK TRANSACTION
		RETURN -3
	END
	
COMMIT TRANSACTION
	RETURN 1