Quickstart

DISCORD_TOKEN=your_bot_token_here

# PostgreSQL connection string
DATABASE_URL=postgres://faculty_manager:averysecurepasswordyes@database:5432/faculty_manager

# Command prefix (if using prefix commands)
PREFIX=>

# Email configuration for student verification
SEND_FROM_ADDRESS=[email protected]
MAIL_USERNAME=your_smtp_username
MAIL_PASSWORD=your_smtp_password
SMTP_SERVER=smtp.gmail.com
SMTP_PORT=587

# PostgreSQL credentials (for Docker)
POSTGRES_USER=faculty_manager
POSTGRES_PASSWORD=averysecurepasswordyes
POSTGRES_DB=faculty_manager

# Logging level (optional but recommended)
RUST_LOG="info,sqlx=error,sqlx::query=error,sqlx::query_as=error"

# InfluxDB (optional - for metrics)
INFLUX_TOKEN=your_influx_token_here

{
  "prefix": ">",
  "channels": {
    "xp": "YOUR_XP_CHANNEL_ID",
    "rules": "YOUR_RULES_CHANNEL_ID",
    "news": "YOUR_NEWS_CHANNEL_ID",
    "logs": "YOUR_LOGS_CHANNEL_ID",
    "ads": "YOUR_ADS_CHANNEL_ID",
    "createChannel": "🔊 New VoiceChannel",
    "mealplan": "YOUR_MEALPLAN_CHANNEL_ID"
  },
  "colors": {
    "blue": "#4200ff",
    "lightblue": "#FFFFF",
    "green": "#28823d",
    "red": "#cf0a0a"
  },
  "roles": {
    "staffrole": "YOUR_STAFF_ROLE_ID",
    "semestermodrole": "YOUR_SEMESTER_MOD_ROLE_ID",
    "verified": "YOUR_VERIFIED_ROLE_ID",
    "mealplannotify": "YOUR_MEALPLAN_NOTIFY_ROLE_ID"
  },
  "general": {
    "adstimeout": 2147483647,
    "charsForLevel": 25,
    "xpScalingFactor": 0.5
  },
  "mealplan": {
    "postMealplan": true,
    "url": "http://www.max-manager.de/daten-extern/augsburg/pdf/wochenplaene/hs-kempten/aktuell.pdf",
    "check": 30,
    "postOnDay": "Monday",
    "postAtHour": "09:00:00",
    "imgsettings": {
      "density": 400,
      "quality": 100,
      "flatten": false,
      "width": 768,
      "height": 512
    }
  },
  "rssSettings": {
    "postRss": false,
    "rssFeedData": {},
    "rssCheckIntervalHours": 1,
    "rssCheckAfterTimeHours": 8
  },
  "podcastSettings": {
    "postPodcast": false,
    "podcastCheckInterval": 1,
    "podcastUrl": "",
    "podcastChannel": ""
  }
}

version: "3"
services:
  bot:
    container_name: faculty_manager
    image: ghcr.io/rndrmu/facultymanager:latest
    volumes:
      - './config.json:/config.json:ro'
      - './images:/images'
      - './migrations:/migrations'
    env_file:
      - .env
    depends_on:
      - database
    networks:
      - bot
    restart: unless-stopped

  database:
    container_name: faculty_manager_db
    image: postgres:13
    environment:
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      POSTGRES_DB: ${POSTGRES_DB}
    volumes:
      - ./migrations/faculty_manager.sql:/docker-entrypoint-initdb.d/init.sql
      - postgres_data:/var/lib/postgresql/data
    networks:
      - bot
    restart: unless-stopped

volumes:
  postgres_data:

networks:
  bot: {}

CREATE TABLE IF NOT EXISTS verified_users (
    user_id BIGINT PRIMARY KEY NOT NULL,
    user_email TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS user_xp (
    user_id BIGINT PRIMARY KEY NOT NULL,
    user_xp FLOAT8 NOT NULL DEFAULT 0.0,
    user_level INTEGER NOT NULL DEFAULT 0
);

CREATE TABLE IF NOT EXISTS voice_channels (
    channel_id BIGINT PRIMARY KEY NOT NULL,
    owner_id BIGINT NOT NULL,
    deletion_marker BOOL NOT NULL DEFAULT FALSE
);

CREATE TABLE IF NOT EXISTS mensaplan (
    date TEXT PRIMARY KEY NOT NULL,
    posted BOOL NOT NULL DEFAULT FALSE,
    plan_hash TEXT NOT NULL DEFAULT ''
);

CREATE TABLE IF NOT EXISTS ads (
    message_id BIGINT PRIMARY KEY NOT NULL,
    posted_at TIME DEFAULT CURRENT_TIME
);

CREATE TABLE IF NOT EXISTS rules (
    rule_number INTEGER PRIMARY KEY NOT NULL UNIQUE,
    rule_text TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS semestermods (
    user_id BIGINT PRIMARY KEY NOT NULL
);

CREATE TABLE IF NOT EXISTS posted_rss (
    message_id BIGINT PRIMARY KEY NOT NULL,
    rss_title TEXT NOT NULL,
    channel_id BIGINT NOT NULL
);