change Mobs Spawn

[kimo888]

want to delete mobs from Samarkand and change it mobs lvl 100 and lv 98

[sonzenbi]

Find SMK and qin-shi MOB with Qr:

 Spoiler

use SRO_VT_SHARD
select distinct c.CodeName128,ch.lvl,c.id from _RefObjCommon c
join _RefObjChar ch on ch.id = c.Link
join Tab_RefTactics t on t.dwObjID = c.ID
join Tab_RefNest n on n.dwTacticsID =
t.dwTacticsID where n.nRegionDBID in
(select wRegionID from _RefRegion where ContinentName = 'CA' or ContinentName = 'AM') and c.Rarity = 0 and ch.ExpToGive !=0 ORDER BY ch.Lvl
select distinct c.CodeName128,ch.lvl,c.id from _RefObjCommon c
join _RefObjChar ch on ch.id = c.Link
join Tab_RefTactics t on t.dwObjID = c.ID
join Tab_RefNest n on n.dwTacticsID =
t.dwTacticsID where n.nRegionDBID in
(select wRegionID from _RefRegion where ContinentName = 'TQ') and c.Rarity = 0 and ch.ExpToGive > 1 ORDER BY ch.Lvl

Then use this qr to change mob

 Spoiler

USE SRO_VT_SHARD
declare @mobid int = --OLD MOB ID
declare @bid int = -- NEW MOB ID
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, @mobid, @bid) from Tab_RefTactics t
inner join Tab_RefNest n on n.dwTacticsID = t.dwTacticsID
inner join _RefRegion r on n.nRegionDBID = r.wRegionID
WHERE dwObjID LIKE @mobid and r.ContinentName in('CA','AM')

[Rgend]

Originally Posted by sonzenbi

Find SMK and qin-shi MOB with Qr:

 Spoiler

use SRO_VT_SHARD
select distinct c.CodeName128,ch.lvl,c.id from _RefObjCommon c
join _RefObjChar ch on ch.id = c.Link
join Tab_RefTactics t on t.dwObjID = c.ID
join Tab_RefNest n on n.dwTacticsID =
t.dwTacticsID where n.nRegionDBID in
(select wRegionID from _RefRegion where ContinentName = 'CA' or ContinentName = 'AM') and c.Rarity = 0 and ch.ExpToGive !=0 ORDER BY ch.Lvl
select distinct c.CodeName128,ch.lvl,c.id from _RefObjCommon c
join _RefObjChar ch on ch.id = c.Link
join Tab_RefTactics t on t.dwObjID = c.ID
join Tab_RefNest n on n.dwTacticsID =
t.dwTacticsID where n.nRegionDBID in
(select wRegionID from _RefRegion where ContinentName = 'TQ') and c.Rarity = 0 and ch.ExpToGive > 1 ORDER BY ch.Lvl

Then use this qr to change mob

 Spoiler

USE SRO_VT_SHARD
declare @mobid int = --OLD MOB ID
declare @bid int = -- NEW MOB ID
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, @mobid, @bid) from Tab_RefTactics t
inner join Tab_RefNest n on n.dwTacticsID = t.dwTacticsID
inner join _RefRegion r on n.nRegionDBID = r.wRegionID
WHERE dwObjID LIKE @mobid and r.ContinentName in('CA','AM')

sup can give Constantinople and qin-shi MOB with Qr: ??

[sonzenbi]

Originally Posted by Rgend

sup can give Constantinople and qin-shi MOB with Qr: ??

 Spoiler

use SRO_VT_SHARD
select distinct c.CodeName128,ch.lvl,c.id from _RefObjCommon c
join _RefObjChar ch on ch.id = c.Link
join Tab_RefTactics t on t.dwObjID = c.ID
join Tab_RefNest n on n.dwTacticsID =
t.dwTacticsID where n.nRegionDBID in
(select wRegionID from _RefRegion where ContinentName = 'EU') and c.Rarity = 0 and ch.ExpToGive !=0 ORDER BY ch.Lvl