🛠️Installation

Database

We have one option on config to run this code automatic and you dont need to install it.

CREATE TABLE IF NOT EXISTS `m_drug_gang_stats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gang_name` varchar(50) NOT NULL,
  `total_sales` int(11) DEFAULT 0,
  `total_money` bigint(20) DEFAULT 0,
  `last_sale` timestamp NULL DEFAULT current_timestamp(),
  `gang_level` int(11) NOT NULL DEFAULT 1,
  `gang_exp` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `gang_name` (`gang_name`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE IF NOT EXISTS `m_drug_missions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `drugs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`drugs`)),
  `target` int(10) unsigned NOT NULL,
  `reward_xp` int(10) unsigned NOT NULL,
  `reward_money` int(10) unsigned NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `ended_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `m_drug_mission_progress` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `player_identifier` varchar(64) NOT NULL,
  `mission_id` int(10) unsigned NOT NULL,
  `progress` int(11) DEFAULT 0,
  `completed` tinyint(1) DEFAULT 0,
  `last_updated` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `mission_id` (`mission_id`),
  CONSTRAINT `fk_mission` FOREIGN KEY (`mission_id`) REFERENCES `m_drug_missions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `m_drug_zones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`data`)),
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

Images on UI

When you finish to create all zones you want, and the drugs allowed, please drop the same images from your inventory of the selected drugs, on folder nui/.