WebSite: Statistics

[RiiStar]

So i've been abit busy with RL work as of late, but i've spent the better part of this week making sure that this was calculated correctly...

But hey it's a start and you've all wanted this for most of the season!
So here's something for you to oogle at.

http://twl.trenchwars.org/?x=stats

Now i know its not finished and will prolly need tweaking... but...
You can see all TWL Players stats i could generate and searching a player
will bring up that users stats without having to look through em all.

Clicking Player or W/L will change the order the stats are shown,
but basicly from it's normal output to show who has the highest stat trailing down...

I'll hopefully have the little parts of that finished this weekend,
along with the compare tab when i work out exactly how to allow you to choose the players you would like to compare...

Peace, :fear:

[Izor]

THIS STAT PAGE SUCKS FUCK YOU RIISTAR YOU MIGHT AS WELL NEVER DO ANYTHING ELSE FOR TW IF THIS IS THE PRODUCT YOU PUT OUT!!!

lol, its nice to see this up. I doubt theres any way to change this to filter out those preseason games i wasnt trying in that are fucking up my ratio though...

Also, the combined k/d is kinda confusing. But like you said its a work in progress..thanks for getting this all together makes it easier for my articles

[RaCka]

are you sure the win losses are correct? cause mine dont seem to be adding up

[kthx]

Im not going to complain, but it says I have 3 jav kills, lol.

[RiiStar]

I guess i'll explain...

There are 4 tables for 1 match, each has different data in them but also has over lapping data...

• Match
• MatchRound
• MatchRoundUser
• MatchRoundUserShip

In the last 3 there are over lapping fields of data, and some have completely different values in them... Don't ask me why, this is the same as how twd's are set out and the bot records. When i have time i may look at twd's stats page code for ideas.

W/L is the sum of a feild for wins of a game (in one of those tables) and the sum of losses for a game in another table and are combined for all twl games recorded...

Because these are spread out across all these fricken tables i don't know what stuff is good and isn't. I've done my best to pick through em but everyone was bitching at me for stats to look at and asking why the fuck it was taking so long...

Well here is what i have produced so far, like it or code the damn thing ur self and find out why it's not such an EZ task as people think it should be.

[Izor]

we werent flaming you, relax

[Jeenyuss]

can you seperate it by league (and for basing, by ship?) if not that's fine, was just curious.

[ignite ignite]

I appreciate your work, when noone else does jack shit, however, why can't you make the TWL stats page similar to the TWD one. We need to have the 'loss' statistics for both jav and warbird, and can you please separate them as well. I think just a copy of TWD squad statistics would be great.

[Infrared]

hi ignite i cant play next weekendddd

[RiiStar]

can you seperate it by league (and for basing, by ship?) if not that's fine, was just curious.

I can certinly work that in... Over All/LD/LJ/LB i just need time when i have it.

I why can't you make the TWL stats page similar to the TWD one. We need to have the 'loss' statistics for both jav and warbird, and can you please separate them as well. I think just a copy of TWD squad statistics would be great.

If you'd read my 2nd post closely i did say when i had time i was going to look at twd's stat pages for ideas on how my predecessors displayed their stats...

To put it simply people were harassing me for a stats page, i threw this "dirty" page up that at least gives you something to look at now rather than later...

[Infrared]

talk to arobas+ about coding the statistics page

[ignite ignite]

I can certinly work that in... Over All/LD/LJ/LB i just need time when i have it.



If you'd read my 2nd post closely i did say when i had time i was going to look at twd's stat pages for ideas on how my predecessors displayed their stats...

To put it simply people were harassing me for a stats page, i threw this "dirty" page up that at least gives you something to look at now rather than later...

cool, thanks. keep up the good work. make me proud, kiwi.

[ignite ignite]

p.s. the SVS guy Underlord is a God when it comes to bots, talk to him.

[Arobas+]

Statistics page got updated. You can now choose a specific league and select any column to sort it (ascending/descending). We had to make the title for each column shorter due to the amount of columns. But I'm pretty sure you prefer more data than larger titles!

New columns :
G: Number of games
R: Number of rounds
AVK: Average Kill per round
AVD: Average Death per round
AVP: Average Points/Score per game
HW: Highest Wins in a game

Possible, not added :
TP: Total time played
ATP: Average Time played per round
TS: Total points/scores

More improvements to come!
Btw, if you see a bug, tell us here.

[ignite ignite]

It says come back later