PDA

View Full Version : FOF MP Draft Utility


Pages : 1 [2]

Sef0r
01-28-2014, 01:35 PM
If I missed it, how does one important their own extractor file to conscriptor so they can see the player bars?

WheelsVT
01-28-2014, 09:01 PM
If I missed it, how does one important their own extractor file to conscriptor so they can see the player bars?

I have not implemented it yet.

WheelsVT
01-28-2014, 09:08 PM
Ok, I've finished the latest important update which has several key patches to the staff draft aspect, captures QB formations and rookie birthdays, and switches to the 7.0a export format. I plan to test the staff draft a few more times this week, but so far it's matched up well.

Version 2.4

Fixed bug where traded picks still were reported as owned by the original team.
Fixed bug where unemployed staff would not show up if the XXX utility user in_game_id was not set to 99.
Fixed bug where Arizona staff also showed up as admin or xxx staff if in_game_id values were not set properly by the utility to -1 and 99 respectively.
Fixed bug where expired contract staff members were considered still employed since the export listed their former team as current employer.
Fixed bug where staff pick could not be made manually after the first round.
Fixed bug where rollback caused formerly drafted staff members to not be selectable when the draft restarted.
Fixed bug where rollback caused formerly fired staff members to not be reinstated to their former teams.
Updated to support new export format of FOF7.0a.
Updated to change from arbitrary staff transaction input file numbers to using the year column now exported in FOF7.0a
Updated to capture the formations for active QBs when running an allocation draft.
Updated to capture rookie birthdays by cross-referencing Player_ID with player_information.csv.

WheelsVT
02-04-2014, 06:16 AM
Minor revision

Version 2.4.1
Fixed bug where Arizona (or team with in-game ID of 0) does not show up in the selections filter dropdown list but team 'admin' does.


There are no database mods needed to update, just overwrite all the files (or specifically page.inc.php). Thanks Red Zone.

PackerFanatic
02-04-2014, 12:02 PM
Have you ever seen an issue with the installer not writing the admin user to the team table? I get no errors at all, it is able to create the tables and everything, but when I try to login with the admin user, it says the login is not valid. When I check the team table in the DB, there is no admin record in there at all.

PackerFanatic
02-04-2014, 08:38 PM
Looks like our server is using PHP 5.5.6 and the mysql library has been deprecated from PHP as of v5.5. Not sure that is exactly the cause of the weirdness I am seeing, but it seems to fit at least.

Any word on upgrading the utility to be fully 5.5 compatible? Anyone else using that high of a version of PHP that is seeing it working? From what I am seeing, it sounds like the library will be fully removed from PHP soon-ish (at least most likely by the next major release), so I thought I would mention it either way.

sjshaw
02-05-2014, 03:57 PM
If you could implement the suggestion for returning to the "Priority" page after adding a guy in the search box instead of kicking out to the "Selections" page, I'd appreciate it.

WheelsVT
02-05-2014, 07:35 PM
I looked into the code and there's a session variable that should be set to return you to your previous page. So it's in there from original days, just not working.

WheelsVT
02-05-2014, 07:40 PM
Have you ever seen an issue with the installer not writing the admin user to the team table? I get no errors at all, it is able to create the tables and everything, but when I try to login with the admin user, it says the login is not valid. When I check the team table in the DB, there is no admin record in there at all.

That record should be created from the install process. Using the admin username you enter on the install web page. I haven't seen it fail to be created that I can remember.

WheelsVT
02-05-2014, 07:47 PM
Looks like our server is using PHP 5.5.6 and the mysql library has been deprecated from PHP as of v5.5. Not sure that is exactly the cause of the weirdness I am seeing, but it seems to fit at least.

Any word on upgrading the utility to be fully 5.5 compatible? Anyone else using that high of a version of PHP that is seeing it working? From what I am seeing, it sounds like the library will be fully removed from PHP soon-ish (at least most likely by the next major release), so I thought I would mention it either way.

Thanks for the heads up. I've seen the notices when looking up syntax to modify the original utility. Hopefully, it doesn't require much of a rewrite. A search and replace would be great, but I doubt it's that simple.

WheelsVT
02-05-2014, 07:54 PM
Feature request if you get a chance: Be able to view "everybody but K/P" in the "All Players" view.

I tried to add this but the list is pulled from the positions table and there is no "all but K/P" position. Adding it to the table could mess up other aspects so I haven't figured out a nice way to do it yet.

WheelsVT
02-12-2014, 07:21 PM
Minor revision

Version 2.4.2

Modified the player detail URLs to use the player_id from within FOF7 so that leagues could create their own player pages that link to Conscriptor.

WheelsVT
02-12-2014, 07:23 PM
If I missed it, how does one important their own extractor file to conscriptor so they can see the player bars?

I have not implemented it yet.

I'm hoping to work on this over the next few days if we get some time off work with this snow storm.

Dutch
02-12-2014, 08:59 PM
Minor revision

Version 2.4.2

Modified the player detail URLs to use the player_id from within FOF7 so that leagues could create their own player pages that link to Conscriptor.

You rock!

WheelsVT
02-15-2014, 09:09 AM
An update everyone's been waiting for...

Version 2.5

- Fixed bug introduced in 2.4.2 where the left and right player detail navigation was no longer correct.
-Added ability for GMs to upload extractor output to have their own staff's view of rookie skill bar values.

Normie32r
02-15-2014, 09:46 AM
-Added ability for GMs to upload extractor output to have their own staff's view of rookie skill bar values.

:chickendance: :banana:

garion333
02-15-2014, 01:12 PM
oh, thank god. If we didn't get some sort of bars view in conscriptor I was seriously thinking of shelving FOF7. It's nigh impossible to draft away from your computer without bars, even when you upload a priority list.

