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
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
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
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
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
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
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
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%";
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
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.
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.