xp_debug.php

<?php
// Debug script for XP management system
session_start();
include 'config.php';

// Check if user is logged in and is admin/teacher
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

if (!in_array($_SESSION['role'], ['admin', 'teacher'])) {
    header("Location: dashboard.php");
    exit();
}

include 'header.php';
?>

<style>
    .debug-container {
        max-width: 1000px;
        margin: 20px auto;
        padding: 20px;
        background: white;
        border-radius: 10px;
        box-shadow: 0 4px 20px rgba(0,0,0,0.1);
    }

    .debug-section {
        margin-bottom: 30px;
        padding: 20px;
        border: 1px solid #e9ecef;
        border-radius: 8px;
    }

    .debug-section h3 {
        margin-top: 0;
        color: #495057;
        border-bottom: 2px solid #007bff;
        padding-bottom: 10px;
    }

    .status-good {
        color: #28a745;
        font-weight: bold;
    }

    .status-bad {
        color: #dc3545;
        font-weight: bold;
    }

    .test-result {
        padding: 10px;
        margin: 10px 0;
        border-radius: 4px;
        font-family: monospace;
    }

    .test-success {
        background: #d4edda;
        border: 1px solid #c3e6cb;
        color: #155724;
    }

    .test-error {
        background: #f8d7da;
        border: 1px solid #f5c6cb;
        color: #721c24;
    }

    .test-btn {
        background: #007bff;
        color: white;
        border: none;
        padding: 10px 20px;
        border-radius: 5px;
        cursor: pointer;
        margin: 5px;
    }

    .test-btn:hover {
        background: #0056b3;
    }

    .table-debug {
        width: 100%;
        border-collapse: collapse;
        margin-top: 10px;
    }

    .table-debug th,
    .table-debug td {
        padding: 8px;
        text-align: left;
        border: 1px solid #ddd;
    }

    .table-debug th {
        background: #f8f9fa;
        font-weight: 600;
    }
</style>

