Front Office Football Central  

Go Back   Front Office Football Central > Main Forums > FOF9, FOF8, and TCY Discussion
Register FAQ Members List Calendar Mark Forums Read Statistics

Reply
 
Thread Tools
Old 03-08-2010, 02:00 PM   #1101
cuervo72
Head Coach
 
Join Date: Dec 2002
Location: Maryland
Likely so.

Another strange thing I just noticed is that two players (one of them Millan the Elder) have 1000+ values in the PoG field. This just happened this year. The other guy doesn't have a kid - at least not yet (though he does have a duplicate name). Also there are a couple dozen guys with '1000' for number of rings.
__________________
null
cuervo72 is offline   Reply With Quote
Old 03-19-2010, 11:04 AM   #1102
Firefly
High School Varsity
 
Join Date: Dec 2007
Maybe we should sticky the utility fix somewhere
Firefly is offline   Reply With Quote
Old 03-28-2010, 10:44 PM   #1103
beargrowlz
High School Varsity
 
Join Date: Jan 2007
Location: Georgia
Any ideas why I can't get the Maddenator to work? Reshack, Extractor, Extender and DBUpdater all work fine. Here's the error message. (I haven't run it since pre 6.3 patch).

Quote:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ArgumentException: An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at Maddenator.MaddenatorForm.LoadMaddenTeams(Int32 dbIndex)
at Maddenator.MaddenatorForm.LoadMaddenTables(Int32 dbIndex)
at Maddenator.MaddenatorForm.buttonRunConversion_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3603 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Fra...7/mscorlib.dll
----------------------------------------
Maddenator
Assembly Version: 1.9.6.0
Win32 Version: 1.9.6.0
CodeBase: file:///E:/Program%20Files/StelmackS...Maddenator.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL...dows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL...089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL...em.Drawing.dll
----------------------------------------
WindowsUtilities
Assembly Version: 1.9.6.0
Win32 Version: 1.9.6.0
CodeBase: file:///E:/Program%20Files/StelmackS...sUtilities.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL...System.Xml.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:



When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
__________________
-Beargrowlz

[email protected]
TCY Golden Scribe Winner - Bear Goes Home

"The measure of a man's real character is what he would do if he knew he would never be found out."
--Thomas B. Macaulay

Last edited by beargrowlz : 03-28-2010 at 10:46 PM.
beargrowlz is offline   Reply With Quote
Old 04-01-2010, 08:22 AM   #1104
Ragin Cajun
n00b
 
Join Date: Jul 2004
So if I'm reading these threads correctly, this program no longer works with 6.3b unless you go in and do some recoding? I think that's my issue with DBUpdater and assuming I'll hit the same issue when I try to do my next draft here in a couple of weeks.
Ragin Cajun is offline   Reply With Quote
Old 04-01-2010, 08:52 AM   #1105
gstelmack
Pro Starter
 
Join Date: Oct 2000
Location: Cary, NC
Quote:
Originally Posted by Ragin Cajun View Post
So if I'm reading these threads correctly, this program no longer works with 6.3b unless you go in and do some recoding? I think that's my issue with DBUpdater and assuming I'll hit the same issue when I try to do my next draft here in a couple of weeks.

There is a registry hack that gets over most stuff, and some files to copy over to the new save file location in 6.3 that lets DBUpdater run. All of that info is in here.

I am not planning any more updates to the utility suite at this time.
__________________
-- Greg
-- Author of various FOF utilities
gstelmack is offline   Reply With Quote
Old 04-01-2010, 11:34 AM   #1106
beargrowlz
High School Varsity
 
Join Date: Jan 2007
Location: Georgia
Let me ask another way then. Has anyone used Maddenator since the patch and gotten it to work?


Cheers.



N/M, thanks anyway. Had nothing to do with the patch surprisingly.
__________________
-Beargrowlz

[email protected]
TCY Golden Scribe Winner - Bear Goes Home

"The measure of a man's real character is what he would do if he knew he would never be found out."
--Thomas B. Macaulay

Last edited by beargrowlz : 04-01-2010 at 01:16 PM. Reason: Fixed it.
beargrowlz is offline   Reply With Quote
Old 04-06-2010, 08:17 PM   #1107
fireems14
n00b
 
Join Date: Feb 2010
Location: North of Seattle WA
Extractor

I am having trouble with the extractor. I followed the instructions then clicked extract and left the computer alone for quite a while. The mouse never moved, the working on line on the extractor never changed. Finally I gave up and clicked away and received a message that said.

"could not connect to CCA lib: 0 the operation completed successfully"

I don't have any idea what this means or what I need to change to make this work.

Any Ideas?
fireems14 is offline   Reply With Quote
Old 04-06-2010, 08:30 PM   #1108
fireems14
n00b
 
Join Date: Feb 2010
Location: North of Seattle WA
extractor

I figured it out. I am on vista so I had to change the compatibility of the program and then also add the run as administrator option.
fireems14 is offline   Reply With Quote
Old 04-11-2010, 08:00 PM   #1109
Ragin Cajun
n00b
 
Join Date: Jul 2004
Just to clarify something before I give up on this...

I've got all the data to input into the DBUpdater. To get that to work with Vista on 6.3 I have to change the regedit Full Path to the User/AppData that the 6.3 path changed all the FOF stuff too?
Ragin Cajun is offline   Reply With Quote
Old 04-28-2010, 12:41 AM   #1110
cubboyroy1826
College Benchwarmer
 
Join Date: Jun 2002
Okay I tried the following for the resource patcher

For XP...

Start-->Run-->regedit

HKEY_LOCAL_MACHINE-->SOFTWARE-->Solecismic Software-->Front Office Football 2007

ONce you're there...

Edit--->New-->String Value

Name the new string value to "Full Path" (no quotes)

Double click on Full Path and in the "Value data" box, enter the path where FOF is now located, down to the \Front Office Football 2007

That's it.


and I am getting an "Unhandled exception has occured in your application.

Any ideas?
cubboyroy1826 is offline   Reply With Quote
Old 06-12-2010, 09:50 AM   #1111
jdavidbakr
High School Varsity
 
Join Date: Feb 2008
Location: Oklahoma
Here's a curious issue: In two MP leagues I'm in (vNFL House and AUFL) we've had teams move. If I run dbUpdater on either of these leagues, the teams retain their old city connection in the database. (It can't be the city files, it seems, because the team names do change to the correct league values, just the city names are still the old ones.) If the commish in AUFL runs the update, he gets the same thing. However, if the commish in vNFL House runs the update, the city values change.

