0 of 0

File information

Last updated

Original upload

Created by

SmiLeX

Uploaded by

smilex32

Virus scan

Safe to use

Tags for this mod

About this mod

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

Requirements
Permissions and credits
Mirrors
Donations
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