🚀 Installation & Database Setup

Follow these simple steps to install and activate DynaDev VIP on your FiveM server.

---

🗄️ 1. Import Database Schema

Execute the SQL script below in your MySQL database via HeidiSQL, phpMyAdmin, or Navicat:

CREATE TABLE IF NOT EXISTS `vip_users` (
    `identifier` VARCHAR(64) NOT NULL,
    `tier` VARCHAR(32) NOT NULL,
    `started_at` INT(11) NOT NULL,
    `expires_at` INT(11) DEFAULT NULL,
    `player_name` VARCHAR(64) DEFAULT NULL,
    `steam_name` VARCHAR(64) DEFAULT NULL,
    `last_daily_claim` BIGINT NOT NULL DEFAULT 0,
    PRIMARY KEY (`identifier`),
    KEY `idx_vip_tier` (`tier`),
    KEY `idx_vip_expires` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Database Structure Notes

• expires_at = -1 or NULL indicates a Lifetime (Permanent) subscription.
• Auto-indexed on tier and expires_at for high-speed lookups with zero server tick lag.

---

📁 2. Resource Placement

Place the folder dynadev-vip into your server's resources/ directory (e.g. resources/[general]/dynadev-vip).

server/
  └── resources/
        └── [general]/
              └── dynadev-vip/
                    ├── client/
                    ├── server/
                    ├── html/
                    ├── bridge.lua
                    ├── config.lua
                    └── fxmanifest.lua

---

⚙️ 3. Startup Configuration (server.cfg)

Ensure the resource starts after oxmysql, ox_lib, and your active inventory resource:

# Dependencies
ensure oxmysql
ensure ox_lib
ensure ox_inventory    # or qb-inventory / qs-inventory

# DynaDev VIP System
ensure dynadev-vip

---

🛡️ 4. Administrator Permissions (Ace Permissions)

To grant your admin group access to the /vip Management Control Panel, add the following to your server.cfg:

add_ace group.admin "dynadev.vipadmin" allow