Skip to main content
Installation
  1. Unzip Pandryx_Billing and place Pandryx_Billing in your server’s resources folder.
  2. Add ensure Pandryx_Billing to your server.cfg
  3. Import the database schema.sql
  4. Make sure it starts before any resource that depends on it
  5. Start / Restart your server
ESX: no extra tables needed (uses native billing/addon_account_data)
QBCore / QBOX: creates phone_invoices and management_funds.See schema.sql](schema.sql) for the full script.
CREATE TABLE IF NOT EXISTS phone_invoices (
    id          INT UNSIGNED    AUTO_INCREMENT PRIMARY KEY,
    citizenid   VARCHAR(64)     NOT NULL DEFAULT '',
    society     VARCHAR(64)     NOT NULL DEFAULT '',
    label       VARCHAR(255)    NOT NULL DEFAULT '',
    amount      INT UNSIGNED    NOT NULL DEFAULT 0,
    status      ENUM('unpaid','paid','overdue','void') NOT NULL DEFAULT 'unpaid',
    issued_by   VARCHAR(128)    NOT NULL DEFAULT '',
    name        VARCHAR(128)    NOT NULL DEFAULT '',
    phone       VARCHAR(64)     NOT NULL DEFAULT '',
    created_at  TIMESTAMP       NOT NULL DEFAULT CURRENT_TIMESTAMP,
    created_ts  INT UNSIGNED    NOT NULL DEFAULT 0
);

-- Society/management fund balances
CREATE TABLE IF NOT EXISTS management_funds (
    job     VARCHAR(64) PRIMARY KEY,
    amount  BIGINT      NOT NULL DEFAULT 0
);
```