Hello i have ah Problem,
we can i Store Mod17 -22
The other Mods saved in my Database only for mod17 - 22 will not save?!The rest Works
The code for the Modsave.
AddEventHandler('UpdateVeh', function(plate, primarycolor, secondarycolor, pearlescentcolor, wheelcolor, mods)
TriggerEvent('es:getPlayerFromId', source, function(user)
local mods = mods
local player = user.identifier
local name = name
local price = price
local vehicles = vehicles
local plate = plate
local state = "Draußen"
local primarycolor = primarycolor
local secondarycolor = secondarycolor
local pearlescentcolor = pearlescentcolor
local wheelcolor = wheelcolor
local executed_query = MySQL:executeQuery("update user_vehicles Set vehicles_colorprimary='@primarycolor', vehicles_colorsecondary='@secondarycolor', vehicles_pearlescentcolor='@pearlescentcolor', vehicles_wheelcolor='@wheelcolor' where vehicles_plate='@plate'",
{['@username'] = player, ['@name'] = name, ['@vehicles'] = vehicles, ['@price'] = price, ['@plate'] = plate, ['@state'] = state, ['@primarycolor'] = primarycolor, ['@secondarycolor'] = secondarycolor, ['@pearlescentcolor'] = pearlescentcolor, ['@wheelcolor'] = wheelcolor})
for i,t in pairs(mods) do
--print('Versuche, Mods zu aktualisieren')
if t.mod ~= nil then
--print("Mod#: "..i.." Wert: " .. t.mod)
local executed_query = MySQL:executeQuery("update user_vehicles set mod"..i.."='"..t.mod.."' where vehicles_plate='"..plate.."'" )
end
end
end)
end)