Announcement

Collapse
No announcement yet.

Tutorial To Create A Team?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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!

  • #2
    Did you change the teamId?

    Comment


    • #3
      Originally posted by mrliioadin View Post
      Did you change the teamId?
      yup!

      Comment


      • #4
        Add record to leagueteamlinks?

        Comment


        • #5
          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?

          Comment


          • #6
            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

            Comment


            • #7
              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.

              Comment


              • #8
                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.

                Comment

                Working...
                X