๐Ÿ—„๏ธDatabase

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

LPC Pro will automatically create all required tables on startup.

Connection String

For advanced users, you can customize the JDBC connection string:

LPC Pro uses HikariCP for connection pooling, which handles reconnection automatically.

triangle-exclamation

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

Last updated