|
|
本帖最后由 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;
注意加粗部分
其中 时间 596334041928058929 这里填 CT表 显示的 UpdateTime
|
|
[复制链接]
发表于 2023-2-15 21:37
楼主