Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
ads.php	10.11 KB	-rw-r--r--	2025-12-22 20:20
announcements.php	8.13 KB	-rw-r--r--	2025-12-25 17:46
banners.php	9.86 KB	-rw-r--r--	2025-12-22 19:19
boosts.php	5.51 KB	-rw-r--r--	2025-12-24 21:41
daily_targets.php	11.29 KB	-rw-r--r--	2025-12-26 07:59
dashboard.php	9.23 KB	-rw-r--r--	2025-12-25 12:46
deposits.php	13.59 KB	-rw-r--r--	2026-01-26 16:58
dpin_requests.php	7.43 KB	-rw-r--r--	2025-12-24 21:41
dpins.php	9.37 KB	-rw-r--r--	2025-12-23 19:48
error_log	1.14 KB	-rw-r--r--	2026-01-07 16:39
footer.php	122 B	-rw-r--r--	2025-12-25 18:15
header.php	6.83 KB	-rw-r--r--	2026-01-26 17:15
login.php	4.42 KB	-rw-r--r--	2026-01-26 17:46
lucky_wheel.php	24.12 KB	-rw-r--r--	2026-01-26 16:57
orders.php	12.63 KB	-rw-r--r--	2026-01-07 16:27
payment_methods.php	6.53 KB	-rw-r--r--	2025-12-23 19:24
plans.php	22.86 KB	-rw-r--r--	2025-12-29 11:03
products.php	10.72 KB	-rw-r--r--	2026-01-07 16:15
ranks.php	7.31 KB	-rw-r--r--	2025-12-25 16:48
referrals.php	8.7 KB	-rw-r--r--	2025-12-25 12:43
return.php	440 B	-rw-r--r--	2025-12-29 13:55
settings.php	10.77 KB	-rw-r--r--	2026-01-07 16:26
tickets.php	11.98 KB	-rw-r--r--	2025-12-22 19:21
users.php	18.1 KB	-rw-r--r--	2025-12-29 13:53
withdraws.php	11.42 KB	-rw-r--r--	2025-12-24 22:29
wp-blog-header.php	2.74 KB	-r--r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

<?php
define('ADMIN_PANEL', true);
require_once '../includes/config.php';
requireAdmin();

$page_title = 'Support Tickets';

// Handle ticket actions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $action = $_POST['action'];

try {
        if ($action === 'reply') {
            $ticketId = intval($_POST['ticket_id']);
            $message = trim($_POST['message']);

if (empty($message)) {
                throw new Exception("Message is required");
            }

// Add reply
            $stmt = $pdo->prepare("
                INSERT INTO ticket_replies (ticket_id, user_id, is_admin, message) 
                VALUES (?, ?, 1, ?)
            ");
            $stmt->execute([$ticketId, $_SESSION['user_id'], $message]);

// Update ticket status to open
            $stmt = $pdo->prepare("UPDATE support_tickets SET status = 'open' WHERE id = ?");
            $stmt->execute([$ticketId]);

setSuccess("Reply sent successfully!");
            header('Location: tickets.php?ticket_id=' . $ticketId);
            exit;

} elseif ($action === 'close') {
            $ticketId = intval($_POST['ticket_id']);
            $stmt = $pdo->prepare("UPDATE support_tickets SET status = 'closed' WHERE id = ?");
            $stmt->execute([$ticketId]);
            setSuccess("Ticket closed successfully!");

} elseif ($action === 'open') {
            $ticketId = intval($_POST['ticket_id']);
            $stmt = $pdo->prepare("UPDATE support_tickets SET status = 'open' WHERE id = ?");
            $stmt->execute([$ticketId]);
            setSuccess("Ticket reopened successfully!");
        }
    } catch (Exception $e) {
        setError($e->getMessage());
    }

header('Location: tickets.php');
    exit;
}

// Get filter
$filter = $_GET['filter'] ?? 'all';

$query = "
    SELECT st.*, u.full_name, u.email 
    FROM support_tickets st
    JOIN users u ON st.user_id = u.id
";

if ($filter === 'open') {
    $query .= " WHERE st.status = 'open'";
} elseif ($filter === 'closed') {
    $query .= " WHERE st.status = 'closed'";
}

