Soccer Gaming Forums
Registration is free! Calendar Find other members Frequently Asked Questions Rules User CP Tools Home


Go Back   Soccer Gaming Forums | FIFA Forums, FIFA Mods, Futball > FIFA Series > FIFA 16 Forum

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 29-10-2015, 11:59:PM   #1
eliteone1
Club Supporter
 
Join Date: Oct 2015
Posts: 6
eliteone1 is on a distinguished road
Tutorial To Create A Team?

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!
eliteone1 is offline   Reply With Quote
Old 30-10-2015, 01:21:AM   #2
mrliioadin
Senior Squad
 
Join Date: Apr 2006
Location: Wilmington
Posts: 2,349
mrliioadin is on a distinguished road
Send a message via MSN to mrliioadin
Did you change the teamId?
mrliioadin is offline   Reply With Quote
Old 30-10-2015, 02:50:AM   #3
eliteone1
Club Supporter
 
Join Date: Oct 2015
Posts: 6
eliteone1 is on a distinguished road
Quote:
Originally Posted by mrliioadin View Post
Did you change the teamId?
yup!
eliteone1 is offline   Reply With Quote
Old 30-10-2015, 03:01:AM   #4
mrliioadin
Senior Squad
 
Join Date: Apr 2006
Location: Wilmington
Posts: 2,349
mrliioadin is on a distinguished road
Send a message via MSN to mrliioadin
Add record to leagueteamlinks?
mrliioadin is offline   Reply With Quote
Old 30-10-2015, 03:17:AM   #5
eliteone1
Club Supporter
 
Join Date: Oct 2015
Posts: 6
eliteone1 is on a distinguished road
Quote:
Originally Posted by mrliioadin View Post
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?
eliteone1 is offline   Reply With Quote
Old 30-10-2015, 04:36:AM   #6
mrliioadin
Senior Squad
 
Join Date: Apr 2006
Location: Wilmington
Posts: 2,349
mrliioadin is on a distinguished road
Send a message via MSN to mrliioadin
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/dat...malization.php
mrliioadin is offline   Reply With Quote
Old 30-10-2015, 10:18:AM   #7
bangus
Starting XI
 
Join Date: Sep 2011
Posts: 4,405
bangus is just really nicebangus is just really nicebangus is just really nicebangus is just really nicebangus is just really nice
Quote:
Originally Posted by eliteone1 View Post
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?
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.
bangus is offline   Reply With Quote
Old 28-01-2017, 03:29:PM   #8
jesperscott
Club Supporter
 
Join Date: Jan 2017
Posts: 1
jesperscott is on a distinguished road
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.
jesperscott is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




All times are GMT +1. The time now is 08:41:PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.