💻 Installation

How to set up the script?

🧱 Dependencies

To ensure the OS and physical paper systems work seamlessly, the following resources are required:

• Ox Lib: Core library for UI and internal functions.

• OX Inventory or QB Inventory: For item management and persistence.

• OxMySQL: For database connectivity.

---

📦 Inventory Configuration

Choose your framework and add the following items to your shared files.

Option A: OX Inventory (data/items.lua)

['laptop'] = {
    label = 'Laptop',
    weight = 2000,
    stack = true,
    close = true,
    description = 'Place it in the world to use it',
    client = { export = 'df_computer.useLaptop' }
},
['desktop_computer'] = {
    label = 'Desktop Computer',
    weight = 6000,
    stack = true,
    close = true,
    description = 'Fixed computer - place it in the world',
    client = { export = 'df_computer.usedesktopComputer' }
},
['printer'] = {
    label = 'Printer',
    weight = 5000,
    stack = true,
    close = true,
    description = 'Place a printer in the world',
    client = { export = 'df_computer.usePrinter' }
},
['usb'] = {
    label = 'USB',
    weight = 20,
    stack = false,
    close = true,
    description = 'USB Drive - use it with a computer'
},
['paper'] = {
    label = "Paper",
    weight = 50,
    stack = false,
    close = true,
},
['pencil'] = {
    label = "Pen",
    weight = 100,
},

Custom Inventory Note: Use TriggerEvent("df:vedidoc", serial, slot) on item "paper" to view documents.

Option B: QB Core (shared/items.lua)

paper = { name = "paper", label = "Paper", weight = 100, type = "item", image = "paper.png", unique = true, useable = true, shouldClose = true, description = "Writable paper document" },
pencil = { name = "pencil", label = "Pencil", weight = 50, type = "item", image = "pencil.png", unique = false, useable = false, shouldClose = true, description = "Used to write on paper" },
laptop = { name = "laptop", label = "Laptop", weight = 2000, type = "item", image = "laptop.png", unique = false, useable = true, shouldClose = true, description = "Place it in the world to use it" },
desktop_computer = { name = "desktop_computer", label = "Desktop Computer", weight = 6000, type = "item", image = "desktop_computer.png", unique = false, useable = true, shouldClose = true, description = "Fixed computer - place it in the world" },
usb = { name = "usb", label = "USB", weight = 20, type = "item", image = "usb.png", unique = false, useable = false, shouldClose = true, description = "USB Drive - use it with a computer" },
printer = { name = "printer", label = "Printer", weight = 5000, type = "item", image = "printer.png", unique = false, useable = true, shouldClose = true, description = "Place a printer in the world" },

---

🗄️ Database Setup (SQL)

Execute the following queries in your database to handle file persistence, emails, and device tracking:

CREATE TABLE IF NOT EXISTS `usb_data` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `serial` VARCHAR(32) NOT NULL UNIQUE,
    `owner_identifier` VARCHAR(255) DEFAULT NULL,
    `name` VARCHAR(64) NOT NULL DEFAULT 'USB',
    `files` TEXT DEFAULT '{}',
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `computer_data` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `serial` VARCHAR(32) NOT NULL UNIQUE,
    `owner_identifier` VARCHAR(255) DEFAULT NULL,
    `pos_x` FLOAT NOT NULL DEFAULT 0,
    `pos_y` FLOAT NOT NULL DEFAULT 0,
    `pos_z` FLOAT NOT NULL DEFAULT 0,
    `heading` FLOAT NOT NULL DEFAULT 0,
    `screen_down` TINYINT(1) NOT NULL DEFAULT 0,
    `device` VARCHAR(16) NOT NULL DEFAULT 'laptop',
    `notes` TEXT DEFAULT '',
    `files` TEXT DEFAULT '',
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `mail_accounts` (
    `id` INT AUTO_INCREMENT PRIMARY KEY, 
    `identifier` VARCHAR(255) NOT NULL,
    `username` VARCHAR(64) NOT NULL,
    `password_hash` VARCHAR(255) NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY `uq_username` (`username`),
    KEY `idx_identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Messaggi: from/to sono id account
CREATE TABLE IF NOT EXISTS `mail_messages` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `from_account_id` INT NOT NULL,
    `to_account_id` INT NOT NULL,
    `subject` VARCHAR(255) NOT NULL DEFAULT '',
    `body` TEXT NOT NULL,
    `is_read` TINYINT(1) NOT NULL DEFAULT 0,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    KEY `idx_to_account` (`to_account_id`),
    KEY `idx_from_account` (`from_account_id`),
    KEY `idx_created` (`created_at`),
    FOREIGN KEY (`from_account_id`) REFERENCES `mail_accounts`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`to_account_id`) REFERENCES `mail_accounts`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

    CREATE TABLE IF NOT EXISTS `computer_printer_data` (
        `id` INT AUTO_INCREMENT PRIMARY KEY,
        `serial` VARCHAR(32) NOT NULL UNIQUE,
        `name` VARCHAR(64) NOT NULL DEFAULT 'Printer',
        `pos_x` FLOAT NOT NULL DEFAULT 0,
        `pos_y` FLOAT NOT NULL DEFAULT 0,
        `pos_z` FLOAT NOT NULL DEFAULT 0,
        `heading` FLOAT NOT NULL DEFAULT 0,
        `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        UNIQUE KEY `uq_printer_name` (`name`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `computer_printer_jobs` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `printer_serial` VARCHAR(32) NOT NULL,
    `image_url` TEXT NOT NULL,
    `doc_name` VARCHAR(255) DEFAULT 'document',
    `page_num` INT NOT NULL DEFAULT 1,
    `printed_by` VARCHAR(255) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    KEY `idx_printer_serial` (`printer_serial`),
    KEY `idx_created_at` (`created_at`),
    CONSTRAINT `fk_printer_jobs_printer` FOREIGN KEY (`printer_serial`) REFERENCES `computer_printer_data`(`serial`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

---

⚙️ Final Steps

• Step 1: Place the df_computer folder into your resources directory.

• Step 2: Add ensure df_computer to your server.cfg (ensure it starts after dependencies).

• Step 3: Review config.lua to adjust settings like language, prop names, and permissions.