Hogwarts Legacy [Engine:Unreal 4.27.2]

[FLAskur]

Could someone help me? I'm not sure what I'm doing wrong with the SQLite Exec

I'm trying different codes but none seem to work, for example I'm trying to use this one that I got from the InventoryDynamic, I even tried to update the time manually and it still have no effect in game

Code: Select all

INSERT INTO "main"."InventoryDynamic" ("CharacterID", "HolderID", "SlotNumber", "ItemID", "Variation", "Count", "Stolen", "UniqueItem", "KeepOnReset", "UpdateTime") VALUES ('Player0', 'ResourceInventory', '18', 'Jobberknoll_Byproduct', 'NULL', '999', '0', '0', '0', '596334306852359577');

How to use this cheat table?

1. Install Cheat Engine
2. Double-click the .CT file in order to open it.
3. Click the PC icon in Cheat Engine in order to select the game process.
4. Keep the list.
5. Activate the trainer options by checking boxes or setting values from 0 to 1

[bobbls]

Could someone help me? I'm not sure what I'm doing wrong with the SQLite Exec

I'm trying different codes but none seem to work, for example I'm trying to use this one that I got from the InventoryDynamic, I even tried to update the time manually and it still have no effect in game

Code: Select all

INSERT INTO "main"."InventoryDynamic" ("CharacterID", "HolderID", "SlotNumber", "ItemID", "Variation", "Count", "Stolen", "UniqueItem", "KeepOnReset", "UpdateTime") VALUES ('Player0', 'ResourceInventory', '18', 'Jobberknoll_Byproduct', 'NULL', '999', '0', '0', '0', '596334306852359577');

Is there already something in slot 18? do you already have jobberknoll feathers in your inventory? if the answer is yes to either of those, then it's an issue with your query, otherwise make sure you can execute basic SQL commands to see if its a deeper issue, try setting your knuts

Also, don't forget to save and load.

Code: Select all

UPDATE InventoryDynamic SET ItemID = 'Knuts', Count = 30000, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596323800000000000 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND SlotNumber = 0; 

[FLAskur]

Could someone help me? I'm not sure what I'm doing wrong with the SQLite Exec

I'm trying different codes but none seem to work, for example I'm trying to use this one that I got from the InventoryDynamic, I even tried to update the time manually and it still have no effect in game

Code: Select all

INSERT INTO "main"."InventoryDynamic" ("CharacterID", "HolderID", "SlotNumber", "ItemID", "Variation", "Count", "Stolen", "UniqueItem", "KeepOnReset", "UpdateTime") VALUES ('Player0', 'ResourceInventory', '18', 'Jobberknoll_Byproduct', 'NULL', '999', '0', '0', '0', '596334306852359577');

Is there already something in slot 18? do you already have jobberknoll feathers in your inventory? if the answer is yes to either of those, then it's an issue with your query, otherwise make sure you can execute basic SQL commands to see if its a deeper issue, try setting your knuts

Also, don't forget to save and load.

Code: Select all

UPDATE InventoryDynamic SET ItemID = 'Knuts', Count = 30000, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596323800000000000 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND SlotNumber = 0; 

This command for knulls did work. So what would be wrong with my command? I do have the jobberknoll feathers

[bobbls]

This command for knulls did work. So what would be wrong with my command? I do have the jobberknoll feathers

your query is using INSERT INTO which only works when there isnt a row already existing, since you have feathers you should use a different query, looked through the thread and modified a query that should work fine

Code: Select all

 UPDATE InventoryDynamic SET Count = 999 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND ItemID = 'Jobberknoll_Byproduct'; 

[FLAskur]

This command for knulls did work. So what would be wrong with my command? I do have the jobberknoll feathers

your query is using INSERT INTO which only works when there isnt a row already existing, since you have feathers you should use a different query, looked through the thread and modified a query that should work fine

Code: Select all

 UPDATE InventoryDynamic SET Count = 999 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND ItemID = 'Jobberknoll_Byproduct'; 

Thanks for your help. I actually got it to work using the Knuts code you sent me and changing the product and itemslot for each one

[FLAskur]

Wand handles for days, not really only 42 of them all unlocked

Code: Select all

