How to set server vehicle spawn limit?

[sk8ters24 0]

I just purchased a HFBserver and I set the vehicle file to 1000 vehicles, but it is telling me I also have to change the limit in my database and I have no idea where to find that, I have looked everywhere and I cannot find where I go to change the limit. Here is a screen of what the database looks like, if someone can point out where I go and what to do, please do so, thanks!

[Allie (DayZ) 97]

This is not the correct location you are looking in, this is the default SQL stuff.

You should look for the procedure "PMain" it should look some like this :

BEGIN

DECLARE iSpawnNumVeh SMALLINT(3) DEFAULT 11; <<<<<<<< change default to 100 if you want 100 spawns

CALL pCleanup();

CALL pFixMaxNum;

SELECT SUM(MaxNum) FROM object_classes INTO @iMaxNumTotal;

IF (iSpawnNumVeh > @iMaxNumTotal) THEN

SET iSpawnNumVeh = @iMaxNumTotal;

END IF;

WHILE (fGetVehCount() < iSpawnNumVeh) DO

CALL pSpawn();

END WHILE;

END//

But this is not all !!!!

If you want 100 vehicles to spawn, all these vehicles need to be in the database too, this is done in the "object_spawn" TABLE,

every spawnpoint needs to be in there.

Sample of "object_spawn" Table SQL :

-- Dumping structure for table default.object_spawns

