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
LockIn overview
My role
  1. 01Built voice session tracking that monitors specific study channels and ignores connection blips so study time stays accurate.
  2. 02Recorded study sessions with start and end times in PostgreSQL, updating daily and monthly totals in a single step.
  3. 03Calculated calendar-day study streaks in Philippine time (Asia/Manila) with evening reminders before the midnight cutoff.
  4. 04Designed a 20-badge achievement system that rewards study consistency, marathon sessions, and leaderboard milestones.
  5. 05Created responsive slash commands (/stats, /leaderboard, /streak, /profile, /badges) backed by fast indexed queries.
  6. 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
Study leaderboard
Midnight Manila streaks
Badge unlock alerts
Voice session logs
#locked-in-pics desk proof
Critical admin alerts

Captured from the live study server: leaderboards, midnight streak resets, milestone badge alerts, voice session logs, community desk photos, and emergency alerts.