Installation

Quasar Motels Creator is a full motel management system for FiveM, letting players rent rooms with wardrobes, stashes, and parking. Rentals can be temporary or permanent, with auto-cleaning cycles and key-based access for guests. Admins create motels in real time, customize interiors, and set prices. Compatible with ESX and QBCORE, it expands housing with immersive, flexible, entry-level living.

---

Download Script

To download the assets needed for this script, you must access the official Cfx.re portal, where all assets purchased through Tebex are managed.

1. Go to the following link: 🔗 https://portal.cfx.re/assets/granted-assets

2. Log in with the same Cfx.re account you used to make the purchase.

3. In the list of granted assets, find and download the following:

   • Motels Creator

---

Download Dependencies

This script requires some mandatory dependencies to function correctly. Make sure to download and extract them inside your server’s main directory, keeping their original folder structure intact.

Releases · overextended/oxmysqlGitHub

Release bob74_ipl · Bob74/bob74_iplGitHub

---

Remove Other Scripts

This script may cause conflicts or errors if you use other motel systems on your server. It’s strongly recommended to remove them completely before installation to prevent compatibility or functionality issues.

---

Server.cfg Placement

This script must always start after es_extended or qb-core, never before. We recommend placing it below them in your server.cfg, ensuring all dependencies are loaded first to prevent errors or unexpected behavior.

---

Database Setup

Avoid using tools like XAMPP or other non-optimized local servers, as they may cause connection errors.

This script includes an essential database required for its operation. You must import it before starting your server, preferably using HeidiSQL or any other manager compatible with MariaDB/MySQL.

ESX

ALTER TABLE
    `users`
ADD
    COLUMN IF NOT EXISTS `currentRoom` VARCHAR(90) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci';
    
DROP TABLE IF EXISTS `motels`;

CREATE TABLE `motels` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`owner` VARCHAR(90) NOT NULL COLLATE 'utf8mb4_general_ci',
	`pay` INT(11) NOT NULL DEFAULT '0',
	`motel` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`roomId` INT(5) NOT NULL,
	`uniq` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
	`requests` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
	`suspended` INT(2) NOT NULL DEFAULT '0',
	`shared` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
	`startTime` INT(12) NULL DEFAULT NULL,
	`endTime` INT(12) NULL DEFAULT NULL,
	`warn` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `owner` (`owner`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;

DROP TABLE IF EXISTS `motels_bills`;

CREATE TABLE `motels_bills` (
    `owner` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `data` TEXT NOT NULL COLLATE 'armscii8_bin',
    PRIMARY KEY (`owner`) USING BTREE,
    INDEX `owner` (`owner`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_items`;

CREATE TABLE `motels_items` (
    `id` VARCHAR(50) NOT NULL DEFAULT 'AUTO_INCREMENT' COLLATE 'utf8mb4_general_ci',
    `items` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `limit` INT(11) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_owners`;

CREATE TABLE `motels_owners` (
    `owner` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `motel` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'armscii8_bin',
    PRIMARY KEY (`motel`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_storages`;

CREATE TABLE `motels_storages` (
    `motel` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `money` INT(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`motel`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_workers`;

CREATE TABLE `motels_workers` (
    `employee` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'armscii8_bin',
    `motel` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `salary` INT(11) NOT NULL,
    `pay` INT(11) NOT NULL,
    `permissions` TEXT NOT NULL COLLATE 'armscii8_bin',
    PRIMARY KEY (`employee`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

QBCORE

ALTER TABLE
    `players`
ADD
    COLUMN IF NOT EXISTS `currentRoom` VARCHAR(90) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci';

DROP TABLE IF EXISTS `motels`;

CREATE TABLE `motels` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`owner` VARCHAR(90) NOT NULL COLLATE 'utf8mb4_general_ci',
	`pay` INT(11) NOT NULL DEFAULT '0',
	`motel` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`roomId` INT(5) NOT NULL,
	`uniq` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
	`requests` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
	`suspended` INT(2) NOT NULL DEFAULT '0',
	`shared` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
	`startTime` INT(12) NULL DEFAULT NULL,
	`endTime` INT(12) NULL DEFAULT NULL,
	`warn` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `owner` (`owner`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;

DROP TABLE IF EXISTS `motels_bills`;

CREATE TABLE `motels_bills` (
    `owner` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `data` TEXT NOT NULL COLLATE 'armscii8_bin',
    PRIMARY KEY (`owner`) USING BTREE,
    INDEX `owner` (`owner`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_items`;

CREATE TABLE `motels_items` (
    `id` VARCHAR(50) NOT NULL DEFAULT 'AUTO_INCREMENT' COLLATE 'utf8mb4_general_ci',
    `items` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `limit` INT(11) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_owners`;

CREATE TABLE `motels_owners` (
    `owner` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `motel` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'armscii8_bin',
    PRIMARY KEY (`motel`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_storages`;

CREATE TABLE `motels_storages` (
    `motel` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `money` INT(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`motel`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_workers`;

CREATE TABLE `motels_workers` (
    `employee` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'armscii8_bin',
    `motel` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `salary` INT(11) NOT NULL,
    `pay` INT(11) NOT NULL,
    `permissions` TEXT NOT NULL COLLATE 'armscii8_bin',
    PRIMARY KEY (`employee`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

---

Motel Creation Menu

Make sure you have admin permissions before using the command.

To access the motel creation menu, simply use the following command in the in-game chat:

/createmotels

This command will open the Quasar Motels Creator interface, allowing you to create, edit, and configure your motel quickly and visually.