[Fix] Small query for 1 game server with all regions

[FuriousRage]

Works perfect, all uniques etc spawn :) thank you:) except holywater i guess

[mpcvtvca]

I ran this query in my DB and now my Gameserver is presenting this error. "local overlap job exception!! CServerProcessOverlap".

anyone help me?

[kekes]

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2 WHERE dwmaxtotalcount > 2

easy. no need to fix uniques lol^

[VzlaR]

I ran this query in my DB and now my Gameserver is presenting this error. "local overlap job exception!! CServerProcessOverlap".

anyone help me?

maybe you change something in your db, or change you gameserver to another. yesterday i fix this error when i change the gameserver for the gameserver of statiic that fix lvl 120

[Poka]

Thx <3

[eshak]

did it work with jupter ?

[asi]

Thank you

[eshak]

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2 

Update
Fix unique spawn ( Tiger girl - Uruchi - Isy - Lord Yarkan )

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1  where dwdelaytimemax = '21600' ; 

use this query after old query to fix unique spawn

Fix Qin-Shi Tomb uniques by sladlejrhfpq

USE SRO_VT_SHARD_INIT
--B1
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32100 --B1 Unique
--B2
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32200 --Camp 8 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32300 --Camp 11 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32400 --Camp 11 Unique
--B3
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32500
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32600
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32700
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32800 

Update by sladlejrhfpq


Original table in attachments

did thes work with jupter ?

[P L A S M A]

it ruin my DB :(

[eshak]

dod this shitt work with jupter itry it i found no mobs in JUpter? eny help