游戏狂人
![Rank: 6](static/image/common/star_level3.gif) ![Rank: 6](static/image/common/star_level2.gif)
- 贡献度
- 34
- 金元
- 15775
- 积分
- 1714
- 精华
- 0
- 注册时间
- 2015-1-25
|
需要调查声明
EDIT4:插入到 InventoryDynamic 似乎不起作用?
EDIT5: sunbeam
,如果你看这个, 有时会输出打印空白游戏中的任何物品,我猜物品不能使用适当的变体 ID(系统工作方式可能是错误的)
打开箱子(幻化物品?)
代码:全选
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'RecipeInventory', 11, 'Recipe_Wand12_Var3', 1, 0, 1, 0, 596324911333258200)
打开一个箱子(金色的,没有眼睛的,普通的箱子)
代码:全选
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;
获得任务物品
代码:全选
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;
取回魔法书的一页
代码:全选
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'NoteInventory', 2, 'Hogwarts_Library_ScribnerNote', 1, 0, 0, 0, 596324268000000000)
打开箱子(物品)
代码:全选
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;
从库存切换项目(手,类似于 Sunbeam 示例)
代码:全选
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'HAND', 'Hand_021_Legendary', '9DA6216D4E7A2883B12731AFFA540586')
从库存切换项目(面部配件)
代码:全选
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'FACE', 'Face_031_Epic', '9A64E817446627A612AB66AA872D0F75')
从库存中切换项目(帽子)
代码:全选
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'HEAD', 'Head_048_Legendary', 'E66E287B4E510CF2FA677889E8322869')
从库存中切换项目(颈部)
代码:全选
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'NECK', 'Neck_017_Common', 'DAC7F08749A5A208396E30B2CE6B4D28')
从库存切换项目(斗篷/背部)
代码:全选
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'BACK', 'Back_048_Common', '25AEE9594A9EC56ED1B92799E3533B6A')
从库存(装备)切换项目
代码:全选
INSERT OR REPLACE INTO EquippedGearDynamic (ActorID, SlotID, GearID, GearVariation ) VALUES ('Player0', 'OUTFIT', 'Outfit_087_Common', 'FBF03AA9419D221D08272FA8F5BD6F6D')
打开一个箱子(物品但只有一个声明?)
代码:全选
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')
向供应商出售物品
代码:全选
UPDATE InventoryDynamic SET ItemID = null, Variation = null, Count = 0, Stolen = 0, UniqueItem = 0 WHERE CharacterID = 'Player0' AND HolderID = 'ActorBackpack' AND SlotNumber = 4;
从供应商处购买物品
代码:全选
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;
户外收集物品
代码:全选
UPDATE InventoryDynamic SET ItemID = 'LacewingFlies', Count = 2, Stolen = 0, UniqueItem = 0, KeepOnReset = 0, UpdateTime = 596324358607966140 WHERE CharacterID = 'Player0' AND HolderID = 'ResourceInventory' AND SlotNumber = 3;
户外收集物品(第一次拿到)
代码:全选
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'ResourceInventory', 4, 'LeapingToadstool_Byproduct', 1, 0, 0, 0, 596324402981589933)
户外采集物品(第一次拿到,而且SlotNumber不一样)
代码:全选
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'ResourceInventory', 5, 'AshwinderEggs', 1, 0, 0, 0, 596324426317818118)
户外采集物品(第一次拿到,不一样的SlotNumber,禁林附近户外暴徒的战利品)
代码:全选
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'ResourceInventory', 6, 'Dugbog_Pellet', 1, 0, 0, 0, 596324464353071323)
户外采集物品(第一次拿到,又和上面的SlotNumber不一样)
代码:全选
INSERT INTO InventoryDynamic (CharacterID, HolderID, SlotNumber, ItemID, Count, Stolen, UniqueItem, KeepOnReset, UpdateTime ) VALUES ('Player0', 'ResourceInventory', 7, 'LeechJuice', 1, 0, 0, 0, 596324480124468035)
采集月光石
代码:全选
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;
[ |
|