Raid management (add, edit, delete, attendance)

[avandenberghe]

Summary

Implement raid management — the core workflow for awarding DKP points.

Features

Raid CRUD

• Add raid: select event type, date/time, attendees, base DKP value, notes
• Edit raid: modify details, add/remove attendees
• Delete raid: cascade-deletes associated transactions and item drops
• Copy raid: duplicate as template with new timestamp

Attendance tracking

• Select attendees from guild roster (filtered by guild/game)
• Bulk add/remove attendees
• Time-based bonuses: optional start/end time per attendee for proportional DKP

DKP distribution

• On raid save, create earned transactions per attendee in the transaction ledger
• Support for raid value override per event type
• Connected raids: link raids within a time window (multi-boss sessions)

ACP interface

• Raid list with filtering by date range, event, pool
• Raid detail view with attendees and loot
• Bulk operations (delete selected, update values)

Schema

bb_dkp_raids

Column	Type	Description
raid_id	INT PK AUTO
guild_id	INT	FK to bb_guild
event_id	INT	FK to bb_dkp_events
raid_date	INT	Unix timestamp
raid_value	DECIMAL(11,2)	Base DKP awarded
raid_note	TEXT	BBCode notes
raid_added_by	INT	User ID

bb_dkp_raid_attendees

Column	Type	Description
raid_id	INT	FK
player_id	INT	FK to bb_players
join_time	INT NULL	For time-based DKP
leave_time	INT NULL

Reference

• Old bbDKP: acp_dkp_raid.php, controller/raids/
• EQdkp Plus: admin/manage_raids.php