Buying an Item from a Trader

Description

A player purchases an item from an NPC trader.

SQL Example

INSERT INTO Character_Item (CharacterID, ItemID)
SELECT 1, ItemID FROM Trader_Item WHERE TraderID = 1 AND ItemID = 2;