Current League File Broken

[gstelmack]

<DIV>It's still pointing to the week 8 FA file instead of the week 8 gameday file.</DIV>

[wademoore]

<div>It's still pointing to the week 8 FA file instead of the week 8 gameday file.</div><br><br>This is funny...<br><br>A GoogleTalk chat with LS JUST now..<br><br><br><div class="chat out"><br><div class="msg"><br><span class="salutation-o">Wade</span><br><div class="1st">btw</div></div><br><div class="Nth">minor thing</div><br><div class="Nth">I clicked on "current league file"</div><br><div class="Nth">and it wasn't the current league file</div><br><div class="Nth">it was Friday's</div><br></div><br><br><div class="chat in"><br><div class="msg"><br><div class="icon-i"><br></div><span class="salutation-i">lordscarlet</span><br><div class="1st">odd</div></div><br></div><br><br><br><br><div class="chat out"><br><div class="msg"><br><div class="icon-o"><br></div><span class="salutation-o">Wade</span><br><div class="1st">I could get the file from the specific event though</div></div><br></div><br><br><div class="chat in"><br><div class="msg"><br><div class="icon-i"><br></div><span class="salutation-i">lordscarlet</span><br><div class="1st">Is it a mid-week vs. regular week difference?</div></div><br></div><br><br><br><br><div class="chat out"><br><div class="msg"><br><div class="icon-o"><br></div><span class="salutation-o">Wade</span><br><div class="1st">yeah, right now if i go there it's 3-16.zip</div></div><br><div class="Nth">friday's was a mid-week if that's what you're asking</div><br></div><br><br><div class="chat in"><br><div class="msg"><br><div class="icon-i"><br></div><span class="salutation-i">lordscarlet</span><br><div class="1st">that's probably the problem.. hmm..</div></div><br><div class="Nth">I'll look at it tonight</div></div><br><br><br>

[lordscarlet]

Current league file is grabbed as the most recent week/year of the game files. I need to also sort by the file type. :)

[gstelmack]

Current league file is grabbed as the most recent week/year of the game files. I need to also sort by the file type. :)<br><br>I'm not sure how well that will hold up when we get to free agency or Preseason. Do I treat week 3 of the preseason as "week 3 type PreS" (like I do now) or "PreS week 3 type gameday".<br><br>We might need a "Stage" in here. So it breaks down like:<br><br>Stage: FA Week: 1 Type: FA<br>Stage: FA Week: 2 Type: FA<br>...<br>Stage: PreSeason Week: 2 Type: FA<br>Stage: PreSeason Week: 2 Type: GameDay<br>...<br>Stage: Regular Season Week: 1 Type: FA<br>Stage: Regular Season Week: 1 Type: GameDay<br>...<br>Stage: PostSeason Week: 1 Type: GameDay<br><br>or something like that. Or, I need to go back and reorganize everything to combine Stage and Week correctly, so that the weeks run something like 1 - 50:<br><br>Weeks 1-3: Staff Hiring<br>Week 4: Ticket Prices / FA<br>Weeks 5-16: FA<br>Week 17: Draft<br>Weeks 18-22: Late FA<br><br>etc etc<br><br>Have to figure out which way is best. I think the second one fits in better with what you are planning, so I'll just have to redo everything for next season.<br>

[lordscarlet]

Current league file is grabbed as the most recent week/year of the game files. I need to also sort by the file type. :)<br><br>I'm not sure how well that will hold up when we get to free agency or Preseason. Do I treat week 3 of the preseason as "week 3 type PreS" (like I do now) or "PreS week 3 type gameday".<br><br>We might need a "Stage" in here. So it breaks down like:<br><br>Stage: FA Week: 1 Type: FA<br>Stage: FA Week: 2 Type: FA<br>...<br>Stage: PreSeason Week: 2 Type: FA<br>Stage: PreSeason Week: 2 Type: GameDay<br>...<br>Stage: Regular Season Week: 1 Type: FA<br>Stage: Regular Season Week: 1 Type: GameDay<br>...<br>Stage: PostSeason Week: 1 Type: GameDay<br><br>or something like that. Or, I need to go back and reorganize everything to combine Stage and Week correctly, so that the weeks run something like 1 - 50:<br><br>Weeks 1-3: Staff Hiring<br>Week 4: Ticket Prices / FA<br>Weeks 5-16: FA<br>Week 17: Draft<br>Weeks 18-22: Late FA<br><br>etc etc<br><br>Have to figure out which way is best. I think the second one fits in better with what you are planning, so I'll just have to redo everything for next season.<br><br><br>This is when IM would be much easier, but... :)<br><br>Where is the issue here? We have an order for Stages and we have an order for filetypes. I really should be ordering by: year, filetype.order, stage.order, week (descending) and get the first result. Would that not match up?<br>

[gstelmack]

