الموقع العربي الاول للعبة Silkroad Online

كود بلغة HTML:

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 ؟