اقتباس:
المشاركة الأصلية كتبت بواسطة mohamed habib
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
طيب جرب دا كدا
كود PHP:
USE [SRO_VT_SHARD] --- Coded by [iLegend]
Declare @ItemCodeName Varchar (129)
Set @ItemCodeName = 'CodeName128' --- write here the item codename128 that u want to remove it from all players.
Update _Chest Set ItemID = 0
where ItemID in ( Select ID64 From _Items where RefItemID = (Select ID From _RefObjCommon where CodeName128 = @ItemCodeName ))
Update _Inventory Set ItemID = 0
where ItemID in ( Select ID64 From _Items where RefItemID = (Select ID From _RefObjCommon where CodeName128 = @ItemCodeName ))
Update _InvCOS Set ItemID = 0
where ItemID in ( Select ID64 From _Items where RefItemID = (Select ID From _RefObjCommon where CodeName128 = @ItemCodeName ))
|
برضه كتب انه نجح بس ما مسحشى حاجه
وجربت كيورى دا مسح كل الحيوانات اللى بتلم جولد واللى اتاك وكل حاجه تخص الحيوانات انا كنت عايز امسح بيت اللى بتلم جولد بس
كود:
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