server.lua

local ESX = nil

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

ESX.RegisterServerCallback('adoptme:getPlayerPets', function(source, cb)
    local xPlayer = ESX.GetPlayerFromId(source)
    MySQL.Async.fetchAll('SELECT * FROM adoptme_pets WHERE owner = @owner', {
        ['@owner'] = xPlayer.identifier
    }, function(result)
        cb(result)
    end)
end)

RegisterNetEvent('adoptme:buyPet')
AddEventHandler('adoptme:buyPet', function(petModel)
    local xPlayer = ESX.GetPlayerFromId(source)
    local petPrice = 0
    for _, pet in ipairs(Config.Pets) do
        if pet.model == petModel then
            petPrice = pet.price
            break
        end
    end
    
    if xPlayer.getMoney() >= petPrice then
        xPlayer.removeMoney(petPrice)
        MySQL.Async.execute('INSERT INTO adoptme_pets (owner, pet_name, pet_model) VALUES (@owner, @pet_name, @pet_model)', {
            ['@owner'] = xPlayer.identifier,
            ['@pet_name'] = 'Pet',
            ['@pet_model'] = petModel
        }, function(rowsChanged)
            TriggerClientEvent('adoptme:spawnPet', source, petModel)
        end)
    else
        TriggerClientEvent('esx:showNotification', source, 'You do not have enough money!')
    end
end)

RegisterNetEvent('adoptme:tradePet')
AddEventHandler('adoptme:tradePet', function(targetId, petId)
    local xPlayer = ESX.GetPlayerFromId(source)
    local xTarget = ESX.GetPlayerFromId(targetId)
    
    MySQL.Async.fetchScalar('SELECT COUNT(*) FROM adoptme_pets WHERE id = @id AND owner = @owner', {
        ['@id'] = petId,
        ['@owner'] = xPlayer.identifier
    }, function(count)
        if count > 0 then
            MySQL.Async.execute('UPDATE adoptme_pets SET owner = @new_owner WHERE id = @id', {
                ['@new_owner'] = xTarget.identifier,
                ['@id'] = petId
            }, function(rowsChanged)
                TriggerClientEvent('esx:showNotification', source, 'Pet traded successfully!')
                TriggerClientEvent('esx:showNotification', targetId, 'You received a pet!')
            end)
        else
            TriggerClientEvent('esx:showNotification', source, 'You do not own this pet!')
        end
    end)
end)