الزيرك

[احمدزهير]

لو سمحتم عايز الغلى كل الزيرك الى مع الناس علشان معاهم زيرك كتير اوى

وجربت الكيورى ده ما نفعش

USE [SRO_VT_SHARD]

Exec [Dbo].[_SEEK_N_DESTROY_ITEM] ['ITEM Code Name' ]

بيكتبلى

Unknown Item
Msg 50000, Level 1, State 16
ياريت مساعده مش عايز حد معاه زيرك فى الجيم

[Hamza FiGo]

USE [SRO_VT_SHARD]

/* ***** -HiwatariKai* ***** */


DECLARE @Codename128 VARCHAR(128)SET @Codename128 = 'ITEM_MALL_GLOBAL_CHATTING' -- Write code to delete item
UPDATE _Inventory SET ItemID = 0 FROM _Inventory JOIN _Items ON _Items.ID64 = _Inventory.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _Chest SET ItemID = 0 FROM _Chest JOIN _Items ON _Items.ID64 = _Chest.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _GuildChest SET ItemID = 0 FROM _GuildChest JOIN _Items ON _Items.ID64 = _GuildChest.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _InvCOS SET ItemID = 0 FROM _InvCOS JOIN _Items ON _Items.ID64 = _InvCOS.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128

[احمدزهير]

تم الحل شكرا على المساعده

[Hamza FiGo]

##