May 2025 - Apr 2026Discord Bot · Time Tracking
LockIn
A Discord bot for study servers that logs voice channel sessions to track daily streaks, leaderboards, and achievement badges.
Study hours track automatically the moment you join a voice room.
GodiscordgoPostgreSQLsqlcGooserobfig/cronDocker

My role
- 01Built voice session tracking that monitors specific study channels and ignores connection blips so study time stays accurate.
- 02Recorded study sessions with start and end times in PostgreSQL, updating daily and monthly totals in a single step.
- 03Calculated calendar-day study streaks in Philippine time (Asia/Manila) with evening reminders before the midnight cutoff.
- 04Designed a 20-badge achievement system that rewards study consistency, marathon sessions, and leaderboard milestones.
- 05Created responsive slash commands (/stats, /leaderboard, /streak, /profile, /badges) backed by fast indexed queries.
- 06Ensured reliable bot startup with automatic retry loops and crash recovery.
Usage
Study hours by member
665 h · 38 people
Wingman’s Mom210.7 h
Kimobozochi132.6 h
Chin91.8 h
ggbbxx_343546.9 h
hazyliy37.2 h
Anon 43930432.6 h
knightnics17.6 h
jimmyneo15.3 h
Top 8 members. The top five logged 78% of the 665 tracked hours; the median session was 22 minutes.
Details
Captured from the live study server: leaderboards, midnight streak resets, milestone badge alerts, voice session logs, community desk photos, and emergency alerts.