Storage Systems

-- Player balances table
CREATE TABLE IF NOT EXISTS balances (
    uuid TEXT PRIMARY KEY,
    balance DECIMAL(19,2) NOT NULL DEFAULT 0.00
);

-- Transaction history for logging
CREATE TABLE IF NOT EXISTS transactions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    uuid TEXT NOT NULL,
    amount DECIMAL(19,2) NOT NULL,
    type TEXT NOT NULL,        -- 'deposit', 'withdraw', 'transfer'
    source TEXT,               -- 'shop', 'auction', 'player', etc.
    timestamp INTEGER DEFAULT (strftime('%s', 'now'))
);

CREATE INDEX IF NOT EXISTS idx_transactions_uuid ON transactions(uuid);

-- Warp definitions
CREATE TABLE IF NOT EXISTS warps (
    name TEXT PRIMARY KEY,
    world TEXT NOT NULL,
    x REAL NOT NULL,
    y REAL NOT NULL,
    z REAL NOT NULL,
    yaw REAL NOT NULL,
    pitch REAL NOT NULL,
    permission TEXT,           -- Optional permission node
    cost REAL DEFAULT 0.0,     -- Economy cost to use
    hidden INTEGER DEFAULT 0,  -- 1 = hidden from lists
    description TEXT DEFAULT '',
    category TEXT DEFAULT 'default'
);

-- Per-player warp usage tracking
CREATE TABLE IF NOT EXISTS player_warp_usage (
    uuid TEXT NOT NULL,
    warp_name TEXT NOT NULL,
    uses INTEGER DEFAULT 0,
    last_used INTEGER DEFAULT 0,
    PRIMARY KEY (uuid, warp_name)
);

-- Home locations
CREATE TABLE IF NOT EXISTS homes (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    uuid TEXT NOT NULL,
    name TEXT NOT NULL,
    world TEXT NOT NULL,
    x REAL NOT NULL,
    y REAL NOT NULL,
    z REAL NOT NULL,
    yaw REAL NOT NULL,
    pitch REAL NOT NULL,
    created_at INTEGER DEFAULT (strftime('%s', 'now')),
    UNIQUE(uuid, name)       -- One home name per player
);

CREATE INDEX IF NOT EXISTS idx_homes_uuid ON homes(uuid);

-- Kit claim tracking
CREATE TABLE IF NOT EXISTS kit_claims (
    uuid TEXT NOT NULL,
    kit_name TEXT NOT NULL,
    last_claimed INTEGER DEFAULT 0,   -- Unix timestamp
    claim_count INTEGER DEFAULT 0,    -- Total times claimed
    PRIMARY KEY (uuid, kit_name)
);

-- Player nicknames
CREATE TABLE IF NOT EXISTS nicknames (
    uuid TEXT PRIMARY KEY,
    nickname TEXT NOT NULL,           -- MiniMessage formatted
    updated_at INTEGER DEFAULT (strftime('%s', 'now'))
);

-- Index for nickname lookup (case-insensitive)
CREATE INDEX IF NOT EXISTS idx_nick_name ON nicknames(nickname);

-- Active auctions
CREATE TABLE IF NOT EXISTS auctions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    seller_uuid TEXT NOT NULL,
    seller_name TEXT NOT NULL,
    item_base64 TEXT NOT NULL,        -- Serialized ItemStack
    price REAL NOT NULL,
    listed_time INTEGER NOT NULL,     -- Unix timestamp
    duration INTEGER NOT NULL,        -- Duration in milliseconds
    claimed BOOLEAN DEFAULT FALSE     -- True when sold/cancelled/expired
);

-- Expired/unsold items waiting for pickup
CREATE TABLE IF NOT EXISTS expired_auctions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    seller_uuid TEXT NOT NULL,
    item_base64 TEXT NOT NULL,
    expired_time INTEGER NOT NULL,
    claimed BOOLEAN DEFAULT FALSE
);

-- Purchase history
CREATE TABLE IF NOT EXISTS purchase_history (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    uuid TEXT NOT NULL,
    item_id TEXT NOT NULL,            -- Shop item identifier
    amount INTEGER NOT NULL,
    price DECIMAL(19,2) NOT NULL,
    timestamp INTEGER DEFAULT (strftime('%s', 'now'))
);

-- Sale history (players selling to shop)
CREATE TABLE IF NOT EXISTS sell_history (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    uuid TEXT NOT NULL,
    item_id TEXT NOT NULL,
    amount INTEGER NOT NULL,
    price DECIMAL(19,2) NOT NULL,
    timestamp INTEGER DEFAULT (strftime('%s', 'now'))
);

CREATE INDEX IF NOT EXISTS idx_purchases_uuid ON purchase_history(uuid);

debug: true

default-language: en_US

