Database
Documents LPC Pro 4.0.0 · mirrored from the product wiki, updated 2026-02-07 · GitBook version
LPC Pro stores player data, mutes, warnings, reputation, chat logs, and more in a database. Configuration is in database.yml.
SQLite (Default)
SQLite requires zero configuration. Data is stored in a local lpcpro.db file inside the plugin folder.
type: local
This is the recommended option for single servers.
MySQL / MariaDB
For larger servers or BungeeCord/Velocity networks, use a remote MySQL/MariaDB database:
type: remote
host: localhost:3306
database: lpcpro
username: your_username
password: your_password
Requirements
- MySQL 8.0+ or MariaDB 10.3+
- Collation:
utf8mb4_unicode_520_ci(required for emoji and unicode support)
Creating the Database
CREATE DATABASE lpcpro
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_520_ci;
LPC Pro will automatically create all required tables on startup.
Connection String
For advanced users, you can customize the JDBC connection string:
jdbc:{driver}://{host}/{database}?autoReconnect=true&characterEncoding=UTF-8&tcpKeepAlive=true&useSSL=false
LPC Pro uses HikariCP for connection pooling, which handles reconnection automatically.
database.yml does not support reloading. Any changes require a full server restart.
Data Stored
The following data is persisted in the database:
| Table | Purpose |
|---|---|
lpcpro_channels |
Custom chat channel definitions |
lpcpro_player_channels |
Channel membership and modes |
lpcpro_ignored_players |
Player ignore lists |
lpcpro_mutes |
Active and expired mutes |
lpcpro_warnings |
Player warnings |
lpcpro_player_notes |
Staff notes on players |
lpcpro_reputation |
Reputation scores |
lpcpro_reputation_log |
Reputation transaction log |
lpcpro_reports |
Chat reports |
lpcpro_polls |
Poll data |
lpcpro_poll_votes |
Poll vote records |
lpcpro_offline_messages |
Messages for offline players |
lpcpro_player_settings |
Per-player settings (color, toggles) |
lpcpro_chat_logs |
Chat message log |
lpcpro_chat_stats |
Player chat statistics (message counts, mentions, replies) |
lpcpro_achievements |
Unlocked achievements per player |
lpcpro_quick_replies |
Saved quick reply messages |
lpcpro_newcomer |
Newcomer tracking (playtime, message count) |
lpcpro_shop_purchases |
Shop item purchase records |
lpcpro_shop_points |
Player shop currency balances |
lpcpro_mail |
Mail messages between players |
lpcpro_player_language |
Player language preferences for translation |