QBESX
Agency-Repairkits Installation
Complete vehicle repair kit system with progressive damage mechanics including engine stuttering, failure.
v1.0.0Paid4 Pages
01Installation
- 1Copy Agency-Repairkits to resources folder
- 2Execute sql/repairkit.sql in database (optional)
- 3Add ensure Agency-Repairkits to server.cfg
- 4Add agencyrepairkit item to framework
- 5Copy repairkit.png to inventory images
02Dependencies
None required, works standaloneQBCore or ESX (optional)Agency-Notify (optional)
03SQL File
Import this SQL file into your database before starting the resource:
-- Repair Kit System Database Schema
-- Compatible with both QB-Core and ESX frameworks
-- Table for tracking vehicle damage states (optional)
CREATE TABLE IF NOT EXISTS `vehicle_damage` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`plate` varchar(20) NOT NULL,
`engine_health` float DEFAULT 1000.0,
`body_health` float DEFAULT 1000.0,
`last_updated` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`owner` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `plate` (`plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Table for repair kit usage logs (optional)
CREATE TABLE IF NOT EXISTS `repairkit_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` varchar(50) NOT NULL,
`player_name` varchar(100) NOT NULL,
`vehicle_plate` varchar(20) NOT NULL,
`vehicle_model` varchar(50) DEFAULT NULL,
`engine_health_before` float DEFAULT NULL,
`body_health_before` float DEFAULT NULL,
`repair_time` timestamp DEFAULT CURRENT_TIMESTAMP,
`location` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `player_id` (`player_id`),
KEY `repair_time` (`repair_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Insert repair kit item for QB-Core (if using qb-core items table)
-- INSERT IGNORE INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`)
-- VALUES ('repairkit', 'Fahrzeug Reparaturkit', 500, 0, 1);
-- Insert repair kit item for ESX (if using esx items table)
-- INSERT IGNORE INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`)
-- VALUES ('repairkit', 'Fahrzeug Reparaturkit', 5, 0, 1);