QB / ESX

Agency-Minerjob

Enhanced mining job for FiveM with multi-framework and multi-inventory auto-detection. Features 100-level skill progression with XP, dynamic economy with real-time price fluctuations, and interactive skill checks via ox_lib. Supports 6 ore types (stone, coal, silver, copper, diamond, emerald) with framework-adapted selling menus.

v1.1.0Paid3 Pages
Agency-Minerjob

01 Installation

Download and extract to resources folder
Add items to framework item configuration
Import mining_skills.sql to database
Add ensure agency-minerjob to server.cfg
Configure config.lua

Dependencies

  • ox_lib — required
  • QBCore or ESX — auto-detected
  • ox_inventory — optional
  • Agency-Notify — optional

SQL File

Import this SQL file into your database before starting the resource:

⬇ minerjob.sql
-- Mining Skills System Database Table
-- Execute this SQL query in your database to create the mining skills table

CREATE TABLE IF NOT EXISTS `player_mining_skills` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) NOT NULL,
  `level` int(11) NOT NULL DEFAULT 1,
  `xp` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `citizenid` (`citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Need help? Join our Discord community for support!

Join Discord