Standard League/Teams/Players ID

Discussion in 'FIFA 10 Megapatch Forum (Private)' started by Outsider 87, Oct 8, 2009.

  1. Outsider 87

    Outsider 87 Starting XI

    Joined:
    Jan 19, 2007
    Messages:
    2,952
    Likes Received:
    0
    Location:
    Italy
    So, even if most of you still don't have answered the poll, I'm going to write here something about the standards we want to use for leagues, teams and players.
    About leagues id and teams id we will use a fifamanager table that has lots more leagues_id and teams_id used by that game. It is better to use original EA ids when possible!
    Then new teams will be created using the program I'm doing (see below).
    About players id me and Robbie thought about this possibility:

    a) When sites want to update already existing leagues we define a range of 200 players id for each league: given that the league is already present 200 new players should be enough!

    b) When sites want to create new leagues we define a range of 1000 players id for each new league. 1000 should be enough for a 20 teams league: they are 50 players per team.

    An important note: WE invite sites to use original player id (even if out of range) when possible, that is for players that were present in previous fifa and that are not present in FIFA 10. Why? Because EA SPORTS is not well known for cleaning things properly and the commentary callnames are surely still there. So if they use the original id also the commentary callname is being activated.

    The big difficulty, especially for b) point, is how to make this. I mean: lots of sites use only Creation Master and it is not so quick to change every id to every player to keep the range chosen.
    So the solution is this:
    I'm making a program (I hope to finish it in 1-2 weeks) that, using some pre-determined tables, will allow you to:
    1) choose your league to create among the list provided
    2) find if there are already some ids for the teams of that league
    3) decide how many new teams you want to create for that league and create that number of teams with the range id chosen for that league
    4) decide how many players to create for every team and create them, assigned them to teams with the range id chosen for the leagues.

    All this things are done as template, so teams are created in this way:
    Liga_1
    Liga_2
    etc
    and players in this way:
    player1_Liga
    player2_Liga
    etc

    so that it is easy for everyone, then, edit those players/teams with CM and KEEPING the range id chosen for them without NEVER changing the id.

    I need a favour from Robbie or from other mods: I need the tables to use in this way. Please use the fifamanager xls file I sent you and make these tables (updating data/teams when necessary):

    LEAGUES:
    league_name,league_id
    eg: Serie A,31

    TEAMS:
    league_id, team_name, team_id
    eg: 31,Milan,47

    LEAGUE_TEAMS_CREATION:
    league_id, starting_team_id
    eg.
    66,140000
    67,140030
    68,140060
    The range above (starting_team_id) has to be chosen in a way that there cannot be already existing team (previous table) in the range between the starting_team_id and the starting_team_id of the following row.
    And I think that 30 teams_id range is more than enough, do you agree?
    By the way my program will start counting the teams_id from the starting_team_id until he needs to make the wanted number of teams. And my limit is 30 teams! So just make sure that there is at least a 30 ids difference between every starting_team_id of the different leagues.

    LEAGUES_PLAYERS_CREATION:
    league_id,player_id_from,player_id_to
    eg:
    66,120000,121000

    In this table remember:
    at least 200 players_id range for already existent leagues
    at least 1000 players_id range for new leagues
     
  2. myx

    myx Senior Squad

    Joined:
    Apr 14, 2006
    Messages:
    2,479
    Likes Received:
    0
    Location:
    Alytus,Lithuania
    im waiting for program. want to start making some patch :)
     
  3. Outsider 87

    Outsider 87 Starting XI

    Joined:
    Jan 19, 2007
    Messages:
    2,952
    Likes Received:
    0
    Location:
    Italy
    Well mate, I don't know if I will finish the program. It seems that lots of sites are not interested anymore in this project: they don't answer my mail neither come here :(
     
  4. savuz

    savuz Youth Team

    Joined:
    Jun 9, 2007
    Messages:
    137
    Likes Received:
    0
    Location:
    The Netherlands
    Fifavoetbal is still in the game with their Dutch Second league patch ... Could the other members who still participate in this patch, say they participate as well? This could clear which site's aren't interested in this project.
     
  5. RobbieD_PL

    RobbieD_PL Unreliable deceiver Staff Member Moderator

    Joined:
    Mar 29, 2004
    Messages:
    11,702
    Likes Received:
    504
    Location:
    Melbourne, Australia
    I think he means CM10 the full version. There are still some bugs that Rinaldo has to iron out.
     
  6. Outsider 87

    Outsider 87 Starting XI

    Joined:
    Jan 19, 2007
    Messages:
    2,952
    Likes Received:
    0
    Location:
    Italy
    I agree. And I can go on with my program if you want...

    Mate, if I'm going to continue my program as it seems, can you create those tables I am asking you above? Send me an email if you need further explanations :)
    Thanks!
     
  7. RobbieD_PL

    RobbieD_PL Unreliable deceiver Staff Member Moderator

    Joined:
    Mar 29, 2004
    Messages:
    11,702
    Likes Received:
    504
    Location:
    Melbourne, Australia
    Unfortunately, for the time being, I'm busy with university studies untill the 1st of November. I'll be more than happy to make those tables for you after then.
     
  8. Outsider 87

    Outsider 87 Starting XI

    Joined:
    Jan 19, 2007
    Messages:
    2,952
    Likes Received:
    0
    Location:
    Italy
    Too late mate, I will ask to another project mod ;)

    Here you are the first part of my program:
    [​IMG]

    Only player creation is missing. As you can see in the example in the predetermined tables it is written that:
    1) Premier League has id 1
    2) Premier League has already 2 teams (only an example!) that have an ID in fifamanager or fifa. This does not mean that those teams are present in the game, but that there are already their id.

    You can choose how much teams to create and the program will create the template keeping the id chosen for the league and keeping the id of the already existent teams id. So, for the moment, the program is editing these fifa.db tables creating teams and league template to edit with CM10:
    teams
    leagueteamlinks (only if you tick "Link Teams to League")
    leagues
    I think I will also add the edit to teamkits table adding at least one kit as CM does when you ask it to create a new team!

    In the final release it will be able also to edit and create template for players and playerteamlinks ;)
     
  9. savuz

    savuz Youth Team

    Joined:
    Jun 9, 2007
    Messages:
    137
    Likes Received:
    0
    Location:
    The Netherlands
    Nice stuff Outsider :) Already searched id's for some teams and now I have like 6 teams with original FIFA id. Quite weird to see this, because if you use this original id, the team even has flags in FIFA 10 (very ugly FIFA 06 flags though). Already started with the project, but I think your program would be very usefull. Waiting for your full version, till that time we still work further with our project. Hope the other site's will do the same, so we can release it early this/next year.
     
  10. ujpest4ever

    ujpest4ever Reserve Team

    Joined:
    Jan 30, 2007
    Messages:
    799
    Likes Received:
    0
    Location:
    Nagykanizsa, Hungary
    great tool my mate!!! FIFAZone is still in the project, we have already started working on Hungarian League Patch 10, we'll be ready with the 1st league's grapichs soon, we're working on 2nd and 3rd leagues' grapichs too, but we are waiting for full version of CM10 and for your id tool to start working on database :)

    send me an e-mail or write here if there's something new ;)
     
  11. myx

    myx Senior Squad

    Joined:
    Apr 14, 2006
    Messages:
    2,479
    Likes Received:
    0
    Location:
    Alytus,Lithuania
    FIFA Baltic also waiting for your tool to start updating db.
     
  12. Outsider 87

    Outsider 87 Starting XI

    Joined:
    Jan 19, 2007
    Messages:
    2,952
    Likes Received:
    0
    Location:
    Italy
    Ok, I'll try to finish it as soon as possible (one week?). But I need someone that makes me those id tables the program need to read from...

    savuz, will you?
     
  13. savuz

    savuz Youth Team

    Joined:
    Jun 9, 2007
    Messages:
    137
    Likes Received:
    0
    Location:
    The Netherlands
    Sure if I can help you, I will ;) Let me know what you need and I will do my best. It's maybe more easier if you mail or use a instant messenger like msn, my adress is: click here..
     
  14. Outsider 87

    Outsider 87 Starting XI

    Joined:
    Jan 19, 2007
    Messages:
    2,952
    Likes Received:
    0
    Location:
    Italy
    savuz: you have an email

    Guys, the program is quite ready ;)
     
  15. myx

    myx Senior Squad

    Joined:
    Apr 14, 2006
    Messages:
    2,479
    Likes Received:
    0
    Location:
    Alytus,Lithuania
    Great waiting ;)
     
  16. savuz

    savuz Youth Team

    Joined:
    Jun 9, 2007
    Messages:
    137
    Likes Received:
    0
    Location:
    The Netherlands
    Sorry friend, but I didn't recieved it :O
     
  17. Outsider 87

    Outsider 87 Starting XI

    Joined:
    Jan 19, 2007
    Messages:
    2,952
    Likes Received:
    0
    Location:
    Italy
  18. Outsider 87

    Outsider 87 Starting XI

    Joined:
    Jan 19, 2007
    Messages:
    2,952
    Likes Received:
    0
    Location:
    Italy
    Just to show you the progress of the tool:
    [​IMG]

    As you can see you can also choose the retirement age and contract value to assign to all players that are going to be created.
    The "free agents" form, in fact, will contain the players that are not assigned to any team, but not only related to Fifa 10 but at least to fifa06,fifa07,fifa08 and fifa09 ;) Of course, for them, the program keeps only the id, then you have to create by yourself the other data of the players (it would be complicated to retrieve those data from old fifas that had less values)!
    Still missing 70% of the code to generate new players, then the tool is finished. I hope to finish it in few days (3-4) ;)
     
  19. Outsider 87

    Outsider 87 Starting XI

    Joined:
    Jan 19, 2007
    Messages:
    2,952
    Likes Received:
    0
    Location:
    Italy
    Sorry guys but this is a bad week for me: I got sick (fever and cough), so I could not go on a lot with the program :(
    Moreover I'm making the player routine that is the most difficult one of the program. I really hope to finish it in another week!

    savuz: I still need the tables and I have seen nothing from you so far :D
     
  20. Keegan

    Keegan Yardie Staff Member Moderator

    Joined:
    Sep 18, 2002
    Messages:
    8,960
    Likes Received:
    0
    Location:
    Jamaica - The Sprint Factory
    I'm going to want this program... I have been meaning to make the Digicel Premier League (Jamaica) for years now, and I'd like to do one before I retire from Fifa editing! (Y)
     
      

Share This Page