PRODUCER

[Dev.Ahmed_Elnashary]

GO
/****** Object:  StoredProcedure [dbo].[D10_SWITCHER]    Script Date: 19/04/39 04:21:22 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****** Object:  StoredProcedure [dbo].[D10_SWITCHER]    Script Date: 6/6/2015 8:10:36 AM ******/

ALTER PROCEDURE [dbo].[D10_SWITCHER] 
-- ============================================= 
/*
Eslam ******
*/
-- ============================================= 
  @CharID INT 


AS 
BEGIN 
--//---------------------------------------------------------------   
    

	DECLARE @INVSIZE TINYINT,
				@Top1Wep int,
				@OldItm int 
	
		Set @InvSize = (select InventorySize from SRO_VT_SHARD.._char where charid = @charid)
		set @Top1Wep = (select top 1 inv.itemid from SRO_VT_SHARD.._inventory inv inner join SRO_VT_SHARD.._items itm on inv.itemid = itm.id64
			where itm.refitemid in (select ItemID from D10_ModelSwitcher) and itm.serial64 > 0 and inv.itemid <> 0 and inv.slot between 13 and @InvSize and inv.charid = @charid )
		Set @OldItm = (select top 1 refitemid from SRO_VT_SHARD.._items where id64 <> 0 and id64 = @Top1Wep and serial64 > 0)
	if @Top1Wep > 0
	Begin
		Declare @NewItm int = case
			When @olditm in (select ItemID from D10_ModelSwitcher)
				then (select top 1 Newitemid from D10_ModelSwitcher where ItemID = @olditm )
		 end /* will destroy any item that he tries to switch if he dont have required items */
		update SRO_VT_SHARD.._items set RefItemID = @NewItm   where RefItemID = @OldItm and ID64 = @Top1Wep and Serial64 > 0
	End

	END

هنا في الPRODUCER بياخد من رقم 0 ل 13 في الاكونت عايزه يبقي 13 بس حاولت اعمله معرفتش ؟ حد عنده فكره اعمله ازاي ياخد رقم 13 ؟