Hey guys, been searching around and the closest thing I could find to a tutorial was the FIFA 13 one which doesn't go in depth about anything. I have had time to play around with files, learn about regenerating and things of that nature - but some of the things I've tried have not worked so I was wondering if you guys could point me in the right direction. I installed ModdingWay mod with the extra national teams so I know it loaded the DB properly, but when I modify the "teams" table I duplicated a team for example and changed the name, then regenerated, but it didn't show up. I was wondering if you guys could help me out as I would like to create a national team for Cambodia, thanks!
-
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!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Tutorial To Create A Team?
- Thread starter eliteone1
- Start date
mrliioadin
Senior Squad
Did you change the teamId?
mrliioadin;3873079 said:Did you change the teamId?
yup!
mrliioadin
Senior Squad
Add record to leagueteamlinks?
mrliioadin;3873104 said:Add record to leagueteamlinks?
Nope i had no idea i had to do that. Is there any type of guide at all for at least the basics out there?
mrliioadin
Senior Squad
The best way to learn this stuff is to learn how it works for all games, not just FIFA.
EA, most other companies, and most databases use a process called data normalization. One way to identify that data is normalized is that no simple piece of data will ever be stored twice.
Imagine I wanted to make a table with a player's name, country of origin and their position.
I could write out...
Bob Smith, USA, Defender
Mark Poncy, UK, Defender
Erin Brockofacer, USA, Striker
But I'm wasting a ton of data repeating country names and positions. Also, what if another Bob Smith comes along? That's a common name. It's highly probably that at some point another Bob Smith from the United States who plays defender gets added to my database. Now I have no way to distinguish between those two rows.
Instead, let me make three tables. Nations. Positions. Players.
Within each table, let's make sure that each row has a unique Id that never repeats in any other row.
NationId, nationname
1 , USA
2 , UK
3 , Brazil
PositionId, position
1 , defender
2 , midfielder
3 , striker
PlayerId, name , nation, position
1 , Bob Smith, 1 , 1
2 , Mark Ponce, 2 , 1
3. , Erin Brockerface, 1, 3
Now, we stopped repeating 'USA' and 'defender. Everything is stored only once. The database structure and the exe builds the interrelationships. It might say, 'I see that Bob Smith is from country 1, what is country 1? I see that it is the United States. I'll show the user, "United States."'
Now what if we have one player on two teams? Do we store that player twice? Hell no. Enormous waste of space. Instead, let's build another table that just links a player to a team.
UniqueId, playerId, teamId
1 , 2 , 130010
That would link Mark Ponce to a team with Id 130010.
When you go to make a team, it will be created in a very similar way but with a table set aside to link the team and league.
Preserves data, minimizes data storage. Maximizes pliability.
This is data in the third normal form and you can read more about it here. It's a very common, very efficient form of data normalization. Starting to see how it works?
http://www.studytonight.com/dbms/database-normalization.php
EA, most other companies, and most databases use a process called data normalization. One way to identify that data is normalized is that no simple piece of data will ever be stored twice.
Imagine I wanted to make a table with a player's name, country of origin and their position.
I could write out...
Bob Smith, USA, Defender
Mark Poncy, UK, Defender
Erin Brockofacer, USA, Striker
But I'm wasting a ton of data repeating country names and positions. Also, what if another Bob Smith comes along? That's a common name. It's highly probably that at some point another Bob Smith from the United States who plays defender gets added to my database. Now I have no way to distinguish between those two rows.
Instead, let me make three tables. Nations. Positions. Players.
Within each table, let's make sure that each row has a unique Id that never repeats in any other row.
NationId, nationname
1 , USA
2 , UK
3 , Brazil
PositionId, position
1 , defender
2 , midfielder
3 , striker
PlayerId, name , nation, position
1 , Bob Smith, 1 , 1
2 , Mark Ponce, 2 , 1
3. , Erin Brockerface, 1, 3
Now, we stopped repeating 'USA' and 'defender. Everything is stored only once. The database structure and the exe builds the interrelationships. It might say, 'I see that Bob Smith is from country 1, what is country 1? I see that it is the United States. I'll show the user, "United States."'
Now what if we have one player on two teams? Do we store that player twice? Hell no. Enormous waste of space. Instead, let's build another table that just links a player to a team.
UniqueId, playerId, teamId
1 , 2 , 130010
That would link Mark Ponce to a team with Id 130010.
When you go to make a team, it will be created in a very similar way but with a table set aside to link the team and league.
Preserves data, minimizes data storage. Maximizes pliability.
This is data in the third normal form and you can read more about it here. It's a very common, very efficient form of data normalization. Starting to see how it works?
http://www.studytonight.com/dbms/database-normalization.php
There is no tutorial, no. There are several tables in the db you need to edit when creating a team, I suggest you head over to the editing forum and start reading, most all the info is there.eliteone1;3873108 said:Nope i had no idea i had to do that. Is there any type of guide at all for at least the basics out there?
jesperscott
Club Supporter
As mrliioadin mentioned,
When you go to make a team, it will be created in a very similar way but with a table set aside to link the team and league.
To create a team, you should have hands on practice on creating tables, forms, and queries in databases.
Studytonight and this tutorial http://www.tutorialology.com/dbms/normalization/ is very helpful in creating databases and normalization stages 1NF, 2NF and 3NF.
When you go to make a team, it will be created in a very similar way but with a table set aside to link the team and league.
To create a team, you should have hands on practice on creating tables, forms, and queries in databases.
Studytonight and this tutorial http://www.tutorialology.com/dbms/normalization/ is very helpful in creating databases and normalization stages 1NF, 2NF and 3NF.