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

11/13/2011 19:46 mido2222005#1
PHP Code:
USE [SRO_VT_SHARD]
GO
UPDATE dbo
.Tab_RefNest SET dwmaxtotalcount dwmaxtotalcount/
11/17/2011 13:27 [Snow]#2
are u sure this Right Query?

i think u can't run all areas on 1 machine, 1 machine can't handle all areas.
11/17/2011 16:29 nuocda#3
i think it true, this query is reduce the number of monsters all map :-?

sorry if my english bad
11/17/2011 16:52 Shane¸#4
yea probably it decreases the mobs count. nice one !
11/17/2011 17:42 xBongosx#5
hmm and how can i add it into db ? i gues somewhere in storedprocedures but where exactly and how :p

I need to create new stored procedure with this code?
11/17/2011 17:48 KHAOHS#6
work
11/17/2011 18:44 Shane¸#7
Quote:
Originally Posted by xBongosx View Post
hmm and how can i add it into db ? i gues somewhere in storedprocedures but where exactly and how :p

I need to create new stored procedure with this code?
:facepalm:
New Query button
:facepalm:
11/17/2011 19:10 rushcrush#8
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
11/17/2011 23:39 mido2222005#9
PHP Code:
USE [SRO_VT_SHARD]
GO
UPDATE dbo
.Tab_RefNest SET dwmaxtotalcount dwmaxtotalcount*
to back it to normal

use your mind
11/18/2011 04:29 Murgen#10
Well, I did
Code:
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/1.25
To have more mobs, cause you can have 50K mobs before despawn bug.
11/18/2011 11:22 Reality_xXx#11
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..
11/18/2011 17:49 qoaway#12
Quote:
Originally Posted by Reality_xXx View Post
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.
11/19/2011 15:30 ins0ma#13
@qoaway

Are you just showing off?
11/20/2011 18:50 Murgen#14
- 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.
11/21/2011 17:13 xBongosx#15
it working for swsro?