PRstats site idea
-
- PR:BF2 Contributor
- Posts: 27
- Joined: 2015-08-06 12:50
PRstats site idea
I'm playing with PHP a little bit and I've made a small (web) application which parses PRSpy data and stores it in the database. It extracts server data (name, ip, description, current map, current teams and their scores/kills/deaths, total scores/kills/deaths over time) as well as player data (clan*, name, current game score/kills/deaths, total score/kills/deaths over time).
The idea is to make a website which will display currently populated servers (much like prspy), but also some server stats and player/clan stats. Each server/player/clan would have it's own page on the site with all data available. I could even make dynamic forum signatures (dynamically generated images for each player with their own stats), but that's just an idea. I know it's not much data so it wouldn't be something extraordinary but I guess it could be interesting.
* The clans are stored in a separate table in the database and each user is added to a clan (if he/she has clan tag in the name), so I can easily list clans/clan members and clan data (just combine the data of clan members).
I would like to hear what do you guys think about this idea? Is it worth spending time on building such website? Would you use the site? I would also like to hear from PR devs if it's okay to make this because it would pull the data from PRSpy like every minute in order to have as much precise data as we can.
Here's two screenshot, one is cmd line tool which imports the data (would be run on my server) and other is couple of guys from my (SEX_YU) clan displayed in the database
The idea is to make a website which will display currently populated servers (much like prspy), but also some server stats and player/clan stats. Each server/player/clan would have it's own page on the site with all data available. I could even make dynamic forum signatures (dynamically generated images for each player with their own stats), but that's just an idea. I know it's not much data so it wouldn't be something extraordinary but I guess it could be interesting.
* The clans are stored in a separate table in the database and each user is added to a clan (if he/she has clan tag in the name), so I can easily list clans/clan members and clan data (just combine the data of clan members).
I would like to hear what do you guys think about this idea? Is it worth spending time on building such website? Would you use the site? I would also like to hear from PR devs if it's okay to make this because it would pull the data from PRSpy like every minute in order to have as much precise data as we can.
Here's two screenshot, one is cmd line tool which imports the data (would be run on my server) and other is couple of guys from my (SEX_YU) clan displayed in the database
You do not have the required permissions to view the files attached to this post.
Last edited by Avram on 2016-07-11 11:51, edited 2 times in total.
-
- PR:BF2 Developer
- Posts: 985
- Joined: 2011-06-14 14:13
Re: PRstats site idea
PRSPY can only display the data of the first 64p on a given server, plus if I'm not mistaken PRSpy rarely has the correct information in the end if the game, ie all kills and points gained between the last query and the end-screen will not be update via PRSPY.
Regarding the metrics, you would only be able to retrieve kills/deaths, points and play time which in my opinion are not worth it.
Instead I would ask the Server administrators if they would be interested in a super efficient super stable script that would run server side and would gather way cooler information.
That plus a cool front end would make this interesting, even if it doest really matter like K/D.
Regarding the metrics, you would only be able to retrieve kills/deaths, points and play time which in my opinion are not worth it.
Instead I would ask the Server administrators if they would be interested in a super efficient super stable script that would run server side and would gather way cooler information.
That plus a cool front end would make this interesting, even if it doest really matter like K/D.
Dont question the wikipedia! Just because it reports different things on different languages does not make it unreliable source!
-
- PR:BF2 Contributor
- Posts: 27
- Joined: 2015-08-06 12:50
Re: PRstats site idea
Damn, I never counted thePRSPY can only display the data of the first 64p on a given server
Code: Select all
Data[n].Players
Well, I worked with what I had (PRSpy data feed), but something like that would be awesome! I might even help on the PHP side (front end app), if actually making a server script like that is even possible :SInstead I would ask the Server administrators if they would be interested in a super efficient super stable script that would run server side and would gather way cooler information. That plus a cool front end would always be interesting, even if it doest really matter like K/D.
edit: Hey, but it seems PRSpy shows top 64 players (ordered by their score) so I say let's make it a feature you have to be in top 64 on the server in order to get registered
Last edited by Avram on 2016-07-11 12:15, edited 1 time in total.
-
- Forum Moderator
- Posts: 3018
- Joined: 2012-07-09 20:44
-
- PR:BF2 Contributor
- Posts: 27
- Joined: 2015-08-06 12:50
Re: PRstats site idea
So, someone is already making something similar? Do we have an ETA on this?
Whoa, this is some big data I don't think I could ever pull something like that myself [at least not while I have job and family] :S'[R-MOD wrote:Nate.;2137471']Link: Forgotten Hope 2 Awards
-
- Posts: 776
- Joined: 2011-06-07 12:27
Re: PRstats site idea
Damn would be interesting to see something like that for PR.'[R-MOD wrote:Nate.;2137471']Link: Forgotten Hope 2 Awards
-
- PR:BF2 Contributor
- Posts: 27
- Joined: 2015-08-06 12:50
Re: PRstats site idea
Not even remotely close to that Forgotten Hope stats page linked above but after ~6 months I finally got some time to knock together a simple front-end for the script I mentioned in the OP: www.prstats.tkA.Finest wrote:Damn would be interesting to see something like that for PR.
It has just started gathering data today so it will take some time to show who are really the best players out there
-
- Posts: 481
- Joined: 2009-09-27 11:36
Re: PRstats site idea
I don't care much for stats but isn't it a little misleading when players active on CO-OP servers are also included? I tried playing coop once recently and had a massive amount of kills by just running around aimlessly with an assault rifle.
-
- Posts: 2784
- Joined: 2009-09-18 10:27
Re: PRstats site idea
Is it possible to take into account time played? I mean, those that can play 4 hours everyday will obviously have more kills.
Not to humblebrag here, I wouldn't be on any leaderboard anyway.
Not to humblebrag here, I wouldn't be on any leaderboard anyway.
-
- Posts: 335
- Joined: 2012-07-07 15:04
Re: PRstats site idea
It's pretty meaningless, but still kinda fun to play around with. Clearly boiling down the game to just kills and deaths is pretty misleading.
But nice work, would love to see it fleshed out further
But nice work, would love to see it fleshed out further
-
- Forum Moderator
- Posts: 1468
- Joined: 2014-03-18 04:47
-
- Posts: 1090
- Joined: 2013-07-28 13:19
Re: PRstats site idea
Gametracker was able (at some point) to show played hours and so on even for PR servers.
- Mineral
- Retired PR Developer
- Posts: 8533
- Joined: 2012-01-02 12:37
- Location: Belgium
Re: PRstats site idea
FH2's tracker really worked with custom server side code. Which is really the only real way to do proper stat tracking. PRSPY is simply incomplete and outside of a few items doesn't offer much at all.
Nice start however, i like it!
Nice start however, i like it!
- Suchar
- PR:BF2 Lead Developer
- Posts: 2176
- Joined: 2016-10-12 13:25
- Location: Poland
Re: PRstats site idea
I heard that someone(tm) in PRTA is working on a similar project, but the database will be taken from tracker files, not PRSpy.
-
- Posts: 7334
- Joined: 2008-01-05 14:53
Re: PRstats site idea
As long as it's used for some sort of automatic balancing instead of e-penis growth..
Xact Wicca is The Joker. That is all.
-
- Posts: 318
- Joined: 2006-12-15 14:20
Re: PRstats site idea
Tbh, the attitude of some players changed for the worse when we had prstats for a few months.
I am quite happy we don't have any site showing kills and deaths based on that.
I am quite happy we don't have any site showing kills and deaths based on that.
-
- Posts: 1027
- Joined: 2008-09-02 05:07
Re: PRstats site idea
I can imagine how it might have been.. But cant we simply come up with a ranking system based on points you get from doing all the stuff you do in PR? I mean killing is going to be a part of it but it can be nerfed to the point that killing in and of itself wont get you to the higher ranks