Does that actually work for you? I haven't been able to get it to work.
Yeah doesn't seem to work, I thought it worked but it was because of my focus potion. I'll edit my original post to say its not working
I'm assuming they are static values which the game preloads at launch. Would be nice if there was a way to force the game to reload it.
UPDATE SpellDefinition SET CooldownTime = '0.0', Inanimate = '1', Plant = '1', Dead = '1', Water = '1', PlayObjectImpactEffects = '1' WHERE SpellTypeID = 'AvadaKedavra'
I suspect that would allow you to freely spamcast it without needing an animate target.
Doesn't work for the spamcast still needs a target, though cooldown works if you mod the db file with a pak patch but gonna go ahead and say its not possible at this time with the cheat table.
UPDATE InventoryDynamic SET ItemID = 'CURR_Infiltrator_Token', Count = 20, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596359858070379192 WHERE CharacterID = 'Player0' AND HolderID = 'MissionItems' AND SlotNumber = 10;
Ive actually played around alot the past hours and trying to figure out how to add items in an easy way, both if I have them already or adding more and using UPDATE will not work since it ONLY updates an already existing one and doesnt add a new one if you have 0 of the item.
Youll have to use INSERT INTO instead if you are at 0 of the item. But only for when you are adding it the first time, after that you can use UPDATE again if you wanna change it.
What Ive managed to do so far is update all items in my Resource Inventory to a specific amount but one IMPORTANT thing to know is that SlotNumber is different for each player since it depends on WHEN you pick it up and if you already have something in that slot in your inventory already the number will be different and it will not work.
That being said I Tried this on my newly created character and it worked so here is the code for adding the Demiguise Moon Item if you are at 0 of it but again if you have something in slot 10 of your Quest Item Inventory already it will not work.
What you could do tho if you already have at least 1 of it is to use the Commit_OnUpdate feature under [ DEBUG ] in the cheat table and whenever you pick up the next Demiguise Moon a window will pop up and in that it should say exactly on what SlotNumber it added it to and then just change it to that slot in my code below
UPDATE InventoryDynamic SET ItemID = 'CURR_Infiltrator_Token', Count = 20, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596323656000000000 WHERE CharacterID = 'Player0' AND HolderID = 'MissionItems' AND SlotNumber = 10;
I did this for the keys needed for the house chests and it gives me the keys but the quest dosnt read you have the keys lol.. opening the chest with the quest still saying you need any of the keys opens it n gives you nothing hahaha
Whats the code for the house chest tokens? struggling with this one.
UPDATE LockDefinition SET LockTypeID = 'Simple_Unlocked' WHERE LockID = 'Spell_AvadaKedavra'
Removing the lock entirely.
Wow, I had completely missed that table. Thanks for the hint.
Doing it that way seems better since it doesn't require a reload and it unlocks all spells. update LockDefinition set LockTypeID='Simple_Unlocked' where LockID like 'Spell_%';
Lots of other interesting stuff in there as well, but I have no time to look any deeper at the moment.
INSERT OR REPLACE INTO PerkDynamic SELECT PerkID, 2 FROM PerkDefinition WHERE PerkID LIKE 'GEN_Inventory_%';
This won't actually complete the trials, but it will unlock the inventory slot rewards from them.
Save and reload after running the command.
sorry how do I do the command I just do it on the table and if yes how or in the console and what command, ``update LockDefinition set LockTypeID='Simple_Unlocked`` this one
I'm also new to all of this,want to unlock all the spells early.. how do I do that? I don't understand. Thanks in advance!
I'm new to this so bear with me a bit, I need help to gain a specific item.
I'm gonna hide what item is this for those who doesn't want to be spoiled with their gameplay Spoiler
I knew the deathly Hallows exist in the game and so does the model.
At some point of the story we'll get to experience the power. I found out that once you picked up an item called 'Invinsibility Cloak', you get to access the Elder Wand (once I picked up the cloak my wand changed to Elder Wand).
for those who don't know what that is, its the most powerful wand in the lore.
It is part of the trial you face, once you finished the trial the item is removed from your inventory (once you finish the trial using Elder Wand I believe, since the Ressurrection Stone does nothing adn I saw the wand returned back to my original wand)
I found this on Akira table
[Link]
(I don't know how to upload an image, sorry)
[Link]
this is also maybe a thing (I dunno for sure), I found this on autodesk presentation back in the day
now I believe the console command is easier and able to accquire this item
Is anyone else experiencing an issue with the dark arts arena spells/unforgiveable curses? When I entered the arena I can only use crucio and confringo, Avada Kedavra and Imperio just cause my character to shake his wand. I decided to create a new save and use the SQL code to give my self all the spells and it causes the same reaction. I don't think it has anything to do with unlocking them via cheats as crucio works but the other 2 just don't. Uninstalling the game, making new saves don't seem to help at all and I'm not sure what to do.
day 1 patch is out and has made the console inaccessible currently with the supplied method sometimes. worked for me a second time so check a few times before coming here.
There's currently no means to print the result of a SELECT statement in some format you're used to seeing to CE's console. The result needs to be first understood, then formatted to be shown. I'd advise not acting as if Hogwarts or CE is some sort of database you query with tools you know.
day 1 patch is out and has made the console inaccessible currently with the supplied method sometimes. worked for me a second time so check a few times before coming here.
Console works fine for me, game's updated (1119132) -and- I don't see others complaining. As long as you don't see an ERROR MESSAGE that tells you to contact me for an update, my stuff still works.
Ive actually played around alot the past hours and trying to figure out how to add items in an easy way, both if I have them already or adding more and using UPDATE will not work since it ONLY updates an already existing one and doesnt add a new one if you have 0 of the item.
Youll have to use INSERT INTO instead if you are at 0 of the item. But only for when you are adding it the first time, after that you can use UPDATE again if you wanna change it.
What Ive managed to do so far is update all items in my Resource Inventory to a specific amount but one IMPORTANT thing to know is that SlotNumber is different for each player since it depends on WHEN you pick it up and if you already have something in that slot in your inventory already the number will be different and it will not work.
That being said I Tried this on my newly created character and it worked so here is the code for adding the Demiguise Moon Item if you are at 0 of it but again if you have something in slot 10 of your Quest Item Inventory already it will not work.
What you could do tho if you already have at least 1 of it is to use the Commit_OnUpdate feature under [ DEBUG ] in the cheat table and whenever you pick up the next Demiguise Moon a window will pop up and in that it should say exactly on what SlotNumber it added it to and then just change it to that slot in my code below
UPDATE InventoryDynamic SET ItemID = 'CURR_Infiltrator_Token', Count = 20, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596323656000000000 WHERE CharacterID = 'Player0' AND HolderID = 'MissionItems' AND SlotNumber = 10;
I did this for the keys needed for the house chests and it gives me the keys but the quest dosnt read you have the keys lol.. opening the chest with the quest still saying you need any of the keys opens it n gives you nothing hahaha
Oooh thats odd, only tried it on a new char but i didnt have the quest to collect the Demiguise Moon so havent tried it out fully tbh. Only shared how i did to actually just add it to the game or update the already existing value.
So Yeah...Wouldnt really recommend to to this for any quest related stuff yet tho since it doesnt make the quest steps trigger and change the statuses as if you would do it normally. Seems you will need to do some other commands to trigger the next step in the quest or to update the quest status.
Im actually looking into how to trigger certain events and quest steps right now, having ALOT to read through to find the right ones tho so I dont break my save xD
The moon quest you can do it for cause quest dosnt trigger changing until you hand in
I Tried this on my newly created character and it worked so here is the code for adding the Demiguise Moon Item if you are at 0 of it but again if you have something in slot 10 of your Quest Item Inventory already it will not work.
