-- 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)
for _, turf in pairs(currentTurfZones) do local distance = #(coords - vector3(turf.x, turf.y, turf.z)) if distance < 30.0 then DrawMarker(27, turf.x, turf.y, turf.z - 1, 0, 0, 0, 0, 0, 0, 2.0, 2.0, 1.0, 255, 0, 0, 100, false, true, 2, false, nil, nil, false) if distance < 2.0 then QBCore.Functions.DrawText3D(coords, '~g~[E]~w~ Claim Turf') if IsControlJustPressed(0, 38) then -- E key TriggerServerEvent('gom:claimTurf', 'Turf_' .. math.random(1000, 9999), {x = turf.x, y = turf.y, z = turf.z}) end end end end end end) gom fivem
-- Create turf marker Citizen.CreateThread(function() while true do Citizen.Wait(0) local playerPed = PlayerPedId() local coords = GetEntityCoords(playerPed) -- Periodic income from turfs Citizen
MySQL.Async.fetchAll('SELECT g.* FROM gom_gangs g JOIN gom_members m ON g.id = m.gang_id WHERE m.identifier = @identifier', { ['@identifier'] = identifier }, function(result) if result[1] then cb(result[1]) else cb(nil) end end) end) function(turfs) for _
CREATE TABLE gom_stash ( id INT PRIMARY KEY AUTO_INCREMENT, gang_id INT NOT NULL, item_name VARCHAR(50) NOT NULL, quantity INT DEFAULT 0, FOREIGN KEY ( gang_id ) REFERENCES gom_gangs ( id ) ); ( server/gom_server.lua ) local QBCore = exports['qb-core']:GetCoreObject() local gangs = {} -- Create gang RegisterNetEvent('gom:createGang') AddEventHandler('gom:createGang', function(gangName, color) local src = source local Player = QBCore.Functions.GetPlayer(src) local identifier = Player.PlayerData.citizenid