Setup and Item

This page covers the setup parts you should finish before touching scenarios: dependencies, server.cfg order, database behavior, localization, streamed assets, and required items.

How to Download: Tutorial Video

---

Required Dependencies

Scriptname	Download Link
oxmysql	Click to Download
ox_lib	Click to Download
qua_fishingpiers_0r	When you purchase the script, it will be delivered to your CFX account

The script supports only the qbox, qb-core, and es_extended frameworks.

---

Recommended server.cfg Start Order

server.cfg

ensure oxmysql
ensure ox_lib
ensure [framework] -- es_extended, qb-core, or qbx_core

--------------------------------
-- Start Your Other Resources --
--------------------------------

ensure qua_fishingpiers_0r -- Map
ensure 0r-fishingv2 -- Script

---

Setup Database Tables

0r-fishingv2/INSTALL/insert-me.sql

CREATE TABLE IF NOT EXISTS `0r_fishingv2` (
    `identifier` varchar(255) NOT NULL,
    `firstname` varchar(255) NOT NULL DEFAULT '',
    `lastname` varchar(255) NOT NULL DEFAULT '',
    `xp` int(11) NOT NULL DEFAULT 0,
    `is_rod_crafted` tinyint(1) NOT NULL DEFAULT 0,
    UNIQUE KEY `identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

You don’t need to run the SQL file manually for this script; the SQL tables are automatically checked at the start of the script, and if any tables are missing, they are automatically recreated. However, if you encounter an error and the SQL tables cannot be created, you can run this code to create the SQL tables manually.

---

Change the Language

If you don't know how to write a script, you can check out this page.

Editing localization files

---

Add items to your server

QBCore

qb-core/shared/items.lua

--- Start 0R Fishing v2 Item List ---
['bass'] = { name = 'bass', label = 'Bass', weight = 100, type = 'item', image = 'bass.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['bluegill'] = { name = 'bluegill', label = 'Bluegill', weight = 100, type = 'item', image = 'bluegill.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['common_carp'] = { name = 'common_carp', label = 'Common Carp', weight = 100, type = 'item', image = 'common_carp.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['nothern_pike'] = { name = 'nothern_pike', label = 'Northern Pike', weight = 100, type = 'item', image = 'nothern_pike.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['perch'] = { name = 'perch', label = 'Perch', weight = 100, type = 'item', image = 'perch.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['rainbow_trout'] = { name = 'rainbow_trout', label = 'Rainbow Trout', weight = 100, type = 'item', image = 'rainbow_trout.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['redfin_pickerel'] = { name = 'redfin_pickerel', label = 'Redfin Pickerel', weight = 100, type = 'item', image = 'redfin_pickerel.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['rock_bass'] = { name = 'rock_bass', label = 'Rock Bass', weight = 100, type = 'item', image = 'rock_bass.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['small_trout'] = { name = 'small_trout', label = 'Small Trout', weight = 100, type = 'item', image = 'small_trout.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['smallmouth_bass'] = { name = 'smallmouth_bass', label = 'Smallmouth Bass', weight = 100, type = 'item', image = 'smallmouth_bass.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['sockeye_salmon'] = { name = 'sockeye_salmon', label = 'Sockeye Salmon', weight = 100, type = 'item', image = 'sockeye_salmon.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['trout'] = { name = 'trout', label = 'Trout', weight = 100, type = 'item', image = 'trout.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },
['whitefish'] = { name = 'whitefish', label = 'Whitefish', weight = 100, type = 'item', image = 'whitefish.png', unique = false, useable = false, shouldClose = false, description = 'A fish' },

['anchor'] = { name = 'anchor', label = 'Anchor', weight = 200, type = 'item', image = 'anchor.png', unique = true, useable = false, shouldClose = true, description = 'A heavy anchor' },

['redpearl'] = { name = 'redpearl', label = 'Red Pearl', weight = 100, type = 'item', image = 'redpearl.png', unique = false, useable = false, shouldClose = false, description = 'A pearl' },
['bluepearl'] = { name = 'bluepearl', label = 'Blue Pearl', weight = 100, type = 'item', image = 'bluepearl.png', unique = false, useable = false, shouldClose = false, description = 'A pearl' },
['yellowpearl'] = { name = 'yellowpearl', label = 'Yellow Pearl', weight = 100, type = 'item', image = 'yellowpearl.png', unique = false, useable = false, shouldClose = false, description = 'A pearl' },
['greenpearl'] = { name = 'greenpearl', label = 'Green Pearl', weight = 100, type = 'item', image = 'greenpearl.png', unique = false, useable = false, shouldClose = false, description = 'A pearl' },
['whitepearl'] = { name = 'whitepearl', label = 'White Pearl', weight = 100, type = 'item', image = 'whitepearl.png', unique = false, useable = false, shouldClose = false, description = 'A pearl' },

['green_crab'] = { name = 'green_crab', label = 'Green Crab', weight = 500, type = 'item', image = 'green_crab.png', unique = false, useable = false, shouldClose = false, description = 'A crab' },
['red_crab'] = { name = 'red_crab', label = 'Red Crab', weight = 500, type = 'item', image = 'red_crab.png', unique = false, useable = false, shouldClose = false, description = 'A crab' },
['blue_crab'] = { name = 'blue_crab', label = 'Blue Crab', weight = 500, type = 'item', image = 'blue_crab.png', unique = false, useable = false, shouldClose = false, description = 'A crab' },
['king_crab'] = { name = 'king_crab', label = 'King Crab', weight = 500, type = 'item', image = 'king_crab.png', unique = false, useable = false, shouldClose = false, description = 'A crab' },

['fishing_rod_one'] = { name = 'fishing_rod_one', label = '1 Lvl Fishing Rod', weight = 1000, type = 'item', image = 'fishing_rod_one.png', unique = true, useable = true, shouldClose = true, description = 'Fishing rod level 1' },
['fishing_rod_two'] = { name = 'fishing_rod_two', label = '2 Lvl Fishing Rod', weight = 1000, type = 'item', image = 'fishing_rod_two.png', unique = true, useable = true, shouldClose = true, description = 'Fishing rod level 2' },
['fishing_rod_three'] = { name = 'fishing_rod_three', label = '3 Lvl Fishing Rod', weight = 1000, type = 'item', image = 'fishing_rod_three.png', unique = true, useable = true, shouldClose = true, description = 'Fishing rod level 3' },
['fishing_rod_four'] = { name = 'fishing_rod_four', label = '4 Lvl Fishing Rod', weight = 1000, type = 'item', image = 'fishing_rod_four.png', unique = true, useable = true, shouldClose = true, description = 'Fishing rod level 4' },
['fishing_rod_five'] = { name = 'fishing_rod_five', label = '5 Lvl Fishing Rod', weight = 1000, type = 'item', image = 'fishing_rod_five.png', unique = true, useable = true, shouldClose = true, description = 'Fishing rod level 5' },

['fishing_net'] = { name = 'fishing_net', label = 'Fishing Net', weight = 750, type = 'item', image = 'fishing_net.png', unique = true, useable = true, shouldClose = true, description = 'Used to catch fish' },

['worm_fish_bait'] = { name = 'worm_fish_bait', label = 'Worm Fish Bait', weight = 100, type = 'item', image = 'worm_fish_bait.png', unique = false, useable = true, shouldClose = false, description = 'Fishing bait' },
['simple_fish_bait'] = { name = 'simple_fish_bait', label = 'Simple Fish Bait', weight = 100, type = 'item', image = 'simple_fish_bait.png', unique = false, useable = true, shouldClose = false, description = 'Fishing bait' },
['illegal_fish_bait'] = { name = 'illegal_fish_bait', label = 'Illegal Fish Bait', weight = 100, type = 'item', image = 'illegal_fish_bait.png', unique = false, useable = true, shouldClose = false, description = 'Illegal bait' },

['diving_cloth'] = { name = 'diving_cloth', label = 'Diving Cloths', weight = 1000, type = 'item', image = 'diving_cloth.png', unique = false, useable = true, shouldClose = true, description = 'Diving clothes' },
['diving_gear'] = { name = 'diving_gear', label = 'Diving Gear', weight = 1000, type = 'item', image = 'diving_gear.png', unique = false, useable = true, shouldClose = true, description = 'Diving gear' },
['diving_tube'] = { name = 'diving_tube', label = 'Diving Tube', weight = 1000, type = 'item', image = 'diving_tube.png', unique = false, useable = true, shouldClose = true, description = 'Oxygen tube' },

['lucky_hat'] = { name = 'lucky_hat', label = 'Lucky Hat', weight = 750, type = 'item', image = 'lucky_hat.png', unique = false, useable = false, shouldClose = false, description = 'A lucky hat' },

['rod_grip'] = { name = 'rod_grip', label = 'Rod Grip', weight = 750, type = 'item', image = 'rod_grip.png', unique = false, useable = false, shouldClose = false, description = 'Rod part' },
['rod_reel_seet'] = { name = 'rod_reel_seet', label = 'Rod Reel Seet', weight = 750, type = 'item', image = 'rod_reel_seet.png', unique = false, useable = false, shouldClose = false, description = 'Rod part' },
['rod_blank'] = { name = 'rod_blank', label = 'Rod Blank', weight = 750, type = 'item', image = 'rod_blank.png', unique = false, useable = false, shouldClose = false, description = 'Rod part' },
['rod_fishing_line'] = { name = 'rod_fishing_line', label = 'Rod Line', weight = 750, type = 'item', image = 'rod_fishing_line.png', unique = false, useable = false, shouldClose = false, description = 'Fishing line' },

['vehicle_wheels'] = { name = 'vehicle_wheels', label = 'Vehicle Wheels', weight = 2500, type = 'item', image = 'vehicle_wheels.png', unique = false, useable = false, shouldClose = false, description = 'Vehicle part' },

['trash_can'] = { name = 'trash_can', label = 'Trash Can', weight = 200, type = 'item', image = 'trash_can.png', unique = false, useable = false, shouldClose = false, description = 'Trash item' },
['trash_chips'] = { name = 'trash_chips', label = 'Trash Chips', weight = 200, type = 'item', image = 'trash_chips.png', unique = false, useable = false, shouldClose = false, description = 'Trash item' },
['trash_burger'] = { name = 'trash_burger', label = 'Trash Burger', weight = 200, type = 'item', image = 'trash_burger.png', unique = false, useable = false, shouldClose = false, description = 'Trash item' },

['scrapmetal'] = { name = 'scrapmetal', label = 'Scrap Metal', weight = 1000, type = 'item', image = 'scrapmetal.png', unique = false, useable = false, shouldClose = false, description = 'Scrap material' },
['coral_grass'] = { name = 'coral_grass', label = 'Coral Grass', weight = 100, type = 'item', image = 'coral_grass.png', unique = false, useable = false, shouldClose = false, description = 'Sea plant' },
--- End 0R Fishing v2 Item List ---

OX Inventory