How Do I Convert Singleplayer Save Data to Multiplayer Save Data

When you transfer a single player world to your server or vice-versa, your inventory and player statistics will not transfer unless certain changes are made to your world. Additionally, if you try to join your world or server, you may not be able to if you haven’t converted your world or deleted the players.db file. This is because the way multiplayer and singleplayer load player data is stored differently.

Converting singleplayer data to multiplayer data is an indepth and complex process. We’ve broken down the steps required as much as we can to make this easier to read.

1. Confirming players.db is a Singleplayer file
2. Creating a Multiplayer players.db file
3. Converting Singleplayer players.db to Multiplayer players.db
4. SQL Commands

Confirming players.db is a Singleplayer file

1. Open the AleForge Panel
2. Stop your server
3. Upload your single player world to your server
4. Open the Settings page for your server and note down the Internal Save Name value

5. Create a folder for a workspace on your computer. This is not required but it will make it easier to work on converting your player data
6. Connect to your server using SFTP
7. Navigate to .cache/Saves/Multiplayer/Internal Save Name
8. Download the players.db file and place it in your workspace folder

9. Rename the players.db file you moved to oldplayers.db

10. Download SQLite Database Browser from https://sqlitebrowser.org/dl/
11. Open SQLite Database Browser
12. Drag and drop oldplayers.db onto SQLite Database Browser
13. Click Browse Data and then select local players

If you see player data you can confirm the file is in the single player format

Creating a Multiplayer players.db file

1. Delete the players.db file from your server using the SFTP client
2. Start the server to generate a multiplayer-compatible players.db file
3. Join the server and create a new character. It doesn’t matter what statistic you choose for the player as this will be reset after migrating the data.
4. Leave the server and then stop it from the console
5. Navigate to .cache/Saves/Multiplayer/Internal Save Name in your SFTP client
6. Download players.db to your workspace
7. Rename players.db to newplayers.db

Converting a Singleplayer players.db file to Multiplayer players.db

1. Open SQLite Database Browser again and drag and drop newplayers.db onto the browser
2. Click Browse Data then select the networkPlayers table. If there are any players in the table you can confirm this is in the multiplayer format

3. Open the oldplayers.db file with SQLite Database Browser
4. Click Browse Data and open the localPlayers table
5. Copy the X,Y,Z values into your preferred note taking software

6. Right-click on the field in the data column for your player and press **Copy as SQL** . Paste this into your note.

7. Open the newplayers.db file in SQLite Database Browser
8. Click Execute SQL , then run the SQL commands mentioned here. Replace the values in the SQL command with the values you took note of. You will want to modify the networkPlayers table .
9. Click the Execute all/selected SQL button . This looks like a play button located near the top left of SQLite Database Browser

10. Click Browse Data and confirm the changes were applied
11. ClickFile -> Write Changes and then Save All
12. Exit SQLite Database Browser
13. Open your workspace folder and rename newplayers.db to players.db
14. Upload the new players.db to your server using SFTP to .cache/Saves/Multiplayer/Internal Save Nam
15. Start the server and connect to join with your Single player character data

SQL Commands

Update player data

UPDATE “main”.”REPLACE_WITH_TABLE” — Select which table you’d like to modify.

SET data = NULL — Replace “NULL” with value inside the copied SQL command VALUES(); method

WHERE id = 1; — The ID is the row you’re replacing the value of for the character you created earlier.

Update player X coord

UPDATE “main”.”REPLACE_WITH_TABLE” — Select which table you’d like to modify.

SET x = 0 — Replace with the X coordinate of the player.

WHERE id = 1; — The ID is the row you’re replacing the value of for the character you created.

Update player Y coord

UPDATE “main”.”REPLACE_WITH_TABLE” — Select which table you’d like to modify.

SET y = 0 — Replace with the Y coordinate of the player.

WHERE id = 1; — The ID is the row you’re replacing the value of for the character you created.

Update player Z coord

UPDATE “main”.”REPLACE_WITH_TABLE” — Select which table you’d like to modify.

SET z = 0 — Replace with the Z coordinate of the player.

WHERE id = 1; — The ID is the row you’re replacing the value of for the character you created.