31 ms·
Is there a place I can view all the sponsor segments I've submitted? It would be nice to see them individually, maybe with stats about how often each one was us
by slang800 7y ago
Is there a place I can view all the sponsor segments I've submitted? It would be nice to see them individually, maybe with stats about how often each one was used and whether or not it is in good standing w/rt voting.
- ajayyy 7y agoRight now, there is no easy way, but you can do it manually following these steps: Get an sqlite DB GUI like this awesome one: https://sqlitebrowser.org/ https://sqlitebrowser.org/ Open up the DB from https://sponsor.ajay.app/database.db https://sponsor.ajay.app/database.db Click browse data and switch to the userNames table. Find the userID for your username in that list and copy it. Go back to the sponsorTimes table and paste your userID into the filter text box under the userID category. Currently, the only easy to access stats are at https://sponsor.ajay.app/stats/ https://sponsor.ajay.app/stats/
- slang800 7y agoThanks, I'll give that a shot.