A Discord bot automating challenge verification. Seamlessly tracks participant posts, validates Twitter/LinkedIn links, checks post formats, and auto-assesses eligibility. Features an admin panel for insights and reward distribution. Ensures efficiency, fairness, and reduced moderator effort.
Event ID
Event Name
Start Date
End Date
Users Table:
User ID
Username
User Events Table (junction table for many-to-many relationship):
User ID (foreign key)
Event ID (foreign key)
Last Post Date
Streak Count
b. Language & Libraries:
Python with discord.py for bot functionality.
SQLite or PostgreSQL for relational database management, tracking events, and user participation.
a. Database Schema: Events Table:
Event ID Event Name Start Date End Date Users Table:
User ID Username User Events Table (junction table for many-to-many relationship):
User ID (foreign key) Event ID (foreign key) Last Post Date Streak Count b. Language & Libraries: Python with discord.py for bot functionality. SQLite or PostgreSQL for relational database management, tracking events, and user participation.