霍格華茲的傳承 解鎖全部飛路之火焰地點 等一些驗證過的解鎖

1. 解鎖快速傳送
   
2. INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM LockDefinition where LockID IN (SELECT Name from FastTravelLocations);
   
3. 
   
4. 開鎖任務修復
   
5. update LockableComponentsDynamic set Locked = 1 where ID like 'FacultyTowerDoor%';
   
6. 
   
7. 正常解鎖法術槽
   
8. INSERT OR REPLACE INTO PerkDynamic (PerkID, Level) VALUES ('GEN_SpellLoadouts_1', 1),('GEN_SpellLoadouts_2', 1),('GEN_SpellLoadouts_3', 1);
   
9. 
   
10. 解鎖全部法術（包含開鎖）
    
11. INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM "LockDefinition" WHERE "LockID" LIKE 'Spell\_%' escape '\';
    
12. 
    
13. 解鎖配方
    
14. INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM "LockDefinition" WHERE "LockID" LIKE 'Transfiguration\_%' escape '\';
    
15. 
    
16. 解鎖衣服裝扮
    
17. INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM "LockDefinition" WHERE LockID LIKE '%\_Basic' escape '\' OR LockID LIKE '%\_Common' escape '\' OR LockID LIKE '%\_Epic' escape '\' OR LockID LIKE '%\_Legendary' escape '\';
    
18. 
    
19. 解鎖魔杖裝扮
    
20. INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM LockDefinition where LockID IN (SELECT ItemID FROM CollectionItems where CategoryID = 'WandStyle');
    
21. 
    
22. 解鎖特質
    
23. INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM "LockDefinition" WHERE "LockID" LIKE 'GearTrait\_%' escape '\';
    
24. 
    

複製代碼

安全新增 資源 道具 如果存在則修改數量

1. INSERT INTO "InventoryDynamic" ("CharacterID", "HolderID", "SlotNumber", "ItemID", "Variation", "Count", "Stolen", "UniqueItem", "KeepOnReset", "UpdateTime")
   
2. VALUES(
   
3. 'Player0', 'ResourceInventory',
   
4. (select IFNULL(MAX(SlotNumber),(select MAX(SlotNumber)+1 from InventoryDynamic where CharacterID='Player0' and HolderID = 'ResourceInventory'))
   
5. from InventoryDynamic where CharacterID='Player0' and HolderID = 'ResourceInventory'
   
6. AND ItemId='Phoenix_Byproduct')
   
7. , 'Phoenix_Byproduct', NULL, 500, 0, 0, 0, 596334041928058929
   
8. )
   
9. ON CONFLICT("CharacterID","HolderID","SlotNumber") DO UPDATE SET "Count" = 500;

複製代碼

新增 資源 道具 如果存在則修改數量

1. INSERT INTO "InventoryDynamic" ("CharacterID", "HolderID", "SlotNumber", "ItemID", "Variation", "Count", "Stolen", "UniqueItem", "KeepOnReset", "UpdateTime")
   
2. VALUES(
   
3. 'Player0', 'ResourceInventory',
   
4. (select IFNULL(MAX(SlotNumber),(select MAX(SlotNumber)+1 from InventoryDynamic where CharacterID='Player0' and HolderID = 'ResourceInventory'))
   
5. from InventoryDynamic where CharacterID='Player0' and HolderID = 'ResourceInventory'
   
6. AND ItemId='Phoenix_Byproduct')
   
7. , 'Phoenix_Byproduct', NULL, 500, 0, 0, 0, 596334041928058929
   
8. )
   
9. ON CONFLICT("CharacterID","HolderID","SlotNumber") DO UPDATE SET "Count" = 500;
   

複製代碼

注意加粗部分
其中 時間 596334041928058929 這裡填 CT表 顯示的 UpdateTime