Getting Started

Discord Ticket Bot

A modern, self-hosted Discord ticket bot built on Discord.js v14 and SQLite — no external database, no telemetry, full feature set out of the box.

✨ Features

Feature	Description
🎫 Ticket Types	Up to 25 configurable types with individual emoji, color, category & questions
📋 Questionnaires	Modal forms (up to 5 questions) shown when opening a ticket
🙋 Claim System	Staff can claim/unclaim — button toggles, embed & topic update automatically
🔴 Priorities	Low / Medium / High / Urgent via `/priority` — shown in channel topic & embed
📝 Staff Notes	Private notes via `/note add` / `/note list`
🔀 Move Ticket	Move to a different type/category via `/move` or button (staff only)
🛡️ Type-specific Staff Roles	Each ticket type can define its own staff roles
🖼️ Panel Logo & Banner	Optional logo thumbnail and/or banner image in the panel embed
🎛️ Panel Interaction Type	Choose between a Button or a direct Select Menu in the panel
⭐ Rating System	1–5 star feedback after closing, automatically posted to a configured channel
⏰ Staff Reminder	Automatic ping inside the ticket if no staff responds within X hours
⏰ Auto-Close	Automatically close inactive tickets with a configurable warning period
🔗 Transcript Links	Transcripts stored online and accessible via a public link
📄 HTML Transcript	Full self-contained HTML transcript — avatars embedded as Base64, no CDN required
🌐 Custom Domain	Premium users can serve transcripts under their own domain
📊 Statistics	Server-wide stats and detailed per-user stats via `/stats`
🚫 Blacklist	`/blacklist add/remove/list` to block users from opening tickets
💬 Canned Responses	Pre-defined snippets sent with one command — configured in `snippets.jsonc`
🔒 Ticket Lock	Lock/unlock a ticket to prevent the user from sending messages
📢 Broadcast	Send a message to all open ticket channels at once
🔔 User Notifications	Optional DM notification for users when a staff member replies
🎮 Dynamic Bot Status	Automatically display the number of open tickets in the bot status
🌍 Multilingual	German and English included, easily extensible
🗄️ SQLite	No external database required — file is created automatically
🔄 Auto-Update Check	Checks for new GitHub releases on startup and notifies with update instructions

🔗 MSK Transcript Service

Instead of sending transcripts as file attachments via DM, the bot can upload them to www.msk-scripts.de and generate a public link — accessible in any browser, no download required.

Subscription Tiers

Feature	Basic (free)	Premium (€5/mo)	Premium+ (€10/mo)
Transcript as link	✅	✅	✅
Max. transcript size	10 MB	100 MB	250 MB
File attachments in transcript	❌	✅	✅
Max. attachment size per ticket	—	150 MB	500 MB
Custom domain	❌	✅	✅
Storage duration	30 days	60 days	90 days

Premium and Premium+ are unlocked via GitHub Sponsors.

Getting your API Key

Visit www.msk-scripts.de/verify
Sign in with your GitHub account
Connect your Discord account
Select your server → your API key is generated instantly

Then add it to your .env:

MSK_API_KEY='your_api_key_here'
MSK_API_URL="https://www.msk-scripts.de"

Custom Domain (Premium & Premium+)

Premium users can serve transcripts under their own domain (e.g. tickets.yourserver.com).

Visit www.msk-scripts.de/dashboard after verifying
Enter your domain and set a DNS A-Record pointing to the server IP shown
Click "Check DNS" once propagation is complete — SSL is set up automatically

📖 Full setup guide: docu.msk-scripts.de

📁 Project Structure

