FIFA DB Master - Alternative db editor

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • raupe
    Rookie
    • Apr 2013
    • 199

    #1

    FIFA DB Master - Alternative db editor

    FIFA DB Master can read NHL roster when .db is converted console format to pc. Converting is able to do with myfifa2005 DB Converter. Also localization databases where the team names etc are stored is able to convert to DB Master.
    Usage:
    -Convert the original db and xml using myfifa2005-fifa-db-convert.jar
    -Read the converted xml and db using DB Master

    FIFA DB Master 15:
    Database Master 15 - Updated Links - ModdingWay Mods Database


    MyFifa2005 Converter:
    MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.


    Original DB and XML from NHL Legacy game disc:


    Original language db from NHL Legacy game disc:


    Language strings read in DB Master:
    Last edited by raupe; 02-15-2020, 05:20 PM.
  • Jlnhlfan
    Rookie
    • Jul 2014
    • 363

    #2
    Re: FIFA DB Master - Alternative db editor

    While some things (such as team information and player names) are obvious, some things are confusing (i.e. Mike Modano's height is listed as 21... which has nothing to do with 6'3", with his state being listed as 37, his weight as 55 and his year drafted as 29. What does this all mean?)

    Comment

    • nikethebike
      MVP
      • Aug 2007
      • 1183

      #3
      Re: FIFA DB Master - Alternative db editor

      If I make changes using this, can I get them back into the game some way?


      Playing NHL Legacy on PC with RPCS3.


      ...



      Ok, I think I've got the hang of this now.


      1. Make sure the save is unencrypted (an RPCS3 save can be used as is).
      2. Export the db from SYSDATA using NHL DB patcher v1.2.
      3. Use DB converter to convert the file from PS3 to PC format.
      4. Open the DB file using the XML for NHL Legacy.
      5. Export all tables to CSV
      6. I will try converting and editing the csv AI files with my statistics based attribute tools.
      7. Import edited csvs to tables
      8. Save changes to DB file
      9. Use DB converter to convert the file from PC to PS3 format.
      10. Import the db to SYSDATA using NHL DB patcher v1.2.
      11. Make sure the save is encrypted (an RPCS3 save can be used as is).
      Last edited by nikethebike; 10-30-2022, 02:38 PM.
      Now go play NHL Two K!

      Download the NHL2K20 roster at:
      http://PlayNHL.TK

      Discussion: https://forums.operationsports.com/f...s-nhl2k11.html

      Comment

      • nikethebike
        MVP
        • Aug 2007
        • 1183

        #4
        Re: FIFA DB Master - Alternative db editor

        I've verified this now by blanking off awareness and def awareness to 0 (36 ingame) for all players using excel then importing back. It worked. Now I can convert my tools if I want to edit the excel files. Pretty powerful stuff for roster updates. It does involve a lot of manual steps as you see above, I wish I didn't need all of them.


        Edit: I seem to be getting random freezes in the menu now so perhaps it wasn't as flawless as I thought.
        Last edited by nikethebike; 03-07-2021, 05:05 AM.
        Now go play NHL Two K!

        Download the NHL2K20 roster at:
        http://PlayNHL.TK

        Discussion: https://forums.operationsports.com/f...s-nhl2k11.html

        Comment

        • phatkroger10
          Rookie
          • Jun 2012
          • 143

          #5
          Re: FIFA DB Master - Alternative db editor

          Originally posted by raupe
          FIFA DB Master can read NHL roster when .db is converted console format to pc. Converting is able to do with myfifa2005 DB Converter. Also localization databases where the team names etc are stored is able to convert to DB Master.
          Usage:
          -Convert the original db and xml using myfifa2005-fifa-db-convert.jar
          -Read the converted xml and db using DB Master

          Language strings read in DB Master:
          Have you been able to get strings updated in-game?

          I've converted the nhl_eng_us.db file using DB Converter, renamed all instances of Anaheim Ducks (and the variations of) with DB Master, but after converting back with DB Converter and replacing the file, it still shows Anaheim Ducks everywhere.
          NHL REVAMPED TEAM
          DB Expert, Draft Prospects, College Prospects

          GO SIOUX!
          National Champions: '59, '63, '80, '82, '87, '97, '00, '16

          Comment

          • raupe
            Rookie
            • Apr 2013
            • 199

            #6
            Re: FIFA DB Master - Alternative db editor

            Originally posted by phatkroger10
            Have you been able to get strings updated in-game?

            I've converted the nhl_eng_us.db file using DB Converter, renamed all instances of Anaheim Ducks (and the variations of) with DB Master, but after converting back with DB Converter and replacing the file, it still shows Anaheim Ducks everywhere.
            If you use the latest update for Legacy there are nhl_eng_us.db in the update container and the game will read that file instead of the file in fe/loc folder. What you should do:
            1) Disable the update.
            2) Extract the latest loc db from update and place it to fe/loc folder and set loc db hash to 0 in patch.big:
            https://forums.operationsports.com/f...2&postcount=35

            Comment

            • nikethebike
              MVP
              • Aug 2007
              • 1183

              #7
              Re: FIFA DB Master - Alternative db editor

              Originally posted by raupe
              If you use the latest update for Legacy there are nhl_eng_us.db in the update container and the game will read that file instead of the file in fe/loc folder. What you should do:
              1) Disable the update.
              2) Extract the latest loc db from update and place it to fe/loc folder and set loc db hash to 0 in patch.big:
              https://forums.operationsports.com/f...2&postcount=35
              I'm confused again now. Does my step by step guide above miss a hashing step?
              Now go play NHL Two K!

              Download the NHL2K20 roster at:
              http://PlayNHL.TK

              Discussion: https://forums.operationsports.com/f...s-nhl2k11.html

              Comment

              • Jlnhlfan
                Rookie
                • Jul 2014
                • 363

                #8
                Re: FIFA DB Master - Alternative db editor

                I am editing an NHL 10 database, and I have a question:

                What are all the country IDs? I'm asking because one of the players in a mod I am working on is from Serbia.

                Comment

                • Jlnhlfan
                  Rookie
                  • Jul 2014
                  • 363

                  #9
                  Re: FIFA DB Master - Alternative db editor

                  Originally posted by raupe
                  FIFA DB Master can read NHL roster when .db is converted console format to pc. Converting is able to do with myfifa2005 DB Converter. Also localization databases where the team names etc are stored is able to convert to DB Master.
                  Usage:
                  -Convert the original db and xml using myfifa2005-fifa-db-convert.jar
                  -Read the converted xml and db using DB Master

                  FIFA DB Master 15:
                  Database Master 15 - Updated Links - ModdingWay Mods Database


                  MyFifa2005 Converter:
                  MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.


                  Original DB and XML from NHL Legacy game disc:


                  Original language db from NHL Legacy game disc:


                  Language strings read in DB Master:
                  Since NHL 07's databases were able to be opened using the converter, I assumed I was able to open it in DBMaster, but oh boy, I couldn't be any more wrong, as it resulted in an IMMEDIATE unhandled exception error.

                  Comment

                  • Jlnhlfan
                    Rookie
                    • Jul 2014
                    • 363

                    #10
                    Re: FIFA DB Master - Alternative db editor

                    Originally posted by raupe
                    FIFA DB Master can read NHL roster when .db is converted console format to pc. Converting is able to do with myfifa2005 DB Converter. Also localization databases where the team names etc are stored is able to convert to DB Master.
                    Usage:
                    -Convert the original db and xml using myfifa2005-fifa-db-convert.jar
                    -Read the converted xml and db using DB Master

                    FIFA DB Master 15:
                    Database Master 15 - Updated Links - ModdingWay Mods Database


                    MyFifa2005 Converter:
                    MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.


                    Original DB and XML from NHL Legacy game disc:


                    Original language db from NHL Legacy game disc:


                    Language strings read in DB Master:
                    How would edit lines in DB Master? Asking because the way I edited players in NHL 11 wound up resulting in renamed players on the Stars being on line 4 when they should be on line 2.

                    Comment

                    • Jlnhlfan
                      Rookie
                      • Jul 2014
                      • 363

                      #11
                      Re: FIFA DB Master - Alternative db editor

                      The DB Converter no longer works for me, which means I cannot convert files from PS3 to PC like I could in the past. This is detrimental to my mods, as the conversions are necessary for DB master to read the files.

                      Comment

                      • Jlnhlfan
                        Rookie
                        • Jul 2014
                        • 363

                        #12
                        Re: FIFA DB Master - Alternative db editor

                        Originally posted by Jlnhlfan
                        The DB Converter no longer works for me, which means I cannot convert files from PS3 to PC like I could in the past. This is detrimental to my mods, as the conversions are necessary for DB master to read the files.
                        Just going to bump this by way of necroposting.

                        Comment

                        • MuzzUK
                          Rookie
                          • Dec 2016
                          • 130

                          #13
                          Re: FIFA DB Master - Alternative db editor

                          Originally posted by GlobalDev
                          Hello, could you help? I edit the fe/loc eng_db file, change Arizona to utah, go into the game, everything applies, but as soon as I load my roaster, I immediately get an empty name, instead of Utah there is a void ... I do it on rpcs3.

                          So the way the game saves the data and the way the editors read it is different. So even though you can edit something it doesn't mean your change can be made. It takes a lot of expertise and coding experience to get all these things to line up. The only real way to edit NHL games is using NHL View, however changing team names isn't possible. Team names are stored in many places in the game code. Who knows might be possible in the future but not at the moment.
                          https://discord.gg/BeCHnu86 Project 20s 2K10 MOD

                          Comment

                          • SQNNET
                            Rookie
                            • Jun 2023
                            • 10

                            #14
                            Re: FIFA DB Master - Alternative db editor

                            Originally posted by Jlnhlfan
                            The DB Converter no longer works for me, which means I cannot convert files from PS3 to PC like I could in the past. This is detrimental to my mods, as the conversions are necessary for DB master to read the files.
                            Coming in from the future to bump this, were you able to get it working again?
                            I'd love if this site was updated enough to let me use a VGK logo as my avatar.

                            Comment

                            • ametaslimedrawsnear
                              Rookie
                              • Dec 2023
                              • 5

                              #15
                              Re: FIFA DB Master - Alternative db editor

                              Does anyone anyone have a working link for the original nhl_eng_us files? The one posted here (the last link) is broken.

                              Comment

                              Working...