Where are the Cheers (with Bits) in the database?



PhantomBot Version: (Revision: 6e994fd9)
OS Version: Centos 6.9 Final
Java Version: 1.8.0_131-b11
Browser and Version (for Panel Support): Firefox
Stock PhantomBot: Yes

I just wanted to ask if there is a table in the database where cheers with bits on twitch get stored seperatly?
The donations obviously get saved in phantombot_donations but i couldn’t find something similar for the bits cheers.

Are they even saved? If yes where can i find them?

Thanks in advance :heart:


At the moment, there’s no tracking for total bits over time unfortunately.


As an aside, later this year, when we look to migrate to Helix, Twitch’s new API, they do provide a Bits Leaderboard API endpoint which will allow polling the top 100 bit providers. It also indicates that a user can be looked up as well for a channel – however, keep in mind that due to rate limits it would not be very feasible to pull that data for every user.