FOF MP Draft Utility

[aston217]

For some reason, importing a new draft is not clearing the table of registered users. That should be happening, right?

I know I tinkered with the import code, but not in that area, I thought. I actually tracked down a very old import_draft_run (pre FOF7) file and the import code looks the same, there's no "truncate table team" query run. Only:

// Ok, all is well, first let's clear out the existing draft data
if ($admin) {
  $statement = "truncate table pick";
  mysql_query($statement);
  $statement = "truncate table player";
  mysql_query($statement);
  $statement = "truncate table player_comments";
  mysql_query($statement);
  $statement = "truncate table team_player";
  mysql_query($statement);
  $statement = "truncate table player_to_attribute";
  mysql_query($statement);
  $statement = "truncate table team_player_to_attribute";
  mysql_query($statement);
  $statement = "truncate table selection";
  mysql_query($statement);
  $statement = "truncate table bpa";
  mysql_query($statement);
  $statement = "truncate table team_need";
  mysql_query($statement);
  $statement = "truncate table mock_draft";
  mysql_query($statement);
  $col[] = "team_clock_adj = '1'";
  $col[] = "team_autopick = '1'";
  $col[] = "pick_method_id = '3'";
  $col[] = "team_autopick_wait = '30'";
  $col[] = "team_email_prefs = '0'";
  $col[] = "team_sms_setting = '0'";
  $statement = "update team set ".implode(",",$col)." where team_id != '1'";
  mysql_query($statement);
 } else {
  $statement = "delete from team_player where team_id = '".$login->team_id()."'";
  mysql_query($statement);
  $statement = "delete from team_player_to_attribute where team_id = '".$login->team_id()."'";
  mysql_query($statement);
 }

What could be happening?

[aston217]

Does anyone know here?

I know the draft utility should be clearing all the existing registrations upon import - right? Is anyone else getting the same issue? Or, better: is anyone else not getting the same issue? That is, old registrations are successfully cleared upon draft class import?

If that's the case, could you post your draft utility in a zip file so I can take a look at what might be different? TIA!

[Ben E Lou]

It should? I don't know that it has ever cleared those out. I've been just running a query to clear them out for years:

update team set team_clock_adj=1.00, team_owner=NULL, team_chat_time=0, team_password=NULL, team_email=NULL, pick_method_id=1, team_autopick=0  where team_id>1 AND team_name!="Atlanta" and team_name!="Tucker" and team_name!="Lowcountry"

[aston217]

Oh, crap, my bad. Ignore that. I don't know how I got that in my head, maybe I was just so used to seeing it turn out that way.

Firefly just told me this, but yeah, I guess everyone has been manually clearing them.

If that's the query you run every time, should it be just added to the code? Part of it's already in there, in the above, just not the part with the team names and passwords. Or better to just leave this to admin discretion?

[PackerFanatic]

I'd say leave it to the admin.

[Templar]

Is there a known issue with the system about a 1.1 pick would not fire if it's the list and therefore it should picked manually?

[dthompso8]

Since we had a skipped pick in the 3rd round, no one has been able to select a player by clicking pick player in priority queue or players tab (using 2.6.1) have you come across this issue before?

Workaround is to have player top of queue and set auto pick on to make the selection..

[aston217]

That is a known issue and should be fixed. The issue crops up upon import. As I recall, you need to go into the database here. The player id field for the missed pick should be -1, I believe...but it's been a while since I've done this, so I'm not that confident about it. Hopefully you have someone comfortable enough to go into the database via phpMyAdmin. Let me know if not.

[marc_rdfl]

Hi, we're getting this error:

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in ...[file location] ...includes/classes/login.inc.php

Actually this is repeating for any line of code that uses the date function

Any ideas?

THanks

Marc.

[Maynard]

Originally Posted by marc_rdfl

Hi, we're getting this error:



Actually this is repeating for any line of code that uses the date function

Any ideas?

THanks

Marc.

Thanks for working on this, Marc!

[marc_rdfl]

found a way for fix it but now I can't get it to import a new draft - says the player_information file wasn't uploaded but it was !! arghh!!

[aston217]

What'd you guys do?

[marc_rdfl]

Originally Posted by aston217

What'd you guys do?

To fix the timezone error, I added this code to the relevant pages:

if( ! ini_get('date.timezone') )
{
    date_default_timezone_set('GMT');
}

So now I can get to the import draft stage but it won't recognise that I've uploaded the player_information.csv file.

Very odd and frustrating

[aston217]

Does reversing that change allow you to import the draft? If so ... you could try that as a quick temporary fix, and change it back after importing.

It doesn't seem like they would be related issues, though I'm assuming you have done plenty of draft imports in the past.

[aston217]

Resolved. The server had an upload_max_filesize setting of 2M (as revealed by phpinfo()) and the player_information.csv file was greater than that, so it wasn't accepting the upload.

I placed a .user.ini file in the root of the fofdraft directory with the following contents:

