• This is a reminder of 3 IMPORTANT RULES:

    1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.

    2- Do NOT post in other languages. English-only.

    3- Crack/Warez/Piracy talk is NOT allowed.

    Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.

    Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.

    Thank you!

STEP BY STEP-adding teams with Access!

Alex

sKIp_E
Staff member
Administrator
Super Moderator
I would usually post this in the access thread, but lots of ppl are asking me about it, and doing it with my forms. So ive made tihs short readme, and will be from now on inlcuding it in the download of my forms.
But you can just read it online here:

Adding teams with Access:
Go Tools-Relationships.
Delte Relationships from Teams(ID) to Link_PT, Link_TC and Link_TF
Save
Open Teams table in design view.
Change ID from autonumber to number
Save
Go Tools-Relationships.
Rebuild relationships between teams(id) and link_pt(team), link_tc(team) and link_tf(team)

WHEN YOU REBUILD THESE, YOU WILL BE ASKED IF YOU wANT TO ENFORCE REFERENTIAL INTEGRITY. TICK THIS BOX! Also make sure u go from teams(id) to link_XX(team), in that order and not to link_xx(id)!!!


Ok now to add teams.
Firstly, go to the kits table, and add 5 kits. To find the numbers style, copy a team that you know has the same number and name style (this usually goes with brands, so if you're adding a Nike team, just copy it from another Nike team etc). To find colours, open the colour table.
MAKE SURE THAT FOR THE KITS YOU WANT TO USE, THE "isgeneric" tick box is NOT selected.
1st kit=home kit
2nd kit=away kit
3rd kit=Alt kit
4th Kit=GK kit
5th kit, JUST LEAVE THE ISGENERIC BOX TICKED FOR THIS KIT!

Once youve set up the teams kits.

Go to the teams table (NOT FORM!), and add a team with an ID, starting as low as u can (which should be around 1800).

Make its 1st, 2nd 3rd 4th 5th kits the 5 kits you just added.

save

Now go to the teams form, and simply add the players u want in the team!

Set the teams formations etc!

And away u go.

Make sure u add atleast 16 players (11 starting 5 subs), and no more then 32.

Open Link_TF table, and add a row/record, with ur teams ID number in the team field, and 78 in the federation field if it is a National Team, or 76 if your team is a club (it will appear in "rest of

world")

Now

Download and install kit raptor and flags raptor.

Open the directory their exe's are in (easily found by right clicking on a shortcut, going properties, and then "find target")
Open Teams.ini, and add a line to the file that has:
"YOURNEWTEAMSNAME",XXXX

where XXXX is your new teams id number (NOT KIT NUMBER!)

Do the same thing to flteams.ini which can be found in the same folder.

Import flags, and kits using Kit Raptor and Flags Raptor. Only the kits that you unselected isgeneric for will show up in the game.

Now run the CC, file new. File save (save the BLANK package), and then install the package.

DONE!
 

unknown1

Youth Team
erm a little too confusing...

i don understand the add 5 kits part, how am i suppose to add 5 kits when the kits that i'm using are not form the database???
 

Alex

sKIp_E
Staff member
Administrator
Super Moderator
Originally posted by unknown1
erm a little too confusing...

i don understand the add 5 kits part, how am i suppose to add 5 kits when the kits that i'm using are not form the database???

By add 5kits, i mean in the kits table, add 5 rows. Open the kits table and have a look. You have to add 5 kits because the kits arent already in the game! This is exactly the reason why they need to be added!
You add the kits to the database (not importing anything, just let the db know they excist), by adding 5 rows to the kits table.
THEN you import the kits you want using Kit Raptor!

Hope this clears things up.
If you're confused contact me on MSN, or email me:

[email protected]

Cheers
sKIp_E
 

lettuce_Athens

Club Supporter
And the color of the fans?i made panathinaikos and my fan are red!!Panathinaikos fans are green.Please help me.From where i can change the color?
 

mohawk

Senior Squad
I added players to the Dutch squad and the 1st team all messed up van Nistelrooy playin in midfield etc. although I have made him a right striker...whats going on??
 

^^Snoop^^

Club Supporter
FINALLY got my kits for the new team sorted, thanks a lot sKIp_E :D By the way, I noticed that I added a player in at a certain ID and Motson says "Adams" when he gets the ball. I believe this is to do with the ID's from FIFA 2002, but is there anyway to remove this? Cheers :D
 

Alex

sKIp_E
Staff member
Administrator
Super Moderator
Originally posted by mohawk
I added players to the Dutch squad and the 1st team all messed up van Nistelrooy playin in midfield etc. although I have made him a right striker...whats going on??

This is because:

Either the created teams ID is too high (IF you follow the above directions exactly, and make the ID as low as possible-usually start at 1801 for your first created team).
As ive said, follow instructions step by step, or dont wonder why things dont work properly.

What you need to do is follow the steps from the above post step by step. MAKING SURE when u add the team, u CHOOSE its team ID number, and that you make it as low as possible. For Holland I suggest using 1339, because this is the ID Holland has used in previous version of FIFA, and so it isnt used.

IF YOU LEAVE TEAM ID ON AUTONUMBER THEN FORMATIONS AND NUMBERS WILL BE LOST!

This should be the last time I have to say this.

Cheers
sKIp_E
 

Alex

sKIp_E
Staff member
Administrator
Super Moderator
Originally posted by ^^Snoop^^
FINALLY got my kits for the new team sorted, thanks a lot sKIp_E :D By the way, I noticed that I added a player in at a certain ID and Motson says "Adams" when he gets the ball. I believe this is to do with the ID's from FIFA 2002, but is there anyway to remove this? Cheers :D

IF you start adding players from an ID that has been used in FIFA 2002, then the commentary will still be there. You can get rid of this, by deselecting FIFPRO, BUT this means that your players first name wont be shown, but only his first initial.

I take it you havent used my forms to add this player, because as far as I know they dont start adding players from IDs that low.
What I suggest is just changing the players ID to the one directly after the last EA created player.
To do this, ull have to delete the relationship between players(id) and link_pt(player) by going to tools->relationships
THEN
in players table sort by ID, and make ur added players ID the one directly after the last EA added player.
Save players table, and open Link_pt table.

In Link_PT table find your players old ID in the "player" field, and replace it with his new one.

Now go back to relationships, click and drag from Players(ID) to Link_PT(player), and when the box comes up Tick the box "Enforce Referential Integrity"

Then your done!

It sounds like a bit of work, but really isnt that much.
I suggest getting my forms if u havent though, because they assign give u an ID to use for created players, and as far as I know, these havent been used in previous FIFA's so u shouldnt get commentary ;)

Cheers
sKIp_E
 

mohawk

Senior Squad
Originally posted by sKIp_E
This is because:

Either the created teams ID is too high (IF you follow the above directions exactly, and make the ID as low as possible-usually start at 1801 for your first created team).
As ive said, follow instructions step by step, or dont wonder why things dont work properly.

What you need to do is follow the steps from the above post step by step. MAKING SURE when u add the team, u CHOOSE its team ID number, and that you make it as low as possible. For Holland I suggest using 1339, because this is the ID Holland has used in previous version of FIFA, and so it isnt used.

IF YOU LEAVE TEAM ID ON AUTONUMBER THEN FORMATIONS AND NUMBERS WILL BE LOST!

This should be the last time I have to say this.

Cheers
sKIp_E
Ooops I've been a bad boy (sorry)....it waz on autonumber...I will now revisit this - Thanks ever so much m8 sorry to cause u stress (pretty sure u got enuf worries with El Tel at the moment ;))
 

unknown1

Youth Team
wht abt the pics of thekits that are in the kits selection screen???
i'm making the holland team and the flags and kits are in the CC but how can i get the pics of the kits to appear in the kits selection??
 

Alex

sKIp_E
Staff member
Administrator
Super Moderator
Originally posted by mohawk
Ooops I've been a bad boy (sorry)....it waz on autonumber...I will now revisit this - Thanks ever so much m8 sorry to cause u stress (pretty sure u got enuf worries with El Tel at the moment ;))

hehe tell me about it! Im starting to wonder, why oh why did we sack O'leary ;)

Cheers
sKIp_E
 

^^Snoop^^

Club Supporter
I am using your forms and could've sworn I followed the instructions in the readme right down to the letter ... I'll do what you suggested in your post then and see.

I see what I was doing wrong now. When your forms assigned a number, I assumed it was a CC number and changed it to the lowest free number hehe :)

Okay, question, if I add a player to a team, do I have to change the "Number Of Players" box in the team form?
 

lettuce_Athens

Club Supporter
AWhat about the color of the fans?Can i change it?Please answer me.From where i can whange the color of the new team's fans?Do you know?
 


Top