Optional SQL mode
By default StrikeBoards reads stats through the StrikePractice API, walking offline players in small background batches. If you run StrikePractice on MySQL or MariaDB you can instead load leaderboard stats straight from its table. It is read-only: only SELECT statements are sent.
sql:
enabled: false
url: "jdbc:mysql://127.0.0.1:3306/strikepractice?useSSL=false"
username: ""
password: ""
driver: ""
table: "strikepractice_stats"
page-size: 500
columns:
uuid: "uuid"
name: "name"
global-elo: "elo"
kills: "kills"
deaths: "deaths"
wins: "wins"
losses: "losses"
win-streak: "winstreak"
brackets-wins: ""
lms-wins: ""
sumo-wins: ""
juggernaut-wins: ""
party-vs-party-wins: ""
event-wins: ""
- The table layout is never assumed. At startup the plugin checks your table and logs which configured columns it found. Missing columns show as 0.
- Leave a column value empty if your table does not have it.
- Kit ELO is not loaded in SQL mode. Kit boards always come from the StrikePractice API.
drivercan stay empty to use the JDBC driver that comes with your server.- Check
/sb statusto see which data source is active.