server.lua

local ESX = nil

TriggerEvent('esx:getSharedObject', function(obj) ESX = obj end)

ESX.RegisterServerCallback('AnimalMapSystem:getAnimals', function(source, cb)
    local xPlayer = ESX.GetPlayerFromId(source)
    local identifier = xPlayer.identifier

    MySQL.Async.fetchAll('SELECT * FROM animals WHERE owner_id = @owner_id', {
        ['@owner_id'] = identifier
    }, function(result)
        cb(result)
    end)
end)

RegisterServerEvent('AnimalMapSystem:captureAnimal')
AddEventHandler('AnimalMapSystem:captureAnimal', function(animalPed)
    local xPlayer = ESX.GetPlayerFromId(source)
    local identifier = xPlayer.identifier
    local animalCoords = GetEntityCoords(animalPed)

    for _, animal in ipairs(Config.Animals) do
        if GetEntityModel(animalPed) == GetHashKey(animal.model) then
            MySQL.Async.execute('INSERT INTO animals (owner_id, animal_name, model, x, y, z) VALUES (@owner_id, @animal_name, @model, @x, @y, @z)', {
                ['@owner_id'] = identifier,
                ['@animal_name'] = animal.name,
                ['@model'] = animal.model,
                ['@x'] = animalCoords.x,
                ['@y'] = animalCoords.y,
                ['@z'] = animalCoords.z
            }, function(rowsChanged)
                xPlayer.addMoney(animal.captureReward)
                TriggerClientEvent('esx:showNotification', source, 'You captured a ' .. animal.name .. ' and earned $' .. animal.captureReward)
            end)
            break
        end
    end
end)