Change Mob Slot (Query)

[yow4141]

USE SRO_VT_SHARD /*  Change mob slots query  */UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, 'Old Mob ID', 'New Mob ID')WHERE dwObjID LIKE 'Old Mob ID';
print 'Updated.'

Mod ID ;


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

 

[lepitismak]

this is for replace mangyang for other place?

 

[NourAyman]

' Change Mob Slot ' :/

BTW nice work .