# PAIDSURVEYHUB 14 OCT 2025 - REPOSITORY
================================================================================

Project Name: PaidSurveyHub 14 Oct 2025
Created: 2025-10-14 02:15:11
Last Updated: 2025-10-14 02:16:04
Source ZIP: public_html.zip
Total Files: 42
Total Folders: 5

================================================================================
## FILE STRUCTURE
================================================================================

PaidSurveyHub 14 Oct 2025/
├── assets/
│   └── style.css
├── config/
│   └── config.php
├── contact.php
├── create-admin.php
├── dashboard.php
├── default.php
├── includes/
│   ├── footer.php
│   └── header.php
├── index.php
├── login.php
├── logout.php
├── management/
│   ├── add-survey.php
│   ├── dashboard.php
│   ├── delete-survey.php
│   ├── edit-member.php
│   ├── edit-survey.php
│   ├── index.php
│   ├── logout.php
│   ├── manage-members.php
│   ├── manage-surveys.php
│   ├── manage-tickets.php
│   ├── reply-ticket.php
│   ├── settings.php
│   └── view-ticket.php
├── my-tickets.php
├── payment-info.php
├── reply-my-ticket.php
├── reply-ticket.php
├── signup.php
├── survey-detail.php
├── uploads/
│   ├── 68e875094c5cd.png
│   ├── 68e88a7f0c767.png
│   ├── 68e88a92c53b1.png
│   ├── 68e88b5160c95.png
│   ├── 68e88b5c4655f.png
│   ├── 68e88b6790d1b.png
│   ├── 68e88bd4a06c7.png
│   ├── 68e88bdeaf176.png
│   ├── 68e88be9460c0.png
│   ├── 68e88bf2dc063.png
│   └── qr_code_1760063901.jpg
└── verify-email.php

================================================================================
## FILE CONTENTS
================================================================================

### FILE 1: contact.php
- Type: PHP
- Size: 7.34 KB
- Path: .
- Name: contact.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

$error = '';
$success = '';
$ticket_id = null;
$submitted_email = '';

// Check if member is logged in
$is_logged_in = is_member_logged_in();
$member_email = $is_logged_in ? $_SESSION['member_email'] : '';
$member_name = $is_logged_in ? $_SESSION['member_name'] : '';
$member_id = $is_logged_in ? $_SESSION['member_id'] : null;

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $name = clean_input($_POST['name']);
    $email = clean_input($_POST['email']);
    $message = clean_input($_POST['message']);
    $submitted_email = $email;
    
    if (empty($name) || empty($email) || empty($message)) {
        $error = "All fields are required";
    } elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
        $error = "Invalid email address";
    } else {
        // Generate response token for visitors
        $response_token = $member_id ? NULL : md5(uniqid($email, true) . time());
        
        // Insert contact message (ticket)
        $sql = "INSERT INTO contact_messages (name, email, message, member_id, ticket_status, response_token) 
                VALUES ('$name', '$email', '$message', " . ($member_id ? $member_id : "NULL") . ", 'new', " . ($response_token ? "'$response_token'" : "NULL") . ")";
        
        if ($conn->query($sql)) {
            $ticket_id = $conn->insert_id;
            $success = "Your ticket has been submitted successfully! Our support team will respond within 24 hours.";
        } else {
            $error = "Failed to send message. Please try again.";
        }
    }
}

$page_title = 'Contact Us';
include 'includes/header.php';
?>

<div class="container">
    <div class="card" style="max-width: 700px; margin: 0 auto;">
        <h1 class="card-title">Contact Us</h1>
        
        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <?php if ($success): ?>
            <div class="alert alert-success">
                <strong>✅ Ticket Submitted Successfully!</strong><br><br>
                <p style="line-height: 1.8; margin: 1rem 0;">
                    <?php echo $success; ?>
                </p>
                <?php if ($ticket_id): ?>
                    <p style="line-height: 1.8; margin: 1rem 0;">
                        <strong>Your Ticket ID:</strong> #<?php echo $ticket_id; ?>
                    </p>
                <?php endif; ?>
                
                <?php if ($is_logged_in): ?>
                    <!-- Member success message -->
                    <p style="line-height: 1.8; margin: 1rem 0;">
                        You can view your ticket status and response anytime from your <a href="<?php echo SITE_URL; ?>/my-tickets.php" style="color: var(--yellow); font-weight: bold;">My Tickets</a> page.
                    </p>
                <?php else: ?>
                    <!-- Visitor success message -->
                    <div style="background: #fff3cd; padding: 1.5rem; border-radius: 8px; border-left: 5px solid var(--yellow); margin: 1rem 0;">
                        <p style="line-height: 1.8; margin-bottom: 1rem; font-size: 1.05rem;">
                            <strong>📧 Please check your email inbox:</strong>
                        </p>
                        <p style="line-height: 1.8; margin-bottom: 0.5rem;">
                            We will send our response to: <strong><?php echo htmlspecialchars($submitted_email); ?></strong>
                        </p>
                        <p style="line-height: 1.8; margin-bottom: 0.5rem;">
                            You will receive an email notification when our support team replies to your query.
                        </p>
                        <p style="line-height: 1.8; margin: 0;">
                            The email will include a link to respond if you have any follow-up questions.
                        </p>
                    </div>
                    
                    <div class="alert alert-info" style="margin-top: 1rem;">
                        <strong>💡 Tip:</strong> Check your spam/junk folder if you don't see our response within 24 hours.
                    </div>
                <?php endif; ?>
            </div>
            
            <div style="text-align: center; margin-top: 1.5rem;">
                <?php if ($is_logged_in): ?>
                    <a href="<?php echo SITE_URL; ?>/my-tickets.php" class="btn btn-primary">View My Tickets</a>
                    <a href="<?php echo SITE_URL; ?>/dashboard.php" class="btn btn-secondary">Go to Dashboard</a>
                <?php else: ?>
                    <a href="<?php echo SITE_URL; ?>/" class="btn btn-primary">Back to Home</a>
                <?php endif; ?>
            </div>
        <?php else: ?>
            <p style="margin-bottom: 2rem;">
                Have a question or need assistance? Submit your query below and our support team will get back to you within 24 hours.
            </p>
            
            <?php if ($is_logged_in): ?>
                <div class="alert alert-info" style="background: #d4edda; border-color: #c3e6cb;">
                    <strong>✨ Member Support</strong><br>
                    As a member, you can track your ticket status and view responses from your <a href="<?php echo SITE_URL; ?>/my-tickets.php" style="color: var(--navy-blue); font-weight: bold;">My Tickets</a> page.
                </div>
            <?php endif; ?>
            
            <form method="POST" action="">
                <div class="form-group">
                    <label for="name">Your Name *</label>
                    <input type="text" id="name" name="name" required 
                           value="<?php echo $is_logged_in ? htmlspecialchars($member_name) : (isset($_POST['name']) ? htmlspecialchars($_POST['name']) : ''); ?>">
                </div>
                
                <div class="form-group">
                    <label for="email">Email Address *</label>
                    <input type="email" id="email" name="email" required 
                           value="<?php echo $is_logged_in ? htmlspecialchars($member_email) : (isset($_POST['email']) ? htmlspecialchars($_POST['email']) : ''); ?>"
                           <?php echo $is_logged_in ? 'readonly style="background-color: var(--light-grey);"' : ''; ?>>
                    <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">
                        We will respond to this email address
                    </small>
                </div>
                
                <div class="form-group">
                    <label for="message">Your Message *</label>
                    <textarea id="message" name="message" required placeholder="Please describe your query or issue in detail..."><?php echo isset($_POST['message']) ? htmlspecialchars($_POST['message']) : ''; ?></textarea>
                </div>
                
                <button type="submit" class="btn btn-primary" style="width: 100%;">Submit Ticket</button>
            </form>
            
            <?php if ($is_logged_in): ?>
                <p style="text-align: center; margin-top: 1.5rem;">
                    <a href="<?php echo SITE_URL; ?>/my-tickets.php" style="color: var(--yellow); font-weight: bold;">View your previous tickets →</a>
                </p>
            <?php endif; ?>
        <?php endif; ?>
    </div>
</div>

<?php include 'includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 2: create-admin.php
- Type: PHP
- Size: 1.18 KB
- Path: .
- Name: create-admin.php
------------------------------------------------------------
<?php
/**
 * Run this file ONCE to create the default admin user
 * After creating admin, delete this file for security
 */

require_once 'config/config.php';

// Default admin credentials
$username = 'admin';
$password = 'admin123'; // Change this after first login
$email = 'admin@indiasurveyguide.com';

// Hash the password
$hashed_password = password_hash($password, PASSWORD_DEFAULT);

// Check if admin already exists
$check_sql = "SELECT id FROM admins WHERE username = '$username'";
$result = $conn->query($check_sql);

if ($result->num_rows > 0) {
    echo "Admin user already exists!";
} else {
    // Insert admin user
    $sql = "INSERT INTO admins (username, password, email) VALUES ('$username', '$hashed_password', '$email')";
    
    if ($conn->query($sql)) {
        echo "Admin user created successfully!<br>";
        echo "Username: " . $username . "<br>";
        echo "Password: " . $password . "<br><br>";
        echo "Please login at: " . SITE_URL . ADMIN_PATH . "<br><br>";
        echo "<strong>IMPORTANT: Change your password after first login and DELETE this file!</strong>";
    } else {
        echo "Error creating admin user: " . $conn->error;
    }
}

$conn->close();
?>
-------------------- END OF FILE --------------------

### FILE 3: dashboard.php
- Type: PHP
- Size: 6.34 KB
- Path: .
- Name: dashboard.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

// Check if member is logged in
if (!is_member_logged_in()) {
    redirect(SITE_URL . '/login.php');
}

// Get member details
$member_id = $_SESSION['member_id'];
$sql = "SELECT * FROM members WHERE id = $member_id";
$result = $conn->query($sql);
$member = $result->fetch_assoc();

// Check approval and payment status
$is_approved = $member['is_approved'] == 1;
$payment_status = $member['payment_status'] == 1;
$payment_amount = get_setting('payment_amount');

// If approved but payment not done and payment amount > 0, redirect to payment info
if ($is_approved && !$payment_status && $payment_amount > 0) {
    redirect(SITE_URL . '/payment-info.php');
}

$page_title = 'Dashboard';
include 'includes/header.php';
?>

<div class="container">
    <div class="card">
        <h1 class="card-title">Welcome, <?php echo htmlspecialchars($member['full_name']); ?>!</h1>
        
        <?php if (!$is_approved): ?>
            <?php if (!$payment_status && $payment_amount > 0): ?>
                <!-- Waiting for payment verification -->
                <div class="alert alert-info" style="background: #fff3cd; border-color: #ffeaa7;">
                    <strong>⏱️ Payment Verification Pending</strong><br><br>
                    <p style="line-height: 1.8; margin: 0.5rem 0;">
                        Thank you for your interest! We have received your registration. To access all verified survey sites, please:
                    </p>
                    <ol style="margin: 1rem 0 1rem 1.5rem; line-height: 1.8;">
                        <li>Complete the payment of ₹<?php echo number_format($payment_amount, 2); ?></li>
                        <li>Send payment screenshot with UTR/Reference Number to <strong style="color: var(--navy-blue);">signupverification@paidsurveyhub.in</strong></li>
                        <li>Wait for verification (within 24 working hours)</li>
                    </ol>
                    <p style="margin: 1rem 0;">
                        If you have already made the payment and sent the proof, your account will be activated within 24 working hours. Please be patient!
                    </p>
                    <a href="<?php echo SITE_URL; ?>/payment-info.php" class="btn btn-primary" style="margin-top: 1rem; display: inline-block;">
                        View Payment Instructions
                    </a>
                </div>
            <?php else: ?>
                <!-- Account pending approval (free or after payment) -->
                <div class="alert alert-info">
                    <strong>🔄 Account Pending Approval</strong><br><br>
                    <?php if ($payment_amount == 0): ?>
                        <p style="line-height: 1.8;">
                            Your account is currently awaiting admin approval. You will receive access once your account is approved. This usually takes up to 24 working hours.
                        </p>
                    <?php else: ?>
                        <p style="line-height: 1.8;">
                            Thank you for your payment! We are verifying your payment details and will activate your account within 24 working hours (Monday to Saturday, 9 AM to 6 PM IST).
                        </p>
                        <p style="line-height: 1.8; margin-top: 1rem;">
                            You will receive full access to all verified survey sites once your account is approved.
                        </p>
                    <?php endif; ?>
                </div>
            <?php endif; ?>
        <?php elseif (!$payment_status && $payment_amount > 0): ?>
            <!-- Approved but payment not done -->
            <div class="alert alert-info">
                <strong>💳 Payment Required</strong><br><br>
                <p style="line-height: 1.8;">
                    Your account has been approved! Please complete your one-time payment to access all verified survey sites.
                </p>
                <a href="<?php echo SITE_URL; ?>/payment-info.php" class="btn btn-primary" style="margin-top: 1rem; display: inline-block;">
                    View Payment Details
                </a>
            </div>
        <?php else: ?>
            <!-- Member has full access to content -->
            <div class="alert alert-success" style="margin-bottom: 2rem;">
                <strong>✅ Account Active!</strong> You have lifetime access to all verified survey sites.
            </div>
            
            <p style="font-size: 1.1rem; margin-bottom: 2rem;">
                Browse through our collection of verified survey sites and start earning! Click on any survey site below to view details and visit their website.
            </p>
            
            <?php
            // Get all survey sites
            $survey_sql = "SELECT * FROM survey_sites ORDER BY created_at DESC";
            $survey_result = $conn->query($survey_sql);
            
            if ($survey_result->num_rows > 0):
            ?>
                <div class="survey-grid">
                    <?php while ($survey = $survey_result->fetch_assoc()): ?>
                        <a href="<?php echo SITE_URL; ?>/survey-detail.php?id=<?php echo $survey['id']; ?>" style="text-decoration: none; color: inherit;">
                            <div class="survey-card">
                                <img src="<?php echo SITE_URL; ?>/uploads/<?php echo htmlspecialchars($survey['image']); ?>" 
                                     alt="<?php echo htmlspecialchars($survey['title']); ?>" 
                                     class="survey-image"
                                     onerror="this.src='<?php echo SITE_URL; ?>/assets/placeholder.jpg';">
                                <div class="survey-info">
                                    <h3 class="survey-title"><?php echo htmlspecialchars($survey['title']); ?></h3>
                                </div>
                            </div>
                        </a>
                    <?php endwhile; ?>
                </div>
            <?php else: ?>
                <div class="alert alert-info">
                    <strong>📋 No Survey Sites Available</strong><br><br>
                    We are currently adding verified survey sites to the platform. Please check back soon for updates!
                </div>
            <?php endif; ?>
        <?php endif; ?>
    </div>
</div>