I can't for the life of me figure out why it works for the one and not for the rest of us. Any ideas?
jdavidbakr is offline   Reply With Quote
Old 06-14-2010, 08:36 AM   #1112
Yoda
High School Varsity
 
Join Date: Mar 2006
Location: Woodstock, GA
Help!

NHibernate.ADOException: could not insert: [DBUpdater.Tables.FofPlayergamestats][SQL: INSERT INTO fof_playergamestats (PlayerID, Year, Week, Team, GamePlayed, GameStarted, PassAttempts, PassCompletions, PassYards, LongestPass, TDPasses, INTThrown, TimesSacked, SackedYards, RushAttempts, RushingYards, LongestRun, RushTD, Catches, ReceivingYards, LongestReception, ReceivingTDs, PassTargets, YardsAfterCatch, PassDrops, PuntReturns, PuntReturnYards, PuntReturnTDs, KickReturns, KickReturnYards, KickReturnTDs, Fumbles, FumbleRecoveries, ForcedFumbles, MiscTD, KeyRunBlock, KeyRunBlockOpportunites, SacksAllowed, Tackles, Assists, Sacks, INTs, INTReturnYards, INTReturnTDs, PassesDefended, PassesBlocked, QBHurries, PassesCaught, PassPlays, RunPlays, FGMade, FGAttempted, FGLong, PAT, PATAttempted, Punts, PuntYards, PuntLong, PuntIn20, Points, OpposingTeamID, ThirdDownRushes, ThirdDownRushConversions, ThirdDownPassAttempts, ThirdDownPassCompletions, ThirdDownPassConversions, ThirdDownReceivingTargets, ThirdDownReceivingCatches, ThirdDownReceivingConversions, FirstDownRushes, FirstDownPasses, FirstDownCatches, FG40PlusAttempts, FG40PlusMade, FG50PlusAttempts, FG50PlusMade, PuntNetYards, SpecialTeamsTackles, TimesKnockedDown, RedZoneRushes, RedZoneRushingYards, RedZonePassAttempts, RedZonePassCompletions, RedZonePassingYards, RedZoneReceivingTargets, RedZoneReceivingCatches, RedZoneReceivingYards, TotalTDs, TwoPointConversions, PancakeBlocks, QBKnockdowns, SpecialTeamsPlays, RushingGamesOver100Yards, ReceivingGamesOver100Yards, PassingGamesOver300Yards, RunsOf10YardsPlus, CatchesOf20YardsPlus, ThrowsOf20YardsPlus, AllPurposeYards, YardsFromScrimmage) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Connection unexpectedly terminated.
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd)
at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session)
--- End of inner exception stack trace ---
at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session)
at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session)
at NHibernate.Impl.ScheduledIdentityInsertion.Execute()
at NHibernate.Impl.SessionImpl.Execute(IExecutable executable)
at NHibernate.Impl.SessionImpl.DoSave(Object theObj, EntityKey key, IEntityPersister persister, Boolean replicate, Boolean useIdentityColumn, CascadingAction cascadeAction, Object anything)
at NHibernate.Impl.SessionImpl.DoSave(Object obj, Object id, IEntityPersister persister, Boolean useIdentityColumn, CascadingAction cascadeAction, Object anything)
at NHibernate.Impl.SessionImpl.SaveWithGeneratedIdentifier(Object obj, CascadingAction action, Object anything)
at NHibernate.Impl.SessionImpl.Save(Object obj)
at DBUpdater.DBUpdaterForm.DoPlayerGameStatsUpdates()
at DBUpdater.DBUpdaterForm.RunUpdate()
MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Connection unexpectedly terminated.
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd)
at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session)
__________________
Championships Won
CCFL 2040
PFL 2015 2022 2026 2046
FFL 2013 2014 2015
RNFL 2014 2029
GMFL 2009
HFL 1983 1987 1990
TFL 1983
vNFL 2024
GML 2011
WOOF 2018
Yoda is offline   Reply With Quote
Old 06-15-2010, 07:48 AM   #1113
Yoda
High School Varsity
 
