Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
AssignmentWorkZone.apk	19.5 MB	-rw-r--r--	2026-03-28 16:09
assignment.php	20.18 KB	-rw-r--r--	2026-03-31 10:04
checkout.php	10.61 KB	-rw-r--r--	2026-03-13 17:01
dashboard.php	10.53 KB	-rw-r--r--	2026-03-31 10:21
history.php	3.6 KB	-rw-r--r--	2026-03-12 12:52
logout.php	91 B	-rw-r--r--	2026-03-11 23:27
pending.php	4.56 KB	-rw-r--r--	2026-03-12 01:29
plan-current.php	2.55 KB	-rw-r--r--	2026-03-11 23:27
profile.php	5.04 KB	-rw-r--r--	2026-03-28 15:45
referral-commissions.php	6.07 KB	-rw-r--r--	2026-03-12 00:37
referral.php	8.61 KB	-rw-r--r--	2026-03-28 15:31
select-plan.php	3.4 KB	-rw-r--r--	2026-03-11 23:27
support.php	12.43 KB	-rw-r--r--	2026-03-12 13:23
team-commission.php	2.82 KB	-rw-r--r--	2026-03-12 12:52
team-details.php	4.46 KB	-rw-r--r--	2026-03-12 15:31
withdraw-history.php	3.53 KB	-rw-r--r--	2026-03-12 12:52
withdraw.php	8.18 KB	-rw-r--r--	2026-03-12 15:18
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
require_once '../includes/config.php';

// Ensure user is loaded
$stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([$_SESSION['user_id']]);
$user = $stmt->fetch();

if (!$user || $user['status'] != 'active') {
    header("Location: ../login.php");
    exit;
}
// 1. Session and Data logic first
$error = '';
$success = $_SESSION['success'] ?? '';
unset($_SESSION['success']);
$info = $_SESSION['info'] ?? '';
unset($_SESSION['info']);

// Handle Ticket Submission (New Ticket)
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['submit_ticket'])) {
    $subject = trim($_POST['subject']);
    $message = trim($_POST['message']);

if (!empty($subject) && !empty($message)) {
        $stmt = $pdo->prepare("INSERT INTO tickets (user_id, subject, message, status) VALUES (?, ?, ?, 'open')");
        $stmt->execute([$user['id'], $subject, $message]);
        $_SESSION['success'] = "Support ticket created successfully! Our team will respond shortly.";
        header("Location: support.php");
        exit;
    }
    else {
        $error = "Please fill in both subject and message.";
    }
}

// Handle User Reply
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['reply_ticket'])) {
    $ticket_id = (int)$_POST['ticket_id'];
    $message = trim($_POST['message']);

// Security: Check if ticket belongs to user
    $checkStmt = $pdo->prepare("SELECT id FROM tickets WHERE id = ? AND user_id = ?");
    $checkStmt->execute([$ticket_id, $user['id']]);
    
    if ($checkStmt->fetch() && !empty($message)) {
        $stmt = $pdo->prepare("INSERT INTO ticket_replies (ticket_id, sender_role, message) VALUES (?, 'user', ?)");
        $stmt->execute([$ticket_id, $message]);

// Mark as open/in_progress again if it was resolved? 
        $pdo->prepare("UPDATE tickets SET status = 'open' WHERE id = ? AND status = 'resolved'")->execute([$ticket_id]);
        
        $_SESSION['success'] = "Your reply has been sent.";
        header("Location: support.php?view=" . $ticket_id);
        exit;
    } else {
        $error = "Invalid ticket or empty message.";
    }
}

// 2. Now include visual elements
require_once '../includes/header_dashboard.php';
require_once '../includes/sidebar.php';

// View specific ticket if requested
$view_ticket = null;
$replies = [];
if (isset($_GET['view'])) {
    $id = (int)$_GET['view'];
    $stmt = $pdo->prepare("SELECT * FROM tickets WHERE id = ? AND user_id = ?");
    $stmt->execute([$id, $user['id']]);
    $view_ticket = $stmt->fetch();

if ($view_ticket) {
        $rStmt = $pdo->prepare("SELECT * FROM ticket_replies WHERE ticket_id = ? ORDER BY id ASC");
        $rStmt->execute([$id]);
        $replies = $rStmt->fetchAll();
    } else {
        $error = "Ticket not found or access denied.";
    }
}