<?php include 'includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 4: default.php
- Type: PHP
- Size: 15.99 KB
- Path: .
- Name: default.php
------------------------------------------------------------
<!DOCTYPE html>
<html lang="en">
    <head>
        <title>Default page</title>
        <link rel="icon" type="image/x-icon" href="https://hpanel.hostinger.com/favicons/hostinger.png">
        <meta charset="utf-8">
        <meta content="IE=edge,chrome=1" http-equiv="X-UA-Compatible">
        <meta content="Default page" name="description">
        <meta content="width=device-width, initial-scale=1" name="viewport">
        <link rel="preconnect" href="https://fonts.googleapis.com">
        <link href="https://fonts.googleapis.com/css2?family=DM+Sans&display=swap" rel="stylesheet">
        <link href="https://fonts.googleapis.com/css2?family=DM+Sans:wght@400;700&display=swap" rel="stylesheet">
        <style>
            body {
                margin: 0px;
                display: flex;
                flex-direction: column;
                align-items: center;
                justify-content: center;
                width: 100vw;
                height: 100vh;
                min-height: 675px;
                background-color: #F4F5FF;
            }
            p {
                width: 100%;
                left: 0px;
                font-size: 16px;
                font-family: 'DM Sans', sans-serif;
                font-weight: 400;
                letter-spacing: 0px;
                text-align: center;
                vertical-align: top;
                max-width: 550px;
                color: #727586;
                margin: 0px;
            }
            a:hover {
                cursor: pointer;
                color: #673DE6;
                text-decoration: underline;
            }
            h1 {
                font-family: 'DM Sans', sans-serif;
                font-size: 24px;
                font-weight: 700;
                letter-spacing: 0px;
                text-align: center;
                margin: 8px;
            }
            .content {
                display: flex;
                flex-direction: column;
                align-items: center;
                justify-content: center;
                width: 100%;
                height: 100%;
            }
            .ic-launch  {
                margin-left: 10.5px;
                width: 21px !important;
                height: 20px !important;
            }
            .link-container {
                margin-top: 32px;
                margin-bottom: 32px;
            }
            .link {
                display: flex;
                flex-direction: row;
                align-items: center;
                justify-content: center;
                font-family: 'DM Sans', sans-serif;
                font-style: normal;
                font-weight: 700;
                font-size: 14px;
                color: #673DE6;
                margin-top: 8px;
                text-decoration: none;
            }
            .main-image {
                width: 100%;
                max-width: 650px;
                max-height: 406px;
                height: auto;
            }
            .navigation {
                width: 100%;
                height: 72px;
                display: flex;
                margin: 0;
                padding: 0;
                flex-direction: row;
                align-items: center;
                justify-content: center;
                background-color: #36344D;
            }
            @media screen and (max-width: 580px) and (min-width: 0px) {
                h1, p, .link-container {
                    width: 80%;
                }
            }
            @media screen and (min-width: 650px) and (min-height: 0px) and (max-height: 750px) {
                .link-container {
                    margin-top: 12px;
                }
                h1 {
                    margin-top: 0px;
                    margin-bottom: 0px;
                }
            }
        </style>
    </head>
    <body>
        <nav class="navigation">
            <a href="https://hpanel.hostinger.com" rel="nofollow" target="_blank">
                <svg width="150" height="30" viewBox="0 0 150 30" fill="none" xmlns="http://www.w3.org/2000/svg">
                    <path fill-rule="evenodd" clip-rule="evenodd" d="M116.793 12.1444C117.376 11.4191 118.324 11.0565 119.634 11.0565C120.223 11.0565 120.767 11.1312 121.267 11.2811C121.765 11.4312 122.207 11.6077 122.592 11.8114L123.404 9.56372C123.307 9.50387 123.149 9.41962 122.926 9.31174C122.703 9.2036 122.421 9.09874 122.078 8.99714C121.735 8.89504 121.326 8.80526 120.851 8.72705C120.376 8.64935 119.844 8.60986 119.255 8.60986C118.389 8.60986 117.575 8.75421 116.811 9.04215C116.048 9.32984 115.383 9.75233 114.818 10.3099C114.253 10.8671 113.808 11.5481 113.484 12.3511C113.159 13.1546 112.997 14.0777 112.997 15.1211C112.997 16.1522 113.143 17.0696 113.438 17.8723C113.733 18.6755 114.151 19.3532 114.692 19.9045C115.233 20.4562 115.885 20.8754 116.649 21.1636C117.412 21.4511 118.263 21.5951 119.201 21.5951C120.295 21.5951 121.215 21.5197 121.961 21.3701C122.706 21.2204 123.247 21.0799 123.584 20.9478V14.7794H120.77V19.1133C120.602 19.1495 120.407 19.1734 120.184 19.1852C119.962 19.1971 119.694 19.2031 119.381 19.2031C118.804 19.2031 118.299 19.1043 117.866 18.9066C117.433 18.7087 117.073 18.4298 116.784 18.0699C116.496 17.7101 116.279 17.2816 116.135 16.7844C115.991 16.287 115.919 15.732 115.919 15.1211C115.919 13.8617 116.21 12.8699 116.793 12.1444ZM72.0952 19.1222C71.8367 19.1886 71.5091 19.2213 71.1124 19.2213C70.3189 19.2213 69.6483 19.1403 69.1015 18.9781C68.5539 18.8166 68.0939 18.6341 67.7216 18.4299L66.9277 20.6597C67.0962 20.756 67.3035 20.8576 67.5499 20.9658C67.7965 21.0736 68.0914 21.1755 68.4339 21.2713C68.7766 21.3671 69.1703 21.4478 69.6152 21.5142C70.0601 21.5801 70.5593 21.6133 71.1124 21.6133C72.7596 21.6133 73.9921 21.2924 74.8098 20.6507C75.6275 20.0094 76.0366 19.1071 76.0366 17.944C76.0366 17.345 75.9581 16.8357 75.8022 16.4158C75.6456 15.9961 75.408 15.6302 75.0897 15.3186C74.771 15.007 74.3709 14.7342 73.8902 14.5003C73.409 14.2664 72.8438 14.0298 72.1949 13.7896C71.8819 13.6817 71.5961 13.5771 71.3381 13.475C71.0793 13.3734 70.8508 13.2592 70.6523 13.1335C70.4541 13.0075 70.3005 12.8667 70.1926 12.7108C70.0844 12.5554 70.0299 12.3632 70.0299 12.1351C70.0299 11.7519 70.1774 11.467 70.472 11.2811C70.7666 11.0955 71.2506 11.002 71.9242 11.002C72.5253 11.002 73.0393 11.0714 73.4663 11.2089C73.8928 11.347 74.2807 11.5059 74.6297 11.6857L75.4411 9.47375C75.0443 9.25798 74.5392 9.05982 73.9263 8.88001C73.3129 8.70046 72.5853 8.60992 71.7437 8.60992C71.0339 8.60992 70.3968 8.69744 69.8316 8.87096C69.2664 9.04523 68.7857 9.29344 68.389 9.61734C67.992 9.9415 67.6856 10.3338 67.4689 10.7955C67.2525 11.257 67.1443 11.7755 67.1443 12.3512C67.1443 12.9268 67.2465 13.4152 67.451 13.8165C67.6553 14.2186 67.9201 14.5604 68.2445 14.842C68.5691 15.1239 68.9358 15.3578 69.3446 15.5434C69.7535 15.729 70.1623 15.8942 70.5714 16.0376C71.5091 16.3499 72.1704 16.6404 72.5553 16.9104C72.9399 17.1798 73.1326 17.519 73.1326 17.9264C73.1326 18.1183 73.1026 18.2923 73.0423 18.448C72.982 18.6039 72.8736 18.7387 72.7174 18.8521C72.5613 18.9668 72.3538 19.0565 72.0952 19.1222ZM54.4948 15.121C54.4948 15.7321 54.5697 16.2836 54.72 16.7752C54.8703 17.2671 55.087 17.6896 55.3697 18.0432C55.6517 18.3972 55.9977 18.6696 56.4068 18.8612C56.8154 19.0536 57.2843 19.1497 57.8137 19.1497C58.3304 19.1497 58.7965 19.0536 59.2117 18.8612C59.626 18.6696 59.9751 18.3972 60.2573 18.0432C60.5398 17.6896 60.7567 17.2671 60.907 16.7752C61.0573 16.2836 61.1325 15.7321 61.1325 15.121C61.1325 14.5091 61.0573 13.9546 60.907 13.457C60.7567 12.9595 60.5398 12.5343 60.2573 12.1802C59.9751 11.8266 59.626 11.5535 59.2117 11.3622C58.7965 11.1703 58.3304 11.0745 57.8137 11.0745C57.2843 11.0745 56.8154 11.1733 56.4068 11.371C55.9977 11.5689 55.6517 11.8447 55.3697 12.1986C55.087 12.5522 54.8703 12.9777 54.72 13.4751C54.5697 13.973 54.4948 14.5215 54.4948 15.121ZM64.0369 15.121C64.0369 16.1878 63.8772 17.1263 63.5592 17.935C63.2401 18.7445 62.8041 19.422 62.2512 19.9672C61.6981 20.5132 61.0396 20.9236 60.2762 21.1992C59.5127 21.4753 58.6918 21.6131 57.8143 21.6131C56.9603 21.6131 56.155 21.4753 55.3974 21.1992C54.6397 20.9236 53.9782 20.5132 53.4132 19.9672C52.8478 19.422 52.4034 18.7445 52.0785 17.935C51.7539 17.1263 51.5912 16.1878 51.5912 15.121C51.5912 14.0537 51.7597 13.1155 52.0964 12.3065C52.4329 11.4969 52.8871 10.8164 53.4584 10.265C54.0291 9.71347 54.6907 9.30004 55.4425 9.02417C56.1936 8.74805 56.9845 8.60999 57.8143 8.60999C58.6678 8.60999 59.4734 8.74805 60.2313 9.02417C60.9887 9.30004 61.65 9.71347 62.2152 10.265C62.7801 10.8164 63.2253 11.4969 63.5499 12.3065C63.8747 13.1155 64.0369 14.0537 64.0369 15.121ZM45.1113 8.89825H47.9253V21.3612H45.1113V16.0739H40.3856V21.3612H37.5717V8.89825H40.3856V13.6638H45.1113V8.89825ZM88.4326 8.89838V11.2904H84.6628V21.3613H81.8491V11.2904H78.079V8.89838H88.4326ZM94.3715 21.3616H91.5576V8.89838H94.3715V21.3616ZM106.967 21.3613C106.162 19.9347 105.29 18.5262 104.352 17.135C103.414 15.7441 102.416 14.4314 101.358 13.1964V21.3613H98.58V8.89838H100.871C101.267 9.2937 101.706 9.7793 102.187 10.3549C102.668 10.9306 103.158 11.5452 103.657 12.1985C104.156 12.8519 104.652 13.5293 105.145 14.2305C105.638 14.9318 106.101 15.606 106.534 16.2536V8.89838H109.33V21.3613H106.967ZM127.521 21.3613V8.89838H135.963V11.2542H130.335V13.6998H135.331V16.0021H130.335V19.0055H136.378V21.3613H127.521ZM143.046 11.1641C143.209 11.1523 143.391 11.1463 143.596 11.1463C144.498 11.1463 145.18 11.2753 145.643 11.5325C146.106 11.7911 146.337 12.2251 146.337 12.8367C146.337 13.4724 146.109 13.9223 145.652 14.1856C145.195 14.4497 144.437 14.5809 143.38 14.5809H142.586V11.2001C142.731 11.1885 142.884 11.1764 143.046 11.1641ZM147.745 9.75233C146.747 9.08666 145.311 8.75421 143.435 8.75421C142.917 8.75421 142.331 8.7781 141.676 8.82639C141.021 8.87391 140.387 8.95841 139.773 9.07761V21.3613H142.587V16.8108H143.976C144.217 17.099 144.458 17.4196 144.7 17.7737C144.941 18.1273 145.187 18.5015 145.433 18.8973C145.681 19.2931 145.922 19.701 146.158 20.1205C146.392 20.5402 146.625 20.9536 146.854 21.3613H150C149.784 20.9059 149.549 20.4414 149.297 19.9673C149.044 19.4941 148.783 19.0386 148.512 18.6011C148.242 18.1635 147.968 17.7438 147.691 17.3419C147.415 16.9403 147.151 16.5837 146.898 16.2716C147.655 15.9603 148.236 15.5313 148.638 14.9861C149.041 14.4406 149.243 13.7297 149.243 12.8548C149.243 11.4518 148.743 10.4177 147.745 9.75233Z" fill="white"/>
                    <path fill-rule="evenodd" clip-rule="evenodd" d="M0.000188531 14.046V0.000497794L7.0891 3.78046V10.1086L16.4734 10.1132L23.6773 14.046H0.000188531ZM18.3924 8.95058V0L25.6725 3.6859V13.1797L18.3924 8.95058ZM18.3924 26.1177V19.8441L8.93571 19.8375C8.94454 19.8793 1.61224 15.8418 1.61224 15.8418L25.6725 15.9547V30L18.3924 26.1177ZM-6.10352e-05 26.1177L0.000191176 16.9393L7.0891 21.0683V29.8033L-6.10352e-05 26.1177Z" fill="white"/>
                </svg>
            </a>
        </nav>
        <div class="content">
            <svg 
                class="main-image"
                width="650" 
                height="406" 
                viewBox="0 0 650 406" 
                fill="none"
                xmlns="http://www.w3.org/2000/svg"
                xmlns:xlink="http://www.w3.org/1999/xlink">
                <path d="M603.171 195.67L445.106 347.201V44.1392L603.171 195.67Z" stroke="#C4CCE8" stroke-miterlimit="10"/>
                <path d="M445.106 195.67L287.041 347.201V44.1392L445.106 195.67Z" stroke="#C4CCE8" stroke-miterlimit="10"/>
                <path d="M603.171 195.67H180.043" stroke="#C4CCE8" stroke-miterlimit="10"/>
                <path d="M57.0145 43H593.668C596.51 43 599.237 44.0612 601.247 45.9501C603.257 47.8391 604.387 50.401 604.387 53.0724V348.34H57.0145C54.1716 348.34 51.4452 347.279 49.435 345.39C47.4248 343.501 46.2954 340.939 46.2954 338.268V53.1252C46.288 51.798 46.5598 50.4826 47.0952 49.2544C47.6306 48.0263 48.4189 46.9097 49.415 45.9688C50.4111 45.0279 51.5953 44.2812 52.8994 43.7717C54.2036 43.2623 55.6021 43 57.0145 43V43Z" stroke="#C5CDE9" stroke-miterlimit="10"/>
                <path d="M65.1415 64.6472C67.4918 64.6472 69.3971 62.8618 69.3971 60.6595C69.3971 58.4572 67.4918 56.6719 65.1415 56.6719C62.7912 56.6719 60.8859 58.4572 60.8859 60.6595C60.8859 62.8618 62.7912 64.6472 65.1415 64.6472Z" stroke="#C5CDE9" stroke-miterlimit="10"/>
                <path d="M82.7718 65.7865C85.4579 65.7865 87.6354 63.7461 87.6354 61.2292C87.6354 58.7123 85.4579 56.6719 82.7718 56.6719C80.0858 56.6719 77.9083 58.7123 77.9083 61.2292C77.9083 63.7461 80.0858 65.7865 82.7718 65.7865Z" stroke="#C5CDE9" stroke-miterlimit="10"/>
                <path d="M100.402 65.7866C102.752 65.7866 104.658 64.0013 104.658 61.7989C104.658 59.5966 102.752 57.8113 100.402 57.8113C98.0519 57.8113 96.1466 59.5966 96.1466 61.7989C96.1466 64.0013 98.0519 65.7866 100.402 65.7866Z" stroke="#C5CDE9" stroke-miterlimit="10"/>
                <path d="M52.3747 171.744H39V184.277H52.3747V171.744Z" fill="#673CE5"/>
                <path d="M611.682 88.573H598.307V102.245H611.682V88.573Z" fill="#673CE5"/>
                <path d="M384.311 173.864C397.176 197.034 424.878 208.367 449.522 201.798C470.052 196.291 485.552 179.079 488.877 158.072" stroke="#673DE6" stroke-width="18" stroke-miterlimit="10"/>
                <path d="M569.199 264.276L517.516 232.922L484.055 281.351L535.738 312.705L569.199 264.276Z" fill="#673DE6"/>
                <rect x="76" y="55" width="325" height="308" fill="url(#pattern0)"/>
                <defs>
                <pattern id="pattern0" patternContentUnits="objectBoundingBox" width="1" height="1">
                <use xlink:href="#image0_793_7454" transform="translate(0 -0.0294456) scale(0.000431034 0.000453478)"/>
                </pattern>
                    <image 
                        id="image0_793_7454" 
                        width="2320"
                        height="2296"
                        href="https://assets.hostinger.com/content/hostinger_welcome/v2/man1.png"
                    />
                </defs>
            </svg>
            <h1>You Are All Set to Go!</h1>
            <p>All you have to do now is upload your website files and start your journey. Check out how to do that below:</p>
            <div class="link-container">
                <a 
                    class=link
                    href="https://support.hostinger.com/en/articles/4455931-how-can-i-migrate-website-to-hostinger"
                    rel="nofollow"
                    target="_blank"
                >
                    How can I migrate a website to Hostinger? 
                    <svg class="ic-launch" viewBox="0 0 21 20" fill="none" xmlns="http://www.w3.org/2000/svg">
                        <path 
                            fill-rule="evenodd" 
                            clip-rule="evenodd" 
                            d="M16.3333 15.8333H4.66667V4.16667H10.5V2.5H4.66667C3.74167 2.5 3 3.25 3 4.16667V15.8333C3 16.75 3.74167 17.5 4.66667 17.5H16.3333C17.25 17.5 18 16.75 18 15.8333V10H16.3333V15.8333ZM12.1667 2.5V4.16667H15.1583L6.96667 12.3583L8.14167 13.5333L16.3333 5.34167V8.33333H18V2.5H12.1667Z" 
                            fill="#673DE6"
                        />
                    </svg>
                </a>
                <a 
                    class="link"
                    href="https://support.hostinger.com/en/articles/3220304-how-to-install-wordpress-using-auto-installer"
                    rel="nofollow"
                    target="_blank"
                >
                    How to install WordPress using Auto Installer?
                    <svg class="ic-launch" viewBox="0 0 21 20" fill="none" xmlns="http://www.w3.org/2000/svg">
                        <path 
                            fill-rule="evenodd" 
                            clip-rule="evenodd" 
                            d="M16.3333 15.8333H4.66667V4.16667H10.5V2.5H4.66667C3.74167 2.5 3 3.25 3 4.16667V15.8333C3 16.75 3.74167 17.5 4.66667 17.5H16.3333C17.25 17.5 18 16.75 18 15.8333V10H16.3333V15.8333ZM12.1667 2.5V4.16667H15.1583L6.96667 12.3583L8.14167 13.5333L16.3333 5.34167V8.33333H18V2.5H12.1667Z" 
                            fill="#673DE6"
                        />
                    </svg>
                </a>
            </div>
            
        </div>
    </body>
</html>
-------------------- END OF FILE --------------------

### FILE 5: index.php
- Type: PHP
- Size: 3.38 KB
- Path: .
- Name: index.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

// If already logged in, redirect to dashboard
if (is_member_logged_in()) {
    redirect(SITE_URL . '/dashboard.php');
}

$page_title = 'Home';
include 'includes/header.php';
?>

<div class="container">
    <div class="card">
        <h1 class="card-title">Welcome to Paid Survey Hub India</h1>
        <p style="font-size: 1.1rem; line-height: 1.8; color: #333;">
            Discover genuine and reliable paid online survey opportunities in India. Our platform connects you with legitimate survey companies that actually pay for your valuable opinions.
        </p>
        
        <div style="margin-top: 2rem;">
            <h2 style="color: var(--navy-blue); margin-bottom: 1rem;">Why Choose Us?</h2>
            <ul style="list-style: none; padding: 0;">
                <li style="padding: 0.5rem 0; font-size: 1.05rem;">✓ Verified and genuine survey sites only</li>
                <li style="padding: 0.5rem 0; font-size: 1.05rem;">✓ Direct links to survey companies</li>
                <li style="padding: 0.5rem 0; font-size: 1.05rem;">✓ Support contact for each site</li>
                <li style="padding: 0.5rem 0; font-size: 1.05rem;">✓ One-time access fee</li>
                <li style="padding: 0.5rem 0; font-size: 1.05rem;">✓ Lifetime access to all survey sites</li>
            </ul>
        </div>
        
        <div style="margin-top: 2rem; text-align: center;">
            <a href="<?php echo SITE_URL; ?>/signup.php" class="btn btn-primary" style="margin: 0.5rem;">Get Started Now</a>
            <a href="<?php echo SITE_URL; ?>/login.php" class="btn btn-secondary" style="margin: 0.5rem;">Already a Member? Login</a>
        </div>
    </div>
    
    <div class="card">
        <h2 class="card-title">How It Works</h2>
        <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(250px, 1fr)); gap: 2rem; margin-top: 1.5rem;">
            <div style="text-align: center;">
                <div style="background: var(--yellow); width: 60px; height: 60px; border-radius: 50%; display: flex; align-items: center; justify-content: center; margin: 0 auto 1rem; font-size: 1.5rem; font-weight: bold; color: var(--navy-blue);">1</div>
                <h3 style="color: var(--navy-blue); margin-bottom: 0.5rem;">Sign Up</h3>
                <p>Create your free account with basic information</p>
            </div>
            <div style="text-align: center;">
                <div style="background: var(--yellow); width: 60px; height: 60px; border-radius: 50%; display: flex; align-items: center; justify-content: center; margin: 0 auto 1rem; font-size: 1.5rem; font-weight: bold; color: var(--navy-blue);">2</div>
                <h3 style="color: var(--navy-blue); margin-bottom: 0.5rem;">Get Approved</h3>
                <p>Wait for admin approval and complete payment</p>
            </div>
            <div style="text-align: center;">
                <div style="background: var(--yellow); width: 60px; height: 60px; border-radius: 50%; display: flex; align-items: center; justify-content: center; margin: 0 auto 1rem; font-size: 1.5rem; font-weight: bold; color: var(--navy-blue);">3</div>
                <h3 style="color: var(--navy-blue); margin-bottom: 0.5rem;">Start Earning</h3>
                <p>Access all verified survey sites and start earning</p>
            </div>
        </div>
    </div>
</div>

<?php include 'includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 6: login.php
- Type: PHP
- Size: 2.64 KB
- Path: .
- Name: login.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

// If already logged in, redirect to dashboard
if (is_member_logged_in()) {
    redirect(SITE_URL . '/dashboard.php');
}

$error = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $email = clean_input($_POST['email']);
    $password = $_POST['password'];
    
    if (empty($email) || empty($password)) {
        $error = "Please enter both email and password";
    } else {
        // Check member credentials
        $sql = "SELECT * FROM members WHERE email = '$email'";
        $result = $conn->query($sql);
        
        if ($result->num_rows > 0) {
            $member = $result->fetch_assoc();
            
            if (password_verify($password, $member['password'])) {
                if ($member['is_verified'] == 0) {
                    $error = "Please verify your email first. Check your inbox for the verification link.";
                } else {
                    // Set session
                    $_SESSION['member_id'] = $member['id'];
                    $_SESSION['member_name'] = $member['full_name'];
                    $_SESSION['member_email'] = $member['email'];
                    
                    redirect(SITE_URL . '/dashboard.php');
                }
            } else {
                $error = "Invalid email or password";
            }
        } else {
            $error = "Invalid email or password";
        }
    }
}

$page_title = 'Login';
include 'includes/header.php';
?>

<div class="container">
    <div class="card" style="max-width: 500px; margin: 0 auto;">
        <h1 class="card-title">Member Login</h1>
        
        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <form method="POST" action="">
            <div class="form-group">
                <label for="email">Email Address</label>
                <input type="email" id="email" name="email" required 
                       value="<?php echo isset($_POST['email']) ? htmlspecialchars($_POST['email']) : ''; ?>">
            </div>
            
            <div class="form-group">
                <label for="password">Password</label>
                <input type="password" id="password" name="password" required>
            </div>
            
            <button type="submit" class="btn btn-primary" style="width: 100%;">Login</button>
        </form>
        
        <p style="text-align: center; margin-top: 1.5rem;">
            Don't have an account? <a href="<?php echo SITE_URL; ?>/signup.php" style="color: var(--yellow); font-weight: bold;">Sign up here</a>
        </p>
    </div>
</div>

<?php include 'includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 7: logout.php
- Type: PHP
- Size: 186 B
- Path: .
- Name: logout.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

// Clear all session variables
session_unset();

// Destroy the session
session_destroy();

// Redirect to home page
redirect(SITE_URL . '/');
?>
-------------------- END OF FILE --------------------

### FILE 8: my-tickets.php
- Type: PHP
- Size: 7.62 KB
- Path: .
- Name: my-tickets.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

// Check if member is logged in
if (!is_member_logged_in()) {
    redirect(SITE_URL . '/login.php');
}

$member_id = $_SESSION['member_id'];

// Get member's tickets
$sql = "SELECT * FROM contact_messages 
        WHERE member_id = $member_id 
        ORDER BY created_at DESC";
$result = $conn->query($sql);

$page_title = 'My Tickets';
include 'includes/header.php';
?>

