[UPDATED] Vanilla & DLC Vehicles [Diamond Casino, Cayo Perico, Los Santos Tuners DLC, The Contract, LS: Drug Wars, Bottom Dollar Bounties, The Chop Shop, San Andreas Mercenaries]

leaksy · May 2, 2021, 8:10am

GTAV: ONLINE Vanilla & DLC Vehicles SQL File

Download Links:
GitHub Repository

This SQL file offers an extensive list of over 500 vehicles from various Grand Theft Auto Online DLCs, such as:

Diamond Casino
Cayo Perico
Los Santos Tuners
The Contract
Los Santos: Drug Wars
Bottom Dollar Bounties
The Chop Shop
San Andreas Mercenaries

Important Notes:

This SQL file excludes flying vehicles and those equipped with weapons.
Some vehicles may be missing due to unavailable spawn codes.
Ensure compatibility by adding the following line to your start.bat file:

Instructions:

Download the file from GitHub
Set your gamebuild to the latest one (Gamebuild 3258).
To set your gamebuild, add the following line to your start.bat file:
```
+set sv_enforceGameBuild 3258
```
Download esx_vehicleshop if you don’t have it. You can use it with other resources
Insert the mySQL file into your FiveM server database.
Start your server after inserting the mySQL file into your database.
Check the vehicle shop—they will be available.

Updates:

LATEST Update 5.0: Added the new Bottom Dollar Bounties, The Chop Shop, San Andreas Mercenaries (Gamebuild 3258)
Update 4.0: Added the new Los Santos Drug Wars DLC (Gamebuild 2802)
Update 3.0: Added the new The Contract DLC (Gamebuild 2545)
Update 2.0: Added the new Los Santos Tuners DLC (Gamebuild 2372)
Release 1.0: Initial release, includes the Cayo Perico DLC & Diamond Casino DLC Vehicles (Gamebuild 2189)

Spacetrucker · May 2, 2021, 8:55am

this is amazing thanks for doing all the work, quick question though, this is for the base game cars for fivem right, this does not include expansion stuff like casino cars and the like. Just wondering because I’m not using any of the extra expansion cars and don’t know what would happen to my dealership if there is a car in the database that would not spawn ingame without either changing the server build thing or grabbing the converted resources.

leaksy · May 2, 2021, 9:09am

Thanks!

But yes, it does include the casino cars and the cayo perico onces… Forgot to mention that, you can fix that by putting ’ +set sv_enforceGameBuild 2189’ in your start.bat file. It just loads all the DLC’s, so you can have the DLC cars (Cayo Perico & Diamond Casino)!

Spacetrucker · May 2, 2021, 9:11am

awesome ill set the game build and test it out thank you so much! thats cool i did not know that you could set it to 2189 and get all of the expansions thought it was either/or, thanks again!

Flobbah · May 2, 2021, 10:40am

I started working on this yesterday, i reached like 25% of all vehicles… You saved me so much time! Thank you!

Spacetrucker · May 2, 2021, 10:43am

thats so weird, i deleted out my two tables to put in your version and got this error, good thing i made a back up, would have been nice to use your list, I’m dead in the water unless you have any ideas

here is line 146

function OpenShopMenu()
IsInShopMenu = true

StartShopRestriction()
ESX.UI.Menu.CloseAll()

local playerPed = PlayerPedId()

FreezeEntityPosition(playerPed, true)
SetEntityVisible(playerPed, false)
SetEntityCoords(playerPed, Config.Zones.ShopInside.Pos)

local vehiclesByCategory = {}
local elements           = {}
local firstVehicleData   = nil

for i=1, #Categories, 1 do          --line 146
	vehiclesByCategory[Categories[i].name] = {}
end

for i=1, #Vehicles, 1 do
	if IsModelInCdimage(GetHashKey(Vehicles[i].model)) then
		table.insert(vehiclesByCategory[Vehicles[i].category], Vehicles[i])
	else
		print(('esx_vehicleshop: vehicle "%s" does not exist'):format(Vehicles[i].model))
	end
end

leaksy · May 2, 2021, 10:52am

No problem!

leaksy · May 2, 2021, 10:57am

Did you chainge the table names server side?
It should have a line that goes something like this

function SQLVehiclesAndCategories()
	MySQL.Async.fetchAll('SELECT * FROM `vehicle_categories`', {}, function(_categories)
		categories = _categories

		MySQL.Async.fetchAll('SELECT * FROM `vehicles`', {}, function(_vehicles)
			vehicles = _vehicles

			GetVehiclesAndCategories(categories, vehicles)
		end)

	end)
end

What you do is you chainge the vehicle_categories, chainge it to vehicles_category and for the vehicles leave it the same, tell me if that works!

Edit-

It’s usually something along those lines, it’s probably not reading the new categories and the vehicles table has motorcycles and cycles table…

Spacetrucker · May 2, 2021, 11:29am

that worked going into the server side of the shop and changing vehicle_categories to vehicles_category

thank you so much, going beyond the call of duty!!

leaksy · May 2, 2021, 11:34am

Glad to help! Enjoy driving around in the cars!

Spacetrucker · May 2, 2021, 11:43am

thank you it helps the server so much, it added all the new clothes too, I never had a chance to mess with the minitank either so that was one of the first things I did . You did my server a great service today. Thanks again. And good luck on your future projects

leaksy · May 2, 2021, 11:46am

Hope your players like the cars and the clothes! And thank you!

RYN_3d · May 2, 2021, 12:05pm

how do i spawn the vehicles in with vmenu

leaksy · May 2, 2021, 12:28pm

Oh unsure on that one, i think you need to enter the spawn code of the vehicle…
The model column to be exact.

Would offer more help but never used vMenu before.

RYN_3d · May 2, 2021, 12:46pm

what do you recommend to use to spawn in vehicles

RYN_3d · May 2, 2021, 12:47pm

and where do i put the sql file (fivem vanilla vehicles)

leaksy · May 2, 2021, 12:53pm

I use ESX 1.1, it’s basically a framework for roleplay server… It has many useful functions and commands like /car [modelname]… To install the SQL file you need to have Heidi SQL and XAMPP and also a database for your server and a script named esx_vehicleshop.

If you are new to developing servers i would recomment following a couple of tutorials to get you started:

But i will install vMenu on my localhost and see what i can do from there and help you on spawning the vehicles.

RYN_3d · May 2, 2021, 12:56pm

ty man i appreciate that

leaksy · May 2, 2021, 1:06pm

Okay so, when you start vMenu with the M button, go to the Vehicle Related Options - then Vehicle Spawner and select the first one, the Spawn Vehicle By Model Name and click enter, a windows should pop up saying - Enter Vehicle Name, here you enter the second column of the database.

The one before the numbers (price).

STEPS
1.

2.

3.

4.

5.

6.

Hope this helps!!!

RYN_3d · May 2, 2021, 3:33pm

thanks