خد يا باشا الكيوري دا هيشيلك اي ايتم من البلايرس كلها ان كان فى Char Inventory , Pet Inventory or Account Storage .
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 ))
17-01-2015, 03:25 AM
المواضيع المتشابهه
.gif){kind=icon}
العرض المتطور
