Dev.Ahmed_Elnashary
06-01-2018, 04:22 AM
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 ؟
/****** 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 ؟