USA cup stats

akickku · 05-28-2005, 03:31 PM

Are being calculated by my deep and cunning brain. Also I'll be updating league match stats to include attendance and weather occurences as they've been requested. Soooo what do you want to see in a cup stats, I've got a few things that I want to do.

1) Flag cupsets
2) Count home/away matches
3) Final round count
4) Win/Loss Percentage
5) Rating averages as well as match display, as well as averaging all the above nuggest of stat glory

I can do more if I deem it worthy :-) so post your suggestions here. FYI, I'm porting all my code to a more powerful machine in addition to making tons of updates, so week 1 stats for season 26 might be a bit delayed. This is mainly due to a fairly pathetic technical issue. I was running all this stuff on a laptop using a dialup connection. The laptop has a busted cd rom drive so it won't read discs any more. It also doesn't have a NIC card so it's not like I can network it easily. I had the presence of mind to upload all my source to my webserver, but some key stuff was forgotten, mainly my test database. Which shouldn't be an issue since I'm gonna rebuild all my stats anyway. To make this rambling a bit shorter, I forgot to do some stuff, but it shouldn't be an issue in the future because of the massive updates I've got planned.

Havok · 05-28-2005, 04:16 PM

your site rocks akickku.... we need you to take over the FOFC rankings aswell!!!

sterlingice · 05-29-2005, 01:29 PM

Wow. I had never seen your site before- those are awesome.