Join Date: Mar 2006
Location: Woodstock, GA
Anyone?
__________________
Championships Won
CCFL 2040
PFL 2015 2022 2026 2046
FFL 2013 2014 2015
RNFL 2014 2029
GMFL 2009
HFL 1983 1987 1990
TFL 1983
vNFL 2024
GML 2011
WOOF 2018
Yoda is offline   Reply With Quote
Old 06-15-2010, 07:51 AM   #1114
Ben E Lou
Morgado's Favorite Forum Fascist
 
Join Date: Oct 2000
Location: Greensboro, NC
Did you try re-running? I don't know what the huge majority of that stuff means, but when I see two places where it says "Connection unexpectedly terminated," it makes me wonder if the database connection was unexpectedly terminated. Maybe you just lost your connection to the interwebs temporarily in the middle of updating?
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'!
Ben E Lou is offline   Reply With Quote
Old 06-17-2010, 07:46 PM   #1115
Yoda
High School Varsity
 
Join Date: Mar 2006
Location: Woodstock, GA
Quote:
Originally Posted by Ben E Lou View Post
Did you try re-running? I don't know what the huge majority of that stuff means, but when I see two places where it says "Connection unexpectedly terminated," it makes me wonder if the database connection was unexpectedly terminated. Maybe you just lost your connection to the interwebs temporarily in the middle of updating?