// Fetch All Tickets for the list
$stmt = $pdo->prepare("SELECT * FROM tickets WHERE user_id = ? ORDER BY created_at DESC");
$stmt->execute([$user['id']]);
$tickets = $stmt->fetchAll();
?>

<div style="display:flex; justify-content:space-between; align-items:center; margin-bottom:30px;">
    <h2>Support Center</h2>
    <span style="color:var(--text-muted); font-size:0.9rem;">Need help? Create a ticket below.</span>
</div>

<?php if ($error): ?>
    <div class="badge badge-danger" style="display:block; margin-bottom:20px; text-align:center; padding:15px; border-radius:8px; font-size:1rem;"><?php echo $error; ?></div>
<?php
endif; ?>

<?php if ($success): ?>
    <div class="badge badge-success" style="display:block; margin-bottom:20px; text-align:center; padding:15px; border-radius:8px; font-size:1rem;"><?php echo $success; ?></div>
<?php
endif; ?>

<?php if ($view_ticket): ?>
    
    <a href="support.php" class="btn-outline" style="margin-bottom:20px; display:inline-block;"><i class="fas fa-arrow-left"></i> Back to My Tickets</a>
    
    <div class="card" style="padding:30px; margin-bottom:30px; text-align:left; background: rgba(255,255,255,0.02);">
        <div style="display:flex; justify-content:space-between; align-items:center; margin-bottom:25px; border-bottom:1px solid rgba(255,255,255,0.05); padding-bottom:15px;">
            <h3 style="margin:0; color:var(--primary-color);">Subject: <?php echo htmlspecialchars($view_ticket['subject']); ?></h3>
            <span class="badge <?php echo $view_ticket['status'] == 'open' ? 'badge-warning' : ($view_ticket['status'] == 'in_progress' ? 'badge-primary' : 'badge-success'); ?>">
                <?php echo ucfirst(str_replace('_', ' ', $view_ticket['status'])); ?>
            </span>
        </div>

<div style="max-height: 450px; overflow-y: auto; padding-right: 15px; margin-bottom: 30px; display:flex; flex-direction:column; gap:20px;" class="custom-scrollbar">
            
            <div style="align-self: flex-start; max-width: 85%; background: rgba(52, 152, 219, 0.1); border-left:4px solid #3498db; padding:20px; border-radius:15px; border-top-left-radius:0;">
                <div style="display:flex; justify-content:space-between; align-items:center; margin-bottom:10px;">
                    <strong style="font-size:0.9rem; color:#3498db;">You (Original Message)</strong>
                    <span style="font-size:0.75rem; color:var(--text-muted);"><?php echo date('M d, h:i A', strtotime($view_ticket['created_at'])); ?></span>
                </div>
                <p style="margin:0; line-height:1.6;"><?php echo nl2br(htmlspecialchars($view_ticket['message'])); ?></p>
            </div>

<?php foreach ($replies as $r): ?>
                <div style="align-self: <?php echo $r['sender_role'] == 'admin' ? 'flex-end' : 'flex-start'; ?>; max-width: 85%; <?php echo $r['sender_role'] == 'admin' ? 'background: rgba(0, 210, 106, 0.1); border-right:4px solid var(--primary-color); border-top-right-radius:0;' : 'background: rgba(52, 152, 219, 0.05); border-left:4px solid #3498db; border-top-left-radius:0;'; ?> padding:20px; border-radius:15px;">
                    <div style="display:flex; justify-content:space-between; align-items:center; margin-bottom:10px; gap:40px;">
                        <strong style="font-size:0.9rem; color:<?php echo $r['sender_role'] == 'admin' ? 'var(--primary-color)' : '#3498db'; ?>;"><?php echo $r['sender_role'] == 'admin' ? 'Support Team' : 'You'; ?></strong>
                        <span style="font-size:0.75rem; color:var(--text-muted);"><?php echo date('M d, h:i A', strtotime($r['created_at'])); ?></span>
                    </div>
                    <p style="margin:0; line-height:1.6;"><?php echo nl2br(htmlspecialchars($r['message'])); ?></p>
                </div>
            <?php endforeach; ?>
        </div>

