🖥️Installation Guide

Gym Script Installation Guide

This page is dedicated to installation of our gym script. Follow steps listed below to start using Gym System on your server.

Step 1: Installing the dependencies

1. ox_lib

2. oxmysql

3. ox_target / qb-target

Step 2: Setting up the Database

For our script to work, you need to modify your database. Run these SQL commands:

ESX

ALTER TABLE `users`
  ADD IF NOT EXISTS `gymEmployeePhoto` longtext DEFAULT NULL,
  ADD IF NOT EXISTS `lastActive` varchar(46) DEFAULT NULL,
  ADD IF NOT EXISTS `statistics` longtext DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `gym_business` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `data` longtext DEFAULT '{}',
  `history` longtext DEFAULT '{}',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `gym_employees_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creator` varchar(46) NOT NULL,
  `employee` varchar(46) NOT NULL,
  `title` varchar(60) NOT NULL,
  `text` longtext NOT NULL,
  `time` bigint(25) NOT NULL,
  `important` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `gym_memberships` (
  `identifier` varchar(50) DEFAULT NULL,
  `name` varchar(80) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `membership_id` varchar(15) DEFAULT NULL,
  `revoked` int(1) DEFAULT 0,
  `data` longtext DEFAULT '{}'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

QB

ALTER TABLE `players`
  ADD IF NOT EXISTS `gymEmployeePhoto` longtext DEFAULT NULL,
  ADD IF NOT EXISTS `lastActive` varchar(46) DEFAULT NULL,
  ADD IF NOT EXISTS `statistics` longtext DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `gym_business` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `data` longtext DEFAULT '{}',
  `history` longtext DEFAULT '{}',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `gym_employees_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creator` varchar(46) NOT NULL,
  `employee` varchar(46) NOT NULL,
  `title` varchar(60) NOT NULL,
  `text` longtext NOT NULL,
  `time` bigint(25) NOT NULL,
  `important` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `gym_memberships` (
  `identifier` varchar(50) DEFAULT NULL,
  `name` varchar(80) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `membership_id` varchar(15) DEFAULT NULL,
  `revoked` int(1) DEFAULT 0,
  `data` longtext DEFAULT '{}'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Qbox

ALTER TABLE `players`
  ADD IF NOT EXISTS `gymEmployeePhoto` longtext DEFAULT NULL,
  ADD IF NOT EXISTS `statistics` longtext DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `gym_business` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `data` longtext DEFAULT '{}',
  `history` longtext DEFAULT '{}',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `gym_employees_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creator` varchar(46) NOT NULL,
  `employee` varchar(46) NOT NULL,
  `title` varchar(60) NOT NULL,
  `text` longtext NOT NULL,
  `time` bigint(25) NOT NULL,
  `important` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `gym_memberships` (
  `identifier` varchar(50) DEFAULT NULL,
  `name` varchar(80) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `membership_id` varchar(15) DEFAULT NULL,
  `revoked` int(1) DEFAULT 0,
  `data` longtext DEFAULT '{}'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Step 3: Downloading the Gym Script

1. Download the bossmenu script from your Keymaster

2. Extract the files to your resources (or any other preffered) folder.

3. Add the following line to your server.cfg

ensure xnr-gym

Step 4: Configuration

1. Open the files in the configs/ folder

2. Configure the script basing on your needs.

Step 5: Start using our script

1. Save all changes

2. Restart / Start your FiveM server