Quote:
Originally Posted by only16859
After long-term testing, Taiwan 1.258
The following issues need to be fixed
1. The map is fully open. The number of mobs refreshed is very high. At the same time, mobs appeared, which also caused the pets to be used abnormally. Need to delete the refresh quantity of mobs.
2. "Samarkand", "Prince Map" and "Alexander" three maps. Characters close to the portal will cause the client to crash.
|
The problem must be in Tab_RefNest
use this query
Code:
SELECT SUM(dwMaxTotalCount)
FROM Tab_RefNest
if the result is higher than 50k objects means the problem comes from Nest
to fix it use this simple query
Code:
UPDATE Tab_RefNest
SET dwMaxTotalCount = 1
WHERE dwMaxTotalCount >1
if it's just for testing purpose
or use syloxx query which is avoiding uniques , instance uniques and mobs
Code:
DECLARE @RARE FLOAT = 0.75 /*_#2 = 200%, 1 = 100%, 0.5 = 50%*/
UPDATE TRN
SET TRN.dwMaxTotalCount *= @RARE
FROM Tab_RefNest TRN
JOIN Tab_RefTactics TRT ON TRN.dwTacticsID = TRT.dwTacticsID
JOIN _RefObjCommon ROC ON TRT.dwObjID = ROC.ID
WHERE ROC.CodeName128 LIKE 'MOB%'
AND ROC.Rarity = 0
AND dwDelayTimeMin < 600
AND dwDelayTimeMin != 0
AND dwMaxTotalCount != 1