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 );
CREATE TABLE gom_turfs ( id INT PRIMARY KEY AUTO_INCREMENT, gang_id INT NOT NULL, zone_name VARCHAR(50) NOT NULL, coords_x FLOAT NOT NULL, coords_y FLOAT NOT NULL, coords_z FLOAT NOT NULL, income_rate INT DEFAULT 500, FOREIGN KEY ( gang_id ) REFERENCES gom_gangs ( id ) ); gom fivem
files { 'html/ .html', 'html/ .css', 'html/*.js' } `name` VARCHAR(50) UNIQUE NOT NULL
-- 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) `leader` VARCHAR(50) NOT NULL
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)