🖥️Installation Guide

Policejob Script Installation Guide

This page is dedicated to installation of our banking script. Follow steps listed below to start using pScripts Police Job on your server.

Additional information

REMEMBER TO REMOVE ANY SCRIPTS RELATED TO POLICE JOB!

REMOVE handsup.lua FILE from your qb-smallresources IF YOU USE!

We don't provide maps used in our preview videos, if you want to buy them, click the links below Prison Map (Use code "piotreq" for 10% off your purchase) Department Map

Prerequisities

Before you begin, ensure you have:

1. FiveM server with administrator access

2. Access to your server's database

3. File transfer capability (FTP or direct file access)

Do not use FileZilla - It corrupting files many times when files are transferred.

Step 1: Installing the dependencies

Our script requires 3 dependencies:

1. ox_lib

2. oxmysql

3. ox_target / qb-target

4. p_bridge

Additionaly, we recommend you use MariaDB as your Database Management System.

Step 2: Setting up the Database

For our script to work, you need to modify your database. Run these SQL commands:

ESX

ALTER TABLE `users`
  ADD IF NOT EXISTS `badge` int(11) DEFAULT NULL,
  ADD IF NOT EXISTS `jail` int(11) NOT NULL DEFAULT 0;

ALTER TABLE `owned_vehicles`
  ADD IF NOT EXISTS `job` varchar(30) DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `police_mugshots` (
  `id` int(11) NOT NULL,
  `suspect` varchar(60) NOT NULL,
  `dob` varchar(30) NOT NULL,
  `officer` varchar(60) NOT NULL,
  `description` varchar(150) NOT NULL,
  `url` longtext NOT NULL
);

CREATE TABLE IF NOT EXISTS `police_outfits` (
  `id` int(11) NOT NULL,
  `job` varchar(30) NOT NULL,
  `grade` longtext NOT NULL,
  `label` varchar(60) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `license` longtext DEFAULT 'none',
  `requirements` varchar(50) NOT NULL,
  `skin` longtext NOT NULL
);

CREATE TABLE IF NOT EXISTS `judgements` (
  `id` int(11) NOT NULL,
  `officer` varchar(46) NOT NULL,
  `player` varchar(46) NOT NULL,
  `offenses` longtext NOT NULL,
  `jail` int(11) NOT NULL,
  `fine` int(11) NOT NULL,
  `time` bigint(25) NOT NULL
);

