Installation

Dependencies

Installation

Download all dependencies

Download `lvl_smartstop` from your portal, extract it to the `resources` folder

In your `server.cfg`, create a new line and type `ensure lvl_smartstop`

Configure the script

And lastly install sql you will find in the `INSTALL` folder

SQL

Both version ⬇️

DROP TABLE IF EXISTS `camera_installs`;
CREATE TABLE `camera_installs` (
  `plate` VARCHAR(20) PRIMARY KEY,
  `hasCamera` BOOLEAN DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

DROP TABLE IF EXISTS `vehicle_v2x`;
CREATE TABLE `vehicle_v2x` (
  `plate` VARCHAR(20) PRIMARY KEY,
  `hasV2X` BOOLEAN DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

DROP TABLE IF EXISTS `vehicle_stop_logs`;
CREATE TABLE `vehicle_stop_logs` (
  id INT AUTO_INCREMENT PRIMARY KEY,
  `officer_name` VARCHAR(100) NOT NULL,
  `plate` VARCHAR(20) NOT NULL,
  `stopped_at` DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;