OSFL Draft Utility

[marc]

We'll look into it. Please don't edit your preference lists for now, since there's a good chance we'll need to clear all lists to fix the issue. This goes for people who aren't experiencing the problem as well.

Andrew, sent you some IMs but you are offline, here's what I sent:

ok, I see why this is happening as the script exlcudes the non player lines but does advance the dclassid increment, however, it did't affect mine or the vNFL draft so I can only assume that it's because of VPIs utility

the easiest solution is to export the dutil_class table to csv, manually create the dclassid column then import the amended csv into your db

marc.

[Andrew]

Hmm. It's still adding the player with id #127 for some reason so the issue is definitely with VPI's utility. I don't have time to work on it tonight though. Hopefully I can get it up and running by the time the draft starts tomorrow.

[Guest]

Well, maybe your logging in as admin did something, because now it's letting me build a preference list!

[aholbert]

Well, maybe your logging in as admin did something, because now it's letting me build a preference list!

I can build one but I can remove people from the list and I when I tried to add a CB it added a FB instead.

[Guest]

Yup. I can add my guys.

[Guest]

Yup. I can add my guys.

Scratch that. It adds a different guy than the one I add, after the first addition. I can't do much with it right now, and I'll be on the road from roughly 8am-3:30pm tomorrow. I hope I don't hold things up, but if I can't add guys to the utility before I leave tomorrow morning, it's going to be unavoidable. :(

(What can't we edit our own posts?)

[aholbert]

Scratch that. It adds a different guy than the one I add, after the first addition. I can't do much with it right now, and I'll be on the road from roughly 8am-3:30pm tomorrow. I hope I don't hold things up, but if I can't add guys to the utility before I leave tomorrow morning, it's going to be unavoidable. :(

(What can't we edit our own posts?)

Dont worry about that. Your first pick isnt until pick 29 and I doubt we will get there before 3:30 tomorrow.

[Jistic]

I can build one but I can remove people from the list and I when I tried to add a CB it added a FB instead.

Ditto. I was trying to add a D lineman and it did a fullback as well.

[Guest]

Dont worry about that. Your first pick isnt until pick 29 and I doubt we will get there before 3:30 tomorrow.

Well, I won't be able to load the utility immediately when I return. I was planning on being able to do that Sunday morning. There may be a delay.

[aholbert]

Well, I won't be able to load the utility immediately when I return. I was planning on being able to do that Sunday morning. There may be a delay.

Thats understandable and you have 12 hrs to make your pick but like I said, based on last year I dont think we will be at pick 29 until late Sunday afternoon-early evening. Dont get me wrong I would love if we were but I doubt it.

[Andrew]

The Draft Utility is fixed!!

It was a lot easier than I thought.

Not that you guys care about the technical details, but I'll explain the issue. When I originally set everything up I didn't have any of the database info so I pieced it together based on what I saw in the utility code. Two of the fields were in the wrong order, including the player ID field. So when I switched them, I moved the player ID to a field that had a datatype of "TINY INT". Unfortunately TINYINt can only store values from -128 to 127. So when any player with an id over 127 was getting stored, it was defaulting to 127, our good friend Mr. Zeiders. Changed the field type to INT and all is solved.

[Guest]

Hey, a bug and a workaround in it....



SkyDog wrote: There's a bug in BPA. If you're around, and a team is on the clock and their utility is on, please go in and pick manually. I'm going to sleep once the Georgia-Alabama game is over.

We had this same problem in the CFL. I looked into it and the fix was to add extra rows to the table that stores the draftees: one row for each position available to be selected as BPA. When entered correctly you will see blank rows at the end of each position on the draft class screen. For example: http://www.fof-ihof.com/draft/draftclass.php
.

Hope this helps.

[Andrew]

Easy enough to fix what exactly is the bug? The utility isn't autopicking?

[Guest]

Easy enough to fix what exactly is the bug? The utility isn't autopicking?

If you choose best player available, or best player at a specific position, it doesn't pick. The fix will take care of that.

[Andrew]

If you choose best player available, or best player at a specific position, it doesn't pick. The fix will take care of that.

Thanks for the heads up! The fix has been implemented.