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