- 解鎖快速傳送
- INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM LockDefinition where LockID IN (SELECT Name from FastTravelLocations);
- 開鎖任務修復
- update LockableComponentsDynamic set Locked = 1 where ID like 'FacultyTowerDoor%';
- 正常解鎖法術槽
- INSERT OR REPLACE INTO PerkDynamic (PerkID, Level) VALUES ('GEN_SpellLoadouts_1', 1),('GEN_SpellLoadouts_2', 1),('GEN_SpellLoadouts_3', 1);
- 解鎖全部法術(包含開鎖)
- INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM "LockDefinition" WHERE "LockID" LIKE 'Spell\_%' escape '\';
- 解鎖配方
- INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM "LockDefinition" WHERE "LockID" LIKE 'Transfiguration\_%' escape '\';
- 解鎖衣服裝扮
- 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 '\';
- 解鎖魔杖裝扮
- INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM LockDefinition where LockID IN (SELECT ItemID FROM CollectionItems where CategoryID = 'WandStyle');
- 解鎖特質
- INSERT OR REPLACE INTO "LocksDynamic" ("LockID", "ELockState") SELECT LockID,0 FROM "LockDefinition" WHERE "LockID" LIKE 'GearTrait\_%' escape '\';
複製代碼 安全新增 資源 道具 如果存在則修改數量- INSERT INTO "InventoryDynamic" ("CharacterID", "HolderID", "SlotNumber", "ItemID", "Variation", "Count", "Stolen", "UniqueItem", "KeepOnReset", "UpdateTime")
- VALUES(
- 'Player0', 'ResourceInventory',
- (select IFNULL(MAX(SlotNumber),(select MAX(SlotNumber)+1 from InventoryDynamic where CharacterID='Player0' and HolderID = 'ResourceInventory'))
- from InventoryDynamic where CharacterID='Player0' and HolderID = 'ResourceInventory'
- AND ItemId='Phoenix_Byproduct')
- , 'Phoenix_Byproduct', NULL, 500, 0, 0, 0, 596334041928058929
- )
- ON CONFLICT("CharacterID","HolderID","SlotNumber") DO UPDATE SET "Count" = 500;
複製代碼 新增 資源 道具 如果存在則修改數量- INSERT INTO "InventoryDynamic" ("CharacterID", "HolderID", "SlotNumber", "ItemID", "Variation", "Count", "Stolen", "UniqueItem", "KeepOnReset", "UpdateTime")
- VALUES(
- 'Player0', 'ResourceInventory',
- (select IFNULL(MAX(SlotNumber),(select MAX(SlotNumber)+1 from InventoryDynamic where CharacterID='Player0' and HolderID = 'ResourceInventory'))
- from InventoryDynamic where CharacterID='Player0' and HolderID = 'ResourceInventory'
- AND ItemId='Phoenix_Byproduct')
- , 'Phoenix_Byproduct', NULL, 500, 0, 0, 0, 596334041928058929
- )
- ON CONFLICT("CharacterID","HolderID","SlotNumber") DO UPDATE SET "Count" = 500;
複製代碼 注意加粗部分
其中 時間 596334041928058929 這裡填 CT表 顯示的 UpdateTime
|