Now it is time to create players. Notice in my list of players of Canada, I have some that have an "x" next to them. These are players that are not in the game. So I have to create them.
There are two tables that you need to edit to add players. table_playerwrite and table_players
table_playerwrite has the names of the players in it. Let's start there. So let's open it.
I'm just going to type in this data because I only have two players to create here. I'm going to use the player ids I'm using in my spreadsheet. So Ante Jazic is playerid 170301, and Mark Watson is playerid 170302.
I suppose your wondering what to put for the birthdate. Well, I don't know how these numbers calculate the birthdate, so I just put in the number I put in for playerid 169999.
For the column "current" and "disablestarhead", just put zero. Why? All the other players have zeros. So put zeros!
Okay, Done with that table, only four to go!
Now you need to get attributes for those players you created. As you can see in the table_players below, that is where you add your player attributes.
So lets discuss the different attributes you see in the table that you will have to create.
playerid - this is the playerid.
acceleration - you can put from 0-100
accessorycolor1,2,3,4,5 Well I don't know what "1" stands for. But most of the players have "1". If you want to add accessories. I would just put "1" for starters. And then experiment with making color changes later.
accessoryid1,2,3,4,5 You can add accessories. No accessories is number "0". I think if put "1" you will have a certain accessory. If you want that you'll have to figure that one out. I think that there are five accessories in the game. But I'm just guessing. Put "0" for now. You won't have accessories to start. I don't want them, so I'll just put "0". If you see a player in the game with an accessory you want to add. Look up the data on that player, then you can add that info with whatever new player you want to create.
aggression - 0-100
anticipation - 0-100
assetid - Make this the same as the playerid
balance - 0-100
ballcontrol - 0-100
creativity - 0-100
crossing - 0-100
dribbling - 0-100
facetypeid - 1 to 25. See chart below
facialhairstyle - 1 to 6. See chart below.
gkpositioning - 0-100
haircolorid from "1" to "5". See chart below.
hairtypeid - 1 to 18. See chart below.
handling - 0-100
heading - 0-100
injuriprone"1" if they are injury prone, "0" if they are not.
legtypeid 1 to 6. Most players have 5.
longballs - 0 to 100
marking - 0 to 100
longballs - 0 to 100
marking - 0 to 100
nationality Look up players that are from the same country that the player you want to create. You'll find the correct # there. So I look up 138292 for Onstad. So nationality number for Canada is 70.
pace - 0 to 100
passing - 0 to 100
playercomposure - 0 to 100
potential - 0 to 100
preferredfoot - "0" or "1" I suppose "0" is right, since there are more players with "0"
preferredpositon1,2,3 - between -1 and 31. It's easiest to use the position number you used in the table_teamplayerlink.
reflexes - 0 to 100
rushing - 0 to 100
shoecolor - 1 to 5 I think 1 is white, 2 is black, and the other ones?
shotaccuracy - 0 to 100
shotpower - 0 to 100
sleevelength - 0 is short, 1 is long
specificfaceid, - put 0, if you know how to create a face. then put the face your designating for the created player. This is not a face creation tutorial, so I will not go on that here.
stamina - 0 to 100
starplayer - put 1 if there a star player, 0 if they are not.
strength - 0 to 100
tackling - 0 to 100
tacticaliconid1,2,3,4 - I don't know what this really does. I would just put zero.
weight - weight of the player in kilos
So you can type in this information directly or do a spreadsheet export to the .mdb as described before. Now only three more tables to go. I'm going to do a spreadsheet import.