Only one suggestion to add for the cup ratings (or maybe I just didn't see it)- have record and GD by series.

SI

Alf · 05-30-2005, 03:30 AM

akickku, you site speeds like lightning. Mine is slow as hell. How could I improve my "site speed" ?

akickku · 05-30-2005, 08:36 AM

Well its probably poor database design, but I don't care. I was having speed issues until I seperated my data. I've got all my league data seperated by season instead of in one massive database. It's cheating but it works.

Poli · 05-30-2005, 08:53 AM

Thumbs up, akickku.

Alf · 05-30-2005, 08:53 AM

well, I have all data separated by season already, but was planning on merging them all for easier sql requests. And I know my database design is not great

Plus I do some caching on my pages (generate them once and then, they have a TTL of 86400 seconds), hence not generating sql resuests each time.

Gotta consult my MySQL gurus again

finkenst · 05-30-2005, 11:46 AM

i'd like to see series dreamteam??

sterlingice · 05-31-2005, 01:25 AM

What happened to the Series Rating Rank this week?

SI

Mr. Wednesday · 05-31-2005, 01:29 AM

Quote:

Originally Posted by Havok

your site rocks akickku.... we need you to take over the FOFC rankings aswell!!!

Not really, I shouldn't think...

akickku · 05-31-2005, 07:21 AM

I don't scan non USA clubs so that might take additional programming.

Havok · 05-31-2005, 10:59 AM

Quote:

Originally Posted by Mr. Wednesday

Not really, I shouldn't think...

Would be nice to have them again.

Mr. Wednesday · 05-31-2005, 12:32 PM

I've posted info through week 25.14... if FrogMan isn't up to continuing to do them, I can post rankings as well when I do week 26.01 (planned for tonight). The downside would be that you would lose a few of the things he keeps track of (e.g. team age in weeks), I track highest-ever rating by date and not by week, and my rating history for highest-ever rating and/or ranking might not be accurate since I don't have any history for before I started downloading the data.

Mr. Wednesday · 05-31-2005, 12:34 PM

Dola, my biggest problem is that I'm pushing the limits on my webspace quota, so I'd be a bit limited in how much history I could keep. I haven't actually checked where I sit quota-wise, but with a full season of both USCHO and BigSoccer rankings in the space currently, I've got to be pretty close.

Mr. Wednesday · 05-31-2005, 12:35 PM

Double-dola, I think I've calculated rankings through 25.14 for FOFC, so while I could also post rankings for that week, any earlier rankings would still show the current max ranking and max rating data.

sterlingice · 05-31-2005, 12:54 PM

Where are the FOFC stats posted, btw?

SI

Mr. Wednesday · 05-31-2005, 12:57 PM

The info that I've posted is in threads names like "Ratings for week 25.14". FrogMan's most up-to-date rankings I think get posted to the same threads, or else to threads with "Ranking" in the title. His website can be found in the sign-up thread.

akickku · 05-31-2005, 06:17 PM

Quote:

Originally Posted by Mr. Wednesday

Dola, my biggest problem is that I'm pushing the limits on my webspace quota, so I'd be a bit limited in how much history I could keep. I haven't actually checked where I sit quota-wise, but with a full season of both USCHO and BigSoccer rankings in the space currently, I've got to be pretty close.

Wouldn't be too much of an issue for me to host it. I could setup an fofc ftp account if you'd like.

Mr. Wednesday · 05-31-2005, 06:35 PM

That would be great; I don't want to go ahead with anything unless we have a hand-off from FrogMan, though.

Havok · 05-31-2005, 10:59 PM

Frogman has a serious FM2005 addiction(as do i), so i don't think it will be a problem

sterlingice · 06-23-2005, 04:26 PM

I don't suppose you ever implemented the cup stats?

SI

akickku · 06-23-2005, 09:59 PM

Working on coding it actually.

sterlingice · 09-30-2005, 01:32 PM

Tho it looks like the coding is still being done on the cup stuff, I've gotta say that ever since getting the link added to Foxtrick, your site is what I use to do game planning- it's great. Fast, reliable, clean to read, but full of stats.

For anyone not using this yet, shameless bump

And for people on Foxtrick, it's the little American flag.

SI

MikeVick7 · 09-30-2005, 04:47 PM

What kinda game-planning do you do with Akicku's site SI?

sterlingice · 09-30-2005, 07:07 PM

I love being able to, at a glance, see trends as to which side a player favors, strongest part of the team, etc. There's still no substitute for looking at previous match reports but this is a good quick way to get a cursory glance at what's going on.

SI

MikeVick7 · 09-30-2005, 07:12 PM

Oh...duh. Yeah I guess you can find R/C/L breakdowns. Good point. I just always counted on Hattrix Backdraft for that. Same thing minus the pics I guess.

terpkristin · 09-30-2005, 07:52 PM

I use HT-DoG for the R/C/L stuff. HT-Disarmer of Giants. It's also available as a link using Firefox/Foxtrick.

/tk

sterlingice · 09-30-2005, 09:35 PM

Quote:

Originally Posted by MikeVick7

Oh...duh. Yeah I guess you can find R/C/L breakdowns. Good point. I just always counted on Hattrix Backdraft for that. Same thing minus the pics I guess.

Isn't backdraft one of the pay services, tho? I remember it was nice when it was free, but not worth the money for it.

SI

Mr. Wednesday · 10-01-2005, 01:29 AM

Backdraft is definitely for pay, which is unfortunate. I use the analysis tools in HT Buddy to do the same thing.

MikeVick7 · 10-01-2005, 10:29 PM

Quote:

Originally Posted by sterlingice

Isn't backdraft one of the pay services, tho? I remember it was nice when it was free, but not worth the money for it.

SI

Oh yeah...it's turned into a paid service, but it was fairly cheap and I like how they have the lineups listed all on the same page.

lytic · 10-01-2005, 11:28 PM

nice bump SI. :P

I was like "deja-vu?" and then saw the May date.

rickJ · 10-02-2005, 12:59 PM

Quote:

Originally Posted by MikeVick7

Oh yeah...it's turned into a paid service, but it was fairly cheap and I like how they have the lineups listed all on the same page.

What's annoying is how it seems to be the only thing that correctly does the upper-bound economists calculations correctly. HCP claims I need 2 more economists to max and the charts usually just deal with the $500k-$1mil range.

Alf · 10-03-2005, 03:51 AM

Just a FYI (for ackikku), ahem, my caching system was relying on a "undefined" variable making all pages generate each time... Now that the cache is working, my site speeds like lightning too

05-28-2005, 04:16 PM	#2
Havok College Starter Join Date: Mar 2003 Location: Florida	your site rocks akickku.... we need you to take over the FOFC rankings aswell!!! __________________ Maniacal Misfitz - We're better than you and we know it!

05-29-2005, 01:29 PM	#3
sterlingice Hall Of Famer Join Date: Apr 2002 Location: Back in Houston!	Wow. I had never seen your site before- those are awesome. Only one suggestion to add for the cup ratings (or maybe I just didn't see it)- have record and GD by series. SI __________________ Houston Hippopotami, III.3: 20th Anniversary Thread - All former HT players are encouraged to check it out! Janos: "Only America could produce an imbecile of your caliber!" Freakazoid: "That's because we make lots of things better than other people!"

05-30-2005, 03:30 AM	#4
Alf Pro Starter Join Date: Jan 2001 Location: Rennes, France	akickku, you site speeds like lightning. Mine is slow as hell. How could I improve my "site speed" ? __________________ FOFL - GML - IHOF - FranceStats

05-30-2005, 08:36 AM	#5
akickku n00b Join Date: Jan 2005	Well its probably poor database design, but I don't care. I was having speed issues until I seperated my data. I've got all my league data seperated by season instead of in one massive database. It's cheating but it works. __________________ Owner of Rockin the Suburbs in V.172 USA Hattrick Stats

05-30-2005, 08:53 AM	#6
Poli FOFC Survivor Join Date: Apr 2002 Location: Wentzville, MO	Thumbs up, akickku. __________________ Cheer for a walk on quarterback! Ardent leads the Vols in the dynasty forum.

05-31-2005, 01:25 AM	#9
sterlingice Hall Of Famer Join Date: Apr 2002 Location: Back in Houston!	What happened to the Series Rating Rank this week? SI __________________ Houston Hippopotami, III.3: 20th Anniversary Thread - All former HT players are encouraged to check it out! Janos: "Only America could produce an imbecile of your caliber!" Freakazoid: "That's because we make lots of things better than other people!"

05-31-2005, 07:21 AM	#11
akickku n00b Join Date: Jan 2005	I don't scan non USA clubs so that might take additional programming. __________________ Owner of Rockin the Suburbs in V.172 USA Hattrick Stats

05-31-2005, 12:32 PM	#13
Mr. Wednesday Pro Starter Join Date: Jul 2003 Location: South Bend, IN	I've posted info through week 25.14... if FrogMan isn't up to continuing to do them, I can post rankings as well when I do week 26.01 (planned for tonight). The downside would be that you would lose a few of the things he keeps track of (e.g. team age in weeks), I track highest-ever rating by date and not by week, and my rating history for highest-ever rating and/or ranking might not be accurate since I don't have any history for before I started downloading the data. __________________ Hattrick - Brays Bayou FC (70854) / USA III.4 Hockey Arena - Houston Aeros / USA II.1 Thanks to my FOFC Hattrick supporters - Blackout, Brillig, kingfc22, RPI-fan, Rich1033, antbacker, One_to7, ur_land, KevinNU7, and TonyR (PM me if you support me and I've missed you)

05-31-2005, 12:34 PM	#14
Mr. Wednesday Pro Starter Join Date: Jul 2003 Location: South Bend, IN	Dola, my biggest problem is that I'm pushing the limits on my webspace quota, so I'd be a bit limited in how much history I could keep. I haven't actually checked where I sit quota-wise, but with a full season of both USCHO and BigSoccer rankings in the space currently, I've got to be pretty close. __________________ Hattrick - Brays Bayou FC (70854) / USA III.4 Hockey Arena - Houston Aeros / USA II.1 Thanks to my FOFC Hattrick supporters - Blackout, Brillig, kingfc22, RPI-fan, Rich1033, antbacker, One_to7, ur_land, KevinNU7, and TonyR (PM me if you support me and I've missed you)

05-31-2005, 12:35 PM	#15
Mr. Wednesday Pro Starter Join Date: Jul 2003 Location: South Bend, IN	Double-dola, I think I've calculated rankings through 25.14 for FOFC, so while I could also post rankings for that week, any earlier rankings would still show the current max ranking and max rating data. __________________ Hattrick - Brays Bayou FC (70854) / USA III.4 Hockey Arena - Houston Aeros / USA II.1 Thanks to my FOFC Hattrick supporters - Blackout, Brillig, kingfc22, RPI-fan, Rich1033, antbacker, One_to7, ur_land, KevinNU7, and TonyR (PM me if you support me and I've missed you)

05-31-2005, 12:54 PM	#16
sterlingice Hall Of Famer Join Date: Apr 2002 Location: Back in Houston!	Where are the FOFC stats posted, btw? SI __________________ Houston Hippopotami, III.3: 20th Anniversary Thread - All former HT players are encouraged to check it out! Janos: "Only America could produce an imbecile of your caliber!" Freakazoid: "That's because we make lots of things better than other people!"

05-31-2005, 12:57 PM	#17
Mr. Wednesday Pro Starter Join Date: Jul 2003 Location: South Bend, IN	The info that I've posted is in threads names like "Ratings for week 25.14". FrogMan's most up-to-date rankings I think get posted to the same threads, or else to threads with "Ranking" in the title. His website can be found in the sign-up thread. __________________ Hattrick - Brays Bayou FC (70854) / USA III.4 Hockey Arena - Houston Aeros / USA II.1 Thanks to my FOFC Hattrick supporters - Blackout, Brillig, kingfc22, RPI-fan, Rich1033, antbacker, One_to7, ur_land, KevinNU7, and TonyR (PM me if you support me and I've missed you)

05-31-2005, 06:35 PM	#19
Mr. Wednesday Pro Starter Join Date: Jul 2003 Location: South Bend, IN	That would be great; I don't want to go ahead with anything unless we have a hand-off from FrogMan, though. __________________ Hattrick - Brays Bayou FC (70854) / USA III.4 Hockey Arena - Houston Aeros / USA II.1 Thanks to my FOFC Hattrick supporters - Blackout, Brillig, kingfc22, RPI-fan, Rich1033, antbacker, One_to7, ur_land, KevinNU7, and TonyR (PM me if you support me and I've missed you)

05-31-2005, 10:59 PM	#20
Havok College Starter Join Date: Mar 2003 Location: Florida	Frogman has a serious FM2005 addiction(as do i), so i don't think it will be a problem __________________ Maniacal Misfitz - We're better than you and we know it!

06-23-2005, 04:26 PM	#21
sterlingice Hall Of Famer Join Date: Apr 2002 Location: Back in Houston!	I don't suppose you ever implemented the cup stats? SI __________________ Houston Hippopotami, III.3: 20th Anniversary Thread - All former HT players are encouraged to check it out! Janos: "Only America could produce an imbecile of your caliber!" Freakazoid: "That's because we make lots of things better than other people!"

06-23-2005, 09:59 PM	#22
akickku n00b Join Date: Jan 2005	Working on coding it actually. __________________ Owner of Rockin the Suburbs in V.172 USA Hattrick Stats

09-30-2005, 01:32 PM	#23
sterlingice Hall Of Famer Join Date: Apr 2002 Location: Back in Houston!	Tho it looks like the coding is still being done on the cup stuff, I've gotta say that ever since getting the link added to Foxtrick, your site is what I use to do game planning- it's great. Fast, reliable, clean to read, but full of stats. For anyone not using this yet, shameless bump And for people on Foxtrick, it's the little American flag. SI __________________ Houston Hippopotami, III.3: 20th Anniversary Thread - All former HT players are encouraged to check it out! Janos: "Only America could produce an imbecile of your caliber!" Freakazoid: "That's because we make lots of things better than other people!"

09-30-2005, 04:47 PM	#24
MikeVick7 College Benchwarmer Join Date: Dec 2003 Location: Ron, Mexico	What kinda game-planning do you do with Akicku's site SI? __________________ Hattrick - Seattle Reign (224367)

09-30-2005, 07:07 PM	#25
sterlingice Hall Of Famer Join Date: Apr 2002 Location: Back in Houston!	I love being able to, at a glance, see trends as to which side a player favors, strongest part of the team, etc. There's still no substitute for looking at previous match reports but this is a good quick way to get a cursory glance at what's going on. SI __________________ Houston Hippopotami, III.3: 20th Anniversary Thread - All former HT players are encouraged to check it out! Janos: "Only America could produce an imbecile of your caliber!" Freakazoid: "That's because we make lots of things better than other people!"

09-30-2005, 07:12 PM	#26
MikeVick7 College Benchwarmer Join Date: Dec 2003 Location: Ron, Mexico	Oh...duh. Yeah I guess you can find R/C/L breakdowns. Good point. I just always counted on Hattrix Backdraft for that. Same thing minus the pics I guess. __________________ Hattrick - Seattle Reign (224367)

09-30-2005, 07:52 PM	#27
terpkristin Grizzled Veteran Join Date: May 2003 Location: Ashburn, VA	I use HT-DoG for the R/C/L stuff. HT-Disarmer of Giants. It's also available as a link using Firefox/Foxtrick. /tk __________________ GO TERPS! https://www.flickr.com/photos/terpkristin https://twitter.com/terpkristin

10-01-2005, 01:29 AM	#29
Mr. Wednesday Pro Starter Join Date: Jul 2003 Location: South Bend, IN	Backdraft is definitely for pay, which is unfortunate. I use the analysis tools in HT Buddy to do the same thing. __________________ Hattrick - Brays Bayou FC (70854) / USA III.4 Hockey Arena - Houston Aeros / USA II.1 Thanks to my FOFC Hattrick supporters - Blackout, Brillig, kingfc22, RPI-fan, Rich1033, antbacker, One_to7, ur_land, KevinNU7, and TonyR (PM me if you support me and I've missed you)

10-01-2005, 11:28 PM	#31
lytic College Benchwarmer Join Date: Mar 2003 Location: back in Nebraska (for a couple years)	nice bump SI. :P I was like "deja-vu?" and then saw the May date. __________________ Hattrick stuff: SouthPark Cows' General Manager (Est Season 16) U20 South Korea Trainer (Season 19-22) Hattrick Moderator (since Season 22) Evil Gargs' Hater (since Season 18) -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- My Pro Soccer Story

10-03-2005, 03:51 AM	#33
Alf Pro Starter Join Date: Jan 2001 Location: Rennes, France	Just a FYI (for ackikku), ahem, my caching system was relying on a "undefined" variable making all pages generate each time... Now that the cache is working, my site speeds like lightning too __________________ FOFL - GML - IHOF - FranceStats

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)