اقتباس:
المشاركة الأصلية كتبت بواسطة M@hmoud
برضه كتب انه نجح بس ما مسحشى حاجه
وجربت كيورى دا مسح كل الحيوانات اللى بتلم جولد واللى اتاك وكل حاجه تخص الحيوانات انا كنت عايز امسح بيت اللى بتلم جولد بس
كود:
USE [SRO_VT_SHARD]
DECLARE @Codename128 VARCHAR(128)SET @Codename128 = '%cos%' -- 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 like @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 like @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 like @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 like @Codename128
|
انا شايف ان مشكلة حضرتك اتحلت
افضل جواب بعد اذنك