Vsro Mob Slot Değiştirme [New]
![Vsro Mob Slot Değiştirme [New]](https://vsrosunucu.com/images/blog/33-1737610006.jpg)
Vsro Mob Slot Değiştirme [New]
BLOG
Hali hazırda piyasada dolaşan Queryde 2 defa eski mob ID yazıyorduk..
Ancak bu Query de Eski Mob ID yi bir defa yazmanız yeterlidir..
SQL:
USE SRO_VT_SHARD
GO
Declare @EskiMobID int Select @EskiMobID = 'xxx'--Eski Mob ID nizi girin !
Declare @YeniMobID int Select @YeniMobID = 'yyy'--Yeni Mob ID nizi girin !
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, @EskiMobID, @YeniMobID)WHERE dwObjID LIKE @EskiMobID;
TÜM BÖLGELERE AİT MOB KODLARI
SQL:
Jangandaki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_CH%'
Donwhang'daki moblar 1: select * from _RefObjCommon where CodeName128 like '%MOB_WC%'
Donwhang'daki moblar 2: select * from _RefObjCommon where CodeName128 like '%MOB_OA%'
Hotandaki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_KT%'
Karakoramdaki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_KK%'
Taklamakan'daki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_TK%'
Downhang Cave'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_DH%'
Roc Mountain'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_RM%'
Constantinople'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_EU%'
Samarkand'daki moblar 1: select * from _RefObjCommon where CodeName128 like '%MOB_AM%'
Samarkand'daki moblar 2 : select * from _RefObjCommon where CodeName128 like '%MOB_CA%'
Jangan cave'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_TQ%'
Alexandria'daki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_SD%'
Jupiter'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_JUPITER%'
Forgotten World'deki moblar : select 38223* from _RefObjCommon where CodeName128 like '%MOB_GOD%'
