Pulling player all players' points info from the database into a text file manually, maybe?


#1

PhantomBot Version: 2.4.0.3
OS Version: Windows 10 64bit
Java Version:
Browser and Version (for Panel Support): Chrome Latest
Stock PhantomBot: Yes

I guess this is a bit of a feature request, I don’t know. I realize the Data Render Service exists, however I need something more on-demand and DRS is a tad too slow for what I need (and I 100% undestand why).

What I’m trying to do is to add an on-stream leaderboard of the people on the channel with the most points. I realize there is a command for that but it’s a bit cluttered for Twitch chat IMO which is why I would prefer it that way. I’m expecting a large amount of points usage from viewers, so it would need to be updated every 5 minutes or so. Since it’s for OBS to read, it could be parsed to a simple text file; I believe that would be the easier route. I also know there’s a high CPU usage in this; I personally think it won’t be a problem.

What do you guys think, is this possible? I don’t mind trying my hand on scripting it, I just need a pointer to the right direction I think.


#2

What I personally did was I created a php script on my website and used JavaScript to make ajax requests to the script.

With use of the HTTP API for the database, you can basically pull any info from your database file.

But if you’d like it to be in a text file, it’s possible. You’d just need to create a custom script or modify the pointSystem (or top command system) to include a timer to write to the file every X.


#3

Do you believe writing a custom script would be simpler? I’ll have a look at how pointSystem works


#4

It’d probably be easier to modify the top command because it does all the legwork for you, all you’d have to do is make it write to the file.