I have SQL Mod menu and am running it successfully. I too ran into the Fluxweed seed problem and was able to extricate myself using your fix. Thanks a lot for posting it. I am curious. Is there a SQL Mod Menu query that could make all the seeds available?
The transaction to fix the Fluxweed Seed bug could be done like this: UPDATE InventoryDynamic SET (ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime) = ("Fluxweed_Seed", 1, 0, 1, 1, 596333304000000000) WHERE CharacterID="TimothyTeasdale" AND HolderID="VendorStock" AND SlotNumber=0;
That replaces whatever is in slot 0 with Fluxweed Seeds, but marks them as "unique" and "keeponreset" so they don't vanish.
If you wanted to add other stuff I'd guess you'd do something like this: INSERT OR IGNORE INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime) VALUES ("TimothyTeasdale", "VendorStock", 7, "ChompingCabbage_Seed", 1, 0, 0, 0, 596337726460969263); That will put chomping cabbage seeds into slot 7, unless slot 7 is already occupied. Similar transactions could add the other seed types (VenomousTentacula_Seed, Mandrake_Seed, Knotgrass_Seed, Shrivelfig_Seed, Mallowsweet_Seed, etc).
I tried your mod and it worked great. I then tried your SQL query, but that didn’t work. I can’t seem to buy Mallowsweet, Knotgrass, or Shrivelfig seeds.
I sort of found a fix to get all the seeds using the SQL Mod Menu and tweaked it to meet my needs. Basically do this:
Step 01 - Open SQL Menu. Step 02 - Go to Gameplay. Step 03 - Add new. Step 04 - Do the following:
[NAME] Fix Seed Bug [TYPE] Gameplay [NOTES] Add Seeds to Timothy Teasdale's stock. [ONENABLE] UPDATE InventoryDynamic SET (ItemID,Count,Stolen,UniqueItem,KeepOnReset,UpdateTime) = ("???_Seed",1,0,1,1,596333304000000000) WHERE CharacterID ="TimothyTeasdale" AND HolderID="VendorStock" AND SlotNumber=0;
**** NOTE: ON THIS PART REPLACE ??? WITH SEED OF YOUR CHOICE (DITTANY, MALLOWSWEET, FLUXWEED, SHRIVELFIG, KNOTGRASS) *** [ONDISABLE] [QUERY] SELECT * FROM InventoryDynamic WHERE CharacterID="TimothyTeasdale" AND HolderID="VendorStock"; [TRIGGERS] OnGameBoot: false OnModLoaded: true OnLoadScreenEnd: true OnPlayerCharLoaded: true OnPlayerGearLoaded: false OnPlayerTeleported: false OnPlayerTakeDamage: false OnPlayerSpellCast: false
Step 05 - Hit RUN, then Apply. Step 06 - Save and Reload. Step 07 - Go to The Magic Neep and buy your seeds. Step 08 - Save. Step 09 - Open SQL Menu. Step 10 - Go to Gameplay tab. Step 11 - Edit your ENABLE tab to reflect the seed of your choice. For example, if the first time you put in ("Dittany_Seed", 1,0,1,1,596333304000000000), then this time you'd delete Dittany and replace it with another seed type, such as ("Mallowsweet_Seed", 1,0,1,1,596333304000000000) Step 12 - Repeat steps 05 - 11 as needed for you to acquire all the seeds.
I know this is a sloppy fix, but at least it works (at least it did for me) until something better and easier comes along, but that's above my skill level.
can you do it like this? "DITTANY_Seed",1,0,1,1,596333304000000000 "MALLOWSWEET_Seed",1,0,1,1,596333304000000000 "FLUXWEED_Seed",1,0,1,1,596333304000000000 "SHRIVELFIG_Seed",1,0,1,1,596333304000000000 "KNOTGRASS_Seed",1,0,1,1,596333304000000000 so you don't have to exit to main menu multiple times?
6 comments
I have SQL Mod menu and am running it successfully. I too ran into the Fluxweed seed problem and was able to extricate myself using your fix. Thanks a lot for posting it. I am curious. Is there a SQL Mod Menu query that could make all the seeds available?
Thanks
UPDATE InventoryDynamic SET (ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime) =
("Fluxweed_Seed", 1, 0, 1, 1, 596333304000000000) WHERE CharacterID="TimothyTeasdale" AND HolderID="VendorStock" AND SlotNumber=0;
That replaces whatever is in slot 0 with Fluxweed Seeds, but marks them as "unique" and "keeponreset" so they don't vanish.
If you wanted to add other stuff I'd guess you'd do something like this:
INSERT OR IGNORE INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime) VALUES ("TimothyTeasdale", "VendorStock", 7, "ChompingCabbage_Seed", 1, 0, 0, 0, 596337726460969263);That will put chomping cabbage seeds into slot 7, unless slot 7 is already occupied. Similar transactions could add the other seed types (VenomousTentacula_Seed, Mandrake_Seed, Knotgrass_Seed, Shrivelfig_Seed, Mallowsweet_Seed, etc).
I tried your mod and it worked great. I then tried your SQL query, but that didn’t work. I can’t seem to buy Mallowsweet, Knotgrass, or Shrivelfig seeds.
any way you could bug fix mod those? 😇
Step 01 - Open SQL Menu.
Step 02 - Go to Gameplay.
Step 03 - Add new.
Step 04 - Do the following:
[NAME]
Fix Seed Bug
[TYPE]
Gameplay
[NOTES]
Add Seeds to Timothy Teasdale's stock.
[ONENABLE]
UPDATE InventoryDynamic SET (ItemID,Count,Stolen,UniqueItem,KeepOnReset,UpdateTime) =
("???_Seed",1,0,1,1,596333304000000000) WHERE CharacterID ="TimothyTeasdale" AND HolderID="VendorStock" AND SlotNumber=0;
**** NOTE: ON THIS PART REPLACE ??? WITH SEED OF YOUR CHOICE (DITTANY, MALLOWSWEET, FLUXWEED, SHRIVELFIG, KNOTGRASS) ***
[ONDISABLE]
[QUERY]
SELECT * FROM InventoryDynamic WHERE CharacterID="TimothyTeasdale" AND HolderID="VendorStock";
[TRIGGERS]
OnGameBoot: false
OnModLoaded: true
OnLoadScreenEnd: true
OnPlayerCharLoaded: true
OnPlayerGearLoaded: false
OnPlayerTeleported: false
OnPlayerTakeDamage: false
OnPlayerSpellCast: false
Step 05 - Hit RUN, then Apply.
Step 06 - Save and Reload.
Step 07 - Go to The Magic Neep and buy your seeds.
Step 08 - Save.
Step 09 - Open SQL Menu.
Step 10 - Go to Gameplay tab.
Step 11 - Edit your ENABLE tab to reflect the seed of your choice. For example, if the first time you put in ("Dittany_Seed", 1,0,1,1,596333304000000000), then this time you'd delete Dittany and replace it with another seed type, such as ("Mallowsweet_Seed", 1,0,1,1,596333304000000000)
Step 12 - Repeat steps 05 - 11 as needed for you to acquire all the seeds.
I know this is a sloppy fix, but at least it works (at least it did for me) until something better and easier comes along, but that's above my skill level.
"DITTANY_Seed",1,0,1,1,596333304000000000
"MALLOWSWEET_Seed",1,0,1,1,596333304000000000
"FLUXWEED_Seed",1,0,1,1,596333304000000000
"SHRIVELFIG_Seed",1,0,1,1,596333304000000000
"KNOTGRASS_Seed",1,0,1,1,596333304000000000
so you don't have to exit to main menu multiple times?