<main>
    <div class="debug-container">
        <h1>🔧 XP Management Debug Tool</h1>
        <p>Use this tool to diagnose issues with the XP spending system.</p>

        <!-- Database Tables Check -->
        <div class="debug-section">
            <h3>📊 Database Tables Check</h3>
            <?php
            $tables = ['xp_spending_items', 'xp_spending_requests', 'notifications'];
            foreach ($tables as $table) {
                $result = $conn->query("SHOW TABLES LIKE '$table'");
                $exists = $result && $result->num_rows > 0;
                echo "<div class='test-result " . ($exists ? "test-success" : "test-error") . "'>";
                echo "Table '$table': " . ($exists ? "EXISTS ✓" : "MISSING ✗");
                echo "</div>";
            }
            ?>
        </div>

        <!-- Session Check -->
        <div class="debug-section">
            <h3>🔐 Session Check</h3>
            <div class="test-result test-success">
                User ID: <?php echo $_SESSION['user_id']; ?><br>
                Username: <?php echo htmlspecialchars($_SESSION['username']); ?><br>
                Role: <?php echo $_SESSION['role']; ?><br>
                Session Status: ACTIVE ✓
            </div>
        </div>

        <!-- XP Items Check -->
        <div class="debug-section">
            <h3>🎁 XP Items Check</h3>
            <?php
            $result = $conn->query("SELECT COUNT(*) as count FROM xp_spending_items");
            if ($result) {
                $count = $result->fetch_assoc()['count'];
                echo "<div class='test-result test-success'>Total XP items: $count</div>";

                if ($count > 0) {
                    $items_result = $conn->query("SELECT id, title, xp_cost, category, is_active FROM xp_spending_items ORDER BY xp_cost ASC LIMIT 10");
                    echo "<table class='table-debug'>";
                    echo "<tr><th>ID</th><th>Title</th><th>XP Cost</th><th>Category</th><th>Active</th></tr>";
                    while ($item = $items_result->fetch_assoc()) {
                        echo "<tr>";
                        echo "<td>{$item['id']}</td>";
                        echo "<td>{$item['title']}</td>";
                        echo "<td>{$item['xp_cost']}</td>";
                        echo "<td>{$item['category']}</td>";
                        echo "<td>" . ($item['is_active'] ? 'Yes' : 'No') . "</td>";
                        echo "</tr>";
                    }
                    echo "</table>";
                }
            } else {
                echo "<div class='test-result test-error'>Cannot query XP items table</div>";
            }
            ?>
        </div>

        <!-- Pending Requests Check -->
        <div class="debug-section">
            <h3>📋 Pending Requests Check</h3>
            <?php
            $result = $conn->query("SELECT COUNT(*) as count FROM xp_spending_requests WHERE status = 'pending'");
            if ($result) {
                $count = $result->fetch_assoc()['count'];
                echo "<div class='test-result test-success'>Pending requests: $count</div>";

                if ($count > 0) {
                    $req_result = $conn->query("
                        SELECT r.id, u.first_name, u.last_name, i.title, r.xp_cost, r.requested_at
                        FROM xp_spending_requests r
                        JOIN users u ON r.student_id = u.id
                        JOIN xp_spending_items i ON r.item_id = i.id
                        WHERE r.status = 'pending'
                        ORDER BY r.requested_at DESC LIMIT 5
                    ");
                    echo "<table class='table-debug'>";
                    echo "<tr><th>Student</th><th>Item</th><th>XP Cost</th><th>Requested</th></tr>";
                    while ($req = $req_result->fetch_assoc()) {
                        echo "<tr>";
                        echo "<td>{$req['first_name']} {$req['last_name']}</td>";
                        echo "<td>{$req['title']}</td>";
                        echo "<td>{$req['xp_cost']}</td>";
                        echo "<td>" . date('M j, Y g:i A', strtotime($req['requested_at'])) . "</td>";
                        echo "</tr>";
                    }
                    echo "</table>";
                }
            } else {
                echo "<div class='test-result test-error'>Cannot query pending requests</div>";
            }
            ?>
        </div>

        <!-- AJAX Test -->
        <div class="debug-section">
            <h3>🌐 AJAX Test</h3>
            <p>Test the AJAX endpoints used by the XP management system:</p>

            <button class="test-btn" onclick="testAjax('get_pending_requests')">Test Pending Requests</button>
            <button class="test-btn" onclick="testAjax('get_xp_items')">Test XP Items</button>
            <button class="test-btn" onclick="testAjax('get_request_history')">Test Request History</button>

            <div id="ajax-result" style="margin-top: 15px; padding: 10px; border: 1px solid #ddd; border-radius: 4px; background: #f8f9fa; display: none;"></div>
        </div>

        <!-- Setup Instructions -->
        <div class="debug-section">
            <h3>🚀 Setup Instructions</h3>
            <p>If you're seeing errors, make sure to run the XP setup script:</p>
            <ol>
                <li>Access your database admin panel (phpMyAdmin, etc.)</li>
                <li>Run the queries from <code>xp_spending_setup.php</code></li>
                <li>Or access <code>xp_spending_setup.php</code> directly in your browser</li>
                <li>Check that the tables <code>xp_spending_items</code> and <code>xp_spending_requests</code> exist</li>
            </ol>
        </div>
    </div>
</main>

<script>
function testAjax(action) {
    const resultDiv = document.getElementById('ajax-result');
    resultDiv.style.display = 'block';
    resultDiv.innerHTML = 'Testing ' + action + '...';

    fetch('xp_management_handler.php', {
        method: 'POST',
        headers: { 'Content-Type': 'application/x-www-form-urlencoded' },
        body: 'action=' + action
    })
    .then(response => {
        if (!response.ok) {
            throw new Error('HTTP ' + response.status + ': ' + response.statusText);
        }
        return response.json();
    })
    .then(data => {
        resultDiv.innerHTML = '<pre>' + JSON.stringify(data, null, 2) + '</pre>';
        resultDiv.className = data.success ? 'test-result test-success' : 'test-result test-error';
    })
    .catch(error => {
        resultDiv.innerHTML = 'AJAX Error: ' + error.message;
        resultDiv.className = 'test-result test-error';
    });
}
</script>

<?php include 'footer.php'; ?>