<div class="container">
    <div class="card">
        <h1 class="card-title">My Support Tickets</h1>
        
        <p style="margin-bottom: 2rem;">
            View all your support requests and responses from our team. Click "Respond" to continue the conversation.
        </p>
        
        <?php if ($result->num_rows > 0): ?>
            <div style="display: grid; gap: 1.5rem;">
                <?php while ($ticket = $result->fetch_assoc()): ?>
                    <div style="background: var(--white); border: 2px solid var(--light-grey); border-radius: 8px; padding: 1.5rem; <?php echo $ticket['ticket_status'] === 'new' ? 'border-left: 5px solid #ffc107;' : ($ticket['admin_reply'] ? 'border-left: 5px solid #28a745;' : ''); ?>">
                        <div style="display: flex; justify-content: space-between; align-items: start; flex-wrap: wrap; margin-bottom: 1rem;">
                            <div>
                                <h3 style="color: var(--navy-blue); margin-bottom: 0.5rem;">Ticket #<?php echo $ticket['id']; ?></h3>
                                <p style="color: var(--dark-grey); font-size: 0.9rem;">
                                    Submitted: <?php echo date('F j, Y \a\t g:i A', strtotime($ticket['created_at'])); ?>
                                </p>
                            </div>
                            <?php
                            $status_colors = [
                                'new' => 'background: #ffc107; color: #000;',
                                'in_progress' => 'background: #17a2b8; color: #fff;',
                                'resolved' => 'background: #28a745; color: #fff;',
                                'closed' => 'background: #6c757d; color: #fff;'
                            ];
                            $status_text = ucfirst(str_replace('_', ' ', $ticket['ticket_status']));
                            ?>
                            <span style="display: inline-block; padding: 0.35rem 0.85rem; border-radius: 4px; font-size: 0.9rem; font-weight: bold; <?php echo $status_colors[$ticket['ticket_status']]; ?>">
                                <?php echo $status_text; ?>
                            </span>
                        </div>
                        
                        <div style="background: var(--light-grey); padding: 1rem; border-radius: 5px; margin-bottom: 1rem;">
                            <p style="font-weight: bold; color: var(--navy-blue); margin-bottom: 0.5rem;">Your Message:</p>
                            <p style="line-height: 1.6; white-space: pre-wrap;"><?php 
                                // Show only original message without responses
                                $original_message = $ticket['message'];
                                if (strpos($original_message, '--- User Response ---') !== false) {
                                    $parts = explode('--- User Response ---', $original_message);
                                    echo htmlspecialchars(trim($parts[0]));
                                } else {
                                    echo htmlspecialchars($original_message);
                                }
                            ?></p>
                        </div>
                        
                        <?php if ($ticket['admin_reply']): ?>
                            <div style="background: #d4edda; padding: 1rem; border-radius: 5px; border-left: 4px solid #28a745; margin-bottom: 1rem;">
                                <p style="font-weight: bold; color: #155724; margin-bottom: 0.5rem;">
                                    Support Team Response:
                                    <?php if ($ticket['replied_at']): ?>
                                        <small style="font-weight: normal; font-size: 0.85rem;">
                                            (<?php echo date('M j, Y \a\t g:i A', strtotime($ticket['replied_at'])); ?>)
                                        </small>
                                    <?php endif; ?>
                                </p>
                                <p style="line-height: 1.6; color: #155724; white-space: pre-wrap;"><?php echo nl2br(htmlspecialchars($ticket['admin_reply'])); ?></p>
                            </div>
                        <?php else: ?>
                            <div style="background: #fff3cd; padding: 1rem; border-radius: 5px; margin-bottom: 1rem;">
                                <p style="margin: 0; color: #856404;">
                                    ⏱️ <strong>Waiting for response...</strong> Our support team will reply within 24 hours.
                                </p>
                            </div>
                        <?php endif; ?>
                        
                        <?php
                        // Show follow-up messages if any
                        if (strpos($ticket['message'], '--- User Response ---') !== false) {
                            $parts = explode('--- User Response ---', $ticket['message']);
                            array_shift($parts); // Remove original message
                            
                            if (!empty($parts)) {
                                foreach ($parts as $index => $response) {
                                    $response = trim($response);
                                    if (!empty($response)) {
                                        echo '<div style="background: #e7f3ff; padding: 1rem; border-radius: 5px; border-left: 4px solid #007bff; margin-bottom: 1rem;">
                                            <p style="font-weight: bold; color: #004085; margin-bottom: 0.5rem;">Your Follow-up #' . ($index + 1) . ':</p>
                                            <p style="line-height: 1.6; color: #004085; white-space: pre-wrap;">' . nl2br(htmlspecialchars($response)) . '</p>
                                        </div>';
                                    }
                                }
                            }
                        }
                        ?>
                        
                        <div style="text-align: right; margin-top: 1rem;">
                            <?php if ($ticket['admin_reply'] && $ticket['ticket_status'] !== 'closed'): ?>
                                <a href="<?php echo SITE_URL; ?>/reply-my-ticket.php?id=<?php echo $ticket['id']; ?>" 
                                   class="btn btn-primary">
                                    💬 Respond to Ticket
                                </a>
                            <?php endif; ?>
                        </div>
                    </div>
                <?php endwhile; ?>
            </div>
        <?php else: ?>
            <div class="alert alert-info">
                <strong>No tickets yet</strong><br>
                You haven't submitted any support requests yet. If you have any questions or need assistance, feel free to use the contact form.
            </div>
        <?php endif; ?>
        
        <div style="text-align: center; margin-top: 2rem;">
            <a href="<?php echo SITE_URL; ?>/contact.php" class="btn btn-primary">Submit New Ticket</a>
            <a href="<?php echo SITE_URL; ?>/dashboard.php" class="btn btn-secondary">Back to Dashboard</a>
        </div>
    </div>
</div>

<?php include 'includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 9: payment-info.php
- Type: PHP
- Size: 6.67 KB
- Path: .
- Name: payment-info.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

// Check if member is logged in
if (!is_member_logged_in()) {
    redirect(SITE_URL . '/login.php');
}

// Get member details
$member_id = $_SESSION['member_id'];
$sql = "SELECT * FROM members WHERE id = $member_id";
$result = $conn->query($sql);
$member = $result->fetch_assoc();

// If already paid, redirect to dashboard
if ($member['payment_status'] == 1) {
    redirect(SITE_URL . '/dashboard.php');
}

// Get payment settings
$payment_amount = get_setting('payment_amount');
$upi_id = get_setting('upi_id');
$qr_code_path = get_setting('qr_code_path');

// If payment amount is 0, auto-approve and redirect
if ($payment_amount == 0) {
    $update_sql = "UPDATE members SET payment_status = 1 WHERE id = $member_id";
    $conn->query($update_sql);
    redirect(SITE_URL . '/dashboard.php');
}

$page_title = 'Payment Information';
include 'includes/header.php';
?>

<div class="container">
    <div class="card" style="max-width: 800px; margin: 0 auto;">
        <h1 class="card-title">Complete Your Payment</h1>
        
        <div class="alert alert-info" style="background-color: #fff3cd; border-color: #ffeaa7;">
            <strong style="font-size: 1.1rem;">📋 Payment Instructions</strong>
        </div>
        
        <div class="payment-box">
            <p style="font-size: 1.2rem; margin-bottom: 1rem;">One-time Access Fee</p>
            <div class="payment-amount">₹<?php echo number_format($payment_amount, 2); ?></div>
            
            <?php if (!empty($upi_id)): ?>
                <div style="margin: 2rem 0;">
                    <p style="font-weight: bold; margin-bottom: 0.5rem;">UPI ID:</p>
                    <p style="font-size: 1.2rem; color: var(--navy-blue); font-weight: bold; word-break: break-all;"><?php echo htmlspecialchars($upi_id); ?></p>
                </div>
            <?php endif; ?>
            
            <?php if (!empty($qr_code_path)): ?>
                <div>
                    <p style="font-weight: bold; margin-bottom: 1rem;">Scan QR Code to Pay:</p>
                    <img src="<?php echo SITE_URL . '/' . htmlspecialchars($qr_code_path); ?>" 
                         alt="Payment QR Code" 
                         class="qr-code">
                </div>
            <?php endif; ?>
        </div>
        
        <div style="background-color: var(--light-grey); padding: 2rem; border-radius: 8px; margin: 2rem 0; border-left: 5px solid var(--yellow);">
            <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">📌 How to Complete Payment & Activation</h3>
            
            <div style="margin: 1.5rem 0;">
                <p style="font-weight: bold; color: var(--navy-blue); margin-bottom: 0.5rem;">Step 1: Make Payment</p>
                <p style="margin-bottom: 1rem; line-height: 1.6;">
                    Pay ₹<?php echo number_format($payment_amount, 2); ?> using the UPI ID or QR code shown above. Make sure to complete the payment successfully.
                </p>
            </div>
            
            <div style="margin: 1.5rem 0;">
                <p style="font-weight: bold; color: var(--navy-blue); margin-bottom: 0.5rem;">Step 2: Take Screenshot</p>
                <p style="margin-bottom: 1rem; line-height: 1.6;">
                    After successful payment, take a clear screenshot of the payment confirmation showing:
                </p>
                <ul style="margin-left: 1.5rem; line-height: 1.8;">
                    <li>Payment amount (₹<?php echo number_format($payment_amount, 2); ?>)</li>
                    <li>Transaction date and time</li>
                    <li><strong>UTR/Reference Number</strong> (Very Important!)</li>
                    <li>Payment status as "Success"</li>
                </ul>
            </div>
            
            <div style="margin: 1.5rem 0;">
                <p style="font-weight: bold; color: var(--navy-blue); margin-bottom: 0.5rem;">Step 3: Send Payment Proof</p>
                <p style="margin-bottom: 0.5rem; line-height: 1.6;">
                    Email your payment screenshot to:
                </p>
                <p style="font-size: 1.2rem; font-weight: bold; color: var(--navy-blue); background: var(--yellow); padding: 1rem; border-radius: 5px; text-align: center; margin: 1rem 0;">
                    signupverification@paidsurveyhub.in
                </p>
                <p style="line-height: 1.6; margin-top: 1rem;">
                    <strong>Email Subject:</strong> Payment Verification - <?php echo htmlspecialchars($member['email']); ?>
                </p>
                <p style="line-height: 1.6; margin-top: 0.5rem;">
                    <strong>Email Body:</strong> Include your registered email (<?php echo htmlspecialchars($member['email']); ?>) and UTR/Reference Number
                </p>
            </div>
            
            <div style="margin: 1.5rem 0; background: var(--white); padding: 1rem; border-radius: 5px; border: 2px solid var(--yellow);">
                <p style="font-weight: bold; color: var(--navy-blue); margin-bottom: 0.5rem;">⏱️ Verification Time</p>
                <p style="line-height: 1.6;">
                    Your payment will be verified and account will be activated within <strong>24 working hours</strong> (Monday to Saturday, 9 AM to 6 PM IST, excluding Sundays and public holidays).
                </p>
            </div>
            
            <div style="margin: 1.5rem 0;">
                <p style="font-weight: bold; color: var(--navy-blue); margin-bottom: 0.5rem;">✅ After Activation</p>
                <p style="line-height: 1.6;">
                    Once verified, you will receive lifetime access to all verified survey sites. You can then login anytime to access the complete list of genuine paid survey opportunities.
                </p>
            </div>
        </div>
        
        <div class="alert alert-error" style="background-color: #f8d7da; border-color: #f5c6cb;">
            <strong>⚠️ Important Notes:</strong><br>
            • Double-check the UPI ID before making payment<br>
            • Keep the UTR/Reference Number safe<br>
            • Send payment proof from the same email you registered with<br>
            • Do not share your login credentials with anyone<br>
            • Contact us if payment is done but not verified after 24 hours
        </div>
        
        <div style="text-align: center; margin-top: 2rem;">
            <a href="<?php echo SITE_URL; ?>/dashboard.php" class="btn btn-secondary" style="margin-right: 1rem;">Back to Dashboard</a>
            <a href="<?php echo SITE_URL; ?>/contact.php" class="btn btn-secondary">Need Help? Contact Support</a>
        </div>
    </div>
</div>

<?php include 'includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 10: reply-my-ticket.php
- Type: PHP
- Size: 9.2 KB
- Path: .
- Name: reply-my-ticket.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

// Check if member is logged in
if (!is_member_logged_in()) {
    redirect(SITE_URL . '/login.php');
}

if (!isset($_GET['id'])) {
    redirect(SITE_URL . '/my-tickets.php');
}

$ticket_id = (int)$_GET['id'];
$member_id = $_SESSION['member_id'];
$error = '';
$success = '';

// Get ticket details - verify it belongs to this member
$sql = "SELECT * FROM contact_messages WHERE id = $ticket_id AND member_id = $member_id";
$result = $conn->query($sql);

if ($result->num_rows == 0) {
    redirect(SITE_URL . '/my-tickets.php');
}

$ticket = $result->fetch_assoc();

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $user_reply = clean_input($_POST['user_reply']);
    
    if (empty($user_reply)) {
        $error = "Please enter your response";
    } else {
        // Append user reply to the message
        $updated_message = $ticket['message'] . "\n\n--- User Response ---\n" . $user_reply;
        $updated_message = clean_input($updated_message);
        
        // Update ticket with user's response and change status to new
        $update_sql = "UPDATE contact_messages SET 
                      message = '$updated_message',
                      ticket_status = 'new'
                      WHERE id = $ticket_id";
        
        if ($conn->query($update_sql)) {
            $success = "Your response has been submitted successfully! Our support team will review and respond to your follow-up question.";
            
            // Refresh ticket data
            $result = $conn->query($sql);
            $ticket = $result->fetch_assoc();
        } else {
            $error = "Failed to submit response. Please try again.";
        }
    }
}

$page_title = 'Respond to Ticket';
include 'includes/header.php';
?>

<div class="container">
    <div class="card" style="max-width: 800px; margin: 0 auto;">
        <a href="<?php echo SITE_URL; ?>/my-tickets.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to My Tickets
        </a>
        
        <div style="display: flex; justify-content: space-between; align-items: center; flex-wrap: wrap; margin-bottom: 1.5rem;">
            <h1 class="card-title" style="margin: 0;">Respond to Ticket #<?php echo $ticket['id']; ?></h1>
            <?php
            $status_colors = [
                'new' => 'background: #ffc107; color: #000;',
                'in_progress' => 'background: #17a2b8; color: #fff;',
                'resolved' => 'background: #28a745; color: #fff;',
                'closed' => 'background: #6c757d; color: #fff;'
            ];
            $status_text = ucfirst(str_replace('_', ' ', $ticket['ticket_status']));
            ?>
            <span style="display: inline-block; padding: 0.5rem 1rem; border-radius: 5px; font-size: 1rem; font-weight: bold; <?php echo $status_colors[$ticket['ticket_status']]; ?>">
                <?php echo $status_text; ?>
            </span>
        </div>
        
        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <?php if ($success): ?>
            <div class="alert alert-success">
                <?php echo $success; ?>
            </div>
            
            <div style="background: #fff3cd; padding: 1.5rem; border-radius: 8px; margin: 2rem 0;">
                <p style="line-height: 1.8; margin-bottom: 1rem;">
                    <strong>📧 What happens next:</strong>
                </p>
                <ul style="line-height: 1.8; margin-left: 1.5rem;">
                    <li>Our support team will review your follow-up question</li>
                    <li>We will respond within 24 hours</li>
                    <li>You'll receive an email notification when we reply</li>
                    <li>You can view the response in your "My Tickets" section</li>
                </ul>
            </div>
            
            <div style="text-align: center; margin-top: 2rem;">
                <a href="<?php echo SITE_URL; ?>/my-tickets.php" class="btn btn-primary">View My Tickets</a>
                <a href="<?php echo SITE_URL; ?>/dashboard.php" class="btn btn-secondary">Go to Dashboard</a>
            </div>
        <?php else: ?>
            <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 2rem;">
                <p style="margin-bottom: 0.5rem;"><strong>Ticket Created:</strong></p>
                <p><?php echo date('F j, Y \a\t g:i A', strtotime($ticket['created_at'])); ?></p>
            </div>
            
            <?php if ($ticket['admin_reply']): ?>
                <div style="background: #d4edda; padding: 1.5rem; border-left: 5px solid #28a745; border-radius: 8px; margin-bottom: 2rem;">
                    <h3 style="color: #155724; margin-bottom: 1rem;">Support Team Response:</h3>
                    <p style="line-height: 1.8; color: #155724; white-space: pre-wrap;"><?php echo nl2br(htmlspecialchars($ticket['admin_reply'])); ?></p>
                    <?php if ($ticket['replied_at']): ?>
                        <p style="margin-top: 1rem; font-size: 0.85rem; color: #155724;">
                            <em>Replied on: <?php echo date('F j, Y \a\t g:i A', strtotime($ticket['replied_at'])); ?></em>
                        </p>
                    <?php endif; ?>
                </div>
            <?php endif; ?>
            
            <div style="background: var(--white); padding: 1.5rem; border: 2px solid var(--light-grey); border-radius: 8px; margin-bottom: 2rem;">
                <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">Your Original Message:</h3>
                <p style="line-height: 1.8; white-space: pre-wrap; color: #555;"><?php 
                    // Show only original message
                    $original_message = $ticket['message'];
                    if (strpos($original_message, '--- User Response ---') !== false) {
                        $parts = explode('--- User Response ---', $original_message);
                        echo htmlspecialchars(trim($parts[0]));
                    } else {
                        echo htmlspecialchars($original_message);
                    }
                ?></p>
            </div>
            
            <?php
            // Show previous follow-ups if any
            if (strpos($ticket['message'], '--- User Response ---') !== false) {
                $parts = explode('--- User Response ---', $ticket['message']);
                array_shift($parts); // Remove original message
                
                if (!empty($parts)) {
                    echo '<div style="margin-bottom: 2rem;">';
                    echo '<h3 style="color: var(--navy-blue); margin-bottom: 1rem;">Previous Follow-ups:</h3>';
                    
                    foreach ($parts as $index => $response) {
                        $response = trim($response);
                        if (!empty($response)) {
                            echo '<div style="background: #e7f3ff; padding: 1rem; border-left: 4px solid #007bff; border-radius: 5px; margin-bottom: 1rem;">
                                <p style="font-weight: bold; color: #004085; margin-bottom: 0.5rem;">Follow-up #' . ($index + 1) . ':</p>
                                <p style="line-height: 1.6; color: #004085; white-space: pre-wrap;">' . nl2br(htmlspecialchars($response)) . '</p>
                            </div>';
                        }
                    }
                    echo '</div>';
                }
            }
            ?>
            
            <div style="background: var(--light-grey); padding: 2rem; border-radius: 8px;">
                <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">💬 Add Your Follow-up</h3>
                <p style="margin-bottom: 1.5rem; line-height: 1.6;">
                    Have additional questions or need clarification? Type your follow-up message below and our support team will respond.
                </p>
                
                <form method="POST" action="">
                    <div class="form-group">
                        <label for="user_reply">Your Follow-up Message *</label>
                        <textarea id="user_reply" name="user_reply" required style="min-height: 150px;" placeholder="Type your follow-up question or additional details here..."><?php echo isset($_POST['user_reply']) ? htmlspecialchars($_POST['user_reply']) : ''; ?></textarea>
                        <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">
                            We will review your follow-up and respond to your email within 24 hours.
                        </small>
                    </div>
                    
                    <button type="submit" class="btn btn-primary" style="width: 100%;">Submit Follow-up</button>
                </form>
            </div>
            
            <div class="alert alert-info" style="margin-top: 2rem;">
                <strong>📌 Note:</strong> After submitting your follow-up, our support team will review and respond within 24 hours. You will receive an email notification and can view the response in your "My Tickets" section.
            </div>
        <?php endif; ?>
    </div>
</div>

<?php include 'includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 11: reply-ticket.php
- Type: PHP
- Size: 9.29 KB
- Path: .
- Name: reply-ticket.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

$error = '';
$success = '';
$ticket = null;

// Check if token and ID are provided
if (!isset($_GET['token']) || !isset($_GET['id'])) {
    $error = "Invalid ticket link. Please use the link provided in your email.";
} else {
    $token = clean_input($_GET['token']);
    $ticket_id = (int)$_GET['id'];
    
    // Verify token and get ticket
    $sql = "SELECT * FROM contact_messages 
            WHERE id = $ticket_id 
            AND response_token = '$token' 
            AND member_id IS NULL";
    $result = $conn->query($sql);
    
    if ($result->num_rows == 0) {
        $error = "Invalid or expired ticket link. Please contact support if you need assistance.";
    } else {
        $ticket = $result->fetch_assoc();
        
        // Handle form submission
        if ($_SERVER['REQUEST_METHOD'] === 'POST') {
            $user_reply = clean_input($_POST['user_reply']);
            
            if (empty($user_reply)) {
                $error = "Please enter your response";
            } else {
                // Append user reply to the message
                $updated_message = $ticket['message'] . "\n\n--- User Response ---\n" . $user_reply;
                $updated_message = clean_input($updated_message);
                
                // Update ticket with user's response
                $update_sql = "UPDATE contact_messages SET 
                              message = '$updated_message',
                              ticket_status = 'new'
                              WHERE id = $ticket_id";
                
                if ($conn->query($update_sql)) {
                    $success = "Your response has been submitted successfully! Our support team will review and respond to your follow-up question.";
                    
                    // Refresh ticket data
                    $result = $conn->query($sql);
                    $ticket = $result->fetch_assoc();
                } else {
                    $error = "Failed to submit response. Please try again.";
                }
            }
        }
    }
}

