That depends if I automate the scorecard uploading or not. The scorecards are basically still part of "old site" if that makes sense. All the stats come from something else. I'm hoping to combine them so I don't have to keep using OldSite anymore.
If you could fix that right now that would be great. Apparently i took 8/102 in an innings somewhere in NZ 2nd XI, No fucking idea when that happened
A satsguru style database query engine would be so beastly. I would expect it to be massively difficult tho; especially if the scorecards are just pure text format now.
Possible to have career stats from each form of the game in a box at the top so you don't have to scroll down for each? Possibly making the season-by-season stats for each boxes capable of being minimized/maximized?
They're converted into a big database so it wouldn't be as difficult as you think, but it'd slow the site down because it'd be SQL heavy. Something I plan on doing if I ever upgrade to dedicated hosting, which would probably require me to actually reply to some of these advertising interests...
Just to elaborate on what I mean.. every player match performance ever is in an SQL database with these fields: You can see a more zoomed in version here: https://dl.dropboxusercontent.com/u/31002207/stats.png Every performance is cross-referenced to a scorecard number, which is in the 'file' field. So a lot of the requests for scorecard links seem very achievable, but these scorecards only exist with those names on my hard drive. The scorecards section of the site database still basically runs off the old site software, and it's a mess with no references. Here's that part of the database: As you can see, no references. That's because I still have to input them manually through this: This input used to calculate player stats as well but it just does the ladder calculations and scorecards now. This is fixable.. I just need to finally kill off that remnant of OldSite by getting my VB program that does a lot of the hard work to save on SQL load to upload the scorecards for me automatically, and reference them. So I plan on doing that but it'd definitely be a pain in the arse.
Yeah but that's the thing; the scorecards database uses those IDs but the performances databases references something different (the filenames). The scorecards database needs to be overhauled to get in line with the rest of the new site. One section of the database thinks that Ireland v Redbacks game is called 20 because that was how OldSite referenced it, but the rest of the site knows it by 01001-M now. Given there have been 1,988 matches in CricSim history, changing these manually isn't an option, and automating the changes would be difficult too, so I think I'm going to just get the VB program that populate the big performances database to populate a scorecards one too.. the big problem with that is that the filenames don't give any clue as to which round anything is in other than just the order of them. :/
You know, this season will actually finish up on 1,999. 7 finals left + 3 N/S FC games + 3 N/S OD games. We definitely need to think of something big to do after that for 2,000. Maybe I should make a thread.
Actually no we're at 1988 not 1986. So the 2000th game will be a N/S game unless I interrupt it and have something else random in there.