<?php if ($view_ticket['status'] != 'resolved'): ?>
            <div style="background:rgba(255,255,255,0.03); padding:25px; border-radius:15px; border:1px solid rgba(255,255,255,0.05);">
                <h4 style="margin-bottom:15px;"><i class="fas fa-reply" style="margin-right:8px;"></i> Write a Reply</h4>
                <form method="POST">
                    <input type="hidden" name="ticket_id" value="<?php echo $view_ticket['id']; ?>">
                    <div class="form-group">
                        <textarea name="message" class="form-control" rows="4" placeholder="Type your message here..." required style="resize:none; padding:15px; background:var(--bg-dark);"></textarea>
                    </div>
                    <button type="submit" name="reply_ticket" class="btn-primary" style="padding:12px 30px;">Send Reply</button>
                </form>
            </div>
        <?php else: ?>
            <div style="text-align:center; padding:20px; background:rgba(46, 204, 113, 0.1); border-radius:12px; color:#2ecc71; border:1px solid rgba(46, 204, 113, 0.2);">
                <i class="fas fa-check-circle" style="margin-right:8px;"></i> This ticket has been marked as <strong>Resolved</strong>. If you still need help, please open a new ticket.
            </div>
        <?php endif; ?>
    </div>

<?php else: ?>
    
    <div class="grid" style="grid-template-columns: 1.5fr 1fr; align-items: start;">
        
        <div class="card" style="padding:0; overflow:hidden;">
            <div style="padding:20px; border-bottom:1px solid rgba(255,255,255,0.05);">
                <h3 style="margin:0;">My Support Tickets</h3>
            </div>
            <div style="max-height: 380px; overflow-y: auto; overflow-x: auto;" class="custom-scrollbar">
                <table class="admin-table">
                    <thead style="position: sticky; top: 0; z-index: 10; background: var(--card-bg-dark);">
                        <tr>
                            <th>Subject</th>
                            <th>Created</th>
                            <th>Status</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php if (count($tickets) > 0): ?>
                            <?php foreach ($tickets as $t): ?>
                            <tr>
                                <td style="font-weight:600;">
                                    <?php echo htmlspecialchars($t['subject']); ?>
                                    <div style="font-size:0.8rem; font-weight:400; color:var(--text-muted); margin-top:5px;">
                                        <?php echo(strlen($t['message']) > 40) ? substr(htmlspecialchars($t['message']), 0, 40) . '...' : htmlspecialchars($t['message']); ?>
                                    </div>
                                </td>
                                <td style="font-size:0.85rem; color:var(--text-muted);">
                                    <?php echo date('d M Y', strtotime($t['created_at'])); ?>
                                </td>
                                <td>
                                    <?php
            $status_class = '';
            if ($t['status'] == 'open')
                $status_class = 'badge-warning';
            elseif ($t['status'] == 'in_progress')
                $status_class = 'badge-primary';
            elseif ($t['status'] == 'resolved')
                $status_class = 'badge-success';
    ?>
                                    <span class="badge <?php echo $status_class; ?>">
                                        <?php echo str_replace('_', ' ', ucfirst($t['status'])); ?>
                                    </span>
                                </td>
                                <td>
                                    <a href="?view=<?php echo $t['id']; ?>" class="btn-primary" style="padding:5px 12px; font-size:0.8rem; box-shadow:none;">View</a>
                                </td>
                            </tr>
                            <?php endforeach; ?>
                        <?php else: ?>
                            <tr>
                                <td colspan="4" style="text-align:center; padding:50px; color:var(--text-muted);">
                                    You haven't created any support tickets yet.
                                </td>
                            </tr>
                        <?php endif; ?>
                    </tbody>
                </table>
            </div>
        </div>

<div class="card" style="text-align:left;">
            <h3 style="margin-bottom:20px;">Open New Ticket</h3>
            <form method="POST">
                <div class="form-group">
                    <label>Subject / Topic</label>
                    <input type="text" name="subject" class="form-control" placeholder="e.g. Withdrawal Delay" required>
                </div>
                <div class="form-group">
                    <label>Detailed Message</label>
                    <textarea name="message" class="form-control" rows="6" placeholder="Describe your issue in detail..." required style="resize:none; padding:15px;"></textarea>
                </div>
                <button type="submit" name="submit_ticket" class="btn-primary" style="width:100%; margin-top:10px;">Create Ticket</button>
            </form>
        </div>
    </div>
<?php endif; ?>

<?php require_once '../includes/footer_dashboard.php'; ?>