Server gets flooded with vehicles

[Anthraxx]

Hey All, 

 

I have a question. 

In my init.sqf i have MaxVehicleLimit = 300; // Default = 100.

Now when I turn on my ESP icons in my server that number is closer too 3000 than 300 in my opinion.

There are vehicles literally everywhere

 

Is there anything I might have missed?

or does anyone have a solution for this?

 

Maybe an SQL query that i can run?  (im not good at SQL and queries, so forgive me :p  )

 

Thanks in advance

[cen]

Run this query. How many results you get?

SELECT
object_data.ObjectID,
object_data.ObjectUID,
object_data.Worldspace,
object_data.Classname,
(CASE
        WHEN object_data.CharacterID < 2501 THEN CONCAT('ItemKeyGreen', object_data.CharacterID)
        WHEN object_data.CharacterID < 5001 THEN CONCAT('ItemKeyRed', object_data.CharacterID - 2500)
        WHEN object_data.CharacterID < 7501 THEN CONCAT('ItemKeyBlue', object_data.CharacterID - 5000)
        WHEN object_data.CharacterID < 10001 THEN CONCAT('ItemKeyYellow', object_data.CharacterID - 7500)
        WHEN object_data.CharacterID < 12501 THEN CONCAT('ItemKeyBlack', object_data.CharacterID - 10000)
        ELSE 'ERROR'
END) as `KeyColour`,
(SELECT COUNT(*) FROM `character_data` WHERE `Alive` = '1' AND (`Inventory` LIKE CONCAT('%', KeyColour, '%') OR `Backpack` LIKE CONCAT('%', KeyColour, '%'))) AS InChar,
(SELECT COUNT(*) FROM `object_data` WHERE `Inventory` LIKE CONCAT('%', KeyColour, '%')) AS InVeh
FROM `object_data`
WHERE `CharacterID` <> '0'
AND `CharacterID` <= 12500
AND `Classname` NOT LIKE 'Land%'
AND `Classname` NOT LIKE 'Cinder%'
AND `Classname` NOT LIKE 'Wood%'  
AND `Classname` NOT LIKE 'Metal%'
AND `Classname` NOT LIKE '%Storage%'
AND `Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ','DesertCamoNet_DZ','StickFence_DZ','LightPole_DZ','DeerStand_DZ','ForestLargeCamoNet_DZ','Plastic_Pole_EP1_DZ','Hedgehog_DZ','FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ')
HAVING
InChar = 0 AND InVeh = 0

[Anthraxx]

just 25.

 

The amount of random vehicles which come with dynamic spawn is immense it seems

[Anthraxx]

Still having the issue :(

 

http://imgur.com/a/dFls3

[Anthraxx]

anyone?

[Achmed]

Try deleting all the vehicles and then see if they come back.

We had the same issue and believe it may be to do with what was fixed in 1.0.4.2a

[Anthraxx]

manually? that would take me a while, but i guess someone has to do it :p

Thanks

[Achmed]

I did it manually on mine to make sure I didn't get any that was being used but it would be possiable via the database

[Geryon]

Did you upgrade to 1.0.4.2a?  I noticed it disappeared with that upgrade on our server.