Where is the issue here? We have an order for Stages and we have an order for filetypes. I really should be ordering by: year, filetype.order, stage.order, week (descending) and get the first result. Would that not match up?<br><br><br>Do you have a stage order? The files seem to have:<br><br>Year (2006)<br>Week (8)<br>Type (FA = 1)<br><br>I'm concerned what happens when we get to the offseason and enter free agency. When we get to the 8th week of free agency, what file do you grab? When we get to the 8th week of the regular season and the game day type = 2 while the FA turn type was equal to say 6, I don't want you grabbing the Free Agency file from a while back.<br><br>As I hint above, I *think* your system is okay, I'm just not using it correctly. Although it requires me to not use week = 8 for regular season week 8. I need to match up your concept of "week" to FOF's concept of "stage".<br>

[lordscarlet]

Where is the issue here? We have an order for Stages and we have an order for filetypes. I really should be ordering by: year, filetype.order, stage.order, week (descending) and get the first result. Would that not match up?<br><br><br>Do you have a stage order? The files seem to have:<br><br>Year (2006)<br>Week (8)<br>Type (FA = 1)<br><br>I'm concerned what happens when we get to the offseason and enter free agency. When we get to the 8th week of free agency, what file do you grab? When we get to the 8th week of the regular season and the game day type = 2 while the FA turn type was equal to say 6, I don't want you grabbing the Free Agency file from a while back.<br><br>As I hint above, I *think* your system is okay, I'm just not using it correctly. Although it requires me to not use week = 8 for regular season week 8. I need to match up your concept of "week" to FOF's concept of "stage".<br><br><br>Remember that I created this with an ignorance of FOF for the most part. :) If we need to change something we certainly can. But what I currently have is:<br><br>Stages<br><ul><li>Name</li><li>Order</li></ul>examples: Mid-Week, Game Day, Regular<br><br>Filetypes<br><ul><li>Name</li><li>Order</li></ul>Filetypes_stages<br><ul><li>stage_id</li><li>filetype_id</li></ul>event_filetype_stage<br><ul><li>filetypes_stage_id</li><li>event_id</li><li>week</li><li>year<br></li></ul>examples: Regular Season, Preseason, Free Agency<br><br>I think Filetype is closer to stage in FOF? I know it's rather convoluted, but it works. :)<br><br>So 2006 would have:<br>Filetype: Free Agency<br>Stage: Regular<br>Event: 1234<br>Week: 1<br>Year 2006<br><br>Filetype: Free Agency<br>
Stage: Regular<br>
Event: 1235<br>
Week: 2<br>
Year 2006<br>

.<br>.<br>.<br>Filetype: Preseason<br>

Stage: Mid-week<br>

Event: 1240<br>

Week: 1<br>

Year 2006<br><br>


Filetype: Preseason<br>
Stage: Game Week<br>
Event: 1240<br>
Week: 1<br>
Year 2006<br>

.<br>.<br>.<br>Filetype: Preseason<br>

Stage: Game Week<br>

Event: 1240<br>

Week: 4<br>

Year 2006<br>


<br>Filetype: Regular Season<br>


Stage: Mid-week<br>


Event: 1240<br>


Week: 4<br>


Year 2006<br>



<br><br>etc, etc<br><br>Is that making sense? And will that work?<br>

<br>

[gstelmack]

<DIV>Ah, got it. I'm misusing the filetype then. I'll need to fix that.</DIV><DIV></DIV><DIV>My problem remains though that within a given season"week"therecan be 2stages: gameday and a midweek run. All of the above works for everything but when we are actually simming games, where I need a way to differentiate these two submissions. I was using filetype for that (sticking it on the back end of the sort instead of the front end of the sort).</DIV>

[lordscarlet]

<div>Ah, got it. I'm misusing the filetype then. I'll need to fix that.</div><div></div><div>My problem remains though that within a given season"week"therecan be 2stages: gameday and a midweek run. All of the above works for everything but when we are actually simming games, where I need a way to differentiate these two submissions. I was using filetype for that (sticking it on the back end of the sort instead of the front end of the sort).</div><br><br>I think the sort is the problem. I didn't take into account the stages of a week, so I need to fix that. I'll do it by the order for a stage, and if you want to change the order you can do that through the site.<br>

[gstelmack]

<DIV>Well, tonight I'm getting a 550 Internal Server Error trying to upload the week 9 FA turn. If you want the real file to test with, grab it from <A href="http://www.gstelmack.com/woof/woof_export2007-03-20.zip">http://www.gstelmack.com/woof/woof_export2007-03-20.zip</A>.</DIV>

[lordscarlet]

Ugh. It's not getting an error in the log file, so this could take some time to figure out.

[gstelmack]

<DIV>1) Still broken. It's showing Tuesday's turn instead of tonight's.</DIV><DIV></DIV><DIV>2) May or may not be caused by me trying to replace the file for tonight's turn (event 27), and the game sticking with the first uploaded league file. So replacement of league files is not working.</DIV>

[lordscarlet]

<div>1) Still broken. It's showing Tuesday's turn instead of tonight's.</div><div></div><div>2) May or may not be caused by me trying to replace the file for tonight's turn (event 27), and the game sticking with the first uploaded league file. So replacement of league files is not working.</div><br><br>1) Yeah, I haven't fixed the ordering problem yet.<br>