Hi all. Here I will show you how to relink and add how many adboards you want to English Premier League teams. This method doesn't work for other countries teams, even if I've tried all possible solutions to solve this. Maybe someone will help me in discover why.
First of all, you need Database Master by Rinaldo. Open Fifa 15 database and search "sponsor" table.
As you can see, there's a list of all existing animated adboards, which you can find in data_front_end.big file, as images in .big format.
All you have to do to add new adboards to this list is to add new lines, starting from ID 78, and insert all correct info about new file you will create.
After having added all adboards you want to this list, you now have to relink them to teams. You now have to open "teamsponsorlinks" table.
You will see that every line has an own "artificialkey" number, each one has to be different from the others. The first column, "adsponserid", contains the ID number of the adboard, the same one of "sponsor" table.
Relinking new adboards is very simple: create a new line, add the ID of the adboard in the first column, then a new artificialkey, 0 and 1 in next columns as default, and in the last column add the correct ID of the team you are relinking for (1 is Arsenal, 11 is Man Utd, 5 is Chelsea and so on).
Just save your work and the DB work it's done.
Now, you obviously need to import png files into big to create new adboards you have added to the game.
You can easily overwrite existing png files by using Fifa File Explorer by Jenkey, very easy to do. Just choose an existing .big file and import new textures over it. Rename the adboard after importing. I've already created all adboards for EPL, most of them are made by SiaBouncer, some of them created from scratch by me. If you are interested, and if SiaBouncer agree, I will upload my personal folder with all of them.
The big problem is that this method only works for EPL teams. Adding and relinking new adboards for Spanish, Italian, German teams appear useless till now.
What I've discovered is that adboards are relinked with team ID 0 in "teamsponsorlinks" table, it means that all teams with rotating adboards stadium share the same adboards. I've tried to delete these lines and to overwrite them with personalized IDs (Barça, Real, Juventus), but in game I always see "Fifa 15 Ultimate Team", repeated and repeated, this one is maybe relinked with another file and not via Database, so this is something we have to discover.
Just let me know what you guys think
First of all, you need Database Master by Rinaldo. Open Fifa 15 database and search "sponsor" table.
As you can see, there's a list of all existing animated adboards, which you can find in data_front_end.big file, as images in .big format.
All you have to do to add new adboards to this list is to add new lines, starting from ID 78, and insert all correct info about new file you will create.
After having added all adboards you want to this list, you now have to relink them to teams. You now have to open "teamsponsorlinks" table.
You will see that every line has an own "artificialkey" number, each one has to be different from the others. The first column, "adsponserid", contains the ID number of the adboard, the same one of "sponsor" table.
Relinking new adboards is very simple: create a new line, add the ID of the adboard in the first column, then a new artificialkey, 0 and 1 in next columns as default, and in the last column add the correct ID of the team you are relinking for (1 is Arsenal, 11 is Man Utd, 5 is Chelsea and so on).
Just save your work and the DB work it's done.
Now, you obviously need to import png files into big to create new adboards you have added to the game.
You can easily overwrite existing png files by using Fifa File Explorer by Jenkey, very easy to do. Just choose an existing .big file and import new textures over it. Rename the adboard after importing. I've already created all adboards for EPL, most of them are made by SiaBouncer, some of them created from scratch by me. If you are interested, and if SiaBouncer agree, I will upload my personal folder with all of them.
The big problem is that this method only works for EPL teams. Adding and relinking new adboards for Spanish, Italian, German teams appear useless till now.
What I've discovered is that adboards are relinked with team ID 0 in "teamsponsorlinks" table, it means that all teams with rotating adboards stadium share the same adboards. I've tried to delete these lines and to overwrite them with personalized IDs (Barça, Real, Juventus), but in game I always see "Fifa 15 Ultimate Team", repeated and repeated, this one is maybe relinked with another file and not via Database, so this is something we have to discover.
Just let me know what you guys think