SQL Mod Menu
ALL your favourite database mods in one place, wrapped in a beautiful user interface, able to be toggled at will…
SQL Mod Menu allows users to set/toggle SQL operations (database mods) to be triggered at runtime!!
Features:
- Run SQL Operations & Queries on the game database
- Set SQL Operations to run at runtime
- Easily toggle active ‘SQL Mods’
- No need to merge SQL mod files
- No need to update your SQL mods after each game patch
- UI resembles default game menus and elements
- 50+ Default Database Mods!!!
Default Database Mods Include:
- Godmode::HP
- Godmode::Defense
- Godmode::Damage
- No Random Gear (always max gear stats)
- x99 Plants&Potions Limit
- Unlock Alohamora III
- Unlock Unforgivables
- Unlock Learned Spells
- Hogwarts Express::Morning Schedule
- Hogwarts Express::Evening Schedule
- Hogwarts Express::Extra Schedule
- Wandering Graphorn
- Wandering Phoenix
- Wandering Beasts
- Wandering Birds
- Gain Knuts On Damaged
- Lose Knuts On Cast Spell
- Max Wiggenwelds
- Max Potions&Plants
- Max Ingredients
MANY MORE!
KNOWN ISSUES:
Need to reload world/game to get certain active mod / SQL changes to take effect.
This mod uses pak chunk 1312 and may be incompatible with other mods that do so.
Old version used pak chunk id 72.
REQUIREMENTS / HOW TO USE:
UICore – ALWAYS REQUIRED – Regardless of chosen modloader.
A modloader such as UE4SS or Apparate Modloader is required to use logic mods.
DONT LOAD THE SAME MOD IN BOTH MODLOADERS
With UE4SS:
Set BPModLoaderMod to 1 in Hogwarts Legacy\Phoenix\Binaries\Win64\Mods\mods.txt
Install this mods .pak, .utoc, and .ucas files to Hogwarts Legacy\Phoenix\Content\Paks\LogicMods
With Apparate Modloader:
Install this mods .pak, .utoc, and .ucas files to Hogwarts Legacy\Phoenix\Content\Paks\~mods
Press F8 (when in game) to open the modloader menu, type
DekSQLModMenu This mod should now be listed within the apparate modloader menu.
NOTE: If your having trouble getting the mod working with apparate modloader, try renaming the mod files to have a ! in front of their name. This seems to be a priority issue when using a lot of mods.
FOR MODDERS:
Instead of repackaging the sqlite file every time the game wants to update, write your logic as an sql transaction. You can use the ‘run’ command to test your transaction. Please note, certain items may need to be reloaded depending what data your changing (thats why the mod menu is shown on title before game loads fully). Simply return to title to re-run your sql logic as needed for testing.
Please report any bugs you find so I can try squish them, and please also share any SQL mods you have written in the comments so other users can benefit from them too! <3
Delete DekSQLRunner Save Data When Updating!!
Located in the following directory: (on Windows, just copy this into your folder path and hit enter)
%appdata%\..\Local\Hogwarts Legacy\Saved\SaveGames
You can delete this file at any time to reset the mods list.