CREATE TABLE IF NOT EXISTS `police_evidences` (
  `id` varchar(20) NOT NULL,
  `item` longtext NOT NULL,
  `time` bigint(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `police_impound` (
  `officer` varchar(60) NOT NULL,
  `officer_name` varchar(100) NOT NULL,
  `owner` varchar(46) DEFAULT NULL,
  `plate` varchar(10) NOT NULL,
  `vehicle` longtext NOT NULL,
  `location` varchar(60) NOT NULL,
  `reason` varchar(200) NOT NULL,
  `price` int(11) NOT NULL,
  `duration` bigint(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `police_evidences`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `police_impound`
  ADD PRIMARY KEY IF NOT EXISTS (`plate`);

ALTER TABLE `judgements`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `judgements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
ALTER TABLE `police_outfits`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `police_outfits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `police_mugshots`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `police_mugshots`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

QB

ALTER TABLE `players`
  ADD IF NOT EXISTS `badge` int(11) DEFAULT NULL,
  ADD IF NOT EXISTS `jail` int(11) NOT NULL DEFAULT 0;

ALTER TABLE `player_vehicles`
  ADD IF NOT EXISTS `job` varchar(30) DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `police_mugshots` (
  `id` int(11) NOT NULL,
  `suspect` varchar(60) NOT NULL,
  `dob` varchar(30) NOT NULL,
  `officer` varchar(60) NOT NULL,
  `description` varchar(150) NOT NULL,
  `url` longtext NOT NULL
);

CREATE TABLE IF NOT EXISTS `police_outfits` (
  `id` int(11) NOT NULL,
  `job` varchar(30) NOT NULL,
  `grade` longtext NOT NULL,
  `label` varchar(60) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `license` longtext DEFAULT 'none',
  `requirements` varchar(50) NOT NULL,
  `skin` longtext NOT NULL
);

CREATE TABLE IF NOT EXISTS `judgements` (
  `id` int(11) NOT NULL,
  `officer` varchar(46) NOT NULL,
  `player` varchar(46) NOT NULL,
  `offenses` longtext NOT NULL,
  `jail` int(11) NOT NULL,
  `fine` int(11) NOT NULL,
  `time` bigint(25) NOT NULL
);

CREATE TABLE IF NOT EXISTS `police_evidences` (
  `id` varchar(20) NOT NULL,
  `item` longtext NOT NULL,
  `time` bigint(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE  IF NOT EXISTS `police_impound` (
  `officer` varchar(60) NOT NULL,
  `officer_name` varchar(100) NOT NULL,
  `owner` varchar(46) DEFAULT NULL,
  `plate` varchar(10) NOT NULL,
  `vehicle` longtext NOT NULL,
  `location` varchar(60) NOT NULL,
  `reason` varchar(200) NOT NULL,
  `price` int(11) NOT NULL,
  `duration` bigint(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `police_evidences`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `police_impound`
  ADD PRIMARY KEY IF NOT EXISTS (`plate`);

ALTER TABLE `judgements`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `judgements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `police_outfits`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `police_outfits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
ALTER TABLE `police_mugshots`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `police_mugshots`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

QBOX

ALTER TABLE `players`
  ADD IF NOT EXISTS `badge` int(11) DEFAULT NULL,
  ADD IF NOT EXISTS `jail` int(11) NOT NULL DEFAULT 0;

ALTER TABLE `player_vehicles`
  ADD IF NOT EXISTS `job` varchar(30) DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `police_mugshots` (
  `id` int(11) NOT NULL,
  `suspect` varchar(60) NOT NULL,
  `dob` varchar(30) NOT NULL,
  `officer` varchar(60) NOT NULL,
  `description` varchar(150) NOT NULL,
  `url` longtext NOT NULL
);

CREATE TABLE IF NOT EXISTS `police_outfits` (
  `id` int(11) NOT NULL,
  `job` varchar(30) NOT NULL,
  `grade` longtext NOT NULL,
  `label` varchar(60) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `license` longtext DEFAULT 'none',
  `requirements` varchar(50) NOT NULL,
  `skin` longtext NOT NULL
);

CREATE TABLE IF NOT EXISTS `judgements` (
  `id` int(11) NOT NULL,
  `officer` varchar(46) NOT NULL,
  `player` varchar(46) NOT NULL,
  `offenses` longtext NOT NULL,
  `jail` int(11) NOT NULL,
  `fine` int(11) NOT NULL,
  `time` bigint(25) NOT NULL
);

CREATE TABLE IF NOT EXISTS `police_evidences` (
  `id` varchar(20) NOT NULL,
  `item` longtext NOT NULL,
  `time` bigint(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE  IF NOT EXISTS `police_impound` (
  `officer` varchar(60) NOT NULL,
  `officer_name` varchar(100) NOT NULL,
  `owner` varchar(46) DEFAULT NULL,
  `plate` varchar(10) NOT NULL,
  `vehicle` longtext NOT NULL,
  `location` varchar(60) NOT NULL,
  `reason` varchar(200) NOT NULL,
  `price` int(11) NOT NULL,
  `duration` bigint(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `police_evidences`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `police_impound`
  ADD PRIMARY KEY IF NOT EXISTS (`plate`);

ALTER TABLE `judgements`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `judgements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `police_outfits`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `police_outfits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `police_mugshots`
  ADD PRIMARY KEY IF NOT EXISTS (`id`);

ALTER TABLE `police_mugshots`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

You can run these on your preferred Database Management Tool (ex. HeidiSQL, phpMyAdmin etc.)

Step 3: Downloading the Police Job Script

1. Download the script from your Keymaster.

2. Extract the files to your resources (or any other preffered) folder.

3. Add the following line to your server.cfg

   ensure p_policejob

Step 4: Setting up items

Adding inventory items

Place the items from p_policejob/INSTALL/ITEMS in your inventory items file

Adding item image

Place the images from p_policejob/INSTALL/ICONS in your inventory resource's image folder:

• For ox_inventory: ox_inventory/web/images/

• For qb-inventory: qb-inventory/html/images/

• For ESX inventory: Check your specific inventory resource's image directory

• For other inventories: Check your specific inventory resource's image directory

Step 5: Configuration

1. Open p_policejob/shared folder

2. Configure our script basing on your needs.

Step 6: Start using our script

1. Save all changes

2. Restart / Start your FiveM server

Enjoy using your brand new pScripts Police Job Script!

---