[UPDATED] Vanilla & DLC vehicles [Diamond Casino, Cayo Perico, Los Santos Tuners DLC, The Contract,LS:DrugWars]

On the github page, you can find a .sql file with ~450+ vehicles. The SQL file is made for ESX_VehicleShop but can be used for any other script that has similar/same sql format to ESX_VehicleShop.

If you see any errors & mistakes please notify me, this was made in a matter of around two hours… Every UPDATE might be missing some vehicles because of sources for spawning those vehicles.

:man_teacher:Instructions

  1. Download the file from Github
  2. Set your gamebuild to the latest one. (Gamebuild 2802)
  3. To set your gamebuild put +set sv_enforceGameBuild 2802 in your start.bat file
  4. If you don’t have esx_vehicleshop, please download it!
  5. Insert the mySQL File into your FiveM server database.
  6. After inserting the mySQL file into your servers database, start your server.
  7. Check the vehicle shop, they will be there.

:arrow_down:Download Links
:arrow_down: GitHub
:arrow_down: Direct Download.

:chart_with_downwards_trend:Script Updates
LATEST 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 - First release, contains the Cayo Perico DLC & Casino DLC Vehicles (Gamebuild 2189)

15 Likes

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.

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)!

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!

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

1 Like

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

No problem!

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…

1 Like

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!!

1 Like

Glad to help! Enjoy driving around in the cars! :grinning_face_with_smiling_eyes:

1 Like

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

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

1 Like

how do i spawn the vehicles in with vmenu

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

Would offer more help but never used vMenu before.

what do you recommend to use to spawn in vehicles

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

1 Like

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:

  1. Tutorial on FiveM Docs
  2. Tutorial on how to install an ESX Server by BGHDDevelopment

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

ty man i appreciate that

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.
image
2.
image
3.


4.

5.

6.

Hope this helps!!!

1 Like

thanks