OrigenNetwork
Docs
DocsScriptsorigen_propplacerInstallation

Installation · origen_propplacer

1. SQL

Run the following SQL against your database before starting the resource.

The resource will also create and migrate these tables automatically on startup via oxmysql. Running the SQL manually is recommended to ensure a clean initial state.

propplacer_props

Stores every placed prop with its position, rotation, category, and metadata.

sql
CREATE TABLE IF NOT EXISTS `propplacer_props` (
    `id`         INT AUTO_INCREMENT PRIMARY KEY,
    `model`      VARCHAR(100) NOT NULL,
    `label`      VARCHAR(150) DEFAULT NULL,
    `notes`      TEXT         DEFAULT NULL,
    `x`          FLOAT NOT NULL,
    `y`          FLOAT NOT NULL,
    `z`          FLOAT NOT NULL,
    `rx`         FLOAT NOT NULL DEFAULT 0,
    `ry`         FLOAT NOT NULL DEFAULT 0,
    `rz`         FLOAT NOT NULL DEFAULT 0,
    `category`   VARCHAR(80)  DEFAULT 'General',
    `placed_by`  VARCHAR(100) NOT NULL DEFAULT 'admin',
    `locked`     TINYINT(1)   DEFAULT 0,
    `ghost`      TINYINT(1)   DEFAULT 0,
    `tags`       VARCHAR(200) DEFAULT NULL,
    `placed_at`  TIMESTAMP    DEFAULT CURRENT_TIMESTAMP
);

propplacer_permissions

Stores manually granted player permissions.

sql
CREATE TABLE IF NOT EXISTS `propplacer_permissions` (
    `identifier` VARCHAR(100) PRIMARY KEY,
    `name`       VARCHAR(100) NOT NULL,
    `level`      VARCHAR(20)  NOT NULL DEFAULT 'editor',
    `granted_by` VARCHAR(100) NOT NULL DEFAULT 'console',
    `granted_at` TIMESTAMP    DEFAULT CURRENT_TIMESTAMP
);

Runtime migrations

On every resource start, the server automatically runs ALTER TABLE … ADD COLUMN IF NOT EXISTS migrations for backward compatibility with older installs (pre-2.2.0). No manual action needed if upgrading from a previous version.

2. server.cfg

text
ensure origen_propplacer

oxmysql must be ensured before origen_propplacer in your server.cfg.

Previous
Dependencies