Installation

Quasar Fisher Job turns fishing into a fun, profitable, and fully immersive activity for your FiveM server. Catch unique fish, sell your haul, upgrade your gear, and enjoy a dynamic coastal experience that fits both casual and economy-focused servers.

---

Download Script

To download the assets needed for this script, you must access the official Cfx.re portal, where all assets purchased through Tebex are managed.

1. Go to the following link: 🔗 https://portal.cfx.re/assets/granted-assets

2. Log in with the same Cfx.re account you used to make the purchase.

3. In the list of granted assets, find and download the following:

• Fishing Job

---

Download Dependencies

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.

Releases · overextended/oxmysqlGitHub

Release v3.30.6 · overextended/ox_libGitHub

---

Server.cfg Placement

This script must always start after es_extended or qb-core, never before. We recommend placing it below in your server.cfg, ensuring that all its dependencies are started first to prevent errors or unexpected behavior.

---

Database Setup

Avoid using tools like XAMPP or other non-optimized local servers, as they may cause connection errors.

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

INSERT INTO `jobs` (name, label) VALUES
    ('fisher','Fisher')
;

INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
    ('fisher',0,'novice','Novice',10,'{}','{}')
;

CREATE TABLE IF NOT EXISTS `qs_fisher` (
    `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_fisher_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_fisher_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_fisher_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'
;

QBCORE

CREATE TABLE IF NOT EXISTS `qs_fisher` (
    `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_fisher_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_fisher_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_fisher_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'
;