Database

[moring]

Looking through the database files for players there are fields for first name and last name, in the fields are just numbers, I am assuming that these are cross referenced with another database to pull that number to get the assigned name to that number. I can't seem to find the name database to cross reference these numbers to, am I missing something?

[Tim Plum]

its in a file folder called names. This should be in the mods forum.

[moring]

This is not for a mod, just general discussion, there is no mdb, dat file in the NAMES folder, at least not in the demo, just a simple text file that has 1 first name in it and 1 last name in it. In the 'full version/beta version' is there an mdb or dat file there with names in it?

[Tim Plum]

thats the file for names, the locked dbases access the notepad files, in the full version its the same way that way adding/modding names is very simple.

[moring]

Yes that would seem simple, but I guess what I am getting at here... perhaps I didn't clarify it... When looking at the stats.dat file in say a save game, there is a table such as team100players, in that table their are first name and last name fields with all numbers, not names... which leads me to believe that there must be a .dat or .mdb file that the game cross references the stats.dat file to pull the name utilizing the number provided in the stats.dat file. So I guess what I am asking is the following, in your 'version', in the NAMES folder is the firstnames.txt have 1 name in it, or is it populated with A LOT of names, if yours just has a single name in it, where is the cross reference file that the stats.dat file is using to match player names with the numbers referenced in it. I hope that was more descriptive.

[Tim Plum]

the "full" version has a first and last name files in .mdb

[moring]

[QUOTE=Tim Plum]the "full" version has a first and last name files in .mdb[/QUOTE] Thanks Tim, that answers my question... sometimes I hate forums, it can be tough to find the right way to ask your question and equally frustrating for those trying to answer to find the right answer to give. :)

[Tim Plum]

np, glad to help

[coachcbj]

some name sin the database but not realistic. what I mean by that is more common names like Smith and Jackson, should be seen more. If I go into the name database and add in common names OVER very uncommon names will it raise the % of those names being used in the game?

[21C__]

[QUOTE=moring]When looking at the stats.dat file in say a save game, there is a table such as team100players, in that table their are first name and last name fields with all numbers, not names... which leads me to believe that there must be a .dat or .mdb file that the game cross references the stats.dat file to pull the name utilizing the number provided in the stats.dat file. So I guess what I am asking is the following, in your 'version', in the NAMES folder is the firstnames.txt have 1 name in it, or is it populated with A LOT of names, if yours just has a single name in it, where is the cross reference file that the stats.dat file is using to match player names with the numbers referenced in it. I hope that was more descriptive.[/QUOTE] In the same stats.dat file, there is a table of [I]First Names[/I] and [I]Last Names[/I] and their corresponding number. For example, [QUOTE]Id,FName 1,A.D. 2,A.J. 3,Aaron 4,AB 5,Abdual[/QUOTE]

[21C__]

BTW I just tested it by changing the first name of one of my players in the [I]First Names[/I] table and it was changed when I re-opened the game.

[Tim Plum]

the number is a frequency that you will see that particular name, not a % so change the numbers and names as you see fit.

[21C__]

Umm, if you are talking about the [I]Id[/I] in the example I quoted above then that is not the case. That [I]Id[/I] is just the matching key for the [I]First Names[/I] and [I]Last Names[/I]. As far as I can tell, there is no frequency for a given [I]First Name[/I] or [I]Last Name[/I]. If a name appears once then it has the same chance of appearing as any other name. You should be able to change its likelihood of appearing by increasing the number of times that this name appears in the list. I have no idea if Arlie is using a fixed value for the [I]First Names[/I] ( 1511 in the list ) and [I]Last Names[/I] ( 3525 ) - or if he is using a RecordCount on the table. If he is using a fixed number then there may be no effect to adding more names to either list.

[Arlie Rahn]

The First and LastNames table in stats.dat should not be changed ad-hoc. If you want to add names, you can use the text file. If you wish to edit players, there will be an in-game player editor to allow you to do that. Keep in mind that hundreds of players may be mapped to a certain first or last name ID in the game. So, changing one could impact many players.

[21C__]

Thanks for clearing that up.

[Tim Plum]

the text file has a number in it thats the frequency as Arlie said I wouldn't mess with the dbase side. Wait for the in-game editor.

[gambler1650]

I looked at the text file. There's just one name in it.. "Rahn,1" So to add any other names you just add a new line with: "Name, #"? The number is frequency but... what's the average number? 1? If you make it a 2 does that mean you end up with double the chance of getting that name compared to the basic names in the db? How do you make the chance of getting the name less common? Help gratefully accepted.. :)

[Tim Plum]

the text file I see is much more extensive so I don't know exactly what yours says but yes you add a name and number the number is a frequency of it being selected not a % chance. There is no "average" if you want more "Joe" then "Charlie" put a higher number, I know names have 50-60 frequencies.

[gambler1650]

The text file I'm referring to is: LastNames (text document, not the Access document) in the Names directory...

[Tim Plum]

I'm a tester so I see alot more then the demo version thats what I meant, you see the file if Rahn,1 is what you see then thats all Arlie is allowing you to view in the demo.