Database
Import data.sql to create the required tables.
Tables
multichar_music
Per-player background music preferences.
| Column | Type | Description |
|---|---|---|
id | INT (PK, AI) | Unique identifier |
license | INT | Player license |
url | LONGTEXT | Music URL (YouTube/SoundCloud) |
volume | INT | Volume level |
multichar_purchases
Tebex transaction records for slot purchases.
| Column | Type | Default | Description |
|---|---|---|---|
id | INT (PK, AI) | Unique identifier | |
transaction | VARCHAR(50) | Tebex transaction ID | |
slots | INT | 0 | Number of slots purchased |
used | INT | 0 | Number of slots redeemed |
multichar_slots
Per-player additional slot count.
| Column | Type | Description |
|---|---|---|
id | INT (PK, AI) | Unique identifier |
license | VARCHAR(55) | Player license |
slots | INT | Additional purchased slots |
players (ALTER)
Adds a settings column (LONGTEXT) to the existing players table for storing character display preferences (pose, background, camera, profile photo).