Thank you so much, I will try it in a second.
Do you know why some players are freezing in the air in my server?
Do you know a script to show a player’s ID in screen? But the pernament ID from the database.
No, but you can modify the Dunko’s one changing the output. Is the garage script working?
Yea it’s working thank you so much!
Cool. Enjoy it
Can you please send a script of that? (The player ID in screen script)
or can you make one for me? 
Do you know why my LS Customs script is not taking money from the players when they buy something?
Could you send me the same script but then with the buy option enabled and the rent option disabled?
Are you using dunko’s lscustoms?
-- a basic garage implementation
-- vehicle db
MySQL.createCommand("vRP/vehicles_table", [[
CREATE TABLE IF NOT EXISTS vrp_user_vehicles(
user_id INTEGER,
vehicle VARCHAR(100),
CONSTRAINT pk_user_vehicles PRIMARY KEY(user_id,vehicle),
CONSTRAINT fk_user_vehicles_users FOREIGN KEY(user_id) REFERENCES vrp_users(id) ON DELETE CASCADE
);
]])
MySQL.createCommand("vRP/add_vehicle","INSERT IGNORE INTO vrp_user_vehicles(user_id,vehicle) VALUES(@user_id,@vehicle)")
MySQL.createCommand("vRP/remove_vehicle","DELETE FROM vrp_user_vehicles WHERE user_id = @user_id AND vehicle = @vehicle")
MySQL.createCommand("vRP/get_vehicles","SELECT vehicle FROM vrp_user_vehicles WHERE user_id = @user_id")
MySQL.createCommand("vRP/get_vehicle","SELECT vehicle FROM vrp_user_vehicles WHERE user_id = @user_id AND vehicle = @vehicle")
-- init
MySQL.execute("vRP/vehicles_table")
-- load config
local cfg = module("cfg/garages")
local cfg_inventory = module("cfg/inventory")
local vehicle_groups = cfg.garage_types
local lang = vRP.lang
local garages = cfg.garages
-- garage menus
local garage_menus = {}
for group,vehicles in pairs(vehicle_groups) do
local veh_type = vehicles._config.vtype or "default"
local menu = {
name=lang.garage.title({group}),
css={top = "75px", header_color="rgba(255,125,0,0.75)"}
}
garage_menus[group] = menu
menu[lang.garage.owned.title()] = {function(player,choice)
local user_id = vRP.getUserId(player)
if user_id ~= nil then
-- init tmpdata for rents
local tmpdata = vRP.getUserTmpTable(user_id)
if tmpdata.rent_vehicles == nil then
tmpdata.rent_vehicles = {}
end
-- build nested menu
local kitems = {}
local submenu = {name=lang.garage.title({lang.garage.owned.title()}), css={top="75px",header_color="rgba(255,125,0,0.75)"}}
submenu.onclose = function()
vRP.openMenu(player,menu)
end
local choose = function(player, choice)
local vname = kitems[choice]
if vname then
-- spawn vehicle
local vehicle = vehicles[vname]
if vehicle then
vRP.closeMenu(player)
vRPclient.spawnGarageVehicle(player,{veh_type,vname})
end
end
end
-- get player owned vehicles
MySQL.query("vRP/get_vehicles", {user_id = user_id}, function(pvehicles, affected)
-- add rents to whitelist
for k,v in pairs(tmpdata.rent_vehicles) do
if v then -- check true, prevent future neolua issues
table.insert(pvehicles,{vehicle = k})
end
end
for k,v in pairs(pvehicles) do
local vehicle = vehicles[v.vehicle]
if vehicle then
submenu[vehicle[1]] = {choose,vehicle[3]}
kitems[vehicle[1]] = v.vehicle
end
end
vRP.openMenu(player,submenu)
end)
end
end,lang.garage.owned.description()}
menu[lang.garage.buy.title()] = {function(player,choice)
local user_id = vRP.getUserId(player)
if user_id ~= nil then
-- build nested menu
local kitems = {}
local submenu = {name=lang.garage.title({lang.garage.buy.title()}), css={top="75px",header_color="rgba(255,125,0,0.75)"}}
submenu.onclose = function()
vRP.openMenu(player,menu)
end
local choose = function(player, choice)
local vname = kitems[choice]
if vname then
-- buy vehicle
local vehicle = vehicles[vname]
if vehicle and vRP.tryPayment(user_id,vehicle[2]) then
MySQL.execute("vRP/add_vehicle", {user_id = user_id, vehicle = vname})
vRPclient.notify(player,{lang.money.paid({vehicle[2]})})
vRP.closeMenu(player)
else
vRPclient.notify(player,{lang.money.not_enough()})
end
end
end
-- get player owned vehicles (indexed by vehicle type name in lower case)
MySQL.query("vRP/get_vehicles", {user_id = user_id}, function(_pvehicles, affected)
local pvehicles = {}
for k,v in pairs(_pvehicles) do
pvehicles[string.lower(v.vehicle)] = true
end
-- for each existing vehicle in the garage group
for k,v in pairs(vehicles) do
if k ~= "_config" and pvehicles[string.lower(k)] == nil then -- not already owned
submenu[v[1]] = {choose,lang.garage.buy.info({v[2],v[3]})}
kitems[v[1]] = k
end
end
vRP.openMenu(player,submenu)
end)
end
end,lang.garage.buy.description()}
menu[lang.garage.sell.title()] = {function(player,choice)
local user_id = vRP.getUserId(player)
if user_id ~= nil then
-- build nested menu
local kitems = {}
local submenu = {name=lang.garage.title({lang.garage.sell.title()}), css={top="75px",header_color="rgba(255,125,0,0.75)"}}
submenu.onclose = function()
vRP.openMenu(player,menu)
end
local choose = function(player, choice)
vRP.request(player,"Are you sure that you want to sell this vehicle?",30,function(player,ok)
if ok then
local vname = kitems[choice]
if vname then
-- sell vehicle
local vehicle = vehicles[vname]
if vehicle then
local price = math.ceil((vehicle[2]*cfg.sell_factor)*1)
MySQL.query("vRP/get_vehicle", {user_id = user_id, vehicle = vname}, function(rows, affected)
if #rows > 0 then -- has vehicle
vRP.giveMoney(user_id,price)
MySQL.execute("vRP/remove_vehicle", {user_id = user_id, vehicle = vname})
vRPclient.notify(player,{lang.money.received({price})})
vRP.closeMenu(player)
else
vRPclient.notify(player,{lang.common.not_found()})
end
end)
end
end
end
end)
end
-- get player owned vehicles (indexed by vehicle type name in lower case)
MySQL.query("vRP/get_vehicles", {user_id = user_id}, function(_pvehicles, affected)
local pvehicles = {}
for k,v in pairs(_pvehicles) do
pvehicles[string.lower(v.vehicle)] = true
end
-- for each existing vehicle in the garage group
for k,v in pairs(pvehicles) do
local vehicle = vehicles[k]
if vehicle then -- not already owned
local price = math.ceil((vehicle[2]*cfg.sell_factor)*1)
submenu[vehicle[1]] = {choose,lang.garage.buy.info({price,vehicle[3]})}
kitems[vehicle[1]] = k
end
end
vRP.openMenu(player,submenu)
end)
end
end,lang.garage.sell.description()}
menu[lang.garage.store.title()] = {function(player,choice)
vRPclient.despawnGarageVehicle(player,{veh_type,15})
end, lang.garage.store.description()}
end
local function build_client_garages(source)
local user_id = vRP.getUserId(source)
if user_id ~= nil then
for k,v in pairs(garages) do
local gtype,x,y,z = table.unpack(v)
local group = vehicle_groups[gtype]
if group then
local gcfg = group._config
-- enter
local garage_enter = function(player,area)
local user_id = vRP.getUserId(source)
if user_id ~= nil and vRP.hasPermissions(user_id,gcfg.permissions or {}) then
local menu = garage_menus[gtype]
if menu then
vRP.openMenu(player,menu)
end
end
end
-- leave
local garage_leave = function(player,area)
vRP.closeMenu(player)
end
vRPclient.addBlip(source,{x,y,z,gcfg.blipid,gcfg.blipcolor,lang.garage.title({gtype})})
vRPclient.addMarker(source,{x,y,z-1,0.7,0.7,0.5,0,255,125,125,150})
vRP.setArea(source,"vRP:garage"..k,x,y,z,1,1.5,garage_enter,garage_leave)
end
end
end
end
AddEventHandler("vRP:playerSpawn",function(user_id,source,first_spawn)
if first_spawn then
build_client_garages(source)
end
end)
-- VEHICLE MENU
-- define vehicle actions
-- action => {cb(user_id,player,veh_group,veh_name),desc}
local veh_actions = {}
-- open trunk
veh_actions[lang.vehicle.trunk.title()] = {function(user_id,player,vtype,name)
local chestname = "u"..user_id.."veh_"..string.lower(name)
local max_weight = cfg_inventory.vehicle_chest_weights[string.lower(name)] or cfg_inventory.default_vehicle_chest_weight
-- open chest
vRPclient.vc_openDoor(player, {vtype,5})
vRP.openChest(player, chestname, max_weight, function()
vRPclient.vc_closeDoor(player, {vtype,5})
end)
end, lang.vehicle.trunk.description()}
-- detach trailer
veh_actions[lang.vehicle.detach_trailer.title()] = {function(user_id,player,vtype,name)
vRPclient.vc_detachTrailer(player, {vtype})
end, lang.vehicle.detach_trailer.description()}
-- detach towtruck
veh_actions[lang.vehicle.detach_towtruck.title()] = {function(user_id,player,vtype,name)
vRPclient.vc_detachTowTruck(player, {vtype})
end, lang.vehicle.detach_towtruck.description()}
-- detach cargobob
veh_actions[lang.vehicle.detach_cargobob.title()] = {function(user_id,player,vtype,name)
vRPclient.vc_detachCargobob(player, {vtype})
end, lang.vehicle.detach_cargobob.description()}
-- lock/unlock
veh_actions[lang.vehicle.lock.title()] = {function(user_id,player,vtype,name)
vRPclient.vc_toggleLock(player, {vtype})
end, lang.vehicle.lock.description()}
-- engine on/off
veh_actions[lang.vehicle.engine.title()] = {function(user_id,player,vtype,name)
vRPclient.vc_toggleEngine(player, {vtype})
end, lang.vehicle.engine.description()}
--sell2
MySQL.createCommand("vRP/sell_vehicle_player","UPDATE vrp_user_vehicles SET user_id = @user_id, vehicle_plate = @registration WHERE user_id = @oldUser AND vehicle = @vehicle")
-- sell vehicle
veh_actions[lang.vehicle.sellTP.title()] = {function(playerID,player,vtype,name)
if playerID ~= nil then
vRPclient.getNearestPlayers(player,{15},function(nplayers)
usrList = ""
for k,v in pairs(nplayers) do
usrList = usrList .. "[" .. vRP.getUserId(k) .. "]" .. GetPlayerName(k) .. " | "
end
if usrList ~= "" then
vRP.prompt(player,"Players Nearby: " .. usrList .. "","",function(player,user_id)
user_id = user_id
if user_id ~= nil and user_id ~= "" then
local target = vRP.getUserSource(tonumber(user_id))
if target ~= nil then
vRP.prompt(player,"Price $: ","",function(player,amount)
if (tonumber(amount)) then
MySQL.query("vRP/get_vehicle", {user_id = user_id, vehicle = name}, function(pvehicle, affected)
if #pvehicle > 0 then
vRPclient.notify(player,{"~r~The player already has this vehicle type."})
else
local tmpdata = vRP.getUserTmpTable(playerID)
if tmpdata.rent_vehicles[name] == true then
vRPclient.notify(player,{"~r~You cannot sell a rented vehicle!"})
return
else
vRP.request(target,GetPlayerName(player).." wants to sell: " ..name.. " Price: $"..amount, 10, function(target,ok)
if ok then
local pID = vRP.getUserId(target)
local money = vRP.getMoney(pID)
if (tonumber(money) >= tonumber(amount)) then
vRPclient.despawnGarageVehicle(player,{vtype,15})
vRP.getUserIdentity(pID, function(identity)
MySQL.execute("vRP/sell_vehicle_player", {user_id = user_id, registration = "P "..identity.registration, oldUser = playerID, vehicle = name})
end)
vRP.giveMoney(playerID, amount)
vRP.setMoney(pID,money-amount)
vRPclient.notify(player,{"~g~You have successfully sold the vehicle to ".. GetPlayerName(target).." for $"..amount.."!"})
vRPclient.notify(target,{"~g~"..GetPlayerName(player).." has successfully sold you the car for $"..amount.."!"})
else
vRPclient.notify(player,{"~r~".. GetPlayerName(target).." doesn't have enough money!"})
vRPclient.notify(target,{"~r~You don't have enough money!"})
end
else
vRPclient.notify(player,{"~r~"..GetPlayerName(target).." has refused to buy the car."})
vRPclient.notify(target,{"~r~You have refused to buy "..GetPlayerName(player).."'s car."})
end
end)
end
vRP.closeMenu(player)
end
end)
else
vRPclient.notify(player,{"~r~The price of the car has to be a number."})
end
end)
else
vRPclient.notify(player,{"~r~That ID seems invalid."})
end
else
vRPclient.notify(player,{"~r~No player ID selected."})
end
end)
else
vRPclient.notify(player,{"~r~No player nearby."})
end
end)
end
end, lang.vehicle.sellTP.description()}
local function ch_vehicle(player,choice)
local user_id = vRP.getUserId(player)
if user_id ~= nil then
-- check vehicle
vRPclient.getNearestOwnedVehicle(player,{7},function(ok,vtype,name)
if ok then
-- build vehicle menu
vRP.buildMenu("vehicle", {user_id = user_id, player = player, vtype = vtype, vname = name}, function(menu)
menu.name=lang.vehicle.title()
menu.css={top="75px",header_color="rgba(255,125,0,0.75)"}
for k,v in pairs(veh_actions) do
menu[k] = {function(player,choice) v[1](user_id,player,vtype,name) end, v[2]}
end
vRP.openMenu(player,menu)
end)
else
vRPclient.notify(player,{lang.vehicle.no_owned_near()})
end
end)
end
end
-- ask trunk (open other user car chest)
local function ch_asktrunk(player,choice)
vRPclient.getNearestPlayer(player,{10},function(nplayer)
local nuser_id = vRP.getUserId(nplayer)
if nuser_id ~= nil then
vRPclient.notify(player,{lang.vehicle.asktrunk.asked()})
vRP.request(nplayer,lang.vehicle.asktrunk.request(),15,function(nplayer,ok)
if ok then -- request accepted, open trunk
vRPclient.getNearestOwnedVehicle(nplayer,{7},function(ok,vtype,name)
if ok then
local chestname = "u"..nuser_id.."veh_"..string.lower(name)
local max_weight = cfg_inventory.vehicle_chest_weights[string.lower(name)] or cfg_inventory.default_vehicle_chest_weight
-- open chest
local cb_out = function(idname,amount)
vRPclient.notify(nplayer,{lang.inventory.give.given({vRP.getItemName(idname),amount})})
end
local cb_in = function(idname,amount)
vRPclient.notify(nplayer,{lang.inventory.give.received({vRP.getItemName(idname),amount})})
end
vRPclient.vc_openDoor(nplayer, {vtype,5})
vRP.openChest(player, chestname, max_weight, function()
vRPclient.vc_closeDoor(nplayer, {vtype,5})
end,cb_in,cb_out)
else
vRPclient.notify(player,{lang.vehicle.no_owned_near()})
vRPclient.notify(nplayer,{lang.vehicle.no_owned_near()})
end
end)
else
vRPclient.notify(player,{lang.common.request_refused()})
end
end)
else
vRPclient.notify(player,{lang.common.no_player_near()})
end
end)
end
-- repair nearest vehicle
local function ch_repair(player,choice)
local user_id = vRP.getUserId(player)
if user_id ~= nil then
-- anim and repair
if vRP.tryGetInventoryItem(user_id,"repairkit",1,true) then
vRPclient.playAnim(player,{false,{task="WORLD_HUMAN_WELDING"},false})
SetTimeout(15000, function()
vRPclient.fixeNearestVehicle(player,{7})
vRPclient.stopAnim(player,{false})
end)
end
end
end
-- replace nearest vehicle
local function ch_replace(player,choice)
vRPclient.replaceNearestVehicle(player,{7})
end
vRP.registerMenuBuilder("main", function(add, data)
local user_id = vRP.getUserId(data.player)
if user_id ~= nil then
-- add vehicle entry
local choices = {}
choices[lang.vehicle.title()] = {ch_vehicle}
-- add ask trunk
choices[lang.vehicle.asktrunk.title()] = {ch_asktrunk}
-- add repair functions
if vRP.hasPermission(user_id, "vehicle.repair") then
choices[lang.vehicle.repair.title()] = {ch_repair, lang.vehicle.repair.description()}
end
if vRP.hasPermission(user_id, "vehicle.replace") then
choices[lang.vehicle.replace.title()] = {ch_replace, lang.vehicle.replace.description()}
end
add(choices)
end
end)
Uhm I don’t think so. Maybe.
Is this the new script for the garage?
Yes, try it. Are you using the Dunko’s edit right?
yes (20 characters)
Sorry for the many questions but can you help me with that script again? Is it possible to show a message when they click on the button buy? Like this: "Do NOT buy vehicles here, this was only added for whitelisted jobs. Go to the showroom to buy your own car’’. I don’t care what message/popup it is. I’ve pNotify if you are going to use that. Just one last thing I will credit you on my discord server that you helped me a lot. Thanks!
Do you know why the upgrades are not taking money from players? You asked If I was using Dunko’s edit.
I’ll try later.
hello may i ask you how can i add the mobile script and carage
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.