More stats from TWD! (vets,squadhoppers,er)

[Arobas+]

It could be possible but how it would be useful?
You already have http://twl.trenchwars.org/?x=stats

[With Ease]

It would be useful because that stats page is broken, it even indicates on it that stats for seasons 7-11 may be inaccurate, which i assure you they are. It says I played 2 games overall season 8, which is probably around 5% of what was actually played. The old TWLM website has the stats for seasons 6-10, with some occasional missing games due to TWLM not being played that weekend. If you need help organizing it into the different seasons I'm sure i can find you game ID ranges for the different seasons (except season 11, I'm not sure of the ID range for that season).

The reason I bring all of this up is because it seems we finally have someone who is capable of doing something. Year after year we play TWL and then have no record of what actually happened, unless you have a lot of time on your hands and access to the old websites. Even knowing the old websites, it would take forever to actually find all of the games, as everything is so completely unorganized. I don't believe the TWL website is what you're working on, but doing all of this is possible via the TWD website which is why I mention it.

I'll guarantee that 99% of the players that are interested in looking at old stats from seasons 6-11 have no way of doing so.

[pascone]

It would be useful because that stats page is broken, it even indicates on it that stats for seasons 7-11 may be inaccurate, which i assure you they are. It says I played 2 games overall season 8, which is probably around 5% of what was actually played. The old TWLM website has the stats for seasons 6-10, with some occasional missing games due to TWLM not being played that weekend. If you need help organizing it into the different seasons I'm sure i can find you game ID ranges for the different seasons (except season 11, I'm not sure of the ID range for that season).

The reason I bring all of this up is because it seems we finally have someone who is capable of doing something. Year after year we play TWL and then have no record of what actually happened, unless you have a lot of time on your hands and access to the old websites. Even knowing the old websites, it would take forever to actually find all of the games, as everything is so completely unorganized. I don't believe the TWL website is what you're working on, but doing all of this is possible via the TWD website which is why I mention it.

I'll guarantee that 99% of the players that are interested in looking at old stats from seasons 6-11 have no way of doing so.

this is accurate

[With Ease]

Now that I think about it, the game ID range to identify seasons may not work so great, seeing as how the playoff games take on an entirely new ID range. A solution to this could possibly be feeding the IDs that the site finds for 'Trench Wars League' level back into the OLD twl website, and then sorting them by DATE, since when the IDs are placed into the old twl website it doesn't just give 00/00/0000 like the TWD website does. This could eventually be further expanded upon if someone was devoted to it, as they could index stats by player names and then finally provide an ACCURATE source for stats (far more accurate than even the old TWLM site).

[Arobas+]

Since season 12, TWL use its own system copied from TWD. That's why it's possible to look at old twl games on the twd website.

I could maybe implement a "WayBack" option to set the website on a specific season. You would see the stats/squads as it was on that season. You could at the same time set the site for TWD or TWL (season 6-11).

[paradise!]

as if princess paradise is better
or was it persia paradise
or princess persia

it was persia paradise.

[Ara]

I should now be there between Jebu and Annul in TOP 100 TWD Veterans (who
registered first and still active)

[Mantra-Slider]

Where is Disoblige in this list?

Top 20 - Games played by a squad since its creation

Thunder  	5451
Paladen 	4358
dicE 		4226
Penetrate 	4104
Brainwave 	2399
Spastic 	2305
Quake 		1862
Mambo 		1811
STONERZ 	1409
Rape 		1334
Warpath 	1251
HappyTrain 	1128
Rapid 		903
Respect 	849
Choleric 	718
Devest 		622
Sake 		540
Pandora 	523
Melee 		487
sage 		439

[Arobas+]

Where is Disoblige in this list?

You are right, my query was wrong.. on the db, we have multiple instance for each squad.. and i forgot to count that.

Here is the new top 30 squads all-time by games played and "completed" (jd/dd/bd/sd)

Disoblige	10716
Sk8		10416
Paladen		9028
dicE		8659
Spastic		8126
Warpath		7845
TeKs		6590
Melee		6236
Anti-Scrub	6221
Gantz		6187
Pirates		6011
Brainwave	5862
Thunder		5596
Ancients	5259
Rejected Basers	5163
Ossify		5088
Pandora		4582
Wingmasters	4516
Mambo		4488
Penetrate	4242
Quicksand	4178
Squad!!		3975
Grapevine	3962
BasingCrew	3866
Savanger	3848
Heavy		3733
BoZ		3724
DragonGuard	3719
Rapid		3624
Syne		3598

[Mantra-Slider]

thats more like it! Disoblige wins the nerds award!!!! :wub:

[Dabram]

YES!!

And for once I'm gonna say Sk8 isn't Thunder, so we're on the top baby!!



Here's a new rule for TWL. ANy squad who has played over 10000 twd games in total receives a lifetime TWL-invite reward. :P

[Black Mage]

Can you sort those stats by leagues, to see which squad has played the most in each league?

[PaulOakenfold]

YES!!

And for once I'm gonna say Sk8 isn't Thunder, so we're on the top baby!!



Here's a new rule for TWL. ANy squad who has played over 10000 twd games in total receives a lifetime TWL-invite reward. :P

welcome Wolvencreed everybody

[Arobas+]

Can you sort those stats by leagues, to see which squad has played the most in each league?

		DD	JD	BD	SD	TOTAL
Disoblige	3691	4448	2380	197	10716
Sk8		3803	4917	1606	90	10416
Paladen		6625	1946	398	65	9034
dicE		2326	4421	1814	104	8665
Spastic		2576	2419	3022	109	8126
Warpath		6486	1041	306	20	7853
TeKs		1069	2313	3019	189	6590
Melee		2956	2717	555	8	6236
Anti-Scrub	767	1709	3626	122	6224
Gantz		5121	726	320	20	6187
Pirates		2167	3203	619	22	6011
Brainwave	2150	958	2650	111	5869
Thunder		1741	3071	741	51	5604
Ancients	1419	3010	782	48	5259
Rejected Basers	992	1084	2968	119	5163
Ossify		4612	335	93	49	5089
Pandora		499	1937	2115	31	4582
Wingmasters	957	3063	447	49	4516
Mambo		275	2773	1351	89	4488
Penetrate	525	696	2998	27	4246
Quicksand	3652	424	89	29	4194
Squad!!		3341	478	131	25	3975
Grapevine	2277	1126	526	33	3962
BasingCrew	712	1053	1957	144	3866
Savanger	3448	360	28	17	3853
Heavy		2873	689	163	8	3733
BoZ		1165	2417	123	19	3724
DragonGuard	2755	644	299	21	3719
Rapid		1551	1678	385	20	3634
Syne		3175	214	180	29	3598

[Kid Kaos]

Gatta be something wrong with you top 100 vets list ive been registered for twd since it first started out.