Replace mobs from one map to another

[pablitto18]

Hello everyone, does someone explain to me how to replace all the mobs of Constatinople with the mobs of Alexandria for example? or how can I do it manually

[ZαKuRα]

[Obyx]

1st get ID of mob
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'MOB_SD_ANUBIS'

2nd get dwTacticsID
USE [SRO_VT_SHARD]
SELECT [dwTacticsID] FROM [dbo].[Tab_RefTactics] WHERE (dwObjID LIKE 'UniqueID')

3rd get dwNestID
USE [SRO_VT_SHARD]
SELECT [dwNestID] FROM [dbo].[Tab_RefNest] WHERE (dwTacticsID LIKE 'dwTacticsID')

4th change nRegionDBID + fLocalPosX + fLocalPosY + fLocalPosZ to the Position you want

[pablitto18]

Thanks you i am already solved with this query

 Spoiler

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




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%'