[Database] Update Equip.

[Mocro]

Clothes gets removed from players :

MMatchDBMgr::UpdateEquipedItem - FAILED(-1)MMatchDBMgr::UpdateEquipedItem - {CALL spUpdateEquipItem (14244, 11, 2356251, 40203)}
MMatchDBMgr::UpdateEquipedItem - FAILED(-1)
MMatchDBMgr::UpdateEquipedItem - {CALL spUpdateEquipItem (14244, 10, 2356252, 40003)}

i was looking at the code found :

USE [GunzDB]GO
/****** Object:  StoredProcedure [dbo].[spUpdateEquipItem]    Script Date: 08/09/2012 22:34:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spUpdateEquipItem]
-- ALTER PROC dbo.spUpdateEquipItem
	@CID		INT,
	@SlotID		INT,
	@CIID		INT,
	@ItemID		INT
AS BEGIN
 
	SET NOCOUNT ON;
  	
	IF( @CIID <> 0 ) BEGIN
	
		DECLARE @OldCIID INT;
		
		------------------------------------------------------------------
		
		IF( @SlotID = 10 ) BEGIN
		
			SELECT	@OldCIID = CIID
			FROM	CharacterEquipmentSlot(NOLOCK) 
			WHERE	CID = @CID 
			AND		CIID = @CIID
			AND		SlotID = 11;
			
			IF( @OldCIID IS NOT NULL ) BEGIN		
				SELECT -1 AS 'Ret';
				RETURN;				
			END			
		END
		ELSE IF( @SlotID = 11 ) BEGIn
		
			SELECT	@OldCIID = CIID
			FROM	CharacterEquipmentSlot(NOLOCK) 
			WHERE	CID = @CID 
			AND		CIID = @CIID
			AND		SlotID = 10;
			
			IF( @OldCIID IS NOT NULL ) BEGIN		
				SELECT -1 AS 'Ret';
				RETURN;				
			END			
		END	
		
		------------------------------------------------------------------
	END
	
	
	UPDATE  dbo.CharacterEquipmentSlot
	SET		CIID = @CIID, ItemID = @ItemID
	WHERE	CID = @CID 
	AND		SlotID = @SlotID
			
	SELECT 0 AS 'Ret';
	RETURN;
	
END


----------------------------------------------------------------------------------------------------------------------------------------
-- º¹±¸ Äõ¸®
/*
DROP PROC spUpdateEquipItem
EXEC sp_rename 'BackUp_spUpdateEquipItem', 'spUpdateEquipItem'
*/

and i was thinking to remove the :

			IF( @OldCIID IS NOT NULL ) BEGIN						SELECT -1 AS 'Ret';
				RETURN;				
			END

is that a good idea or is it important
becaus now when you somtimes login your items get removed its anoying and they get in to your inventory.

[MentaL]