Using it

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.
  • driver can stay empty to use the JDBC driver that comes with your server.
  • Check /sb status to see which data source is active.