Standard League/Teams/Players ID

[Outsider 87]

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

 

[myx]

im waiting for program. want to start making some patch

 

[Outsider 87]

im waiting for program. want to start making some patch

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

 

[savuz]

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.

 

[RobbieD_PL]

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

I think he means CM10 the full version. There are still some bugs that Rinaldo has to iron out.

 

[Outsider 87]

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.

I agree. And I can go on with my program if you want...

I think he means CM10 the full version. There are still some bugs that Rinaldo has to iron out.

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!

 

[RobbieD_PL]

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.

 

[Outsider 87]

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.

Too late mate, I will ask to another project mod

Here you are the first part of my program:


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

 

[savuz]

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.

 

[ujpest4ever]

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

 

[myx]

FIFA Baltic also waiting for your tool to start updating db.

 

[Outsider 87]

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?

 

[savuz]

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?

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

 

[Outsider 87]

savuz: you have an email

Guys, the program is quite ready

 

[myx]

Great waiting

 

[savuz]

savuz: you have an email

Guys, the program is quite ready

Sorry friend, but I didn't recieved it

 

[Outsider 87]

Re-sent the mail to [email protected] mate

 

[Outsider 87]

Just to show you the progress of the tool:


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)

 

[Outsider 87]

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

 

[Keegan]

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!