Installation Guide

---

Step 1: SQL Modifications

You need to execute the SQL code to set up the necessary database tables.

1. Alter player_vehicles table to include repossessed_state column:

   ALTER TABLE player_vehicles ADD COLUMN repossessed TINYINT(1) NOT NULL DEFAULT 0;

2. Create repossessed_vehicles table:

    CREATE TABLE `repossessed_vehicles` (
        `id` INT(11) NOT NULL AUTO_INCREMENT,
        `original_plate` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
        `citizenid` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
        `vehicle` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
        `repo_date` DATETIME NULL DEFAULT current_timestamp(),
        `repo_by` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
        `additional_info` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
        PRIMARY KEY (`id`) USING BTREE,
        INDEX `original_plate` (`original_plate`) USING BTREE,
        CONSTRAINT `repossessed_vehicles_ibfk_1` FOREIGN KEY (`original_plate`) REFERENCES `newmoonrp`.`player_vehicles` (`plate`) ON UPDATE RESTRICT ON DELETE CASCADE
    );

3. Create repossessed_auction table:

    CREATE TABLE `repossessed_auction` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `seller` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `price` INT(11) NULL DEFAULT NULL,
    `description` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `plate` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `model` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `mods` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `repossesionid` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `repossesionId` (`repossesionid`) USING BTREE);

---

Step 2: Lua Integration

Insert into qb-vehicleshop/server.lua.

Replace:

 MySQL.query('DELETE FROM player_vehicles WHERE plate = @plate', {['@plate'] = plate}) 
 TriggerClientEvent('QBCore:Notify', src, Lang:t('error.repossessed', {plate = plate}), 'error')

With:

 TriggerEvent("moon-dealerdynamics:server:repovehicle", v.plate, v.citizenid, v.vehicle, "Bank", '')
 TriggerClientEvent('QBCore:Notify', src, "Vehicle now Posted for Repossession", 'error') 

---

Step 3: Configure the Config.lua File

Customize the Config.lua file based on your preferences and requirements. Ensure the settings align with your server's intended functionality and features.

---

Step 4: Ensure Dependencies

Ensure you have the following dependencies installed:

• ox_lib