Documentation
Installation guide — please follow each step carefully and exactly as described to ensure the script works correctly on your server. Skipping or modifying steps may cause the system to not function properly, so follow it step by step.
To download the assets needed for this script, you must access the official Cfx.re portal, where all assets purchased through Tebex are managed.
Open the Cfx.re granted assets page: https://portal.cfx.re/assets/granted-assets.
This page contains all assets linked to your Cfx.re purchases.
Sign in using the same Cfx.re account you used when purchasing the asset.
If you use a different account, the assets will not appear.
In the granted assets list, locate and download:
Drugs Creator
These two packages are required to install the full housing system.
These files include the models, materials, and visual resources required for the proper operation of the housing system.
This script requires some mandatory dependencies to function correctly. Make sure to download and extract them inside your server’s main directory, keeping their original folder structure intact.
This is an optional dependency used to enable extended functionality when running with the ESX.
This is an optional dependency used to enable extended functionality when running with the QB.
This script may cause conflicts or errors if you use other drugs systems on your server.Common examples include qb-drugs, esx_drugs or other similar drugs scripts. It’s strongly recommended to remove them completely before installation to prevent compatibility or functionality issues.
This script includes an essential database required for its operation.You must import it before starting your server, preferably using HeidiSQL or any other manager compatible with MariaDB/MySQL.
ALTER TABLE
`users`
ADD
IF NOT EXISTS `inside_lab` VARCHAR(50) NULL DEFAULT NULL;
DROP TABLE IF EXISTS `drug_farm`;
CREATE TABLE `drug_farm` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(80) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`type` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`zone` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`maxCollectionCount` INT(11) NOT NULL DEFAULT '5',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_labs`;
CREATE TABLE `drug_labs` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`stash` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`wardrobe` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`shell` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`price` INT(11) NULL DEFAULT '500',
`holders` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`locked` TINYINT(2) NULL DEFAULT '0',
`level` INT(11) NULL DEFAULT '1',
`progress` INT(11) NULL DEFAULT '0',
`public` TINYINT(1) NULL DEFAULT '0',
`interior_type` VARCHAR(20) NULL DEFAULT 'shell' COLLATE 'utf8mb3_general_ci',
`mlo_data` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`zone_points` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_lab_decorations`;
CREATE TABLE `drug_lab_decorations` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`lab` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(70) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`modelName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`coords` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`rotation` TEXT NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`inStash` TINYINT(1) NOT NULL DEFAULT '0',
`created` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `id` (`id`, `lab`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_seller`;
CREATE TABLE `drug_seller` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`entry` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`model` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
`time` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`knock` TINYINT(1) NOT NULL DEFAULT '0',
`itemListId` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
CREATE TABLE IF NOT EXISTS `qs_drugs_furnitures` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NULL DEFAULT NULL,
`category_key` VARCHAR(100) NOT NULL,
`object` VARCHAR(200) NOT NULL,
`label` VARCHAR(255) NOT NULL,
`description` TEXT NULL DEFAULT NULL,
`price` INT(11) NOT NULL DEFAULT '0',
`img` TEXT NULL DEFAULT NULL,
`colorlabel` VARCHAR(255) NULL DEFAULT NULL,
`type` VARCHAR(50) NULL DEFAULT NULL,
`stash` LONGTEXT NULL DEFAULT NULL,
`offset` LONGTEXT NULL DEFAULT NULL,
`colors` LONGTEXT NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `creator` (`creator`) USING BTREE,
INDEX `category_key` (`category_key`) USING BTREE
)COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB;
ALTER TABLE `drug_labs` ADD IF NOT EXISTS `public` TINYINT(1) NULL DEFAULT '0';
ALTER TABLE `drug_labs` ADD IF NOT EXISTS `vaultCodes` TEXT NULL DEFAULT NULL;
INSERT INTO
`addon_inventory` (name, label, shared)
VALUES
('drugs', 'Drugs', 0);
INSERT INTO
`datastore` (name, label, shared)
VALUES
('drugs', 'Drugs', 0);ALTER TABLE
`players`
ADD
IF NOT EXISTS `inside_lab` VARCHAR(50) NULL DEFAULT NULL;
DROP TABLE IF EXISTS `drug_farm`;
CREATE TABLE `drug_farm` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(80) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`type` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`zone` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`maxCollectionCount` INT(11) NOT NULL DEFAULT '5',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_labs`;
CREATE TABLE `drug_labs` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`stash` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`wardrobe` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`shell` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`price` INT(11) NULL DEFAULT '500',
`holders` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`locked` TINYINT(2) NULL DEFAULT '0',
`level` INT(11) NULL DEFAULT '1',
`progress` INT(11) NULL DEFAULT '0',
`public` TINYINT(1) NULL DEFAULT '0',
`interior_type` VARCHAR(20) NULL DEFAULT 'shell' COLLATE 'utf8mb3_general_ci',
`mlo_data` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`zone_points` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_lab_decorations`;
CREATE TABLE `drug_lab_decorations` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`lab` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(70) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`modelName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`coords` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`rotation` TEXT NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`inStash` TINYINT(1) NOT NULL DEFAULT '0',
`created` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `id` (`id`, `lab`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_seller`;
CREATE TABLE `drug_seller` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`entry` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`model` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
`time` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`knock` TINYINT(1) NOT NULL DEFAULT '0',
`itemListId` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
CREATE TABLE IF NOT EXISTS `qs_drugs_furnitures` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NULL DEFAULT NULL,
`category_key` VARCHAR(100) NOT NULL,
`object` VARCHAR(200) NOT NULL,
`label` VARCHAR(255) NOT NULL,
`description` TEXT NULL DEFAULT NULL,
`price` INT(11) NOT NULL DEFAULT '0',
`img` TEXT NULL DEFAULT NULL,
`colorlabel` VARCHAR(255) NULL DEFAULT NULL,
`type` VARCHAR(50) NULL DEFAULT NULL,
`stash` LONGTEXT NULL DEFAULT NULL,
`offset` LONGTEXT NULL DEFAULT NULL,
`colors` LONGTEXT NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `creator` (`creator`) USING BTREE,
INDEX `category_key` (`category_key`) USING BTREE
)COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB;
ALTER TABLE `drug_labs` ADD IF NOT EXISTS `public` TINYINT(1) NULL DEFAULT '0';
ALTER TABLE `drug_labs` ADD IF NOT EXISTS `vaultCodes` TEXT NULL DEFAULT NULL;