1. We apologize for the delay. The FIFA 19 Forum is now open. And we are looking into the log in issue.
    Dismiss Notice

Adboards Relinking

Discussion in 'FIFA 15 Adboards, Balls, Boots, Scoreboards, etc F' started by Gothlay, Oct 7, 2014.

  1. Gothlay

    Gothlay Youth Team

    Joined:
    Nov 23, 2010
    Messages:
    364
    Likes Received:
    0
    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.

    [​IMG]

    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.

    [​IMG]

    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.

    [​IMG]

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

    [​IMG]

    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 :)
     
  2. christophe83460

    christophe83460 Senior Squad

    Joined:
    May 14, 2013
    Messages:
    1,572
    Likes Received:
    175
    Location:
    france
    hello Gothlay , I confirm what you said I ais try to add as one of the league adbs dinamic ny but I just can not, I try to ais easier by changing the ids but its does not work I ais try another solution adding lines but knows nothing strange the game freezes and crashes there must be another way besides the db can be lua ?????
     
  3. Gothlay

    Gothlay Youth Team

    Joined:
    Nov 23, 2010
    Messages:
    364
    Likes Received:
    0
    I already asked to Scouser, the lua files are not involved, maybe it could be some xml file, I hope we will find a solution.
     
  4. christophe83460

    christophe83460 Senior Squad

    Joined:
    May 14, 2013
    Messages:
    1,572
    Likes Received:
    175
    Location:
    france
    yes we need to find, to have a beautiful game
    some French competition tropher of the champion I ais doing the normal adboard rx3 into the stadium by default it works without adboard dinamic, I change the stage in compodj and adboard dinamic by default aparait I believe that some stadiums do not manages the dinamic adboard
    I ais disable adboard dinamic for the league and one in my adboard rx3 running like scrolling Horisontales dinamic images and vertical
    must we missing a file to direct all its strange really knows
     
  5. Gothlay

    Gothlay Youth Team

    Joined:
    Nov 23, 2010
    Messages:
    364
    Likes Received:
    0
    After the download of the official Fifa update from Origin, all adboards relinked in my database are not visible in game anymore. I've obviously did the regeneration and all other changes applied by me (kits and so on) work perfectly, but not adboards. Really don't understand why.
     
  6. Andreasmax

    Andreasmax Senior Squad

    Joined:
    Oct 7, 2007
    Messages:
    2,048
    Likes Received:
    187
    Location:
    Germany
    it works

    [​IMG]
    [​IMG]

    this is a Manager with Bayern in the Bundesliga
    I have found the problem in the database, I'm happy....
     
  7. Gothlay

    Gothlay Youth Team

    Joined:
    Nov 23, 2010
    Messages:
    364
    Likes Received:
    0
    Have you relinked animated adboards to Bayern ? If yes, can you please explain how ?
     
  8. Andreasmax

    Andreasmax Senior Squad

    Joined:
    Oct 7, 2007
    Messages:
    2,048
    Likes Received:
    187
    Location:
    Germany
    I have import new animated adboards for bayern, inlc. Database and the big's......
    I have new sponsor, new artificialkey, new adsponserid and I have relink to the team 21 and the compid 19 (1.German league)...

    I will send my Database, and you can see...
     
  9. Gothlay

    Gothlay Youth Team

    Joined:
    Nov 23, 2010
    Messages:
    364
    Likes Received:
    0
    Yes please, send your DB, 'cause I have tried and it doesn't work for me
     
  10. Andreasmax

    Andreasmax Senior Squad

    Joined:
    Oct 7, 2007
    Messages:
    2,048
    Likes Received:
    187
    Location:
    Germany
    you have a PM...
     
  11. Andreasmax

    Andreasmax Senior Squad

    Joined:
    Oct 7, 2007
    Messages:
    2,048
    Likes Received:
    187
    Location:
    Germany
    new animated adboard:


    [​IMG]

    [​IMG]
     
  12. soldier613TR

    soldier613TR Club Supporter

    Joined:
    Sep 18, 2014
    Messages:
    32
    Likes Received:
    0
    link pls. bro :)
     
  13. soldier613TR

    soldier613TR Club Supporter

    Joined:
    Sep 18, 2014
    Messages:
    32
    Likes Received:
    0
    link pls. bro :)
     
  14. Andreasmax

    Andreasmax Senior Squad

    Joined:
    Oct 7, 2007
    Messages:
    2,048
    Likes Received:
    187
    Location:
    Germany
    and this

    [​IMG]
     
  15. Gothlay

    Gothlay Youth Team

    Joined:
    Nov 23, 2010
    Messages:
    364
    Likes Received:
    0
    Do they work in every match ? Also in friendly ? Or only in career or leagues matches ?
     
  16. Andreasmax

    Andreasmax Senior Squad

    Joined:
    Oct 7, 2007
    Messages:
    2,048
    Likes Received:
    187
    Location:
    Germany
    this is in a career...
     
  17. kamaka

    kamaka Youth Team

    Joined:
    Aug 16, 2014
    Messages:
    208
    Likes Received:
    0
    Thanks
     
  18. Andreasmax

    Andreasmax Senior Squad

    Joined:
    Oct 7, 2007
    Messages:
    2,048
    Likes Received:
    187
    Location:
    Germany
    it works for you?

    this is my new animated adboard:

    adboard_bayerntelecom

    this is the adbaord, was you find in my database...you can test whether it with you in a career....

    if you can not see, then save the new career, closed Fifa 15, restart the game an load the new career, now you can see the new adboards...
     
  19. Gothlay

    Gothlay Youth Team

    Joined:
    Nov 23, 2010
    Messages:
    364
    Likes Received:
    0
    The problem is that when you play online or you download squad updates from Origin the changes in database don't work anymore, and you only see default adboards.
     
  20. Andreasmax

    Andreasmax Senior Squad

    Joined:
    Oct 7, 2007
    Messages:
    2,048
    Likes Received:
    187
    Location:
    Germany
    this work is not online kompatible...
     
      

Share This Page