03-12-2013, 10:20 AM | #101 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
I've attached what the "team" table looks like currently if you want to take a look and see if it's something unexpected there.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! Last edited by Ben E Lou : 03-12-2013 at 03:39 PM. |
03-12-2013, 01:12 PM | #102 |
High School JV
Join Date: Sep 2002
Location: GA
|
Thanks Ben. Looking at it now. I'll use it for further testing. Posted 1.8.6b for now which moves the pick_time setting just ahead of the on-the-clock email address calculations that seem to be erroring this out.
|
03-12-2013, 01:14 PM | #103 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
Thanks! Grabbing 1.86b now.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
03-14-2013, 01:39 PM | #104 |
High School JV
Join Date: Sep 2002
Location: GA
|
Ok, after much headache we've identified the bugs causing Ben's issues in the GML. Much thanks goes to Ben and the GML for their patience as we tried to figure this one out. They were introduced in 1.8.1 when I split admin email settings off of the regular email settings and moved a lot of the DB queries ahead of sending email.
1) Draft Admins changing draft options cause email settings to turn completely off. 2) If no mock draft was run then email is never sent and teams do not go on-the-clock properly. pick_time and pick_start are not populated. And an admin has to start/stop the draft after every pick to set them I've created a patch that addresses these issues, and posted it on the main page. 1.8.7.. yep, we killed those bugs. RNFL, DFL, if you're listening, you're already running this update. |
03-14-2013, 02:10 PM | #105 |
Pro Starter
Join Date: Jul 2005
Location: Appleton, WI
|
Thanks, Wheels!
I hope to get a new version installed on our server and run some tests to see what was causing our issues soon. I will let you know if I need any troubleshooting help (probably after our current draft is done)
__________________
Commissioner of the RNFL |
03-14-2013, 04:16 PM | #106 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
04-13-2013, 02:06 PM | #107 |
College Starter
Join Date: Dec 2000
Location: Sweden
|
A suggestion - when entering names for the priority list through the "quick add" text field, could the browser just reload the priority list instead of loading the selections page?
__________________
San Diego Chargers (HFL) - Lappland Reindeers (WOOF) - Gothenburg Giants (IHOF) Indiana: A TCY VC - year 2044 - the longest running dynasty ever on FOFC! |
04-17-2013, 04:11 AM | #108 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
Updated to 1.8.7 in the CCFL this year and when I imported draftorder.txt, CLE did not have any picks due to having traded them all away. Now they're unable to register. I just added "CLE" to the "team" table. Do I need to do anything else?
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
04-17-2013, 11:29 AM | #109 |
High School JV
Join Date: Sep 2002
Location: GA
|
That's one way to do it.
The designed way is to use the "Add Team" section at the bottom of the Users tab. Once that's done they should be able to register. |
04-17-2013, 11:32 AM | #110 | |
High School JV
Join Date: Sep 2002
Location: GA
|
Quote:
Yes. Now that we've reached a stable release I'll start to move forward on some tweaks and improvements as I have time. Reworking the Quick Add feature is one of them. |
|
05-23-2013, 11:11 PM | #111 |
n00b
Join Date: Nov 2004
|
I'm getting this error when I click the selections tab:
http://primetime-football-league.com...selections.php |
05-24-2013, 07:09 AM | #112 | |
High School JV
Join Date: Sep 2002
Location: GA
|
Quote:
The key here is: Unknown column 'team_owner' in 'field list' I'm guessing this was an update of a previous installation, and you haven't run the SQL commands needed to update the database tables. They can be found in fof_draft/includes/mysql/ I should have done a better numbering scheme since it looks like my updates are prior to 1_28, but run the commands from upgrade_1_3.sql through upgrade_1_8_1.sql and you should be set. |
|
05-25-2013, 02:48 PM | #113 | |
n00b
Join Date: Nov 2004
|
Quote:
I'm sorry. How do I run these commands? |
|
05-25-2013, 04:21 PM | #114 |
"Dutch"
Join Date: Oct 2000
Location: Tampa, FL
|
You need to run the SQL commands against your database (wherever that's located). Just run them one after another (starting with 1_3 and ending with 1_8_1 according to the instructions provided above).
|
05-31-2013, 08:20 PM | #115 |
lolzcat
Join Date: Oct 2000
|
Feature request:
Be able to select multiple draft picks for sending to another team. For example, having checkboxes in the team-filtered view of the Selections tab. Also, notification of transferred picks having "arrived."
__________________
Hollywood Media Whores FOBL CHAMPION 2007 2020 2035 Last edited by sjshaw : 05-31-2013 at 08:21 PM. |
06-04-2013, 08:06 AM | #116 |
Pro Starter
Join Date: Jul 2005
Location: Appleton, WI
|
Having an issue with the start/end times. No matter what timezone I select, it seems to be altering the start/end times I have selected by adding 3 hours. Basically, I want the clock to start at Noon CST, but it is giving the next person up 7 hours on the clock (when it should be only 4). I was finally able to figure out a start/end time combo that didn't give me the "start time is after end time" error and that got around the problem, but I should be able to enter any time with any timezone without it not seeming to take the timezone changes.
__________________
Commissioner of the RNFL |
06-04-2013, 06:36 PM | #117 | |
Pro Starter
Join Date: Jul 2005
Location: Appleton, WI
|
Quote:
I guess it didn't get around the problem like I thought. Still seems to be starting and stopping the clock at fairly random times.
__________________
Commissioner of the RNFL |
|
06-18-2013, 01:56 PM | #118 |
High School JV
Join Date: Sep 2002
Location: GA
|
The closest thing I've seen to this is when the host webserver does not account for daylight savings time and is an hour off from what you'd expect. So that may explain the 3 hours off from what you want - a webserver time setting. I don't have an answer yet for random stop/starts though.
|
11-13-2013, 05:09 PM | #119 |
High School JV
Join Date: Sep 2002
Location: GA
|
Long delay, and perhaps pointless with the upcoming FOF 7 release, but I've updated the draft utility to 1.9 now.
It includes a "Force Pick" option in addition to the "Skip Pick" so that admins can force a team on the clock to be selected from their list, scout, or BPA without having to look at the lists, guess what the scout would do, or let the time expire. Also, changed the default auto-pick to to OFF after seeing most leagues have preferred it that way. |
11-13-2013, 05:19 PM | #120 |
High School JV
Join Date: Sep 2002
Location: GA
|
Also, after regrettably taking forever to get started after being asked, I now have a working version that will accommodate the Action PC Football game in beta. It doesn't have all of the player fields and stats, but it allows the basic drafting of rookies or free agents to take place using the same interface setup.
|
12-13-2013, 12:47 AM | #121 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
In case you don't get a chance to do this soon, I just exported from the release version of the game the info that I think you'll want to use in Conscriptor for the draft (and maybe staff draft, if that's possible). It's attached.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
12-14-2013, 01:36 AM | #122 |
High School JV
Join Date: Sep 2002
Location: GA
|
Excellent! I just sent you a PM asking for exactly this. I've finished the APCFB mod to the conscriptor tonight and should be ready to turn around and update this thing for FOF7 soon.
|
12-15-2013, 10:12 PM | #123 |
High School JV
Join Date: Sep 2002
Location: GA
|
Ben has me off to a good start and I'm looking at the staff draft, but will first tackle the player draft since it's the most important.
Extractor hangs when I try to run it to grab bar values and the player_record.csv doesn't record those hidden values we could extract like personality, leadership, intelligence for rookies pre-draft. Any ideas? Right now we'd be limited to combine scores and I know people want at least the bar values too. |
12-15-2013, 10:20 PM | #124 |
High School JV
Join Date: Sep 2002
Location: GA
|
Perhaps the best option, and most unlikely, would be if the game were patched so that the rookies.csv file would contain the estimated (blue) bar ranges for each rookie.
|
12-15-2013, 10:29 PM | #125 |
College Prospect
Join Date: Sep 2010
|
Seems like a pretty glaring omission, Jim...
I agree with Wheels' post above. It would be really nice to not require a utility such as extractor in order to set up the drafting...or a tool such as draft analyzer. Last edited by aston217 : 12-15-2013 at 10:33 PM. |
12-15-2013, 10:46 PM | #126 |
High School JV
Join Date: Sep 2002
Location: GA
|
I like the draft analyzer part just because it's a different way to look at the data, but yes, it would be a big benefit to at least allow all the visible data/ratings to be exported when you click the export button.
Anyone else find that their player_ratings.csv file is just filled with 0's? |
12-15-2013, 10:57 PM | #127 |
College Prospect
Join Date: Sep 2010
|
No, that's just for when players don't have ratings in certain categories. For example the first rows in the player_ratings csv's are the passing ones, which tend to be only nonzero for QBs.
And yeah, there's no way you can expect people to go through a 800 or even 80-man draft class clicking the buttons in game! That's cruel! :P |
12-16-2013, 07:44 AM | #128 |
College Benchwarmer
Join Date: Nov 2003
|
So I guess the issue, right, is that there is no single source of information for the estimated blue bar values for each player? Each team gets their own information on that, based on the scouting talents of the coaching staff. Just as a conceptual starting point, I'm not sure I would mind if conscriptor had only the combine numbers, and we had to look at our own data for the estimated bar ranges.
Last edited by corbes : 12-16-2013 at 07:45 AM. |
12-16-2013, 07:53 AM | #129 | |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
Quote:
My vote would be to get rid of the blue bars in Conscriptor and just use the combines. As far as the intelligence, etc. for rookies, keep in mind that that's info that was intended to be hidden. We only started showing it in MP when we realized that Interrogator could grab it and some people could gain an advantage by using Interrogator. Now that there's no Interrogator for FOF7 and Greg has stated that he has no intention of updating his stuff, I'd be all for going back to not having that info unless you interview. A little more mystery in drafting would be a good thing.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! Last edited by Ben E Lou : 12-16-2013 at 08:10 AM. |
|
12-16-2013, 08:59 AM | #130 |
College Prospect
Join Date: Sep 2010
|
Unless people are intended to click through 800-man classes to check out their bars, I think the bar data should be put out there, if not for conscriptor, then for a personal use Draft Analyzer utility.
|
12-16-2013, 10:09 AM | #131 |
College Prospect
Join Date: Sep 2010
|
If the bars are indeed meant to be kept private, I think you can have a setup where each user imports their own 'as they see them' bars into conscriptor. It just doesn't make sense for this (assumed meaningful) data to exist in game, but then not in any utilities that are simply meant to display the same data to the user to allow them to make a decision.
|
12-16-2013, 10:12 AM | #132 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
That would work and keep the burden off the commish. I just don't want to have to run Extractor to get Conscriptor up and running.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
12-16-2013, 10:18 AM | #133 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
Dola:
To be clear, with the amount of effort that may be required to keep league databases updated, I'd want Conscriptor to be as easy as is possible on commishes. Allow me to hit the "Export Data" button in the game, upload stuff from that, and be done.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
12-16-2013, 10:26 AM | #134 |
College Prospect
Join Date: Sep 2010
|
Yeah, exactly. Is extractor working with the new game? Hearing conflicting things, and seems like it might. If it does that's not the hugest deal. But if you can hear this Jim, it'd be really, really great to have this stuff just included in 'export data.'
Ben, what do you mean by 'amount of effort'? Just asking because I'm looking at the export data stuff and it seems more straightforward than in the past, but I haven't thought everything through. Is there going to be more to it than hitting 'export data' and bam, hitting 'load into DB' in the theoretical frontend utility, and bam, done? Last edited by aston217 : 12-16-2013 at 10:28 AM. |
12-16-2013, 10:38 AM | #135 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
Who is going to write that "theoretical frontend utility?"
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
12-16-2013, 10:40 AM | #136 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
Without something to stuff the new format into the old DBUpdater-seeded databases, tons of code will have to be rewritten to accommodate the new format and the csvs uploaded manually.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
12-16-2013, 10:40 AM | #137 |
College Prospect
Join Date: Sep 2010
|
Haha, the magic faeries in the sky? :P
Nah, I'm not questioning the work involved, just asking about what the process is expected to be. I noticed you said "in keeping league databases updated" and thought that was referring to the yearly maintenance work you'd need to do with FOF7, which the export data was supposed to cut down on...but in re-reading, I think you just mean in transitioning from current setups to FOF7. Right? |
12-16-2013, 10:46 AM | #138 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
I fully intend to take a swing at a front-end utility. I just have no idea whether I can actually pull it off.
When I say "keeping," it's more than yearly maintenance. I update my database every single day for the auto-posts, league schedule, etc. GAMEDAY COMPLETED 2037 Week 1 That thread and two others are all posted automatically after the database is updated. So the answer is that it's both things combined: the transition of databases for FOF7 needs to be done in a way that they can be updated daily with the results of that day's sim, whether they are transactions, gamedays, training camp, whatever.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
12-16-2013, 05:02 PM | #139 |
High School JV
Join Date: Sep 2002
Location: GA
|
(operationsports is filtered at work so I'm catching up now)
Those are great points about bar values being team specific. I agree more mystery is good, and combine with the ability to add in your scout's view of bars just for yourself would be nice but there's no way to get that data yet. Ben's right - the initial way will be to write front-ends to transform the export data into old dbupdater form. Eventually, I imagine we'd re-write the code, but to keep it smooth that's the way most leagues would go. I have the initial steps of Conscriptor 2.0 done. No Extractor, no interrogator, no draft preview or draft order files. It currently take just 3 files from the export folder to load it up, will auto-sense between staff and player drafts, and I'm looking into how to make the mock draft continue to work which may require a couple more files from the export folder. I could expand it once it's working to allow you to just enter a URL to the export folder that your commissioner would post online and click "Go" more or less. One attribute not in the rookie file other than bars that should be listed and would be helpful is birthday so you know if you're getting a 6th year senior or a draft repeat. |
12-16-2013, 06:39 PM | #140 |
College Benchwarmer
Join Date: Nov 2003
|
Yeah, birthday is helpful for the affinity hounds too
|
12-16-2013, 06:49 PM | #141 |
High School JV
Join Date: Sep 2002
Location: GA
|
|
12-16-2013, 10:38 PM | #142 |
High School JV
Join Date: Sep 2002
Location: GA
|
UPDATE: I have successfully exported from FOF7, run the Conscriptor from the export files, and imported the draft results.
Still working on the mock draft (since ratings aren't exporting for me) and completely new staff draft option. |
12-18-2013, 05:48 AM | #143 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
Extractor is working fine for me, fwiw. Cuervo reported the same.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
12-18-2013, 06:16 AM | #144 |
High School JV
Join Date: Sep 2002
Location: GA
|
Thanks. Perhaps it's a Win7 thing. I haven't tried it on a different system yet.
|
12-18-2013, 06:21 AM | #145 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
I'm using it on Win7 (Home Premium 64-bit, SP1).
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
12-18-2013, 09:04 AM | #147 |
Morgado's Favorite Forum Fascist
Join Date: Oct 2000
Location: Greensboro, NC
|
It runs much faster, fwiw, presumably because the game isn't trying to calculate statistical standing on the fly any longer.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'! |
12-19-2013, 04:10 AM | #148 | |
Pro Starter
Join Date: Dec 2003
Location: At the corner of Beat Street and Electric Avenue
|
Okay I meant to ask this when I saw this in the help file, but is the Staff Draft in the game already?
Quote:
__________________
"I'm ready to bury the hatchet, but don't fuck with me" - Schmidty "Box me once, shame on Skydog. Box me twice. Shame on me. Box me 3 times, just fucking ban my ass...." - stevew |
|
12-19-2013, 04:29 AM | #149 | |
Pro Starter
Join Date: Dec 2003
Location: At the corner of Beat Street and Electric Avenue
|
Oh and this would help with the later rounds of the Amateur Draft:
Quote:
__________________
"I'm ready to bury the hatchet, but don't fuck with me" - Schmidty "Box me once, shame on Skydog. Box me twice. Shame on me. Box me 3 times, just fucking ban my ass...." - stevew |
|
12-19-2013, 07:41 AM | #150 | |
High School Varsity
Join Date: May 2011
|
Quote:
Most (all?) leagues conduct their draft outside the game allowing GM's to make all picks "live" (at least per the definition in the help file). As such, this is not necessary and has no impact on the draft because it is conducted outside the confines of the game (i.e. through conscriptor or a forum). |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|