Changes to the site before the next CS season

Discussion in 'Forum Discussion' started by Cribbage, Jul 7, 2013.

  1. Cribbage RG Cribb

    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.
     
  2. SM MD Dorn

    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 :laugh:
     
  3. zorax ZX Doom

    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.
     
  4. Mousey AJ Son

    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?
     
  5. Cribbage RG Cribb

    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...
     
  6. MightyPies DA Alessi

    I like when things are combines :ninja:

    :laugh:
     
  7. Cribbage RG Cribb

    Just to elaborate on what I mean.. every player match performance ever is in an SQL database with these fields:

    [​IMG]

    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:

    [​IMG]




    As you can see, no references. That's because I still have to input them manually through this:

    [​IMG]



    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. :p
     
    Last edited: Sep 8, 2015
  8. MightyPies DA Alessi

    Good little insight there, i like it!

    Good to know whats behind the scenes of this wizardry!
     
  9. Cribbage RG Cribb

    That VB.net program I spoke of is already over 2000 lines of code :laugh:
     
  10. Gazza GJ Weaver

    Such a classic MP post
     
    Last edited: Sep 8, 2015
  11. Escath LE Schaw

    Such a classic Gazza post.

    @Cribb: When you say no references, isn't the id a reference?
     
  12. Cribbage RG Cribb

    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. :/
     
    Last edited: Sep 8, 2015
  13. AVA T Delonge

    Definitely need something memorable for match number 2000
     
  14. Cribbage RG Cribb

    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.
     
    Last edited: Sep 8, 2015
  15. Cribbage RG Cribb

    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.
     
  16. Cribbage RG Cribb

    I should give it to the Lions. Undefeated in four-five years now!
     
  17. Cribbage RG Cribb

    Or the Griffins. They're looming.
     
  18. stupersteve03 SJ Cambridge

  19. Alex AJ O'Driscoll

    Nope.

    Just counted all of them, we're only on 1981 atm.
     
  20. Hunter AD Hunt

    Ireland.
     

Share This Page