server

RegisterServerEvent('save')
AddEventHandler('save', function(plate, props)
  print('UPDATE owned_vehicles SET `X` = '.. x ..' , `Y` = '.. y ..', `Z` = '.. z ..', `A` = '.. heading ..' WHERE `vehicle` LIKE "%' .. plate .. '%"')
  local feedback='Saving Vehicle Pos: '.. plate

  MySQL.Async.execute(
        'UPDATE `owned_vehicles` SET `X` = @x , `Y` = @y, `Z` = @z, `A` = @a WHERE `vehicle` LIKE "%' .. plate .. '%"',
        {
            ['@x'] = x, ['@y'] = y, ['@z'] = z, ['@a'] = heading
        }, function(rowsChanged)
      print(feedback.. " | Updated: " .. rowsChanged)
    end)

end)
function LoaderVeh()
  MySQL.Async.fetchAll(
    'SELECT * FROM owned_vehicles',
    {},
    function (result)
      for i=1, #result, 1 do
        if result[i].X == 0 then
          print("Loading Vehicle: (ID:".. result[i].id ..") => Skipping due Spawn @0 coordinates" )
        else
          local veh = json.decode(result[i].vehicle)
          print("Loading Vehicle: (ID:".. result[i].id ..") => Spawning (".. veh00000.plate ..")" .. result[i].id .. " at X:".. result[i].X .."|Y:".. result[i].Y .."|Z:".. result[i].Z .."|A:".. result[i].A )
          TriggerClientEvent('loadveh', veh,result[i].X,result[i].Y,result[i].Z,result[i].A)
        end
      end
    end)
    print("")
    print("Loading Vehicles: DONE!")
    print("")
end
Citizen.CreateThread(function()
    while true do
    LoaderVeh()
    print("")
    print("Loading Vehicles:")
        Citizen.Wait(360000000) -- 3600000 msec → 1 hour
    end
end)