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

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

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

anyone help me?

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

easy. no need to fix uniques lol^

Quote:

---

Originally Posted by mpcvtvca

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

Thx <3

did it work with jupter ?

Thank you

Quote:

---

Originally Posted by mido1112005

PHP Code:

---

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


---

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

PHP Code:

---

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

PHP Code:

---

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 ?

it ruin my DB :(

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