Wow-Manager

• Back-end
• PHP
• MySQL
• JavaScript
• Discord API

World of Warcraft Guild Manager is a full-stack web application built for managing guild raids, member attendance, and DKP (Dragon Kill Points) tracking for a World of Warcraft guild.

I built the entire system: a custom PHP router with role-based access control, a comprehensive DKP management system with automated point calculations, raid scheduling and attendance tracking, member management with Discord integration, and administrative tools for guild leadership.

How it works (user flow → DKP system)

1. Member Management: Guild members can create accounts and link them to their in-game characters. Discord bot integration allows automatic member registration and updates.
2. Raid Scheduling: Admins create raids with dates, descriptions, and automatically generate attendance tracking for all guild members. Members can mark their attendance (will attend/might attend/won’t attend).
3. DKP Tracking: The system automatically calculates DKP based on raid participation. Members earn 2 DKP for attending raids (capped at 30), with additional bonuses for punctuality and penalties for spending on items.
4. Raid Completion: When raids are marked as finished, the system processes attendance, updates member DKP totals, and creates detailed participation records with item purchases and notes.
5. Analytics & Reporting: Members can view their DKP history, raid participation statistics, and guild-wide leaderboards. Admins have access to comprehensive management tools for all aspects of the system.

What I built (scope & responsibilities)

• Custom PHP Framework: Built a lightweight routing system with middleware for authentication, authorization, and error handling.
• Database Design: Designed and implemented a normalized MySQL schema for members, raids, attendance, DKP tracking, classes, roles, and audit logging.
• DKP Management System: Automated DKP calculations with transaction safety, point caps, and historical tracking with rollback capabilities.
• Discord Integration: Secure API endpoints for Discord bot communication, allowing automated member registration and updates.
• Administrative Interface: Comprehensive admin panel for managing members, raids, classes, roles, and system-wide configurations.
• Member Portal: User-friendly interface for members to view their stats, link characters, and manage attendance.

Design choices that make it robust

• Transaction Safety: All DKP operations use database transactions to prevent data corruption during concurrent updates.
• Role-Based Access: Granular permissions system separating member, admin, and public access with secure route protection.
• Audit Logging: Complete action logging for all administrative operations, enabling accountability and debugging.
• Data Integrity: Foreign key constraints and validation ensure consistent data relationships and prevent orphaned records.
• Modular Architecture: Clean separation between routing, business logic, and data access layers for maintainability.