LAOSIJI

# Tutorial



# 1、Import DB

After opening the software, click File in the upper left corner, select Open menu item, open the file selector, and first select fifa_ng_db-meta.xml, and then select fifa_ng_db.db can complete the import of the database, which takes about 4-5 seconds to read.

Note: The tool can only recognize files with. db suffix, so when we want to open the files saved by debug, we need to remove the debug suffix.






# 2、Edit DB

After opening and reading the database, all the data tables of the database are on the left. The common tables:

  • stadium (Stadium Data Sheet)
  • team (Team Data Sheet)
  • teamstadiumlinks (Team's Stadium Data Sheet)
  • players (Players Data Sheet)
  • teamkits (Team's Jersey Data Sheet)
  • teamplayerlinks (Team's Lineup Data Sheet)
  • playernames (PlayerName Data Sheet)
  • nations (National Data Sheet)
  • leagues (League Data Sheet)
  • leagueteamlinks (League's Team Data Sheet)
  • formations (Team Formation Data Sheet)

On the right is all the data in the corresponding data table, which can be searched and edited. The top left is the search box and search criteria. You can select the specified column from the drop-down menu to search the corresponding data. Next to the search box is the type of column field. There are two types, String and Integer.

Note: Data of type String cannot be filled into column fields of type Integer.

The right shows the minimum and maximum values of the data of an Integer type column in the current table, and the number of rows in the current table.

Below is the editing function area, from left to right are [Copy] [Insert] [Replace] [Delete] [Fuzzy match] [Full match]



# 3、Export DataSheet

When we need to edit more data, it may be a little inefficient to use this tool. At this time, we can select the data table we need to export, click File in the upper left corner, find the Export Single option to export a single data table, and then we can use Excel or WPS tools with higher editing efficiency to complete the modification. Of course, we can also directly export all tables, just click Export All, All tables can be exported.

# 4、Import DataSheet

After we modify the data table from outside, we need to import the new data table back to our database. After we open the database, select the data table we want to import data, click File, Import Single, and select the new data table to complete the import of new data.

Note: The imported table must be the same as the selected table

# 5、Save DB

After we import the data table, we need to save the database. At present, the software provides two ways to save the database, one is debug, the other is release.

As the name implies, debug means debugging. By clicking debug, the software will repackage the latest data. The file generated by the package has the suffix .debug. At this time, the file cannot be put into the game to run, otherwise it will cause the game to crash and flash back, Can be used for debugging and testing.

The release save method will package and generate two versions of debug and release for us. The generated file has a suffix of. release, and the release version is an encrypted version. Therefore, when we decide to publish the db we created, we can use the release save method if we don't want to be opened by others.

Note: Generally, after saving the file, we need to rename the file to avoid overwriting when saving next time. At the same time, we need to distinguish between the debug version and the release version. The tool can only open the debug version, not the release version. Every time we save a file, the software will help us generate a backup (.bnk) file.

←