Project Reality Forums

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

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.

PRSPY can only display the data of the first 64p on a given server

Damn, I never counted the array, but it seems you are correct. Just tested and none of them shows more than 64 players. Meh

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 always be interesting, even if it doest really matter like K/D.

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 :S

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

Talk to 762 guys from FH . They got it working for PR very long time ago

Link: Forgotten Hope 2 Awards

So, someone is already making something similar? Do we have an ETA on this?

'[R-MOD wrote:Nate.;2137471']Link: Forgotten Hope 2 Awards

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

Damn would be interesting to see something like that for PR.

A.Finest wrote:Damn would be interesting to see something like that for PR.

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.tk

It has just started gathering data today so it will take some time to show who are really the best players out there

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.

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.

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

I think it has its uses. But CO-OP is a joke xD

Gametracker was able (at some point) to show played hours and so on even for PR servers.

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!

is this idea is forgotten?

I heard that someone(tm) in PRTA is working on a similar project, but the database will be taken from tracker files, not PRSpy.

As long as it's used for some sort of automatic balancing instead of e-penis growth..

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 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