[Request] Query to change mobs spawn by area.

[Dracula Untold]

as tittle said ..
not by ID ! by area if is posible .. someone could make me a query ? thanks

[Midnight ™]

I don't exactly know what you mean by Region, so i just took the RegionID for you.

here you are:

 Spoiler

USE SRO_VT_SHARD /* Decrease Monster Respawn Time By Midnight */

DECLARE @Rate smallint = 2 -- Rate to increase the respawn Time | 2 = 2x, 3 = 3x and so on
DECLARE @Region smallint = 28901 -- RegionID

UPDATE Tab_RefNest
SET dwDelayTimeMin = dwDelayTimeMin/@Rate, dwDelayTimeMax = dwDelayTimeMax/@Rate
WHERE nRegionDBID = @Region