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.


This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.