1. We have just migrated to Xenforo forum platform. Few things to remember:
    - You will need to reset your password in order to login. Reset your pass here: Click here. Be sure to check SPAM folder!
    - Avatars were not migrated. You will need to upload your new avatar

    Regards,
    Soccer Gaming Admin

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
    Hi once more! In the How to.. thread no one can help me, so I've decided to create own thread. The question is: what is the way to make changes in main DB from the squad files permanent? Or is there a way to make own changes in squad files format? Hope that the question is clear and someone know the answer. Thanks a lot!
     
  2. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,015
    Likes Received:
    310
    Permanent changes are made to the db. When you use that db, it creates a new squads save. If you need to make more permanent changes, you have to edit the db again, then delete your current squads save, and then create a new squads save. You don't ever edit the squads save.
     
  3. BlackEmperor

    BlackEmperor Youth Team

    Joined:
    Jul 12, 2012
    Messages:
    290
    Likes Received:
    0
    Location:
    Germany
    Well... since I don't know how to open a squad file, you'll probably have to look the changes up in the game itself (compare current stats with previous stats on a page like sofifa) and then insert them into the database. A really tough endeavour...

    I wanted to do the same, but I'll probably only do it for the Bundesliga at the most.
     
  4. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,015
    Likes Received:
    310
    Oh okay, so he's asking how to make changes in the downloaded squad updates, a permanent part of the db.

    No can do, other than editing one player at a time as BE said.
     
  5. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    Yes I know this. But I want to know if there is a way to export changes from the squad update files from EA to the main DB to have edited skills and new players like Del Pierro, Owen and so on in FIFA base. Now if I make some changes I have to remove old squad files and new skills & players will disappear.

    As I understand there is no way to do it. Nevertheless thank's a lot.

    By the way, squad files can be opened with notepad and there you can find added players surnames.
     
  6. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,015
    Likes Received:
    310
    Okay, I was in fact able to copy data from the squad save file, and paste and save it into my db.

    Squad files can be opened using IM 12. I opened a squad save and exported the players table to my desktop. The table wouldn't import into the db without getting an error message. And I couldn't open the table with Excel (says "locked for editing"). But I could open it with Notepad. Using Notepad, I then:

    - Opened the players table from the db, and deleted the data inside that file.
    - Opened the players table from the squad save, copied the data inside, then pasted the data into the blank players table from the db.
    - Saved, then imported this edited players table back into the db. I was also able to now open this edited players table with Excel.

    The table imported back into the db and saved with no issues. And I was able to start FIFA 13 and play a game.

    If this much worked, it seems to me you could try following this same procedure using any squad save update. You would have to copy the players table info and teamplayerlinks table info from the squads save update file, and paste it into the corresponding db table files. I would try it myself but I don't have any squad updates to test.
     
  7. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,015
    Likes Received:
    310
  8. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    Really nice work. I'll test it and describe results in this topic.
     
  9. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    Steps 2 and 3 are clear, but I failed to open squad update file with IM. What shoul I do step-by-step? I've used this tool only few times... BTW here is the my last squad update file. http://depositfiles.com/files/4uf35pem7
     
  10. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,015
    Likes Received:
    310
    I was hoping someone would post a squad update, thanks.

    It opens in IM 12 fine BTW. Opening/loading involves two steps: the tool asks for your db meta file from your current db folder, then for your squad save. I paste both on my desktop, makes it easier for me.
     
  11. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    Yes, now it works without problems. I'll try to do steps 2 and 3 and see what would happen.
     
  12. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,015
    Likes Received:
    310
    I transferred the squads data, edited the players table and teamplayerlinks table, imported into the db, saved, started FIFA 13, all with no problems. But when I went to play a game, it crashed. Could be other tables need updating as well, like the formations table for example. I know from previous editing that the player positional data in the teamplayerlinks table has to match the teams' formation data or the game won't work. I may also need to load my original db and use that, maybe there are conflicts in my edited db. If you can't get it working, I'll maybe try some things later.
     
  13. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    I've looked through the tables. I think that we have to export players, teamplayerlinks, teams, formations. Also some new player ID's are connected with player_grudgelove, formupdate and previosteam. DCPLAYERNAMES contains jerseynames for added players. Also we may need playerloans table.
     
  14. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    I've exported those tables, but now CM gives an error after selecting of lan.db. An error (wrong value) is in those files:

    в System.DateTime.Add(Double value, Int32 scale)
    в FifaLibrary13.FifaUtil.ConvertToDate(Int32 gregorian)
    в FifaLibrary13.Player.FillFromPlayerloans(Record r)
    в FifaLibrary13.PlayerList.FillFromPlayerloans(Table t)
    в FifaLibrary13.PlayerList.Load(DbFile fifaDbFile)
    в FifaLibrary13.FifaEnvironment.LoadLists(EFifaObjects fifaObjects)
    в FifaLibrary13.FifaEnvironment.LoadLists()
    в FifaLibrary13.FifaEnvironment.Open(ToolStripStatusLabel statusBar)
    в CreationMaster.MainForm.Open()
    в CreationMaster.MainForm.openSelectAllToolStripMenuItem_Click(Object sender, EventArgs e)
    в System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
    в System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
    в System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
    в System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
    в System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
    в System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
    в System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
    в System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
    в System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
    в System.Windows.Forms.Control.WndProc(Message& m)
    в System.Windows.Forms.ScrollableControl.WndProc(Message& m)
    в System.Windows.Forms.ToolStrip.WndProc(Message& m)
    в System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
    в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
    в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
     
  15. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,015
    Likes Received:
    310
    You don't select lan.db when opening the db with CM 13. That's not even an option in the latest version. Choose Open - Select all (13).
     
  16. regularcat

    regularcat Manager Moderator

    Joined:
    Jun 11, 2008
    Messages:
    12,913
    Likes Received:
    153
    the squads data is not on the same order as the database data, if you do not copy it to the correct locations the game will crash.
     
  17. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    I don't understand you guys :). I know how to open DB with CM and I've selected all. I select main fodder of the FIFA, then db-meta, after that ng_db, next lan. db and after that CM crashes.

    Reg, I did everything like bangus said but CM still crashes.

    And what about you guys? Is everything OK or the game still crashes? We have to find what we are doing wrong.
     
  18. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,015
    Likes Received:
    310
    You use DBM 12 to open the tables. Not sure why you're even using CM 12/13, that tool can't edit what you need to edit here.

    Like I said, I was sucessful in transferring the data from tables in the squad save, to the db. After that, I was able to start FIFA 13. It was only when I tried to start a game that it crashed. It's no doubt an issue with more of the tables, but it's not something I'm interested in spending time testing. I never use squad updates, I have my own db I use.
     
  19. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
    Look, ewerything works nice, I managed to start the game and play match. Hope that after relise of CS or other tool I will be able to use this DB. The problem is that now CM gives an error, so editing is impossible.

    Any way, I hope that it will work in future. Thank's for help and good luck in FIFA edeting :)!
     
  20. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,015
    Likes Received:
    310
    Which tables from the squad file did you transfer to the db, to get it to work?
     
      

Share This Page