$page_title = 'Respond to Ticket';
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo $page_title; ?> - India Survey Guide</title>
    <link rel="stylesheet" href="<?php echo SITE_URL; ?>/assets/style.css">
</head>
<body style="background-color: var(--light-grey);">
    
<div class="container" style="padding: 2rem 20px;">
    <div style="text-align: center; margin-bottom: 2rem;">
        <a href="<?php echo SITE_URL; ?>/" style="font-size: 1.8rem; font-weight: bold; color: var(--navy-blue); text-decoration: none;">
            <span style="color: var(--yellow);">Paid Survey Hub</span> India
        </a>
    </div>
    
    <div class="card" style="max-width: 700px; margin: 0 auto;">
        <?php if ($error): ?>
            <div style="text-align: center;">
                <div style="font-size: 3rem; margin-bottom: 1rem;">⚠️</div>
                <h1 class="card-title">Access Error</h1>
                <div class="alert alert-error"><?php echo $error; ?></div>
                <div style="margin-top: 2rem;">
                    <a href="<?php echo SITE_URL; ?>/contact.php" class="btn btn-primary">Submit New Ticket</a>
                    <a href="<?php echo SITE_URL; ?>/" class="btn btn-secondary">Go to Homepage</a>
                </div>
            </div>
        <?php elseif ($success): ?>
            <div style="text-align: center;">
                <div style="font-size: 3rem; margin-bottom: 1rem;">✅</div>
                <h1 class="card-title">Response Submitted!</h1>
                <div class="alert alert-success">
                    <?php echo $success; ?>
                </div>
                
                <div style="background: #fff3cd; padding: 1.5rem; border-radius: 8px; margin: 2rem 0; text-align: left;">
                    <p style="line-height: 1.8; margin-bottom: 1rem;">
                        <strong>📧 What happens next:</strong>
                    </p>
                    <ul style="line-height: 1.8; margin-left: 1.5rem;">
                        <li>Our support team will review your follow-up question</li>
                        <li>We will respond to your email within 24 hours</li>
                        <li>You can respond again using the link in our next email</li>
                    </ul>
                </div>
                
                <div style="margin-top: 2rem;">
                    <a href="<?php echo SITE_URL; ?>/" class="btn btn-primary">Go to Homepage</a>
                </div>
            </div>
        <?php elseif ($ticket): ?>
            <h1 class="card-title">Respond to Support Ticket</h1>
            
            <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 2rem;">
                <div style="display: flex; justify-content: space-between; align-items: center; flex-wrap: wrap; margin-bottom: 1rem;">
                    <div>
                        <p style="margin: 0;"><strong>Ticket ID:</strong> #<?php echo $ticket['id']; ?></p>
                        <p style="margin: 0.5rem 0 0 0; font-size: 0.9rem; color: var(--dark-grey);">
                            Submitted: <?php echo date('M j, Y', strtotime($ticket['created_at'])); ?>
                        </p>
                    </div>
                    <?php
                    $status_colors = [
                        'new' => 'background: #ffc107; color: #000;',
                        'in_progress' => 'background: #17a2b8; color: #fff;',
                        'resolved' => 'background: #28a745; color: #fff;',
                        'closed' => 'background: #6c757d; color: #fff;'
                    ];
                    $status_text = ucfirst(str_replace('_', ' ', $ticket['ticket_status']));
                    ?>
                    <span style="display: inline-block; padding: 0.4rem 0.9rem; border-radius: 4px; font-size: 0.9rem; font-weight: bold; <?php echo $status_colors[$ticket['ticket_status']]; ?>">
                        <?php echo $status_text; ?>
                    </span>
                </div>
            </div>
            
            <?php if ($ticket['admin_reply']): ?>
                <div style="background: #d4edda; padding: 1.5rem; border-left: 5px solid #28a745; border-radius: 8px; margin-bottom: 2rem;">
                    <h3 style="color: #155724; margin-bottom: 1rem;">Support Team Response:</h3>
                    <p style="line-height: 1.8; color: #155724; white-space: pre-wrap;"><?php echo nl2br(htmlspecialchars($ticket['admin_reply'])); ?></p>
                    <?php if ($ticket['replied_at']): ?>
                        <p style="margin-top: 1rem; font-size: 0.85rem; color: #155724;">
                            <em>Replied on: <?php echo date('F j, Y \a\t g:i A', strtotime($ticket['replied_at'])); ?></em>
                        </p>
                    <?php endif; ?>
                </div>
            <?php endif; ?>
            
            <div style="background: var(--white); padding: 1.5rem; border: 2px solid var(--light-grey); border-radius: 8px; margin-bottom: 2rem;">
                <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">Your Original Message:</h3>
                <p style="line-height: 1.8; white-space: pre-wrap; color: #555;"><?php echo htmlspecialchars($ticket['message']); ?></p>
            </div>
            
            <div style="background: var(--light-grey); padding: 2rem; border-radius: 8px;">
                <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">💬 Have a follow-up question?</h3>
                <p style="margin-bottom: 1.5rem; line-height: 1.6;">
                    Type your follow-up message below and our support team will respond to your email.
                </p>
                
                <form method="POST" action="">
                    <div class="form-group">
                        <label for="user_reply">Your Follow-up Message *</label>
                        <textarea id="user_reply" name="user_reply" required style="min-height: 150px;" placeholder="Type your follow-up question or additional details here..."><?php echo isset($_POST['user_reply']) ? htmlspecialchars($_POST['user_reply']) : ''; ?></textarea>
                        <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">
                            We will send our response to: <strong><?php echo htmlspecialchars($ticket['email']); ?></strong>
                        </small>
                    </div>
                    
                    <button type="submit" class="btn btn-primary" style="width: 100%;">Submit Follow-up</button>
                </form>
            </div>
            
            <div class="alert alert-info" style="margin-top: 2rem;">
                <strong>📌 Note:</strong> After submitting your follow-up, our support team will review and respond to your email within 24 hours. You will receive another email with our response and a link to continue the conversation if needed.
            </div>
        <?php endif; ?>
    </div>
    
    <div style="text-align: center; margin-top: 2rem; color: var(--dark-grey); font-size: 0.9rem;">
        <p>&copy; <?php echo date('Y'); ?> Paid Survey Hub India. All rights reserved.</p>
    </div>
</div>

</body>
</html>
-------------------- END OF FILE --------------------

### FILE 12: signup.php
- Type: PHP
- Size: 4.92 KB
- Path: .
- Name: signup.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

// If already logged in, redirect to dashboard
if (is_member_logged_in()) {
    redirect(SITE_URL . '/dashboard.php');
}

$error = '';
$success = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $full_name = clean_input($_POST['full_name']);
    $email = clean_input($_POST['email']);
    $phone = clean_input($_POST['phone']);
    $password = $_POST['password'];
    $confirm_password = $_POST['confirm_password'];
    
    // Validation
    if (empty($full_name) || empty($email) || empty($phone) || empty($password)) {
        $error = "All fields are required";
    } elseif ($password !== $confirm_password) {
        $error = "Passwords do not match";
    } elseif (strlen($password) < 6) {
        $error = "Password must be at least 6 characters long";
    } else {
        // Check if email already exists
        $check_sql = "SELECT id FROM members WHERE email = '$email'";
        $result = $conn->query($check_sql);
        
        if ($result->num_rows > 0) {
            $error = "Email already registered";
        } else {
            // Hash password and create verification token
            $hashed_password = password_hash($password, PASSWORD_DEFAULT);
            $verification_token = bin2hex(random_bytes(32));
            
            // Insert member
            $sql = "INSERT INTO members (full_name, email, phone, password, verification_token) 
                    VALUES ('$full_name', '$email', '$phone', '$hashed_password', '$verification_token')";
            
            if ($conn->query($sql)) {
                // Send verification email
                $verify_link = SITE_URL . "/verify-email.php?token=" . $verification_token;
                $email_subject = "Verify Your Email - India Survey Guide";
                $email_message = "
                    <h2>Welcome to Paid Survey Hub India!</h2>
                    <p>Thank you for signing up. Please verify your email address by clicking the link below:</p>
                    <p><a href='$verify_link'>Verify Email Address</a></p>
                    <p>Or copy and paste this link: $verify_link</p>
                    <p>Best regards,<br>India Survey Guide Team</p>
                ";
                
                send_email($email, $email_subject, $email_message);
                
                $success = "Registration successful! Please check your email to verify your account.";
            } else {
                $error = "Registration failed. Please try again.";
            }
        }
    }
}

$page_title = 'Sign Up';
include 'includes/header.php';
?>

<div class="container">
    <div class="card" style="max-width: 600px; margin: 0 auto;">
        <h1 class="card-title">Create Your Account</h1>
        
        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <?php if ($success): ?>
            <div class="alert alert-success"><?php echo $success; ?></div>
        <?php else: ?>
            <form method="POST" action="">
                <div class="form-group">
                    <label for="full_name">Full Name *</label>
                    <input type="text" id="full_name" name="full_name" required 
                           value="<?php echo isset($_POST['full_name']) ? htmlspecialchars($_POST['full_name']) : ''; ?>">
                </div>
                
                <div class="form-group">
                    <label for="email">Email Address *</label>
                    <input type="email" id="email" name="email" required 
                           value="<?php echo isset($_POST['email']) ? htmlspecialchars($_POST['email']) : ''; ?>">
                </div>
                
                <div class="form-group">
                    <label for="phone">Phone Number *</label>
                    <input type="tel" id="phone" name="phone" required 
                           value="<?php echo isset($_POST['phone']) ? htmlspecialchars($_POST['phone']) : ''; ?>">
                </div>
                
                <div class="form-group">
                    <label for="password">Password * (minimum 6 characters)</label>
                    <input type="password" id="password" name="password" required>
                </div>
                
                <div class="form-group">
                    <label for="confirm_password">Confirm Password *</label>
                    <input type="password" id="confirm_password" name="confirm_password" required>
                </div>
                
                <button type="submit" class="btn btn-primary" style="width: 100%;">Sign Up</button>
            </form>
            
            <p style="text-align: center; margin-top: 1.5rem;">
                Already have an account? <a href="<?php echo SITE_URL; ?>/login.php" style="color: var(--yellow); font-weight: bold;">Login here</a>
            </p>
        <?php endif; ?>
    </div>
</div>

<?php include 'includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 13: survey-detail.php
- Type: PHP
- Size: 2.99 KB
- Path: .
- Name: survey-detail.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

// Check if member is logged in
if (!is_member_logged_in()) {
    redirect(SITE_URL . '/login.php');
}

// Get member details
$member_id = $_SESSION['member_id'];
$sql = "SELECT * FROM members WHERE id = $member_id";
$result = $conn->query($sql);
$member = $result->fetch_assoc();

// Check if member has access
$payment_amount = get_setting('payment_amount');
$has_access = ($member['is_approved'] == 1 && ($member['payment_status'] == 1 || $payment_amount == 0));

if (!$has_access) {
    redirect(SITE_URL . '/dashboard.php');
}

// Get survey site details
if (!isset($_GET['id'])) {
    redirect(SITE_URL . '/dashboard.php');
}

$survey_id = (int)$_GET['id'];
$survey_sql = "SELECT * FROM survey_sites WHERE id = $survey_id";
$survey_result = $conn->query($survey_sql);

if ($survey_result->num_rows == 0) {
    redirect(SITE_URL . '/dashboard.php');
}

$survey = $survey_result->fetch_assoc();

$page_title = htmlspecialchars($survey['title']);
include 'includes/header.php';
?>

<div class="container">
    <div class="card">
        <a href="<?php echo SITE_URL; ?>/dashboard.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to Dashboard
        </a>
        
        <h1 class="card-title"><?php echo htmlspecialchars($survey['title']); ?></h1>
        
        <div style="display: grid; grid-template-columns: 1fr 2fr; gap: 2rem; margin-top: 2rem;">
            <div>
                <img src="<?php echo SITE_URL; ?>/uploads/<?php echo htmlspecialchars($survey['image']); ?>" 
                     alt="<?php echo htmlspecialchars($survey['title']); ?>" 
                     style="width: 100%; border-radius: 8px; box-shadow: 0 2px 10px rgba(0,0,0,0.1);">
            </div>
            
            <div>
                <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">About This Survey Site</h3>
                <p style="line-height: 1.8; margin-bottom: 2rem;">
                    <?php echo nl2br(htmlspecialchars($survey['description'])); ?>
                </p>
                
                <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 1.5rem;">
                    <p style="margin-bottom: 0.5rem;"><strong>Support Contact:</strong></p>
                    <p><?php echo htmlspecialchars($survey['support_contact']); ?></p>
                </div>
                
                <a href="<?php echo htmlspecialchars($survey['website_link']); ?>" 
                   target="_blank" 
                   rel="noopener noreferrer" 
                   class="btn btn-primary" 
                   style="width: 100%; text-align: center; font-size: 1.1rem; padding: 1rem;">
                    Visit Survey Site →
                </a>
            </div>
        </div>
    </div>
</div>

<style>
@media (max-width: 768px) {
    .container .card > div {
        grid-template-columns: 1fr !important;
    }
}
</style>

<?php include 'includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 14: verify-email.php
- Type: PHP
- Size: 1.76 KB
- Path: .
- Name: verify-email.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

$message = '';
$type = 'error';

if (isset($_GET['token'])) {
    $token = clean_input($_GET['token']);
    
    // Find member with this token
    $sql = "SELECT id, is_verified FROM members WHERE verification_token = '$token'";
    $result = $conn->query($sql);
    
    if ($result->num_rows > 0) {
        $member = $result->fetch_assoc();
        
        if ($member['is_verified'] == 1) {
            $message = "Your email has already been verified. You can login now.";
            $type = 'info';
        } else {
            // Update member as verified
            $update_sql = "UPDATE members SET is_verified = 1, verification_token = NULL WHERE id = " . $member['id'];
            
            if ($conn->query($update_sql)) {
                $message = "Email verified successfully! Your account is now awaiting admin approval. You will be notified once approved.";
                $type = 'success';
            } else {
                $message = "Verification failed. Please try again.";
            }
        }
    } else {
        $message = "Invalid verification token.";
    }
} else {
    $message = "No verification token provided.";
}

$page_title = 'Email Verification';
include 'includes/header.php';
?>

<div class="container">
    <div class="card" style="max-width: 600px; margin: 0 auto; text-align: center;">
        <h1 class="card-title">Email Verification</h1>
        
        <div class="alert alert-<?php echo $type; ?>">
            <?php echo $message; ?>
        </div>
        
        <?php if ($type === 'success' || $type === 'info'): ?>
            <a href="<?php echo SITE_URL; ?>/login.php" class="btn btn-primary">Go to Login</a>
        <?php endif; ?>
    </div>
</div>

<?php include 'includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 15: assets/style.css
- Type: CSS
- Size: 5.42 KB
- Path: assets
- Name: style.css
------------------------------------------------------------
/* Reset and Base Styles */
* {
    margin: 0;
    padding: 0;
    box-sizing: border-box;
}

:root {
    --navy-blue: #001f3f;
    --yellow: #FFD700;
    --light-grey: #f5f5f5;
    --dark-grey: #666;
    --white: #ffffff;
}

body {
    font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
    background-color: var(--light-grey);
    color: var(--navy-blue);
    line-height: 1.6;
}

/* Header */
header {
    background-color: var(--navy-blue);
    color: var(--white);
    padding: 1rem 0;
    box-shadow: 0 2px 5px rgba(0,0,0,0.1);
}

.header-container {
    max-width: 1200px;
    margin: 0 auto;
    padding: 0 20px;
    display: flex;
    justify-content: space-between;
    align-items: center;
    flex-wrap: wrap;
}

.logo {
    font-size: 1.5rem;
    font-weight: bold;
    color: var(--yellow);
    text-decoration: none;
}

nav ul {
    list-style: none;
    display: flex;
    gap: 1.5rem;
    flex-wrap: wrap;
}

nav a {
    color: var(--white);
    text-decoration: none;
    transition: color 0.3s;
}

nav a:hover {
    color: var(--yellow);
}

/* Main Container */
.container {
    max-width: 1200px;
    margin: 2rem auto;
    padding: 0 20px;
}

/* Cards */
.card {
    background: var(--white);
    border-radius: 8px;
    padding: 2rem;
    box-shadow: 0 2px 10px rgba(0,0,0,0.1);
    margin-bottom: 2rem;
}

.card-title {
    color: var(--navy-blue);
    margin-bottom: 1.5rem;
    font-size: 1.8rem;
    border-bottom: 3px solid var(--yellow);
    padding-bottom: 0.5rem;
}

/* Forms */
.form-group {
    margin-bottom: 1.5rem;
}

label {
    display: block;
    margin-bottom: 0.5rem;
    color: var(--navy-blue);
    font-weight: 500;
}

input[type="text"],
input[type="email"],
input[type="password"],
input[type="tel"],
input[type="url"],
input[type="number"],
textarea,
select {
    width: 100%;
    padding: 0.75rem;
    border: 2px solid var(--dark-grey);
    border-radius: 5px;
    font-size: 1rem;
    transition: border-color 0.3s;
}

input:focus,
textarea:focus,
select:focus {
    outline: none;
    border-color: var(--yellow);
}

textarea {
    resize: vertical;
    min-height: 120px;
}

/* Buttons */
.btn {
    padding: 0.75rem 1.5rem;
    border: none;
    border-radius: 5px;
    cursor: pointer;
    font-size: 1rem;
    transition: all 0.3s;
    text-decoration: none;
    display: inline-block;
}

.btn-primary {
    background-color: var(--yellow);
    color: var(--navy-blue);
    font-weight: bold;
}

.btn-primary:hover {
    background-color: #FFC700;
    transform: translateY(-2px);
    box-shadow: 0 4px 8px rgba(0,0,0,0.2);
}

.btn-secondary {
    background-color: var(--navy-blue);
    color: var(--white);
}

.btn-secondary:hover {
    background-color: #003366;
}

.btn-danger {
    background-color: #dc3545;
    color: var(--white);
}

.btn-danger:hover {
    background-color: #c82333;
}

/* Survey Grid */
.survey-grid {
    display: grid;
    grid-template-columns: repeat(auto-fill, minmax(280px, 1fr));
    gap: 2rem;
    margin-top: 2rem;
}

.survey-card {
    background: var(--white);
    border-radius: 8px;
    overflow: hidden;
    box-shadow: 0 2px 10px rgba(0,0,0,0.1);
    transition: transform 0.3s, box-shadow 0.3s;
    cursor: pointer;
}

.survey-card:hover {
    transform: translateY(-5px);
    box-shadow: 0 5px 20px rgba(0,0,0,0.15);
}

.survey-image {
    width: 100%;
    height: 200px;
    object-fit: cover;
}

.survey-info {
    padding: 1.5rem;
}

.survey-title {
    color: var(--navy-blue);
    font-size: 1.2rem;
    margin-bottom: 0.5rem;
}

/* Tables */
table {
    width: 100%;
    border-collapse: collapse;
    background: var(--white);
    border-radius: 8px;
    overflow: hidden;
}

th {
    background-color: var(--navy-blue);
    color: var(--white);
    padding: 1rem;
    text-align: left;
}

td {
    padding: 1rem;
    border-bottom: 1px solid var(--light-grey);
}

tr:hover {
    background-color: var(--light-grey);
}

/* Alerts */
.alert {
    padding: 1rem;
    border-radius: 5px;
    margin-bottom: 1.5rem;
}

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

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

.alert-info {
    background-color: #fff3cd;
    color: #856404;
    border: 1px solid #ffeaa7;
}

