Untitled conversation
- User
local function giveVehicle(identifier, data, stored) if Framework == "esx" then -- Check for the 'stored' column in the owned_vehicles table local query_parking = "SELECT stored FROM owned_vehicles LIMIT 1" local response = FetchQuery(query_parking) if not response[1] then -- If 'stored' column does not exist, create it local query = "ALTER TABLE owned_vehicles ADD COLUMN stored VARCHAR(255) DEFAULT NULL" ExecuteQuery(query) print("Stored column has been added to the database") return end -- Select a random vehicle model from the configured list local randomIndex = math.random(1, #Config.RandomVehicles.vehicles) local vehicleModel = Config.RandomVehicles.vehicles[randomIndex] -- Check if the vehicleModel is valid if not vehicleModel then print("^1[Error] Selected vehicle model is nil at index " .. randomIndex .. "^0") return end -- Get the hash for the vehicle model local vehicleHash = GetHashKey(vehicleModel) -- Prepare the SQL insert statement local query_insert = "INSERT INTO `owned_vehicles` (`owner`, `plate`, `vehicle`, `stored`, `model`, `hash`) VALUES (?, ?, ?, ?, ?, ?)" local params = { identifier, data.props.plate, json.encode(data.props), stored, vehicleModel, vehicleHash } -- Execute the insert query InsertQuery(query_insert, params, function(rowsAffected) if rowsAffected > 0 then print("^2[Database] Vehicle successfully added for " .. identifier .. "^0") else print("^1[Database] Failed to add vehicle for " .. identifier .. "^0") end end) elseif Framework == "qbc" then local Player = Core.Functions.GetPlayer(source) local citizenId = Player.PlayerData.citizenid -- Prepare the SQL insert statement for QBCore local query = "INSERT INTO player_vehicles (license, citizenid, vehicle, hash, mods, plate, garage) VALUES (?, ?, ?, ?, ?, ?, ?)" local params = { Player.PlayerData.license, citizenId, data.vehicle_name, GetHashKey(data.vehicle_name), json.encode(data.props), data.props.plate, data.parking } InsertQuery(query, params, function(rowsAffected) if rowsAffected > 0 then debugPrint("success", "Vehicle has been added to the database") else error("Failed to add vehicle to the database") end end) end endcan you make owned_vehicles custom plate start with BTV and then random
- Assistant
To modify the
giveVehiclefunction so that theplatefor theowned_vehiclestable starts with "BTV" followed by a random combination of characters or numbers, you can add a helper function to generate this random plate. Below is the updated function with the changes implemented.Here's how you can do that:
local function generateCustomPlate() local randomNum = math.random(1000, 9999) -- Random number between 1000 and 9999 return "BTV" .. randomNum -- Combine "BTV" with the random number end local function giveVehicle(identifier, data, stored) if Framework == "esx" then -- Check for the 'stored' column in the owned_vehicles table local query_parking = "SELECT stored FROM owned_vehicles LIMIT 1" local response = FetchQuery(query_parking) if not response[1] then -- If 'stored' column does not exist, create it local query = "ALTER TABLE owned_vehicles ADD COLUMN stored VARCHAR(255) DEFAULT NULL" ExecuteQuery(query) print("Stored column has been added to the database") return end -- Select a random vehicle model from the configured list local randomIndex = math.random(1, #Config.RandomVehicles.vehicles) local vehicleModel = Config.RandomVehicles.vehicles[randomIndex] -- Check if the vehicleModel is valid if not vehicleModel then print("^1[Error] Selected vehicle model is nil at index " .. randomIndex .. "^0") return end -- Get the hash for the vehicle model local vehicleHash = GetHashKey(vehicleModel) -- Generate a custom plate local customPlate = generateCustomPlate() -- Prepare the SQL insert statement local query_insert = "INSERT INTO `owned_vehicles` (`owner`, `plate`, `vehicle`, `stored`, `model`, `hash`) VALUES (?, ?, ?, ?, ?, ?)" local params = { identifier, customPlate, json.encode(data.props), stored, vehicleModel, vehicleHash } -- Execute the insert query InsertQuery(query_insert, params, function(rowsAffected) if rowsAffected > 0 then print("^2[Database] Vehicle successfully added for " .. identifier .. "^0") else print("^1[Database] Failed to add vehicle for " .. identifier .. "^0") end end) elseif Framework == "qbc" then local Player = Core.Functions.GetPlayer(source) local citizenId = Player.PlayerData.citizenid -- Generate a custom plate for QBCore local customPlate = generateCustomPlate() -- Prepare the SQL insert statement for QBCore local query = "INSERT INTO player_vehicles (license, citizenid, vehicle, hash, mods, plate, garage) VALUES (?, ?, ?, ?, ?, ?, ?)" local params = { Player.PlayerData.license, citizenId, data.vehicle_name, GetHashKey(data.vehicle_name), json.encode(data.props), customPlate, data.parking } InsertQuery(query, params, function(rowsAffected) if rowsAffected > 0 then debugPrint("success", "Vehicle has been added to the database") else error("Failed to add vehicle to the database") end end) end endChanges Made:
- Custom Plate Function: A function
generateCustomPlateis created to generate a plate starting with "BTV" followed by a random number. - Integration: The function is used when preparing the SQL insert statement for both ESX and QBCore frameworks.
This will result in each vehicle being assigned a unique plate that begins with "BTV" followed by a random number (e.g., BTV1234). Adjust the number range in
math.random(1000, 9999)based on your requirements for the length of the random part. - Custom Plate Function: A function
- User
hmm but i cant store to my garage :(
- Assistant
If you cannot store vehicles properly to your garage, several issues might need to be addressed, including database design, queries, or relevant logic. Below are some steps and suggestions to help troubleshoot and ensure that the vehicle storage functionality works as intended.
1. Database Structure Check
Ensure your database structure for the
owned_vehiclestable (or the respective table for your framework) supports storing the necessary fields, including thestoredcolumn. You mentioned that you added the column, but confirm the column is present and correctly set up. You should have at least these columns:ownerplatevehiclestored(should allow for eitherNULLor a marker indicating the vehicle is stored, such as '1' or 'true')modelhash
2. Check Insert Logic
Ensure the insert query you are using sets the value for the
storedfield appropriately. You can modify thestoredvariable based on whether the vehicle is being stored in a garage or not. In cases where you want to indicate that a vehicle is stored, you might set it to a value like'1'or'true'.Example of Setting the
storedValue:If you want to indicate that vehicles stored in the garage should set
storedto '1', you can do something like this:local storedValue = stored and '1' or '0' -- Assuming `stored` is a boolean indicating if the vehicle is storedUpdate the SQL insert params accordingly.
3. Insert Function Usage
Ensure the
InsertQueryfunction correctly handles the execution of SQL commands and captures any errors that may occur.Check if your function callback captures errors in the insertion:
InsertQuery(query_insert, params, function(rowsAffected, error) if error then print("^1[Database Error] " .. error .. "^0") -- Log any SQL errors elseif rowsAffected > 0 then print("^2[Database] Vehicle successfully added for " .. identifier .. "^0") else print("^1[Database] Failed to add vehicle for " .. identifier .. "^0") end end)4. Debugging the Storage Logic
If the vehicle does not seem to be stored correctly, consider adding some debug print statements throughout the function to observe the flow of code and where it may fail:
print("Attempting to give vehicle for:", identifier, "with plate:", customPlate) -- Right before InsertQuery print("Inserting vehicle with params:", params)5. Check Garage Logic
If you have specific routines for handling vehicle storage (like entering or exiting a garage), ensure those are functioning correctly. For instance:
- Confirm the logic that determines when a vehicle can or cannot enter the garage.
- Ensure that any messages or feedback from the user interface indicate the success or failure of the parking operation.
6. Testing the Function
Run your function with different scenarios (vehicles with different conditions) to ensure it’s always executing as intended. You might want to test the function separately to see if the insert works when called directly.
-- Sample test call giveVehicle("some-identifier", { props = { plate = "ABC123" }, vehicle_name = "example_model" }, true) -- Pass `true` to storeSummary
If you address the items above and verify your database structure, insert logic, and debugging setup, you should be able to identify the problem with storing vehicles in your garage. If you’re still having issues, detailed logs from your database calls may reveal more about where the flow is failing.