fxPoliceMenu

Installation Guide

Run this code in your database:

CREATE TABLE management_funds_transactions (
    transactions CHAR(255) NOT NULL,
    transaction_date DATETIME
);

CREATE TABLE `fxcommunityservice` (
  `citizenid` varchar(100) NOT NULL PRIMARY KEY,
  `actions` int(11) NOT NULL
);

If you want to use standalone police invoices, run this code in your database:

CREATE TABLE `fxInvoices` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `amount` int(11) NOT NULL DEFAULT 0,
  `society` tinytext DEFAULT NULL,
  `sender` varchar(50) DEFAULT NULL,
  `sendercitizenid` varchar(50) DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `citizenid` (`citizenid`)
);

If you want to use qb-phone invoices, run this code:

ALTER TABLE phone_invoices ADD COLUMN reason TEXT;
ALTER TABLE phone_invoices ADD COLUMN date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

Add this item in qb-core/shared/items.lua:

['fxtablet'] = {['name'] = 'fxtablet', ['label'] = 'Police Tablet', ['weight'] = 2000, ['type'] = 'item', ['image'] = 'tablet.png', ['unique'] = false, ['useable'] = true, ['shouldClose'] = true, ['combinable'] = nil, ['description'] = 'fxPoliceMenu tablet'},