vSRO - monsters replace

12/12/2018 15:39 Eljazar JR#1
Hello pvpers, i'd like to replace monster by another one
example:
i want to replace samarkand monsters with jangan cave monsters.
12/12/2018 15:46 MrCatGardens#2
cant remember exactly, but in one of the spawntables, you should only replace the mob ids. ofc, you have to search for the regions and so on to get the right locations. but isnt that difficult
12/12/2018 15:49 Ryotic#3
Quote:
Originally Posted by infinityProject View Post
cant remember exactly, but in one of the spawntables, you should only replace the mob ids. ofc, you have to search for the regions and so on to get the right locations. but isnt that difficult
Refnest as I remember

Sent from my Redmi Note 5 using Tapatalk
12/12/2018 16:52 $WeGs#4
Tab_RefTactics change objid
12/12/2018 20:06 ZαKuRα#5
He wants the query not to be explained :rolleyes: ..

Code:
USE SRO_VT_SHARD
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, 'OldMobID', 'NewMobID')WHERE dwObjID LIKE 'OldMobIDAgain';
Code:
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%'
12/13/2018 15:55 Eljazar JR#6
Quote:
Originally Posted by ZαKuRα View Post
He wants the query not to be explained :rolleyes: ..

Code:
USE SRO_VT_SHARD
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, 'OldMobID', 'NewMobID')WHERE dwObjID LIKE 'OldMobIDAgain';
Code:
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%'
Useful , thank you :)
12/14/2018 11:17 MrCatGardens#7
Quote:
Originally Posted by ZαKuRα View Post
He wants the query not to be explained :rolleyes: ..

Code:
USE SRO_VT_SHARD
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, 'OldMobID', 'NewMobID')WHERE dwObjID LIKE 'OldMobIDAgain';
Code:
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%'
Maybe he want to learn how shit works... not fek copypastamylife
12/14/2018 18:42 ZαKuRα#8
Quote:
Originally Posted by infinityProject View Post
Maybe he want to learn how shit works... not fek copypastamylife
I'm not interested in what you say in which you want to go, I only help the person who needs it and it's not your problem if it's a copy and paste the post to the end and the help is for the not for you I'm worth mother what you say
I come to help to solve not to make explanations without solution or to criticize others looking for something to do for the community ;)
12/14/2018 18:54 MrCatGardens#9
Quote:
Originally Posted by ZαKuRα View Post
I'm not interested in what you say in which you want to go, I only help the person who needs it and it's not your problem if it's a copy and paste the post to the end and the help is for the not for you I'm worth mother what you say
I come to help to solve not to make explanations without solution or to criticize others looking for something to do for the community ;)
wtf i've just read? bb worthy mother :pimp:
12/14/2018 19:08 ZαKuRα#10
:)
12/16/2018 09:12 Eljazar JR#11
Quote:
Originally Posted by infinityProject View Post
Maybe he want to learn how shit works... not fek copypastamylife
I know to it works exactly. thank you.
#REQUEST for close.
02/20/2025 04:41 Kabloz™#12
Quote:
Originally Posted by Eljazar JR View Post
Hello pvpers, i'd like to replace monster by another one
example:
i want to replace samarkand monsters with jangan cave monsters.

to get mob id >

Code:
SELECT * FROM dbo._RefObjCommon WHERE CodeName128 LIKE 'ID MOB'
to replace >

Code:
USE SRO_VT_SHARD
UPDATE x SET x.dwObjID = 49118
FROM dbo.tab_refnest i
INNER JOIN dbo._RefRegion a ON a.wRegionID = i.nRegionDBID
INNER JOIN dbo.Tab_RefTactics x ON i.dwTacticsID = x.dwTacticsID INNER JOIN dbo._RefObjCommon s ON x.dwObjID=s.ID
WHERE a.ContinentName LIKE 'ARABIA_FIELD_02'