SQL module menu

All your favorite database mods in one place, wrapped in a beautiful user interface that can be toggled on or off at will... The SQL Mods menu allows users to set/trigger SQL operations (database mods) at runtime!

SQL module menu

🎮 **One-stop database module management tool to take your "Hogwarts Legacy" experience to the next level! **

✨ Core Functions

• **💾 Run SQL operations and queries**: Perform operations directly on the game database.
• **⚙️ Set SQL operations at runtime**: Dynamically adjust module effects without restarting the game.
• **🔘 Easily switch "SQL Module" on and off**: Freely enable or disable various functions through the intuitive menu interface.
• **🧩 No need to merge SQL files**: Say goodbye to tedious file merging steps.
• **🛡️ Worry-free game updates**: In most cases, your SQL mods do not need to be updated after game patches.
• **🎨 Native style UI**: The interface design is consistent with the game's default menus and elements, seamlessly integrated.
• **🎁 Built-in 50+ default database modules**: ready to use out of the box, rich in features!

🧰 Default module example

Here are some of the powerful built-in features:

• **Invincible Mode**: HP, defense, and damage are fully improved.
• **Equipment Optimization**: No more random attributes, always get the best equipment.
• **Item Cap**: The maximum carrying limit for plants and potions is increased to x99.
• **Spell Unlock**: Unlock **Arajo Cave III**, **Unforgivable Curse** and all learned spells with one click.
• **Hogwarts Express timetable**: Added morning, evening and extra services.
• **Fantastic Beast Refresh**: Increase the chance of encountering **Troll Bird**, **Phoenix**, various beasts and birds in the wild.
• **Economic system adjustment**: Interesting rules such as gaining Galleons when you are injured, and consuming Galleons when casting spells.
• **Item Maximization**: Instantly replenish **Wigan Elixir**, potions, plants and all materials.
• **There’s more! **Waiting for you to explore.

---

⚠️ Known issues and compatibility

• Some active mods or SQL changes require a world/game reload to take effect.
• This mod uses pak block 1312 and may conflict with other mods that also use this block.
• *Older versions use pak block ID 72. *

📦 Prerequisites and installation guide

**Required components:**

• **UICore** - **Always required**, regardless of which mod loader is chosen.
• **A module loader**, such as **UE4SS** or **Apparate Modloader**, is used to load logical modules.
• **IMPORTANT**: Do not load the same mod in both loaders at the same time.

**Installation using UE4SS:**

• In `Hogwarts Legacy\Phoenix\Binaries\Win64\Mods\mods.txt`, set `BPModLoaderMod` to `1`.
• Install the `.pak`, `.utoc` and `.ucas` files of this module to the `Hogwarts Legacy\Phoenix\Content\Paks\LogicMods` directory.

**Install using Apparate Modloader:**

• Install the `.pak`, `.utoc` and `.ucas` files of this module to the `Hogwarts Legacy\Phoenix\Content\Paks\~mods` directory.
• Press **F8** in the game to open the module loader menu and enter the command `DekSQLModMenu`.
• The mod should now appear in the Apparate mod loader menu.
• *Tip: If you have trouble using the Apparate loader, try prefixing the mod file name with a `!` symbol. This may involve loading priority issues when using a large number of mods at the same time. *

---

🛠️ Tips for modders

Instead of repackaging sqlite files every time the game is updated, write your logic as SQL transactions. You can use the 'run' command to test your transactions. Please note that depending on the type of data you change, some items may need to be reloaded (this is why the mod menu is displayed on the title screen before the game is fully loaded). Simply return to the header interface to re-run your SQL logic for testing as needed.

🔄 Update Notice

**Be sure to delete the archive data of DekSQLRunner when updating! ! **

Archive location (Windows systems):

```

%appdata% …