Loot/item management

[avandenberghe]

Summary

Implement loot tracking — items dropped in raids and awarded to players.

Features

• Add item: name, value (DKP cost), buyer(s), raid, date
• Edit/delete items
• Item pools: group items by category (e.g. "Tier tokens", "Weapons")
• Link items to raids (which raid dropped it)
• Link items to players (who received it)
• On item save, create spent transaction(s) in the ledger per buyer
• Game item ID field for tooltip integration (e.g. Wowhead)

Schema

bb_dkp_items

Column	Type	Description
item_id	INT PK AUTO
item_name	VARCHAR(255)
item_gameid	VARCHAR(50)	Game-specific item ID (for tooltips)
item_value	DECIMAL(11,2)	DKP cost
item_date	INT	Unix timestamp
raid_id	INT NULL	FK to bb_dkp_raids
itempool_id	INT	FK to bb_dkp_itempools
item_added_by	INT	User ID

bb_dkp_item_buyers

Column	Type	Description
item_id	INT	FK
player_id	INT	FK to bb_players

bb_dkp_itempools

Column	Type	Description
itempool_id	INT PK AUTO
itempool_name	VARCHAR(255)
itempool_desc	VARCHAR(255)

Reference

• Old bbDKP: acp_dkp_item.php, controller/loot/
• EQdkp Plus: admin/manage_items.php, admin/manage_itempools.php