عاوز امسح mobs ال في Samarkand واغيرها mobs lvl 100 و لفل 98

[gedso01]

want to delete mobs from Samarkand and change it mobs lvl 100 and 98 silkroad8

[gedso01]

up

[gedso01]

up

[Hell_Boy]

داه عشان تغير بي ال mops
USE SRO_VT_SHARD
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, 'Old mops id', 'New mops id') WHERE dwObjID LIKE 'Old mops id';

و داه عشان تجيب بي ال id
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'MOB_SD_ANUBIS'

وداه اسما ال mops

Mobs in jangan: select * from _RefObjCommon where CodeName128 like '% MOB_CH%'
mobs in Donwhang 1: select * from _RefObjCommon where CodeName128 like '% MOB_ WC %'
Mobs in Donwhang 2: select * from _RefObjCommon like CodeName12 ' OA % '
Mobs in hot: select * from _RefObjCommon where CodeName128 like'% MOB_ KT % '
Mobs in my Karakoram: select * from _RefObjCommon where CodeName128 like'% MOB_ KK % '
Mobs in Taklamakan: select * from _RefObjCommon like Code%' _ TK % '
Downhang Cave'select * from _RefObjCommon where CodeName128 like '% MOB_ DH %'
mobs in Roc Mountain: select * from _RefObjCommon where CodeName128 like '% MOB_ RM %'
mobs in Constantinople: select * from _RefObjCommon where CodeName128 like '% MOB_ EU %'
Mobiles in Samarkand 1: select * from _RefObjCommon where CodeName128 like '% MOB_ AM %'
Mobiles in Samarkand 2: select * from _RefObjCommon where CodeName128 like '% MOB_ CA %'
Mobiles in Jangan cave: select * from _RefObjComm8 where CodeName12N like '% MOB_TQ %'
mobs in Alexandria:select * from _RefObjCommon where CodeName128 like '% MOB_SD %'
mobs in Jupiter: select * from _RefObjCommon where CodeName128 like '% MOB_JUPITER %'
mobs in Forgotten World: select * from _RefObjCommon where CodeName128 like '% MOB_GOD %