v0.95 has been unleashed!! - Now contains 60+ togglable database mods (not all fully documented) - Huge UI Overhaul (Mod now REQUIRES UICore) - Fix bug when escape/gamepad mouse button returned to title but kept sql mod window open - Q/E (or shoulder buttons on gamepad) now toggle rotator/selector options. (title only) - Escape (or cancel buttons on gamepad) now close mod menu when opened. (title only) - Fix bug when right mouse button/gamepad opened settings menu (title only) - Fix bug when return to main title removes sql mod button - Added new 'OnGameBoot' trigger - ALL DATA TABLES NOW EDITABLE**
** Providing your sql operation is set to the new 'OnGameBoot' trigger. These operations REQUIRE the game to be rebooted after you enable/disable them.
NOTE: If you somehow disable this mod (SQLModMenu) using your modloader, the sql mods previously enabled with 'OnGameBoot' triggers will still run as long as the (SQLModMenu) mod files are still in your game directory.
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
If you use and enjoy this mod, please consider endorsing it, or sharing the link with your HL playing friends! <3
hello how are you, how are you? how do i install this mod? and how do I run it to release the things I want to leave released? could someone guide me please.
1) Install Blueprint Apparate Modloader. 2) Install UICore. 3) Install SQL Mod Menu. 4) Start Hogwarts Legacy and load up a saved game. 5) Hit F8. In the little modloader window that appears type DekUICore (make sure you spell it correctly!) in the top line and hit return. The word DekUICore should disappear and reappear lower down with an "x" next to it. If it doesn't - if it stays on the top line - then UICore isn't installed correctly. Check your ~mods folder and let me know what's in there. 6) If all is well type DekSQLModMenu (make sure you spell it correctly!) in the top line and hit return. Again this should disappear and reappear lower down with an "x" next to it. If it doesn't - if it stays on the top line - then SQL Mod Menu isn't installed correctly. Check your ~mods folder and let me know what's in there. 7) If all is well, hit F8 to get rid of the little modloader window. 8) Just to be safe, exit and restart the game. 9) When you get to the character selection screen you should see two new buttons in the bottom left. Ignore the first one. The second will open SQL Mod Menu. Alternatively, you can hit F5 when you're in the game to bring up SQL Mod Menu. (Unless some other mod is already using F5, in which case you will need to change the key-binding for that mod The key-binding for SQL Mod Menu cannot currently be changed.)
Usage Instructions
To Enable mods:
1) Open SQL Mod Menu and browse through the mods. 2) If you see one you like, click on it. 3) In the new window hit "Enable". 4) Repeat steps 2 & 3 on all the mods you like. 5) When you're done hit "Apply" (SQL Mod Menu will close). 6) Exit to the character selection screen. 7) Select your character and reload your game. 8) The mods you chose should now be active.
To Disable mods:
1) Open SQL Mod Menu. 2) Select the mod you want to disable. 3) In the new window hit "Disable". 4) Hit "Apply" (SQL Mod Menu will close). 6) Exit to the character selection screen. 7) Select your character and reload your game. 8) That mod should now be Disabled.
DO NOT click Delete. Ever. It will delete that mod and it cannot be undeleted.
[NAME] Reduced Spell Cooldown [TYPE] Spells [NOTES] Reduce the cooldown on all combat spells to 1 second. [ONENABLE] CREATE TABLE IF NOT EXISTS SQLModSpellDefinition AS SELECT * FROM SpellDefinition; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Accio' AND Upgrade='Spell_Accio_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='ArrestoMomentum' AND Upgrade='Spell_ArrestoMomentum_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='AvadaKedavra' AND Upgrade='Spell_AvadaKedavra_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Confringo' AND Upgrade='Spell_Confringo_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Crucio' AND Upgrade='Spell_Crucio_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Depulso' AND Upgrade='Spell_Depulso_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Descendo' AND Upgrade='Spell_Descendo_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Diffindo' AND Upgrade='Spell_Diffindo_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Expelliarmus' AND Upgrade='Spell_Expelliarmus_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Expulso' AND Upgrade='Spell_Expulso_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Flipendo' AND Upgrade='Spell_Flipendo_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Glacius' AND Upgrade='Spell_Glacius_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Imperius' AND Upgrade='Spell_Imperius_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Incendio' AND Upgrade='Spell_Incendio_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Levioso' AND Upgrade='Spell_Levioso_Base'; UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='TransformationOverland' AND Upgrade='Spell_TransformationOverland_Base'; [ONDISABLE] DROP TABLE SpellDefinition; CREATE TABLE IF NOT EXISTS SpellDefinition AS SELECT * FROM SQLModSpellDefinition; [QUERY] SELECT SpellTypeID, CooldownTime FROM SpellDefinition WHERE CooldownTime=1.0; [TRIGGERS] OnLoadScreenEnd: false OnPlayerCharLoaded: false OnPlayerGearLoaded: false OnPlayerTeleported: false OnPlayerTakeDamage: false OnPlayerSpellCast: false OnModLoaded: false OnGameBoot: true
bro, thank you so much for this cooldown table...it worked 100% here. I set it all to 0.1s
Now I just need to set all the enemies to get 100% aggressive, that way my plan to maximize the "action" inside the game will be completed.
All mods in nexus to change this seens to be outdated. I research how to do it, and it seem the "enemy ticket scale" is related to it. Can you help me one more time?
Anyway to get the fewer spiders mod running through this ? https://www.nexusmods.com/hogwartslegacy/mods/1257 or maybe add a similar option like fewer spiders to your mod ?
665 comments
- Now contains 60+ togglable database mods (not all fully documented)
- Huge UI Overhaul (Mod now REQUIRES UICore)
- Fix bug when escape/gamepad mouse button returned to title but kept sql mod window open
- Q/E (or shoulder buttons on gamepad) now toggle rotator/selector options. (title only)
- Escape (or cancel buttons on gamepad) now close mod menu when opened. (title only)
- Fix bug when right mouse button/gamepad opened settings menu (title only)
- Fix bug when return to main title removes sql mod button
- Added new 'OnGameBoot' trigger
- ALL DATA TABLES NOW EDITABLE**
** Providing your sql operation is set to the new 'OnGameBoot' trigger. These operations REQUIRE the game to be rebooted after you enable/disable them.
NOTE: If you somehow disable this mod (SQLModMenu) using your modloader, the sql mods previously enabled with 'OnGameBoot' triggers will still run as long as the (SQLModMenu) mod files are still in your game directory.
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
If you use and enjoy this mod, please consider endorsing it, or sharing the link with your HL playing friends! <3
DISCORD SUPPORT SERVER
1) Install Blueprint Apparate Modloader.
2) Install UICore.
3) Install SQL Mod Menu.
4) Start Hogwarts Legacy and load up a saved game.
5) Hit F8. In the little modloader window that appears type DekUICore (make sure you spell it correctly!) in the top line and hit return. The word DekUICore should disappear and reappear lower down with an "x" next to it. If it doesn't - if it stays on the top line - then UICore isn't installed correctly. Check your ~mods folder and let me know what's in there.
6) If all is well type DekSQLModMenu (make sure you spell it correctly!) in the top line and hit return. Again this should disappear and reappear lower down with an "x" next to it. If it doesn't - if it stays on the top line - then SQL Mod Menu isn't installed correctly. Check your ~mods folder and let me know what's in there.
7) If all is well, hit F8 to get rid of the little modloader window.
8) Just to be safe, exit and restart the game.
9) When you get to the character selection screen you should see two new buttons in the bottom left. Ignore the first one. The second will open SQL Mod Menu. Alternatively, you can hit F5 when you're in the game to bring up SQL Mod Menu. (Unless some other mod is already using F5, in which case you will need to change the key-binding for that mod The key-binding for SQL Mod Menu cannot currently be changed.)
Usage Instructions
To Enable mods:
1) Open SQL Mod Menu and browse through the mods.
2) If you see one you like, click on it.
3) In the new window hit "Enable".
4) Repeat steps 2 & 3 on all the mods you like.
5) When you're done hit "Apply" (SQL Mod Menu will close).
6) Exit to the character selection screen.
7) Select your character and reload your game.
8) The mods you chose should now be active.
To Disable mods:
1) Open SQL Mod Menu.
2) Select the mod you want to disable.
3) In the new window hit "Disable".
4) Hit "Apply" (SQL Mod Menu will close).
6) Exit to the character selection screen.
7) Select your character and reload your game.
8) That mod should now be Disabled.
DO NOT click Delete. Ever. It will delete that mod and it cannot be undeleted.
[NAME]
Reduced Spell Cooldown
[TYPE]
Spells
[NOTES]
Reduce the cooldown on all combat spells to 1 second.
[ONENABLE]
CREATE TABLE IF NOT EXISTS SQLModSpellDefinition AS SELECT * FROM SpellDefinition;
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Accio' AND Upgrade='Spell_Accio_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='ArrestoMomentum' AND Upgrade='Spell_ArrestoMomentum_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='AvadaKedavra' AND Upgrade='Spell_AvadaKedavra_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Confringo' AND Upgrade='Spell_Confringo_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Crucio' AND Upgrade='Spell_Crucio_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Depulso' AND Upgrade='Spell_Depulso_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Descendo' AND Upgrade='Spell_Descendo_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Diffindo' AND Upgrade='Spell_Diffindo_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Expelliarmus' AND Upgrade='Spell_Expelliarmus_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Expulso' AND Upgrade='Spell_Expulso_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Flipendo' AND Upgrade='Spell_Flipendo_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Glacius' AND Upgrade='Spell_Glacius_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Imperius' AND Upgrade='Spell_Imperius_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Incendio' AND Upgrade='Spell_Incendio_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='Levioso' AND Upgrade='Spell_Levioso_Base';
UPDATE SpellDefinition SET CooldownTime=1.0 WHERE SpellTypeID='TransformationOverland' AND Upgrade='Spell_TransformationOverland_Base';
[ONDISABLE]
DROP TABLE SpellDefinition;
CREATE TABLE IF NOT EXISTS SpellDefinition AS SELECT * FROM SQLModSpellDefinition;
[QUERY]
SELECT SpellTypeID, CooldownTime FROM SpellDefinition WHERE CooldownTime=1.0;
[TRIGGERS]
OnLoadScreenEnd: false
OnPlayerCharLoaded: false
OnPlayerGearLoaded: false
OnPlayerTeleported: false
OnPlayerTakeDamage: false
OnPlayerSpellCast: false
OnModLoaded: false
OnGameBoot: true
OnGameBoot: true
OnModLoaded: false
Now I just need to set all the enemies to get 100% aggressive, that way my plan to maximize the "action" inside the game will be completed.
All mods in nexus to change this seens to be outdated.
I research how to do it, and it seem the "enemy ticket scale" is related to it. Can you help me one more time?