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)
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)
-- Stash system RegisterNetEvent('gom:storeItem') AddEventHandler('gom:storeItem', function(itemName, quantity) local src = source exports['gom']:getPlayerGang(src, function(gang) if gang then MySQL.Async.fetchAll('SELECT * FROM gom_stash WHERE gang_id = @gang_id AND item_name = @item', { ['@gang_id'] = gang.id, ['@item'] = itemName }, function(result) if result[1] then MySQL.Async.execute('UPDATE gom_stash SET quantity = quantity + @q WHERE id = @id', { ['@q'] = quantity, ['@id'] = result[1].id }) else MySQL.Async.insert('INSERT INTO gom_stash (gang_id, item_name, quantity) VALUES (@gang_id, @item, @q)', { ['@gang_id'] = gang.id, ['@item'] = itemName, ['@q'] = quantity }) end TriggerClientEvent('QBCore:Notify', src, 'Item stored in gang stash', 'success') end) end end) end)
exports['gom']:getPlayerGang(src, function(gang) if gang then MySQL.Async.insert('INSERT INTO gom_turfs (gang_id, zone_name, coords_x, coords_y, coords_z) VALUES (@gang_id, @zone, @x, @y, @z)', { ['@gang_id'] = gang.id, ['@zone'] = zoneName, ['@x'] = coords.x, ['@y'] = coords.y, ['@z'] = coords.z }) TriggerClientEvent('QBCore:Notify', src, 'Turf claimed!', 'success') end end) end)
-- NUI Callbacks RegisterNUICallback('closeStash', function(data, cb) SetNuiFocus(false, false) cb('ok') end)
-- 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)
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)
1. Database Setup ( gom.sql ) CREATE TABLE `gom_gangs` ( `id` INT PRIMARY KEY AUTO_INCREMENT, `name` VARCHAR(50) UNIQUE NOT NULL, `leader` VARCHAR(50) NOT NULL, `color` VARCHAR(7) DEFAULT '#FF0000', `money` INT DEFAULT 0, `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE gom_members ( id INT PRIMARY KEY AUTO_INCREMENT, gang_id INT NOT NULL, identifier VARCHAR(50) NOT NULL, rank VARCHAR(20) DEFAULT 'member', joined_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY ( gang_id ) REFERENCES gom_gangs ( id ) ON DELETE CASCADE );
window.addEventListener('message', function(event) { if (event.data.action === 'openStash') { document.getElementById('gangName').innerText = event.data.gangName; document.getElementById('gangMoney').innerText = event.data.money; // Load items dynamically } }); </script> </body> </html> ( fxmanifest.lua ) fx_version 'cerulean' game 'gta5' author 'Your Name' description 'GOM Gang System for FiveM' version '1.0.0'
client_scripts { 'client/*.lua' }
RegisterNUICallback('withdrawItem', function(data, cb) TriggerServerEvent('gom:withdrawItem', data.item, data.quantity) cb('ok') end)
-- Load turf zones from server QBCore.Functions.TriggerCallback('gom:getTurfs', function(turfs) currentTurfZones = turfs end) ( html/stash.html ) <!DOCTYPE html> <html> <head> <style> body { margin: 0; padding: 0; font-family: 'Arial', sans-serif; background: transparent; } .stash-container { position: absolute; top: 50%; left: 50%; transform: translate(-50%, -50%); width: 500px; background: rgba(0, 0, 0, 0.9); border-radius: 10px; padding: 20px; color: white; border: 2px solid #ff0000; } .stash-header { text-align: center; font-size: 24px; margin-bottom: 20px; color: #ff0000; } .stash-item { display: flex; justify-content: space-between; padding: 10px; margin: 5px 0; background: rgba(255, 255, 255, 0.1); border-radius: 5px; } .stash-item button { background: #ff0000; border: none; color: white; padding: 5px 10px; cursor: pointer; } .close-btn { position: absolute; top: 10px; right: 10px; background: red; border: none; color: white; cursor: pointer; padding: 5px 10px; } </style> </head> <body> <div class="stash-container"> <button class="close-btn" onclick="closeStash()">X</button> <div class="stash-header">🏢 Gang Stash - <span id="gangName"></span></div> <div>💰 Gang Money: $<span id="gangMoney"></span></div> <div id="stashItems"></div> </div> <script> function closeStash() { fetch('https://gom/closeStash', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({}) }); }
-- 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)