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

Squad Changes & Main DB

Discussion in 'FIFA 13 Forum' started by Bubble Gum, Dec 5, 2012.

  1. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    Players, teamplayerlinks, teams, formations, player_grudgelove, formupdate, playerloans and previosteam. Everything works good, but new players don't have names and jerseynames. I've transfered dcplayernames, but the game crashes when I try to select teams from some countries. But Sydney FC, for example, works without problems. If names are the last problem, we can just edit them directly into the editing tool. Hope that it will work fine, not like CM 12.5 :).
     
  2. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    No, some countries still don't work :(. It's just a waste of time... I don't know the reason why I can't select England, Germany or Spain....
     
  3. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    Update: I have tryed different combinations and realised that the problem is in teams table. I don't export it and now everything works good, BUT... Arsenal don't work! This is the last defective team! I think that it is caused by formations table, but I am not sure.

    P.S. Of course, if we don't export teams table free kick takers are wrong.

    If I find a problem, 2 difficulties will remain:

    1) Some new players don't have surnames and jerseynames.

    2) Free kick takers are wrong.

    Anyway it will be a good result. If anyone have an opportunity and wish to help me, you are wellcome!
     
  4. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    I've found the problem! Teamplayerlinks has a LOT of empty links. We can just delete them and now everything works correct!

    Now we have only 2 small difficulties that I've mentioned in the post above.
     
  5. BlackEmperor

    BlackEmperor Youth Team

    Joined:
    Jul 12, 2012
    Messages:
    290
    Likes Received:
    0
    Location:
    Germany
    Just to bump this thread up, I've tried it out now as well.
    Everything works fine except for the new player names. Which is a shame because there are so many new players. It will likely work if we change the name IDs. Instead of starting at 29000 or so, they should start one after the last ID in the playernames table. Maybe some kind of search & replace feature could help, I'm not too familiar with Excel.

    By the way, didn't know that the squads were updated today again... so I have to do everything again anyway.
     
  6. BlackEmperor

    BlackEmperor Youth Team

    Joined:
    Jul 12, 2012
    Messages:
    290
    Likes Received:
    0
    Location:
    Germany
    It worked! You can't let the names have an ID of 29000 and above, you'll have to give them lower IDs which come after the last original ID in playernames. 21763 is the first one.
    Then you'll have to change the firstname/lastname/commonname/jerseyname IDs in the players table as well. It works best by simply using Excel. Substract 21763 from 29000 and you'll get 7237. Write it into a free column, copy it and delete it again. Sort the table by firstname/lastname/commonname/jerseyname (the one you want to edit), then highlight everything from 29000 onwards and then use that substract feature. It will automatically substract 7237 (the number you've copied) from every number in the column and you should get the correct IDs. Repeat that for every names column and finally sort the table again by player ID. Import the table again and the names of the new players will be displayed.
     
  7. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    Nice work mate, I've changed the names one by one manually! Your way is much better.
     
  8. or20tzemah

    or20tzemah Club Supporter

    Joined:
    Jan 25, 2013
    Messages:
    9
    Likes Received:
    0
  9. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    I know it's very funny... I have to reinstall FIFA and then I've tried to export squad update from 22.02 but... I can't save changes. I've exported tables with IM and then directly substitute old tables with new ones in DBMaster and save but after reopening old tables are still here. After that I've exported old DB tables and edit notepad documents replacing old info with the new, export it into the DBMaster but with the same effect... Don't know what to do.
     
  10. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    Can't help, sorry. Too much headache-inducing tinkering for my tastes. There are 14,000 players already in the game, that's good enough for me, lol.
     
  11. oasisbrazil

    oasisbrazil Youth Team

    Joined:
    Apr 10, 2012
    Messages:
    119
    Likes Received:
    0
    Location:
    Campinas Brazil
    I tried all above, but when started the game crashed to the desktop.
    I hope someone that have sucess in merge squad update with db, can tell us what exactly is nedeed.
     
  12. lolfifa13

    lolfifa13 Club Supporter

    Joined:
    May 30, 2013
    Messages:
    15
    Likes Received:
    0
  13. coxlenox

    coxlenox Superstar

    Joined:
    Feb 21, 2008
    Messages:
    19,665
    Likes Received:
    1
    Location:
    Campinas-SP
    someone might be better to create a video tutorial explaining and posting in youtube
     
  14. fejige3bi

    fejige3bi

    Joined:
    Feb 22, 2013
    Messages:
    0
    Likes Received:
    0
    Nike Air M

    and fatty tissues,Nike Air Max Shoes Shop. Its secretions drain Cheap Nike Air Max 2014 Shoesonto the surface of the nipple through five to seven main duct orifNike Air Max Shoes Shopices,2014 Cheap Nike Air Max Shoes.
    The breast lies between the skin and the pectoral muscles of the chest (or thoracic wall). It extends from the second to the sixth rib and across from the lateral border of New Air Jordans Shoesthe sternumNike Air Max Shoes Outlet to the midaxillary line. There is excellent blood and lymph supply to the breas
    ????????


    Air Max Shoes on Sale 0008_19

    Air Max Shoes on Sale 0008_49

    2014 Cheap Nike Air Max Shoes
     
      

Share This Page