/* Payment Info */
.payment-box {
    text-align: center;
    padding: 2rem;
    background: var(--white);
    border-radius: 8px;
    border: 3px solid var(--yellow);
}

.payment-amount {
    font-size: 2.5rem;
    color: var(--navy-blue);
    font-weight: bold;
    margin: 1rem 0;
}

.qr-code {
    max-width: 300px;
    margin: 1.5rem auto;
    display: block;
}

/* Footer */
footer {
    background-color: var(--navy-blue);
    color: var(--white);
    text-align: center;
    padding: 2rem 0;
    margin-top: 3rem;
}

/* Responsive Design */
@media (max-width: 768px) {
    .header-container {
        flex-direction: column;
        text-align: center;
    }
    
    nav ul {
        margin-top: 1rem;
        justify-content: center;
    }
    
    .survey-grid {
        grid-template-columns: 1fr;
    }
    
    .card {
        padding: 1.5rem;
    }
    
    table {
        font-size: 0.9rem;
    }
    
    th, td {
        padding: 0.75rem;
    }
}

@media (max-width: 480px) {
    .logo {
        font-size: 1.2rem;
    }
    
    nav ul {
        gap: 1rem;
    }
    
    .card-title {
        font-size: 1.5rem;
    }
    
    .btn {
        padding: 0.6rem 1.2rem;
        font-size: 0.9rem;
    }
}
-------------------- END OF FILE --------------------

### FILE 16: config/config.php
- Type: PHP
- Size: 2.62 KB
- Path: config
- Name: config.php
------------------------------------------------------------
<?php
// Database Configuration
define('DB_HOST', 'localhost');
define('DB_USER', 'u752449863_pshadmin'); // Replace with your database username
define('DB_PASS', 'S@n@h2016'); // Replace with your database password
define('DB_NAME', 'u752449863_psh');     // Replace with your database name

// Site Configuration
define('SITE_URL', 'https://paidsurveyhub.in'); // Replace with your domain
define('SITE_NAME', 'Paid Survey Hub India');
define('ADMIN_PATH', '/management');

// Email Configuration
define('SMTP_FROM', 'signupverification@paidsurveyhub.in'); // Replace with your email
define('SMTP_FROM_NAME', 'Registrations - Paid Survey Hub India');

// Create database connection
try {
    $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
    
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    
    $conn->set_charset("utf8mb4");
} catch (Exception $e) {
    die("Database connection error: " . $e->getMessage());
}

// Start session if not already started
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

// Helper function to check if user is logged in (member)
function is_member_logged_in() {
    return isset($_SESSION['member_id']);
}

// Helper function to check if admin is logged in
function is_admin_logged_in() {
    return isset($_SESSION['admin_id']);
}

// Helper function to redirect
function redirect($url) {
    header("Location: " . $url);
    exit();
}

// Helper function to sanitize input
function clean_input($data) {
    global $conn;
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $conn->real_escape_string($data);
}

// Helper function to send email
function send_email($to, $subject, $message) {
    $headers = "From: " . SMTP_FROM_NAME . " <" . SMTP_FROM . ">\r\n";
    $headers .= "Reply-To: " . SMTP_FROM . "\r\n";
    $headers .= "MIME-Version: 1.0\r\n";
    $headers .= "Content-Type: text/html; charset=UTF-8\r\n";
    
    return mail($to, $subject, $message, $headers);
}

// Get setting value
function get_setting($key) {
    global $conn;
    $key = clean_input($key);
    $sql = "SELECT setting_value FROM settings WHERE setting_key = '$key'";
    $result = $conn->query($sql);
    
    if ($result && $result->num_rows > 0) {
        $row = $result->fetch_assoc();
        return $row['setting_value'];
    }
    
    return '';
}

// Update setting value
function update_setting($key, $value) {
    global $conn;
    $key = clean_input($key);
    $value = clean_input($value);
    
    $sql = "UPDATE settings SET setting_value = '$value' WHERE setting_key = '$key'";
    return $conn->query($sql);
}
?>
-------------------- END OF FILE --------------------

### FILE 17: includes/footer.php
- Type: PHP
- Size: 254 B
- Path: includes
- Name: footer.php
------------------------------------------------------------
<footer>
        <div class="container">
            <p>&copy; <?php echo date('Y'); ?> Paid Survey Hub India. All rights reserved.</p>
            <p>Find genuine paid online survey opportunities in India</p>
        </div>
    </footer>
</body>
</html>
-------------------- END OF FILE --------------------

### FILE 18: includes/header.php
- Type: PHP
- Size: 1.94 KB
- Path: includes
- Name: header.php
------------------------------------------------------------
<?php
if (!defined('DB_HOST')) {
    require_once __DIR__ . '/../config/config.php';
}

// Determine the base path for assets
$base_path = SITE_URL;
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo isset($page_title) ? $page_title . ' - ' : ''; ?>Paid Survey Hub India</title>
    <link rel="stylesheet" href="<?php echo $base_path; ?>/assets/style.css">
</head>
<body>
    <header>
        <div class="header-container">
            <a href="<?php echo $base_path; ?>/" class="logo">Paid Survey Hub India</a>
            <nav>
                <ul>
                    <?php if (is_member_logged_in()): ?>
                        <li><a href="<?php echo $base_path; ?>/dashboard.php">Dashboard</a></li>
                        <li><a href="<?php echo $base_path; ?>/my-tickets.php">My Tickets</a></li>
                        <li><a href="<?php echo $base_path; ?>/contact.php">Contact</a></li>
                        <li><a href="<?php echo $base_path; ?>/logout.php">Logout</a></li>
                    <?php elseif (is_admin_logged_in()): ?>
                        <li><a href="<?php echo $base_path . ADMIN_PATH; ?>/dashboard.php">Dashboard</a></li>
                        <li><a href="<?php echo $base_path . ADMIN_PATH; ?>/manage-tickets.php">Tickets</a></li>
                        <li><a href="<?php echo $base_path . ADMIN_PATH; ?>/logout.php">Logout</a></li>
                    <?php else: ?>
                        <li><a href="<?php echo $base_path; ?>/">Home</a></li>
                        <li><a href="<?php echo $base_path; ?>/contact.php">Contact</a></li>
                        <li><a href="<?php echo $base_path; ?>/login.php">Login</a></li>
                        <li><a href="<?php echo $base_path; ?>/signup.php">Sign Up</a></li>
                    <?php endif; ?>
                </ul>
            </nav>
        </div>
    </header>
-------------------- END OF FILE --------------------

### FILE 19: management/add-survey.php
- Type: PHP
- Size: 4.99 KB
- Path: management
- Name: add-survey.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

$error = '';
$success = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $title = clean_input($_POST['title']);
    $website_link = clean_input($_POST['website_link']);
    $description = clean_input($_POST['description']);
    $support_contact = clean_input($_POST['support_contact']);
    
    // Validation
    if (empty($title) || empty($website_link) || empty($description) || empty($support_contact)) {
        $error = "All fields are required";
    } elseif (!isset($_FILES['image']) || $_FILES['image']['error'] != 0) {
        $error = "Please upload an image";
    } else {
        // Handle image upload
        $allowed_types = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif'];
        $file_type = $_FILES['image']['type'];
        
        if (!in_array($file_type, $allowed_types)) {
            $error = "Only JPG, PNG, and GIF images are allowed";
        } else {
            $file_extension = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
            $new_filename = uniqid() . '.' . $file_extension;
            $upload_path = '../uploads/' . $new_filename;
            
            if (move_uploaded_file($_FILES['image']['tmp_name'], $upload_path)) {
                // Insert survey site
                $sql = "INSERT INTO survey_sites (title, website_link, description, support_contact, image) 
                        VALUES ('$title', '$website_link', '$description', '$support_contact', '$new_filename')";
                
                if ($conn->query($sql)) {
                    $success = "Survey site added successfully!";
                } else {
                    $error = "Failed to add survey site: " . $conn->error;
                    unlink($upload_path); // Delete uploaded file
                }
            } else {
                $error = "Failed to upload image";
            }
        }
    }
}

$page_title = 'Add Survey Site';
include '../includes/header.php';
?>

<div class="container">
    <div class="card">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/dashboard.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to Dashboard
        </a>
        
        <h1 class="card-title">Add New Survey Site</h1>
        
        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <?php if ($success): ?>
            <div class="alert alert-success">
                <?php echo $success; ?>
                <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/add-survey.php" class="btn btn-primary" style="margin-top: 1rem;">Add Another</a>
                <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-surveys.php" class="btn btn-secondary" style="margin-top: 1rem;">View All</a>
            </div>
        <?php else: ?>
            <form method="POST" action="" enctype="multipart/form-data">
                <div class="form-group">
                    <label for="title">Survey Site Title *</label>
                    <input type="text" id="title" name="title" required 
                           value="<?php echo isset($_POST['title']) ? htmlspecialchars($_POST['title']) : ''; ?>">
                </div>
                
                <div class="form-group">
                    <label for="website_link">Website Link *</label>
                    <input type="url" id="website_link" name="website_link" required 
                           placeholder="https://example.com"
                           value="<?php echo isset($_POST['website_link']) ? htmlspecialchars($_POST['website_link']) : ''; ?>">
                </div>
                
                <div class="form-group">
                    <label for="description">Description *</label>
                    <textarea id="description" name="description" required><?php echo isset($_POST['description']) ? htmlspecialchars($_POST['description']) : ''; ?></textarea>
                </div>
                
                <div class="form-group">
                    <label for="support_contact">Support Email or Form Link *</label>
                    <input type="text" id="support_contact" name="support_contact" required 
                           placeholder="support@example.com or https://example.com/contact"
                           value="<?php echo isset($_POST['support_contact']) ? htmlspecialchars($_POST['support_contact']) : ''; ?>">
                </div>
                
                <div class="form-group">
                    <label for="image">Survey Site Image * (JPG, PNG, GIF)</label>
                    <input type="file" id="image" name="image" accept="image/*" required>
                </div>
                
                <button type="submit" class="btn btn-primary">Add Survey Site</button>
            </form>
        <?php endif; ?>
    </div>
</div>

<?php include '../includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 20: management/dashboard.php
- Type: PHP
- Size: 4.97 KB
- Path: management
- Name: dashboard.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

// Get statistics
$total_members_result = $conn->query("SELECT COUNT(*) as count FROM members");
$total_members = $total_members_result->fetch_assoc()['count'];

$pending_approval_result = $conn->query("SELECT COUNT(*) as count FROM members WHERE is_verified = 1 AND is_approved = 0");
$pending_approval = $pending_approval_result->fetch_assoc()['count'];

$active_members_result = $conn->query("SELECT COUNT(*) as count FROM members WHERE is_approved = 1 AND payment_status = 1");
$active_members = $active_members_result->fetch_assoc()['count'];

$total_surveys_result = $conn->query("SELECT COUNT(*) as count FROM survey_sites");
$total_surveys = $total_surveys_result->fetch_assoc()['count'];

$new_tickets_result = $conn->query("SELECT COUNT(*) as count FROM contact_messages WHERE ticket_status = 'new'");
$new_tickets = $new_tickets_result->fetch_assoc()['count'];

$page_title = 'Admin Dashboard';
include '../includes/header.php';
?>

<div class="container">
    <div class="card">
        <h1 class="card-title">Admin Dashboard</h1>
        
        <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 1.5rem; margin: 2rem 0;">
            <div style="background: var(--yellow); padding: 1.5rem; border-radius: 8px; text-align: center;">
                <h3 style="color: var(--navy-blue); margin-bottom: 0.5rem;">Total Members</h3>
                <p style="font-size: 2rem; font-weight: bold; color: var(--navy-blue);"><?php echo $total_members; ?></p>
            </div>
            
            <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; text-align: center; border: 2px solid var(--yellow);">
                <h3 style="color: var(--navy-blue); margin-bottom: 0.5rem;">Pending Approval</h3>
                <p style="font-size: 2rem; font-weight: bold; color: var(--navy-blue);"><?php echo $pending_approval; ?></p>
            </div>
            
            <div style="background: var(--navy-blue); padding: 1.5rem; border-radius: 8px; text-align: center;">
                <h3 style="color: var(--yellow); margin-bottom: 0.5rem;">Active Members</h3>
                <p style="font-size: 2rem; font-weight: bold; color: var(--white);"><?php echo $active_members; ?></p>
            </div>
            
            <div style="background: var(--yellow); padding: 1.5rem; border-radius: 8px; text-align: center;">
                <h3 style="color: var(--navy-blue); margin-bottom: 0.5rem;">Survey Sites</h3>
                <p style="font-size: 2rem; font-weight: bold; color: var(--navy-blue);"><?php echo $total_surveys; ?></p>
            </div>
            
            <div style="background: #ffc107; padding: 1.5rem; border-radius: 8px; text-align: center; position: relative;">
                <h3 style="color: var(--navy-blue); margin-bottom: 0.5rem;">New Tickets</h3>
                <p style="font-size: 2rem; font-weight: bold; color: var(--navy-blue);"><?php echo $new_tickets; ?></p>
                <?php if ($new_tickets > 0): ?>
                    <span style="position: absolute; top: 10px; right: 10px; background: #dc3545; color: white; border-radius: 50%; width: 24px; height: 24px; display: flex; align-items: center; justify-content: center; font-size: 0.8rem; font-weight: bold;">!</span>
                <?php endif; ?>
            </div>
        </div>
        
        <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(250px, 1fr)); gap: 1.5rem; margin-top: 2rem;">
            <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-tickets.php" class="btn btn-primary" style="text-align: center; padding: 1.5rem; position: relative;">
                Manage Tickets
                <?php if ($new_tickets > 0): ?>
                    <span style="position: absolute; top: 10px; right: 10px; background: #dc3545; color: white; border-radius: 12px; padding: 2px 8px; font-size: 0.75rem; font-weight: bold;"><?php echo $new_tickets; ?> New</span>
                <?php endif; ?>
            </a>
            
            <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-members.php" class="btn btn-secondary" style="text-align: center; padding: 1.5rem;">
                Manage Members
            </a>
            
            <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/add-survey.php" class="btn btn-primary" style="text-align: center; padding: 1.5rem;">
                + Add Survey Site
            </a>
            
            <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-surveys.php" class="btn btn-secondary" style="text-align: center; padding: 1.5rem;">
                Manage Surveys
            </a>
            
            <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/settings.php" class="btn btn-secondary" style="text-align: center; padding: 1.5rem;">
                Settings
            </a>
        </div>
    </div>
</div>

<?php include '../includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 21: management/delete-survey.php
- Type: PHP
- Size: 858 B
- Path: management
- Name: delete-survey.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

if (!isset($_GET['id'])) {
    redirect(SITE_URL . ADMIN_PATH . '/manage-surveys.php');
}

$survey_id = (int)$_GET['id'];

// Get survey details to delete image
$sql = "SELECT image FROM survey_sites WHERE id = $survey_id";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $survey = $result->fetch_assoc();
    
    // Delete survey from database
    $delete_sql = "DELETE FROM survey_sites WHERE id = $survey_id";
    
    if ($conn->query($delete_sql)) {
        // Delete image file
        $image_path = '../uploads/' . $survey['image'];
        if (file_exists($image_path)) {
            unlink($image_path);
        }
    }
}

redirect(SITE_URL . ADMIN_PATH . '/manage-surveys.php');
?>
-------------------- END OF FILE --------------------

### FILE 22: management/edit-member.php
- Type: PHP
- Size: 8.23 KB
- Path: management
- Name: edit-member.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

if (!isset($_GET['id'])) {
    redirect(SITE_URL . ADMIN_PATH . '/manage-members.php');
}

$member_id = (int)$_GET['id'];
$error = '';
$success = '';

// Get member details
$sql = "SELECT * FROM members WHERE id = $member_id";
$result = $conn->query($sql);

if ($result->num_rows == 0) {
    redirect(SITE_URL . ADMIN_PATH . '/manage-members.php');
}

$member = $result->fetch_assoc();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $full_name = clean_input($_POST['full_name']);
    $email = clean_input($_POST['email']);
    $phone = clean_input($_POST['phone']);
    $is_verified = isset($_POST['is_verified']) ? 1 : 0;
    $is_approved = isset($_POST['is_approved']) ? 1 : 0;
    $payment_status = isset($_POST['payment_status']) ? 1 : 0;
    
    // Validation
    if (empty($full_name) || empty($email) || empty($phone)) {
        $error = "Name, email, and phone are required";
    } elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
        $error = "Invalid email format";
    } else {
        // Check if email is already used by another member
        $check_sql = "SELECT id FROM members WHERE email = '$email' AND id != $member_id";
        $check_result = $conn->query($check_sql);
        
        if ($check_result->num_rows > 0) {
            $error = "Email is already registered by another member";
        } else {
            // Update member
            $update_sql = "UPDATE members SET 
                          full_name = '$full_name',
                          email = '$email',
                          phone = '$phone',
                          is_verified = $is_verified,
                          is_approved = $is_approved,
                          payment_status = $payment_status
                          WHERE id = $member_id";
            
            if ($conn->query($update_sql)) {
                $success = "Member updated successfully!";
                // Refresh member data
                $result = $conn->query("SELECT * FROM members WHERE id = $member_id");
                $member = $result->fetch_assoc();
            } else {
                $error = "Failed to update member: " . $conn->error;
            }
        }
    }
}

$page_title = 'Edit Member';
include '../includes/header.php';
?>

<div class="container">
    <div class="card" style="max-width: 800px; margin: 0 auto;">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-members.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to Members
        </a>
        
        <h1 class="card-title">Edit Member</h1>
        
        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <?php if ($success): ?>
            <div class="alert alert-success"><?php echo $success; ?></div>
        <?php endif; ?>
        
        <form method="POST" action="">
            <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 2rem;">
                <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">Basic Information</h3>
                
                <div class="form-group">
                    <label for="full_name">Full Name *</label>
                    <input type="text" id="full_name" name="full_name" required 
                           value="<?php echo htmlspecialchars($member['full_name']); ?>">
                </div>
                
                <div class="form-group">
                    <label for="email">Email Address *</label>
                    <input type="email" id="email" name="email" required 
                           value="<?php echo htmlspecialchars($member['email']); ?>">
                </div>
                
                <div class="form-group">
                    <label for="phone">Phone Number *</label>
                    <input type="tel" id="phone" name="phone" required 
                           value="<?php echo htmlspecialchars($member['phone']); ?>">
                </div>
            </div>
            
            <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 2rem;">
                <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">Account Status</h3>
                
                <div style="margin-bottom: 1rem;">
                    <label style="display: flex; align-items: center; cursor: pointer;">
                        <input type="checkbox" name="is_verified" value="1" 
                               <?php echo $member['is_verified'] ? 'checked' : ''; ?>
                               style="width: 20px; height: 20px; margin-right: 10px; cursor: pointer;">
                        <span style="font-size: 1rem;">
                            <strong>Email Verified</strong>
                            <small style="display: block; color: var(--dark-grey); margin-top: 0.25rem;">
                                Member has verified their email address
                            </small>
                        </span>
                    </label>
                </div>
                
                <div style="margin-bottom: 1rem; padding: 1rem; background: #fff3cd; border-left: 4px solid var(--yellow); border-radius: 4px;">
                    <label style="display: flex; align-items: center; cursor: pointer;">
                        <input type="checkbox" name="payment_status" value="1" 
                               <?php echo $member['payment_status'] ? 'checked' : ''; ?>
                               style="width: 20px; height: 20px; margin-right: 10px; cursor: pointer;">
                        <span style="font-size: 1rem;">
                            <strong style="color: var(--navy-blue);">Payment Completed</strong>
                            <small style="display: block; color: var(--dark-grey); margin-top: 0.25rem;">
                                Mark as paid after verifying payment proof (UTR/Reference Number)
                            </small>
                        </span>
                    </label>
                </div>
                
                <div style="margin-bottom: 0;">
                    <label style="display: flex; align-items: center; cursor: pointer;">
                        <input type="checkbox" name="is_approved" value="1" 
                               <?php echo $member['is_approved'] ? 'checked' : ''; ?>
                               style="width: 20px; height: 20px; margin-right: 10px; cursor: pointer;">
                        <span style="font-size: 1rem;">
                            <strong>Account Approved</strong>
                            <small style="display: block; color: var(--dark-grey); margin-top: 0.25rem;">
                                Member can access survey sites after approval
                            </small>
                        </span>
                    </label>
                </div>
            </div>
            
            <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 2rem;">
                <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">Registration Details</h3>
                <p><strong>Member ID:</strong> <?php echo $member['id']; ?></p>
                <p><strong>Registered On:</strong> <?php echo date('F j, Y \a\t g:i A', strtotime($member['created_at'])); ?></p>
            </div>
            
            <div class="alert alert-info" style="background: #fff3cd; border-color: #ffeaa7;">
                <strong>⚠️ Important:</strong> Make sure to verify payment proof before marking as paid and approving the member. Check the UTR/Reference number from the payment screenshot sent to signupverification@paidsurveyhub.in
            </div>
            
            <div style="display: flex; gap: 1rem; margin-top: 1.5rem;">
                <button type="submit" class="btn btn-primary" style="flex: 1;">Update Member</button>
                <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-members.php" class="btn btn-secondary" style="flex: 1; text-align: center;">Cancel</a>
            </div>
        </form>
    </div>
