this is my assumption --- i could totally be wrong!!!!!
I will edit this post when found something
Useful statements
Changing gold/knuts amount
Code: Select all
UPDATE InventoryDynamic SET ItemID = 'Knuts', Count = YOUR_NEW_AMOUNT, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = YOUR_UPDATE_TIME WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND SlotNumber = 0;
------------
The game has two differents CharacterID: Player0 and a "uuid-like" id, be careful at the 'YOUR_CHARACTER_ID' in the statements below
EDIT: saying s***, where "YOUR_CHARACTER_ID" is writted, it is the actor id from WHERE the item is from, like chest, they've their own id, the player, your character is ONLY Player0
EDIT2: not saying much sh***, seems Player0 for player is not always the character id... need investigation
EDIT3: The game is adding the item into the backpack into the slot 0 and then the game update to the correct slot, remember to put the correct slot id of your item when inserting item using InventoryDynamic statement
EDIT4: Insert to InventoryDynamic does not seems to works?
EDIT5: sunbeam, if you watch this, sometimes output print blank
EDIT6: All the items are already in the player backpack, you are not adding it when getting, but the game update your backpack, you only need to use the update statement to get any items from the game, I guess items can't work with proper variation id (can be wrong about how the system work)
Opening chest (transmog item ?)
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'RecipeInventory', 11, 'Recipe_Wand12_Var3', 1, 0, 1, 0, 596324911333258200)
Opening a chest (gold, not eyed one, normal chest)
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('YOUR_CHARACTER_ID', 'ActorBackpack', 0, 'Knuts', 46, 0, 0, 0, 596324935940806593)
UPDATE InventoryDynamic SET ItemID = 'Knuts', Count = 2139, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596324935940806593 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND SlotNumber = 0;
UPDATE InventoryDynamic SET ItemID = null, Variation = null, Count = 0, Stolen = 0, UniqueItem = 0 WHERE CharacterID = 'YOUR_CHARACTER_ID' AND HolderID = 'ActorBackpack' AND SlotNumber = 0;
Obtaining a quest item
Code: Select all
UPDATE InventoryDynamic SET ItemID = 'Quest_FIG_01_LibraryKey', Count = 1, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596324268000000000 WHERE CharacterID = 'Player0' AND HolderID = 'MissionItems' AND SlotNumber = 0;
Retrieving a page of the sorcerer's book
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'NoteInventory', 2, 'Hogwarts_Library_ScribnerNote', 1, 0, 0, 0, 596324268000000000)
Opening a chest (item)
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime , Variation) VALUES ('YOUR_CHARACTER_ID', 'ActorBackpack', 0, 'Neck_017_Common', 1, 0, 1, 0, 596324268000000000, 'DAC7F08749A5A208396E30B2CE6B4D28')
UPDATE InventoryDynamic SET ItemID = 'Neck_017_Common', Count = 1, Stolen = 0, UniqueItem = 1, KeepOnReset = 0, UpdateTime = 596324268000000000 , Variation = 'DAC7F08749A5A208396E30B2CE6B4D28'WHERE CharacterID = 'Player0' AND HolderID = 'ActorBackpack' AND SlotNumber = 4;
UPDATE InventoryDynamic SET ItemID = null, Variation = null, Count = 0, Stolen = 0, UniqueItem = 0 WHERE CharacterID = 'YOUR_CHARACTER_ID' AND HolderID = 'ActorBackpack' AND SlotNumber = 0;
Switching item from inventory (hands, similar to Sunbeam example)
Code: Select all
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'HAND', 'Hand_021_Legendary', '9DA6216D4E7A2883B12731AFFA540586')
Switching item from inventory (facial accessories)
Code: Select all
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'FACE', 'Face_031_Epic', '9A64E817446627A612AB66AA872D0F75')
Switching item from inventory (hats)
Code: Select all
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'HEAD', 'Head_048_Legendary', 'E66E287B4E510CF2FA677889E8322869')
Switching item from inventory (neck)
Code: Select all
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'NECK', 'Neck_017_Common', 'DAC7F08749A5A208396E30B2CE6B4D28')
Switching item from inventory (capes/back)
Code: Select all
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'BACK', 'Back_048_Common', '25AEE9594A9EC56ED1B92799E3533B6A')
Switching item from inventory (outfit)
Code: Select all
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'OUTFIT', 'Outfit_087_Common', 'FBF03AA9419D221D08272FA8F5BD6F6D')
Opening a chest (item but only one statement?)
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime , Variation) VALUES ('YOUR_CHARACTER_ID', 'ActorBackpack', 0, 'Hand_030_Rare', 1, 0, 1, 0, 596324268000000000, 'E31A134544358F5BF0A922B1952FAA10')
Selling item to vendor
Code: Select all
UPDATE InventoryDynamic SET ItemID = null, Variation = null, Count = 0, Stolen = 0, UniqueItem = 0 WHERE CharacterID = 'Player0' AND HolderID = 'ActorBackpack' AND SlotNumber = 4;
Buying item from vendor
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'ResourceInventory', 2, 'HorklumpJuice', 1, 0, 0, 0, 596324321883249365)
UPDATE InventoryDynamic SET ItemID = 'HorklumpJuice', Count = 4, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596324321883249365 WHERE CharacterID = 'percivalpippin' AND HolderID = 'VendorStock' AND SlotNumber = 5;
UPDATE InventoryDynamic SET ItemID = 'Knuts', Count = 2149, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596324321883249365 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND SlotNumber = 0;
Gathering item outdoor
Code: Select all
UPDATE InventoryDynamic SET ItemID = 'LacewingFlies', Count = 2, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596324358607966140 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND SlotNumber = 3;
Gathering item outdoor (first time getting it)
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'ResourceInventory', 4, 'LeapingToadstool_Byproduct', 1, 0, 0, 0, 596324402981589933)
Gathering item outdoor (first time getting it, and not the same SlotNumber)
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'ResourceInventory', 5, 'AshwinderEggs', 1, 0, 0, 0, 596324426317818118)
Gathering item outdoor (first time getting it, not the same SlotNumber, loot of a mob outdoor near the Forbidden Forest)
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'ResourceInventory', 6, 'Dugbog_Pellet', 1, 0, 0, 0, 596324464353071323)
Gathering item outdoor (first time getting it, not the same SlotNumber as above again)
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'ResourceInventory', 7, 'LeechJuice', 1, 0, 0, 0, 596324480124468035)
Gathering moonstone
Code: Select all
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('DB22F98E.72A3C93E', 'ActorBackpack', 0, 'Moonstone', 3, 0, 0, 0, 596324498525848587)
UPDATE InventoryDynamic SET ItemID = 'Moonstone', Count = 8, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596324498525848587 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND SlotNumber = 1;
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('E5A4CCA0.218DB9AF', 'ActorBackpack', 0, 'Moonstone', 2, 0, 0, 0, 596324498796804927)
UPDATE InventoryDynamic SET ItemID = 'Moonstone', Count = 10, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596324498796804927 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND SlotNumber = 1;
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('2C73331D.99EC8421', 'ActorBackpack', 0, 'Moonstone', 3, 0, 0, 0, 596324498909432321)
UPDATE InventoryDynamic SET ItemID = 'Moonstone', Count = 13, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596324498909432321 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND SlotNumber = 1;
[