WebSite: Statistics

[Arobas+]

Yeah, I had to fix a little bug :fear:

[PaulOakenfold]

Ardour seemed like he knew what he was doing with all of this when I talked to him about TWLM. I'm not saying Aro or Rii are incapable, but would it hurt to have a third on board, one that is gifted in math?

[PaulOakenfold]

Ardour seemed like he knew what he was doing with all of this when I talked to him about TWLM. I'm not saying Aro or Rii are incapable, but would it hurt to have a third on board, one that is gifted in math?

He's also dealing with number crunching at least once a week with TWLM. I'd donate to get him on board with this even if his programming is sub-prime (sorry bro, from your mouth not mine).

[Arobas+]

Ardour seemed like he knew what he was doing with all of this when I talked to him about TWLM. I'm not saying Aro or Rii are incapable, but would it hurt to have a third on board, one that is gifted in math?

If you have any idea to improve the current system, we accept any suggestion. Btw, the current level of matehmatic involved is pretty low.. some division and addition. Now, if you want to do a regression analysis with X variables for a prediction, that's something else :P

For myself, I prefer 1 big table where I can take all the information I want. If you guys prefer pre-mashed tables with top 30 like TWLM (reference), we will see what we can do.

Sure, there is some kind of statistics that you can't have with the current system like : Your best game in ter with no death, etc.. But the current table give you a lot of data I think!

[PaulOakenfold]

If you have any idea to improve the current system, we accept any suggestion. Btw, the current level of matehmatic involved is pretty low.. some division and addition. Now, if you want to do a regression analysis with X variables for a prediction, that's something else :P

For myself, I prefer 1 big table where I can take all the information I want. If you guys prefer pre-mashed tables with top 30 like TWLM (reference), we will see what we can do.

Sure, there is some kind of statistics that you can't have with the current system like : Your best game in ter with no death, etc.. But the current table give you a lot of data I think!

Well we were talking about a couple simple algorithms that would make everything a lot... well... simpler. I think he's kind of lost interest in these TWL related things since the fallout with Thunder though to be honest. I'm not involved enough in programming and the like to be of much help, but I'd give him a ?message and see if he can be of some help, because he's certainly done a wonderful job with TWLM all by himself.

[Arobas+]

Well we were talking about a couple simple algorithms that would make everything a lot... well... simpler.

But I don't understand what's wrong with the current system? Is it because it's slow to display? Or because there is too many information? The current algorithm is one simple SQL query, can't get more simple than that.

Edit: I just read this thread, were you talking about that?

[PaulOakenfold]

But I don't understand what's wrong with the current system? Is it because it's slow to display? Or because there is too many information? The current algorithm is one simple SQL query, can't get more simple than that.

Oh you are using SQL? I can't figure out why it's slow then. I'm mostly talking about the statistics part of it. Damn, can't really help you here, sorry I brought it up... but really, try contacting Ardour, he may have a good idea and he knows a hell of a lot more than I do.

[Arobas+]

Oh you are using SQL? I can't figure out why it's slow then. I'm mostly talking about the statistics part of it. Damn, can't really help you here, sorry I brought it up... but really, try contacting Ardour, he may have a good idea and he knows a hell of a lot more than I do.

Our system is slower because it's in real-time, but we should add a cache since there is no game during the week. I edited my post ealier, were you talking about http://forums.trenchwars.org/showthread.php?t=35757 ?

[PaulOakenfold]

Our system is slower because it's in real-time, but we should add a cache since there is no game during the week. I edited my post ealier, were you talking about http://forums.trenchwars.org/showthread.php?t=35757 ?

No, this was private a couple of weeks ago, but that's a hint at it.

edit: Seriously, probably too many value systems in place for real time. Again, I'm not the guy to talk to, I was just providing some ideas.
edit2: Thanks for being open Arobas+, in my professional experience, that's the best step towards improvement. I hope you learn a lot from this, and we do as well. Godspeed.

[Arobas+]

Thx anyway :P We will see what we can improve, I will ?message Ardour

[Ardour]

The twl stats part of the website coming along nicely! You can now see accumulative totals from seasons 7 through to 11. Very nice work arobas+!

[Arobas+]

I have to thx also Ardour who helped with the old database!

[Infrared]

This is looking great so far, your work is hugely appreciated.

I'm wondering about the old twl website though, particularly the player search feature, which showed statistics of every twl game a player played, with links to the games. My favorite part of it was that you could see all past squads of any player including players who are not currently active in twd. This feature was incredibly useful.. and addicting. Was incredibly helpful in scouting out players before recruiting, with the ability to check past squads of a name they used to use etc.

Also, another great feature would be a filter to filter out preseason, regular season, and playoffs. If that is possible a good setup for this would be sorta like..

Include results from..
[] (checkbox) preseason
[] Regular season
[] Playoffs

[Save and Refresh]

[Salubrious]

Sorry to spelling nazi you but...

"Seasons: 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 - 11 - 12 (stats for season 7-11 may be inacurrate)"

inaccurate

otherwise, looks good

[Nethila]

Player  	Squad  	G  	SPK 	TRK 	SRK 	JTK 	STK   	FT 	W  	L  	AVK  	HW  	AVD  	AVP  	RT  	LO  	SUB  	TP
Nethila  	Anti-Scrub  	1  	43 	2 	30 	0 	0   	0 	75  	7  	75  	75  	7  	19211  	32428  	0  	0  	0:21:38

ah, memories