change Mobs Spawn

04/09/2020 14:56 kimo888#1

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

04/09/2020 20:58 sonzenbi#2

Find SMK and qin-shi MOB with Qr:

Then use this qr to change mob

04/10/2020 23:52 Rgend#3

Quote:

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 @[Only registered and activated users can see links. Click Here To Register...]mobid int = --OLD MOB ID
declare @[Only registered and activated users can see links. Click Here To Register...]bid int = -- NEW MOB ID
UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, @[Only registered and activated users can see links. Click Here To Register...]mobid, @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]mobid and r.ContinentName in('CA','AM')

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

04/11/2020 07:52 sonzenbi#4

Quote:

Originally Posted by Rgend

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

Spoiler