Announcement

Collapse
No announcement yet.

Squad Changes & Main DB

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Squad Changes & Main DB

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

    Comment


    • #3
      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.

      Comment


      • #4
        Originally posted by BlackEmperor View Post
        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.
        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.

        Comment


        • #5
          Originally posted by bangus View Post
          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.
          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.
          Last edited by Bubble Gum; 05-12-2012, 08:47:PM.

          Comment


          • #6
            Originally posted by BlackEmperor View Post
            Well... since I don't know how to open a squad file
            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.
            Last edited by bangus; 05-12-2012, 09:40:PM.

            Comment


            • #7
              Originally posted by Bubble Gum View Post
              By the way, squad files can be opened with notepad.
              Right, but the editing tool you need to examine and export the various tables is Internal Master 12, download link here:

              http://fifa-master.com/downloads/cat...rnal-master-12

              Comment


              • #8
                Really nice work. I'll test it and describe results in this topic.

                Comment


                • #9
                  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

                  Comment


                  • #10
                    Originally posted by Bubble Gum View Post
                    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
                    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.

                    Comment


                    • #11
                      Yes, now it works without problems. I'll try to do steps 2 and 3 and see what would happen.

                      Comment


                      • #12
                        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.
                        Last edited by bangus; 06-12-2012, 01:16:PM.

                        Comment


                        • #13
                          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.
                          Last edited by Bubble Gum; 06-12-2012, 01:45:PM.

                          Comment


                          • #14
                            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(EFifaObjec ts fifaObjects)
                            в FifaLibrary13.FifaEnvironment.LoadLists()
                            в FifaLibrary13.FifaEnvironment.Open(ToolStripStatus Label statusBar)
                            в CreationMaster.MainForm.Open()
                            в CreationMaster.MainForm.openSelectAllToolStripMenu Item_Click(Object sender, EventArgs e)
                            в System.Windows.Forms.ToolStripItem.RaiseEvent(Obje ct key, EventArgs e)
                            в System.Windows.Forms.ToolStripMenuItem.OnClick(Eve ntArgs e)
                            в System.Windows.Forms.ToolStripItem.HandleClick(Eve ntArgs e)
                            в System.Windows.Forms.ToolStripItem.HandleMouseUp(M ouseEventArgs e)
                            в System.Windows.Forms.ToolStripItem.FireEventIntera ctive(EventArgs e, ToolStripItemEventType met)
                            в System.Windows.Forms.ToolStripItem.FireEvent(Event Args e, ToolStripItemEventType met)
                            в System.Windows.Forms.ToolStrip.OnMouseUp(MouseEven tArgs mea)
                            в System.Windows.Forms.ToolStripDropDown.OnMouseUp(M ouseEventArgs mea)
                            в System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
                            в System.Windows.Forms.Control.WndProc(Message& m)
                            в System.Windows.Forms.ScrollableControl.WndProc(Mes sage& m)
                            в System.Windows.Forms.ToolStrip.WndProc(Message& m)
                            в System.Windows.Forms.ToolStripDropDown.WndProc(Mes sage& m)
                            в System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
                            в System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
                            в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

                            Comment


                            • #15
                              Originally posted by Bubble Gum View Post
                              I've exported those tables, but now CM gives an error after selecting of lan.db.
                              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).

                              Comment

                              Working...
                              X