discord_ticketbot/
├── index.js                    # Entry point
├── package.json
├── .env.example                # Environment variable template
├── ticketbot.service           # systemd unit file for Linux servers
├── assets/                     # Static files (logo, banner images)
│   ├── logo.png                # Panel logo thumbnail (place your own here)
│   └── banner.png              # Panel banner image (place your own here)
├── config/
│   ├── config.example.jsonc    # Configuration template (with comments)
│   └── snippets.example.jsonc  # Canned responses template
├── docs/
│   ├── setup-en.md             # MSK Transcript Service setup guide (English)
│   └── setup-de.md             # MSK Transcript Service setup guide (German)
├── locales/
│   ├── de.json                 # German
│   └── en.json                 # English
├── data/
│   └── tickets.db              # SQLite database (auto-created)
└── src/
    ├── client.js               # Extended Discord Client
    ├── config.js               # Config loader & validation
    ├── database.js             # All DB operations (SQLite)
    ├── handlers/
    │   ├── commandHandler.js   # Loads & registers slash commands
    │   ├── eventHandler.js     # Loads Discord events
    │   └── componentHandler.js # Loads buttons, modals, menus
    ├── commands/               # Slash commands
    │   ├── setup.js            # /setup      – Send panel
    │   ├── close.js            # /close      – Close ticket
    │   ├── add.js              # /add        – Add user
    │   ├── remove.js           # /remove     – Remove user
    │   ├── claim.js            # /claim      – Claim ticket
    │   ├── unclaim.js          # /unclaim    – Unclaim ticket
    │   ├── move.js             # /move       – Move ticket
    │   ├── rename.js           # /rename     – Rename channel
    │   ├── transcript.js       # /transcript – Generate HTML transcript
    │   ├── priority.js         # /priority   – Set priority (topic + embed)
    │   ├── note.js             # /note       – Staff notes
    │   ├── blacklist.js        # /blacklist  – Block users
    │   ├── stats.js            # /stats      – Statistics (server & user)
    │   ├── snippet.js          # /snippet    – Send canned responses
    │   ├── broadcast.js        # /broadcast  – Send to all open tickets
    │   └── lock.js             # /lock       – Lock/unlock ticket
    ├── events/
    │   ├── ready.js            # Bot start, status, auto-close & staff reminder loop
    │   ├── messageCreate.js    # Activity tracking + DM notifications
    │   └── interactionCreate.js # Route all interactions
    ├── components/
    │   ├── buttons/
    │   │   ├── openTicket.js       # tb_open
    │   │   ├── closeTicket.js      # tb_close
    │   │   ├── claimTicket.js      # tb_claim
    │   │   ├── unclaimTicket.js    # tb_unclaim
    │   │   ├── moveTicket.js       # tb_move
    │   │   ├── deleteTicket.js     # tb_delete
    │   │   ├── deleteConfirm.js    # tb_deleteConfirm
    │   │   ├── deleteCancel.js     # tb_deleteCancel
    │   │   ├── rateTicket.js       # tb_rate:N
    │   │   └── notifyToggle.js     # tb_notifyToggle
    │   ├── modals/
    │   │   ├── closeReason.js      # tb_modalClose
    │   │   └── ticketQuestions.js  # tb_modalQuestions:type
    │   └── menus/
    │       ├── panelSelect.js      # tb_panelSelect
    │       ├── ticketType.js       # tb_selectType
    │       └── moveSelect.js       # tb_moveSelect
    └── utils/
        ├── logger.js           # Coloured console logger
        ├── embeds.js           # All embed constructors
        ├── transcript.js       # Self-contained HTML (avatars embedded as Base64)
        ├── mskApi.js           # MSK Transcript Service API client
        ├── ticketActions.js    # Core logic: openTicket, performClose, performMove
        ├── versionCheck.js     # Startup update check against GitHub releases
        └── snippets.js         # Snippet loader & placeholder engine

⚙️ Slash Commands

Command	Permission	Description
`/setup`	Administrator	Send the ticket panel
`/close [reason]`	Configurable	Close the current ticket
`/claim`	Staff	Claim a ticket — updates topic & embed, button toggles to Unclaim
`/unclaim`	Staff	Release a claimed ticket — updates topic & embed, button toggles back
`/move`	Staff	Move ticket to a different type/category
`/add <user>`	Staff	Add a user to the ticket
`/remove <user>`	Staff	Remove a user from the ticket
`/rename <name>`	Staff	Rename the ticket channel
`/transcript`	Staff	Generate an HTML transcript
`/priority <level>`	Staff	Set ticket priority (updates channel topic & embed)
`/note add <text>`	Staff	Add a staff note
`/note list`	Staff	List all notes for this ticket
`/stats`	Staff	Server-wide ticket statistics
`/stats @user`	Staff	Detailed statistics for a specific user
`/blacklist add`	Manage Guild	Block a user
`/blacklist remove`	Manage Guild	Unblock a user
`/blacklist list`	Manage Guild	Show the blacklist
`/snippet send <name>`	Staff	Send a canned response into the ticket
`/snippet list`	Staff	Show all available snippets
`/lock lock [reason]`	Staff	Lock ticket — user cannot send messages
`/lock unlock`	Staff	Unlock ticket — restore user message access
`/broadcast <message>`	Staff	Send a message to all open ticket channels

🔘 Ticket Buttons

Every ticket channel contains a button row at the top:

Button	Visible when	Description
🔒 Close Ticket	Always (configurable)	Disables all buttons, generates transcript, closes & renames channel
🙋 Claim	`claimButton: true`, not yet claimed	Staff claims — topic & embed update, button becomes Unclaim
🙌 Unclaim	`claimButton: true`, already claimed	Staff releases — topic & embed update, button becomes Claim
🔀 Move	More than 1 ticket type configured	Staff opens type selection (staff only)
🗑️ Delete Ticket	After closing	Deletes the channel after confirmation
🔕 Notify me	`userNotifications.enabled: true`	User opts in to DM notifications when a staff member replies

🗄️ Database Schema

The SQLite database is created automatically at data/tickets.db. Columns are added automatically via migration if they are missing.

Table	Contents
`tickets`	All tickets: status, type, priority, claim, lock, notify, reminder, transcript
`blacklist`	Blocked users with reason and timestamp
`staff_notes`	Private staff notes per ticket
`ratings`	Ratings (1–5 ⭐) with optional comment

Columns added in recent updates:

Column	Default	Purpose
`locked`	`0`	Whether the ticket is currently locked
`notify_on_reply`	`0`	Whether the creator opted in to DM notifications
`last_notify_sent`	`NULL`	Timestamp of the last notification DM (30-min cooldown)

🌍 Adding a New Language

Copy locales/de.json, e.g. as locales/fr.json
Translate all strings
Set "lang": "fr" in config/config.jsonc

📝 License

AGPL-3.0 — Source code must remain open and be published under the same license when distributed or hosted.

Forks and modifications that remove or bypass the MSK Transcript Service integration are not permitted.

✨ Features​

🔗 MSK Transcript Service​

Subscription Tiers​

Getting your API Key​

Custom Domain (Premium & Premium+)​

📁 Project Structure​

⚙️ Slash Commands​

🔘 Ticket Buttons​

🗄️ Database Schema​

🌍 Adding a New Language​

📝 License​