# Used for /dbl servers command. Not for saving data.
databases:
  localmachine:
    host: localhost
    port: 3306
    user: root
    password: 'password'
    flags: '/?allowPublicKeyRetrieval=true&useSSL=false'

  examplemiami:
    host: 159.003.0.120
    port: 3306
    user: root
    password: 'password'
    flags: '/?allowPublicKeyRetrieval=true&useSSL=false'

# Used for /dbl servers command. 
# Not for saving data but required.
hidden_databases:
- mysql
- performance_schema
- information_schema
- sys

# Every how many seconds send
# a MySQL request to store
# collected data in cache? 
# (High number = better performance)
update_interval: 15

# Max cache.db file size in MB (0 = disabled)
# File size limit is reached = empty cache.
max_cache_size_mb: 0


# ↓↓ Data section only have to be used for player placeholders like money,kills,words,numbers,etc...
data:
# ↓↓ Only used for the placeholder. ex: (%dbl_data_kills%) 
# you can use ParseOther expansion to display data from other offline/online players.
  kills:
    server: localmachine # Choose one from "databases" section.
    database: killstats # A dbname from the server specified in "server".
    table: players
    column: kills_amount
#   where: "TYPE = 'kdr'" !! Read below ↓↓↓ !!
    empty_message: "I killed no one"
    no_cache: false

# ↓↓ Only used for the placeholder. ex: (%dbl_data_balance%) 
# you can use ParseOther expansion to display data from other offline/online players.
  balance:
    server: localmachine # Choose one from "databases" section.
    database: currencies # A dbname from the server specified in "server".
#   If true the placeholder will grab instant updates from MySQL ignoring SQLite
#   if true, i recommend not using high refresh rates for
#   the placeholder (for better performance). This option is good for conditions.
    no_cache: false
#   The name of the table that shows when you type "/dbl servers".
    table: all_players_coins
#   The column name that you want to show in the placeholder %dbl_data_balance%
#   It can be a number a word or everything. Use "/dbl servers"
#   to see the column name that you want to show.
    column: money_amount
#   ↓↓ Only use it if your table can contain multiple rows with the same player name/uuid
#   Example: (if the where: money_type = 'gold' in %dbl_data_balance% ill see: 35)
#   +--------------------------------------+----------+----------------+
#   | PLAYER                               | money_type | money_amount | <--- Columns
#   +--------------------------------------+----------+----------------+
#   | 76db8f56-d75a-360e-89db-f411265da8d2 | gold       | 35           | <--- Row
#   | 76db8f56-d75a-360e-89db-f411265da8d2 | diamond    | 81           | <--- Row
#   +--------------------------------------+----------+----------------+
#   The "where" is totally optional, dont use it if you don't need it.
    where: "money_type = 'gold'"
#   Empty value for placeholder %dbl_data_balance%
    empty_message: "I have no money"
#
# ↓↓ Used to make leaderboards, only numbers values are accepted. ↓
tops:
# ↓↓ Only used for placeholder. ex: %dbl_top_coins_1_name% and %dbl_top_coins_1_value%
  coins:
#   If true the placeholder will grab instant updates from MySQL ignoring SQLite
#   if true, i recommend not using high refresh rates for
#   the placeholder (for better performance). This option is good for conditions.
    no_cache: false
    server: localmachine # Choose one from "databases" section.
    database: sqlvault # A dbname from the server specified in "server".
#   The name of the table that shows when you type "/dbl servers".
    table: all_player_coins
#   The column name where the numbers are. coins, kills, score, etc. 
#   !!! you can found it with "/dbl servers" !!!
    column_number: money_amount
#   ↓↓ Only use it if your table can contain multiple rows with the same player name/uuid
#   Example: (if the where: money_type = 'diamond' in %dbl_top_coins_1_value% ill see: 81)
#   +--------------------------------------+----------+----------------+
#   | PLAYER                               | money_type | money_amount | <--- Columns
#   +--------------------------------------+----------+----------------+
#   | 76db8f56-d75a-360e-89db-f411265da8d2 | gold       | 35           | <--- Row
#   | 76db8f56-d75a-360e-89db-f411265da8d2 | diamond    | 81           | <--- Row
#   +--------------------------------------+----------+----------------+
    where: "money_type = 'gold'" # The "where" is totally optional, remove it if you don't need it.
#   The column where the player names, uuid, clan names and etc are going to be collected by the plugin,
#   they usually are player, name or player_name. Use "/dbl servers" to discover it.
    column_name: PLAYER
#   Empty value for placeholder %dbl_top_coins_1_name/value%
    empty_message: "---"
#   How many tops the plugin is going to query?
    limit: 5
# ↓↓ Only used for placeholder. ex: %dbl_top_clans_1_name% and %dbl_top_clans_1_value%
  clans:
#   If true the placeholder will grab instant updates from MySQL ignoring SQLite
#   if true, i recommend not using high refresh rates for
#   the placeholder (for better performance). This option is good for conditions.
    no_cache: false
    server: localmachine # Choose one from "databases" section.
    database: clansdata # A dbname from the server specified in "server".
#   The name of the table that shows when you type "/dbl servers" to discover it.
    table: clans
#   The column name where the numbers are. coins, kills, score, etc. 
#   !!! you can found it with "/dbl servers" !!!
    column_number: kills
#   +--------------------------------------------+
#   | clan_name       | members | kills          |  <--- Columns
#   +--------------------------------------------+
#   | kings           | 15      | 81             |  <--- Row
#   | demons          | 25      | 35             |  <--- Row
#   +--------------------------------------------+
#   The column name where the player names, clan names and etc. are going to be collected by the plugin.
#   Use "/dbl servers" to discover it.
    column_name: clan_name
#   Empty value for placeholder %dbl_top_clans_1_name/value%
    empty_message: "---"
#   How many tops the plugin is going to query?
    limit: 5


# ↓↓ Static data, used for values that are not assigned to a player. For example a server registered players count.
static:
# Used for placeholder. ex: %dbl_static_registered_count%
  registered_count:
    server: localmachine # Choose one from "databases" section.
    database: serversdata # A dbname from the server specified in "server".
#   The name of the table that shows when you type "/dbl servers"
    table: server_data
#   If true the placeholder will grab instant updates from MySQL ignoring SQLite
#   if true, i recommend not using high refresh rates for
#   the placeholder (for better performance). This option is good for conditions.
    no_cache: false
#   Example:
#   Here replace 'servername' with the column where the server names are stored
#   and replace 'Skywars' with the server name that you want the registered players amount to be shown.
#   you can know the column names with the command /dbl colsee <database> <table> <columnname,columnname2> (Comma separated)
#   +---------------------------------------------+
#   | servername       | registered_players       |  <--- Columns
#   +---------------------------------------------+
#   | Skywars          | 15                       |  <--- Row
#   | Survival         | 25                       |  <--- Row
#   +---------------------------------------------+
    where: "servername = 'Skywars'"
#   The column that the placeholder is going to show (%dbl_static_registered_count%)
    column: registered_players