</div>

<?php include '../includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 23: management/edit-survey.php
- Type: PHP
- Size: 5.79 KB
- Path: management
- Name: edit-survey.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

if (!isset($_GET['id'])) {
    redirect(SITE_URL . ADMIN_PATH . '/manage-surveys.php');
}

$survey_id = (int)$_GET['id'];
$error = '';
$success = '';

// Get survey details
$sql = "SELECT * FROM survey_sites WHERE id = $survey_id";
$result = $conn->query($sql);

if ($result->num_rows == 0) {
    redirect(SITE_URL . ADMIN_PATH . '/manage-surveys.php');
}

$survey = $result->fetch_assoc();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $title = clean_input($_POST['title']);
    $website_link = clean_input($_POST['website_link']);
    $description = clean_input($_POST['description']);
    $support_contact = clean_input($_POST['support_contact']);
    
    // Validation
    if (empty($title) || empty($website_link) || empty($description) || empty($support_contact)) {
        $error = "All fields are required";
    } else {
        $new_filename = $survey['image'];
        
        // Check if new image is uploaded
        if (isset($_FILES['image']) && $_FILES['image']['error'] == 0) {
            $allowed_types = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif'];
            $file_type = $_FILES['image']['type'];
            
            if (!in_array($file_type, $allowed_types)) {
                $error = "Only JPG, PNG, and GIF images are allowed";
            } else {
                $file_extension = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
                $new_filename = uniqid() . '.' . $file_extension;
                $upload_path = '../uploads/' . $new_filename;
                
                if (move_uploaded_file($_FILES['image']['tmp_name'], $upload_path)) {
                    // Delete old image
                    if (file_exists('../uploads/' . $survey['image'])) {
                        unlink('../uploads/' . $survey['image']);
                    }
                } else {
                    $error = "Failed to upload new image";
                }
            }
        }
        
        if (empty($error)) {
            // Update survey site
            $sql = "UPDATE survey_sites SET 
                    title = '$title', 
                    website_link = '$website_link', 
                    description = '$description', 
                    support_contact = '$support_contact', 
                    image = '$new_filename' 
                    WHERE id = $survey_id";
            
            if ($conn->query($sql)) {
                $success = "Survey site updated successfully!";
                // Refresh survey data
                $result = $conn->query("SELECT * FROM survey_sites WHERE id = $survey_id");
                $survey = $result->fetch_assoc();
            } else {
                $error = "Failed to update survey site: " . $conn->error;
            }
        }
    }
}

$page_title = 'Edit Survey Site';
include '../includes/header.php';
?>

<div class="container">
    <div class="card">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-surveys.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to Survey Sites
        </a>
        
        <h1 class="card-title">Edit Survey Site</h1>
        
        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <?php if ($success): ?>
            <div class="alert alert-success"><?php echo $success; ?></div>
        <?php endif; ?>
        
        <form method="POST" action="" enctype="multipart/form-data">
            <div class="form-group">
                <label for="title">Survey Site Title *</label>
                <input type="text" id="title" name="title" required 
                       value="<?php echo htmlspecialchars($survey['title']); ?>">
            </div>
            
            <div class="form-group">
                <label for="website_link">Website Link *</label>
                <input type="url" id="website_link" name="website_link" required 
                       placeholder="https://example.com"
                       value="<?php echo htmlspecialchars($survey['website_link']); ?>">
            </div>
            
            <div class="form-group">
                <label for="description">Description *</label>
                <textarea id="description" name="description" required><?php echo htmlspecialchars($survey['description']); ?></textarea>
            </div>
            
            <div class="form-group">
                <label for="support_contact">Support Email or Form Link *</label>
                <input type="text" id="support_contact" name="support_contact" required 
                       placeholder="support@example.com or https://example.com/contact"
                       value="<?php echo htmlspecialchars($survey['support_contact']); ?>">
            </div>
            
            <div class="form-group">
                <label>Current Image</label>
                <div style="margin-bottom: 1rem;">
                    <img src="<?php echo SITE_URL; ?>/uploads/<?php echo htmlspecialchars($survey['image']); ?>" 
                         alt="Current Image" 
                         style="max-width: 300px; border-radius: 8px; box-shadow: 0 2px 10px rgba(0,0,0,0.1);">
                </div>
                <label for="image">Upload New Image (Optional)</label>
                <input type="file" id="image" name="image" accept="image/*">
                <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">Leave empty to keep current image</small>
            </div>
            
            <button type="submit" class="btn btn-primary">Update Survey Site</button>
        </form>
    </div>
</div>

<?php include '../includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 24: management/index.php
- Type: PHP
- Size: 2.2 KB
- Path: management
- Name: index.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// If already logged in, redirect to dashboard
if (is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/dashboard.php');
}

$error = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $username = clean_input($_POST['username']);
    $password = $_POST['password'];
    
    if (empty($username) || empty($password)) {
        $error = "Please enter both username and password";
    } else {
        // Check admin credentials
        $sql = "SELECT * FROM admins WHERE username = '$username'";
        $result = $conn->query($sql);
        
        if ($result->num_rows > 0) {
            $admin = $result->fetch_assoc();
            
            if (password_verify($password, $admin['password'])) {
                // Set session
                $_SESSION['admin_id'] = $admin['id'];
                $_SESSION['admin_username'] = $admin['username'];
                
                redirect(SITE_URL . ADMIN_PATH . '/dashboard.php');
            } else {
                $error = "Invalid username or password";
            }
        } else {
            $error = "Invalid username or password";
        }
    }
}

$page_title = 'Admin Login';
include '../includes/header.php';
?>

<div class="container">
    <div class="card" style="max-width: 500px; margin: 0 auto;">
        <h1 class="card-title">Admin Login</h1>
        
        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <form method="POST" action="">
            <div class="form-group">
                <label for="username">Username</label>
                <input type="text" id="username" name="username" required 
                       value="<?php echo isset($_POST['username']) ? htmlspecialchars($_POST['username']) : ''; ?>">
            </div>
            
            <div class="form-group">
                <label for="password">Password</label>
                <input type="password" id="password" name="password" required>
            </div>
            
            <button type="submit" class="btn btn-primary" style="width: 100%;">Login</button>
        </form>
    </div>
</div>

<?php include '../includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 25: management/logout.php
- Type: PHP
- Size: 209 B
- Path: management
- Name: logout.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Clear all session variables
session_unset();

// Destroy the session
session_destroy();

// Redirect to admin login page
redirect(SITE_URL . ADMIN_PATH . '/');
?>
-------------------- END OF FILE --------------------

### FILE 26: management/manage-members.php
- Type: PHP
- Size: 14.57 KB
- Path: management
- Name: manage-members.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

$success = '';

// Handle approval (only if payment is done)
if (isset($_GET['approve'])) {
    $member_id = (int)$_GET['approve'];
    // Check if payment is done before approving
    $check_sql = "SELECT payment_status FROM members WHERE id = $member_id";
    $check_result = $conn->query($check_sql);
    if ($check_result->num_rows > 0) {
        $member_data = $check_result->fetch_assoc();
        if ($member_data['payment_status'] == 1) {
            $sql = "UPDATE members SET is_approved = 1 WHERE id = $member_id";
            if ($conn->query($sql)) {
                $success = "Member approved successfully!";
            }
        } else {
            $success = "Cannot approve: Payment not completed yet!";
        }
    }
}

// Build query with filters
$where_clauses = ["1=1"];

// Search filter
$search = isset($_GET['search']) ? clean_input($_GET['search']) : '';
if (!empty($search)) {
    $where_clauses[] = "(full_name LIKE '%$search%' OR email LIKE '%$search%' OR phone LIKE '%$search%')";
}

// Verified filter
if (isset($_GET['verified']) && $_GET['verified'] !== '') {
    $verified = (int)$_GET['verified'];
    $where_clauses[] = "is_verified = $verified";
}

// Approved filter
if (isset($_GET['approved']) && $_GET['approved'] !== '') {
    $approved = (int)$_GET['approved'];
    $where_clauses[] = "is_approved = $approved";
}

// Payment filter
if (isset($_GET['paid']) && $_GET['paid'] !== '') {
    $paid = (int)$_GET['paid'];
    $where_clauses[] = "payment_status = $paid";
}

// Sorting
$order_by = "created_at";
$order_dir = "DESC";
if (isset($_GET['sort'])) {
    $allowed_sorts = ['full_name', 'email', 'phone', 'created_at', 'is_verified', 'is_approved', 'payment_status'];
    if (in_array($_GET['sort'], $allowed_sorts)) {
        $order_by = $_GET['sort'];
    }
}
if (isset($_GET['dir']) && strtoupper($_GET['dir']) === 'ASC') {
    $order_dir = 'ASC';
}

// Build final query
$where_sql = implode(" AND ", $where_clauses);
$sql = "SELECT * FROM members WHERE $where_sql ORDER BY $order_by $order_dir";
$result = $conn->query($sql);

// Export functionality
if (isset($_GET['export']) && $_GET['export'] === 'csv') {
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment; filename="members_' . date('Y-m-d_H-i-s') . '.csv"');
    
    $output = fopen('php://output', 'w');
    fputcsv($output, ['ID', 'Full Name', 'Email', 'Phone', 'Verified', 'Approved', 'Paid', 'Registered Date']);
    
    while ($row = $result->fetch_assoc()) {
        fputcsv($output, [
            $row['id'],
            $row['full_name'],
            $row['email'],
            $row['phone'],
            $row['is_verified'] ? 'Yes' : 'No',
            $row['is_approved'] ? 'Yes' : 'No',
            $row['payment_status'] ? 'Yes' : 'No',
            date('Y-m-d H:i:s', strtotime($row['created_at']))
        ]);
    }
    fclose($output);
    exit();
}

$page_title = 'Manage Members';
include '../includes/header.php';
?>