Yes, I tried re-running it and it just updated like it was a 'midweek' update.
__________________
Championships Won
CCFL 2040
PFL 2015 2022 2026 2046
FFL 2013 2014 2015
RNFL 2014 2029
GMFL 2009
HFL 1983 1987 1990
TFL 1983
vNFL 2024
GML 2011
WOOF 2018
Yoda is offline   Reply With Quote
Old 06-18-2010, 07:32 AM   #1116
Yoda
High School Varsity
 
Join Date: Mar 2006
Location: Woodstock, GA
Just simmed the Conference Round and here is an example of what is being pulled up from week 16.
http://www.goldenerafootball.com/box...away=19&home=0
__________________
Championships Won
CCFL 2040
PFL 2015 2022 2026 2046
FFL 2013 2014 2015
RNFL 2014 2029
GMFL 2009
HFL 1983 1987 1990
TFL 1983
vNFL 2024
GML 2011
WOOF 2018
Yoda is offline   Reply With Quote
Old 06-30-2010, 04:40 PM   #1117
cuervo72
Head Coach
 
Join Date: Dec 2002
Location: Maryland
I really wish that some of the newer info in dbupdater would have been added to interrogator as well. That, or that dbupdater had an option to dump to csv rather than a db (as I cannot figure out if or how I can connect it to our mysql server). *sigh*
__________________
null
cuervo72 is offline   Reply With Quote
Old 07-05-2010, 07:54 AM   #1118
bwyant32
n00b
 
Join Date: Jan 2007
Ok, I just moved to Windows 7 and I did all the regedits but still can't get dbupdater to recognize my saved game files. Here is a few screen shots:

1) This is my Regedit


2) This is the files that are in my App Data folder:


As you can tell I just copied all the files from my program files folder to the app data folder. I tried with just the selected files from an earlier post and that didn't work either.

Any thoughts?
bwyant32 is offline   Reply With Quote
Old 07-21-2010, 08:14 AM   #1119
ravensmac66
n00b
 
Join Date: Apr 2010
Any way to extract contract costs of team roster?
ravensmac66 is offline   Reply With Quote
Old 07-23-2010, 09:37 AM   #1120
jdavidbakr
High School Varsity
 
Join Date: Feb 2008
Location: Oklahoma
Quote:
Originally Posted by ravensmac66 View Post
Any way to extract contract costs of team roster?

I think the data's there, you just have to do the math. The cap, cap loss for each team, and each player's salary and bonus for each year is in the db.
jdavidbakr is offline   Reply With Quote
Old 07-25-2010, 06:46 AM   #1121
ravensmac66
n00b
 
Join Date: Apr 2010
Have tried using Extractor, opening up a player window that shows contract info....does not appear in the results.
ravensmac66 is offline   Reply With Quote
Old 07-25-2010, 05:00 PM   #1122
PackerFanatic
Pro Starter
 
Join Date: Jul 2005
Location: Appleton, WI
Quote:
Originally Posted by Dutch View Post
Speaking of dbupdater...

What are people using for web-hosting that allows remote connections to their web-site databases?

I've got 1&1 and they will not allow the remote connection functionality of the mysql db's.

Does anyone happen to have an answer to this? I've got 1&1 as well and it's annoying that they don't allow it. I've tried a few free hosts out there just to have the MySQL DB and of course those don't allow it either.
__________________
Commissioner of the RNFL
PackerFanatic is offline   Reply With Quote
Old 07-25-2010, 05:02 PM   #1123
PackerFanatic
Pro Starter
 
