Note: This section is now in read-only mode.
Please use our new community site for future posts.

Back To Board

RE: Settled?

Posted By John Meredith

This is a bit on the technical side, but what is being suggested here is just not possible. The list of draft picks are sorted by a field in the database called "slot_no". Between the time in mid last season, when the picks are set up for trading, and when the order is set randomly, everyone has their "slot_no" for that pick set to null. When the Random draft Order is run each "slot_no" is updated with an integer that is essentially each teams pick order in the draft. So, before each team is assigned a number, when you pull back the draft order report, you get a list of teams with no number in the pick field, and the red message stating that this is not the true order.(One note about the red message. The Random Draft Order prog. is a bit old and clunky and sometimes takes as much as 5 minutes to run, yech! Anyway, the Red message disapears after the first pick has been handed out, so if you are on the site, and hit refresh enough, you can actually see the order being built, pick by pick. Just wanted to note that as there can be a delay between the time the red message goes away, and the actual order is set.) Before the Draft Order is set, the procedure that returns the list in an ordered fashon is still trying to do its job of ordering, but it sees 24 null values for "slot_no", and sorts the records any way it sees fit. (Usually by insertion into the database, but this is fluid and can change for various reasons). Now we did do something different this year. We announced the draft order on Friday, BEFORE the cut to 27. We usually do this on Saturday, after the cuts. You say that your teams did not change draft positions. However, before the actual order is run, there is no pick number associated with your team (they are blank or in this case "null"). So in order to determine for example that before the order was set, you were listed in the 10th spot, you would have to count down ten spots, and remember that number. Is this what happened? Basically if there is a number in the Pick field of the web page, than the order has been run. If it is not there, than the order has not been run, if half of them are there, than the draft order is still running. I have a database record that clearly shows that the order for Champs(One of your leagues.) was set at 2:40pm on Friday. Before that time, there is no way that the process that displays the draft Order would be able to order the picks in such a way as to be the same as the draft order after it was run on Friday. To put it another way. Last Year, if you looked at the draft order page on Friday night, they would have been out of order, and if you looked again on Saturday after the cuts, they would be different and in order. This year, the draft order was run on Friday, so if you looked on Friday night again, expecting them to be out of order, they would already be set, and of course on Saturday, they would be the same as Friday night. This is what I think probably happened. I have no way of knowing what the "order" was displayed before friday, but I do know that a process occured on Friday afternoon to randomize the order of picks, and that process is completely independent of the display of the order before friday.


Thanks
John Meredith