file_uploads = On
post_max_size = 50M
upload_max_filesize = 50M

Perhaps this file should be generally included in draft conscriptor?

[PackerFanatic]

Uncheck the "has password" box in the Users admin and hit Save at the bottom. That will reset it and allow them to re-register.

[PackerFanatic]

Gotcha. Are you attempting to register with the nickname or full team name? In the latest version, you have to use the full team name to register (think that might have been something with FOF7, actually) - so depending on what the team name looks like, you'd have to register with "St. Louis" instead of "STL"

[Dawgfan19]

1. If you are referring to the *30 minute display for AI teams where the auto pick is checked, I believe that is a display issue. The pick should fire immediately. You could also set the "Adjust clock" to zero for AI teams.

2. Ah, you've touch on a pet peeve for me. And actually I believe it is Mountain Time. I don't know of a solution, other than to adjust the draft start time in relation to the time difference between your time zone and MDT.

[ezlee2]

I have a question. No matter how many times I change the time zone. We still keep showing MDT time.

Any idea what this could be?

[A-Husker-4-Life]

We lost our draft admin and he has the Admin password so we can't setup our draft, is there anyway to reset the admin password?

[aston217]

You might have to delete includes/config.inc.php and set up the draft utility (visit it online) again. Make sure to make a copy of config.inc.php as that file will have the DB address and password in it, which you can use when setting up the utility again.

[Ben E Lou]

Big bump. We can talk about what changes need to be made later, but for now, I've stuffed everything I think I need to do an allocation draft into the database, but it's showing as "draft complete" because I didn't use the front end to do it. I'm guessing it's one tiny little flag that needs to be flipped in the db, but I can't find it. What setting needs to change for me to be able to start the draft up.

[Ben E Lou]

Heh. figured it out. First pick must have timestamps and player id must be NULL (not zero) for that pick.

[gstelmack]

We should get Conscriptor into a GitHub project to make collaboration on it easier.

[PackerFanatic]

Originally Posted by gstelmack

We should get Conscriptor into a GitHub project to make collaboration on it easier.

That would be awesome.

[aston217]

Do it!

[QuikSand]

I'm having a problem in FOF8 where I see the imported bars for most players, but for some reason most or all defensive tackles are vacant there. Has this been reported? Is there a fix?

[gstelmack]

I had that in the IHOF draft, so I reimported. They all had them after that. Not sure what the issue was on the first import.

[Ben E Lou]

Originally Posted by QuikSand

I'm having a problem in FOF8 where I see the imported bars for most players, but for some reason most or all defensive tackles are vacant there. Has this been reported? Is there a fix?

Originally Posted by gstelmack

I had that in the IHOF draft, so I reimported. They all had them after that. Not sure what the issue was on the first import.

Quik, I'm assuming you're talking CCFL here. My guess is that the same thing happened in both drafts: at some point after I got the utility thread up, before the official draft start time, but *after* a few people had already uploaded their draft_personal data, I made an edit to the database table that determines which bars get displayed for each position and in what order, so that you'd see coverage and ST bars for DL and have PRT and PRS next to one another. I guess making that change somehow borks previously-uploaded data for DTs (not sure why it would do that to DT and not DE also; I mean, the changes I made to them are identical. *shurg*). But yeah, I can confirm that I made a db change this morning to alter the display of bars, and a few minutes ago I uploaded my draft_personal and now I see full bars for DTs (and DEs and LBs, the only three positions where anything changed.)

The good news is that it's a one-time change in structure; I won't have to do it again moving forward. Sorry it caused confusion.

[hrd12]

Is there something I need to do to my csv files to get conscriptor to work? I'm using FOF8 and the error I'm getting indicates that the format might be different than FOF7 :

The file you imported does not appear to be a player or staff csv export file, or is the wrong version. Please verify that you are uploading the correct file and that you have the current version of FOF7.

I installed conscriptor 2.7.1 on my server. Or is there another version out there that can be used with FOF8? Thanks.

[Firefly]

Originally Posted by hrd12

Is there something I need to do to my csv files to get conscriptor to work? I'm using FOF8 and the error I'm getting indicates that the format might be different than FOF7 :

The file you imported does not appear to be a player or staff csv export file, or is the wrong version. Please verify that you are uploading the correct file and that you have the current version of FOF7.

I installed conscriptor 2.7.1 on my server. Or is there another version out there that can be used with FOF8? Thanks.

I'm having a similar (the same?) problem:

The file you imported does not appear to be a player record file. Please verify that you are uploading the correct file.

[Mike Lowe]

Any updates on whether this is working with FOF8?

[hrd12]

I was able to get it working with FOF8. I ended up installing again and it seemed to work just fine with the player file. It did not work when I tried to set up a staff draft.

[Hooper]

It works for the most part with the rookie draft in FOF8.

There is a SQL query floating around to make the new bars show up on the d-line.

There is a new analyzer.php too that works with Draft Analyzer.

But neither is necessary for it to work.

[A-Husker-4-Life]

