Player Editor

[jdhalfrack]

Okay, I have made a league database editor. It's probably not 100% done, but it's done enough to call it a version 1.0. I do have a couple questions, though.

Link to current changelog/version

First: I have two league files given to me by two different people. One has a field under players called "s_GUID" whereass the other doesn't. I need to know if that field exists anymore (like maybe I got an old league file form one person) or if it only exists in certain leagues.

Second: Where can I post this file? I mean, I have a website that I could probably post it on, butI am only allowed like 5MB of transfer in a day or something like that. That means that only like 4 or 5 people would be able to download it a day.

Here's a quick screen shot:



As I learn more about the game, the editor will expand.

JD

[DirkGildun]

1) I don't know the answer to this one.

2) You can upload it to FBMax.com.

[simmer]

JD, that is unbelievable.....I thought you were going to release it by the weekend. When are you planning on getting the game? There are some quirks in it that I was hoping could be resolved with possibly an addon to your utility. I am a man of my word and I will purchase your game if you want. I know this game is going to ROCK the house.

[jdhalfrack]

ORIGINAL: simmer

JD, that is unbelievable.....I thought you were going to release it by the weekend.

Well, I found an easier way to do what I was doing. After that, the code just flew. After I start playing, I will be able to make even better stuff. But in reality, thank the creators for using ACCESS databases. They are SO easy to edit.

ORIGINAL: simmer

There are some quirks in [the game] that I was hoping could be resolved with possibly an addon to your utility.

As soon as I get the game, we will start working on editing/fixing the quirks. Truthfully, I wouldn't mind consulting with the creators and seeing if maybe I can make some editors for them (the ones they don't want to make, like a league version converter) to release with the product. These guys try as much as they can to answer the suggestions of the players, but there are just somethings they don't have the time to do. My hope is that me and some other guys out there DO have the time.

ORIGINAL: simmer
I am a man of my word and I will purchase your game if you want. I know this game is going to ROCK the house.

Okay, I am going to be completely honest. I HATE doing programs for money. I think making editors to make a game (whatever game it is) better should just be something that people with the knowledge to do so should do if they have time. That's the thought process over at football-freaks and from what I can tell, it's the thought process here, too.

However... It would benefit me GREATLY if you guys wouldn't mind combining some money and purchasing the game for me. Both me and my wife are Lutheran school teachers, so, unfortunately we aren't made of money. We're not poor by any means [:)] but poor enough to piss my wife off when I asked if I could buy this game.... [:(]

And, I promise you, that will be the last time I EVER ask for anything in return for my services.

JD

[simmer]

I sent you an e-mail.....Respond accordingly

[jdhalfrack]

[s]Currently it can be found here: FB Max Database Editor[/s]

(Updated link below)

[Marauders]

It looks nice JD!
 
I am not sure what s_GUID does, but it is part of both the 1.3 and 2.0 player files.
 
Perhaps David can enlighten us.
 

[jdhalfrack]

Just a heads up:
 
I am already aware of a couple things wrong with my program.  I have fixed them and have a new setup program waiting to upload to FBmax.com, but I am going ot wait until the original finally clears the "sorting" section.
 
One of the big things is that any value that is stored as "1" will get changed into a "0" because for some reason vbNull is recognized as a 1, instead of a 0 (which I didnt realize until I released the program).  Plus, I have made a few changes in hopes that it cuts back on a few random errors (usually if the user does something dumb).  So, I would not recommaned using this editor on a league you will actually play (because that vbNull thing is a HUGE blunder).  But, test it out anyway on some spare league files to see how the program works.
 
Sorry! [:(]
 
JD

[sttfrk]

would you email me the new version? 

Thanks.

Edit: new version uploaded to FBMax.

[jdhalfrack]

[s]Currently it can be found here: FB Max Database Editor[/s]

(Updated link below)

[garysorrell]

Incredible work jd, I will give it a whirl after I get back from taking my 3 ghouls candy hunting.

I am pretty sure that as long as edited data remains in its proper place, there shouldnt be a problem.

The only other file that the game produces related to a league is the gamelog, after a completed game.
The gamelog is a boxscore and a play by play in a txt file.

[DreamTeams]

This looks super. I plan to give it a try.

[Tbird]

Nice work so far no problems [8D]

that s_GUID is also in the maindata.mdb file in the leagues table

[jdhalfrack]

First of all, I'm glad there's been no problems so far. Keep letting me know if any of you find any bugs/errors or if any of you have any suggestions to make the editor more user friendly.

that s_GUID is also in the maindata.mdb file in the leagues table

Ultimately, what I did is just add a check to see if there is a s_GUID field. If there is, it grabs its data, if there's not, it skips it. Hopefully, that won't cause problems anywhere. Until I figure out what that field actually does, I have to do it this way.

JD

[simmer]

How do we go about getting the game for you??

[jdhalfrack]

ORIGINAL: simmer

How do we go about getting the game for you??

I Just PMed you about this. You're a good man [&o]

[David Winter]

Hi.

In regards to the s_GUID field. The database for the game are created in JET 2.5 format (yes I know it's old but it's also lightweight and pretty much everything can talk to it). When a game database is opened in Office 2000 or higher the new version of JET displays that field. It could very well be an existing yet hidden field for JET 2.5 and when the DB is opened in other tools, it gets exposed. I've never had a clear reason given as to why it needs to do this, but apparently microsoft thinks it's important.

The game doesn't use it, but I could see it potentially causing problems for the games importing and exporting tools.

I'm afraid I've not done a lot of investigation to determine what impact that field has on the game.

thanks
David

[simmer]

JD I did not get your PM.

[jdhalfrack]

UPDATE! The Updated file can be found here:

Max FB Database Editor v 1.2

Once it gets "sorted," the location will move and I'll update the link.

MAKE A BACKUP before using this program. I have only tested this on League databases but not how the changes affect the game itself! I am not promising that there are no bugs or anything.

CHANGE LOG:
- Reworked some code to make the "Temp Save" function a quicker function.
- Changed "Quarter Back" to "Quarterback"
- Made some aesthetic changes with the player list box (probably not even noticible)
- In the player list box, I changed the first name to be in the second column and the last name to be in the first column
- Added the "Free Agents" to the team sorting selection
- Added the ability to change the player's team
- Added some extra safety checks to help against user errors
- Added the ability to edit a player's Junior Football team (which I assume means college)
---- To use this feature, either select a college from the drop down menu, or if you don't see the college you want in the drop down menu, check the box and type in your own.
---- The editor will not use the name of the college you typed in unless the box is checked!
- Added the ability to global edit all players' Junior Football teams

When using this program, clicking the "Temp Save" button saves the data on the current selection to the program, but not the database. To make all changes permanent (aka, save them to the database), goto Database --> Save.

Let me know immediately if there are errors. I don't own the game, yet, so I am not sure of all the different types of files it creates.

Goodluck and Enjoy!

JD

P.S. simmer, not sure why you didn't get my PM.... I'll send it again.

[MAF]

Good work JD, but I don't see where "Junior Football team" is located on the editor. Am I missing something?