Telegram bot for signing up for a game of Mafia and for sending notifications

Project description:
Telegram bot for automating player registration for offline Mafia games.
The bot allows users to register for the nearest game, choose a date and time, receive reminders, or postpone registration ("remind me later").
Every Monday, the bot automatically updates the list of participants — removes old registrations, sends notifications about the new game, and allows users to register again.

The bot also supports mass messaging, reminders about upcoming games, and has a simple interface in Telegram.
The solution is suitable for any offline events, not just Mafia — the bot easily adapts to other event formats.

Functionality:

User registration for the game via Telegram

Game reminders or postponed notifications (“remind me later”)

Automatic cleaning of the participant list every Monday

Mass messaging to participants

Flexible admin panel for viewing registrations

Technologies used:

Python — main development language

Aiogram — asynchronous Telegram Bot Framework

SQLite / PostgreSQL — storing user data and registrations

Asyncio — scheduling weekly tasks (cleaning and messaging)

Logging — maintaining logs of events and errors