DbQuery - Help Me

[Ionel]

Hello, I want to ask you how I can adopt this script from dbQuery to mysql.

 

local gas_stations = {}
local db = exports.mysql:getConnection()
local mysql = exports.mysql

addEventHandler("onResourceStart", resourceRoot, function()
  dbQuery(function(qh)
    local result = dbPoll(qh, -1)
    if result and #result > 0 then
      for _, v in ipairs(result) do
        gas_stations[tostring(v.id)] = {}
        gas_stations[tostring(v.id)].pos = {x = v.x, y = v.y, z = v.z, int = v.interior, dim = v.dimension}
        gas_stations[tostring(v.id)].status = {owner = v.owner, price = tonumber(v.price), stock = tonumber(v.stock), id = tonumber(v.id), fuelPrice = tonumber(v.fuelPrice), money = tonumber(v.money)}
        gas_stations[tostring(v.id)].colshape = createColSphere(v.x, v.y, v.z, 10)
        gas_stations[tostring(v.id)].pickup = createPickup(v.x, v.y, v.z, 3, 1239)
      end

      triggerClientEvent("gas:fetchGasStations", root, gas_stations)
    end
  end, {}, db, "SELECT * FROM `gas_stations` WHERE `deleted`='0' ORDER BY `id` ASC")
end)

addEvent("gas:getGasStations", true)
addEventHandler("gas:getGasStations", root, function()
  triggerClientEvent("gas:fetchGasStations", root, gas_stations)
end)

addCommandHandler("makegas", function(thePlayer, command, price)
  if not exports.integration:isPlayerLeadAdmin(thePlayer) then return exports.fuel_notifications:addNotification(thePlayer, "error", "Nu ai acces la aceasta comanda!") end
  if not tonumber(price) then return outputChatBox("SYNTAX: /" .. command .. " [Pret]", thePlayer, 255, 194, 14) end

  local x, y, z = getElementPosition(thePlayer)
  local interior, dimension = getElementInterior(thePlayer), getElementDimension(thePlayer)
  dbQuery(function(qh, thePlayer)
    local result, numRows, lastID = dbPoll(qh, -1)
    if numRows > 0 then
      outputChatBox("A fost creata o noua benzinarie. ID: " .. lastID .. "!", thePlayer, 255, 194, 14)

      gas_stations[tostring(lastID)] = {}
      gas_stations[tostring(lastID)].pos = {x = x, y = y, z = z, int = interior, dim = dimension}
      gas_stations[tostring(lastID)].status = {owner = -1, price = tonumber(price), stock = 0, id = lastID, money = 0, fuelPrice = 4}
      gas_stations[tostring(lastID)].colshape = createColSphere(x, y, z, 10)
      gas_stations[tostring(lastID)].pickup = createPickup(x, y, z, 3, 1239)

      triggerClientEvent("gas:fetchGasStations", thePlayer, gas_stations)
    end
  end, {thePlayer}, db, "INSERT INTO `gas_stations` (`x`, `y`, `z`, `interior`, `dimension`, `stock`, `owner`, `price`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", x, y, z, interior, dimension, 0, -1, price)
end)

