| mr_lekaa |
14-07-2014 06:11 AM |
كويرى علشان تمسح الايتم من الموبس
الكويرى ده علشان تمسح الايتم دروب من الموبس وهو سهل مش محتاج شرح
اقتباس:
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 ))
|
|