So, THANK YOU!

WheelsVT
02-17-2014, 08:12 AM
Thanks to RedZone for finding that the 7.32 wasn't being imported despite being in the CSV output. I added an extra newline character to the end to see if the game is looking for a blank line to finish off the CSV.

Version 2.5.1

-Added Draft Analyzer compatible output to the status line in addition to the CSV output.
-Added an extra newline to draft CSV file since FOF 7.0a was not recognizing the 7.32 pick.

sjshaw
02-17-2014, 10:45 PM
:chickendance: :banana:

THANK YOOOOOOOOOOOOU

Ben E Lou
02-28-2014, 06:30 AM
Staff draft with 2.5.1 is not importing last season's transactions.csv. We were supposed to start this morning. Any quick help would be much appreciated.

TRO
02-28-2014, 12:00 PM
Cross posting from CCFL draft thread:

Unless I'm missing something, I don't see an option to set my priority list to skip my pick. All of the options are centered around a player draft.

My goal is to skip my HC, OC and DC picks and try to pick up an improvement at AC and SC. But I can't set my priority list for that at all.

I can set that kind of preference in game preferences, but here I'm forced to wait through the manual picks each round with auto pick off. This is going to lead to a long process.

TRO
02-28-2014, 12:08 PM
I think the utility needs to be set up with 5 separate priority lists.

Unlike a player draft when setting a list in round 2 and getting the guy in round 3 is OK, here, if you set a Head Coach priority list and it gets used in a Coordinator round, it could be a REALLY HORRIBLE pick.

Ben E Lou
02-28-2014, 12:29 PM
Cross posting from CCFL draft thread:

Unless I'm missing something, I don't see an option to set my priority list to skip my pick. All of the options are centered around a player draft.

My goal is to skip my HC, OC and DC picks and try to pick up an improvement at AC and SC. But I can't set my priority list for that at all.

I can set that kind of preference in game preferences, but here I'm forced to wait through the manual picks each round with auto pick off. This is going to lead to a long process.

I think the utility needs to be set up with 5 separate priority lists.

Unlike a player draft when setting a list in round 2 and getting the guy in round 3 is OK, here, if you set a Head Coach priority list and it gets used in a Coordinator round, it could be a REALLY HORRIBLE pick.Very good comments, both of these.

To piggy-back on the first one, I think there needs to be a way for the commish to set all teams to the default of "If I have a staff member signed to the role of the current round, skip my pick." And then it's up to each league member to go into Conscriptor and set it to NOT skip their pick at, say, Offensive Coordinator, because they're looking for an upgrade there. Otherwise, leagues are going to have to deal with what I suspect will be the major annoyance of people who don't need to make changes not bothering to do anything at all, and thus we just sit around waiting for their time to expire.

PackerFanatic
02-28-2014, 02:17 PM
Very good comments, both of these.

To piggy-back on the first one, I think there needs to be a way for the commish to set all teams to the default of "If I have a staff member signed to the role of the current round, skip my pick." And then it's up to each league member to go into Conscriptor and set it to NOT skip their pick at, say, Offensive Coordinator, because they're looking for an upgrade there. Otherwise, leagues are going to have to deal with what I suspect will be the major annoyance of people who don't need to make changes not bothering to do anything at all, and thus we just sit around waiting for their time to expire.

Absolutely this. This would be amazing, from both the Commish and member standpoint. More often than not, people are not going to NEED to make a switch, so if they WANT to, they should have to go in and do the work, rather than being auto'd.

WheelsVT
02-28-2014, 03:31 PM
Thanks guys for trying and posting ideas. At this point staff draft is still not a valid option. (At least the player draft is working!) I will be taking these suggestions and implementing a new design for the staff draft.

Pyser
02-28-2014, 05:07 PM
this wont be helpful at all because the change needs to come from jim, but changing the order of the begin of season routine would make this so much simpler.

if the order was like below, then you could run all these stages and have the coach draft run in conscriptor concurrently, exactly like free agency and the draft works:

1-Staff Retention (would be nice to add "fire" too, as this is where it happens IRL)
2-Stadium Work
3-Summer League
4-Ticket Prices
5-Enter Staff Draft Results

of course there's really no reason the first 4 couldnt be done in 1 stage, but, at least it lets other stuff happen while the boring staff draft runs.

if we could push entering staff draft results to later in free agency, we could shave days off the entire top of season boringness. oh well.

WheelsVT
03-03-2014, 10:42 AM
Found some URL and staff draft issues. Fixed the URLs, but staff draft needs redesign. Staff draft is not a usable option still. Thanks to CCFL for being the first to try.


Version 2.5.2

Fixed bug introduced in 2.4.2 where selections and priority pages player/staff detail URLs no longer worked.
Fixed several staff issues, but it needs a redesign. Not recommending any league use it at this time.

chinaski
03-08-2014, 07:19 AM
Getting this error when trying to upload the extractor data for the WOOF draft.

The file you uploaded appears to be an Extractor file, but I didn't find any matches to the players in the system. Are you sure you uploaded the correct file?

Dont really know where to go from there... I attached the extractor csv.

WheelsVT
03-08-2014, 07:40 AM
The Utility tries to match the player_name, position, and DOB to a player in the database. This message means that none of the lines in the CSV matched anyone.

First thing to check is that the names and positions match up, and second is see if the date of births are off between the utility and the extractor file. If anything I'd bet on the DOBs, but lets see and go from there.

chinaski
03-08-2014, 07:42 AM
The Utility tries to match the player_name, position, and DOB to a player in the database. This message means that none of the lines in the CSV matched anyone.