Join Date: Jul 2005
Location: Appleton, WI
If not the host, is there a way to run DBUpdater from a server rather than locally on my PC?
__________________
Commissioner of the RNFL
PackerFanatic is offline   Reply With Quote
Old 07-25-2010, 05:17 PM   #1124
Dutch
"Dutch"
 
Join Date: Oct 2000
Location: Tampa, FL
I think you just need to switch your ISP. www.aplus.net is the one Ben recommended to me, I switched and the remote connection is no problem now.
Dutch is offline   Reply With Quote
Old 07-25-2010, 05:18 PM   #1125
jdavidbakr
High School Varsity
 
Join Date: Feb 2008
Location: Oklahoma
If enough guys are interested I'd be willing to set up a server just for FOF leagues. I'd give everyone access via FTP and phpMyAdmin, and open the external MySQL ports. I'd have to charge enough to cover the server (depending on how many leagues take me up on it) but you're all paying for hosting already anyway. Thoughts? PM me -
jdavidbakr is offline   Reply With Quote
Old 07-25-2010, 05:27 PM   #1126
Yoda
High School Varsity
 
Join Date: Mar 2006
Location: Woodstock, GA
I am using ixwebhosting. But they really don't like how many resources the conscriptor uses.
__________________
Championships Won
CCFL 2040
PFL 2015 2022 2026 2046
FFL 2013 2014 2015
RNFL 2014 2029
GMFL 2009
HFL 1983 1987 1990
TFL 1983
vNFL 2024
GML 2011
WOOF 2018
Yoda is offline   Reply With Quote
Old 07-25-2010, 06:41 PM   #1127
Ben E Lou
Morgado's Favorite Forum Fascist
 
Join Date: Oct 2000
Location: Greensboro, NC
I've been with aplus.net since 2001 and have had few problems that weren't at least partially my fault. I have six or seven leagues' sites on my server and can take more if needed.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'!
Ben E Lou is offline   Reply With Quote
Old 07-26-2010, 12:23 PM   #1128
jdavidbakr
High School Varsity
 
Join Date: Feb 2008
Location: Oklahoma
aplus.net is a good company, I'll second Ben's recommendation for them.
jdavidbakr is offline   Reply With Quote
Old 07-26-2010, 12:42 PM   #1129
PackerFanatic
Pro Starter
 
Join Date: Jul 2005
Location: Appleton, WI
Does Aplus allow remote MySQL connections with their basic personal plan or do I need something dedicated in order to get that?
__________________
Commissioner of the RNFL
PackerFanatic is offline   Reply With Quote
Old 07-26-2010, 01:36 PM   #1130
Ben E Lou
Morgado's Favorite Forum Fascist
 
Join Date: Oct 2000
Location: Greensboro, NC
Quote:
Originally Posted by PackerFanatic View Post
Does Aplus allow remote MySQL connections with their basic personal plan or do I need something dedicated in order to get that?
Unless they've changed recently, then the basic is just fine. I had remote connections with the 9.99 a month package I had before I upgraded a year or so ago.
__________________
The media don't understand the kinds of problems and pressures 54 million come wit'!
Ben E Lou is offline   Reply With Quote
Old 07-29-2010, 04:03 AM   #1131
Erik Holland
n00b
 
Join Date: Nov 2009
Okay guys, need some help.

I'm on Win7 and can't get extender to find my league files.

I have the : HKEY_CURRENT_USER\Software\Solecismic Software\Front Office Football 2007\Full Path -> direct correctly.

But that isnt the key that extender works on.

So i created: HKEY_LOCAL_MACHINE\SOFTWARE\Solecismic Software\Front Office Football 2007\ Full Path

If the Full Path key derects to any existing directory Extender crashes right on startup.

What am i doing wrong?
Can't i just create the directory where Extender is looking for?

Thank you!
Erik Holland is offline   Reply With Quote
Old 07-29-2010, 04:57 AM   #1132
Erik Holland
n00b
 
