PHP Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[D10_SWITCHER] Script Date: 20/04/39 07:36:19 م ******/
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 Galull
*/
-- =============================================
[MENTION=395373]Chari[/MENTION]D INT
AS
BEGIN
--//---------------------------------------------------------------
DECLARE [MENTION=465749]inv[/MENTION]SIZE TINYINT,
[MENTION=632215]top1[/MENTION]Wep int,
[MENTION=343923]oldi[/MENTION]tm int
Set [MENTION=465749]inv[/MENTION]Size = (select InventorySize from SRO_VT_SHARD.._char where charid = [MENTION=395373]Chari[/MENTION]d)
set [MENTION=632215]top1[/MENTION]Wep = (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 [MENTION=465749]inv[/MENTION]Size and inv.charid = [MENTION=395373]Chari[/MENTION]d )
Set [MENTION=343923]oldi[/MENTION]tm = (select top 1 refitemid from SRO_VT_SHARD.._items where id64 <> 0 and id64 = [MENTION=632215]top1[/MENTION]Wep and serial64 > 0)
if [MENTION=632215]top1[/MENTION]Wep > 0
Begin
Declare [MENTION=2474014]newit[/MENTION]m int = case
When [MENTION=343923]oldi[/MENTION]tm in (select ItemID from D10_ModelSwitcher)
then (select top 1 Newitemid from D10_ModelSwitcher where ItemID = [MENTION=343923]oldi[/MENTION]tm )
end /* will destroy any item that he tries to switch if he dont have required items */
update SRO_VT_SHARD.._items set RefItemID = [MENTION=2474014]newit[/MENTION]m where RefItemID = [MENTION=343923]oldi[/MENTION]tm and ID64 = [MENTION=632215]top1[/MENTION]Wep and Serial64 > 0
End
END
thank you