local colorQuery = nil
if ( not color1 ) and ( not color2 ) then
colorQuery = "color1='0', color2='0', custom_colors='".. sql:escape_string(colors) .."'"
else
colorQuery = "color1=".. sql:escape_string(color1) ..", color2=".. sql:escape_string(color2) ..", custom_colors=''"
end
local update = sql:query("UPDATE vehicles SET currx=".. sql:escape_string(x) ..", curry=".. sql:escape_string
..", currz=".. sql:escape_string(z) ..", currrotx=".. sql:escape_string(rotx) ..", currroty=".. sql:escape_string(roty) ..", currrotz=".. sql:escape_string(rotz) ..", currdimension=".. sql:escape_string(dim) ..", currinterior=".. sql:escape_string(int) ..", fuel=".. sql:escape_string(fuel) ..", lights=".. sql:escape_string(lights) ..", engine=".. sql:escape_string(engine) ..", enginebroke=".. sql:escape_string(enginebroke) ..", handbrake=".. sql:escape_string(handbrake) ..", ".. colorQuery ..", `upgrades`='".. sql:escape_string( upgrades ) .."', health=".. sql:escape_string(health) ..", Impounded=".. sql:escape_string(impounded) .." WHERE id=".. sql:escape_string(dbid) .."")
if not (update) then
outputDebugString("MySQL Error: Vehicle saving failed!", 1)
end
sql:free_result(update)
end
addEventHandler("onVehicleExit", getRootElement(), saveVehicle)
addEvent("saveVehicle", true)
addEventHandler("saveVehicle", getRootElement(), saveVehicle)