I'm having a problem rolling back a pick, any suggestions on what I should try?

It's giving me a 500 Internal server error.

[giannicic]

Hi WheelsVT,

I've made a change to the Conscriptor that allows to run the draft in a slotted mode: basically it sets a fixed deadline for each pick instead of giving a fixed amount of time starting when the previous pick has been done.

The consriptor is available here if you want to merge it with your latest source:
fof_draft.zip - Google Drive

See this post for further info: Slot Draft - Page 3

Thanks

[Born2Run1963]

Has anyone seen these issues before with these warning messages? Wondering if there is a fix out there for this that I'm not seeing posted.

[garion333]

Originally Posted by Born2Run1963

Has anyone seen these issues before with these warning messages? Wondering if there is a fix out there for this that I'm not seeing posted.

Fixed image link for ya

[aston217]

I'm not sure; maybe it's a PHP version/settings issue? Which is to say it's a conscriptor issue for having an outdated way of connecting to the db. Perhaps it needs to be future proofed with a rewrite in PDO.

giannicic, that looks really cool. I'm out of the game now but someone should really github this all up.

[Sharkn20]

Originally Posted by aston217

I'm not sure; maybe it's a PHP version/settings issue? Which is to say it's a conscriptor issue for having an outdated way of connecting to the db. Perhaps it needs to be future proofed with a rewrite in PDO.

giannicic, that looks really cool. I'm out of the game now but someone should really github this all up.

The OSFL still waiting for you

[Born2Run1963]

Any chance anyone knows how to bypass use of mysqli when the php plugin is forcing it?

The is in reference to the above conscriptor warning/error issues. It's wreaking havoc on our draft.

Other question might be, why aren't other leagues experiencing this? Are you just on much older servers using earlier versions of mysql/php? Frankly, the server I'm on won't even let me due that due to security holes.

[chinaski]

Not sure if this is still being worked on, but a QOL feature I would love is if we could get the players birthday color coded by their affinity group? Like what we have here... FOF7 Chemistry Chart and here... http://gml.fof-belco.com/teampageroster.php?teamid=23

[WheelsVT]

Originally Posted by gstelmack

We should get Conscriptor into a GitHub project to make collaboration on it easier.

^^ 1000% All the code is there, but GitHub would enable group dev.

I haven't logged in here in a long time, but happened to drop by this evening and saw this thread continuing to live along with the utility being used.

The utility is definitely showing its age including some security issues that should be fixed as well. GitHub is awesome, I use it quite often, so I'll look into posting a repository there. Unfortunately, I'm not playing FOF anymore so I hope others are able to jump in and contribute. Perhaps FOF9 will change the way drafts are done.

[WheelsVT]

Ok, I created a new repository for it.
Hope this helps!

https://github.com/WheelsVT/FOFConscriptor

[Hooper]

I recently contracted the creator of the app Mr J David Baker himself to update the conscriptor for use with php 7. Most hosts seem to be retiring previous versions. No new features were added. Just a couple bug fix-type things. The mock draft should import without editing the files. The skipped picks should show up as xxx in the selections. I think those are the big changes. The rest was just getting it to run smooth on php 7. My host has 7.4 and it seems fine.


GitHub - Lunchbox00711/FOFConscriptor: Front Office Football draft utility for use by online multiplayer leagues.


The version should be 3.0 to verify you got the right one.



Merry Christmas

[Cuckoo]

Originally Posted by Hooper

I recently contracted the creator of the app Mr J David Baker himself to update the conscriptor for use with php 7. Most hosts seem to be retiring previous versions. No new features were added. Just a couple bug fix-type things. The mock draft should import without editing the files. The skipped picks should show up as xxx in the selections. I think those are the big changes. The rest was just getting it to run smooth on php 7. My host has 7.4 and it seems fine.


GitHub - Lunchbox00711/FOFConscriptor: Front Office Football draft utility for use by online multiplayer leagues.


The version should be 3.0 to verify you got the right one.



Merry Christmas

I missed this at the time but just want to add my huge thanks to Hooper for this. I know it probably cost him a good chuck of change, and it benefits the entire community greatly.

If you want to contribute (and please do, even if it's just a buck), Paypal to [email protected].

[mac88]

I'm not a big computer guy and I don't even know what any of that means or how you even begin to do what Hoop did. I'm just here to just to say he is an awesome commish and just updated the site at the ffl as well. Cheers Hoop!

[A-Husker-4-Life]

Changing servers time zone so it's not UTC, does anyone know how to change this?

[A-Husker-4-Life]

Originally Posted by A-Husker-4-Life

Changing servers time zone so it's not UTC, does anyone know how to change this?

Found the answer, you need to have your php timezone changed to whatever to need.

Create a file called php.ini and place it in your html folder on your host.

in the file add the line;

date.timezone = "US/Mountain"

if you are having an issue opening your Website after you upload file add this to he php.ini

max_execution_time 600
memory_limit 128M
post_max_size 32M
upload_max_filesize 32M