UPDATE CollectionDynamic SET ItemState = "Obtained", UpdateTime = 596359858070379192 WHERE CategoryID = "WandStyle";
INSERT OR REPLACE INTO LocksDynamic (LockID, ELockState) SELECT LockID, 0 FROM LockDefinition WHERE LockID like "h0%_m%";

Save and reload for it to take effect

also extra edit, Talent points sql code

Code: Select all

UPDATE MiscDataDynamic SET DataValue = 12 Where DataOwner = "Player0" and DataName = "PerkPoints"

Would love to see this for the other cosmetics categories, cloaks, outfits, neckwear etc! <3

Done

Code: Select all

UPDATE CollectionDynamic SET ItemState = "Obtained", UpdateTime = 596359858070379192 WHERE CategoryID = "gear";
INSERT OR REPLACE INTO LocksDynamic (LockID, ELockState) SELECT LockID, 0 FROM LockDefinition WHERE LockID like "back\____\_%" ESCAPE '\' or LockID like "outfit\____\_%" ESCAPE '\' or LockID like "face\____\_%" ESCAPE '\' or LockID like "hand\____\_%" ESCAPE '\' or LockID like "head\____\_%" ESCAPE '\' or LockID like "neck\____\_%" ESCAPE '\';

Save and reload for it to take effect, also includes the other exclusives

This is awesome! Thank you very much! Do you by chance happen to know how to do this to unlock all brooms

[gtauser93]

Permanent but it's capped to 500, don't know if there's a way to uncap it.

It's a static cap, only way to bypass would be to mod the game.

Where did you get this database? maybe inserting new rows would do it
this sql table does not exist when you dump it from the game

[Serenity42]

Would anyone know of a command to unlock JUST the shopkeeper outfit/coat/hat. Code here to unlock all the clothing but I'd love to just do those 3 since we can't get them legit right now.

[SandNiBBa]

Is there a way to unlock doors without doing the lockpick minigame? Also can you bypass the Alohomora level requirement?

[FruitLoops69]

I keep getting the error 'aob_to_Commit_OnUnequip2' not found soon after i enable. How can i fix this?

[Celebi]

Quick question does this table work on Steam version as well? I am asking because when I try to click on Enable I am getting this error:

>> 'aob_to_Commit_OnUnequip2' not found. <<

[CalibreThaGoat]

Quick question does this table work on Steam version as well? I am asking because when I try to click on Enable I am getting this error:

>> 'aob_to_Commit_OnUnequip2' not found. <<

If you read on page 20, he tells you how to fix it....

[Gc43]

Where did you get this database? maybe inserting new rows would do it
this sql table does not exist when you dump it from the game

It's in the game's pak files. Can extract them with tools like FModel.

[Serenity42]

Is there a way to unlock doors without doing the lockpick minigame? Also can you bypass the Alohomora level requirement?

I haven't seen any, but if you lower the difficulty to story there an auto solve option.

[Serenity42]

May I ask which keywords I have to change in this SQL query to lock a specific item? Back_073_Basic comes out as a bugged/nonexistent item and it's included in the full unlock by default.

Nvm, I just found out how to. For those who wants to remove that bugged item (after using the gear unlocks) just use this code:
INSERT OR REPLACE INTO LocksDynamic (LockID, ELockState) SELECT LockID, 1 FROM LockDefinition WHERE LockID like "Back_073%";

Then for those who don't want the relic house uniform for the house they don't belong to. Just use these codes

Gryffindor:
INSERT OR REPLACE INTO LocksDynamic (LockID, ELockState) SELECT LockID, 1 FROM LockDefinition WHERE LockID like "Back_099%";
Hufflepuff:
INSERT OR REPLACE INTO LocksDynamic (LockID, ELockState) SELECT LockID, 1 FROM LockDefinition WHERE LockID like "Back_100%";
Ravenclaw:
INSERT OR REPLACE INTO LocksDynamic (LockID, ELockState) SELECT LockID, 1 FROM LockDefinition WHERE LockID like "Back_101%";
Slytherin:
INSERT OR REPLACE INTO LocksDynamic (LockID, ELockState) SELECT LockID, 1 FROM LockDefinition WHERE LockID like "Back_102%";

I wonder if DELETE statement would have been better for these but I did not bother to test it.

Could this go the otherway around and a command be used to unlock specific clothing items. I was hoping to unlock just the shopkeeper items.