I plan to re-install FIFA 07 now that the new season is underway but I can't seem to find any released roster updates.

Does anyone know if a roster update has been released with transfers up until now? I don't want to download something that restricts me from editing the rosters and apparently has a lot of bugs (CEP)...

If nothing has been released, does anyone have their own updated rosters to share? Thanks.

I plan to re-install FIFA 07 now that the new season is underway but I can't seem to find any released roster updates.

Does anyone know if a roster update has been released with transfers up until now? I don't want to download something that restricts me from editing the rosters and apparently has a lot of bugs (CEP)...

If nothing has been released, does anyone have their own updated rosters to share? Thanks.

I'm guessing EA won't release another roster update for 07 as the 08 is out late september... I'm also looking for a roster update too - but i think it'll have to be fan made ;)

yeah, i dont think fifa will release an update with 08 so close to releasing.. damn :(

Yeah, to clarify, I wasn't talking about an official roster update from EA, I know they won't release any more. Sorry if I was unclear, I'm looking for something released and uploaded to a site, this one or another one, with updated rosters.

If not, does anyone want to share if they have been keeping rosters up to date and upload them somewhere or send them by e-mail? Thanks again.

you could try to do your own.. it might take a while though.. lol

there are lots of patches that will update the rosters such K-League Super Patch 2007 (from FIFAKOREA (http://www.fifakorea.net/english/)) Career Expansion Patch (CEP) (from Sweetpatch TV (http://www.fifa-mra.com/CEP/)) FIFA 4 Fans Patch (from FIFA 4 Fans.de 07 (http://www.fifa4fans.de/downloads/onelink_e.php?showid=657)) etc

... but the patches also include other than just rosters update that i don't wont to have into my fifa07 because there will be tons of bugs! :( wish one of them will allows us only to install the rosters update :p

there are lots of patches that will update the rosters such K-League Super Patch 2007 (from FIFAKOREA (http://www.fifakorea.net/english/)) Career Expansion Patch (CEP) (from Sweetpatch TV (http://www.fifa-mra.com/CEP/)) FIFA 4 Fans Patch (from FIFA 4 Fans.de 07 (http://www.fifa4fans.de/downloads/onelink_e.php?showid=657)) etc

... but the patches also include other than just rosters update that i don't wont to have into my fifa07 because there will be tons of bugs! :( wish one of them will allows us only to install the rosters update :p

Yeah, I would also prefer only the rosters and then install what I want in my game myself.

How is the FIFA 4 Fans Patch (quality, bugs etc.)? Thanks.

Don´t use Fifa4fans patch.

All the german teams are very very overated. (All teams from 2nd Bundesliga with 4 stars???:f***:)

while K-League Super Patch 2007 does not compatible with Creation Master 07.. and contains bugs in World League (inconsistent lineups for Classic XI, World XI etc)

anyone use CEP? how about it?

i was going to get it but i could not be bothered.. i still might

Don´t use Fifa4fans patch.

All the german teams are very very overated. (All teams from 2nd Bundesliga with 4 stars???:f***:)

OK, I could live with that though (a bit expected considering it's a german patch ;) ). How is it otherwise, are there missing players or bad ratings in the bigger leagues, any major bugs etc.?

None of those rosters are up to date...maybe until may or june but none thru the transfer window...I just do my own with CM...thats the easiest and best way since everybody adjusts the player ratings and teams to their own liking and theres always some big players on wrong teams..plus for example the Costa Rican national team is never touched and at least a year out of date.

None of those rosters are up to date...maybe until may or june but none thru the transfer window...I just do my own with CM...thats the easiest and best way since everybody adjusts the player ratings and teams to their own liking and theres always some big players on wrong teams..plus for example the Costa Rican national team is never touched and at least a year out of date.

I appreciate that but since there seem to be no up to date rosters I figured I'd rather take what is available because I refuse to update the rosters from scratch.

You wouldn't like to either upload your rosters to fileplanet (or similar site) or e-mail them to me? I don't know how big the roster files are but I would really appreciate if someone could help me out. You can't all be sitting with rosters that are outdated, right? ;) Thanks.

yeah please upload it :amika:

Well what do you know, I actually found a roster up to date as of 8/8!

http://www.eamods.com/Downloads/details/id=276.html

Gonna try it out now but it looks pretty updated and will save me a lot of extra work.

Wow...that's sounds good...I'm going to download it and take a look...you may have found something alot of people have been looking for, for awhile...I've never even seen that site before.

If someone tries out the file, let us know how that DB turns out. I know the site is reputable because it's a spin-off of the site MVPMods.com who have modded MVP 05 with updated rosters. I've used their work for that game and find it to be very good. I hope it lives up to the quality of the rest of their stuff.

only registered users can download the files? :confused:

If someone tries out the file, let us know how that DB turns out. I know the site is reputable because it's a spin-off of the site MVPMods.com who have modded MVP 05 with updated rosters. I've used their work for that game and find it to be very good. I hope it lives up to the quality of the rest of their stuff.

Yeah, that's why I found it since I also use their MVP stuff.

Pretty random that an american site has a roster update with some thought laid into it, I checked it out for a bit yesterday and the stuff he says he's updated looks rather good. This is definitely a good place to start if you don't want to be spending weeks getting accurate rosters for your game.

I installed the Fifa 4 Fans patch and while the graphics and everything looks good, the roster featured some incredibly inflated player ratings, almost every player in the Premiership had an overall rating of over 80...:|

only registered users can download the files? :confused:

Just register, it takes like a minute...

sounds goooood, has anyone used it?

Edit: i got it and it has no problems for me so far, ty for the find

I hope it has this season's kits as well!
I think what Fifa should do is take a lead from Pro Evo's book and use option files. Makes updating rosters much, much easier.

Yeah it would. I'm glad it works... the Fifa4fans patch is the only one that I found that let me use FIFAECP's stadiums. I hope this one does. Maybe I should back up my FIFA directory first.

Those rosters are pretty good...a good start for sure...the players are on the right teams but alot of the starting 11 and numbers are incorrect...but overall not bad.

I think the CPU in manager mode adjusts the starting 11's anyway and I agree it's a good start. Nice to see someone put in the effort.

It doesnt contain kits, but im pretty sure every EPL kit is on this forum, cirtainly Manchester United, damn... there's enough Man U kits to start a new league. Anyway, Liverpool is up to date, i like this roster patch, means, technically, if the community pulls together, we could release a 2008 mod for fifa 07, (HA take that EA and your lack of updates in ANY game). Id love to see one for the EPL.

the only transfer thats not there that ive seen is tevez from west ham to man u

the only transfer thats not there that ive seen is tevez from west ham to man u
What patch is ?

Those rosters are pretty good...a good start for sure...the players are on the right teams but alot of the starting 11 and numbers are incorrect...but overall not bad.

some league cmp files maybe?

yes the first 11 and the player's no. is not accurate.. bekham wear no. 2 at l.a galaxy.. tevez is still not there at manchester but thanks for the effort :)

Heh. i found either a bug or a team that doesnt qualify to be in the league, Lincoln City Barely has enough players to compete in the league 11 players and 6 subs, thats it, 3 Gk's 3 Defenders, 3 Strikers and the rest midfielders... hows that for the ultimate challenge :)

Surely someone is updating their own rosters/squads? :(

patch is good but is it only roster update or there are other gameplay updates too?because after this roster update when i played games i felt different(gameplay seems to have changed).
Also,beckham salary is too low($13,000 only).

I haven't been able to download the roster file. For some reason, I am having trouble getting registered on the EA Mods website.

Can someone e-mail the file to me at nasl@att.net?

Thanks,
Firefan98

patch is good but is it only roster update or there are other gameplay updates too?because after this roster update when i played games i felt different(gameplay seems to have changed).
Also,beckham salary is too low($13,000 only).

Hi,

There shouldn't be any gameplay updates as it us a database update. The patch may have changed player attributes and team tactics to give it a different feel. I'm going to take a look and open with unidb & access and only replace the the table_teamplayerlinks (that is the table within the fifa.db that contains the rosters) and see how it goes. Thanks to the poster that found this update!

There is a new version out

is there anyone who has already downloaded and used it? how about player's jersey no.? are they've fixed? :p some of the new players created in the previous modified fifa.db make the game crashed :(

i have tried the update-they have not yet fixed the player jersey no.
my fifa.db didnt crashed with the earlier update.so,cant say about the crash because of new players.

Hi,

I reviewed the database and found some potential serious problems.

The person that created the patch/database re-used existing Youth player IDs (607 of them), renamed the players and added them to the teams. The main issues that I see are:

(1) 4 -14 year old players on teams

(2) With the youth ids being used, this could cause potential crashes in subsequent seasons as the ids are already in use

(3) Youths have been depleted by 607 players

Good research.

Hi,

I reviewed the database and found some potential serious problems.

The person that created the patch/database re-used existing Youth player IDs (607 of them), renamed the players and added them to the teams. The main issues that I see are:

(1) 4 -14 year old players on teams

(2) With the youth ids being used, this could cause potential crashes in subsequent seasons as the ids are already in use

(3) Youths have been depleted by 607 players

Hm, interesting. I experienced a crash between the second and third season and this could be why then.

I've edited the hell out of this db but that's just to have something to do until 08 gets released. Guess I won't be starting a new career before that then hehe....

Hi, I'm posting this reply in this thread to avoid hi-jacking the creation master thread.


Originally Posted by leavemealone
link of update which i am using
http://www.eamods.com/Downloads/details/id=276.html
i got this link from the thread "Updated rosters?"


Hi,

This roster update will cause crashes in subsequent seasons because the auther re-used over 500 Youth Ids to create new players. You will run into errors when the game tries to generate a new youth that has an id in use.



Originally Posted by leavemealone
ya.i know.only for first time it runs ok.but from 2nd time there is crash when i start new season with same team.do you know the solution?shall i change the ID or delete young players?

Hi,

*All of my changes were made in the fifa.db*

I solved this problem by editing all of the re-used Youth player Ids and created new ones. example: for 410110, I added a leading 6 to make the id 6410110 (original youth player = Niels Sondergaard, he was replaced by Alexandre Song in the patch). My change reinstated Sondergaard as a youth with id 410110 and I created Song with the new id of 6410110.

I used a different program to edit that extracts the fifa.db into relational database that I open with MS Access.

I had to change the table_players table to edit the player ID. Once I changed all of the ids, I reloaded all of the original Youths from the original fifa.db. After the table_players table was "fixed", I had to edit the table_teamplayerlinks (this is the table that sets the rosters). I made the same changes on this table, meaning, I modified the playerid to have a leading 6 for the used youth ids.

Your random crash at the start of a new manager could be caused by a couple of things, 1) youth assignment is random and you could have hit a duplicate id at the start of the first season, 2) Duplicate Youth Ids can appear when you "scout for new players 3) some of the players that the patch updated kept the original birthdates of the youths - I found a 4 year old on a team .



thanks.
i have installed all tools available from the thread.i have unidb installed on my PC.now i will try to change ID and try as you said above.

Great. The easiest way to find the re-used ids is to go to the table_teamplayerlinks and sort the column by playerid. The youths on the fifa.db are in the range of 400000 - 410974. There should be no players with an id in that range assigned to a team. Once you change the ids, you will need to replace the used id's with the players from the original fifa disk to ensure that the youths are generated properly throughout a manager career.

i am changing IDs but i am not recovering the originals.how are they recovered?

changing 11000 IDs is too much.i am just changing IDs of those players who are assigned to a team.will it work?

changing 11000 IDs is too much.i am just changing IDs of those players who are assigned to a team.will it work?

I don't think so because the free agents can be contracted in career mode during transfer season, so that will cause the infamous loading bar crash between two seasons in a career...

I have updated my fifa.db with up to date transfers and relegation/promotion but I added over 250 new teams and many new leagues, so posting mine won't help the general user either... (and the language db's other than dutch and italian still need to be updated if I should release it to the general public)

I don't think so because the free agents can be contracted in career mode during transfer season, so that will cause the infamous loading bar crash between two seasons in a career...


so what do you suggest to do?

so what do you suggest to do?

Well, there is no easy solution. What I would do is convert the original fifa.db to mdb format and open it in access, then do the same with the edited fifa.db opening it in a second instance of microsoft access.

Delete all youth players in the edited database and replace them with the original youth players. Of course if the editor used youth players id's to replace them with actual players linked to teams you have more work to do.

You'll have to change the id's in the table_players, table_team_player_links and table_playerwrite to id's in the normal range instead of the youth player range (id's 400000 and up, change them to free id's of a lesser value), if this has to be done it's even better to export the whole thing to microsoft excel and replace them "en masse" then importing them back to access... excel is easier to edit a large number of records as you can use the "slider" from cell to cell to increment the values easier than you could do in access.

In any case you're in for a lot of work and above all take backups, several ones. It's up to you if you want to invest that many time in it with Fifa08 lurking around the corner.

Note : If you have the id number changes to do, then of course you'll need to change them first before you "restore" the youth players from the original database.

how do you restore the youth players from the original databases

how do you restore the youth players from the original databases?

As I described above, copy/paste from mdb to mdb in Access.

i am editing fifa.db first time.please elaborate what to do in MS access.
what i have done is i am changing the IDs by adding 6 as suffix in table_players.
i have changed IDs from 410000 to 410974 to 6410000 to 6410974.
now i dont have any players from ID 410000 to 410974.so,i havent been able to recover youth players from original database.so,how to do it?

i want to learn editing fifa.db

i am editing fifa.db first time.please elaborate what to do in MS access.
what i have done is i am changing the IDs by adding 6 as suffix in table_players.
i have changed IDs from 410000 to 410974 to 6410000 to 6410974.
now i dont have any players from ID 410000 to 410974.so,i havent been able to recover youth players from original database.so,how to do it?

i want to learn editing fifa.db

With UniDB program (from Fifa ECP) convert original fifa.db to fifa.mdb, open the converted .mdb in MS Access, do the same with the edited fifa.db, now go to the table_players from the original fifa.mdb, copy all records from 410000 to 410974, paste them into the table_players of the edited fifa.mdb, sort the records by id, from small to greater numbers, do the same for the table_playerwrite. Then convert the edited fifa.mdb back to fifa.db and use it in your fifa07/data/cmn folder

Btw, I don't know if adding the 6 in front of the id will work as I am almost sure Fifa always considers every player id greater than 400000 as a youth player...

thanks.i got it.

i am editing fifa.db first time.please elaborate what to do in MS access.
what i have done is i am changing the IDs by adding 6 as suffix in table_players.
i have changed IDs from 410000 to 410974 to 6410000 to 6410974.
now i dont have any players from ID 410000 to 410974.so,i havent been able to recover youth players from original database.so,how to do it?

i want to learn editing fifa.db

Hi,

You really only needed to update the ids that were in use according to the teamplayerlinks (about 500+ - some were added twice because the players were on a country or allstar team as well).

fifa07 does not use a playerwrite table anymore, so identifying players is a lot easier.

In any case you're in for a lot of work and above all take backups, several ones.


Isn't that why editing is sometimes more fun than playing? :)

Btw, I don't know if adding the 6 in front of the id will work as I am almost sure Fifa always considers every player id greater than 400000 as a youth player...

I haven't run into this issue before, though I did get an unexpected crash every now and then. I'll convert the used youth players to 1-up from the last non-youth in the original data base (I can do this rather quickly). Thanks for the head's up.

btw, do you still do your chant/sound packs?

Thank you,

P10

i think there will be no crash after my editing.
what i have edited is i deleted all IDs 400000+ from the table_teamplayerlinks and no editing in table_players.
now i tested this modified fifa.db 3 times.
1 season with porto and 2 seasons with FC basel 1983 by simulating matches.now there is no crash between seasons.

if someone wants to test the modified fifa.db i can mail it.
thanks to Zefilio and Platini10 for helping me in using unidb.

i think there will be no crash after my editing.
what i have edited is i deleted all IDs 400000+ from the table_teamplayerlinks and no editing in table_players.
now i tested this modified fifa.db 3 times.
1 season with porto and 2 seasons with FC basel 1983 by simulating matches.now there is no crash between seasons.

if someone wants to test the modified fifa.db i can mail it.
thanks to Zefilio and Platini10 for helping me in using unidb.

Hi,

You may run into issues where you play a team without the minimum number of players. There are many teams with at least 5+ ids added to the the teamlinks that were re-used youth ids.

you may also encounter a 33 year old youth :)

If you'd like, I can send you my modifed database. I am changing all of the re-used youth ids to ids that 1-up from the last non-youth on the original fifa.db (I'm starting from 178630). I will also add in all of the real youths from the original and re-link all of the teamplayer links.

If you like to edit, this is a great tool and process to understand the inner linkings of the game. You can also modify any language database (eng.db) and the meta.db with unidb and access. Most changes to the database will ruin a current career, so keep back-ups.

BTW - unidb seems to work fine for fifa08. I was able to play around with the demo db a bit, but did not actually play the demo (I also wanted to extract the new Premiership Numbers to import into fifa07).

Best of luck

P10

nice.thanks for the info.i think that editing fifa.db will be fun.so,i am trying to learn it.

i will also make another fifa.db with all the youth from original fifa.db

Best of luck with your editing.

Here is the database that I created. This has re-issued playerids for the used youth players. I also added back all of the original youths and re-linked all of the players again. All previously used youth ids have now been re-assigned numbers starting with 178630. Keep in mind that I did not modify any bit of the roster that was created by the patch.


Please send me a PM if you would like the link to the download.

P10

thanks for that mate ;)

i have downloaded your fifa.db
now i am testing it for crashes.

nice work.no crash between seasons.

yay, same here with my test

Hmm so where is the new download? did someone edit it out of a post? Oo

Best of luck with your editing.

Here is the database that I created. This has re-issued playerids for the used youth players. I also added back all of the original youths and re-linked all of the players again. All previously used youth ids have now been re-assigned numbers starting with 178630. Keep in mind that I did not modify any bit of the roster that was created by the patch.


Please send me a PM if you would like the link to the download.

P10

it was there.. but now u must PM

Hi,

Here is the link.

Updated Roster Database (http://files.filefront.com/fifadb/;8722224;/fileinfo.html)

P10

good work dude.
Highly neeeded by people not wanting FIFA 08.

Hi,

Here is the link.

Updated Roster Database (http://files.filefront.com/Roster+db+with+fixed+ids/;8508799;/fileinfo.html)

P10

what have you edited in this new database?

what have you edited in this new database?

Hi,

I haven't done any further editing to this database, it's the same one. I am doing personal updates though. There are many teams in the lower English divisions that have insufficient rosters. I am adding about 400 players and updating most of those teams. I am not concerned with attribute accuracy in my add-ins, just a valid name, position, number, birthdate, and a general resemblance of the player. I want full rosters in the lower divisions to avoid crash issues if I have to play one of those teams in my career (cup/promotion).

P10

Hi,

There are many teams in the lower English divisions that have insufficient rosters.
P10

i agree.i once got fired,then i continued my career mode with peterbough and it had only 12 players.

Hi Platini10, I dont seem to be able to find the roster patch at filefront. please help. Thanks.

he´s right i couldn´t find it either... a new download link please !!

Hi Platini10, I dont seem to be able to find the roster patch at filefront. please help. Thanks.

Thanks for the head's up. I updated the link above. You can also click Here (http://files.filefront.com/fifadb/;8722224;/fileinfo.html)

P10

So anyone can give us some feedback on this update ?

well it wont work in manager mode for me.

gets to the loading screen past the sponsor selection and crashes on 80%... any help?

well it wont work in manager mode for me.

gets to the loading screen past the sponsor selection and crashes on 80%... any help?

Hi,

Did you remove your "D. Squads" folder in the My Documents? You need to do that or select "Reset Rosters to original" in the game menu.

Also,

I found a few issues with the roster. I tried the original one that was from the ea site. I found that the person that created the database re-used a bunch of youth player ids to create new players. I re-numbered all of the reused player id's and put back in all of the youths from the orginal database. The issues that I found were as follows: (1) some teams have insufficient rosters, (2) most lineups are not set, and (3) some players are way too young that were created. You can use unidb or cm to adjust the teams to fix some of those issues.

anyone now if there is rosters updated to the lates year?

Might be a bit late in the day to ask for this but here goes:
Does anyone have .cmp files for the following teams ?
Tigre,Olimpo de Bahia Blanca (Argentina)
Stromgodset,Aalesunds (Norway)
Orebro,Trelleborg,Brommapojkarna (Sweden)
Zaglebie Sosnowiec,Ruch Chorzow,Polonia Bytom,Jagiellonia Bialystock (Poland)
LASK Linz, SK Austria Karnten (Austria)
Lyngby, Aarhus (Denmark)
Neuchatel Xamax (Switzerland)
Genclerbirligi Oftasspor, Kasimpasa SK,Istanbul Buyuksehir Belediyespor (Turkey)
Dender, Mechelen (Belgium)
Venlo, de Graafschap (Holland)
Leixoes, Academica Coimbra (Portugal)
Wehen Wiesbaden, VFL Osnabruck (Germany 2)
Eibar,Racing Ferrol,Sevilla Atletico Club (Spain 2)
Angers,Boulogne (France 2)
Ravenna,Avellino (Italy 2)

Hope someone can help

It worked on FIFA 07 XBOX after replacing the old fifa.db via ftp :)