[in progress] Player Statistics Web Frontend / Possible Ladder

[-z-]

I had my senior project class today and ran the idea past my professor. He seemed fine with the idea so I'm going forward with it.

I need to narrow down the project scope and figure out what things are most important and what are least important.

Please help me define your expectations of this project as a user, admin, viewer, whatever! Paste links to examples, draw pictures, be descriptive, whatever it takes to get your ideas across.

If I can build a solid match/player statistics base in a decent amount of time, I will expand this project to work with a ladder (this is quite likely to happen if all goes smooth).

Here's an example: [url]http://www.hlstatsx.com/[/url]

[pavlvs]

Sounds awesome! This would be a great thing to have, especially if it could be integrated with a ladder.

A good feature to have is the ability for players to exclude themselves from stats being counted b prefixing their name with some invisible characters. I think one of the servers uses ^4^2 or something.

-z- Wrote:Paste links to examples

[url]http://gulch.mshade.org/stats.php[/url]

[url]http://delight.vapor.com/stats.php[/url]

[url]http://delight.vapor.com/plist.php[/url]

[-z-]

I have the source code for vapor stats and plan on using the database and some of the functions as a base. The gulch stats are crap. I'm sorry. I said it :).

But yes, we'll include the ^4^2 anon bit.

[-z-]

Work on this is slowly moving forward. alpha has provided a parser which is near completion, I'll be working on a frontend towards the end of school. I've been experimenting with calling qstat and through php. Once I'm finished with school, the pace of this project will likely increase but the backend development is what's going to take up the most time.

If there are any SQL gurus around that would like to help out. Please contact me, it'll save me a lot of time and research as I'm only intermediate in my MySQL skills.

[-z-]

The code gets a little confusing with multidimensional arrays -- but maybe I'm just a pussy.

This is one of my favorite lines in the latest revision:

Code:

if (db::count($player_kill_0_sql)>0) { $player_totals[$dm_match['match_id']][$killer['player_id']]=$player_totals[$dm_match['match_id']][$killer['player_id']]+1; }

It calculates the player score totals per match... later it sorts that array to bring the high score to the top of the array and matches the player id with the name.

[img]http://pics.nexuizninjaz.com/images/ony93u9gjcpexuz4ptfy.png[/img]


Map stats are easy so I figured I'd get the basics on that out of the way:

[img]http://pics.nexuizninjaz.com/images/qycf99k8hziy0vjqvkl7.png[/img]

Here's a bigger list with a lot more data imported to the database [url]http://pics.nexuizninjaz.com/viewer.php?file=5yaceajsj94l8clnqbb.png[/url]

long query is long

[img]http://pics.nexuizninjaz.com/images/649jo39e2dx3uq2tyv4h.png[/img]


LOL!


this is out of 344 matches.

[Oat]

Whoa, are you guys trying to get fat by sitting on the computer and pushing your statistics?

[master[mind]]

I'm not on the long list :(. When are you polling again? I want to see how bad I am :).