heal:
  feed-player: true
  clear-negative-effects: true

economy:
  enabled: true
  starting-balance: "100.00"
  currency:
    singular: "Dollar"
    plural: "Dollars"
  minimum-transaction: "0.01"
  max-balance: -1

teleport:
  tpa:
    cooldown: 60
    warmup: 3
    timeout: 60
    max-pending: 5
    max-outgoing: 1
    cost: 0.0
    deny-movement: true
    particles: true
    sounds: true
    blocked-worlds: []

home:
  max-homes: 3
  default-name: "home"
  cooldown: 5
  warmup: 3
  cancel-on-movement: true
  particles: true
  sounds: true
  blocked-worlds:
    - "world_nether"
    - "world_the_end"

spawn:
  cooldown: 5
  warmup: 3
  teleport-on-first-join: true
  particles: true
  sounds: true
  cancel-on-movement: true

join-leave-messages:
  enabled: true
  join: "<white><player> <#FFCE00>joined the game"
  leave: "<white><player> <#FF4000>left the game"

back:
  warmup: 3
  cooldown: 5
  particles: true
  sounds: true
  cancel-on-movement: true

scoreboard:
  enabled: true
  update-interval: 20
  title: "<#FF3000><b>MyServer"
  lines:
    - ""
    - "<#FF3000>| <white>Player: <#FFAC96>%player_name%"
    - "<#FF3000>| <white>Rank: <#FFAC96>%luckperms_prefix%"
    - "<#FF3000>| <white>Balance: <#FFAC96>%vault_eco_balance_formatted%"
    - "<#FF3000>| <white>Online: <#FFAC96>%server_online%<gray>/<#FFAC96>%server_max_players%"
    - "<#FF3000>| <white>Kills: <#FFAC96>%statistic_player_kills%"
    - ""
    - "<#FFAC96>play.myserver.net"

rename:
  blacklist-enabled: true
  blacklist-words:
    - "badword"
    - "hello"
  max-length: 50
  min-length: 1
  normalize-enabled: true
  strip-colors-for-check: true

vanish:
  hide-from-tab: true
  give-night-vision: true
  prevent-mob-target: true
  disable-collisions: true

nickname:
  enabled: true
  min-length: 3
  max-length: 16
  allow-colors: true
  allow-formats: true
  blacklist-enabled: true
  blacklist-words: []
  normalize-enabled: true
  unique: true
  update-tab: true

shop:
  enabled: true
  main-menu-title: "<#F52727><b>Server Shop"
  main-menu-size: 54
  category-title: "<#F52727><category>"
  category-menu-title: "<#F52727>Shop - <category>"
  close-button-enabled: true
  items-per-page: 28
  fill-empty-slots: true
  fill-material: "BLACK_STAINED_GLASS_PANE"
  log-transactions: true
  currency:
    singular: "Dollar"
    plural: "Dollars"

hat:
  blacklist-enabled: true
  blacklist-items:
    - bedrock
    - barrier
    - command_block
    - structure_void
    - jigsaw
    - light
  allow-blocks: false
  require-lore: false
  require-custom-name: false

auction-house:
  enabled: true
  max-auctions-per-player: 5
  duration-hours: 48
  min-price: "1.00"
  max-price: "-1"

warp:
  enabled: true
  cooldown: 5
  warmup: 3
  cancel-on-movement: true
  particles: true
  sounds: true
  blocked-worlds:
    - world_nether
    - world_the_end
  group-by-category: true
  max-name-length: 16
  limit-per-player:
    enabled: false
    max: 5

afk:
  enabled: true
  timeout-seconds: 300
  kick-timeout-seconds: 1800
  tab-placeholder-enabled: true
  tab-placeholder: "<color:#FF6B6B>[AFK]</color> "
  broadcast-enabled: true
  title-enabled: true
  title: "<color:#FF6B6B>You are now AFK</color>"
  subtitle: "<color:#FFE66D>Move to return</color>"
  prevent-damage: true
  prevent-mob-target: true
  prevent-pickup: true
  freeze-player: true
  blocked-commands:
    - spawn
    - home
    - tpa
    - tpahere
    - warp
    - shop
  list-show-location: true
  list-show-world: true
  list-sort-by: "time"

spawn:
  world: world
  x: 0.0
  y: 64.0
  z: 0.0
  yaw: 0.0
  pitch: 0.0

kits:
  starter:
    display-name: "<#2791F5>Starter Kit"
    description: "Basic items for new players"
    cooldown: 86400          # 24 hours
    one-time: false
    first-join: true         # Given automatically
    max-claims: 10
    items:
      - type: STONE_SWORD
        amount: 1
        name: "<#2791F5>Kit Starter"
        enchantments: {}
        unbreakable: false
        flags: []
        custom-model-data: 0
        nbt: {}