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

[mido2222005]

PHP Code:

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


[[Snow]]

are u sure this Right Query?

i think u can't run all areas on 1 machine, 1 machine can't handle all areas.

[nuocda]

i think it true, this query is reduce the number of monsters all map :-?

sorry if my english bad

[Shane¸]

yea probably it decreases the mobs count. nice one !

[xBongosx]

hmm and how can i add it into db ? i gues somewhere in storedprocedures but where exactly and how

I need to create new stored procedure with this code?

[KHAOHS]

work

[Shane¸]

Originally Posted by xBongosx

hmm and how can i add it into db ? i gues somewhere in storedprocedures but where exactly and how

I need to create new stored procedure with this code?

New Query button

[rushcrush]

so this will make us open all areas in 1 machine?

edit:now mobs became 24278 spawn lol
seems working good
but this will make the mobs really rare in any area xD

And to back it to normal? what Query i have to write!
thx

[mido2222005]

PHP Code:

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


to back it to normal

use your mind

[Murgen]

Well, I did

UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/1.25

To have more mobs, cause you can have 50K mobs before despawn bug.

[Reality_xXx]

Well this query is good for 110cap servers...
Servers with 120 regions can't use it... well they can actually but it wont effect so much..

[qoaway]

Originally Posted by Reality_xXx

Well this query is good for 110cap servers...
Servers with 120 regions can't use it... well they can actually but it wont effect so much..

im running violent online on one gameserver, like this query but more complex and little patch to gameserver.

[ins0ma]

@qoaway

Are you just showing off?

[Murgen]

- This will no longer spawn Envy in Forgotten World.
- This will no longer spawn uniques in the Pharaoh temple.
- Apis will also not spawn, as well as neith and others.

[xBongosx]

it working for swsro?