A chatbot for the DopefishLives online streaming community.
- Parse and track topic changes
- Provide an accessible API of changes and derived stats
- ???
???
sessions:
| session_id | streamer | activity | start_timestamp | end_timestamp | raw_topic_string | fk_activities_mapping |
|---|---|---|---|---|---|---|
| 0 | skwid | dark souls | SQL_TIMESTAMP | SQL_TIMESTAMP | 'Streamer: Skwid | Game: Dark Souls | #dopefish_gdq' | 0 |
| 1 | mcskwid | dark souls 2 | SQL_TIMESTAMP | SQL_TIMESTAMP | 'Streamer: McSkwid | Gaem: Dark Souls 2' | 1 |
activities_mapping:
| activities_mapping_id | activity_raw | fk_activity_types |
|---|---|---|
| 0 | game | 0 |
| 1 | gaem | 0 |
activity_types:
| activity_types_id | activity_type |
|---|---|
| 0 | game |
| 1 | movie |
Commands:
- !(played|lastplayed) - Last known session of a game/streamer
- !firstplayed - First known session of a game/streamer
- !totalplayed - Total playtime across all sessions of a game/streamer + first session + last session + average session length
- !currentlyplaying - Current session information
- !playedToday - A totalplayed limited to the last 24 hours
- !discord - A link to the discord server
- !onDemand - A link to the On Demand page
Options:
- These are valid for lastplayed, firstplayed, and totalplayed
- g: specific activity (e.g. g: dark souls)
- s: specific streamer (e.g. s: skwid)
- t: specific activity type (e.g. t: movie)
- e: excludes from the activity. Comma delimited (e.g. searching for the first dark souls game: e: 2, 3, remastered, i)
Many thanks to GoaLitiuM for the original version of this bot that has serviced the community for many years!
The original implementation was in Perl and was well over 4000 lines long! I hope to be able to replicate the original functionality with this project.