HELP timmer

[ismaelviac]

Hi, I'm working on a timmer that delete the vehicle if the fee is higer the 20k, but dont work u can help me this is my code

function Limit(source) MySQL.Async.fetchAll("SELECT FROM car_parking WHERE owner = @identifier AND plate = @plate", { ['@identifier'] = xPlayer.identifier, ['@plate'] = plate }, function(rs) if type(rs) == 'table' and #rs > 0 and rs[1] ~= nil then local fee = math.floor(((os.time() - rs[1].time) / 86400) Config.ParkingLocations[rs[1].parking].fee) if fee >= 20000 then MySQL.Async.execute('DELETE FROM car_parking WHERE plate = @plate AND owner = @identifier', { ["@plate"] = plate, ["@identifier"] = xPlayer.identifier}) MySQL.Async.execute('DELETE FROM owned_vehicles WHERE plate = @plate AND owner = @identifier', { ["@plate"] = plate, ["@identifier"] = xPlayer.identifier}) print(result) end end end) end

[kasuganosoras]

You should trigger the event esx_realparking:refreshVehicles after the timer delete the vehicle. Edit: Trigger the event for every client

[ismaelviac]

still dont work

[ismaelviac]

try this but dont work function Limit(source) MySQL.Async.fetchAll("SELECT FROM car_parking WHERE time < @time", { ["@time"]= math.floor((os.time()-(3086400)))}) print(result) MySQL.Async.execute('DELETE FROM car_parking WHERE plate = @plate', {["@plate"]= matricula}) MySQL.Async.execute('DELETE FROM owned_vehicles WHERE plate = @plate', {["@plate"]= matricula}) end