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.
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 script may cause conflicts or errors if you use other crafting systems on your server. Common examples include qb-crafting, or other similar crafting 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.
ESX
sql
DROPTABLE IF EXISTS `crafting_queue`;
DROPTABLE IF EXISTS `crafting_tables`;
CREATE TABLE IF NOTEXISTS `crafting_queue` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(80) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`tableId` VARCHAR(30) NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`item` VARCHAR(50) NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`amount` INT(11) NOT NULLDEFAULT'1',
`startDate` TIMESTAMPNULLDEFAULTNULL,
`duration` INT(11) NULLDEFAULTNULL,
`earn` INT(11) NULLDEFAULT'0',
PRIMARY KEY (`id`) USING BTREE,
INDEX `owner_tableId` (`owner`, `tableId`) USING BTREE
)
COLLATE='utf8mb3_general_ci';
CREATE TABLE IF NOTEXISTS `crafting_tables` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`label` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`size` SMALLINT(6) NOT NULLDEFAULT'0',
`jobs` LONGTEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`gangs` LONGTEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`object` VARCHAR(50) NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`coords` LONGTEXT NOT NULLCOLLATE'utf8mb3_general_ci',
`recipes` LONGTEXT NOT NULLCOLLATE'utf8mb4_bin',
`blip` LONGTEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`global` TINYINT(1) NULLDEFAULTNULL,
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci';
ALTER TABLE `users` ADD IF NOTEXISTS `crafting_skill` LONGTEXT NULLDEFAULTNULL;
ALTER TABLE `crafting_tables` ADD IF NOTEXISTS `jobs` LONGTEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci';
ALTER TABLE `crafting_tables` ADD IF NOTEXISTS `gangs` LONGTEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci';
QB
sql
DROPTABLE IF EXISTS `crafting_queue`;
DROPTABLE IF EXISTS `crafting_tables`;
CREATE TABLE IF NOTEXISTS `crafting_queue` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(80) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`tableId` VARCHAR(30) NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`item` VARCHAR(50) NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`amount` INT(11) NOT NULLDEFAULT'1',
`startDate` TIMESTAMPNULLDEFAULTNULL,
`duration` INT(11) NULLDEFAULTNULL,
`earn` INT(11) NULLDEFAULT'0',
PRIMARY KEY (`id`) USING BTREE,
INDEX `owner_tableId` (`owner`, `tableId`) USING BTREE
)
COLLATE='utf8mb3_general_ci';
CREATE TABLE IF NOTEXISTS `crafting_tables` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`label` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`size` SMALLINT(6) NOT NULLDEFAULT'0',
`job` VARCHAR(30) NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`grades` LONGTEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`gang` VARCHAR(30) NULLDEFAULTNULL,
`gangGrades` LONGTEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`object` VARCHAR(50) NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`coords` LONGTEXT NOT NULLCOLLATE'utf8mb3_general_ci',
`recipes` LONGTEXT NOT NULLCOLLATE'utf8mb4_bin',
`blip` LONGTEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`global` TINYINT(1) NULLDEFAULTNULL,
`showWeaponsTab` TINYINT(1) NOT NULLDEFAULT'1',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci';
ALTER TABLE `players` ADD IF NOTEXISTS `crafting_skill` LONGTEXT NULLDEFAULTNULL;
ALTER TABLE `crafting_tables` ADD IF NOTEXISTS `jobs` LONGTEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci';
ALTER TABLE `crafting_tables` ADD IF NOTEXISTS `gangs` LONGTEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci';
ALTER TABLE `crafting_tables` ADD IF NOTEXISTS `showWeaponsTab` TINYINT(1) NOT NULLDEFAULT'1';