Join Date: Nov 2009
Got it to work. For everyone:

Need:
FrFoot2007.exe , cities.fdt, citydata.fdt, injuries.fdt, nicks.fdt, cnames.dll, city.txt. in C:\Users\Y.U.N.\AppData\Roaming\Solecismic Software\Front Office Football 2007

Run Extender.exe compatible with Windows XP SP2 and as administrator

Regedit: HKEY_LOCAL_MACHINE\SOFTWARE\Solecismic Software\Front Office Football 2007\ Full Path-> C:\Users\Y.U.N.\AppData\Roaming\Solecismic Software\Front Office Football 2007
Erik Holland is offline   Reply With Quote
Old 08-07-2010, 04:39 PM   #1133
marc_rdfl
n00b
 
Join Date: Jul 2009
anyone got a quick giude to setting up DB Updater? I.e. what to put in the form on the app
marc_rdfl is offline   Reply With Quote
Old 08-16-2010, 10:10 AM   #1134
hfthomp
n00b
 
Join Date: May 2007
Just thought I'd add my question to this list. I'm running FOF07 version 6.3 on XP and I'm getting the "unhandled exception" error when trying to run the resource patcher. Basically I just want to change the background screen of the game. Any help? Thanks.
hfthomp is offline   Reply With Quote
Old 08-26-2010, 02:34 PM   #1135
PackerFanatic
Pro Starter
 
Join Date: Jul 2005
Location: Appleton, WI
Okay, so I am trying to load all of our 2k7 seasons into our database so we can have the historical data. Currently, we are in 2024 - I loaded our current file, then the EOS 2023 file. Then I loaded a couple random previous seasons, and decided that I wanted to clean up the data and just start fresh (I wasn't sure if loading out of order was the best way to do it)

Our first 2k7 season was 2011, but the earliest file I have is 2013, so I started with loading that. I emptied all the tables and now I get this error:


Loading game data...
Reading file RNFLxxxx.fju
Reading file RNFLxxxx.fpd
Reading file RNFLxxxx26.2013
Game data loaded, processing database...
Connected to MySQL server mysql.themoyes.com version: 5.1.39-log
MySQL connection closed.
DB connection opened.
Game Stage set to 2013 Season End
Writing teams...Done!
Writing team stadiums...Done!
Writing franchise performances...Done! (0 added)
Exception Hit, aborted!
NHibernate.ADOException: Unable to perform find ---> System.ArgumentException: The value "" is not of type "System.Int32" and cannot be used in this generic collection.
Parameter name: value
at System.ThrowHelper.ThrowWrongValueTypeArgumentException(Object value, Type targetType)
at System.Collections.Generic.List`1.VerifyValueType(Object value)
at System.Collections.Generic.List`1.System.Collections.IList.Add(Object item)
at NHibernate.Util.ArrayHelper.AddAll(IList to, IList from)
at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results)
--- End of inner exception stack trace ---
at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results)
at NHibernate.Impl.SessionImpl.Find[T](CriteriaImpl criteria)
at NHibernate.Impl.CriteriaImpl.List[T]()
at DBUpdater.DBUpdaterForm.DoTransactionUpdates()
at DBUpdater.DBUpdaterForm.RunUpdate()
System.ArgumentException: The value "" is not of type "System.Int32" and cannot be used in this generic collection.
Parameter name: value
at System.ThrowHelper.ThrowWrongValueTypeArgumentException(Object value, Type targetType)
at System.Collections.Generic.List`1.VerifyValueType(Object value)
at System.Collections.Generic.List`1.System.Collections.IList.Add(Object item)
at NHibernate.Util.ArrayHelper.AddAll(IList to, IList from)
at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results)
DB connection closed.
Finished!
Run Time: 0min 8sec


I have tried re-running a few times (I had been previously getting an exception on the franchise line, but that cleared out) Any ideas?
__________________
Commissioner of the RNFL
PackerFanatic is offline   Reply With Quote
Old 08-27-2010, 05:40 PM   #1136
PackerFanatic
Pro Starter
 
