/****** 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 */
/****** 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
@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)
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.
[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
Increase mob count
