Documentation
Installation guide — please follow each step carefully and exactly as described to ensure the script works correctly on your server. Skipping or modifying steps may cause the system to not function properly, so follow it step by step.
To download the assets needed for this script, you must access the official Cfx.re portal, where all assets purchased through Tebex are managed.
Open the Cfx.re granted assets page: https://portal.cfx.re/assets/granted-assets.
This page contains all assets linked to your Cfx.re purchases.
Sign in using the same Cfx.re account you used when purchasing the asset.
If you use a different account, the assets will not appear.
In the granted assets list, locate and download:
TV & Billboard Creator
These two packages are required to install the full housing system.
These files include the models, materials, and visual resources required for the proper operation of the housing system.
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.
It is important to use MariaDB 10.6 or higher. Older database versions may cause the SQL file to fail during installation or generate compatibility issues. Using MariaDB 10.6+ also helps improve overall database optimization and server performance.
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.
CREATE TABLE IF NOT EXISTS `qs_tv_screens` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`unique_id` VARCHAR(100) NOT NULL,
`model` VARCHAR(100) NOT NULL,
`item_name` VARCHAR(100) DEFAULT NULL,
`x` FLOAT NOT NULL,
`y` FLOAT NOT NULL,
`z` FLOAT NOT NULL,
`heading` FLOAT NOT NULL,
`render_distance` FLOAT DEFAULT NULL,
`url` TEXT DEFAULT NULL,
`volume` FLOAT DEFAULT 0.8,
`password` VARCHAR(255) DEFAULT NULL,
`screen_config` TEXT DEFAULT NULL,
`is_screen_create` TINYINT(1) DEFAULT 0,
`created_by` VARCHAR(50) DEFAULT NULL,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_id` (`unique_id`),
KEY `model` (`model`),
KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `billboards` (
`unique_id` VARCHAR(50) NOT NULL,
`name` VARCHAR(100) NOT NULL,
`model` VARCHAR(50) NOT NULL,
`content_type` VARCHAR(20) DEFAULT 'image',
`content_url` TEXT,
`audio_url` TEXT,
`audio_enabled` BOOLEAN DEFAULT TRUE,
`auto_loop` BOOLEAN DEFAULT TRUE,
`autoplay` BOOLEAN DEFAULT TRUE,
`video_stopped` BOOLEAN DEFAULT FALSE,
`video_start_time` BIGINT DEFAULT NULL,
`volume` FLOAT DEFAULT 0.5,
`render_distance` FLOAT DEFAULT 150.0,
`x` FLOAT NOT NULL,
`y` FLOAT NOT NULL,
`z` FLOAT NOT NULL,
`heading` FLOAT DEFAULT 0.0,
`is_floating` BOOLEAN DEFAULT FALSE,
`scale_x` FLOAT DEFAULT NULL,
`scale_y` FLOAT DEFAULT NULL,
`pitch` FLOAT DEFAULT 0.0,
`created_by` VARCHAR(100),
`password` VARCHAR(255) DEFAULT NULL,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`unique_id`),
KEY `model` (`model`),
KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;