Installation

1. Download resource

Download the purchased resource from keymaster - the official site of fivem with purchased resources.

2. Database

Add the required sql file to your database

1

Business Table:

If you use any of our resources that also use the vms_business table, you can skip the section Business Table

CREATE TABLE IF NOT EXISTS `vms_business` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `type` varchar(50) NOT NULL DEFAULT '',
  `owner` mediumtext DEFAULT NULL,
  `employees` longtext DEFAULT '{}',
  `stock` longtext DEFAULT '{}',
  `data` longtext DEFAULT '{}',
  `announcements` longtext DEFAULT '{}',
  `orders` longtext DEFAULT '{}',
  `history` longtext DEFAULT '{}'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

2

Statistics & Memberships

ESX

ALTER TABLE users ADD COLUMN IF NOT EXISTS statistics LONGTEXT DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `gym_memberships` (
  `owner` varchar(70) DEFAULT NULL,
  `name` varchar(80) DEFAULT NULL,
  `time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

QB-Core

ALTER TABLE players ADD COLUMN IF NOT EXISTS statistics LONGTEXT DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `gym_memberships` (
  `owner` varchar(70) DEFAULT NULL,
  `name` varchar(80) DEFAULT NULL,
  `time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

3

Items:

ESX

INSERT INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`) VALUES
    ("protein", "Protein", 10, 0, 1),
    ("runbooster", "Run-Booster", 10, 0, 1);

qb-inventory

['protein'] = {
    ["name"] = 'protein',
    ["label"] = "Protein",
    ["weight"] = 10,
    ["type"] = "item",
    ["image"] = "protein.png",
    ["unique"] = false,
    ["useable"] = true,
    ["shouldClose"] = false,
    ["combinable"] = nil,
    ["description"] = ""
},
['runbooster'] = {
    ["name"] = 'runbooster',
    ["label"] = "Run-Booster",
    ["weight"] = 10,
    ["type"] = "item",
    ["image"] = "runbooster.png",
    ["unique"] = false,
    ["useable"] = true,
    ["shouldClose"] = false,
    ["combinable"] = nil,
    ["description"] = ""
},

ox_inventory

['protein'] = {
    label = 'Protein',
    weight = 1,
    stack = true
},
['runbooster'] = {
    label = 'Run-Booster',
    weight = 1,
    stack = true
},

4

Jobs:

ESX

INSERT INTO `jobs` (name, label) VALUES
    ('gym1', 'Gym Plaza'),
    ('gym2', 'Gym Pump & Run');

INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
    ('gym1', 0, 'trainee', 'Trainee', 150, '{}', '{}'),
    ('gym1', 1, 'employee', 'Employee', 200, '{}', '{}'),
    ('gym1', 2, 'manager', 'Manager', 300, '{}', '{}'),
    ('gym1', 3, 'boss', 'Boss', 350, '{}', '{}'),
    
    ('gym2', 0, 'trainee', 'Trainee', 150, '{}', '{}'),
    ('gym2', 1, 'employee', 'Employee', 200, '{}', '{}'),
    ('gym2', 2, 'manager', 'Manager', 300, '{}', '{}'),
    ('gym2', 3, 'boss', 'Boss', 350, '{}', '{}')
;

QB-Core

['gym1'] = {
    label = 'Gym Plaza',
    defaultDuty = true,
    offDutyPay = false,
    grades = {
        ['0'] = {name = 'recruit', payment = 50},
        ['1'] = {name = 'employee', payment = 250},
        ['2'] = {name = 'manager', payment = 250},
        ['3'] = {name = 'boss', payment = 250},
    },
},
['gym2'] = {
    label = 'Gym Pump & Run',
    defaultDuty = true,
    offDutyPay = false,
    grades = {
        ['0'] = {name = 'recruit', payment = 50},
        ['1'] = {name = 'employee', payment = 250},
        ['2'] = {name = 'manager', payment = 250},
        ['3'] = {name = 'boss', payment = 250},
    },
},

3. Additional resources

Resource	Download Link
recoil - Not required but it is prepared for shooting skill	https://github.com/vames-dev/recoil