--comanda de fill
function refillCommand(thePlayer, command, amount)
  local money = 0
  local gasStation = nil
  for _, gs in pairs(gas_stations) do
    if isElementWithinColShape(thePlayer, gs.colshape) then
      gasStation = gs
      break
    end
  end

  if not gasStation then
    return exports.fuel_notifications:addNotification(thePlayer, "error", "Trebuie să te aflii într-o benzinărie.")
  end

  if not tonumber(amount) then
    return outputChatBox("SYNTAX: /" .. command .. " [Sumă ($) | 0 = plin]", thePlayer, 255, 194, 17)
  end

    local posX, posY, posZ = getElementPosition(thePlayer)

    local theVehicle = getPedOccupiedVehicle(thePlayer)

    if (getVehicleEngineState(theVehicle) == true) then
        exports.fuel_notifications:addNotification(thePlayer, "error", "Nu poti face plinul la masina cu motorul pornit.")
        return
    end

    if not (isPedInVehicle(thePlayer) == true) then
        exports.fuel_notifications:addNotification(thePlayer, "error", "Trebuie sa te aflii intr-un vehicul.")
        return
    end

    local theLitres = calculateFuelPrice(thePlayer, amount, 1, tonumber(gasStation.status.fuelPrice))
  if tonumber(amount) == 0 then
    theLitres = calculateFuelPrice(thePlayer, 99999999, 1, tonumber(gasStation.status.fuelPrice))
  end

  if tonumber(gasStation.status.owner) ~= -1 then
    if tonumber(gasStation.status.stock) < theLitres then
      return exports.fuel_notifications:addNotification(thePlayer, "error", "Această benzinărie nu are destul combustibil.")
    end
  end

    local fuelCost = theLitres*tonumber(gasStation.status.fuelPrice)

    money = exports.global:getMoney(thePlayer)
    local factionPlayer = getElementData(thePlayer, "faction")
    local factionVehicle = getElementData(theVehicle, "faction")

    local factionPaid = false
    if factionPlayer == factionVehicle and factionsThatPayForFuel[factionPlayer] and factionsThatPayForFuel[factionVehicle] then
        local theTeam = getPlayerTeam(thePlayer)
        if exports.global:takeMoney(theTeam, fuelCost, true) then
            exports.fuel_notifications:addNotification(thePlayer, "info", "Angajatorul dvs. plateste pentru plin.")
            mysql:query_free("INSERT INTO wiretransfers (`from`, `to`, `amount`, `reason`, `type`) VALUES (" .. mysql:escape_string(( -getElementData( theTeam, "id" ) )) .. ", " .. mysql:escape_string(getElementData(thePlayer, "dbid")) .. ", " .. mysql:escape_string(fuelCost) .. ", '"..mysql:escape_string(theLitres).."', 9)" )

            factionPaid = true
        end
    end

    if not factionPaid then
        if (fuelCost > 0 and money > 0) then
            if not exports.donators:hasPlayerPerk(thePlayer, 7) then
        if not exports.global:takeMoney(thePlayer, fuelCost) then
          exports.fuel_notifications:addNotification(thePlayer, "error", "Nu ai destui bani la tine.")
          return
        end
            end
        else
            exports.fuel_notifications:addNotification(thePlayer, "error", "Rezervorul dvs. este plin.")
            return
        end
    end

    local loldFuel = getElementData(theVehicle, "fuel")
    local newFuel = loldFuel+theLitres
    exports.anticheat:changeProtectedElementDataEx(theVehicle, "fuel", newFuel, false)
    triggerClientEvent(thePlayer, "syncFuel", theVehicle, newFuel)

    local info = {
            {"Chitanță benzinărie"},
            {""},
        }

    if exports.donators:hasPlayerPerk(thePlayer, 7) and not factionPaid then
        table.insert(info, {"    " .. math.ceil(theLitres) .. " litrii de combustibil    - (( Gratuit ))"})
    else
        table.insert(info, {"    " .. math.ceil(theLitres) .. " litrii de combustibil    -    " .. fuelCost .. "$"})
        if factionPaid then
            table.insert(info, {"    Plătit de angajator "..tostring(exports.factions:getFactionName(factionPlayer))})
        end
    end
    table.insert(info, {"    "..exports.global:getVehicleName(theVehicle).." - "..exports.global:round(newFuel, 2).."/"..exports.global:round(getMaxFuel(theVehicle), 2).." litres"})
    triggerClientEvent(thePlayer, "hudOverlay:drawOverlayTopRight", thePlayer, info )

  --ia stock-ul din benzinarie
  local newStock = tonumber(gasStation.status.stock) - theLitres
  local newMoney = 0
  if tonumber(gasStation.status.owner) ~= -1 then
    newMoney = tonumber(gasStation.status.money) + fuelCost
  end
  if newStock < 0 then newStock = 0 end

  gasStation.status.stock = newStock
  gasStation.status.money = newMoney

  triggerClientEvent("gas:fetchOneGasStation", root, gasStation.status.id, gasStation)
  dbQuery(function(qh)

    dbFree(qh)
    return true
  end, {}, db, "UPDATE `gas_stations` SET `stock`=?, `money`=? WHERE `id`=?", newStock, newMoney, gasStation.status.id)
end
addCommandHandler("refill", refillCommand)

--cumpara benzinaria
addEvent("gas:buyGasStation", true)
addEventHandler("gas:buyGasStation", root, function(gasStation)
  if not exports.global:hasMoney(client, tonumber(gasStation.status.price)) then return false end
  exports.global:takeMoney(client, tonumber(gasStation.status.price))

  dbQuery(function(qh, player, gasStation)
    local result, numRows, lastID = dbPoll(qh, -1)
    if numRows > 0 then
      if gasStation.status.owner > 0 then
        for _, p in ipairs(getElementsByType("player")) do
          if getElementData(p, "dbid") == tonumber(gasStation.status.owner) then
            setElementData(p, "bankmoney", (getElementData(p, "bankmoney") or 0) + gasStation.status.price)
          end
        end

        local updateBankMoney = exports.mysql:query_free("UPDATE `characters` SET `bankmoney`=`bankmoney` + '" .. gasStation.status.price .."' WHERE `id`='" .. gasStation.status.owner .."'")
      end

      exports.fuel_notifications:addNotification(player, "succes", "Ai cumpărat această benzinărie cu succes!")
      local gasStationID = tostring(gasStation.status.id)
      local gasStation = gas_stations[gasStationID]
      --reloadOneGasStation(tonumber(gasStation.status.id))
      gasStation.status.owner = getElementData(player, "dbid")
      gasStation.status.price = 0
      gasStation.status.stock = 50

      triggerClientEvent("gas:fetchOneGasStation", root, gasStation.status.id, gasStation)
    end
    dbFree(qh)
  end, {client, gasStation}, db, "UPDATE `gas_stations` SET `owner`=?, `price`=?, `stock`=? WHERE `id`=?", getElementData(client, "dbid"), 0, 50, tonumber(gasStation.status.id))
end)

