游戏精英
- 贡献度
- 195
- 金元
- 74319
- 积分
- 8212
- 精华
- 0
- 注册时间
- 2011-2-28
|
本帖最后由 pjy612 于 2023-2-15 22:44 编辑
- 安全添加 资源 道具 如果存在则修改数量
- 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
|
|