Download the purchased resource from CFX Portal - the official site of FiveM with purchased resources.
2. Import Database Tables
This is a very important step - without it, the script will not work properly.
Depending on the framework you are using (ESX or QB-Core), select the appropriate section below and paste the SQL code into your database.
Not sure how to do it?
No worries - we've prepared a short guide that shows you step by step how to import an SQL file into your database:
👉 Click here to view the tutorial.
Database for ESX
ALTER TABLE `users` ADD COLUMN `badge` longtext DEFAULT '[]';
CREATE TABLE IF NOT EXISTS `bossmenu` (
`job` varchar(100) NOT NULL,
`account_name` varchar(50) DEFAULT NULL,
`type` varchar(50) DEFAULT 'job',
`balance` int(15) DEFAULT 0,
`data` longtext DEFAULT '[]',
`announcements` longtext DEFAULT '[]',
PRIMARY KEY (`job`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `bossmenu_outfits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`job` varchar(50) DEFAULT NULL,
`grades` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`gender` tinyint(4) DEFAULT NULL,
`outfit` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `bossmenu_permissions` (
`job` varchar(50) DEFAULT NULL,
`grade` int(11) DEFAULT NULL,
`permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `bossmenu_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) DEFAULT NULL,
`executor` varchar(100) DEFAULT NULL,
`executor_identifier` varchar(100) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL,
`amount` int(11) DEFAULT NULL,
`title` longtext DEFAULT NULL,
`date` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Database for QB-Core
ALTER TABLE `players` ADD COLUMN `badge` longtext DEFAULT '[]';
CREATE TABLE IF NOT EXISTS `bossmenu` (
`job` varchar(100) NOT NULL,
`account_name` varchar(50) DEFAULT NULL,
`type` varchar(50) DEFAULT 'job',
`balance` int(15) DEFAULT 0,
`data` longtext DEFAULT '[]',
`announcements` longtext DEFAULT '[]',
PRIMARY KEY (`job`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `bossmenu_outfits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`job` varchar(50) DEFAULT NULL,
`grades` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`gender` tinyint(4) DEFAULT NULL,
`outfit` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `bossmenu_permissions` (
`job` varchar(50) DEFAULT NULL,
`grade` int(11) DEFAULT NULL,
`permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `bossmenu_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) DEFAULT NULL,
`executor` varchar(100) DEFAULT NULL,
`executor_identifier` varchar(100) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL,
`amount` int(11) DEFAULT NULL,
`title` longtext DEFAULT NULL,
`date` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
3. Environment Requirements
1
Remove Old Management Systems
Remove esx_society / qb-management from your server.
To start a resource in your server.cfg, ensure that it begins after your framework has been initiated. For instance, if you are using a framework like es_extended, you should start resource after it, like so:
start [core] # For example, here is your framework (esx/qb-core)
# Here you run your other resources like esx_policejob etc.
# VMS Resources
start vms_bossmenu # start vms_bossmenu as last resource in your server.cfg
Ensure there are no syntax errors or incorrect paths in your server.cfg.