كويرى علشان تمسح الايتم من الموبس

[mr_lekaa]

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

Query Delete Items Mobs--------------------------------------------------------------------------------------------- Declare @Mob varchar (max), @Item varchar (max) set @Mob = 'MOB_AR_SABRA_CACTUS' set @Item = 'ITEM_MALL_EQUIP_TRANSGENDER_NEW_03' delete from _RefMonster_AssignedItemDrop where RefMonsterID in (select ID from _RefObjCommon where CodeName128 like @Mob and RefItemID in (select ID from _RefObjCommon where CodeName128 like @Item ))