Join Date: Jul 2005
Location: Appleton, WI
Any ideas anyone? Maybe just blow away the DB and start over? I am started fresh anyway so that wouldn't kill me to do that.
__________________
Commissioner of the RNFL
PackerFanatic is offline   Reply With Quote
Old 08-30-2010, 08:30 PM   #1137
PackerFanatic
Pro Starter
 
Join Date: Jul 2005
Location: Appleton, WI
What fills the fof_gamemappings table? I have uploaded 9 years worth of stats and there seems to be nothing in that table at all...does it matter the order I upload different years of data?
__________________
Commissioner of the RNFL
PackerFanatic is offline   Reply With Quote
Old 10-12-2010, 01:14 PM   #1138
Draghetto
n00b
 
Join Date: Jan 2009
when i open the ResuorcePatcher all is empty and when i try to click on FOF Exe Path i get this I added the needed key but it is still not working, anyone can help My game directory is D:\Games\FOf2007 can this be the problem? not having the default name? I also never had previous version of the game since i just bought the game Thanks Max

Last edited by Draghetto : 10-12-2010 at 01:42 PM.
Draghetto is offline   Reply With Quote
Old 11-14-2010, 11:21 AM   #1139
merry
Mascot
 
Join Date: Oct 2002
Printing the Draft Sheet

Hi,
How do I print out the draft sceen?
Thank you.
Merry
merry is offline   Reply With Quote
Old 11-14-2010, 11:42 AM   #1140
dwardzala
H.S. Freshman Team
 
Join Date: Nov 2004
Asuming you mean from the draft analyzer. You need to export CSV and load into excel, then format and delete columns to taste.
dwardzala is offline   Reply With Quote
Old 01-18-2011, 02:18 PM   #1141
miguelcristovao
n00b
 
Join Date: Jan 2011
i'm trying to use extractor but i just dont know where i can find the files ready to upload to the website. any tips? or do i use the DBUpdater? If so, how do I select a league?
miguelcristovao is offline   Reply With Quote
Old 01-25-2011, 10:28 AM   #1142
gstelmack
Pro Starter
 
Join Date: Oct 2000
Location: Cary, NC
Quote:
Originally Posted by miguelcristovao View Post
i'm trying to use extractor but i just dont know where i can find the files ready to upload to the website. any tips? or do i use the DBUpdater? If so, how do I select a league?

This depends on exactly how / what you want to do.

First off, since the 6.3 data file change in FOF, the UtilitySuite requires some hacking to get it to run. There are details earlier in this thread to fool it into thinking FOF is installed over in the AppData area. However, this will not be necessary within the next few days, I hope to push out a release that correctly supports the new FOF folder structure soon.

Second, what to run depends on what you want. DBUpdater is set up to create and maintain a MySQL database with a large amount of game data. Interrogator dumps similar data to CSV. And Extractor grabs a roster dump of player cards, either for all active players, or scouts, or staff, or most often the draft class (which can then be read by DraftAnalyzer to fool around with combine numbers). Extractor writes to Documents\StelmackSoft\UtilitySuite, while many other tools ask where to put the file and what to call it.
__________________
-- Greg
-- Author of various FOF utilities
gstelmack is offline   Reply With Quote
Old 01-25-2011, 11:08 AM   #1143
Yoda
High School Varsity
 
Join Date: Mar 2006
Location: Woodstock, GA
Great to have you back Greg!
__________________
Championships Won
CCFL 2040
PFL 2015 2022 2026 2046
FFL 2013 2014 2015
RNFL 2014 2029
GMFL 2009
HFL 1983 1987 1990
TFL 1983
vNFL 2024
GML 2011
WOOF 2018
Yoda is offline   Reply With Quote
Old 01-25-2011, 11:13 AM   #1144
gstelmack
Pro Starter
 
