🛠️INSTALLATION

"Please read the motel.SQL file and configure the server.cfg according to your needs to access the game. It works seamlessly with qb-target, qb-inventory, illenium-appearance, qb-doorlock, and qb-core. These are the scripts I have. I can bring your requests with updates."

CREATE TABLE IF NOT EXISTS `motel_rooms` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `room_id` varchar(50) NOT NULL,
    `motel_id` varchar(50) NOT NULL,
    `owner` varchar(50) DEFAULT NULL,
    `rented_type` varchar(10) DEFAULT NULL,
    `rented_until` datetime DEFAULT NULL,
    `auto_renew` tinyint(1) DEFAULT 0,
    `last_payment` datetime DEFAULT NULL,
    `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `room_motel_unique` (`room_id`, `motel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `motel_stashes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `room_id` varchar(50) NOT NULL,
    `stash_data` longtext DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `room_id` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `motel_transactions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `room_id` varchar(50) NOT NULL,
    `player_id` varchar(50) NOT NULL,
    `amount` int(11) NOT NULL,
    `type` varchar(20) NOT NULL,
    `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `management_accounts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    `type` varchar(50) NOT NULL,
    `money` int(11) NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name_type` (`name`, `type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `management_accounts` (`name`, `type`, `money`) VALUES
    ('motel', 'boss', 0); 

QB-CORE / SHARED / JOBS.LUA QBShared.Jobs =

['motel'] = {
    label = 'Sandy Motel',
    defaultDuty = true,
    grades = {
        ['0'] = { name = 'Cleaner', payment = 50 },
        ['1'] = { name = 'Receptionist', payment = 100 },
        ['2'] = { name = 'Assistant Manager', payment = 200 },
        ['3'] = { name = 'Manager', payment = 250 },
        ['4'] = { name = 'Owner', isboss = true, payment = 300 },
    },
},

------- QB-DOORLOCK ------- qb-doorlock / configs / janimotel.lua copy and paste

---

"If you have any questions, feel free to contact me privately, or you can reach me on Discord. I can make the necessary adjustments for you."

"This will be my first project that I am officially advertising and putting up for sale. I look forward to all your feedback. I hope we can solve any issues together. Thank you for your purchase, and I wish you a great day. Don't forget to join me on Discord."