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:
Miner Job [main]
Miner Job [props]
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 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.
INSERT INTO `jobs` (name, label) VALUES
('miner','Miner')
;
INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
('miner',0,'novice','Novice',10,'{}','{}')
;
CREATE TABLE IF NOT EXISTS `qs_miner` (
`identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
`level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
`experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`identifier`) USING BTREE
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;
CREATE TABLE IF NOT EXISTS `qs_miner_resets` (
`identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
`last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`identifier`) USING BTREE
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;
CREATE TABLE IF NOT EXISTS `qs_miner_rewards` (
id INT AUTO_INCREMENT PRIMARY KEY,
identifier VARCHAR(255) NOT NULL,
reward_type VARCHAR(50) NOT NULL,
reward_amount INT NOT NULL
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;
CREATE TABLE IF NOT EXISTS `qs_miner_leaderboard_winners` (
id INT AUTO_INCREMENT PRIMARY KEY,
position INT NOT NULL,
identifier VARCHAR(255) NOT NULL,
reward_amount INT NOT NULL,
reward_type VARCHAR(10) NOT NULL,
UNIQUE KEY (position, reward_type)
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;CREATE TABLE IF NOT EXISTS `qs_miner` (
`identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
`level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
`experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`identifier`) USING BTREE
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;
CREATE TABLE IF NOT EXISTS `qs_miner_resets` (
`identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
`last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`identifier`) USING BTREE
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;
CREATE TABLE IF NOT EXISTS `qs_miner_rewards` (
id INT AUTO_INCREMENT PRIMARY KEY,
identifier VARCHAR(255) NOT NULL,
reward_type VARCHAR(50) NOT NULL,
reward_amount INT NOT NULL
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;
CREATE TABLE IF NOT EXISTS `qs_miner_leaderboard_winners` (
id INT AUTO_INCREMENT PRIMARY KEY,
position INT NOT NULL,
identifier VARCHAR(255) NOT NULL,
reward_amount INT NOT NULL,
reward_type VARCHAR(10) NOT NULL,
UNIQUE KEY (position, reward_type)
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;