|
You last visited: Today at 16:36
Advertisement
Increase mob count
Discussion on Increase mob count within the SRO Private Server forum part of the Silkroad Online category.
09/16/2015, 11:33
|
#1
|
elite*gold: 0 
Join Date: Nov 2007
Posts: 248
Received Thanks: 16
|
Increase mob count
Does anyone know how to increase the mob count with a second game server?
|
|
|
|
09/16/2015, 19:40
|
#2
|
elite*gold: 37
Join Date: May 2015
Posts: 339
Received Thanks: 305
|
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
|
#3
|
elite*gold: 0
Join Date: Nov 2007
Posts: 248
Received Thanks: 16
|
Do you know how to make it pass 50000 mobs? with 130 cap mobs are dry.
|
|
|
|
|
09/17/2015, 14:25
|
#4
|
elite*gold: 77
Join Date: Jan 2015
Posts: 1,314
Received Thanks: 856
|
Quote:
Originally Posted by Vxo
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 */
|
@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
|
#5
|
elite*gold: 37
Join Date: May 2015
Posts: 339
Received Thanks: 305
|
Quote:
Originally Posted by Leonius*
@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
|
#6
|
elite*gold: 0
Join Date: Nov 2007
Posts: 248
Received Thanks: 16
|
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.
|
|
|
|
 |
Similar Threads
|
[Navi Cat ER 1136] Column count doesn't match value count at row 1
04/16/2015 - Metin2 Private Server - 0 Replies
hey
Weiß jemand wie ich das Problem löse, google hilft mir nicht wirklich :/
Finde den Fehler nicht... bzw die fehlende Spalte what ever
würde mich sehr freuen wenn mir jemand helfen kann.
|
[Err] 1136 - Column count doesn't match value count at row 1 [Waffen einfügen]
10/11/2014 - Metin2 Private Server - 6 Replies
Hallo hab da ein komischer Fehler
1136 - Column count doesn't match value count at row 1
INSERT INTO `item_proto` VALUES ('164500', 'Testschwert+0', 'Testschwert+0', '1', '3', '0', '3', '56', '1', '16', '', '1', '1', '164501', '0', '0', '15', '1', '65', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('164501', 'Testschwert+1', 'Testschwert+1', '1', '3', '0', '3', '56', '1', '16',...
|
Navicat [Err1136] - Column count doesn't match value count at row 1
02/21/2012 - Metin2 Private Server - 2 Replies
Hallöchen Liebe Com,
Als ich gerade in der Querry Table auf meinem Server die 80er Rüstungen erneut einfügen wollte, stoß ich auf diesen Fehler:
INSERT INTO `item_proto` VALUES ('12039', 'Auraplattenpanzer+9', 'Auraplattenpanzer +9', '2','0','0','2','300','1','1','0','3000','10000',' 1','90','0','0','8','4294967290','37','20','10','4 0','0','154','0','26','0','45','0','64944','127',' 65008','21631','4855','0','0','15','100','3');
1136 - Column count doesn't match value count at row 1
|
Navicat - [Err] 1136 - Column count doesn't match value count at row 1
01/14/2012 - Metin2 Private Server - 1 Replies
Hallo x(
Ich weis nicht ob ich zu doof bin ein loch in den Schnee zu pissen oder ob wirklich was falsch hier ist..
Aufjedenfall muss ich die Querry für die 12 neuen metin steine in Serverside einfügen aber jedesmal bekomme ich die meldung:
INSERT INTO mob_proto VALUES(8028, 'Metin der Hoffnung', 'Metin der Hoffnung', 5, 2, 3, 95, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0,...
|
Daroo Files Lehrer [Err] 1136 - Column count doesn't match value count at row 1
12/08/2011 - Metin2 Private Server - 3 Replies
Hallo ,
Wollte bei den Daroo Files die LKehrer bestücken.
Manche habe ich schon doch ich habe ehrlich keine
Lust mehr bekommen. Und habe gehofft das es hier welche
Released haben. Ich habe auch 2 Themen dazu gefunden mit
den Release.
Doch wenn ich sie einfügen will kommt dieser Fehler
1136 - Column count doesn't match value count at row 1
|
All times are GMT +2. The time now is 16:36.
|
|