--reload la o benzinarie doar
function reloadOneGasStation(gasID)
  if not gas_stations[tostring(gasID)] then return false end

  destroyElement(gas_stations[tostring(gasID)].colshape)
  destroyElement(gas_stations[tostring(gasID)].pickup)
  gas_stations[tostring(gasID)] = nil

  loadOneGasStation(tonumber(gasID))
end

function loadOneGasStation(gasID)
  dbQuery(function(qh)
    local result = dbPoll(qh, -1)
    if result and #result > 0 then
      local gasData = result[1]
      gas_stations[tostring(gasData.id)] = {}
      gas_stations[tostring(gasData.id)].pos = {x = gasData.x, y = gasData.y, z = gasData.z, int = gasData.interior, dim = gasData.dimension}
      gas_stations[tostring(gasData.id)].status = {owner = gasData.owner, price = tonumber(gasData.price), stock = tonumber(gasData.stock), id = tonumber(gasData.id), money = tonumber(gasData.money), fuelPrice = tonumber(gasData.fuelPrice)}
      gas_stations[tostring(gasData.id)].colshape = createColSphere(gasData.x, gasData.y, gasData.z, 10)
      gas_stations[tostring(gasData.id)].pickup = createPickup(gasData.x, gasData.y, gasData.z, 3, 1239)
    end

    triggerClientEvent("gas:fetchGasStations", root, gas_stations)
    dbFree(qh)
  end, {}, db, "SELECT * FROM `gas_stations` WHERE `id`=?", tonumber(gasID))
end

--update la pret benzina
addEvent("gas:updateFuelPrice", true)
addEventHandler("gas:updateFuelPrice", root, function(gasStation, price)
  dbQuery(function(qh, player, gasStation)
    local result, numRows, lastID = dbPoll(qh, -1)
    if numRows > 0 then
      exports.fuel_notifications:addNotification(player, "succes", "Ai setat prețul la benzină cu succes!")
      local gasStationID = tostring(gasStation.status.id)
      local gasStation = gas_stations[gasStationID]
      --reloadOneGasStation(tonumber(gasStation.status.id))
      gasStation.status.fuelPrice = tonumber(price)

      triggerClientEvent("gas:fetchOneGasStation", root, gasStation.status.id, gasStation)
    end
    dbFree(qh)
  end, {client, gasStation}, db, "UPDATE `gas_stations` SET `fuelPrice`=? WHERE `id`=?", price, tonumber(gasStation.status.id))
end)

addEvent("gas:withdrawMoney", true)
addEventHandler("gas:withdrawMoney", root, function(gasStation, amount)
  dbQuery(function(qh, player, gasStation)
    local result, numRows, lastID = dbPoll(qh, -1)
    if numRows > 0 then
      exports.fuel_notifications:addNotification(player, "succes", "Ai scos banii cu succes din seif!")
      local gasStationID = tostring(gasStation.status.id)
      local gasStation = gas_stations[gasStationID]
      --reloadOneGasStation(tonumber(gasStation.status.id))
      exports.global:giveMoney(player, amount)
      gasStation.status.money = gasStation.status.money - tonumber(amount)

      triggerClientEvent("gas:fetchOneGasStation", root, gasStation.status.id, gasStation)
    end
    dbFree(qh)
  end, {client, gasStation}, db, "UPDATE `gas_stations` SET `money`=? WHERE `id`=?", gasStation.status.money - tonumber(amount), tonumber(gasStation.status.id))
end)

addEvent("gas:setSellPrice", true)
addEventHandler("gas:setSellPrice", root, function(gasStation, price)
  dbQuery(function(qh, player, gasStation)
    local result, numRows, lastID = dbPoll(qh, -1)
    if numRows > 0 then
      exports.fuel_notifications:addNotification(player, "succes", "Ai scos la vânzare benzinăria cu succes!")
      local gasStationID = tostring(gasStation.status.id)
      local gasStation = gas_stations[gasStationID]
      gasStation.status.price = tonumber(price)

      triggerClientEvent("gas:fetchOneGasStation", root, gasStation.status.id, gasStation)
    end
    dbFree(qh)
  end, {client, gasStation}, db, "UPDATE `gas_stations` SET `price`=? WHERE `id`=?", tonumber(price), tonumber(gasStation.status.id))
end)

