Hogwarts Legacy Guide for merging SQL mods

Guide for those who see black screen after merge SQL mods

This can be solved by manually merging mods with your version of the game

Query generator for sqlite database merge

Alternate Hogwarts Mod Merger, but base on your game version and with the ability to edit the merge

Simple Manual Version

About: This script Help for Hogwarts Legacy modders or mod users generete diffrence between your mod (witch include sqlite db changes) and update your sql db of your game version.

Req: Python 3. 7,

Libs: os, sqlite3

How to USE IT:

For mod users:

Extract your version of the database from the game files using https://github.com/LongerWarrior/FModel/releases/tag/HW_1. 0. 0. 0 Setting fo HL:

---

---

Choose pakchunkO-WindowsNoEditor.pak -> Phoenix/Content/SQLiteDB/PhoenixShipData.sqlite - It's your db version

Move this file in main dir and Updated

---

Extract db file from HL mod using https://github.com/RiotOreO/unrealpak

• Just drop your file in Unpack.bat

---

Move this folder to main/Mods dir

• You can add mods you need, script scan all folder

---

Run main.py , It's generate SQL file of differences between the mod and your DB

• You can change it

  For example, I added a script to delete all lines that have data on the tutorial, because it led to crash the game when installing any mods for my version of the game.

  You can find it in substrings = ["Tutorial", "Game"] # Change it if you know for sure that this data crashes the start of the game

---

Then run update.py to Update your db file in /Updated

• It's run all query from SQL query file

---

Need pack changes in pak file, using https://github.com/RiotOreO/unrealpak

• Create a folder tree ./z_MergedMods/Phoenix/Content/SQLiteDB in unrealpak root foler

  Drop PhoenixShipData.sqlite From ./Update to ./z_MergedMods/Phoenix/Content/SQLiteDB

---

Drop z_MergedMods folder in UnrealPak-Without-Compression.bat

---

All done drop in HL ~mods Your z_MergedMods

For modders:

You can genrete differences_and_updates.sql SQL file with your mod and source HL DB file ,

Then you got Clean and correct changes for all versions of the game

How it's done at https://www.nexusmods.com/hogwartslegacy/mods/1987/

And everyone will be able to do a merge with their versions of the game