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

[Kid Kaos]

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