Join Date: Oct 2000
Location: Cary, NC
Version 1.9.7 Released!

  • Now uses .NET 3.5 for possible future use.
  • Now built as x86 apps to maybe fix the Maddenator issue (which I'm not set up to test at the moment...).
  • The UtilitySuite now knows about the 6.3+ folder structure and will look for universe and league folders over in the AppData area.
  • Fixed how files were open for reading so Standard Users could read the data files that are still in Program Files.
  • Draft Analyzer now has context menu entries for up/down (already supported keystrokes).
  • Draft Analyzer now has an Edit menu item to seed the draft order from the current sort order. So set up your weights, sort by combine or rating or whatever, then use this menu item to update the current draft order for the players in the list.
  • Draft Analyzer now has a File menu item to export the top 100 players by draft order to a CSV for Conscriptor to import.
With the new export for Conscriptor feature, I'll be happy to take any and all feedback on improving the draft order editing features in Draft Analyzer.
__________________
-- Greg
-- Author of various FOF utilities
gstelmack is offline   Reply With Quote
Old 01-25-2011, 12:16 PM   #1145
Rizon
Pro Starter
 
Join Date: Mar 2004
Location: Oakland, CA
Quote:
Originally Posted by Yoda View Post
Great to have you back Greg!

+1
__________________
Quote:
Originally Posted by Pumpy Tudors View Post
It's hard to throw a good shot with a drunk blonde wrapped around me.
Quote:
Originally Posted by Suicane75 View Post
I don't think I'd stop even if I found a dick.
Rizon is offline   Reply With Quote
Old 01-26-2011, 02:53 PM   #1146
gstelmack
Pro Starter
 
Join Date: Oct 2000
Location: Cary, NC
Is everyone still happy with the combine ranges, coloring, standard devs, etc from Draft Analyzer, or do we need to run some updated numbers after the last two patches?
__________________
-- Greg
-- Author of various FOF utilities
gstelmack is offline   Reply With Quote
Old 01-27-2011, 07:09 AM   #1147
Alf
Pro Starter
 
Join Date: Jan 2001
Location: Rennes, France
Very happy to see you back in FOF !!

Now built as x86 apps to maybe fix the Maddenator issue (which I'm not set up to test at the moment...). <-- what was the issue there ?

I am running Maddenator for IHOF league (I'm running a Windows XP PRO system) and never had a worry with the previous version.

Anything specifdc chanegd there ?
__________________
FOFL - GML - IHOF - FranceStats
Alf is offline   Reply With Quote
Old 01-27-2011, 09:01 AM   #1148
RedHawk00
H.S. Freshman Team
 
Join Date: Dec 2007
anxious to get this loaded this weekend and try to use Maddenator to get some screens for the eNFL! Glad to see your back!
RedHawk00 is offline   Reply With Quote
Old 01-27-2011, 09:52 AM   #1149
gstelmack
Pro Starter
 
Join Date: Oct 2000
Location: Cary, NC
Quote:
Originally Posted by Alf View Post
Now built as x86 apps to maybe fix the Maddenator issue (which I'm not set up to test at the moment...). <-- what was the issue there ?

There were reports of issues with 64-bit Win7/Vista systems, and my theory is that the "Any CPU" configs were running as 64-bit and failing to load the 32-bit supporting DLLs needed by Maddenator. Rebuilding as x86 32-bit apps would fix that if it's the issue. But I no longer have Madden installed to test this out.
__________________
-- Greg
-- Author of various FOF utilities
gstelmack is offline   Reply With Quote
Old 01-27-2011, 10:12 AM   #1150
Alf
Pro Starter
 
Join Date: Jan 2001
Location: Rennes, France
I don't have a 64-bit system to test or I would happily test it.
__________________
FOFL - GML - IHOF - FranceStats
Alf is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -5. The time now is 07:54 PM.



Powered by vBulletin Version 3.6.0
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.