addEvent("gas:updateGasStationStock", true)
addEventHandler("gas:updateGasStationStock", root, function(gasStationID, stockAmount, orderID)
  local newStock = gas_stations[tostring(gasStationID)].status.stock + tonumber(stockAmount)

  dbQuery(function(qh, player, newStock, gasStationID)
    local result, numRows, lastID = dbPoll(qh, -1)
    if numRows > 0 then

      local gasStation = gas_stations[tostring(gasStationID)]
      gasStation.status.stock = tonumber(newStock)

      triggerClientEvent("gas:fetchOneGasStation", root, gasStation.status.id, gasStation)
    end
    dbFree(qh)
  end, {client, newStock, gasStationID}, db, "UPDATE `gas_stations` SET `stock`=? WHERE `id`=?", tonumber(newStock), tonumber(gasStationID))
end)

addEvent("gas:buyStock", true)
addEventHandler("gas:buyStock", root, function(gasStation, stock)
  exports.fuel_notifications:addNotification(client, "succes", "Ai dat comandă de combustibil cu succes!")

  --reloadOneGasStation(tonumber(gasStation.status.id))
  exports.global:takeMoney(client, stock * 4)
  dbQuery(function(qh)
    dbFree(qh)
  end, {}, db, "INSERT INTO `stock_orders` (`biz_id`, `biz_type`, `stock_amount`, `x`, `y`, `z`, `trailer`) VALUES (?, ?, ?, ?, ?, ?, ?)", tonumber(gasStation.status.id), 1, tonumber(stock), gasStation.pos.x, gasStation.pos.y, gasStation.pos.z, 584)

  triggerClientEvent("gas:fetchOneGasStation", root, gasStation.status.id, gasStation)
end)

--fetch benzinarii
addEvent("gas:fetchGasStations", true)
addEventHandler("gas:fetchGasStations", root, function(temp_table)
  gas_stations = temp_table
end)

--opreste jucatorul din a lua pickup-ul lol
function serverPickupHit(matchingDimension)
    for _, pickup in pairs(gas_stations) do
      if pickup.pickup == source then
        cancelEvent()

        break
      end
    end
end
addEventHandler("onPickupHit", root, serverPickupHit)

--refillgs
function pedWillFillFuelCan(thePlayer, command)
    if not (thePlayer and isElement(thePlayer)) then
        return
    end

  local gasStation = nil
  for _, gs in pairs(gas_stations) do
    if isElementWithinColShape(thePlayer, gs.colshape) then
      gasStation = gs
      break
    end
  end

  if not gasStation then 
    return exports.fuel_notifications:addNotification(thePlayer, "error", "Nu te aflii intr-o benzinarie!")
  end

    local hasItem, itemSlot, itemValue, itemUniqueID = exports.global:hasItem(thePlayer, 57)
    if not (hasItem) then
        exports.fuel_notifications:addNotification(thePlayer, "error", "Nu ai o canistra la tine.")
        return
    end

    if itemValue >= 10 then
        exports.fuel_notifications:addNotification(thePlayer, "error", "Este deja plina.")
        return
    end

    local theLitres = 10 - itemValue
    local fuelCost = math.floor(theLitres * tonumber(gasStation.status.fuelPrice))

    local money = exports.global:getMoney(thePlayer)
    if tonumber(money) == 0 then
        exports.fuel_notifications:addNotification(thePlayer, "error", "Nu ai destui bani la tine.")
        return
    else
        if not exports.global:takeMoney(thePlayer, fuelCost) then
      exports.fuel_notifications:addNotification(thePlayer, "error", "Nu ai destui bani la tine - " .. fuelCost .. "$!")
            return
        end
    end

    if not (exports['item-system']:updateItemValue(thePlayer, itemSlot, itemValue + theLitres)) then
        exports.fuel_notifications:addNotification(thePlayer, "error", "Ups.. ceva nu a mers bine.")
        return
    end

    local info = {
            {"Gas Station Receipt"},
            {""},
            {"    " .. math.ceil(theLitres) .. " Litrii de combustibil    -    " .. fuelCost .. "$"},
        }
    triggerClientEvent(thePlayer, "hudOverlay:drawOverlayTopRight", thePlayer, info )
end
addCommandHandler("refillgs", pedWillFillFuelCan)

[FLUSHBICEPS]

you will need to modify the script to use the dbExec function instead of dbQuery.

[Ionel]

How can I do this. Can you help me modify it?