🛠ī¸Installation

1. Run the SQL:

CREATE TABLE IF NOT EXISTS `m_blackmarket` (
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `stock` int NOT NULL,
  `experience` int DEFAULT NULL,
  `category` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `m_blackmarket` (`name`, `price`, `label`, `stock`, `experience`, `category`) VALUES
  ('advancedlockpick', 250.00, 'Advanced Lockpick', 3, 0, 'general'),
  ('lockpick', 500.00, 'Lockpick', 1, 0, 'general'),
  ('weapon_assaultrifle', 50000.00, 'Assaultrifle', 7, 674, 'guns'),
  ('weapon_battleaxe', 25000.00, 'Battleaxe', 4, 123, 'guns'),
  ('weapon_pistol', 35000.00, 'Pistol', 4, 455, 'guns');

CREATE TABLE IF NOT EXISTS `m_blackmarket_xp` (
  `id` varchar(55) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'AUTO_INCREMENT',
  `experience` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Last updated