Jota Dev Report System

Here you can see the documentation to learn how to install our store's reporting system

How to start the script for its correct operation:

Put in your server.cfg

# JotaDev Coins System
ensure jc_reports

General script settings:

Setting

Config = {}

Config.Framework = 'auto'  -- 'esx', 'qb', 'auto' or 'standalone'

--[[  
Configure your language using the following:
    'es' -> Spanish
    'en' -> English
    'fr' -> French
    'de' -> German
    'it' -> Italian
    'pt' -> Portuguese
]]
Config.Locale = 'en' 

Config.ReportCooldownMinutes = 5 -- Minutes you have to wait before you can start another report
Config.EditMessage = true -- Allows you to edit messages
Config.DeleteMessage = true -- Allows you to delete messages
Config.EditMaxSeconds = 600 -- Maximum time in seconds to be able to edit the message
Config.ReportCommand = 'report' -- Command to open the entire reports panel

Config.Links = { -- Links from the panel when you access the homepage
    discord = 'https://discord.com/invite/EDuZKM7Zuv',
    web = 'https://store.jotadev.site/',
    regulations = 'https://store.jotadev.site/'
}

Config.Notifys = {
    notifyType = 'script', -- 'script' // 'framework' | You can use the notification system that comes with the script, or you can use your framework's notifications
    notifyCreateReport = true, -- Notifies administrators when a report is created
    messageReceivedPlayer = true, -- Notifies the player when an administrator writes in the report chat
    messageReceivedReportAdmin = true, -- Notifies the administrator when a player writes in the report
    messageRecceivedChatStaff = true, -- Notify administrators when someone is speaking in the staff chat
    connectedNotice = true -- Notifies staff when the player joins a voice channel
}

Config.StaffGroups = {
    esx = { 'admin', 'mod', 'superadmin' },
    qb  = { 'admin', 'mod', 'god' }
}

Config.Tabs = {
    ControlPanel = {
        enabled = true,

        groups = {
            esx = { 'admin', 'superadmin' },
            qb  = { 'admin', 'god' }
        },

        identifiers = false
    },

    AllReports = {
        enabled = true,

        groups = {
            esx = { 'admin', 'superadmin', 'mod' },
            qb  = { 'admin', 'god', 'mod' }
        },

        identifiers = false
    },

    StaffChat = {
        enabled = true,

        groups = {
            esx = { 'admin', 'superadmin' },
            qb  = { 'admin', 'god' }
        },

        identifiers = false
    }
}

SettingServer

Import the following table in to the database

CREATE TABLE IF NOT EXISTS `jotadev_reports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifiers` longtext NOT NULL,
  `name` varchar(100) NOT NULL,
  `type` varchar(20) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `priority` varchar(20) NOT NULL,
  `status` varchar(20) DEFAULT 'open',
  `mugshot` longtext DEFAULT NULL,
  `players` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `closed_at` timestamp NULL DEFAULT NULL,
  `ai_disabled` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `jotadev_reports_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `report_id` int(11) NOT NULL,
  `identifier` varchar(60) NOT NULL,
  `name` varchar(100) NOT NULL,
  `message` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `edited` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE IF NOT EXISTS `jotadev_staffchat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(120) NOT NULL,
  `name` varchar(80) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `edited` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

---

If you have any questions or problems, do not hesitate to contact us:

Discord: https://discord.gg/EDuZKM7Zuv