-- Periodic income from turfs Citizen.CreateThread(function() while true do Citizen.Wait(1800000) -- Every 30 minutes MySQL.Async.fetchAll('SELECT * FROM gom_turfs', {}, function(turfs) for _, turf in pairs(turfs) do MySQL.Async.execute('UPDATE gom_gangs SET money = money + @income WHERE id = @gang_id', { ['@income'] = turf.income_rate, ['@gang_id'] = turf.gang_id }) end end) end end) ( client/gom_client.lua ) local QBCore = exports['qb-core']:GetCoreObject() local playerGang = nil local currentTurfZones = {} -- Get player gang on spawn RegisterNetEvent('QBCore:Client:OnPlayerLoaded') AddEventHandler('QBCore:Client:OnPlayerLoaded', function() QBCore.Functions.TriggerCallback('gom:getPlayerGang', function(gang) playerGang = gang end) end)

server_scripts { '@mysql-async/lib/MySQL.lua', 'server/*.lua' }

-- Gang stash UI RegisterNetCommand('gangstash', function() if playerGang then SendNUIMessage({ action = 'openStash', gangName = playerGang.name, money = playerGang.money }) SetNuiFocus(true, true) else QBCore.Functions.Notify('You are not in a gang!', 'error') end end)

MySQL.Async.insert('INSERT INTO gom_gangs (name, leader, color) VALUES (@name, @leader, @color)', { ['@name'] = gangName, ['@leader'] = identifier, ['@color'] = color }, function(id) MySQL.Async.insert('INSERT INTO gom_members (gang_id, identifier, rank) VALUES (@gang_id, @identifier, @rank)', { ['@gang_id'] = id, ['@identifier'] = identifier, ['@rank'] = 'leader' }) TriggerClientEvent('QBCore:Notify', src, 'Gang created!', 'success') end) end)