First thing to check is that the names and positions match up, and second is see if the date of births are off between the utility and the extractor file. If anything I'd bet on the DOBs, but lets see and go from there.

Ah i think I see what it is. The players in the draft util aren't showing a DOB.

WOOF Front Office Football Conscriptor version 2.5.2 (http://www.fof-woof2.com/draft/show_player.php?in_game_id=3859)

WheelsVT
03-08-2014, 08:07 AM
Looking back at past revisions I removed DOB matching from the priority list import process since at the time FOF7 didn't export the rookie's DOBs.

I can't remember - checking to see if that changed in 7.0a, and if DOB should now be showing up. If not then I'll have to remove the DOB check from the bar import php file too.

WheelsVT
03-08-2014, 08:29 AM
I just ran a test with FOF7.0a to confirm. Rookie DOBs are imported properly and as long as they show up the Extractor import runs too.

I'll shoot Ben a message about the WOOF. The DOBs should be there, and that is certainly why you're not able to import your bars.

chinaski
03-08-2014, 09:22 AM
Thanks Wheels!

Ben E Lou
03-08-2014, 01:58 PM
Looks like it was an issue with player_information.csv. I generated a new one and it worked.

WheelsVT
03-11-2014, 09:24 PM
Looks like there's an issue if you have two identical cities in the team_information.csv file when setting up the draft. Ex: New York and New York for the Giants and the Jets. Since the cities are the same you'll find that the second team's picks don't show up.

Quick Solution: Edit the team_information.csv file and rename the cities to be unique before importing. Or do it an re-import the draft.

Better Solution: Edit the city nicknames in-game so that future exports have unique city names. ("New York (G)" and "New York (J)" or something)

gstelmack
03-16-2014, 06:53 PM
The Analyzer Dump doesn't seem to have newlines after every draftee? Or is this just WOOF's?

Ben E Lou
03-16-2014, 07:26 PM
The Analyzer Dump doesn't seem to have newlines after every draftee? Or is this just WOOF's?
All. I just use the dump from the draftbit. DRAFTBIT (Http://www.fof-woof2.com/draftbitylnd.php)

gstelmack
03-16-2014, 08:13 PM
Yup, that one'll work.

gstelmack
03-19-2014, 08:12 AM
Wheels:

The old export from Draft Analyzer into Conscriptor to set your draft order included a birthdate to help resolve same name conflicts. Unfortunately, birth date is no longer available for rookies with the exported FOF data (not sure how important it is), so I can't send it with DraftAnalyzer. Is there anything different I should send? Name, position group, college should be enough?

WheelsVT
03-19-2014, 08:55 PM
I've been busy lately and unable to update.

Yes, as soon as I can I'll add the new line to the analyzer output, fix the mock draft URLs, and check the draft order which Ben found wasn't quite right in one instance.

Greg, if I remember right, the birthdays are now exported, but in the player_information.csv which includes rookies now. So Conscriptor still matches on name, birthday, and position currently. I'll check as soon as I can.

gstelmack
03-19-2014, 09:14 PM
If player_information.csv contains rookies, I can look into reading that and adding it to the data I import.

gstelmack
03-21-2014, 06:36 AM
DraftAnalyzer now has birthdays from player_information.csv, so the export draft order for Conscriptor should be working again. Thanks for the pointer, Wheels!

Dutch
03-26-2014, 09:23 PM
We have a site using MySQL Server 5.6 and PHP 5.5.6 and as PackersFanatic mentioned earlier, there might be some conflicts with Conscriptor.

The installation seems to go well, but the admin account is never created and even going into the DB and creating an admin account doesn't allow me to log in.

We are not sure if this is a versioning issue or a permissions issue or something else. Any help or suggestions appreciated.

Dutch
03-29-2014, 09:11 AM
Alright, so I got the manual account creation thing sorted out. But the user I created doesn't have permissions to the admin pages. So I'm getting closer.

Is there an identifier in the 'team' pages that makes my admin account the actual admin account (versus a regular team owner account)?

Dutch
03-29-2014, 05:05 PM
For reference: I think I figured it out. Once I added the admin info into the 'team' table correctly the full draft_admin tab list appeared.

WheelsVT
04-03-2014, 07:06 PM
Hey guys, sorry, I've been swamped in real-life work/family/etc. I'll be updating this and looking at issues mentioned as soon as I have some free cycles where I'm not wiped out.

WheelsVT
04-20-2014, 08:41 AM
For reference, the FOF Conscriptor was built on PHP 5.2.5 and MySQL 5.0.45. My test webserver is using PHP 5.3.18 and MySQL 5.1.61 without issue. I have not started deconflicting the newer MySQL versions which deprecated several SQL calls.

I am implementing a few fixes now and am really hoping I get a rework of the staff draft up soon.

Dutch
04-20-2014, 09:17 AM
I sent you a PM, but you're full. :)

WheelsVT
04-20-2014, 10:04 AM
Cleared out now.

cuervo72
04-22-2014, 08:26 PM
Possible error: team locations that contain an apostrophe. FOFL has a "Sam's Town", and the team wasn't inserted into the db. I'm assuming it's an issue with escaping the string.

nflchampion
04-24-2014, 02:52 PM
Is it possible to use the game output instead of Extractor runs in future versions of the Draft Utility? I ask because I've had a lot of difficulty getting Extractor working well through Crossover on OS X, but Draft Analyzer worked well using the in-game outputs. It helped to use the draft order export, but having it be uniform would be outstanding if at all possible.

WheelsVT
04-24-2014, 10:13 PM
Possible error: team locations that contain an apostrophe. FOFL has a "Sam's Town", and the team wasn't inserted into the db. I'm assuming it's an issue with escaping the string.

Yes, that's likely the issue. Thanks.

WheelsVT
04-24-2014, 10:19 PM
Is it possible to use the game output instead of Extractor runs in future versions of the Draft Utility? I ask because I've had a lot of difficulty getting Extractor working well through Crossover on OS X, but Draft Analyzer worked well using the in-game outputs. It helped to use the draft order export, but having it be uniform would be outstanding if at all possible.

I don't believe the rookie bar values are exported from the game pre-draft?

I need to touch base with Greg if he found a way to pull it from the in-game outputs, or I've missed it since I haven't had time to work on an update until recently.

Ben E Lou
04-25-2014, 03:13 AM
7.0b added draft_personal.csv and players_personal.csv as outputs. They show all bars from the perspective of your own scouts. These should replace Extractor in Conscriptor as they're much easier to output. draft_personal would be for amateur drafts, and players_personal would be for dispersal drafts. (If you get this in there for dispersal drafts, I'll probably end up doing another one, fwiw.)

Ben E Lou
04-25-2014, 03:13 AM
Oh...the analyzer dump isn't formatted correctly in 2.52. The line breaks that it needs aren't showing up.

QuikSand
04-25-2014, 08:37 AM
I know this is a trivial thing, but the default set of attributes that are shown for players is a little silly. SCHOOL yes, but ADJUSTED GRADE no. A common sense refresher there would seem to make sense to me - and obviously we can pick out own with a little effort, but a more sensible starting point would be nice. Some of us watch birthdates carefully, I'd love to see that in the default set.

gstelmack
04-25-2014, 11:10 AM
Adjusted Grade allows you to sort pretty close to the FOF sort, given that the draft class is grouped by position in the new exports.

RedDoby
04-25-2014, 11:18 AM
The NFLsim league will be using this utility in a few months. I am not familiar with it at all and was wondering if it has intelligence enough to select for computer controlled teams, or does the commissioner generally have to make the selections for them?

Thanks for all you guys do.

cuervo72
04-25-2014, 02:10 PM
Speaking of adjusted grade - is the raw grade included in any of the game exports (I don't have them available right now to check)? Because I noticed after importing the FOFL draft that the adjusted grade and raw grade columns were populated with the same values. (Or is that what we're already talking about?)

gstelmack
04-25-2014, 06:17 PM
Not the raw grade, no. I mentioned that in the exports thread. I have the FOF weights somewhere in my DraftAnalyzer code that you can divide by to get the raw grade from adjusted, it's just a per-position factor.

WheelsVT
04-27-2014, 07:47 PM
My time has been limited so it's been really slow going on the updates here, but I'm trying to get to them.

It would be helpful if someone could PM me the export files needed to setup a draft that has a penalized pick, and also any draft that had some draft order issues other than due to a penalized pick.

God bless MikeD for trying to get me excited and going again, but with infant twins at home I never know how a night will turn out. Not exactly great coding conditions.

WheelsVT
04-27-2014, 07:51 PM
The NFLsim league will be using this utility in a few months. I am not familiar with it at all and was wondering if it has intelligence enough to select for computer controlled teams, or does the commissioner generally have to make the selections for them?

Thanks for all you guys do.

If you take the step to run the mock draft it will help make the scout picks a little smarter based on need otherwise it will follow the grade order while avoiding selecting multiple guys at the same position.

Dutch
04-28-2014, 08:03 AM
My time has been limited so it's been really slow going on the updates here, but I'm trying to get to them.

It would be helpful if someone could PM me the export files needed to setup a draft that has a penalized pick, and also any draft that had some draft order issues other than due to a penalized pick.

God bless MikeD for trying to get me excited and going again, but with infant twins at home I never know how a night will turn out. Not exactly great coding conditions.

Trust me, there are plenty of folks around here that are passionate about this game but don't always have the time. In the end we are all in the same boat. Family first, work second, friends third and loner hobbies come in after that to fill the dwindling void called "free time". :)

Andreh
04-29-2014, 04:02 PM
is there anyway to save your priority list order from inside the conscriptor?

WheelsVT
04-30-2014, 05:16 PM
I've managed to switch out the Extractor part for in-game exported scout data. Still working on some more things before posting the update.

WheelsVT
04-30-2014, 07:22 PM
(If you get this in there for dispersal drafts, I'll probably end up doing another one, fwiw.)

Got it working for the allocation draft now too.

Normie32r
05-03-2014, 06:58 AM
An update everyone's been waiting for...

Version 2.5


-Added ability for GMs to upload extractor output to have their own staff's view of rookie skill bar values.

Can someone step me through how to do this? I have exported all the data from in-game. Now what?

WheelsVT
05-04-2014, 07:45 PM
Version 2.5.3

Fixed bug introduced in 2.4.2 where mock draft player detail URLs no longer worked.

Fixed bug where Analyzer output did not include a newline.

**Updated GM player ratings import to use FOF7 generated files instead of requiring another utility like Extractor to pull the data out first.

WheelsVT
05-04-2014, 07:47 PM
Can someone step me through how to do this? I have exported all the data from in-game. Now what?

The update you quoted used Stelmack Extractor to pull the ratings data for import. However, if your commisioner installs the update I just posted you'll be able to use the game generated scout files instead.

WheelsVT
05-04-2014, 07:48 PM
Version 2.5.3

Fixed bug introduced in 2.4.2 where mock draft player detail URLs no longer worked.

Fixed bug where Analyzer output did not include a newline.

**Updated GM player ratings import to use FOF7 generated files instead of requiring another utility like Extractor to pull the data out first.

Note that this update has a few SQL commands to run as part of the update. See upgrade_2_5_3.sql in the includes/mysql directory.

Ben E Lou
05-10-2014, 04:51 AM
Version 2.5.3

Fixed bug introduced in 2.4.2 where mock draft player detail URLs no longer worked.

Fixed bug where Analyzer output did not include a newline.

**Updated GM player ratings import to use FOF7 generated files instead of requiring another utility like Extractor to pull the data out first.
Trying to do a new install with this version and am getting "Query was empty" after I've entered everything and it tries to run the installation script.

WheelsVT
05-10-2014, 05:28 AM
Sorry I've been hard to reach this week.

The install error was due to an extra blank line at the end of the install.sql script, and I found I again included my config file for my test server. :rant: Seriously?

I updated the zip file and you shouldn't have any issues now.

PackerFanatic
05-30-2014, 12:55 PM
Noticed during our current CCFL draft, when looking at the Analyzer output, the utility is not grabbing players with multiple-part first or last names correctly.

This is what it is displaying for two players:

2. - Moon, Blue, WR, Moorhead State
54. - Van, Logan, WR, Wagner

And this is what their full names actually are:

Blue Moon Elliott
Logan Van Pelt

PackerFanatic
07-18-2014, 02:09 PM
Noticed an issue between the main players list and the mock draft list.

From the players list:

RNFL Front Office Football Conscriptor version 2.5.2 (http://www.replicatednfl.com/draft/show_player.php?in_game_id=34853) (page comes up fine, no prob)

From the mock draft page:

RNFL Front Office Football Conscriptor version 2.5.2 (http://www.replicatednfl.com/draft/show_player.php?player_id=1) (passing a different ID, no info is grabbed)

As you can tell by the links, we are v2.5.2 :)

WheelsVT
07-18-2014, 02:28 PM
PackerFanatic, the URL issue is fixed in 2.5.3. It's happened when I started using the in-game IDs for the URLs.

PackerFanatic
07-18-2014, 02:31 PM
I realized we weren't up-to-date after I posted, of course...and just verified that you are correct. Thanks man :)

Ben E Lou
08-21-2014, 02:18 PM
3(32) pick was forfeited for cap violation. Conscriptor listed 2(32) as forfeited instead. Probably similar to the 32nd-pick-traded bug. Universe file attached.

aston217
08-25-2014, 12:51 PM
3(32) pick was forfeited for cap violation. Conscriptor listed 2(32) as forfeited instead. Probably similar to the 32nd-pick-traded bug. Universe file attached.

I'm not sure if the CyFL 32nd-pick-traded bug is being referenced here, but we have the same thing. The universe file I checked and verified as correct.

The "Pick Owner This Year" table within universe_info.csv is of this format:

ROUND / (TEAM ID + 1) / TRUE OWNER.

In other words, the row that reads "1 / 9 / 10" means "In this year's Round 1, Team Id = 8's pick is owned by Team Id = 10."

By modifying the values here I found that the team that held 1.32, if you changed their "Pick Owner This Year" Round 1, that would show up in Round 2. And vice versa. It does not seem to affect any other picks.

I stepped through the logic of the import code (where you read in the universe_info.csv file), and that appears to be 100% correct.

import_fof7_draft_run.php

foreach($lines as $line) {

$fields = preg_split("/,/",$line);

if (!$staff && strcmp($fields[0],"Draft Order")==0){

//we have a pick line, process it

$fields = preg_split("/,/",$line);

$team_id = trim($fields[3]);

$pick_order[$pick] = $tids[$team_id];

$pick+=1;

}

if (!$staff && strcmp($fields[0],"Draft Pick Owner - This Year")==0){

//now see if the pick owner is actually different.

$round = $fields[1];

$orig_team = $fields[2]-1;

if ( $orig_team!=$fields[3] ){

//they traded that pick away

$start = ($round-1)*32;

for ( $i=$start; $pick_order[$i]!=$tids[$orig_team]; $i++){}

$pick_order[$i] = $tids[$fields[3]];

}

}

....
}


So, I'm assuming it has something to do with the display. But I'm not able to check the database and see what was actually entered there. Perhaps it's being thrown for a loop somehow when there's a missing pick (the draft page for Round 3 ends at 4.1 and omits the offending 3rd round pick).

The other thing worth mentioning is that the forefeited pick showed up under Draft Owner This Year as a pick that moved to Team Id = 89.

aston217
08-25-2014, 01:04 PM
Actually, now that I think about it, this last line here:
$pick_order[$i] = $tids[$fields[3]];

$tids appears to be an array of the league's 32 $city ids (in other words, $tids[10] = whatever number is used for Green Bay's city id, since Green Bay's team id number is 10). In this file, I see $tids being constructed but I don't believe it will have an array index of 89.

When the pick has been "traded away" for cap violation penalty, $fields[3] will contain 89. So that's going to be an undefined offset, and $pick_order[$i] is going to be, well, I'm not too sure what. "Undefined", perhaps?

So when this comes up later...


// Store the processed data into the database

foreach($pick_order as $key=>$value) {

if ($value == 'xxx') {

$player_id = '-1';

} else {

$player_id = kDraftHalt;

}

$statement = "insert into pick (pick_id, team_id, player_id) values ('$key', '".$teams[$value]."', $player_id)";

mysql_query($statement);

}


...I'm not sure what's in $value for the offending pick, but $teams[$value] is probably not going to be what's expected?...

Sorry, I'm not too sure, there's a lot going on with that file.

Long story short, probably what I'd do is:

$pick_order[$i] = $tids[$fields[3]];

Before making that statement, check if $fields[3] == 89, and if so, $pick_order[$i] seems like the later code is expecting it to be 'xxx'.

aston217
08-25-2014, 09:08 PM
I did some more looking into it and here's what I found, it actually isn't importing correctly.


if ( $orig_team!=$fields[3] ){

//they traded that pick away

$start = ($round-1)*32;

for ( $i=$start; $pick_order[$i]!=$tids[$orig_team]; $i++){}

$pick_order[$i] = $tids[$fields[3]];

}

$pick_order is an array of all draft picks that starts out as simply the draft order (i.e, no trades). This code runs when it detects that a team has traded their original pick in a given $round to another team. It does this by starting with the first pick of the round in question and incrementing up through the $pick_order table until it hits the next pick owned by $orig_team, the team that has given away their pick. Then it swaps ownership to the new owners of the pick.

For example, if the Lions have traded away their Round 2 pick to the Bears, the counter starts at $pick_order[32] because 32 = (2-1) * 32. It compares the team that holds $pick_order[32] and sees if that's the Lions' Round 2 pick. If not, it goes on to $pick_order[33] and so on.

The problem? $pick_order[32] is 1.32. This is because instead of starting with $pick_order[0], which I think was the (safe; I would've thought the same) assumption, $pick_order actually starts with 1, as defined earlier in the file. $pick_order[0] is initialized to be owned by 'xxx' and is never used again by the conscriptor.

So when we're trying to find a pick to re-assign ownership for, instead of starting at the first pick of $round, we starts at the 32nd pick of the previous round. When it's a trade involving a #32 pick, guess who the owner of the 32nd pick of the previous round is? $orig_team. The counter $i never increments because it meets the test condition right away, and the previous round's 32nd pick is assigned to the new team instead.

From looks of it, then, it might have nothing to do with cap violation penalties. It's just you would think $pick_order[31] == the 32nd element of the pick_order array, but no. So I believe, but have not tested, that the fix is this (in red):


if ( $orig_team!=$fields[3] ){

//they traded that pick away

$start = ($round-1)*32 +1; //now we start at the first pick of the round

for ( $i=$start; $pick_order[$i]!=$tids[$orig_team]; $i++){}

$pick_order[$i] = $tids[$fields[3]];

}

This wouldn't have affected picks other than the 32nd because that's an edge case. In all other cases the test $pick_order[$i]!=$tids[$orig_team] wouldn't pass initially at $i=$start, so it would have incremented normally until it found the correct pick to swap ownership for.

Sorry for all the verbosity. Trying to be thorough in case I need to look back for future reference; I certainly don't want to step through all the debugging again.

The earlier change I suggested for the cap violation teams and checking for "new team id" being 89 still makes sense to me, but it looks like it doesn't impact conscriptor anyway. But don't quote me on that.

WheelsVT
09-01-2014, 07:19 AM
I did some more looking into it and here's what I found, it actually isn't importing correctly.


if ( $orig_team!=$fields[3] ){

//they traded that pick away

$start = ($round-1)*32;

for ( $i=$start; $pick_order[$i]!=$tids[$orig_team]; $i++){}

$pick_order[$i] = $tids[$fields[3]];

}

$pick_order is an array of all draft picks that starts out as simply the draft order (i.e, no trades). This code runs when it detects that a team has traded their original pick in a given $round to another team. It does this by starting with the first pick of the round in question and incrementing up through the $pick_order table until it hits the next pick owned by $orig_team, the team that has given away their pick. Then it swaps ownership to the new owners of the pick.

For example, if the Lions have traded away their Round 2 pick to the Bears, the counter starts at $pick_order[32] because 32 = (2-1) * 32. It compares the team that holds $pick_order[32] and sees if that's the Lions' Round 2 pick. If not, it goes on to $pick_order[33] and so on.

The problem? $pick_order[32] is 1.32. This is because instead of starting with $pick_order[0], which I think was the (safe; I would've thought the same) assumption, $pick_order actually starts with 1, as defined earlier in the file. $pick_order[0] is initialized to be owned by 'xxx' and is never used again by the conscriptor.

So when we're trying to find a pick to re-assign ownership for, instead of starting at the first pick of $round, we starts at the 32nd pick of the previous round. When it's a trade involving a #32 pick, guess who the owner of the 32nd pick of the previous round is? $orig_team. The counter $i never increments because it meets the test condition right away, and the previous round's 32nd pick is assigned to the new team instead.

From looks of it, then, it might have nothing to do with cap violation penalties. It's just you would think $pick_order[31] == the 32nd element of the pick_order array, but no. So I believe, but have not tested, that the fix is this (in red):


if ( $orig_team!=$fields[3] ){

//they traded that pick away

$start = ($round-1)*32 +1; //now we start at the first pick of the round

for ( $i=$start; $pick_order[$i]!=$tids[$orig_team]; $i++){}

$pick_order[$i] = $tids[$fields[3]];

}

This wouldn't have affected picks other than the 32nd because that's an edge case. In all other cases the test $pick_order[$i]!=$tids[$orig_team] wouldn't pass initially at $i=$start, so it would have incremented normally until it found the correct pick to swap ownership for.

Sorry for all the verbosity. Trying to be thorough in case I need to look back for future reference; I certainly don't want to step through all the debugging again.

The earlier change I suggested for the cap violation teams and checking for "new team id" being 89 still makes sense to me, but it looks like it doesn't impact conscriptor anyway. But don't quote me on that.

Thanks so much for the debugging! This definitely helps point me in the right direction right off the bat.

WheelsVT
09-09-2014, 07:47 PM
I'm not dead, just have a new computer and some more important work tasks taking my time right now. I'll get to this soon. It's not completely off my radar.

aston217
09-15-2014, 10:38 PM
Unofficial hotfix 2014-09-15
fof_draft_wheels_astonhotfix20140915.zip (http://ge.tt/4fFKruw1/v/0)

Posting this unofficial hotfix with a modified import_fof7_draft_run.php file. I made the changes I specified here (http://www.operationsports.com/fofc/showpost.php?p=2956206&postcount=331) and here (http://www.operationsports.com/fofc/showpost.php?p=2954587&postcount=329). (The code changes should be commented //aston).

Addressed issues:

32nd pick traded bug, where a 32nd pick traded showed up a round early
draft hang on pick due to cap violation

This is untested, but if one of you guys could test it and see if it's resolving those issues, that'd be great!

aston217
09-17-2014, 11:58 AM
FWIW, I did a test run (I think?) of this on localhost using XAMPP. It imported the past CyFL draft correctly and ran through the cap violation removed pick correctly, I think, although I was clicking "Force Pick" for the previous pick. Not sure if that makes a difference.

aston217
09-18-2014, 08:28 PM
The site I hosted the file at (ge.tt) is down, so I re-uploaded:

fof_draft_wheels astonfix
http://www.simgamingnetwork.com/osfl/repo/fof_draft_wheels_astonfix.zip

There was some kind of error in the last file, but evidently I fixed it somehow this morning, as we're now running this version live for the OSFL draft. I can confirm that it does fix the 32nd-pick-traded bug on import, as we had one of those trades here. We'll see how the penalized picks go.

Another change that's reflected here is that player bars are now width bars to reflect that they are width ranges (i.e, 50-75 or 75-100).

aston217
09-30-2014, 02:34 AM
Wheels (or is this much older code?), I noticed the java.js file seems to be a mash of custom draft-utility specific code, and the MooTools library.

However, it's impossible for me to tell where the latter ends and the former begins. Would you by any chance have any idea?

The reason being its use of MooTools' $ and $$ syntax seems to conflict with jQuery, which is needed by an external chat plugin. The fix is supposed to be easy enough (change the $ and $$ syntax), but I don't want to change the library code.

aston217
10-01-2014, 11:30 AM
New version of the hotfix, because the old one (apparently) didn't fix (or even change) the cap penalty issue due to an extremely dumb mistake on my part.

Download: fof_draft_wheels_astonhotfix.zip (http://ge.tt/9rlUC302/v/0)

Notes

Some files have from the original .zip that I downloaded have a lot of extra line breaks. That seems to happen when you upload to FTP in ANSI rather than binary. Sometimes this causes it to not play nice. If there are serious page-breaking errors, try uploading to FTP in binary mode instead.
The code sets cap-penalized picks to a value of "-1". However, kDeclinePick is "-300". I don't know why this discrepancy is there or if it will have an effect.
I guess the cap penalty pick handling aspect of this fix is still untested.


If you do run into a cap penalty pick issue, what will happen is that users after a penalized pick, will be unable to make their own picks. "Select this player" will not be an option, and "make pick" from queue won't work.

If that happens, you will have to go into the database via phpMyAdmin and manually change the offending pick's player_id from the picks table from NULL to "-300".

aston217
10-02-2014, 02:35 AM
- Site admin can designate other GMs (and their own team) as draft admins which have all the rights as the site-admin except for setting up a new draft. This means they can select for other teams, change draft settings, pause/rollback, etc.

Whole lot of DOLA now. (Non critical) Bug report about the above.

player.inc.php:


if (!$login->is_admin()) {
$joins[] = "left join selection on selection.player_id = player.player_id and
selection.team_id = '".$login->team_id()."'";
$col[] = "selection.player_id is_selected";
$col[] = "selection.selection_priority";
}


This is in the middle of constructing a giant query run to get all the info on a given player.

The selection table crucially identifies whether the player exists in a team's queue or not. That table is not included in the query if a team has also been designated as a draft admin.

So for teams that have been designated as "draft admins", players added to queues will still appear on their player card as not queued. I think it's only cosmetic and not sure if it has other ill effects.

It seems like the sturdiest solution would be to check instead the value of $login->team_id to make sure it's not "admin" or any other "illegal" team. This might merit its own function (or constant) somewhere.

WheelsVT
10-16-2014, 08:22 PM
Aston, you tha man. Obviously I've been consumed in other real-world tasks (twins, work, etc), but I'm running into these issues first hand in the RNFL, and they suck.

Thanks for the HARD work to figure out the code and create hot fixes. I'm going to pull them into the distro tonight and post out the update.

WheelsVT
10-16-2014, 08:55 PM
I can't get your latest hotfix to download, but I did find your mistake on the first hotfix :)

Can you fix the link? I'll pull in your updates and host it.

aston217
10-16-2014, 09:15 PM
Ah man, ge.tt is down again?

Attaching. There are some cosmetic changes in here too (I must have just pulled the folder from the OSFL or CFL draft) -- I changed the way the bars display. Ignore style.css and player.inc.php to uninclude those.

WheelsVT
10-16-2014, 09:51 PM
I kept them in there and posted v2.6 on the first page. The Aston hotfix version.:popcorn: :banana:

PackerFanatic
10-17-2014, 08:45 AM
Thank you, Aston (and Wheels)!

aston217
11-18-2014, 04:13 PM
Uh oh, I've discovered another error with importing FOF7 drafts.

This can happen when teams both give away and receive a future pick in the same round.

import_fof7_draft_run.php (http://ge.tt/4iv45l42/v/0)

This file is an import_fof7_draft_run.php with the fix. That's the only file affected.

The problem is with the bolded:

if ( $orig_team!=$fields[3] ){

//they traded that pick away

$start = ($round-1)*32 +1;

for ( $i=$start; $pick_order[$i]!=$tids[$orig_team]; $i++){}

$pick_order[$i] = $tids[$fields[3]];

}

This is again the code where the draft utility figures out where to assign picks when trades have occurred. Here's the issue:


When the utility looks for the proper landing space of the traded pick, it uses the existing $pick_order
To effect the trade, it modifies the existing $pick_order.


This code is processing the universe_info file line-by-line, so trades that occur later in that file (which is ordered by year, round, and then team_id) are using modified $pick_order to assign their trades.

The way it's supposed to work is by checking the original Pick Order. I.e, the original pick order states "Team A has pick #___ in Round 1." Then when a trade happens where Team A's pick is received by Team B, the utility needs to go through the Original Pick Order and find what #___ Team A's pick was.

The fix stores the original pick order in a separate, unmodified variable.

WheelsVT
11-18-2014, 09:54 PM
Thanks Aston. I've added the replacement file and posted this as v2.7.

aston217
11-23-2014, 12:17 AM
Wheels, yikes, Hooper just reported an error. I must've supplied you with a bad page.inc.php file at some point (it used a custom wrapper we had for the CFL to test out a draft chat there a while back).

The affected file is page.inc.php. This will cause a blank screen or error message if not replaced. It references wrapper_chat.html instead of wrapper.html.

page.inc.php (http://ge.tt/2KgXf452/v/0)

My fault, sorry!

WheelsVT
11-27-2014, 09:30 AM
v2.7.1
Corrected page.inc.php file added.

...one of these days I'll feel like working on the staff draft part of the utility.

garion333
12-01-2014, 04:58 PM
Enhancements and bug fixes here >>>>>>>>>> Staff draft

WheelsVT
12-01-2014, 07:59 PM
Enhancements and bug fixes here >>>>>>>>>> Staff draft

I just don't have the time. Also not aware of any major bugs needing fixing?
Regardless, if someone has time to make bug fixes and carry this forward please do. Aston??

I'd like to play some MP and not have to think about draft issues in the MP universe. Ben's "similar players" feature on his leagues has me thinking about a few things I want to try.

garion333
12-05-2014, 06:41 AM
Oh man, I wasn't pressuring you, it's just that with what time you DO have I'd much rather it be spent on anything related to the utility and not towards a live GM draft client thingy. If there's nothing more to be done, then ignore me.

If there's any bugs, I don't know about them. ;)

aston217
12-10-2014, 10:35 AM
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
01-29-2015, 09:53 AM
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
01-29-2015, 09:59 AM
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
01-29-2015, 10:11 AM
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
01-29-2015, 09:00 PM
I'd say leave it to the admin.

Templar
09-27-2015, 04:18 AM
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
09-29-2015, 03:31 PM
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
09-29-2015, 03:57 PM
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
01-14-2016, 03:20 PM
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
01-14-2016, 06:40 PM
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
01-16-2016, 02:24 PM
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
01-16-2016, 04:29 PM
What'd you guys do?

marc_rdfl
01-17-2016, 06:01 AM
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
01-17-2016, 02:01 PM
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
01-18-2016, 05:53 PM
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
04-09-2016, 04:49 PM
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
04-10-2016, 10:59 AM
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
04-12-2016, 08:35 AM
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
06-09-2016, 12:45 PM
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
10-10-2016, 01:12 PM
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
10-12-2016, 06:53 PM
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
12-08-2016, 12:32 PM
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
12-08-2016, 01:08 PM
Heh. figured it out. First pick must have timestamps and player id must be NULL (not zero) for that pick.

gstelmack
12-08-2016, 03:53 PM
We should get Conscriptor into a GitHub project to make collaboration on it easier.

PackerFanatic
12-14-2016, 01:48 PM
We should get Conscriptor into a GitHub project to make collaboration on it easier.

That would be awesome.

aston217
12-14-2016, 05:31 PM
Do it!

QuikSand
01-29-2017, 11:44 AM
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
01-29-2017, 02:14 PM
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
01-29-2017, 02:49 PM
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?

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
04-06-2017, 02:35 PM
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
04-14-2017, 08:35 PM
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
06-05-2017, 08:45 AM
Any updates on whether this is working with FOF8?

hrd12
06-05-2017, 11:52 AM
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
06-05-2017, 12:09 PM
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
06-09-2017, 10:02 AM
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
07-05-2017, 08:04 PM
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 (https://drive.google.com/file/d/0B0oUdlEk5bq2dUg4NllYMmJLVHc/view)

See this post for further info: Slot Draft - Page 3 (http://www.fof-ffl.com/foffflco_forum/showthread.php?10884-Slot-Draft&p=52478&viewfull=1#post52478)

Thanks

Born2Run1963
07-09-2017, 04:30 PM
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.

http://imgur.com/a/4dnZT

garion333
07-12-2017, 10:22 AM
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.

https://i.imgur.com/ij9HqWa.png

Fixed image link for ya

aston217
07-14-2017, 05:51 PM
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
07-15-2017, 03:06 PM
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
04-27-2018, 12:17 AM
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
10-29-2018, 04:32 PM
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 (http://gml.fof-belco.com/chemistrychart.php) and here... http://gml.fof-belco.com/teampageroster.php?teamid=23

WheelsVT
11-25-2018, 09:29 PM
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
11-25-2018, 10:09 PM
Ok, I created a new repository for it.
Hope this helps!

https://github.com/WheelsVT/FOFConscriptor
(https://github.com/WheelsVT/FOFConscriptor)

Hooper
12-24-2020, 11:00 PM
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. (https://github.com/Lunchbox00711/FOFConscriptor)


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



Merry Christmas

Cuckoo
03-28-2021, 07:09 PM
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. (https://github.com/Lunchbox00711/FOFConscriptor)


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
03-29-2021, 08:31 PM
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
09-10-2021, 05:59 PM
Changing servers time zone so it's not UTC, does anyone know how to change this?

A-Husker-4-Life
09-11-2021, 12:38 PM
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