[Release] Simple query to change mobs respawn place

[Luke*]

Hello , i would like to share this query that will make you able to change mobs respawn place's , Example : you can replace 74-76 Niya hunter mobs into Roc.mt

USE SRO_VT_SHARD
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, '[COLOR="Red"]OldMobID[/COLOR]', '[COLOR="Red"]NewMobID[/COLOR]')WHERE dwObjID LIKE '[COLOR="Red"]OldMobIDAgain[/COLOR]';

* You can also find the mob id's by using the querys

[B]Jangan mobs: select * from _RefObjCommon where CodeName128 like '%MOB_CH%'
Donwhang' mob: select * from _RefObjCommon where CodeName128 like '%MOB_WC%'
Donwhan mobs2: select * from _RefObjCommon where CodeName128 like '%MOB_OA%'
Hotan mobs : select * from _RefObjCommon where CodeName128 like '%MOB_KT%'
Karakoram mobs : select * from _RefObjCommon where CodeName128 like '%MOB_KK%'
Taklamakan mob : select * from _RefObjCommon where CodeName128 like '%MOB_TK%'
Downhang Cave' mob : select * from _RefObjCommon where CodeName128 like '%MOB_DH%'
Roc Mountain' mob : select * from _RefObjCommon where CodeName128 like '%MOB_RM%'
Constantinople mob : select * from _RefObjCommon where CodeName128 like '%MOB_EU%'
Samarkand mob: select * from _RefObjCommon where CodeName128 like '%MOB_AM%'
Samarkand' mob  : select * from _RefObjCommon where CodeName128 like '%MOB_CA%'
Jangan cave' mob : select * from _RefObjCommon where CodeName128 like '%MOB_TQ%'
Alexandria' mob : select * from _RefObjCommon where CodeName128 like '%MOB_SD%'
Jupiter'deki mob : select * from _RefObjCommon where CodeName128 like '%MOB_JUPITER%'
Forgotten World' Mob : select * from _RefObjCommon where CodeName128 like '%MOB_GOD%'[/B]

Credits goes to StrawBerry.

[PortalDark]

#approved

[egystorm]

Nice

[dobesbal]

is it working?

[X-Vortex]

useful