<div class="container">
    <div class="card">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/dashboard.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to Dashboard
        </a>
        
        <h1 class="card-title">Manage Members</h1>
        
        <?php if ($success): ?>
            <div class="alert alert-success"><?php echo $success; ?></div>
        <?php endif; ?>
        
        <!-- Search and Filter Section -->
        <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 2rem;">
            <form method="GET" action="" style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 1rem;">
                <div>
                    <label for="search" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Search</label>
                    <input type="text" id="search" name="search" placeholder="Name, Email, Phone" 
                           value="<?php echo htmlspecialchars($search); ?>"
                           style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                </div>
                
                <div>
                    <label for="verified" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Email Verified</label>
                    <select id="verified" name="verified" style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                        <option value="">All</option>
                        <option value="1" <?php echo (isset($_GET['verified']) && $_GET['verified'] === '1') ? 'selected' : ''; ?>>Yes</option>
                        <option value="0" <?php echo (isset($_GET['verified']) && $_GET['verified'] === '0') ? 'selected' : ''; ?>>No</option>
                    </select>
                </div>
                
                <div>
                    <label for="approved" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Approved</label>
                    <select id="approved" name="approved" style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                        <option value="">All</option>
                        <option value="1" <?php echo (isset($_GET['approved']) && $_GET['approved'] === '1') ? 'selected' : ''; ?>>Yes</option>
                        <option value="0" <?php echo (isset($_GET['approved']) && $_GET['approved'] === '0') ? 'selected' : ''; ?>>No</option>
                    </select>
                </div>
                
                <div>
                    <label for="paid" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Payment Status</label>
                    <select id="paid" name="paid" style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                        <option value="">All</option>
                        <option value="1" <?php echo (isset($_GET['paid']) && $_GET['paid'] === '1') ? 'selected' : ''; ?>>Paid</option>
                        <option value="0" <?php echo (isset($_GET['paid']) && $_GET['paid'] === '0') ? 'selected' : ''; ?>>Unpaid</option>
                    </select>
                </div>
                
                <div style="display: flex; align-items: flex-end; gap: 0.5rem;">
                    <button type="submit" class="btn btn-primary" style="flex: 1;">Filter</button>
                    <a href="?" class="btn btn-secondary" style="padding: 0.75rem 1rem; text-decoration: none;">Reset</a>
                </div>
            </form>
        </div>
        
        <!-- Export Button -->
        <div style="text-align: right; margin-bottom: 1rem;">
            <a href="?export=csv<?php 
                echo !empty($search) ? '&search=' . urlencode($search) : '';
                echo isset($_GET['verified']) ? '&verified=' . $_GET['verified'] : '';
                echo isset($_GET['approved']) ? '&approved=' . $_GET['approved'] : '';
                echo isset($_GET['paid']) ? '&paid=' . $_GET['paid'] : '';
                echo isset($_GET['sort']) ? '&sort=' . $_GET['sort'] : '';
                echo isset($_GET['dir']) ? '&dir=' . $_GET['dir'] : '';
            ?>" class="btn btn-secondary">📊 Export to CSV</a>
        </div>
        
        <?php if ($result->num_rows > 0): ?>
            <div style="overflow-x: auto;">
                <table>
                    <thead>
                        <tr>
                            <th><a href="?sort=full_name&dir=<?php echo ($order_by === 'full_name' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Name <?php if($order_by === 'full_name') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th><a href="?sort=email&dir=<?php echo ($order_by === 'email' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Email <?php if($order_by === 'email') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th><a href="?sort=phone&dir=<?php echo ($order_by === 'phone' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Phone <?php if($order_by === 'phone') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th><a href="?sort=is_verified&dir=<?php echo ($order_by === 'is_verified' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Verified <?php if($order_by === 'is_verified') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th><a href="?sort=is_approved&dir=<?php echo ($order_by === 'is_approved' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Approved <?php if($order_by === 'is_approved') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th><a href="?sort=payment_status&dir=<?php echo ($order_by === 'payment_status' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Paid <?php if($order_by === 'payment_status') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th><a href="?sort=created_at&dir=<?php echo ($order_by === 'created_at' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Registered <?php if($order_by === 'created_at') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php while ($member = $result->fetch_assoc()): ?>
                            <tr>
                                <td><?php echo htmlspecialchars($member['full_name']); ?></td>
                                <td><?php echo htmlspecialchars($member['email']); ?></td>
                                <td><?php echo htmlspecialchars($member['phone']); ?></td>
                                <td>
                                    <span style="display: inline-block; padding: 0.25rem 0.75rem; border-radius: 4px; font-size: 0.85rem; 
                                          background: <?php echo $member['is_verified'] ? 'var(--yellow)' : 'var(--light-grey)'; ?>; 
                                          color: var(--navy-blue); font-weight: bold;">
                                        <?php echo $member['is_verified'] ? 'Yes' : 'No'; ?>
                                    </span>
                                </td>
                                <td>
                                    <span style="display: inline-block; padding: 0.25rem 0.75rem; border-radius: 4px; font-size: 0.85rem; 
                                          background: <?php echo $member['is_approved'] ? 'var(--yellow)' : 'var(--light-grey)'; ?>; 
                                          color: var(--navy-blue); font-weight: bold;">
                                        <?php echo $member['is_approved'] ? 'Yes' : 'No'; ?>
                                    </span>
                                </td>
                                <td>
                                    <span style="display: inline-block; padding: 0.25rem 0.75rem; border-radius: 4px; font-size: 0.85rem; 
                                          background: <?php echo $member['payment_status'] ? 'var(--yellow)' : 'var(--light-grey)'; ?>; 
                                          color: var(--navy-blue); font-weight: bold;">
                                        <?php echo $member['payment_status'] ? 'Yes' : 'No'; ?>
                                    </span>
                                </td>
                                <td><?php echo date('M d, Y', strtotime($member['created_at'])); ?></td>
                                <td style="white-space: nowrap;">
                                    <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/edit-member.php?id=<?php echo $member['id']; ?>" 
                                       class="btn btn-secondary" 
                                       style="padding: 0.4rem 0.8rem; margin: 0.25rem; font-size: 0.85rem;">
                                        Edit
                                    </a>
                                    
                                    <?php if ($member['is_verified'] && !$member['is_approved'] && $member['payment_status'] == 1): ?>
                                        <a href="?approve=<?php echo $member['id']; ?>" 
                                           class="btn btn-primary" 
                                           style="padding: 0.4rem 0.8rem; margin: 0.25rem; font-size: 0.85rem;"
                                           onclick="return confirm('Approve this member?');">
                                            Approve
                                        </a>
                                    <?php elseif ($member['is_verified'] && !$member['is_approved'] && $member['payment_status'] == 0): ?>
                                        <button class="btn" 
                                                style="padding: 0.4rem 0.8rem; margin: 0.25rem; font-size: 0.85rem; background: #ccc; color: #666; cursor: not-allowed;"
                                                disabled
                                                title="Payment not completed">
                                            Approve
                                        </button>
                                    <?php endif; ?>
                                </td>
                            </tr>
                        <?php endwhile; ?>
                    </tbody>
                </table>
            </div>
            
            <p style="margin-top: 1rem; color: var(--dark-grey);">
                Total: <?php echo $result->num_rows; ?> member(s)
            </p>
        <?php else: ?>
            <div class="alert alert-info">
                No members found matching your criteria.
            </div>
        <?php endif; ?>
    </div>
</div>

<?php include '../includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 27: management/manage-surveys.php
- Type: PHP
- Size: 3.71 KB
- Path: management
- Name: manage-surveys.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

// Get all survey sites
$sql = "SELECT * FROM survey_sites ORDER BY created_at DESC";
$result = $conn->query($sql);

$page_title = 'Manage Survey Sites';
include '../includes/header.php';
?>

<div class="container">
    <div class="card">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/dashboard.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to Dashboard
        </a>
        
        <div style="display: flex; justify-content: space-between; align-items: center; flex-wrap: wrap; margin-bottom: 1rem;">
            <h1 class="card-title" style="margin-bottom: 0;">Manage Survey Sites</h1>
            <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/add-survey.php" class="btn btn-primary">+ Add New</a>
        </div>
        
        <?php if ($result->num_rows > 0): ?>
            <div style="overflow-x: auto;">
                <table>
                    <thead>
                        <tr>
                            <th>Image</th>
                            <th>Title</th>
                            <th>Website Link</th>
                            <th>Created</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php while ($survey = $result->fetch_assoc()): ?>
                            <tr>
                                <td>
                                    <img src="<?php echo SITE_URL; ?>/uploads/<?php echo htmlspecialchars($survey['image']); ?>" 
                                         alt="<?php echo htmlspecialchars($survey['title']); ?>" 
                                         style="width: 80px; height: 60px; object-fit: cover; border-radius: 4px;">
                                </td>
                                <td><?php echo htmlspecialchars($survey['title']); ?></td>
                                <td>
                                    <a href="<?php echo htmlspecialchars($survey['website_link']); ?>" 
                                       target="_blank" 
                                       style="color: var(--yellow);">
                                        Visit Site →
                                    </a>
                                </td>
                                <td><?php echo date('M d, Y', strtotime($survey['created_at'])); ?></td>
                                <td>
                                    <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/edit-survey.php?id=<?php echo $survey['id']; ?>" 
                                       class="btn btn-secondary" style="padding: 0.5rem 1rem; margin-right: 0.5rem;">Edit</a>
                                    <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/delete-survey.php?id=<?php echo $survey['id']; ?>" 
                                       class="btn btn-danger" 
                                       style="padding: 0.5rem 1rem;"
                                       onclick="return confirm('Are you sure you want to delete this survey site?');">Delete</a>
                                </td>
                            </tr>
                        <?php endwhile; ?>
                    </tbody>
                </table>
            </div>
        <?php else: ?>
            <div class="alert alert-info">
                No survey sites found. <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/add-survey.php" style="color: var(--navy-blue); font-weight: bold;">Add your first survey site</a>
            </div>
        <?php endif; ?>
    </div>
</div>

<?php include '../includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 28: management/manage-tickets.php
- Type: PHP
- Size: 12.79 KB
- Path: management
- Name: manage-tickets.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

// Build query with filters
$where_clauses = ["1=1"];

// Search filter
$search = isset($_GET['search']) ? clean_input($_GET['search']) : '';
if (!empty($search)) {
    $where_clauses[] = "(name LIKE '%$search%' OR email LIKE '%$search%' OR message LIKE '%$search%')";
}

// Status filter
if (isset($_GET['status']) && $_GET['status'] !== '') {
    $status = clean_input($_GET['status']);
    $where_clauses[] = "ticket_status = '$status'";
}

// Type filter (member vs visitor)
if (isset($_GET['type']) && $_GET['type'] !== '') {
    if ($_GET['type'] === 'member') {
        $where_clauses[] = "member_id IS NOT NULL";
    } else {
        $where_clauses[] = "member_id IS NULL";
    }
}

// Sorting
$order_by = "created_at";
$order_dir = "DESC";
if (isset($_GET['sort'])) {
    $allowed_sorts = ['name', 'email', 'created_at', 'ticket_status'];
    if (in_array($_GET['sort'], $allowed_sorts)) {
        $order_by = $_GET['sort'];
    }
}
if (isset($_GET['dir']) && strtoupper($_GET['dir']) === 'ASC') {
    $order_dir = 'ASC';
}

// Build final query
$where_sql = implode(" AND ", $where_clauses);
$sql = "SELECT c.*, m.full_name as member_name 
        FROM contact_messages c 
        LEFT JOIN members m ON c.member_id = m.id 
        WHERE $where_sql 
        ORDER BY $order_by $order_dir";
$result = $conn->query($sql);

// Get statistics
$stats = [
    'new' => $conn->query("SELECT COUNT(*) as count FROM contact_messages WHERE ticket_status = 'new'")->fetch_assoc()['count'],
    'in_progress' => $conn->query("SELECT COUNT(*) as count FROM contact_messages WHERE ticket_status = 'in_progress'")->fetch_assoc()['count'],
    'resolved' => $conn->query("SELECT COUNT(*) as count FROM contact_messages WHERE ticket_status = 'resolved'")->fetch_assoc()['count'],
    'closed' => $conn->query("SELECT COUNT(*) as count FROM contact_messages WHERE ticket_status = 'closed'")->fetch_assoc()['count'],
];

$page_title = 'Manage Tickets';
include '../includes/header.php';
?>

<div class="container">
    <div class="card">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/dashboard.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to Dashboard
        </a>
        
        <h1 class="card-title">Ticket Management</h1>
        
        <!-- Statistics -->
        <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(150px, 1fr)); gap: 1rem; margin-bottom: 2rem;">
            <div style="background: #fff3cd; padding: 1rem; border-radius: 8px; text-align: center; border-left: 4px solid #ffc107;">
                <div style="font-size: 2rem; font-weight: bold; color: var(--navy-blue);"><?php echo $stats['new']; ?></div>
                <div style="font-size: 0.9rem; color: var(--dark-grey);">New</div>
            </div>
            <div style="background: #d1ecf1; padding: 1rem; border-radius: 8px; text-align: center; border-left: 4px solid #17a2b8;">
                <div style="font-size: 2rem; font-weight: bold; color: var(--navy-blue);"><?php echo $stats['in_progress']; ?></div>
                <div style="font-size: 0.9rem; color: var(--dark-grey);">In Progress</div>
            </div>
            <div style="background: #d4edda; padding: 1rem; border-radius: 8px; text-align: center; border-left: 4px solid #28a745;">
                <div style="font-size: 2rem; font-weight: bold; color: var(--navy-blue);"><?php echo $stats['resolved']; ?></div>
                <div style="font-size: 0.9rem; color: var(--dark-grey);">Resolved</div>
            </div>
            <div style="background: var(--light-grey); padding: 1rem; border-radius: 8px; text-align: center; border-left: 4px solid #6c757d;">
                <div style="font-size: 2rem; font-weight: bold; color: var(--navy-blue);"><?php echo $stats['closed']; ?></div>
                <div style="font-size: 0.9rem; color: var(--dark-grey);">Closed</div>
            </div>
        </div>
        
        <!-- Search and Filter Section -->
        <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 2rem;">
            <form method="GET" action="" style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 1rem;">
                <div>
                    <label for="search" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Search</label>
                    <input type="text" id="search" name="search" placeholder="Name, Email, Message" 
                           value="<?php echo htmlspecialchars($search); ?>"
                           style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                </div>
                
                <div>
                    <label for="status" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Status</label>
                    <select id="status" name="status" style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                        <option value="">All Status</option>
                        <option value="new" <?php echo (isset($_GET['status']) && $_GET['status'] === 'new') ? 'selected' : ''; ?>>New</option>
                        <option value="in_progress" <?php echo (isset($_GET['status']) && $_GET['status'] === 'in_progress') ? 'selected' : ''; ?>>In Progress</option>
                        <option value="resolved" <?php echo (isset($_GET['status']) && $_GET['status'] === 'resolved') ? 'selected' : ''; ?>>Resolved</option>
                        <option value="closed" <?php echo (isset($_GET['status']) && $_GET['status'] === 'closed') ? 'selected' : ''; ?>>Closed</option>
                    </select>
                </div>
                
                <div>
                    <label for="type" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Type</label>
                    <select id="type" name="type" style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                        <option value="">All Types</option>
                        <option value="member" <?php echo (isset($_GET['type']) && $_GET['type'] === 'member') ? 'selected' : ''; ?>>Member</option>
                        <option value="visitor" <?php echo (isset($_GET['type']) && $_GET['type'] === 'visitor') ? 'selected' : ''; ?>>Visitor</option>
                    </select>
                </div>
                
                <div style="display: flex; align-items: flex-end; gap: 0.5rem;">
                    <button type="submit" class="btn btn-primary" style="flex: 1;">Filter</button>
                    <a href="?" class="btn btn-secondary" style="padding: 0.75rem 1rem; text-decoration: none;">Reset</a>
                </div>
            </form>
        </div>
        
        <?php if ($result->num_rows > 0): ?>
            <div style="overflow-x: auto;">
                <table>
                    <thead>
                        <tr>
                            <th>ID</th>
                            <th>Type</th>
                            <th><a href="?sort=name&dir=<?php echo ($order_by === 'name' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Name <?php if($order_by === 'name') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th><a href="?sort=email&dir=<?php echo ($order_by === 'email' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Email <?php if($order_by === 'email') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th>Message</th>
                            <th><a href="?sort=ticket_status&dir=<?php echo ($order_by === 'ticket_status' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Status <?php if($order_by === 'ticket_status') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th><a href="?sort=created_at&dir=<?php echo ($order_by === 'created_at' && $order_dir === 'ASC') ? 'DESC' : 'ASC'; ?><?php echo !empty($search) ? '&search=' . urlencode($search) : ''; ?>" style="color: white; text-decoration: none;">Date <?php if($order_by === 'created_at') echo $order_dir === 'ASC' ? '↑' : '↓'; ?></a></th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php while ($ticket = $result->fetch_assoc()): ?>
                            <tr style="<?php echo $ticket['ticket_status'] === 'new' ? 'background-color: #fff9e6;' : ''; ?>">
                                <td><strong>#<?php echo $ticket['id']; ?></strong></td>
                                <td>
                                    <?php if ($ticket['member_id']): ?>
                                        <span style="display: inline-block; padding: 0.25rem 0.75rem; border-radius: 4px; font-size: 0.85rem; background: var(--yellow); color: var(--navy-blue); font-weight: bold;">
                                            Member
                                        </span>
                                    <?php else: ?>
                                        <span style="display: inline-block; padding: 0.25rem 0.75rem; border-radius: 4px; font-size: 0.85rem; background: var(--light-grey); color: var(--navy-blue); font-weight: bold;">
                                            Visitor
                                        </span>
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <?php echo htmlspecialchars($ticket['name']); ?>
                                    <?php if ($ticket['member_name']): ?>
                                        <br><small style="color: var(--dark-grey);">(<?php echo htmlspecialchars($ticket['member_name']); ?>)</small>
                                    <?php endif; ?>
                                </td>
                                <td><?php echo htmlspecialchars($ticket['email']); ?></td>
                                <td style="max-width: 300px;">
                                    <?php 
                                    $msg = htmlspecialchars($ticket['message']);
                                    echo strlen($msg) > 100 ? substr($msg, 0, 100) . '...' : $msg; 
                                    ?>
                                </td>
                                <td>
                                    <?php
                                    $status_colors = [
                                        'new' => 'background: #ffc107; color: #000;',
                                        'in_progress' => 'background: #17a2b8; color: #fff;',
                                        'resolved' => 'background: #28a745; color: #fff;',
                                        'closed' => 'background: #6c757d; color: #fff;'
                                    ];
                                    $status_text = ucfirst(str_replace('_', ' ', $ticket['ticket_status']));
                                    ?>
                                    <span style="display: inline-block; padding: 0.25rem 0.75rem; border-radius: 4px; font-size: 0.85rem; font-weight: bold; <?php echo $status_colors[$ticket['ticket_status']]; ?>">
                                        <?php echo $status_text; ?>
                                    </span>
                                </td>
                                <td><?php echo date('M d, Y', strtotime($ticket['created_at'])); ?></td>
                                <td>
                                    <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/view-ticket.php?id=<?php echo $ticket['id']; ?>" 
                                       class="btn btn-primary" 
                                       style="padding: 0.4rem 0.8rem; font-size: 0.85rem;">
                                        View/Reply
                                    </a>
                                </td>
                            </tr>
                        <?php endwhile; ?>
                    </tbody>
                </table>
            </div>
            
            <p style="margin-top: 1rem; color: var(--dark-grey);">
                Total: <?php echo $result->num_rows; ?> ticket(s)
            </p>
        <?php else: ?>
            <div class="alert alert-info">
                No tickets found matching your criteria.
            </div>
        <?php endif; ?>
    </div>
</div>

<?php include '../includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 29: management/reply-ticket.php
- Type: PHP
- Size: 9.29 KB
- Path: management
- Name: reply-ticket.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

$error = '';
$success = '';
$ticket = null;

// Check if token and ID are provided
if (!isset($_GET['token']) || !isset($_GET['id'])) {
    $error = "Invalid ticket link. Please use the link provided in your email.";
} else {
    $token = clean_input($_GET['token']);
    $ticket_id = (int)$_GET['id'];
    
    // Verify token and get ticket
    $sql = "SELECT * FROM contact_messages 
            WHERE id = $ticket_id 
            AND response_token = '$token' 
            AND member_id IS NULL";
    $result = $conn->query($sql);
    
    if ($result->num_rows == 0) {
        $error = "Invalid or expired ticket link. Please contact support if you need assistance.";
    } else {
        $ticket = $result->fetch_assoc();
        
        // Handle form submission
        if ($_SERVER['REQUEST_METHOD'] === 'POST') {
            $user_reply = clean_input($_POST['user_reply']);
            
            if (empty($user_reply)) {
                $error = "Please enter your response";
            } else {
                // Append user reply to the message
                $updated_message = $ticket['message'] . "\n\n--- User Response ---\n" . $user_reply;
                $updated_message = clean_input($updated_message);
                
                // Update ticket with user's response
                $update_sql = "UPDATE contact_messages SET 
                              message = '$updated_message',
                              ticket_status = 'new'
                              WHERE id = $ticket_id";
                
                if ($conn->query($update_sql)) {
                    $success = "Your response has been submitted successfully! Our support team will review and respond to your follow-up question.";
                    
                    // Refresh ticket data
                    $result = $conn->query($sql);
                    $ticket = $result->fetch_assoc();
                } else {
                    $error = "Failed to submit response. Please try again.";
                }
            }
        }
    }
}

$page_title = 'Respond to Ticket';
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo $page_title; ?> - Paid Survey Hub India</title>
    <link rel="stylesheet" href="<?php echo SITE_URL; ?>/assets/style.css">
</head>
<body style="background-color: var(--light-grey);">
    
<div class="container" style="padding: 2rem 20px;">
    <div style="text-align: center; margin-bottom: 2rem;">
        <a href="<?php echo SITE_URL; ?>/" style="font-size: 1.8rem; font-weight: bold; color: var(--navy-blue); text-decoration: none;">
            <span style="color: var(--yellow);">Paid Survey Hub</span> India
        </a>
    </div>
    
    <div class="card" style="max-width: 700px; margin: 0 auto;">
        <?php if ($error): ?>
            <div style="text-align: center;">
                <div style="font-size: 3rem; margin-bottom: 1rem;">⚠️</div>
                <h1 class="card-title">Access Error</h1>
                <div class="alert alert-error"><?php echo $error; ?></div>
                <div style="margin-top: 2rem;">
                    <a href="<?php echo SITE_URL; ?>/contact.php" class="btn btn-primary">Submit New Ticket</a>
                    <a href="<?php echo SITE_URL; ?>/" class="btn btn-secondary">Go to Homepage</a>
                </div>
            </div>
        <?php elseif ($success): ?>
            <div style="text-align: center;">
                <div style="font-size: 3rem; margin-bottom: 1rem;">✅</div>
                <h1 class="card-title">Response Submitted!</h1>
                <div class="alert alert-success">
                    <?php echo $success; ?>
                </div>
                
                <div style="background: #fff3cd; padding: 1.5rem; border-radius: 8px; margin: 2rem 0; text-align: left;">
                    <p style="line-height: 1.8; margin-bottom: 1rem;">
                        <strong>📧 What happens next:</strong>
                    </p>
                    <ul style="line-height: 1.8; margin-left: 1.5rem;">
                        <li>Our support team will review your follow-up question</li>
                        <li>We will respond to your email within 24 hours</li>
                        <li>You can respond again using the link in our next email</li>
                    </ul>
                </div>
                
                <div style="margin-top: 2rem;">
                    <a href="<?php echo SITE_URL; ?>/" class="btn btn-primary">Go to Homepage</a>
                </div>
            </div>
        <?php elseif ($ticket): ?>
            <h1 class="card-title">Respond to Support Ticket</h1>
            
            <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 2rem;">
                <div style="display: flex; justify-content: space-between; align-items: center; flex-wrap: wrap; margin-bottom: 1rem;">
                    <div>
                        <p style="margin: 0;"><strong>Ticket ID:</strong> #<?php echo $ticket['id']; ?></p>
                        <p style="margin: 0.5rem 0 0 0; font-size: 0.9rem; color: var(--dark-grey);">
                            Submitted: <?php echo date('M j, Y', strtotime($ticket['created_at'])); ?>
                        </p>
                    </div>
                    <?php
                    $status_colors = [
                        'new' => 'background: #ffc107; color: #000;',
                        'in_progress' => 'background: #17a2b8; color: #fff;',
                        'resolved' => 'background: #28a745; color: #fff;',
                        'closed' => 'background: #6c757d; color: #fff;'
                    ];
                    $status_text = ucfirst(str_replace('_', ' ', $ticket['ticket_status']));
                    ?>
                    <span style="display: inline-block; padding: 0.4rem 0.9rem; border-radius: 4px; font-size: 0.9rem; font-weight: bold; <?php echo $status_colors[$ticket['ticket_status']]; ?>">
                        <?php echo $status_text; ?>
                    </span>
                </div>
            </div>
            
            <?php if ($ticket['admin_reply']): ?>
                <div style="background: #d4edda; padding: 1.5rem; border-left: 5px solid #28a745; border-radius: 8px; margin-bottom: 2rem;">
                    <h3 style="color: #155724; margin-bottom: 1rem;">Support Team Response:</h3>
                    <p style="line-height: 1.8; color: #155724; white-space: pre-wrap;"><?php echo nl2br(htmlspecialchars($ticket['admin_reply'])); ?></p>
                    <?php if ($ticket['replied_at']): ?>
                        <p style="margin-top: 1rem; font-size: 0.85rem; color: #155724;">
                            <em>Replied on: <?php echo date('F j, Y \a\t g:i A', strtotime($ticket['replied_at'])); ?></em>
                        </p>
                    <?php endif; ?>
                </div>
            <?php endif; ?>
            
            <div style="background: var(--white); padding: 1.5rem; border: 2px solid var(--light-grey); border-radius: 8px; margin-bottom: 2rem;">
                <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">Your Original Message:</h3>
                <p style="line-height: 1.8; white-space: pre-wrap; color: #555;"><?php echo htmlspecialchars($ticket['message']); ?></p>
            </div>
            
            <div style="background: var(--light-grey); padding: 2rem; border-radius: 8px;">
                <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">💬 Have a follow-up question?</h3>
                <p style="margin-bottom: 1.5rem; line-height: 1.6;">
                    Type your follow-up message below and our support team will respond to your email.
                </p>
                
                <form method="POST" action="">
                    <div class="form-group">
                        <label for="user_reply">Your Follow-up Message *</label>
                        <textarea id="user_reply" name="user_reply" required style="min-height: 150px;" placeholder="Type your follow-up question or additional details here..."><?php echo isset($_POST['user_reply']) ? htmlspecialchars($_POST['user_reply']) : ''; ?></textarea>
                        <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">
                            We will send our response to: <strong><?php echo htmlspecialchars($ticket['email']); ?></strong>
                        </small>
                    </div>
                    
                    <button type="submit" class="btn btn-primary" style="width: 100%;">Submit Follow-up</button>
                </form>
            </div>
            
            <div class="alert alert-info" style="margin-top: 2rem;">
                <strong>📌 Note:</strong> After submitting your follow-up, our support team will review and respond to your email within 24 hours. You will receive another email with our response and a link to continue the conversation if needed.
            </div>
        <?php endif; ?>
    </div>
    
    <div style="text-align: center; margin-top: 2rem; color: var(--dark-grey); font-size: 0.9rem;">
        <p>&copy; <?php echo date('Y'); ?> Paid Survey Hub India. All rights reserved.</p>
    </div>
</div>

</body>
</html>
-------------------- END OF FILE --------------------

### FILE 30: management/settings.php
- Type: PHP
- Size: 5.7 KB
- Path: management
- Name: settings.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

$error = '';
$success = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $payment_amount = clean_input($_POST['payment_amount']);
    $upi_id = clean_input($_POST['upi_id']);
    
    // Validate payment amount
    if (!is_numeric($payment_amount) || $payment_amount < 0) {
        $error = "Please enter a valid payment amount (0 or greater)";
    } else {
        // Update payment amount
        update_setting('payment_amount', $payment_amount);
        update_setting('upi_id', $upi_id);
        
        // Handle QR code upload
        if (isset($_FILES['qr_code']) && $_FILES['qr_code']['error'] == 0) {
            $allowed_types = ['image/jpeg', 'image/jpg', 'image/png'];
            $file_type = $_FILES['qr_code']['type'];
            
            if (!in_array($file_type, $allowed_types)) {
                $error = "Only JPG and PNG images are allowed for QR code";
            } else {
                $file_extension = pathinfo($_FILES['qr_code']['name'], PATHINFO_EXTENSION);
                $new_filename = 'qr_code_' . time() . '.' . $file_extension;
                $upload_path = '../uploads/' . $new_filename;
                
                if (move_uploaded_file($_FILES['qr_code']['tmp_name'], $upload_path)) {
                    // Delete old QR code if exists
                    $old_qr = get_setting('qr_code_path');
                    if (!empty($old_qr) && file_exists('../' . $old_qr)) {
                        unlink('../' . $old_qr);
                    }
                    
                    update_setting('qr_code_path', 'uploads/' . $new_filename);
                } else {
                    $error = "Failed to upload QR code";
                }
            }
        }
        
        if (empty($error)) {
            $success = "Settings updated successfully!";
        }
    }
}

// Get current settings
$payment_amount = get_setting('payment_amount');
$upi_id = get_setting('upi_id');
$qr_code_path = get_setting('qr_code_path');

$page_title = 'Admin Settings';
include '../includes/header.php';
?>

<div class="container">
    <div class="card">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/dashboard.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to Dashboard
        </a>
        
        <h1 class="card-title">Payment Settings</h1>
        
        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <?php if ($success): ?>
            <div class="alert alert-success"><?php echo $success; ?></div>
        <?php endif; ?>
        
        <form method="POST" action="" enctype="multipart/form-data">
            <div class="form-group">
                <label for="payment_amount">Payment Amount (₹) *</label>
                <input type="number" id="payment_amount" name="payment_amount" required 
                       min="0" step="0.01"
                       value="<?php echo htmlspecialchars($payment_amount); ?>">
                <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">
                    Set to 0 for free access. Members will have instant access without payment.
                </small>
            </div>
            
            <div class="form-group">
                <label for="upi_id">UPI ID</label>
                <input type="text" id="upi_id" name="upi_id" 
                       placeholder="yourname@upi"
                       value="<?php echo htmlspecialchars($upi_id); ?>">
                <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">
                    Your UPI ID for receiving payments
                </small>
            </div>
            
            <div class="form-group">
                <?php if (!empty($qr_code_path)): ?>
                    <label>Current QR Code</label>
                    <div style="margin-bottom: 1rem;">
                        <img src="<?php echo SITE_URL . '/' . htmlspecialchars($qr_code_path); ?>" 
                             alt="Current QR Code" 
                             style="max-width: 250px; border-radius: 8px; box-shadow: 0 2px 10px rgba(0,0,0,0.1);">
                    </div>
                <?php endif; ?>
                
                <label for="qr_code">Upload Payment QR Code (Optional)</label>
                <input type="file" id="qr_code" name="qr_code" accept="image/*">
                <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">
                    Upload your UPI payment QR code. Leave empty to keep current QR code.
                </small>
            </div>
            
            <button type="submit" class="btn btn-primary">Update Settings</button>
        </form>
    </div>
    
    <div class="card">
        <h2 class="card-title">Instructions</h2>
        <ul style="list-style: none; padding: 0;">
            <li style="padding: 0.75rem 0; border-bottom: 1px solid var(--light-grey);">
                <strong>Payment Amount:</strong> Set the one-time fee for accessing survey sites. Set to 0 for free access.
            </li>
            <li style="padding: 0.75rem 0; border-bottom: 1px solid var(--light-grey);">
                <strong>UPI ID:</strong> Your UPI ID where members will send payments (e.g., yourname@paytm, yourname@phonepe).
            </li>
            <li style="padding: 0.75rem 0;">
                <strong>QR Code:</strong> Upload a QR code image that members can scan to make payments directly.
            </li>
        </ul>
    </div>
</div>

<?php include '../includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 31: management/view-ticket.php
- Type: PHP
- Size: 17.28 KB
- Path: management
- Name: view-ticket.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

if (!isset($_GET['id'])) {
    redirect(SITE_URL . ADMIN_PATH . '/manage-tickets.php');
}

$ticket_id = (int)$_GET['id'];
$error = '';
$success = '';

// Get ticket details
$sql = "SELECT c.*, m.full_name as member_name, m.phone as member_phone, m.id as member_account_id
        FROM contact_messages c 
        LEFT JOIN members m ON c.member_id = m.id 
        WHERE c.id = $ticket_id";
$result = $conn->query($sql);

if ($result->num_rows == 0) {
    redirect(SITE_URL . ADMIN_PATH . '/manage-tickets.php');
}

$ticket = $result->fetch_assoc();

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $admin_reply = clean_input($_POST['admin_reply']);
    $new_status = clean_input($_POST['ticket_status']);
    $admin_id = $_SESSION['admin_id'];
    
    if (empty($admin_reply)) {
        $error = "Reply message is required";
    } else {
        // Update ticket
        $update_sql = "UPDATE contact_messages SET 
                      admin_reply = '$admin_reply',
                      ticket_status = '$new_status',
                      replied_at = NOW(),
                      replied_by = $admin_id
                      WHERE id = $ticket_id";
        
        if ($conn->query($update_sql)) {
            $success = "Reply sent successfully!";
            
            // Check if this is member or visitor
            $is_member = !empty($ticket['member_id']);
            
            // Send email notification to user
            $email_subject = "Response to Your Query - Ticket #$ticket_id";
            
            if ($is_member) {
                // Member email (existing format)
                $email_message = "
                    <div style='font-family: Arial, sans-serif; max-width: 600px; margin: 0 auto;'>
                        <h2 style='color: #001f3f; border-bottom: 3px solid #FFD700; padding-bottom: 10px;'>
                            Paid Survey Hub - Support Response
                        </h2>
                        
                        <p>Dear " . htmlspecialchars($ticket['name']) . ",</p>
                        
                        <p style='line-height: 1.6;'>Thank you for contacting us. We have reviewed your query and here is our response:</p>
                        
                        <div style='background-color: #f5f5f5; padding: 20px; border-radius: 8px; margin: 20px 0;'>
                            <p style='margin: 0 0 10px 0;'><strong style='color: #001f3f;'>Your Message:</strong></p>
                            <p style='line-height: 1.6; color: #333;'>" . nl2br(htmlspecialchars($ticket['message'])) . "</p>
                        </div>
                        
                        <div style='background-color: #fff; padding: 20px; border-left: 4px solid #FFD700; margin: 20px 0;'>
                            <p style='margin: 0 0 10px 0;'><strong style='color: #001f3f;'>Our Response:</strong></p>
                            <p style='line-height: 1.6; color: #333;'>" . nl2br($admin_reply) . "</p>
                        </div>
                        
                        <div style='background-color: #fff3cd; padding: 15px; border-radius: 5px; margin: 20px 0;'>
                            <p style='margin: 0; font-size: 14px; color: #856404;'>
                                <strong>Ticket #$ticket_id</strong> - Status: " . ucfirst(str_replace('_', ' ', $new_status)) . "
                            </p>
                        </div>
                        
                        <p style='line-height: 1.6;'>You can view your tickets anytime by logging in to your account and visiting the 'My Tickets' section.</p>
                        
                        <div style='text-align: center; margin: 30px 0;'>
                            <a href='" . SITE_URL . "/my-tickets.php' style='background-color: #FFD700; color: #001f3f; padding: 12px 30px; text-decoration: none; border-radius: 5px; font-weight: bold; display: inline-block;'>View My Tickets</a>
                        </div>
                        
                        <p style='line-height: 1.6;'>If you have any further questions, please don't hesitate to contact us again.</p>
                        
                        <div style='margin-top: 30px; padding-top: 20px; border-top: 1px solid #ddd; text-align: center; color: #666; font-size: 12px;'>
                            <p>Best regards,<br>Paid Survey Hub Support Team</p>
                        </div>
                    </div>
                ";
            } else {
                // Visitor email with respond button
                $response_link = SITE_URL . "/reply-ticket.php?token=" . $ticket['response_token'] . "&id=" . $ticket_id;
                
                $email_message = "
                    <div style='font-family: Arial, sans-serif; max-width: 600px; margin: 0 auto;'>
                        <h2 style='color: #001f3f; border-bottom: 3px solid #FFD700; padding-bottom: 10px;'>
                            Paid Survey Hub - Support Response
                        </h2>
                        
                        <p>Dear " . htmlspecialchars($ticket['name']) . ",</p>
                        
                        <p style='line-height: 1.6;'>Thank you for contacting us. We have reviewed your query and here is our response:</p>
                        
                        <div style='background-color: #f5f5f5; padding: 20px; border-radius: 8px; margin: 20px 0;'>
                            <p style='margin: 0 0 10px 0;'><strong style='color: #001f3f;'>Your Message:</strong></p>
                            <p style='line-height: 1.6; color: #333;'>" . nl2br(htmlspecialchars($ticket['message'])) . "</p>
                        </div>
                        
                        <div style='background-color: #fff; padding: 20px; border-left: 4px solid #FFD700; margin: 20px 0;'>
                            <p style='margin: 0 0 10px 0;'><strong style='color: #001f3f;'>Our Response:</strong></p>
                            <p style='line-height: 1.6; color: #333;'>" . nl2br($admin_reply) . "</p>
                        </div>
                        
                        <div style='background-color: #fff3cd; padding: 15px; border-radius: 5px; margin: 20px 0;'>
                            <p style='margin: 0; font-size: 14px; color: #856404;'>
                                <strong>Ticket #$ticket_id</strong> - Status: " . ucfirst(str_replace('_', ' ', $new_status)) . "
                            </p>
                        </div>
                        
                        <div style='background-color: #d4edda; padding: 20px; border-radius: 8px; border-left: 4px solid #28a745; margin: 30px 0;'>
                            <p style='margin: 0 0 15px 0; font-size: 15px; color: #155724;'>
                                <strong>Have a follow-up question?</strong>
                            </p>
                            <p style='margin: 0 0 20px 0; line-height: 1.6; color: #155724;'>
                                Click the button below to respond to this ticket and continue the conversation with our support team.
                            </p>
                            <div style='text-align: center;'>
                                <a href='" . $response_link . "' style='background-color: #FFD700; color: #001f3f; padding: 14px 35px; text-decoration: none; border-radius: 5px; font-weight: bold; display: inline-block; font-size: 16px;'>💬 Respond to Ticket</a>
                            </div>
                        </div>
                        
                        <p style='line-height: 1.6;'>We hope this resolves your query. If you need further assistance, just click the respond button above.</p>
                        
                        <div style='margin-top: 30px; padding-top: 20px; border-top: 1px solid #ddd; text-align: center; color: #666; font-size: 12px;'>
                            <p>Best regards,<br>Paid Survey Hub Support Team</p>
                            <p style='margin-top: 10px;'>Ticket #$ticket_id</p>
                        </div>
                    </div>
                ";
            }
            
            send_email($ticket['email'], $email_subject, $email_message);
            
            // Refresh ticket data
            $result = $conn->query($sql);
            $ticket = $result->fetch_assoc();
        } else {
            $error = "Failed to send reply. Please try again.";
        }
    }
}

$page_title = 'View Ticket';
include '../includes/header.php';
?>

<div class="container">
    <div class="card" style="max-width: 900px; margin: 0 auto;">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-tickets.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to Tickets
        </a>
        
        <div style="display: flex; justify-content: space-between; align-items: center; flex-wrap: wrap; margin-bottom: 1.5rem;">
            <h1 class="card-title" style="margin: 0;">Ticket #<?php echo $ticket['id']; ?></h1>
            <?php
            $status_colors = [
                'new' => 'background: #ffc107; color: #000;',
                'in_progress' => 'background: #17a2b8; color: #fff;',
                'resolved' => 'background: #28a745; color: #fff;',
                'closed' => 'background: #6c757d; color: #fff;'
            ];
            $status_text = ucfirst(str_replace('_', ' ', $ticket['ticket_status']));
            ?>
            <span style="display: inline-block; padding: 0.5rem 1rem; border-radius: 5px; font-size: 1rem; font-weight: bold; <?php echo $status_colors[$ticket['ticket_status']]; ?>">
                <?php echo $status_text; ?>
            </span>
        </div>
        
        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <?php if ($success): ?>
            <div class="alert alert-success"><?php echo $success; ?></div>
        <?php endif; ?>
        
        <!-- Ticket Information -->
        <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 2rem;">
            <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">Ticket Information</h3>
            
            <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(250px, 1fr)); gap: 1.5rem;">
                <div>
                    <p style="margin-bottom: 0.5rem;"><strong>Type:</strong></p>
                    <?php if ($ticket['member_id']): ?>
                        <span style="display: inline-block; padding: 0.35rem 0.85rem; border-radius: 4px; background: var(--yellow); color: var(--navy-blue); font-weight: bold;">
                            Member Query
                        </span>
                    <?php else: ?>
                        <span style="display: inline-block; padding: 0.35rem 0.85rem; border-radius: 4px; background: var(--light-grey); color: var(--navy-blue); font-weight: bold; border: 2px solid var(--dark-grey);">
                            Visitor Query
                        </span>
                    <?php endif; ?>
                </div>
                
                <div>
                    <p style="margin-bottom: 0.5rem;"><strong>Submitted:</strong></p>
                    <p><?php echo date('F j, Y \a\t g:i A', strtotime($ticket['created_at'])); ?></p>
                </div>
                
                <?php if ($ticket['replied_at']): ?>
                <div>
                    <p style="margin-bottom: 0.5rem;"><strong>Last Reply:</strong></p>
                    <p><?php echo date('F j, Y \a\t g:i A', strtotime($ticket['replied_at'])); ?></p>
                </div>
                <?php endif; ?>
            </div>
        </div>
        
        <!-- Contact Details -->
        <div style="background: var(--white); padding: 1.5rem; border: 2px solid var(--light-grey); border-radius: 8px; margin-bottom: 2rem;">
            <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">Contact Details</h3>
            
            <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 1rem;">
                <div>
                    <p style="color: var(--dark-grey); font-size: 0.9rem; margin-bottom: 0.25rem;">Name</p>
                    <p style="font-weight: bold;"><?php echo htmlspecialchars($ticket['name']); ?></p>
                </div>
                
                <div>
                    <p style="color: var(--dark-grey); font-size: 0.9rem; margin-bottom: 0.25rem;">Email</p>
                    <p style="font-weight: bold;"><?php echo htmlspecialchars($ticket['email']); ?></p>
                </div>
                
                <?php if ($ticket['member_id']): ?>
                    <div>
                        <p style="color: var(--dark-grey); font-size: 0.9rem; margin-bottom: 0.25rem;">Member Name</p>
                        <p style="font-weight: bold;"><?php echo htmlspecialchars($ticket['member_name']); ?></p>
                    </div>
                    
                    <div>
                        <p style="color: var(--dark-grey); font-size: 0.9rem; margin-bottom: 0.25rem;">Phone</p>
                        <p style="font-weight: bold;"><?php echo htmlspecialchars($ticket['member_phone']); ?></p>
                    </div>
                    
                    <div>
                        <p style="color: var(--dark-grey); font-size: 0.9rem; margin-bottom: 0.25rem;">Member ID</p>
                        <p style="font-weight: bold;">
                            <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/edit-member.php?id=<?php echo $ticket['member_account_id']; ?>" style="color: var(--yellow);">
                                #<?php echo $ticket['member_account_id']; ?> (View Account)
                            </a>
                        </p>
                    </div>
                <?php endif; ?>
            </div>
        </div>
        
        <!-- User Message -->
        <div style="background: var(--white); padding: 1.5rem; border-left: 5px solid var(--yellow); border-radius: 8px; margin-bottom: 2rem;">
            <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">User Message</h3>
            <p style="line-height: 1.8; white-space: pre-wrap;"><?php echo htmlspecialchars($ticket['message']); ?></p>
        </div>
        
        <?php if ($ticket['admin_reply']): ?>
        <!-- Previous Reply -->
        <div style="background: #d4edda; padding: 1.5rem; border-left: 5px solid #28a745; border-radius: 8px; margin-bottom: 2rem;">
            <h3 style="color: #155724; margin-bottom: 1rem;">Your Previous Reply</h3>
            <p style="line-height: 1.8; white-space: pre-wrap; color: #155724;"><?php echo nl2br(htmlspecialchars($ticket['admin_reply'])); ?></p>
        </div>
        <?php endif; ?>
        
        <!-- Reply Form -->
        <div style="background: var(--light-grey); padding: 2rem; border-radius: 8px;">
            <h3 style="color: var(--navy-blue); margin-bottom: 1rem;">
                <?php echo $ticket['admin_reply'] ? 'Update Reply & Status' : 'Send Reply'; ?>
            </h3>
            
            <form method="POST" action="">
                <div class="form-group">
                    <label for="admin_reply">Your Reply *</label>
                    <textarea id="admin_reply" name="admin_reply" required style="min-height: 150px;" placeholder="Type your response to the user here..."><?php echo isset($_POST['admin_reply']) ? htmlspecialchars($_POST['admin_reply']) : ''; ?></textarea>
                    <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">
                        This reply will be emailed to <?php echo htmlspecialchars($ticket['email']); ?>
                        <?php if (!$ticket['member_id']): ?>
                            <br><strong>Note:</strong> Visitor will receive a "Respond" button in the email to continue the conversation.
                        <?php endif; ?>
                    </small>
                </div>
                
                <div class="form-group">
                    <label for="ticket_status">Ticket Status *</label>
                    <select id="ticket_status" name="ticket_status" required>
                        <option value="new" <?php echo $ticket['ticket_status'] === 'new' ? 'selected' : ''; ?>>New</option>
                        <option value="in_progress" <?php echo $ticket['ticket_status'] === 'in_progress' ? 'selected' : ''; ?>>In Progress</option>
                        <option value="resolved" <?php echo $ticket['ticket_status'] === 'resolved' ? 'selected' : ''; ?>>Resolved</option>
                        <option value="closed" <?php echo $ticket['ticket_status'] === 'closed' ? 'selected' : ''; ?>>Closed</option>
                    </select>
                </div>
                
                <div style="display: flex; gap: 1rem;">
                    <button type="submit" class="btn btn-primary" style="flex: 1;">Send Reply & Update Status</button>
                    <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-tickets.php" class="btn btn-secondary" style="flex: 1; text-align: center;">Cancel</a>
                </div>
            </form>
        </div>
    </div>
