Increase mob count

09/16/2015 11:33 gofik123#1
Does anyone know how to increase the mob count with a second game server?
09/16/2015 19:40 Vxo#2
You can use this one.

PHP Code:
 /****** Object:  Query [Increase Mob Spawn(one by one)] Owner : AETA GAMING NETWORK   */
  Update [SRO_VT_SHARD].[dbo].[Tab_RefNest]
  Set dwMaxTotalCount = 3
Where dwTacticsID IN (Select dwTacticsID FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics] 
 Where dwObjID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefObjCommon Where CodeName128 LIKE 'MOB_SD_CAMELSPIDER') )
 /****** Object:  Query [Increase Mob Spawn(one by one)] Owner : AETA GAMING NETWORK   */ 
09/16/2015 23:46 gofik123#3
Do you know how to make it pass 50000 mobs? with 130 cap mobs are dry.
09/17/2015 14:25 Aaron*#4
Quote:
Originally Posted by Vxo View Post
You can use this one.

PHP Code:
 /****** Object:  Query [Increase Mob Spawn(one by one)] Owner : AETA GAMING NETWORK   */
  Update [SRO_VT_SHARD].[dbo].[Tab_RefNest]
  Set dwMaxTotalCount = 3
Where dwTacticsID IN (Select dwTacticsID FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics] 
 Where dwObjID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefObjCommon Where CodeName128 LIKE 'MOB_SD_CAMELSPIDER') )
 /****** Object:  Query [Increase Mob Spawn(one by one)] Owner : AETA GAMING NETWORK   */ 

:facepalm: :facepalm: :facepalm:


@OP
If you have second gameserver, then change certain regions assocserver to 2 (from _Refregionbindassocserver) and restart your gs/sm.
If you want to increase the mobs count in those regions, then use the query below.
Quote:
UPDATE TRN SET DWMAXTOTALCOUNT+=3 /*You can change 3 to any value you want.*/ FROM TAB_REFNEST TRN JOIN _RefRegion RR
on RR.wRegionID = TRN.nregiondbid --nregiondbid might be a wrong column name, edit it.
JOIN _RefRegionBindAssocServer rbs
ON RBS.AreaName = RR.ContinentName
WHERE RBS.AssocServer = 2
09/17/2015 21:32 Vxo#5
Quote:
Originally Posted by Leonius* View Post
:facepalm: :facepalm: :facepalm:


@OP
If you have second gameserver, then change certain regions assocserver to 2 (from _Refregionbindassocserver) and restart your gs/sm.
If you want to increase the mobs count in those regions, then use the query below.
Its my fault. I tough he asked how to increase mob spawn on server(via 1gameserver)
09/18/2015 14:14 gofik123#6
Hahaha i haven't even set up the second gameserver sorry i should have been more specific. I am actually trying to setup the 2nd gameserver i've covered the great google and no ones actually made a guide. I just want to play with a couple of friends i'm looking to start an actual private server i got the computer to run the second gameserver just need the knowledge.