CREATE TABLE IF NOT EXISTS `object_spawns` (

`ObjectUID` bigint(20) NOT NULL DEFAULT '0',

`Classname` varchar(32) DEFAULT NULL,

`Worldspace` varchar(64) DEFAULT NULL,

`Inventory` longtext,

`Hitpoints` varchar(999) NOT NULL DEFAULT '[]',

`MapID` varchar(255) NOT NULL DEFAULT '',

`Last_changed` int(10) DEFAULT NULL,

PRIMARY KEY (`ObjectUID`,`MapID`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Dumping data for table default.object_spawns: 112 rows

/*!40000 ALTER TABLE `object_spawns` DISABLE KEYS */;

INSERT INTO `object_spawns` (`ObjectUID`, `Classname`, `Worldspace`, `Inventory`, `Hitpoints`, `MapID`, `Last_changed`) VALUES

(348, 'LandRover_CZ_EP1', '[64,[9653.4443,13555.063,0]]', '[]', '[]', '110', NULL),

(718, 'Tractor', '[-3,[11934.478,9518.6309,0]]', '[]', '[]', '106', NULL),

(719, 'Tractor', '[-3,[12288.495,11094.473,0]]', '[]', '[]', '107', NULL),

(347, 'hilux1_civil_3_open_EP1', '[-1,[12276.199,10586.779,0]]', '[]', '[]', '108', NULL),

(720, 'Tractor', '[0,[6158.7725,9005.5732,0]]', '[]', '[]', '109', NULL),

(717, 'Tractor', '[-3,[12118.503,9445.8721,0]]', '[]', '[]', '105', NULL),

(716, 'Tractor', '[-3,[12090.864,9453.6055,0]]', '[]', '[]', '104', NULL),

(811, 'UH1H_DZ', '[27,[9686.75,3604.3081,0]]', '[]', '[]', '0', NULL),

(311, 'Volha_2_TK_CIV_EP1', '[124,[9676.3398,8880.75,0]]', '[[[],[]],[[],[]],[[],[]]]', '[["motor",0.8],["karoserie",1],["palivo",0.8],["wheel_1_1_steering",1],["wheel_2_1_steering",1],["wheel_1_2_steering",1],["wheel_2_2_steering",1]]', '1', NULL),

(111, 'ATV_US_EP1', '[84,[8837.4805,2844.75,0]]', '[[[],[]],[["ItemTent","ItemHeatPack","FoodCanBakedBeans"],[1,1,1]],[[],[]]]', '[["motor",0.8],["wheel_1_2_steering",1],["wheel_2_1_steering",0.0156045],["wheel_1_3_steering",0.0401988],["wheel_2_3_steering",1]]', '2', NULL),

(112, 'ATV_US_EP1', '[294,[8830.5,2863.95,0]]', '[[[],[]],[["FoodCanFrankBeans","ItemPainkiller","ItemHeatPack"],[1,1,1]],[[],[]]]', '[["motor",1],["palivo",0.368047],["wheel_1_1_steering",0.331809],["wheel_1_2_steering",1],["wheel_2_1_steering",0.0473658],["wheel_2_2_steering",0.332376],["karoserie",0.355141],["wheel_1_3_steering",0.0401988],["wheel_2_3_steering",1]]', '3', NULL),

(611, 'TT650_TK_CIV_EP1', '[13,[8783.2061,11723.631,0]]', '[]', '[]', '4', NULL),

(612, 'TT650_TK_CIV_EP1', '[-17,[8636.0049,6856.8818,0]]', '[]', '[]', '5', NULL),

(511, 'Old_bike_TK_CIV_EP1', '[160,[8346.9404,2458.27,0]]', '[]', '[]', '6', NULL),

(512, 'Old_bike_TK_CIV_EP1', '[197,[8342.5996,2460.51,0]]', '[]', '[]', '7', NULL),

(211, 'Fishing_Boat', '[253,[8299.9502,2358.95,0]]', '[[[],[]],[[],[]],[[],[]]]', '[]', '8', NULL),

(312, 'UAZ_Unarmed_TK_EP1', '[160,[8115.6299,9295.5,0]]', '[[[],[]],[["HandGrenade_East","SmokeShell","SmokeShellRed","SmokeShellYellow","SmokeShellGreen","ItemWaterbottle","30Rnd_545x39_AK","10Rnd_762x54_SVD","ItemTent"],[10,1,1,1,1,1,20,10,1]],[[],[]]]', '[["glass1",1],["glass2",1],["glass3",1],["motor",0.8],["palivo",0.8],["wheel_1_1_steering",1],["wheel_1_2_steering",1],["wheel_2_1_steering",1],["wheel_2_2_steering",1],["sklo predni P",1],["sklo predni L",1],["karoserie",1],["wheel_1_4_steering",1],["wheel_2_4_steering",1],["wheel_1_3_steering",1],["wheel_2_3_steering",1],["glass4",1]]', '9', NULL),

(513, 'Old_bike_TK_CIV_EP1', '[285,[8091.2998,3350.3101,0]]', '[]', '[]', '10', NULL),

(313, 'Volha_2_TK_CIV_EP1', '[185,[8039.1299,2916.3899,0]]', '[[[],[]],[[],[]],[[],[]]]', '[["motor",0.8],["karoserie",1],["palivo",0.8],["wheel_1_1_steering",1],["wheel_2_1_steering",1],["wheel_1_2_steering",1],["wheel_2_2_steering",1]]', '11', NULL),

(514, 'Old_bike_TK_CIV_EP1', '[4,[8027.8701,7076.1699,0]]', '[]', '[]', '12', NULL),

(314, 'Skoda', '[49,[8001.5898,3342.51,0]]', '[[[],[]],[[],[]],[[],[]]]', '[]', '13', NULL),

(515, 'Old_bike_TK_CIV_EP1', '[130,[7919.9063,7231.3369,0]]', '[]', '[]', '14', NULL),

(315, 'datsun1_civil_3_open', '[215,[7807.3442,3539.9856,0]]', '[]', '[]', '15', NULL),

(812, 'UH1H_DZ', '[-23,[7154.9399,8157.1401,0]]', '[]', '[]', '16', NULL),

(316, 'UAZ_Unarmed_TK_EP1', '[340,[6850.1362,2480.0134,0]]', '[]', '[]', '17', NULL),

(411, 'Ikarus', '[202,[6575.8828,2868.105,0]]', '[]', '[]', '18', NULL),

(613, 'TT650_TK_CIV_EP1', '[46,[6404.5347,3209.2341,0]]', '[]', '[]', '19', NULL),

(813, 'UH1H_DZ', '[34,[6360.2271,2767.6943,0]]', '[]', '[]', '20', NULL),

(317, 'UAZ_Unarmed_TK_EP1', '[231,[6319.1499,7733.6499,0]]', '[]', '[]', '21', NULL),

(516, 'Old_bike_TK_CIV_EP1', '[70,[6294.96,7833.77,0]]', '[]', '[]', '22', NULL),

(318, 'SkodaGreen', '[99,[6293.1201,7827.1201,0]]', '[]', '[]', '23', NULL),

(412, 'Ikarus', '[102,[6237.4902,7705.6602,0]]', '[]', '[]', '24', NULL),

(319, 'Volha_2_TK_CIV_EP1', '[222,[5136.8501,2362.4299,0]]', '[]', '[]', '25', NULL),

(320, 'datsun1_civil_3_open', '[246,[4952.6401,5616.5098,0]]', '[]', '[]', '26', NULL),

(814, 'AH6X_DZ', '[2,[12010.7,12637.2,0]]', '[]', '[]', '27', NULL),

(321, 'UAZ_Unarmed_TK_EP1', '[226,[4790.1299,2571.3501,0]]', '[]', '[]', '28', NULL),

(413, 'Ikarus', '[304,[4564.6948,4506.1382,0]]', '[]', '[]', '29', NULL),

(815, 'Mi17_DZ', '[156,[7660.271,3982.0063,0]]', '[]', '[]', '30', NULL),

(911, 'AN2_DZ', '[252,[4530.52,10785.1,0]]', '[]', '[]', '31', NULL),

(816, 'UH1H_DZ', '[268,[4238.04,10781.7,0]]', '[]', '[]', '32', NULL),

(113, 'ATV_US_EP1', '[313,[4087.0901,11669.4,0]]', '[[[],[]],[[],[]],[[],[]]]', '[["motor",0.8],["palivo",0.8],["wheel_1_1_steering",1],["wheel_1_2_steering",1],["wheel_2_1_steering",0.0156045],["wheel_1_3_steering",0.0401988],["wheel_2_3_steering",1]]', '33', NULL),

(114, 'ATV_US_EP1', '[121,[4059.3201,11658.4,0]]', '[[[],[]],[["FoodCanFrankBeans","ItemPainkiller","ItemHeatPack"],[1,1,1]],[[],[]]]', '[["motor",0.8],["wheel_1_2_steering",1],["wheel_2_1_steering",0.0156045],["wheel_1_3_steering",0.0401988],["wheel_2_3_steering",1]]', '34', NULL),

(711, 'tractor', '[-32,[3790.79,8961.0898,0]]', '[]', '[]', '35', NULL),

(115, 'ATV_US_EP1', '[274,[3748.5901,5990.8701,0]]', '[[[],[]],[["ItemTent","ItemHeatPack","FoodCanBakedBeans"],[1,1,1]],[[],[]]]', '[["motor",0.8],["wheel_1_2_steering",0.1],["wheel_2_1_steering",1],["wheel_1_3_steering",0.0401988],["wheel_2_3_steering",0.5]]', '36', NULL),

(414, 'Ikarus', '[180,[3728.0701,8669.0098,0]]', '[]', '[]', '37', NULL),

(322, 'BAF_Offroad_D', '[162,[3702.04,6044.3101,0]]', '[]', '[["glass1",1],["glass2",1],["glass3",1],["motor",0.8],["palivo",0.8],["wheel_1_1_steering",1],["wheel_1_2_steering",1],["wheel_2_1_steering",1],["wheel_2_2_steering",1],["sklo predni P",1],["sklo predni L",1],["karoserie",1],["wheel_1_4_steering",1],["wheel_2_4_steering",1],["wheel_1_3_steering",1],["wheel_2_3_steering",1],["glass4",1]]', '38', NULL),

(517, 'Old_bike_TK_CIV_EP1', '[51,[3572.6201,2545.29,0]]', '[]', '[]', '39', NULL),

(323, 'BAF_Offroad_W', '[71,[3708.5,5999.4199,0]]', '[[[],[]],[["HandGrenade_West","SmokeShell","SmokeShellRed","SmokeShellYellow","SmokeShellGreen","ItemWaterbottle","30Rnd_556x45_Stanag","20Rnd_762x51_DMR","ItemTent"],[10,1,1,1,1,1,20,10,1]],[[],[]]]', '[["glass1",1],["glass2",1],["glass3",1],["motor",0.8],["palivo",0.8],["wheel_1_1_steering",1],["wheel_1_2_steering",1],["wheel_2_1_steering",1],["wheel_2_2_steering",1],["sklo predni P",1],["sklo predni L",1],["karoserie",1],["wheel_1_4_steering",1],["wheel_2_4_steering",1],["wheel_1_3_steering",1],["wheel_2_3_steering",1],["glass4",1]]', '40', NULL),

(518, 'Old_bike_TK_CIV_EP1', '[202,[2947.2,2036.92,0]]', '[]', '[]', '41', NULL),

(519, 'Old_bike_TK_CIV_EP1', '[-3,[2882.28,5270.4902,0]]', '[]', '[]', '42', NULL),

(520, 'Old_bike_TK_CIV_EP1', '[-149,[2792.48,3114.03,0]]', '[]', '[]', '43', NULL),

(415, 'Ikarus', '[309,[2768.26,6000.1602,0]]', '[]', '[]', '44', NULL),

(324, 'Volha_2_TK_CIV_EP1', '[82,[2578.5901,5084.1099,0]]', '[]', '[]', '45', NULL),

(325, 'BAF_Offroad_D', '[141,[11953.279,9107.3896,0]]', '[]', '[["glass1",1],["glass2",1],["glass3",1],["motor",0.8],["palivo",0.8],["wheel_1_1_steering",1],["wheel_1_2_steering",1],["wheel_2_1_steering",1],["wheel_2_2_steering",1],["sklo predni P",1],["sklo predni L",1],["karoserie",1],["wheel_1_4_steering",1],["wheel_2_4_steering",1],["wheel_1_3_steering",1],["wheel_2_3_steering",1],["glass4",1]]', '46', NULL),

(326, 'car_hatchback', '[287,[1967.1801,9147.2197,0]]', '[]', '[]', '47', NULL),

(416, 'UralCivil2', '[233,[1915.7,12442.2,0]]', '[]', '[]', '48', NULL),

(417, 'S1203_TK_CIV_EP1', '[183,[13367.5,6601.1099,0]]', '[]', '[]', '49', NULL),

(327, 'UAZ_Unarmed_TK_EP1', '[89,[13127.792,11561.818,0]]', '[]', '[]', '50', NULL),

(418, 'V3S_Civ', '[330,[13088.4,7108.5698,0]]', '[]', '[]', '51', NULL),

(328, 'SkodaBlue', '[186,[12903.9,4431.3799,0]]', '[]', '[]', '52', NULL),

(419, 'S1203_TK_CIV_EP1', '[-38,[12167.4,9748.5498,0]]', '[]', '[]', '53', NULL),

(420, 'S1203_TK_CIV_EP1', '[376,[12130.7,3516.8899,0]]', '[]', '[]', '54', NULL),

(817, 'UH1H_DZ', '[7,[12057.56,12626.336,0]]', '[]', '[]', '55', NULL),

(614, 'TT650_TK_CIV_EP1', '[272,[11945.3,9130.3398,0]]', '[]', '[]', '56', NULL),

(116, 'ATV_US_EP1', '[-37,[11483.7,11382.7,0]]', '[[[],[]],[["FoodCanFrankBeans","ItemPainkiller","ItemHeatPack"],[1,1,1]],[[],[]]]', '[["motor",0.8],["palivo",0.8],["wheel_1_1_steering",1],["wheel_1_2_steering",1],["wheel_2_1_steering",0.0156045],["wheel_1_3_steering",0.0401988],["wheel_2_3_steering",1]]', '57', NULL),

(421, 'S1203_TK_CIV_EP1', '[245,[11463.3,7545.9302,0]]', '[]', '[]', '58', NULL),

(117, 'ATV_US_EP1', '[42,[11461.1,11380.5,0]]', '[[[],[]],[[],[]],[[],[]]]', '[["motor",0.8],["wheel_1_2_steering",0.1],["wheel_2_1_steering",1],["wheel_1_3_steering",0.0401988],["wheel_2_3_steering",0.5]]', '59', NULL),

(712, 'tractor', '[191,[11424.036,7355.7295,0]]', '[]', '[]', '60', NULL),

(329, 'datsun1_civil_3_open', '[210,[11351.6,6633.52,0]]', '[]', '[]', '61', NULL),

(818, 'UH1H_DZ', '[160,[11216.4,4234.8101,0]]', '[]', '[]', '62', NULL),

(330, 'BAF_Offroad_W', '[322,[7201.5181,3034.3232,0]]', '[]', '[["glass1",1],["glass2",1],["glass3",1],["motor",0.8],["palivo",0.8],["wheel_1_1_steering",1],["wheel_1_2_steering",1],["wheel_2_1_steering",1],["wheel_2_2_steering",1],["sklo predni P",1],["sklo predni L",1],["karoserie",1],["wheel_1_4_steering",1],["wheel_2_4_steering",1],["wheel_1_3_steering",1],["wheel_2_3_steering",1],["glass4",1]]', '63', NULL),

(331, 'Volha_2_TK_CIV_EP1', '[189,[10812.7,2686.29,0]]', '[]', '[]', '64', NULL),

(422, 'Ikarus', '[241,[10641.2,8073.2202,0]]', '[]', '[]', '65', NULL),

(332, 'Volha_2_TK_CIV_EP1', '[306,[10454.8,8872.0996,0]]', '[]', '[]', '66', NULL),

(423, 'Ikarus', '[62,[10320.025,2157.7627,0]]', '[]', '[]', '67', NULL),

(819, 'AH6X_DZ', '[113,[6880.2007,11454.291,0]]', '[]', '[]', '68', NULL),

(820, 'Mi17_DZ', '[-188,[7220.6538,9116.3428,0]]', '[]', '[]', '69', NULL),

(333, 'SUV_TK_EP1', '[-93,[9157.7549,11019.93,0]]', '[]', '[]', '70', NULL),

(334, 'car_sedan', '[-68,[7438.0454,5180.8857,0]]', '[]', '[]', '71', NULL),

(615, 'M1030', '[-71,[8330.4639,5971.6885,0]]', '[]', '[]', '72', NULL),

(335, 'Lada1_TK_CIV_EP1', '[-120,[8440.3926,5975.1753,0]]', '[]', '[]', '73', NULL),

(521, 'Old_bike_TK_INS_EP1', '[-138,[8511.4111,6044.689,0]]', '[]', '[]', '74', NULL),

(336, 'datsun1_civil_1_open', '[-134,[6448.6953,6543.1836,0]]', '[]', '[]', '75', NULL),

(337, 'VolhaLimo_TK_CIV_EP1', '[-14,[6208.9775,10403.117,0]]', '[]', '[]', '76', NULL),

(338, 'Lada1_TK_CIV_EP1', '[105,[6027.7988,10459.635,0]]', '[]', '[]', '77', NULL),

(522, 'Old_bike_TK_CIV_EP1', '[-63,[5986.3462,10373.445,0]]', '[]', '[]', '78', NULL),

(339, 'datsun1_civil_1_open', '[7,[5969.1924,10313.057,0]]', '[]', '[]', '79', NULL),

(118, 'ATV_US_EP1', '[-32,[5984.6064,10161.703,0]]', '[[[],[]],[["FoodCanFrankBeans","ItemPainkiller","ItemHeatPack"],[1,1,1]],[[],[]]]', '[["motor",0.8],["wheel_1_2_steering",0.1],["wheel_2_1_steering",1],["wheel_1_3_steering",0.0401988],["wheel_2_3_steering",0.5]]', '80', NULL),

(340, 'SkodaBlue', '[-163,[9691.2695,6551.8672,0]]', '[]', '[]', '81', NULL),

(821, 'Mi17_DZ', '[4,[13584.044,3199.9648,0]]', '[]', '[]', '82', NULL),

(912, 'AN2_DZ', '[134,[5172.3457,2172.7046,0]]', '[]', '[]', '83', NULL),

(913, 'AN2_DZ', '[108,[5260.3203,2261.9851,0]]', '[]', '[]', '84', NULL),

(914, 'AN2_DZ', '[-212,[5156.3555,2651.9055,0]]', '[]', '[]', '85', NULL),

(915, 'AN2_DZ', '[-125,[4809.2461,2539.2903,0]]', '[]', '[]', '86', NULL),

(341, 'BAF_Offroad_W', '[-95,[4713.7666,2616.6179,0]]', '[]', '[["glass1",1],["glass2",1],["glass3",1],["motor",0.8],["palivo",0.8],["wheel_1_1_steering",1],["wheel_1_2_steering",1],["wheel_2_1_steering",1],["wheel_2_2_steering",1],["sklo predni P",1],["sklo predni L",1],["karoserie",1],["wheel_1_4_steering",1],["wheel_2_4_steering",1],["wheel_1_3_steering",1],["wheel_2_3_steering",1],["glass4",1]]', '87', NULL),

(616, 'M1030', '[37,[4360.8408,2482.9688,0]]', '[]', '[]', '88', NULL),

(342, 'car_sedan', '[19,[4454.373,2453.6816,0]]', '[]', '[]', '89', NULL),

(119, 'ATV_US_EP1', '[-190,[4564.9624,2371.521,0]]', '[[[],[]],[["ItemTent","ItemHeatPack","FoodCanBakedBeans"],[1,1,1]],[[],[]]]', '[["motor",0.8],["palivo",0.8],["wheel_1_1_steering",1],["wheel_1_2_steering",1],["wheel_2_1_steering",0.0156045],["wheel_1_3_steering",0.0401988],["wheel_2_3_steering",1]]', '90', NULL),

(523, 'Old_bike_TK_INS_EP1', '[-56,[4570.3975,2421.6531,0]]', '[]', '[]', '91', NULL),

(822, 'AH6X_DZ', '[-190,[13112.096,10432.461,0]]', '[]', '[]', '92', NULL),

(343, 'hilux1_civil_3_open', '[-161,[13145.874,10416.225,0]]', '[]', '[]', '93', NULL),

(424, 'UralCivil2', '[108,[13109.942,10302.45,0]]', '[]', '[]', '94', NULL),

(425, 'UralCivil2', '[-161,[13098.729,10248.01,0]]', '[]', '[]', '95', NULL),

(426, 'S1203_TK_CIV_EP1', '[-3,[12996.397,10078.24,0]]', '[]', '[]', '96', NULL),

(344, 'Lada2', '[-171,[12989.563,10075.743,0]]', '[]', '[]', '97', NULL),

(345, 'datsun1_civil_1_open', '[-75,[12987.494,10039.641,0]]', '[]', '[]', '98', NULL),

(713, 'Tractor', '[-75,[12670.277,10015.792,0]]', '[]', '[]', '99', NULL),

(714, 'Tractor', '[108,[12684.55,10074.417,0]]', '[]', '[]', '100', NULL),

(427, 'UralCivil', '[-25,[12683.362,9825.7119,0]]', '[]', '[]', '101', NULL),

(346, 'Lada1_TK_CIV_EP1', '[-122,[12283.381,9464.5566,0]]', '[]', '[]', '102', NULL),

(715, 'Tractor', '[-3,[12102.996,9451.2998,0]]', '[]', '[]', '103', NULL),

(823, 'AH6X_DZ', '[-117,[9698.9893,13686.655,0]]', '[]', '[]', '111', NULL);

/*!40000 ALTER TABLE `object_spawns` ENABLE KEYS */;

So again, if you want to spawn 100 vehicles you need to change the "PMain" procedure to spawn 100 times and you have to have at least 100 entries in the "object_spawn" Table

[sk8ters24 0]

The thing is, there is no PMain section in my database. Here is a screen of the only other section I have access to.

[Allie (DayZ) 97]

There is a TAB on that picture called "routines", whats under there ?

It looks you are using a different database then i am.

I'm using NaviCatLite for interacting with the database.

Whats in the table "instance_vehicles" ?

So it might just be that things are differently named in this database, we just have to figure out how :)

Edited January 18, 2013 by Allie

[sk8ters24 0]

This is what is in routine: Here is instance_vehicles, it just gives you the list of vehicles currently on the server and their loadout: I too have NaviCatLite, I just prefer this because it is done in your web browser. Even using it though, there is no PMain.

Edited January 18, 2013 by sk8ters24

[Allie (DayZ) 97]

Ok, the last picture is indeed what at my end is called "objects_spawn"

here is an overview of my database, please note that there are more tables then used in my database because i'm also testing version 1.7.5

Uploaded with ImageShack.us

So it seems your "instance_vehicle" is as my "Object_spawn", this table needs to have at least 100 entries when you want to spawn 100 vehicle, every vehicle has its own spawn location( you can't just spawn 2 choppers on the same coordenates)

So we now only need to find the little script that spawns the stuff.

Actually, there is one more table that needs to be altered, for me it is called "object_classes", see picture, we need to edit the amount of each vehicle that can spawn.

"MaxNum" its called in my table.

Your table will probably be "vehicles", just see if it looks like my table(again, there might be some small differences)

Again, we now only need to find the script ........

Edited January 18, 2013 by Allie

[sk8ters24 0]

I seemed to have found a similar thing to your MaxNum, here is what mine looks like: As for finding the PMain file, I sent a support ticket in, so if we cannot figure this out, they can probably tell me. Also, I need help finding the world coordinates in-game. I have no idea how to find them, I tried to compare some and the Cords look nothing like the ones IG. Here is the location of an AH6 I want: [2,[12010.7,12637.2,0]], can you figure out those cords In-game somehow? P.S. I will be going somewhere for about an hour or two from the point this was edited. If you do not receive a reply, I will reply when I get back, don't worry.

Edited January 18, 2013 by sk8ters24

[Allie (DayZ) 97]

Good plan, if you can get help, its maybe better, i'm not familiar with your database structure.

But still, the 2 tables are found.

The "vehicle" table just houses all vehicles that can be spawn, they are all just 1 time in that table, you don't have to change anything exept the "limit_Max", but here comes the trick, for insance if you have "limit_max" for a "UH1 helicopter" at 5, then the table called "instance_vehicle" needs to have 5 entries for a "UH1", they all have to have a different "world coordenates".

Lets find the script that does the spawning now, just have a good look trueout the database and see if you can find anything like this:

BEGIN

DECLARE iSpawnNumVeh SMALLINT(3) DEFAULT 11; <<<<<<<< change default to 100 if you want 100 spawns

CALL pCleanup();

CALL pFixMaxNum;

SELECT SUM(MaxNum) FROM object_classes INTO @iMaxNumTotal;

IF (iSpawnNumVeh > @iMaxNumTotal) THEN

SET iSpawnNumVeh = @iMaxNumTotal;

END IF;

WHILE (fGetVehCount() < iSpawnNumVeh) DO

CALL pSpawn();

END WHILE;

END//

It will NOT be the same, but maybe you can find something like it .

PS: Is this an "official Hive" server ?

What are those V_* files ?

Edited January 18, 2013 by Allie

[sk8ters24 0]

I have looked through all, but one question before I go and I will look later, is PMain a Procedure or a Table? Because According to your picture, PMain is a procedure, I looked up all procedures in my database and I found none. And it is a Hive, but not connected globally, only to other servers hosted by HFB.

[Allie (DayZ) 97]

It is a Procedure on my database

Good luck, maybe speak later.

While im waiting on my downloads, i will try get info on your database.

Edited January 18, 2013 by Allie

[sk8ters24 0]

So mine will be different, I must look for a table or something similar, anyway, I must go for an hour or so, I will reply when I get back and took a look throughout again. See you later. Also a quick note, my hosts Control Panel allows me to click a button and it will automatically add vehicles to the server(basically adds vehicles to the instance_Vehicles table for me), but because I cannot find the max vehicle limit on my database, I am only getting about 60 vehicles total on my server.

Edited January 18, 2013 by sk8ters24

[Allie (DayZ) 97]

http://www.tunngle.net/community/topic/123131-solved-help-with-adding-more-vehicle-spawns-to-the-map-chernarus/

Check this, i think this has the same layout as you.

[sk8ters24 0]

Oh! I think I understand it now! I do not have a general max vehicle limit. I just change on which amount of vehicles I want to spawn more.

[sk8ters24 0]

Ok, I think it worked, but do you mind giving me some cords to spawn the new vehicles in? I need 1 on the NWA runway for a CJ, and maybe 2 more around the area for 2 choppers, the rest, just be random. I also, still do not understand how to read the Cords from the database and find the vehicle In-game. PS: Didn't mean to double post, my bad. EDIT: No, this did not work and I also got a reply for my ticket, here is the exact answer: "Bliss does not have such a table. Spawned vehicles are inserted into the "Instance_vehicle" table in your database." This still makes no sense because how do I increase the vehicle limit if that just tells me what vehicles are on the server?

Edited January 19, 2013 by sk8ters24