Mob rate

07/20/2017 13:05 gofik123#1
So i used a query from here [Only registered and activated users can see links. Click Here To Register...] and now places like jupiter, donwhang caves (Left side) and many more have dead spawns its like 1-2 mobs for the entire area.. every time i increase the ones with bigger mobs get more and the ones with little mobs get more which overloads server. Any chance of fixing it? i have a backup but that backup i didn't notice jupiter had like barely any mobs at the time... unless i copy refnest table from another database? i really need help on this :(


I used this query from here [Only registered and activated users can see links. Click Here To Register...]
Code:
USE SRO_VT_SHARD
UPDATE Tab_RefNest SET dwmaxtotalcount=3
WHERE dwTacticsID NOT BETWEEN 41000 AND 43860 
AND dwTacticsID NOT BETWEEN 32100 AND 32800
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1  
WHERE dwdelaytimemax=21600;  ;
Changed it to that. Tried it and it looks much better than before. What that does it changed the dwmaxtotalcount column to 3 within those values.

Ok so moles, some other mobs are still too low or too many i give up.
07/20/2017 22:56 ZαKuRα#2
Add me and skype to help you
07/21/2017 10:43 gofik123#3
I've almost done it manually :\ just gotta do jupiter and i'm done

Its much much better but still donwhang caves a bit one sided ah well what can you do.
12/05/2017 12:01 panadol2012#4
When I put it in my DB get Crash