$query .= " ORDER BY st.created_at DESC";

$stmt = $pdo->query($query);
$tickets = $stmt->fetchAll();

// If viewing a specific ticket
$viewingTicket = null;
$ticketReplies = [];
if (isset($_GET['ticket_id'])) {
    $ticketId = intval($_GET['ticket_id']);
    $stmt = $pdo->prepare("
        SELECT st.*, u.full_name, u.email 
        FROM support_tickets st
        JOIN users u ON st.user_id = u.id
        WHERE st.id = ?
    ");
    $stmt->execute([$ticketId]);
    $viewingTicket = $stmt->fetch();

if ($viewingTicket) {
        $stmt = $pdo->prepare("
            SELECT tr.*, u.full_name 
            FROM ticket_replies tr
            LEFT JOIN users u ON tr.user_id = u.id
            WHERE tr.ticket_id = ?
            ORDER BY tr.created_at ASC
        ");
        $stmt->execute([$ticketId]);
        $ticketReplies = $stmt->fetchAll();
    }
}

include 'header.php';
?>

<?php
$success = getSuccess();
if ($success) {
    echo '<div class="alert alert-success"><i class="fas fa-check-circle"></i> ' . htmlspecialchars($success) . '</div>';
}

$error = getError();
if ($error) {
    echo '<div class="alert alert-danger"><i class="fas fa-exclamation-circle"></i> ' . htmlspecialchars($error) . '</div>';
}
?>

<?php if ($viewingTicket): ?>
    
    <div class="card">
        <div class="card-header d-flex justify-between align-center">
            <div>
                <i class="fas fa-ticket-alt"></i> <?php echo htmlspecialchars($viewingTicket['subject']); ?>
            </div>
            <a href="tickets.php" class="btn btn-sm btn-secondary">
                <i class="fas fa-arrow-left"></i> Back
            </a>
        </div>
        <div class="card-body">
            <div style="margin-bottom: 15px;">
                <p style="color: var(--text-secondary); margin-bottom: 5px;">
                    <strong>From:</strong> <?php echo htmlspecialchars($viewingTicket['full_name']); ?>
                </p>
                <p style="color: var(--text-secondary); margin-bottom: 5px;">
                    <strong>Email:</strong> <?php echo htmlspecialchars($viewingTicket['email']); ?>
                </p>
                <p style="color: var(--text-secondary); margin-bottom: 10px;">
                    <strong>Status:</strong>
                    <span class="badge badge-<?php echo $viewingTicket['status'] === 'open' ? 'success' : 'danger'; ?>">
                        <?php echo ucfirst($viewingTicket['status']); ?>
                    </span>
                </p>
                <p style="color: var(--text-secondary); margin: 0; font-size: 12px;">
                    <i class="fas fa-calendar"></i> Created:
                    <?php echo date('M d, Y H:i', strtotime($viewingTicket['created_at'])); ?>
                </p>
            </div>

<div style="max-height: 400px; overflow-y: auto; margin-bottom: 20px;">
                <?php foreach ($ticketReplies as $reply): ?>
                    <div
                        style="margin-bottom: 15px; padding: 15px; background: <?php echo $reply['is_admin'] ? 'rgba(33, 150, 243, 0.1)' : 'var(--dark-bg)'; ?>; border-radius: 8px; border-left: 4px solid <?php echo $reply['is_admin'] ? 'var(--secondary-color)' : 'var(--primary-color)'; ?>;">
                        <div style="display: flex; justify-content: space-between; margin-bottom: 10px;">
                            <strong
                                style="color: <?php echo $reply['is_admin'] ? 'var(--secondary-color)' : 'var(--primary-color)'; ?>;">
                                <?php echo $reply['is_admin'] ? 'Admin (You)' : htmlspecialchars($reply['full_name']); ?>
                            </strong>
                            <span style="color: var(--text-secondary); font-size: 12px;">
                                <?php echo date('M d, Y H:i', strtotime($reply['created_at'])); ?>
                            </span>
                        </div>
                        <p style="color: var(--text-secondary); margin: 0;">
                            <?php echo nl2br(htmlspecialchars($reply['message'])); ?>
                        </p>
                    </div>
                <?php endforeach; ?>
            </div>

<?php if ($viewingTicket['status'] === 'open'): ?>
                <form method="POST" action="">
                    <input type="hidden" name="action" value="reply">
                    <input type="hidden" name="ticket_id" value="<?php echo $viewingTicket['id']; ?>">
                    <div class="form-group">
                        <label class="form-label">Your Reply</label>
                        <textarea name="message" class="form-control" rows="4" placeholder="Type your message..."
                            required></textarea>
                    </div>
                    <div style="display: grid; grid-template-columns: repeat(2, 1fr); gap: 10px;">
                        <button type="submit" class="btn btn-primary">
                            <i class="fas fa-paper-plane"></i> Send Reply
                        </button>
                        <form method="POST" action="" style="margin: 0;">
                            <input type="hidden" name="action" value="close">
                            <input type="hidden" name="ticket_id" value="<?php echo $viewingTicket['id']; ?>">
                            <button type="submit" class="btn btn-danger" style="width: 100%;">
                                <i class="fas fa-times"></i> Close Ticket
                            </button>
                        </form>
                    </div>
                </form>
            <?php else: ?>
                <div class="alert alert-info">
                    <i class="fas fa-info-circle"></i> This ticket is closed.
                </div>
                <form method="POST" action="">
                    <input type="hidden" name="action" value="open">
                    <input type="hidden" name="ticket_id" value="<?php echo $viewingTicket['id']; ?>">
                    <button type="submit" class="btn btn-success btn-block">
                        <i class="fas fa-folder-open"></i> Reopen Ticket
                    </button>
                </form>
            <?php endif; ?>
        </div>
    </div>
<?php else: ?>
    
    <div class="card">
        <div class="card-body">
            <div style="display: flex; gap: 10px; flex-wrap: wrap;">
                <a href="tickets.php?filter=all" class="btn btn-<?php echo $filter === 'all' ? 'primary' : 'secondary'; ?>">
                    All
                </a>
                <a href="tickets.php?filter=open"
                    class="btn btn-<?php echo $filter === 'open' ? 'success' : 'secondary'; ?>">
                    Open
                </a>
                <a href="tickets.php?filter=closed"
                    class="btn btn-<?php echo $filter === 'closed' ? 'danger' : 'secondary'; ?>">
                    Closed
                </a>
            </div>
        </div>
    </div>

<div class="card">
        <div class="card-header">
            <i class="fas fa-headset"></i> Support Tickets (<?php echo count($tickets); ?>)
        </div>
        <div class="card-body">
            <?php if (empty($tickets)): ?>
                <p style="color: var(--text-secondary); text-align: center;">No support tickets yet.</p>
            <?php else: ?>
                <div class="table-responsive">
                    <table>
                        <thead>
                            <tr>
                                <th>Subject</th>
                                <th>User</th>
                                <th>Status</th>
                                <th>Date</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach ($tickets as $ticket): ?>
                                <tr>
                                    <td>
                                        <strong><?php echo htmlspecialchars($ticket['subject']); ?></strong>
                                    </td>
                                    <td>
                                        <?php echo htmlspecialchars($ticket['full_name']); ?>
                                        <br>
                                        <small style="color: var(--text-secondary);">
                                            <?php echo htmlspecialchars($ticket['email']); ?>
                                        </small>
                                    </td>
                                    <td>
                                        <span
                                            class="badge badge-<?php echo $ticket['status'] === 'open' ? 'success' : 'danger'; ?>">
                                            <?php echo ucfirst($ticket['status']); ?>
                                        </span>
                                    </td>
                                    <td><?php echo date('M d, Y', strtotime($ticket['created_at'])); ?></td>
                                    <td>
                                        <a href="tickets.php?ticket_id=<?php echo $ticket['id']; ?>" class="btn btn-sm btn-primary">
                                            <i class="fas fa-eye"></i> View
                                        </a>
                                    </td>
                                </tr>
                            <?php endforeach; ?>
                        </tbody>
                    </table>
                </div>
            <?php endif; ?>
        </div>
    </div>
<?php endif; ?>

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