</div>

<?php include '../includes/footer.php'; ?>
-------------------- END OF FILE --------------------

### FILE 32: uploads/68e875094c5cd.png
- Type: PNG
- Size: 607.75 KB
- Path: uploads
- Name: 68e875094c5cd.png
------------------------------------------------------------
[IMAGE FILE: PNG - Content not displayed]
-------------------- END OF FILE --------------------

### FILE 33: uploads/68e88a7f0c767.png
- Type: PNG
- Size: 638.63 KB
- Path: uploads
- Name: 68e88a7f0c767.png
------------------------------------------------------------
[IMAGE FILE: PNG - Content not displayed]
-------------------- END OF FILE --------------------

### FILE 34: uploads/68e88a92c53b1.png
- Type: PNG
- Size: 551.55 KB
- Path: uploads
- Name: 68e88a92c53b1.png
------------------------------------------------------------
[IMAGE FILE: PNG - Content not displayed]
-------------------- END OF FILE --------------------

### FILE 35: uploads/68e88b5160c95.png
- Type: PNG
- Size: 921.07 KB
- Path: uploads
- Name: 68e88b5160c95.png
------------------------------------------------------------
[IMAGE FILE: PNG - Content not displayed]
-------------------- END OF FILE --------------------

### FILE 36: uploads/68e88b5c4655f.png
- Type: PNG
- Size: 1.02 MB
- Path: uploads
- Name: 68e88b5c4655f.png
------------------------------------------------------------
[IMAGE FILE: PNG - Content not displayed]
-------------------- END OF FILE --------------------

### FILE 37: uploads/68e88b6790d1b.png
- Type: PNG
- Size: 510.39 KB
- Path: uploads
- Name: 68e88b6790d1b.png
------------------------------------------------------------
[IMAGE FILE: PNG - Content not displayed]
-------------------- END OF FILE --------------------

### FILE 38: uploads/68e88bd4a06c7.png
- Type: PNG
- Size: 1.17 MB
- Path: uploads
- Name: 68e88bd4a06c7.png
------------------------------------------------------------
[IMAGE FILE: PNG - Content not displayed]
-------------------- END OF FILE --------------------

### FILE 39: uploads/68e88bdeaf176.png
- Type: PNG
- Size: 670.89 KB
- Path: uploads
- Name: 68e88bdeaf176.png
------------------------------------------------------------
[IMAGE FILE: PNG - Content not displayed]
-------------------- END OF FILE --------------------

### FILE 40: uploads/68e88be9460c0.png
- Type: PNG
- Size: 1.29 MB
- Path: uploads
- Name: 68e88be9460c0.png
------------------------------------------------------------
[IMAGE FILE: PNG - Content not displayed]
-------------------- END OF FILE --------------------

### FILE 41: uploads/68e88bf2dc063.png
- Type: PNG
- Size: 487.67 KB
- Path: uploads
- Name: 68e88bf2dc063.png
------------------------------------------------------------
[IMAGE FILE: PNG - Content not displayed]
-------------------- END OF FILE --------------------

### FILE 42: uploads/qr_code_1760063901.jpg
- Type: JPG
- Size: 70.3 KB
- Path: uploads
- Name: qr_code_1760063901.jpg
------------------------------------------------------------
[IMAGE FILE: JPG - Content not displayed]
-------------------- END OF FILE --------------------


================================================================================
## SUMMARY
================================================================================

Repository contains 42 files total.
All file contents have been extracted and are shown above.
This repository snapshot was generated on: 2025-10-26 19:07:45

================================================================================
## END OF REPOSITORY
================================================================================