Installation

Download resource

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

Remove current society

Remove esx_society / qb-management from your server

Database

Add the required sql file to your database

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;

Last updated

Was this helpful?