Csro-R Solution to Open All Zone in 1 PC

[elcheka1997]

Hello Ragezone, Today i have a solution to open all zone in Csro-R Files in 1 PC.

Execute this Comand in Sql Server.

USE [SR_R_Shard1]
Go
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount /2

After Execute IT.

USE [SR_R_Shard1]
Go
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount * 1.7

This is IT jejejeje

 

[NourAyman]

Congratz, you saved the world lol

 

[skerdikas]

actually it was workin with one gameserver anyway xD

 

[samuelsom]

Fix simple query

USE [SR_R_Shard1]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '8' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '10' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '12' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '15' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '16' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '20' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '22' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '25' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '30' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '35' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '40' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '45' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '50' ;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 3 where dwdelaytimemax = '160' ;

 

[Metalikana]

is there any way to fix

[SR_GameServer]	CGameWorld::SpawnNPCAt - Error Spawn NPC

without reducing the entire mobs spawn?
i mean just fixing the bugged line/s while keep the others as they should be ?

 

[blapanda]

is there any way to fix

[SR_GameServer]    CGameWorld::SpawnNPCAt - Error Spawn NPC

without reducing the entire mobs spawn?
i mean just fixing the bugged line/s while keep the others as they should be ?

That is the bug, having too much NPCs (mobs and regular NPCs) being loaded into the gameserver.
The only solution without reducing the amount is sharing the amount on multiple gameservers.
Regions have to be declared as 1 and 2 instead of only 1 (_RefRegionBindAsso poop).
This will split the amount, tho it will also increase your RAM usage significantly. So by reducing 25% of the mob base and allocating 1~2GB instead of 4~5GB ... you can figure out the answer by yourself.

 

[Metalikana]

well well well (3 well ? guess that bug drives me crazy)
alright yes i already found that you are right and that bug returns to the max NetEngine count in SR_GameServer
we can fix that bug if we'd find the address and expand that number so it can handle more than 100k without calling that error
well i can't find that address by myself
but the other solution that may work (or not) is to find the exact number that call that error then search among the cmp values in olly and if we don't know the correct value we can compare it with the other files like vsro (yes i tried open all towns with original maxtotalcount on vsro and that NetEngine exceeded over than 110k and didn't call that error)
but me alone is impossible since it's hard to look at the monitor while waiting for the exact value on NetEngine until the error comes up xD

 

[IBANEZ320]

Hello Ragezone, Today i have a solution to open all zone in Csro-R Files in 1 PC.

Execute this Comand in Sql Server.

USE [SR_R_Shard1]
Go
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount /2

After Execute IT.

USE [SR_R_Shard1]
Go
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount * 1.7

This is IT jejejeje

1 /2= ????
ADD
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2 where dwmaxtotalcount > 1