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 _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 _ModelSwitcher)
then (select top 1 Newitemid from _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
GO
Create Table
كود:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[_ModelSwitcher] Script Date: 6/6/2015 2:43:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_ModelSwitcher](
[ItemID] [int] NOT NULL,
[ItemCode] [varchar](max) NOT NULL,
[NewitemID] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
_AddLogItem > SRO_VT_SHARDLOG
كود:
if (@ItemRefID = 125892)
BEGIN
EXEC SRO_VT_SHARDLOG.dbo._NOVA_SWITCHER @CharID
END
بعد كل ده هتفتح _ModelSwitcher فى SRO_VT_SHARDLOG > _Table
هتخش عليها
هتلاقى زى الصورة كده بس هتبقى عندك فاضية
فى ItemID هتحط رقم السلاح اللى عايز تغير شكله و الرقم ده فى _RefObjCommon
و فى NewItemID هتحط رقم السلاح الجديد اللى بالشكل الجديد طبعا http://up.dev-point.com/uploads1/af21a9ca286e1.png
ملحوظة : لازم تضيف السلاح من اول و جديد ب سطور جديدة و كده
علشان الشغلانة اللى بتعملها السكرول هيا انها بتنقل السلاح القديم بالرقم القديم الى السلاح الجديد و الرقم الجديد و بنفس البلص و كل حاجة
