# PSH IN 18 APR 26 001 - REPOSITORY
================================================================================

Project Name: PSH IN 18 APR 26 001
Created: 2026-04-18 03:04:59
Last Updated: 2026-04-18 03:05:05
Source ZIP: PSH IN.zip
Total Files: 29
Total Folders: 8

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

PSH IN 18 APR 26 001/
└── PSH IN/
    ├── about-us.php
    ├── assets/
    │   └── style.css
    ├── config/
    │   └── config.php
    ├── contact.php
    ├── faq.php
    ├── google7106e441233c8b50.html
    ├── includes/
    │   ├── footer.php
    │   └── header.php
    ├── index.php
    ├── management/
    │   ├── add-survey.php
    │   ├── change-password.php
    │   ├── dashboard.php
    │   ├── delete-survey.php
    │   ├── edit-survey.php
    │   ├── includes/
    │   │   ├── footer.php
    │   │   └── header.php
    │   ├── index.php
    │   ├── logout.php
    │   ├── manage-reviews.php
    │   ├── manage-surveys.php
    │   ├── manage-tickets.php
    │   ├── newsletter-subscribers.php
    │   ├── reply-ticket.php
    │   └── view-ticket.php
    ├── privacy-policy.php
    ├── robots.txt
    ├── sitemap.xml
    ├── survey-detail.php
    ├── terms-conditions.php
    └── uploads/
        └── review_proofs

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

### FILE 1: PSH IN/about-us.php
- Type: PHP
- Size: 6.39 KB
- Path: PSH IN
- Name: about-us.php
------------------------------------------------------------
<?php
require_once 'config/config.php';
$page_title       = 'About Paid Survey Hub India — Verified Survey Directory';
$meta_description = 'Learn about Paid Survey Hub India — who we are, why we built the most complete directory of paid survey sites for Indian users, and what makes us different.';
$canonical        = SITE_URL . '/about-us.php';
include 'includes/header.php';
?>

<main class="page-wrap">
<div class="container">

    <!-- Breadcrumb -->
    <nav class="breadcrumb" aria-label="Breadcrumb">
        <a href="<?php echo SITE_URL; ?>/">Home</a>
        <span class="breadcrumb-sep">›</span>
        <span>About Us</span>
    </nav>

    <div class="page-card">
        <h1>About Paid Survey Hub India</h1>

        <div class="page-lead">
            <p>We are a free, independent directory that helps Indians find verified paid survey sites — saving hours of research and protecting you from scams. No membership fees. No signups. Just honest information.</p>
        </div>

        <h2>Our Mission</h2>
        <p>At Paid Survey Hub India, our mission is straightforward: <strong>to connect Indians with genuine, verified paid online survey opportunities</strong> — while cutting through the confusion of finding legitimate platforms in a market full of scams and outdated information.</p>
        <p>India has thousands of people looking for ways to earn supplemental income from home. The online survey industry is a legitimate way to do this — but only if you join the right platforms. We do the research and verification so you don't have to waste time on sites that don't pay, don't accept Indian members, or worse, try to steal your data.</p>

        <h2>Why We Built This</h2>
        <p>The Indian survey-taker faces a specific set of challenges that other markets don't:</p>
        <div class="feature-grid">
            <div class="feature-item">
                <div class="fi-icon">🕵️</div>
                <h4>Too many scam sites</h4>
                <p>Sites that collect your data and never pay. We verify payment history before listing anything.</p>
            </div>
            <div class="feature-item">
                <div class="fi-icon">🌍</div>
                <h4>International sites that block India</h4>
                <p>Many global platforms don't accept Indian registrations. We only list platforms that genuinely work in India.</p>
            </div>
            <div class="feature-item">
                <div class="fi-icon">💳</div>
                <h4>Awkward payment methods</h4>
                <p>PayPal and gift cards don't suit everyone. We highlight UPI and bank transfer options prominently.</p>
            </div>
            <div class="feature-item">
                <div class="fi-icon">⏰</div>
                <h4>Wasted time on bad platforms</h4>
                <p>Getting screened out after 20 minutes, or earning 10 paise per survey. We only list platforms with reasonable payouts.</p>
            </div>
        </div>

        <h2>What Makes Us Different</h2>
        <ul>
            <li><strong>India-specific verification</strong> — every platform is checked for Indian accessibility, not just global reputation.</li>
            <li><strong>No paid listings</strong> — we do not charge survey companies to appear in our directory. Our listings are based on merit only.</li>
            <li><strong>Honest about limitations</strong> — we note when a platform has limited India survey volume, awkward payment methods, or invite-only access.</li>
            <li><strong>Completely free to browse</strong> — no signup, no membership fee, no catches. Open to everyone.</li>
            <li><strong>Regularly updated</strong> — we remove sites that stop paying or stop accepting Indian members. The directory reflects current reality, not outdated information.</li>
        </ul>

        <h2>Who Uses This Directory</h2>
        <div class="audience-grid">
            <div class="audience-card">
                <div class="ac-icon">🎓</div>
                <h4>Students</h4>
            </div>
            <div class="audience-card">
                <div class="ac-icon">🏠</div>
                <h4>Homemakers</h4>
            </div>
            <div class="audience-card">
                <div class="ac-icon">💼</div>
                <h4>Professionals</h4>
            </div>
            <div class="audience-card">
                <div class="ac-icon">🌟</div>
                <h4>Retirees</h4>
            </div>
        </div>
        <p>Anyone looking for genuine supplemental income from home — without investment, without a fixed schedule, and without any special skills.</p>

        <h2>Our Verification Process</h2>
        <p>Before any survey site appears in our directory, we check:</p>
        <ul>
            <li>Does it accept registrations from India? (We test with Indian email addresses and phone numbers)</li>
            <li>Does it have a verified payment history? (We look for independent reviews, payment screenshots, and community feedback)</li>
            <li>Is the minimum payout threshold reasonable for Indian members? (Below ₹1,000 equivalent is our benchmark)</li>
            <li>Are payment methods accessible in India? (UPI, PayPal, gift cards from Indian retailers)</li>
            <li>Is it free to join? (Any platform that charges a registration fee is automatically excluded)</li>
        </ul>

        <h2>Important Disclaimer</h2>
        <p>Paid Survey Hub India is an <strong>information directory only</strong>. We are not a survey company and do not conduct surveys ourselves. We are not affiliated with any of the listed platforms (except Relevant Reflex, which is owned by the same team — disclosed clearly). Earnings from surveys vary by demographic, profile completeness, time invested, and platform availability. We do not guarantee any specific income from any platform listed.</p>

        <div style="text-align:center;margin-top:2.5rem;padding:2rem;background:var(--emerald-pale);border-radius:var(--r-md);border:1.5px solid var(--emerald-light);">
            <h3 style="color:var(--emerald-xd);margin-bottom:.5rem;">Ready to find your first survey site?</h3>
            <p style="margin-bottom:1.25rem;">Browse our full directory — free, no signup required.</p>
            <a href="<?php echo SITE_URL; ?>/" class="btn btn-primary btn-lg">Browse Survey Sites →</a>
        </div>
    </div>

</div>
</main>

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

### FILE 2: PSH IN/contact.php
- Type: PHP
- Size: 7.63 KB
- Path: PSH IN
- Name: contact.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

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

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Honeypot
    if (!empty($_POST['website_field'])) {
        $error = 'Spam detected.';
    } else {
        $name    = trim($conn->real_escape_string(substr($_POST['name']    ?? '', 0, 255)));
        $email   = trim($conn->real_escape_string(substr($_POST['email']   ?? '', 0, 255)));
        $message = trim($conn->real_escape_string(substr($_POST['message'] ?? '', 0, 2000)));

        if (empty($name) || empty($email) || empty($message)) {
            $error = 'All fields are required.';
        } elseif (!filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) {
            $error = 'Please enter a valid email address.';
        } elseif (strlen($message) < 15) {
            $error = 'Please write at least 15 characters in your message.';
        } else {
            // Save to database
            $response_token = md5(uniqid($email, true) . time());
            $sql = "INSERT INTO contact_messages (name, email, message, ticket_status, response_token)
                    VALUES ('$name', '$email', '$message', 'new', '$response_token')";

            if ($conn->query($sql)) {
                $ticket_id = $conn->insert_id;

                // Notify admin via email
                $admin_email   = 'gethelp@paidsurveyhub.in';
                $email_subject = "New Contact Message #$ticket_id — PaidSurveyHub India";
                $email_body    = "New contact form submission on PaidSurveyHub India.\n\n"
                    . "Ticket ID: #$ticket_id\n"
                    . "From: $_POST[name] <$_POST[email]>\n"
                    . "Message:\n$_POST[message]\n\n"
                    . "Manage at: " . SITE_URL . ADMIN_PATH . "/manage-tickets.php";
                $headers = "From: PaidSurveyHub <signupverification@paidsurveyhub.in>\r\nReply-To: $_POST[email]\r\n";
                @mail($admin_email, $email_subject, $email_body, $headers);

                // Auto-reply to sender
                $reply_subject = "We received your message — Paid Survey Hub India (Ticket #$ticket_id)";
                $reply_body    = "Hi $_POST[name],\n\nThank you for contacting Paid Survey Hub India.\n\n"
                    . "We have received your message and will respond to this email within 24 hours.\n\n"
                    . "Your Ticket ID: #$ticket_id\n\n"
                    . "Regards,\nPaid Survey Hub India Team\ngethelp@paidsurveyhub.in\nhttps://paidsurveyhub.in";
                $reply_headers = "From: PaidSurveyHub <signupverification@paidsurveyhub.in>\r\n";
                @mail($_POST['email'], $reply_subject, $reply_body, $reply_headers);

                $success = "Your message has been sent! We will reply to <strong>" . htmlspecialchars($_POST['email']) . "</strong> within 24 hours. Your ticket ID is <strong>#$ticket_id</strong>.";
            } else {
                $error = 'Something went wrong. Please try again or email us directly.';
            }
        }
    }
}

$page_title       = 'Contact Us — Paid Survey Hub India';
$meta_description = 'Contact Paid Survey Hub India. Have a question about our survey directory? Get in touch with our support team.';
$canonical        = SITE_URL . '/contact.php';
include 'includes/header.php';
?>

<main style="padding: 2.5rem 0 4rem; background: var(--slate-50);">
<div class="contact-wrap">

    <!-- Breadcrumb -->
    <nav class="breadcrumb" aria-label="Breadcrumb" style="margin-bottom:1.5rem;">
        <a href="<?php echo SITE_URL; ?>/">Home</a>
        <span class="breadcrumb-sep">›</span>
        <span>Contact Us</span>
    </nav>

    <div class="contact-card">

        <h1 style="font-size:1.75rem;margin-bottom:.4rem;">Contact Us</h1>
        <p style="margin-bottom:0;font-size:.9rem;">Have a question about our directory or a survey site? We'll get back to you within 24 hours.</p>

        <!-- Contact info strip -->
        <div class="contact-info-strip">
            <div class="contact-info-item">
                <div class="ci-label">📧 Email</div>
                <div class="ci-val"><a href="mailto:gethelp@paidsurveyhub.in">gethelp@paidsurveyhub.in</a></div>
            </div>
            <div class="contact-info-item">
                <div class="ci-label">⏱ Response Time</div>
                <div class="ci-val">Within 24 hours</div>
            </div>
        </div>

        <div class="contact-divider"><span>Or send us a message</span></div>

        <?php if (!empty($success)): ?>
        <div class="alert alert-success" style="margin-bottom:1.5rem;">
            ✓ <?php echo $success; ?>
        </div>
        <?php endif; ?>

        <?php if (!empty($error)): ?>
        <div class="alert alert-error" style="margin-bottom:1.5rem;">
            <?php echo htmlspecialchars($error); ?>
        </div>
        <?php endif; ?>

        <?php if (empty($success)): ?>
        <form method="POST" action="" novalidate>
            <!-- Honeypot -->
            <div style="display:none;"><input type="text" name="website_field" tabindex="-1" autocomplete="off"></div>

            <div class="form-group">
                <label for="name">Your Name <span style="color:var(--red);">*</span></label>
                <input type="text" id="name" name="name" class="form-control"
                       placeholder="e.g. Priya Sharma" maxlength="255" required
                       value="<?php echo htmlspecialchars($_POST['name'] ?? ''); ?>">
            </div>

            <div class="form-group">
                <label for="email">Email Address <span style="color:var(--red);">*</span></label>
                <input type="email" id="email" name="email" class="form-control"
                       placeholder="your@email.com" maxlength="255" required
                       value="<?php echo htmlspecialchars($_POST['email'] ?? ''); ?>">
                <div style="font-size:.75rem;color:var(--slate-400);margin-top:.3rem;">We will reply to this address.</div>
            </div>

            <div class="form-group">
                <label for="message">Your Message <span style="color:var(--red);">*</span></label>
                <textarea id="message" name="message" class="form-control" rows="5"
                          placeholder="Describe your question or issue in detail…" maxlength="2000"
                          required><?php echo htmlspecialchars($_POST['message'] ?? ''); ?></textarea>
            </div>

            <button type="submit" class="btn btn-primary btn-lg" style="width:100%;">
                Send Message →
            </button>
        </form>

        <p style="font-size:.78rem;color:var(--slate-400);text-align:center;margin-top:1.1rem;">
            By submitting you agree to our <a href="<?php echo SITE_URL; ?>/privacy-policy.php">Privacy Policy</a>. We never share your details with third parties.
        </p>
        <?php endif; ?>

    </div>

    <!-- Note about what we can help with -->
    <div style="margin-top:1.5rem;background:var(--slate-50);border:1.5px solid var(--slate-200);border-radius:var(--r-md);padding:1.25rem 1.5rem;">
        <p style="font-size:.83rem;color:var(--slate-600);margin:0;"><strong>What we can help with:</strong> Questions about our directory, suggesting a survey site to add, reporting a site that has stopped paying, general questions about survey platforms in India.</p>
        <p style="font-size:.83rem;color:var(--slate-500);margin:.5rem 0 0;"><strong>What we cannot help with:</strong> Account issues, payment disputes, or support tickets for individual survey platforms — please contact those platforms directly using the support links on their detail pages.</p>
    </div>

</div>
</main>

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

### FILE 3: PSH IN/faq.php
- Type: PHP
- Size: 18.37 KB
- Path: PSH IN
- Name: faq.php
------------------------------------------------------------
<?php
require_once 'config/config.php';
$page_title       = 'FAQ — Paid Survey Hub India | Frequently Asked Questions';
$meta_description = 'Answers to common questions about Paid Survey Hub India — how our directory works, what survey sites we list, how to avoid scams, and how to maximise your earnings.';
$canonical        = SITE_URL . '/faq.php';

$extra_schema = '<script type="application/ld+json">' . json_encode([
    "@context" => "https://schema.org",
    "@type"    => "FAQPage",
    "mainEntity" => [
        ["@type"=>"Question","name"=>"What is Paid Survey Hub India?","acceptedAnswer"=>["@type"=>"Answer","text"=>"Paid Survey Hub India is a free, publicly accessible directory that lists verified paid survey websites available to Indian users. We research and test platforms so you can find legitimate opportunities without wasting time on scams."]],
        ["@type"=>"Question","name"=>"Is Paid Survey Hub India free to use?","acceptedAnswer"=>["@type"=>"Answer","text"=>"Yes, completely free. No registration, no membership fee, no catches. You can browse all survey sites, read details, and access full information without creating an account."]],
        ["@type"=>"Question","name"=>"How much can I earn from paid surveys in India?","acceptedAnswer"=>["@type"=>"Answer","text"=>"Most active members on India-focused platforms earn between ₹500 and ₹4,000 per month depending on their demographic profile, daily participation, and the platforms they use. Surveys are supplemental income, not a full-time salary replacement."]],
        ["@type"=>"Question","name"=>"Which survey site is best for UPI payment in India?","acceptedAnswer"=>["@type"=>"Answer","text"=>"Relevant Reflex is currently the only India-built survey platform offering direct UPI payment to PhonePe, Google Pay, and Paytm with a ₹250 minimum payout. International platforms like Swagbucks and Toluna pay via gift cards or PayPal."]],
        ["@type"=>"Question","name"=>"How do I avoid survey scams in India?","acceptedAnswer"=>["@type"=>"Answer","text"=>"Avoid any platform that charges a registration fee, promises unusually high earnings, asks for your bank PIN or OTP, or has no verifiable payment history. All legitimate survey platforms are free to join and pay you — not the other way around."]],
    ]
], JSON_UNESCAPED_SLASHES) . '</script>';

include 'includes/header.php';
?>

<main style="padding: 2.5rem 0 4rem; background: var(--slate-50);">
<div class="faq-page-wrap">

    <!-- Breadcrumb -->
    <nav class="breadcrumb" aria-label="Breadcrumb" style="margin-bottom:1.5rem;">
        <a href="<?php echo SITE_URL; ?>/">Home</a>
        <span class="breadcrumb-sep">›</span>
        <span>FAQ</span>
    </nav>

    <h1 class="faq-page-title">Frequently Asked Questions</h1>
    <p class="faq-page-subtitle">Find answers to common questions about our directory, survey platforms, earnings, and how to stay safe online.</p>

    <!-- ── Section 1: About Us ─────────────────────────────── -->
    <div class="faq-group">
        <div class="faq-group-title">ℹ About Paid Survey Hub India</div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> What is Paid Survey Hub India?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Paid Survey Hub India is a free, publicly accessible directory that lists verified paid survey websites available to Indian users. We research, test, and list platforms that genuinely accept Indian members and have a proven payment history — so you can find legitimate opportunities without wasting time on scams. We are not a survey company and do not conduct surveys ourselves.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Is Paid Survey Hub India free to use?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Yes, completely free. No registration, no membership fee, no hidden charges. You can browse all survey sites, read full details, and access all information without creating an account or providing any personal information.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Are you a survey company?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>No. We are an information directory. We do not conduct surveys, collect survey responses, or pay you for survey participation. We simply list and describe the platforms where you can do all of that. When you click on a survey site, you go directly to that platform's own website.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> How do you verify the survey sites you list?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Before listing any platform we check: (1) Does it accept registrations from India? (2) Does it have a verifiable payment history? (3) Is the minimum payout threshold reasonable for Indian users? (4) Are payment methods accessible in India (UPI, PayPal, Indian retailer gift cards)? (5) Is it free to join? Any platform that fails these checks is not listed.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Is Relevant Reflex related to Paid Survey Hub?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Yes — Relevant Reflex and Paid Survey Hub India are owned by the same team. We disclose this clearly. Relevant Reflex is ranked #1 in our directory because it is the only India-built, UPI-native survey platform. All other listings in our directory are independent platforms from which we receive no compensation for being listed.</p>
            </div>
        </div>
    </div>

    <!-- ── Section 2: Getting Started ────────────────────── -->
    <div class="faq-group" id="getting-started">
        <div class="faq-group-title">🚀 Getting Started with Surveys</div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> How do I start earning from paid surveys in India?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Browse our directory and choose 2–3 platforms that accept your demographic. Register for free on each — it takes 5–10 minutes per platform. Complete your profile thoroughly on day 1. Then log in daily to check for new survey invitations. Once your balance reaches the minimum payout threshold, request a withdrawal to your UPI account.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> How many survey sites should I join?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>We recommend joining 3–5 platforms. No single platform has surveys available every day for every demographic. Joining multiple platforms ensures you always have something to complete. Start with 2–3, get comfortable with the process over 4–6 weeks, then add more if you want to increase your earnings.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Do I need a laptop or will my phone work?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Most survey platforms are fully mobile-optimised and work on Android and iOS smartphones. Some have dedicated apps. Platforms like Relevant Reflex, AttaPoll, and Google Opinion Rewards are specifically designed for mobile. A laptop is not required.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Do I need to be 18 to participate in paid surveys?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Yes. Most survey platforms including all those listed in our directory require members to be at least 18 years old. This is a legal requirement related to contract eligibility and data processing consent.</p>
            </div>
        </div>
    </div>

    <!-- ── Section 3: Earnings ──────────────────────────── -->
    <div class="faq-group">
        <div class="faq-group-title">💰 Earnings & Payments</div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> How much can I earn from paid surveys in India?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Most active members on India-focused platforms earn between ₹500 and ₹4,000 per month. Beginners typically earn ₹500–₹1,500 in their first 1–2 months. Experienced members who use multiple platforms and have complete profiles earn ₹2,000–₹4,000 per month. These are supplemental earnings — not a primary income replacement.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Which survey sites pay via UPI in India?</span>
                <span class="faq-chevron">▼</span>
                </div>
            <div class="faq-a" id="upi-payment">
                <p>Relevant Reflex is currently the only India-built survey platform with native UPI payment (PhonePe, Google Pay, Paytm) with a ₹250 minimum payout. International platforms like Swagbucks and Toluna pay via gift cards or PayPal. OpinionWorld India offers some bank transfer options. Check individual platform detail pages for current payment information.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Why do I keep getting screened out of surveys?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Being screened out means the survey was targeting a specific demographic that doesn't match your profile, or the quota for your demographic was already filled. This is completely normal and happens on every platform worldwide. The fix is to complete your profile surveys thoroughly — the more accurately platforms know your demographics, the better matched your survey invitations will be.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Are survey earnings taxable in India?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Survey earnings are technically income in India. For most people earning ₹1,000–₹4,000 per month from surveys, this is below the taxable threshold when combined with a primary salary or when it is their only income source below the ₹2.5 lakh annual limit. If you consistently earn significantly from surveys, consult a tax professional about your specific situation.</p>
            </div>
        </div>
    </div>

    <!-- ── Section 4: Avoiding Scams ───────────────────── -->
    <div class="faq-group" id="avoid-scams">
        <div class="faq-group-title">🛡️ Avoiding Scams</div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> How do I know if a survey site is a scam?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Red flags to watch for: (1) The site charges a registration or membership fee — legitimate platforms are always free. (2) It promises unusually high earnings like ₹10,000 per day or ₹500 per survey for 5-minute surveys. (3) It asks for your bank PIN, OTP, Aadhaar number, or debit card details. (4) There are no verifiable payment proofs or independent reviews. (5) The website has no contact information or support channel. If any of these apply, do not join.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Are all sites listed in this directory genuine?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>We verify all listed platforms at the time of listing for Indian accessibility and payment history. However, platforms can change over time — their policies, payment methods, or quality of service may change without notice. We recommend doing your own research and starting with small participation before committing significant time to any platform. We update and remove sites regularly based on community feedback.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> What information should I never share with a survey site?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Never share: your bank account PIN, UPI PIN, debit/credit card number, OTP (one-time password), Aadhaar card number, PAN card number, or any government ID. Legitimate survey platforms only need your name, email, and demographic information (age, gender, occupation) to match you with surveys. They only need your UPI ID (not PIN) to send you money.</p>
            </div>
        </div>
    </div>

    <!-- ── Section 5: Tips ──────────────────────────────── -->
    <div class="faq-group" id="tips">
        <div class="faq-group-title">💡 Tips for More Earnings</div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> What's the single most important thing to do after joining?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Complete your profile 100% on day 1. This is the most impactful action you can take. Survey platforms match respondents to surveys based on demographic data. Members with fully completed profiles — including all profiler/lifestyle surveys — receive 3–4x more survey invitations than those with incomplete profiles.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Why should I log in daily even when there are no surveys?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Many surveys close within hours of opening once their respondent quota fills. Members who check daily catch these opportunities; those who check every few days regularly miss surveys that are already closed. A quick 5-minute daily check can significantly increase your monthly earnings over members who participate sporadically.</p>
            </div>
        </div>

        <div class="faq-item">
            <div class="faq-q" onclick="toggleFaq(this)">
                <span><span class="faq-icon-q">▶</span> Does answering honestly really matter?</span>
                <span class="faq-chevron">▼</span>
            </div>
            <div class="faq-a">
                <p>Yes — and it protects you. Survey platforms use quality checks including consistency questions, timing analysis, and response pattern detection. Rushed or inconsistent answers get flagged, the response doesn't get credited, and repeated issues can lead to account suspension. Honest, thoughtful participation is also what unlocks higher-value surveys over time.</p>
            </div>
        </div>
    </div>

    <!-- CTA -->
    <div style="background:linear-gradient(135deg,var(--emerald-xd),var(--emerald-dark));border-radius:var(--r-lg);padding:2.5rem;text-align:center;margin-top:2.5rem;">
        <h3 style="color:#fff;margin-bottom:.4rem;">Ready to find your first survey site?</h3>
        <p style="color:rgba(255,255,255,.8);margin-bottom:1.25rem;font-size:.9rem;">Browse our verified directory — free, no signup needed.</p>
        <a href="<?php echo SITE_URL; ?>/" class="btn btn-white btn-lg">Browse Survey Sites →</a>
    </div>

</div>
</main>

<script>
function toggleFaq(el) {
    var answer = el.nextElementSibling;
    var isOpen = el.classList.contains('open');
    // Close all
    document.querySelectorAll('.faq-q.open').forEach(function(q){
        q.classList.remove('open');
        q.nextElementSibling.classList.remove('open');
    });
    // Open clicked if it was closed
    if (!isOpen) {
        el.classList.add('open');
        answer.classList.add('open');
    }
}
// Open FAQ from anchor hash
window.addEventListener('DOMContentLoaded', function(){
    var hash = window.location.hash;
    if (hash) {
        var target = document.querySelector(hash);
        if (target) {
            setTimeout(function(){ target.scrollIntoView({behavior:'smooth', block:'start'}); }, 200);
        }
    }
});
</script>

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

### FILE 4: PSH IN/google7106e441233c8b50.html
- Type: HTML
- Size: 53 B
- Path: PSH IN
- Name: google7106e441233c8b50.html
------------------------------------------------------------
google-site-verification: google7106e441233c8b50.html
-------------------- END OF FILE --------------------

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

$page_title       = 'Best Paid Survey Sites India 2026 — Verified Directory | PaidSurveyHub';
$meta_description = 'Discover 25+ verified paid survey sites for India in 2026. Compare platforms by payment method, minimum payout, and India availability. All free to join — no investment required.';
$meta_keywords    = 'paid surveys india, online surveys india, best survey sites india, earn money surveys india, survey sites upi payment india, legitimate survey sites india 2026';
$canonical        = SITE_URL . '/';

// Search
$search = isset($_GET['search']) ? trim($conn->real_escape_string($_GET['search'])) : '';
$filter = isset($_GET['filter']) ? trim($conn->real_escape_string($_GET['filter'])) : '';

// Build search condition
$search_condition = '';
if (!empty($search)) {
    $search_condition = " AND (s.title LIKE '%$search%' OR s.description LIKE '%$search%')";
}

// Fetch rank #1 survey
$rank1_sql = "SELECT s.*, COALESCE(AVG(r.rating), 0) as avg_rating, COUNT(r.id) as review_count
              FROM survey_sites s
              LEFT JOIN survey_reviews r ON s.id = r.survey_id AND r.is_approved = 1
              WHERE s.rank = 1 $search_condition
              GROUP BY s.id";
$rank1_result = $conn->query($rank1_sql);
$rank1_survey = ($rank1_result && $rank1_result->num_rows > 0) ? $rank1_result->fetch_assoc() : null;

// Fetch ranks 2-5
$ranked_sql = "SELECT s.*, COALESCE(AVG(r.rating), 0) as avg_rating, COUNT(r.id) as review_count
               FROM survey_sites s
               LEFT JOIN survey_reviews r ON s.id = r.survey_id AND r.is_approved = 1
               WHERE s.rank IS NOT NULL AND s.rank > 1 $search_condition
               GROUP BY s.id ORDER BY s.rank ASC";
$ranked_result = $conn->query($ranked_sql);

// Fetch unranked (randomised)
$unranked_sql = "SELECT s.*, COALESCE(AVG(r.rating), 0) as avg_rating, COUNT(r.id) as review_count
                 FROM survey_sites s
                 LEFT JOIN survey_reviews r ON s.id = r.survey_id AND r.is_approved = 1
                 WHERE s.rank IS NULL $search_condition
                 GROUP BY s.id ORDER BY RAND()";
$unranked_result = $conn->query($unranked_sql);

// Count total
$total_sites = 0;
if ($rank1_survey) $total_sites++;
if ($ranked_result) $total_sites += $ranked_result->num_rows;
if ($unranked_result) $total_sites += $unranked_result->num_rows;

// Schema for ItemList
$schema_items = [];
$schema_pos   = 1;

// Helper: render star HTML
function render_stars($rating) {
    $full  = floor($rating);
    $empty = 5 - $full;
    $stars = str_repeat('★', $full) . str_repeat('☆', $empty);
    return $stars;
}

// Helper: truncate
function trunc($str, $len = 180) {
    return strlen($str) > $len ? substr($str, 0, $len) . '…' : $str;
}

include 'includes/header.php';
?>

<!-- ── Hero ──────────────────────────────────────────────── -->
<section class="hero" aria-label="Hero section">
    <div class="container">
        <div class="hero-inner">
            <div class="mb-1">
                <span class="badge badge-green" style="background:rgba(255,255,255,.15);color:#fff;">🇮🇳 India's Survey Directory</span>
            </div>
            <h1>Find the Best Paid Survey Sites in India</h1>
            <p>We've verified <?php echo $total_sites; ?>+ survey platforms so you don't have to. Compare payment methods, minimum payouts, and India availability — then join the ones that suit you.</p>

            <!-- Search -->
            <form method="GET" action="<?php echo SITE_URL; ?>/" class="hero-search">
                <input type="text" name="search" placeholder="Search survey sites…" value="<?php echo htmlspecialchars($search); ?>" aria-label="Search survey sites">
            </form>

            <div class="flex items-center gap-1" style="justify-content:center;flex-wrap:wrap;gap:.5rem;margin-bottom:.5rem;">
                <a href="<?php echo SITE_URL; ?>/" class="btn btn-white btn-sm">View All Sites</a>
                <a href="<?php echo SITE_URL; ?>/?filter=upi" class="btn btn-outline btn-sm" style="border-color:rgba(255,255,255,.5);color:#fff;">UPI Payment ↗</a>
                <a href="<?php echo SITE_URL; ?>/?filter=india" class="btn btn-outline btn-sm" style="border-color:rgba(255,255,255,.5);color:#fff;">India-Based ↗</a>
            </div>

            <div class="hero-stats">
                <div class="hero-stat"><strong><?php echo $total_sites; ?>+</strong><span>Verified Sites</span></div>
                <div class="hero-stat"><strong>100%</strong><span>Free to Browse</span></div>
                <div class="hero-stat"><strong>2026</strong><span>Updated</span></div>
                <div class="hero-stat"><strong>₹500+</strong><span>Min. Payout Options</span></div>
            </div>
        </div>
    </div>
</section>

<!-- ── Filter Bar ─────────────────────────────────────────── -->
<div class="filter-section">
    <div class="container">
        <div class="filter-inner">
            <span class="filter-label">Filter:</span>
            <div class="filter-btns">
                <a href="<?php echo SITE_URL; ?>/" class="filter-btn <?php echo empty($filter) ? 'active' : ''; ?>">All Sites</a>
                <a href="<?php echo SITE_URL; ?>/?filter=top" class="filter-btn <?php echo $filter=='top' ? 'active' : ''; ?>">⭐ Top Rated</a>
                <a href="<?php echo SITE_URL; ?>/?filter=upi" class="filter-btn <?php echo $filter=='upi' ? 'active' : ''; ?>">💳 UPI Payment</a>
                <a href="<?php echo SITE_URL; ?>/?filter=india" class="filter-btn <?php echo $filter=='india' ? 'active' : ''; ?>">🇮🇳 India-Based</a>
                <a href="<?php echo SITE_URL; ?>/?filter=free" class="filter-btn <?php echo $filter=='free' ? 'active' : ''; ?>">🆓 Free to Join</a>
            </div>
            <?php if (!empty($search)): ?>
            <div style="margin-left:auto;font-size:.82rem;color:var(--text-muted);">
                Results for "<strong><?php echo htmlspecialchars($search); ?></strong>" — <a href="<?php echo SITE_URL; ?>/">Clear</a>
            </div>
            <?php endif; ?>
        </div>
    </div>
</div>

<!-- ── Main Content ───────────────────────────────────────── -->
<main>
<div class="container">

    <?php if (!empty($search) && $total_sites == 0): ?>
        <div class="alert alert-info mt-2">No survey sites found for "<?php echo htmlspecialchars($search); ?>". <a href="<?php echo SITE_URL; ?>/">View all sites</a></div>

    <?php else: ?>

    <!-- ── FEATURED: Rank #1 ─────────────────────────────── -->
    <?php if ($rank1_survey && empty($search)): ?>
    <div class="section-divider">⭐ Our Top Pick for Indian Users</div>

    <article class="featured-wrap" >
        <img src="<?php echo SITE_URL; ?>/uploads/<?php echo htmlspecialchars($rank1_survey['image']); ?>"
             alt="<?php echo htmlspecialchars($rank1_survey['title']); ?> logo"
             class="featured-logo">
        <div class="featured-body">
            <div style="margin-bottom:.4rem;">
                <span class="badge badge-green">🏆 #1 Ranked</span>
                <span class="badge badge-india" style="margin-left:.25rem;">🇮🇳 India-Based</span>
                <span class="badge badge-amber" style="margin-left:.25rem;">💳 UPI Payment</span>
            </div>
            <h2><?php echo htmlspecialchars($rank1_survey['title']); ?></h2>
            <p><?php echo htmlspecialchars(trunc($rank1_survey['description'], 280)); ?></p>
            <div class="featured-meta">
                <span class="featured-pill">✓ Free to Join</span>
                <span class="featured-pill upi">₹250 Min. Payout</span>
                <span class="featured-pill">UPI · PhonePe · GPay · Paytm</span>
                <span class="featured-pill">50,000+ Members</span>
                <span class="featured-pill">Founded 2021</span>
            </div>
            <div class="featured-actions">
                <a href="https://relevantreflex.com/signup.php" target="_blank" rel="noopener" class="btn btn-white btn-lg">Join Free — Earn via UPI ↗</a>
                <a href="<?php echo SITE_URL; ?>/survey-detail.php?id=<?php echo $rank1_survey['id']; ?>" class="btn btn-lg" style="background:rgba(255,255,255,.12);color:#fff;border:2px solid rgba(255,255,255,.3);">View Details</a>
            </div>
            <?php if ($rank1_survey['review_count'] > 0): ?>
            <a href="<?php echo SITE_URL; ?>/survey-detail.php?id=<?php echo $rank1_survey['id']; ?>#reviews"
               style="display:inline-flex;align-items:center;gap:.4rem;margin-top:.85rem;font-size:.82rem;color:rgba(255,255,255,.8);text-decoration:none;">
                <span style="color:#f59e0b;font-size:1rem;letter-spacing:-.02em;"><?php echo render_stars($rank1_survey['avg_rating']); ?></span>
                <strong style="color:#fcd34d;"><?php echo number_format($rank1_survey['avg_rating'], 1); ?>/5</strong>
                <span style="color:rgba(255,255,255,.6);">(<?php echo $rank1_survey['review_count']; ?> member review<?php echo $rank1_survey['review_count'] > 1 ? 's' : ''; ?> — click to read)</span>
            </a>
            <?php endif; ?>
        </div>
    </article>
    <?php endif; ?>

    <!-- ── RANKS 2-5 ──────────────────────────────────────── -->
    <?php if ($ranked_result && $ranked_result->num_rows > 0): ?>
    <div class="section-divider">🥇 Highly Recommended</div>
    <div class="survey-grid survey-grid-2">
    <?php while ($survey = $ranked_result->fetch_assoc()):
        $schema_items[] = [
            'pos'   => $schema_pos++,
            'name'  => $survey['title'],
            'url'   => $survey['website_link'],
            'image' => SITE_URL . '/uploads/' . $survey['image'],
        ];
    ?>
        <article class="survey-card ranked-card" >
            <div class="card-top">
                <img src="<?php echo SITE_URL; ?>/uploads/<?php echo htmlspecialchars($survey['image']); ?>"
                     alt="<?php echo htmlspecialchars($survey['title']); ?> logo"
                     class="card-logo">
                <div class="card-title-row">
                    <h3><?php echo htmlspecialchars($survey['title']); ?></h3>
                    <div class="card-rank-badge">#<?php echo $survey['rank']; ?> Recommended</div>
                </div>
            </div>
            <div class="card-desc"><?php echo htmlspecialchars(trunc($survey['description'], 150)); ?></div>
            <div class="card-footer">
                <div>
                    <?php if ($survey['review_count'] > 0): ?>
                    <div class="card-stars"><?php echo render_stars($survey['avg_rating']); ?></div>
                    <div class="card-reviews"><?php echo number_format($survey['avg_rating'], 1); ?>/5 (<?php echo $survey['review_count']; ?> reviews)</div>
                    <?php endif; ?>
                </div>
                <a href="<?php echo SITE_URL; ?>/survey-detail.php?id=<?php echo $survey['id']; ?>" class="card-link">
                    Details <svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M5 12h14M12 5l7 7-7 7"/></svg>
                </a>
            </div>
        </article>
    <?php endwhile; ?>
    </div>
    <?php endif; ?>

    <!-- ── UNRANKED SITES ─────────────────────────────────── -->
    <?php if ($unranked_result && $unranked_result->num_rows > 0): ?>
    <div class="section-divider">🌐 More Verified Survey Sites</div>
    <div class="survey-grid">
    <?php while ($survey = $unranked_result->fetch_assoc()):
        $schema_items[] = [
            'pos'   => $schema_pos++,
            'name'  => $survey['title'],
            'url'   => $survey['website_link'],
            'image' => SITE_URL . '/uploads/' . $survey['image'],
        ];
    ?>
        <article class="survey-card plain-card" >
            <div class="card-top">
                <img src="<?php echo SITE_URL; ?>/uploads/<?php echo htmlspecialchars($survey['image']); ?>"
                     alt="<?php echo htmlspecialchars($survey['title']); ?> logo"
                     class="card-logo">
                <div class="card-title-row">
                    <h3><?php echo htmlspecialchars($survey['title']); ?></h3>
                </div>
            </div>
            <div class="card-desc"><?php echo htmlspecialchars(trunc($survey['description'], 150)); ?></div>
            <div class="card-footer">
                <div>
                    <?php if ($survey['review_count'] > 0): ?>
                    <div class="card-stars"><?php echo render_stars($survey['avg_rating']); ?></div>
                    <div class="card-reviews"><?php echo number_format($survey['avg_rating'], 1); ?>/5</div>
                    <?php endif; ?>
                </div>
                <a href="<?php echo SITE_URL; ?>/survey-detail.php?id=<?php echo $survey['id']; ?>" class="card-link">
                    Details <svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M5 12h14M12 5l7 7-7 7"/></svg>
                </a>
            </div>
        </article>
    <?php endwhile; ?>
    </div>
    <?php endif; ?>

    <!-- ── INFO CARDS ─────────────────────────────────────── -->
    <?php if (empty($search)): ?>
    <div class="info-strip" style="margin:3rem 0 2.5rem;">
        <div class="info-item">
            <span class="info-emoji">🔍</span>
            <h3>All Sites Verified</h3>
            <p>Every platform is personally tested for Indian accessibility and payment history. We remove non-performing sites regularly.</p>
        </div>
        <div class="info-item">
            <span class="info-emoji">💰</span>
            <h3>Compare &amp; Choose</h3>
            <p>Compare payment methods — UPI, PayPal, gift cards — minimum payouts, and survey frequency before you sign up anywhere.</p>
        </div>
        <div class="info-item">
            <span class="info-emoji">🆓</span>
            <h3>Always Free to Browse</h3>
            <p>This directory is completely free. No signup, no fees, no catches. All survey sites listed are also free to join.</p>
        </div>
    </div>

    <!-- ── CTA Section ────────────────────────────────────── -->
    <div class="cta-section" style="margin-top:4rem;">
        <div style="max-width:580px;margin:0 auto;">
            <div style="font-size:2.5rem;margin-bottom:1rem;">🇮🇳</div>
            <h2 style="font-size:2.1rem;margin-bottom:1rem;">New to Paid Surveys?</h2>
            <p style="font-size:1.05rem;color:rgba(255,255,255,.82);line-height:1.8;margin-bottom:2rem;">
                Start with India's only UPI-native survey platform — built specifically for Indian members since 2021. Free to join. Payments directly to PhonePe, GPay, or Paytm.
            </p>
            <div style="display:flex;flex-direction:column;align-items:center;gap:.75rem;">
                <a href="https://relevantreflex.com/signup.php" target="_blank" rel="noopener"
                   class="btn btn-white" style="font-size:1.05rem;padding:.9rem 2.75rem;border-radius:10px;box-shadow:0 4px 20px rgba(0,0,0,.2);">
                    Join Relevant Reflex Free ↗
                </a>
                <span style="font-size:.8rem;color:rgba(255,255,255,.5);">50,000+ members &nbsp;·&nbsp; ₹250 min. payout &nbsp;·&nbsp; No investment</span>
            </div>
        </div>
    </div>
    <?php endif; ?>

    <?php endif; // end search empty check ?>

</div><!-- /container -->
</main>

<?php
// Inject ItemList schema
if (!empty($schema_items)):
    $items_json = [];
    foreach ($schema_items as $si) {
        $items_json[] = [
            "@type"    => "ListItem",
            "position" => $si['pos'],
            "item"     => [
                "@type" => "Thing",
                "@id"   => $si['url'],
                "name"  => $si['name'],
                "image" => $si['image'],
                "url"   => $si['url'],
            ],
        ];
    }
    $schema = [
        "@context" => "https://schema.org",
        "@type"    => "ItemList",
        "name"     => "Best Paid Survey Sites in India 2026",
        "description" => "Verified directory of paid survey platforms that accept Indian members",
        "numberOfItems" => count($schema_items),
        "itemListElement" => $items_json,
    ];
    echo '<script type="application/ld+json">' . json_encode($schema, JSON_UNESCAPED_SLASHES) . '</script>';
endif;
?>

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

### FILE 6: PSH IN/privacy-policy.php
- Type: PHP
- Size: 5.97 KB
- Path: PSH IN
- Name: privacy-policy.php
------------------------------------------------------------
<?php
require_once 'config/config.php';
$page_title       = 'Privacy Policy — Paid Survey Hub India';
$meta_description = 'Privacy Policy for Paid Survey Hub India. Learn how we collect, use and protect your information as a free survey directory.';
$canonical        = SITE_URL . '/privacy-policy.php';
$robots           = 'index, follow';
include 'includes/header.php';
?>

<main class="page-wrap">
<div class="container">

    <nav class="breadcrumb" aria-label="Breadcrumb">
        <a href="<?php echo SITE_URL; ?>/">Home</a>
        <span class="breadcrumb-sep">›</span>
        <span>Privacy Policy</span>
    </nav>

    <div class="page-card">
        <h1>Privacy Policy</h1>
        <p class="text-muted" style="margin-bottom:1.5rem;font-size:.85rem;"><strong>Last Updated:</strong> April 10, 2026</p>

        <div class="page-lead">
            <p>Paid Survey Hub India is a free, publicly accessible directory. We do not require you to create an account or provide personal information to browse our content. This policy explains what limited data we do collect and how we use it.</p>
        </div>

        <h2>1. What We Are</h2>
        <p>Paid Survey Hub India (paidsurveyhub.in) is a free information directory listing verified paid survey websites available to Indian users. You do not need to register, create an account, or provide any personal information to use this website.</p>

        <h2>2. Information We Collect</h2>

        <h3>Information You Provide</h3>
        <p>We only collect personal information when you choose to contact us via our contact form. This includes your name and email address — used solely to respond to your enquiry.</p>

        <h3>Automatically Collected Information</h3>
        <p>Like all websites, we automatically collect limited technical information when you visit, including:</p>
        <ul>
            <li>IP address (anonymised)</li>
            <li>Browser type and version</li>
            <li>Device type (desktop/mobile)</li>
            <li>Pages visited and time spent</li>
            <li>Referring website (how you found us)</li>
        </ul>
        <p>This information is collected by Google Analytics and Google Ads (gtag.js) in anonymised form. We use it to understand which content is most useful to visitors and to improve the directory.</p>

        <h2>3. How We Use Your Information</h2>
        <ul>
            <li><strong>Contact enquiries:</strong> To respond to messages you send via our contact form</li>
            <li><strong>Analytics:</strong> To understand visitor behaviour and improve our content (anonymised data only)</li>
            <li><strong>Security:</strong> To detect and prevent malicious activity or abuse</li>
        </ul>
        <p>We do not use your information for marketing, we do not sell it to third parties, and we do not share it with survey companies listed in our directory.</p>

        <h2>4. Cookies</h2>
        <p>We use cookies in the following ways:</p>
        <ul>
            <li><strong>Google Analytics:</strong> Anonymised usage statistics. You can opt out via <a href="https://tools.google.com/dlpage/gaoptout" target="_blank" rel="noopener">Google's opt-out tool</a>.</li>
            <li><strong>Google Ads:</strong> Conversion tracking for our own advertising campaigns. This does not affect your browsing experience.</li>
            <li><strong>Essential cookies:</strong> Required for basic site functionality (no personal data stored).</li>
        </ul>
        <p>You can control cookie preferences through your browser settings. Disabling cookies will not affect your ability to browse this directory.</p>

        <h2>5. Third-Party Survey Websites</h2>
        <p>Our directory contains links to third-party survey websites. When you click through to these sites:</p>
        <ul>
            <li>You are leaving paidsurveyhub.in and entering a third-party website</li>
            <li>Each survey site has its own privacy policy and data practices</li>
            <li>We have no control over and take no responsibility for third-party data practices</li>
            <li>We strongly recommend reviewing the privacy policy of any survey site before registering</li>
        </ul>

        <h2>6. Data Security</h2>
        <p>We implement standard security measures to protect any information collected. Contact form submissions are transmitted securely. However, no internet transmission is 100% secure and we cannot guarantee absolute security.</p>

        <h2>7. Data Retention</h2>
        <p>Contact form enquiries are retained for up to 12 months and then deleted. Anonymised analytics data is retained as per Google Analytics default settings (26 months).</p>

        <h2>8. Your Rights</h2>
        <p>You have the right to:</p>
        <ul>
            <li>Request access to any personal information we hold about you</li>
            <li>Request correction of inaccurate information</li>
            <li>Request deletion of your information</li>
            <li>Object to processing of your information</li>
        </ul>
        <p>To exercise any of these rights, contact us via our <a href="<?php echo SITE_URL; ?>/contact.php">contact form</a> or email <a href="mailto:gethelp@paidsurveyhub.in">gethelp@paidsurveyhub.in</a>.</p>

        <h2>9. Children's Privacy</h2>
        <p>This website is not intended for individuals under 18 years of age. We do not knowingly collect information from anyone under 18.</p>

        <h2>10. Changes to This Policy</h2>
        <p>We may update this Privacy Policy periodically. The "Last Updated" date above reflects the most recent revision. Material changes will be noted on this page.</p>

        <h2>11. Contact Us</h2>
        <p>For any privacy-related questions or concerns:</p>
        <ul>
            <li>Email: <a href="mailto:gethelp@paidsurveyhub.in">gethelp@paidsurveyhub.in</a></li>
            <li>Contact form: <a href="<?php echo SITE_URL; ?>/contact.php">paidsurveyhub.in/contact.php</a></li>
        </ul>
    </div>

</div>
</main>

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

### FILE 7: PSH IN/robots.txt
- Type: TXT
- Size: 132 B
- Path: PSH IN
- Name: robots.txt
------------------------------------------------------------
User-agent: *
Allow: /
Disallow: /management/
Disallow: /config/
Disallow: /includes/

Sitemap: https://paidsurveyhub.in/sitemap.xml
-------------------- END OF FILE --------------------

### FILE 8: PSH IN/sitemap.xml
- Type: XML
- Size: 3.75 KB
- Path: PSH IN
- Name: sitemap.xml
------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">

  <!-- Core Pages -->
  <url>
    <loc>https://www.paidsurveyhub.in/</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>weekly</changefreq>
    <priority>1.0</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/about-us.php</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.7</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/faq.php</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.8</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/contact.php</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.5</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/privacy-policy.php</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>yearly</changefreq>
    <priority>0.3</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/terms-conditions.php</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>yearly</changefreq>
    <priority>0.3</priority>
  </url>

  <!-- Survey Detail Pages - update IDs based on your actual DB -->
  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=1</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.9</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=4</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.8</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=20</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.8</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=6</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.8</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=9</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.8</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=2</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.7</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=3</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.7</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=7</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.7</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=8</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.7</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=10</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.7</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=15</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.7</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=16</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.7</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=19</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.7</priority>
  </url>

  <url>
    <loc>https://www.paidsurveyhub.in/survey-detail.php?id=21</loc>
    <lastmod>2026-04-10</lastmod>
    <changefreq>monthly</changefreq>
    <priority>0.7</priority>
  </url>

</urlset>
-------------------- END OF FILE --------------------

### FILE 9: PSH IN/survey-detail.php
- Type: PHP
- Size: 46.74 KB
- Path: PSH IN
- Name: survey-detail.php
------------------------------------------------------------
<?php
require_once 'config/config.php';

if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    header('Location: ' . SITE_URL . '/');
    exit;
}
$survey_id = (int)$_GET['id'];

// Fetch survey
$sql = "SELECT s.*, COALESCE(AVG(r.rating), 0) as avg_rating, COUNT(r.id) as review_count
        FROM survey_sites s
        LEFT JOIN survey_reviews r ON s.id = r.survey_id AND r.is_approved = 1
        WHERE s.id = $survey_id GROUP BY s.id";
$result = $conn->query($sql);
if (!$result || $result->num_rows == 0) {
    header('Location: ' . SITE_URL . '/');
    exit;
}
$survey = $result->fetch_assoc();

// Check if proof columns exist before selecting them
$proof_cols = '';
$cols_result = $conn->query("SHOW COLUMNS FROM survey_reviews LIKE 'proof_file'");
if ($cols_result && $cols_result->num_rows > 0) {
    $proof_cols = ', proof_file, proof_type';
}

// Fetch approved reviews
$reviews_sql = "SELECT rating, feedback{$proof_cols}, reviewer_name, reviewer_location, reviewer_email, created_at, helpful_count
                FROM survey_reviews
                WHERE survey_id = $survey_id AND is_approved = 1
                ORDER BY created_at DESC LIMIT 20";
$reviews_result = $conn->query($reviews_sql);

// Rating breakdown
$breakdown_sql = "SELECT rating, COUNT(*) as cnt FROM survey_reviews
                  WHERE survey_id = $survey_id AND is_approved = 1
                  GROUP BY rating ORDER BY rating DESC";
$breakdown_result = $conn->query($breakdown_sql);
$breakdown = [5=>0, 4=>0, 3=>0, 2=>0, 1=>0];
if ($breakdown_result) {
    while ($row = $breakdown_result->fetch_assoc()) {
        $breakdown[(int)$row['rating']] = (int)$row['cnt'];
    }
}

// Handle review submission
$review_success = false;
$review_error   = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['submit_review'])) {
    // Honeypot spam check
    if (!empty($_POST['website_url'])) {
        $review_error = 'Spam detected.';
    } else {
        $rating             = (int)($_POST['rating'] ?? 0);
        $feedback           = trim($conn->real_escape_string($_POST['feedback'] ?? ''));
        $name               = trim($conn->real_escape_string(substr($_POST['reviewer_name'] ?? '', 0, 100)));
        $location           = trim($conn->real_escape_string(substr($_POST['reviewer_location'] ?? '', 0, 100)));
        $email_raw          = trim($_POST['reviewer_email'] ?? '');
        $newsletter_consent = isset($_POST['newsletter_consent']) ? 1 : 0;
        $ip                 = $conn->real_escape_string($_SERVER['REMOTE_ADDR'] ?? '');

        // Validate
        if ($rating < 1 || $rating > 5) {
            $review_error = 'Please select a star rating.';
        } elseif (empty($name)) {
            $review_error = 'Please enter your name.';
        } elseif (empty($email_raw) || !filter_var($email_raw, FILTER_VALIDATE_EMAIL)) {
            $review_error = 'Please enter a valid email address. Your email is required to verify your review.';
        } elseif (strlen($feedback) < 20) {
            $review_error = 'Please write at least 20 characters in your review.';
        } else {
            $email = $conn->real_escape_string(substr($email_raw, 0, 255));

            // Handle proof file upload
            $proof_file = null;
            $proof_type = null;
            if (!empty($_FILES['proof_file']['name']) && $_FILES['proof_file']['error'] === UPLOAD_ERR_OK) {
                $allowed_types = ['image/jpeg','image/jpg','image/png','image/gif','application/pdf'];
                $file_type     = mime_content_type($_FILES['proof_file']['tmp_name']);
                $file_size     = $_FILES['proof_file']['size'];
                if (!in_array($file_type, $allowed_types)) {
                    $review_error = 'Only JPG, PNG, GIF images or PDF files are allowed as proof.';
                } elseif ($file_size > 5 * 1024 * 1024) {
                    $review_error = 'Proof file must be under 5MB.';
                } else {
                    $ext        = pathinfo($_FILES['proof_file']['name'], PATHINFO_EXTENSION);
                    $proof_file = 'review_proof_' . time() . '_' . rand(1000,9999) . '.' . strtolower($ext);
                    $upload_dir = 'uploads/review_proofs/';
                    if (!is_dir($upload_dir)) mkdir($upload_dir, 0755, true);
                    if (!move_uploaded_file($_FILES['proof_file']['tmp_name'], $upload_dir . $proof_file)) {
                        $proof_file = null;
                    } else {
                        $proof_type = (strpos($file_type, 'pdf') !== false) ? 'pdf' : 'image';
                    }
                }
            }

            if (!$review_error) {
                // Rate limiting — 1 review per IP per survey per day
                $rate_check  = "SELECT COUNT(*) as cnt FROM survey_reviews
                                WHERE survey_id = $survey_id AND ip_address = '$ip'
                                AND created_at > DATE_SUB(NOW(), INTERVAL 24 HOUR)";
                $rate_row    = $conn->query($rate_check)->fetch_assoc();

                // Same email check
                $email_check = "SELECT COUNT(*) as cnt FROM survey_reviews
                                WHERE survey_id = $survey_id AND reviewer_email = '$email'";
                $email_row   = $conn->query($email_check)->fetch_assoc();

                if ($rate_row['cnt'] > 0) {
                    $review_error = 'You have already submitted a review for this platform today. Please wait 24 hours.';
                } elseif ($email_row['cnt'] > 0) {
                    $review_error = 'A review from this email address already exists for this platform.';
                } else {
                    $name_val       = !empty($name) ? "'$name'" : "'Anonymous'";
                    $loc_val        = !empty($location) ? "'" . $conn->real_escape_string($location) . "'" : "NULL";
                    $proof_file_val = $proof_file ? "'" . $conn->real_escape_string($proof_file) . "'" : "NULL";
                    $proof_type_val = $proof_type ? "'" . $conn->real_escape_string($proof_type) . "'" : "NULL";

                    // Build INSERT — include proof columns only if they exist
                    $proof_col_sql = $proof_cols ? ", proof_file, proof_type" : "";
                    $proof_val_sql = $proof_cols ? ", {$proof_file_val}, {$proof_type_val}" : "";

                    $insert = "INSERT INTO survey_reviews
                               (survey_id, member_id, reviewer_name, reviewer_location, reviewer_email,
                                newsletter_consent, rating, feedback, is_approved, ip_address{$proof_col_sql})
                               VALUES ($survey_id, NULL, $name_val, $loc_val, '$email',
                                       $newsletter_consent, $rating, '$feedback', 0, '$ip'{$proof_val_sql})";

                    if ($conn->query($insert)) {
                        if ($newsletter_consent) {
                            $survey_name_esc = $conn->real_escape_string($survey['title']);
                            $sub_sql = "INSERT INTO newsletter_subscribers
                                        (email, name, source, source_survey_id, source_survey_name, ip_address)
                                        VALUES ('$email', $name_val, 'review_form', $survey_id, '$survey_name_esc', '$ip')
                                        ON DUPLICATE KEY UPDATE is_active=1, unsubscribed_at=NULL,
                                        name=COALESCE(name, $name_val)";
                            $conn->query($sub_sql);
                        }
                        $review_success = true;
                    } else {
                        $review_error = 'Something went wrong. Please try again.';
                    }
                }
            }
        }
    }
}

// Helper: parse contact field → smart display
function parse_contact($contact) {
    $contact = trim($contact);
    if (empty($contact)) return null;

    // Check if it contains an email
    if (filter_var($contact, FILTER_VALIDATE_EMAIL)) {
        return ['type' => 'email', 'value' => $contact, 'display' => $contact];
    }

    // Check if contains email within text
    if (preg_match('/[\w.+-]+@[\w-]+\.[\w.]+/', $contact, $m)) {
        return ['type' => 'email', 'value' => $m[0], 'display' => $m[0]];
    }

    // It's a URL — extract domain for display
    $url = $contact;
    if (!preg_match('/^https?:\/\//', $url)) $url = 'https://' . $url;
    $parsed = parse_url($url);
    $domain = $parsed['host'] ?? $url;
    $domain = preg_replace('/^www\./', '', $domain);
    return ['type' => 'url', 'value' => $url, 'display' => 'Contact Form (' . $domain . ')'];
}

function mask_email($email) {
    if (empty($email)) return '';
    $parts = explode('@', $email);
    if (count($parts) !== 2) return '***@***.***';
    $name   = $parts[0];
    $domain = $parts[1];
    $masked_name = substr($name, 0, 1) . str_repeat('*', max(2, strlen($name) - 1));
    $domain_parts = explode('.', $domain);
    $masked_domain = substr($domain_parts[0], 0, 1) . str_repeat('*', max(2, strlen($domain_parts[0]) - 1));
    $tld = implode('.', array_slice($domain_parts, 1));
    return $masked_name . '@' . $masked_domain . '.' . $tld;
}

function render_stars_html($rating, $size = '1rem') {
    $full  = floor($rating);
    $empty = 5 - $full;
    $html  = '<span style="color:#d97706;font-size:' . $size . ';letter-spacing:-.03em;">';
    $html .= str_repeat('★', $full) . '<span style="color:#cbd5e1;">' . str_repeat('★', $empty) . '</span>';
    $html .= '</span>';
    return $html;
}

$contact_info = parse_contact($survey['support_contact']);
$total_reviews = (int)$survey['review_count'];
$avg_rating    = round($survey['avg_rating'], 1);

$page_title       = htmlspecialchars($survey['title']) . ' Review 2026 — Is it Legitimate? | PaidSurveyHub India';
$meta_description = 'Read verified member reviews of ' . htmlspecialchars($survey['title']) . '. See star ratings, honest feedback from Indian users, payment details, and whether it\'s worth joining in 2026.';
$canonical        = SITE_URL . '/survey-detail.php?id=' . $survey_id;

$extra_schema = '';
// Always output Product schema — include offers (required by Google) and aggregateRating when available
$schema_data = [
    "@context"    => "https://schema.org",
    "@type"       => "Product",
    "name"        => $survey['title'],
    "url"         => $survey['website_link'],
    "image"       => SITE_URL . '/uploads/' . $survey['image'],
    "description" => substr(strip_tags($survey['description']), 0, 300),
    "offers"      => [
        "@type"         => "Offer",
        "price"         => "0",
        "priceCurrency" => "INR",
        "description"   => "Free to join — no registration fee",
        "availability"  => "https://schema.org/InStock",
    ],
];
if ($total_reviews > 0) {
    $schema_data["aggregateRating"] = [
        "@type"       => "AggregateRating",
        "ratingValue" => $avg_rating,
        "reviewCount" => (int)$total_reviews,
        "bestRating"  => 5,
        "worstRating" => 1,
    ];
}
$extra_schema = '<script type="application/ld+json">' . json_encode($schema_data, JSON_UNESCAPED_SLASHES) . '</script>';

include 'includes/header.php';
?>

<style>
/* ── Review-specific styles ───────────────────────────────── */
.star-picker { display: flex; flex-direction: row-reverse; gap: .2rem; justify-content: flex-end; }
.star-picker input { display: none; }
.star-picker label {
    font-size: 2rem; cursor: pointer; color: #cbd5e1;
    transition: color .1s; line-height: 1;
}
.star-picker input:checked ~ label,
.star-picker label:hover,
.star-picker label:hover ~ label { color: #d97706; }

.rating-bar-wrap { display: flex; align-items: center; gap: .75rem; margin-bottom: .35rem; }
.rating-bar-label { font-size: .78rem; font-weight: 600; color: var(--slate-600); width: 40px; text-align: right; white-space: nowrap; }
.rating-bar-track { flex: 1; height: 8px; background: var(--slate-100); border-radius: 99px; overflow: hidden; }
.rating-bar-fill  { height: 8px; background: #d97706; border-radius: 99px; transition: width .4s; }
.rating-bar-count { font-size: .75rem; color: var(--slate-400); width: 28px; }

.review-card {
    border: 1.5px solid var(--slate-200); border-radius: var(--r-md);
    padding: 1.25rem; margin-bottom: 1rem;
    transition: box-shadow .2s;
}
.review-card:hover { box-shadow: var(--shadow-sm); }
.review-header { display: flex; justify-content: space-between; align-items: flex-start; margin-bottom: .6rem; flex-wrap: wrap; gap: .5rem; }
.reviewer-info {}
.reviewer-name { font-family: var(--font-head); font-weight: 700; font-size: .92rem; color: var(--slate-800); }
.reviewer-meta { font-size: .75rem; color: var(--slate-400); margin-top: .1rem; }
.review-date   { font-size: .75rem; color: var(--slate-400); }
.review-text   { font-size: .87rem; color: var(--slate-600); line-height: 1.75; margin-top: .5rem; }
.verified-badge { display: inline-flex; align-items: center; gap: .2rem; font-size: .68rem; font-weight: 700; color: #059669; background: #d1fae5; padding: .15rem .5rem; border-radius: 99px; }

.big-rating { text-align: center; }
.big-rating .score { font-family: var(--font-head); font-size: 3.5rem; font-weight: 800; color: var(--slate-900); line-height: 1; }
.big-rating .out-of { font-size: .85rem; color: var(--slate-400); }
.big-rating .stars-row { margin: .35rem 0; font-size: 1.4rem; letter-spacing: -.02em; }
.big-rating .total-txt { font-size: .8rem; color: var(--slate-500); }

.contact-link { display: inline-flex; align-items: center; gap: .3rem; font-size: .87rem; font-weight: 600; color: var(--emerald); }
.contact-link svg { width: 14px; height: 14px; flex-shrink: 0; }
</style>

<main style="padding: 1.5rem 0 3.5rem;">
<div class="container">

    <!-- Breadcrumb -->
    <nav class="breadcrumb" aria-label="Breadcrumb">
        <a href="<?php echo SITE_URL; ?>/">Home</a>
        <span class="breadcrumb-sep">›</span>
        <a href="<?php echo SITE_URL; ?>/">Survey Sites</a>
        <span class="breadcrumb-sep">›</span>
        <span><?php echo htmlspecialchars($survey['title']); ?></span>
    </nav>

    <!-- ── Survey Hero Card ───────────────────────────────── -->
    <div class="detail-hero-card">
        <img src="<?php echo SITE_URL; ?>/uploads/<?php echo htmlspecialchars($survey['image']); ?>"
             alt="<?php echo htmlspecialchars($survey['title']); ?> logo"
             class="detail-logo">
        <div class="detail-info">
            <?php if ($survey['rank']): ?>
            <div style="margin-bottom:.4rem;"><span class="badge badge-amber">🏆 Rank #<?php echo $survey['rank']; ?> in India</span></div>
            <?php endif; ?>
            <h1 style="font-size:1.55rem;margin-bottom:.4rem;"><?php echo htmlspecialchars($survey['title']); ?></h1>

            <?php if ($total_reviews > 0): ?>
            <div style="display:flex;align-items:center;gap:.6rem;flex-wrap:wrap;margin-bottom:.6rem;">
                <?php echo render_stars_html($avg_rating, '1.15rem'); ?>
                <strong style="font-size:.95rem;"><?php echo $avg_rating; ?>/5</strong>
                <span style="font-size:.82rem;color:var(--slate-500);"><?php echo $total_reviews; ?> review<?php echo $total_reviews>1?'s':''; ?></span>
            </div>
            <?php endif; ?>

            <div class="detail-meta">
                <span class="badge badge-emerald">✓ Verified</span>
                <span class="badge badge-slate">🆓 Free to Join</span>
                <?php if ($survey['id'] == 1): ?>
                <span class="badge badge-india">🇮🇳 India-Based</span>
                <span class="badge badge-blue">💳 UPI Payment</span>
                <?php endif; ?>
            </div>

            <div class="detail-actions">
                <a href="<?php echo htmlspecialchars($survey['website_link']); ?>"
                   target="_blank" rel="noopener sponsored"
                   class="btn btn-primary">Visit <?php echo htmlspecialchars($survey['title']); ?> ↗</a>
                <a href="#write-review" class="btn btn-outline btn-sm">✍ Write a Review</a>
                <a href="<?php echo SITE_URL; ?>/" class="btn btn-ghost btn-sm">← All Sites</a>
            </div>
        </div>
    </div>

    <!-- ── Main 2-col layout ─────────────────────────────── -->
    <div class="detail-grid">

        <!-- Left Column -->
        <div>

            <!-- About -->
            <div class="detail-section">
                <h2 style="font-size:1.1rem;">About <?php echo htmlspecialchars($survey['title']); ?></h2>
                <div style="font-size:.88rem;color:var(--slate-600);line-height:1.85;">
                    <?php echo nl2br(htmlspecialchars($survey['description'])); ?>
                </div>
            </div>

            <!-- How to Get Started -->
            <div class="detail-section">
                <h3>How to Get Started</h3>
                <ol style="margin-left:1.25rem;line-height:2.1;font-size:.88rem;color:var(--slate-600);">
                    <li>Click "Visit <?php echo htmlspecialchars($survey['title']); ?>" above to go to their website</li>
                    <li>Click "Sign Up" or "Join Free" on their site — it's always free</li>
                    <li>Fill in your demographic details honestly — this determines which surveys you receive</li>
                    <li>Verify your email address by clicking the link they send you</li>
                    <li>Complete all profile/profiler surveys to unlock more survey invitations</li>
                    <li>Log in daily, complete surveys, and request a withdrawal when you hit the minimum payout</li>
                </ol>
            </div>

            <!-- ── Reviews Section ────────────────────────── -->
            <div class="detail-section" id="reviews">
                <div style="display:flex;justify-content:space-between;align-items:center;flex-wrap:wrap;gap:.5rem;margin-bottom:1.25rem;">
                    <h3 style="margin:0;">Member Reviews</h3>
                    <?php if ($total_reviews > 0): ?>
                    <a href="#write-review" class="btn btn-outline btn-sm">✍ Write a Review</a>
                    <?php endif; ?>
                </div>

                <?php if ($total_reviews > 0): ?>

                <!-- Rating Summary -->
                <div style="display:grid;grid-template-columns:auto 1fr;gap:1.5rem;align-items:center;background:var(--slate-50);border-radius:var(--r-md);padding:1.25rem;margin-bottom:1.5rem;flex-wrap:wrap;">
                    <div class="big-rating">
                        <div class="score"><?php echo $avg_rating; ?></div>
                        <div class="stars-row"><?php echo render_stars_html($avg_rating, '1.3rem'); ?></div>
                        <div class="total-txt"><?php echo $total_reviews; ?> review<?php echo $total_reviews>1?'s':''; ?></div>
                    </div>
                    <div>
                        <?php foreach ([5,4,3,2,1] as $star):
                            $cnt   = $breakdown[$star];
                            $pct   = $total_reviews > 0 ? round(($cnt / $total_reviews) * 100) : 0;
                        ?>
                        <div class="rating-bar-wrap">
                            <span class="rating-bar-label"><?php echo $star; ?> ★</span>
                            <div class="rating-bar-track">
                                <div class="rating-bar-fill" style="width:<?php echo $pct; ?>%"></div>
                            </div>
                            <span class="rating-bar-count"><?php echo $cnt; ?></span>
                        </div>
                        <?php endforeach; ?>
                    </div>
                </div>

                <!-- Individual Reviews -->
                <?php
                if ($reviews_result) {
                    while ($review = $reviews_result->fetch_assoc()):
                ?>
                <div class="review-card">
                    <div class="review-header">
                        <div class="reviewer-info">
                            <!-- Individual star rating — golden and prominent -->
                            <div style="display:flex;align-items:center;gap:.5rem;margin-bottom:.4rem;">
                                <span style="color:#f59e0b;font-size:1.1rem;letter-spacing:-.02em;"><?php
                                    $full = floor($review['rating']);
                                    echo str_repeat('★', $full) . '<span style="color:#e2e8f0;">' . str_repeat('★', 5-$full) . '</span>';
                                ?></span>
                                <span style="font-family:var(--font-head);font-size:.82rem;font-weight:800;color:#d97706;"><?php echo $review['rating']; ?>/5</span>
                                <span class="verified-badge">✓ Verified Review</span>
                            </div>
                            <!-- Reviewer name -->
                            <div class="reviewer-name"><?php echo htmlspecialchars($review['reviewer_name'] ?: 'Anonymous'); ?></div>
                            <!-- Location if given -->
                            <?php if (!empty($review['reviewer_location'])): ?>
                            <div class="reviewer-meta">📍 <?php echo htmlspecialchars($review['reviewer_location']); ?></div>
                            <?php endif; ?>
                            <!-- Masked email -->
                            <?php if (!empty($review['reviewer_email'])): ?>
                            <div class="reviewer-meta" style="color:var(--slate-400);">✉ <?php echo htmlspecialchars(mask_email($review['reviewer_email'])); ?></div>
                            <?php endif; ?>
                        </div>
                        <!-- Date -->
                        <div style="text-align:right;">
                            <div class="review-date"><?php echo date('d M Y', strtotime($review['created_at'])); ?></div>
                            <div style="font-size:.7rem;color:var(--slate-300);"><?php echo date('H:i', strtotime($review['created_at'])); ?></div>
                        </div>
                    </div>
                    <p class="review-text"><?php echo nl2br(htmlspecialchars($review['feedback'])); ?></p>

                    <!-- Proof display -->
                    <?php if (!empty($review['proof_file'])): ?>
                    <div style="margin-top:.85rem;padding:.85rem;background:var(--slate-50);border-radius:var(--r-sm);border:1.5px solid var(--slate-200);">
                        <div style="font-size:.72rem;font-weight:700;text-transform:uppercase;letter-spacing:.06em;color:var(--slate-400);margin-bottom:.5rem;">📎 Member Proof</div>
                        <?php if ($review['proof_type'] === 'image'): ?>
                        <a href="<?php echo SITE_URL; ?>/uploads/review_proofs/<?php echo htmlspecialchars($review['proof_file']); ?>"
                           target="_blank" rel="noopener" title="View full proof image">
                            <img src="<?php echo SITE_URL; ?>/uploads/review_proofs/<?php echo htmlspecialchars($review['proof_file']); ?>"
                                 alt="Member proof"
                                 style="max-width:100%;max-height:240px;border-radius:var(--r-sm);object-fit:contain;border:1px solid var(--slate-200);cursor:zoom-in;">
                        </a>
                        <div style="font-size:.72rem;color:var(--slate-400);margin-top:.35rem;">Click image to view full size</div>
                        <?php else: ?>
                        <a href="<?php echo SITE_URL; ?>/uploads/review_proofs/<?php echo htmlspecialchars($review['proof_file']); ?>"
                           target="_blank" rel="noopener"
                           style="display:inline-flex;align-items:center;gap:.4rem;font-size:.84rem;font-weight:600;color:var(--emerald);padding:.4rem .85rem;background:var(--white);border:1.5px solid var(--emerald-light);border-radius:var(--r-sm);">
                            📄 View PDF Proof ↗
                        </a>
                        <?php endif; ?>
                    </div>
                    <?php endif; ?>
                </div>
                <?php
                    endwhile;
                }
                ?>

                <?php else: ?>
                <!-- No reviews yet -->
                <div style="text-align:center;padding:2rem;background:var(--slate-50);border-radius:var(--r-md);">
                    <div style="font-size:2.5rem;margin-bottom:.75rem;">⭐</div>
                    <h4 style="margin-bottom:.4rem;">No reviews yet</h4>
                    <p style="font-size:.87rem;margin-bottom:1rem;">Be the first to share your experience with this platform.</p>
                    <a href="#write-review" class="btn btn-primary btn-sm">Write the First Review</a>
                </div>
                <?php endif; ?>
            </div>

            <!-- ── Write a Review — Prominent CTA ────────── -->
            <div id="write-review" style="background:linear-gradient(135deg,var(--emerald-xd),var(--emerald-dark));border-radius:var(--r-lg);padding:2.25rem;margin-bottom:1.25rem;position:relative;overflow:hidden;">
                <div style="position:absolute;top:-30px;right:-30px;width:150px;height:150px;background:rgba(255,255,255,.05);border-radius:50%;"></div>
                <div style="position:relative;">
                    <div style="display:flex;align-items:center;justify-content:space-between;flex-wrap:wrap;gap:1rem;">
                        <div>
                            <div style="font-size:1.5rem;margin-bottom:.3rem;">⭐</div>
                            <h3 style="color:#fff;font-size:1.15rem;margin-bottom:.3rem;">Have you used <?php echo htmlspecialchars($survey['title']); ?>?</h3>
                            <p style="color:rgba(255,255,255,.78);font-size:.85rem;margin:0;">Share your honest experience — help other Indians decide. <strong style="color:#fcd34d;">Proof or screenshot required for approval.</strong></p>
                        </div>
                        <?php if (!$review_success): ?>
                        <a href="#review-form" onclick="document.getElementById('review-form').scrollIntoView({behavior:'smooth'});document.getElementById('star5')?.focus();return false;"
                           class="btn btn-white btn-lg" style="white-space:nowrap;flex-shrink:0;">
                            ✍ Write a Review
                        </a>
                        <?php endif; ?>
                    </div>
                    <!-- Star rating teaser -->
                    <?php if (!$review_success): ?>
                    <div style="margin-top:1.25rem;display:flex;align-items:center;gap:.75rem;flex-wrap:wrap;">
                        <span style="color:rgba(255,255,255,.6);font-size:.8rem;">Rate it:</span>
                        <div style="display:flex;gap:.3rem;" id="quick-stars">
                            <?php for ($i=1;$i<=5;$i++): ?>
                            <a href="#review-form"
                               onclick="document.getElementById('star<?php echo $i;?>').checked=true;document.getElementById('review-form').scrollIntoView({behavior:'smooth'});return false;"
                               style="font-size:1.75rem;color:rgba(255,255,255,.35);text-decoration:none;transition:color .1s;"
                               onmouseover="highlightStars(<?php echo $i;?>)"
                               onmouseout="resetStars()">★</a>
                            <?php endfor; ?>
                        </div>
                        <span style="color:rgba(255,255,255,.5);font-size:.75rem;">Click a star to begin</span>
                    </div>
                    <?php endif; ?>
                </div>
            </div>

            <!-- ── Review Form ─────────────────────────────── -->
            <div class="detail-section" id="review-form">
                <h3 style="margin-bottom:.4rem;">Write Your Review</h3>
                <p style="font-size:.83rem;color:var(--slate-500);margin-bottom:1.25rem;">All reviews are verified before publishing. You can upload payment proof or a complaint screenshot to strengthen your review.</p>

                <?php if ($review_success): ?>
                <div class="alert alert-success">
                    <strong>✓ Thank you for your review!</strong> It has been submitted and will appear here once our team approves it — usually within 24 hours.
                    <?php if (!empty($_POST['newsletter_consent'])): ?>
                    <br><span style="font-size:.85rem;opacity:.85;">📩 You've also been added to our newsletter.</span>
                    <?php endif; ?>
                </div>


                <?php elseif (!empty($review_error)): ?>
                <div class="alert alert-error"><?php echo htmlspecialchars($review_error); ?></div>
                <?php endif; ?>

                <?php if (!$review_success): ?>
                <form method="POST" action="#review-form" novalidate enctype="multipart/form-data">
                    <input type="hidden" name="submit_review" value="1">
                    <!-- Honeypot -->
                    <div style="display:none;"><input type="text" name="website_url" tabindex="-1" autocomplete="off"></div>

                    <!-- Star Rating -->
                    <div class="form-group">
                        <label>Your Rating <span style="color:var(--red);">*</span></label>
                        <div class="star-picker" role="group" aria-label="Rating">
                            <?php for ($i = 5; $i >= 1; $i--): ?>
                            <input type="radio" id="star<?php echo $i; ?>" name="rating" value="<?php echo $i; ?>"
                                <?php echo (isset($_POST['rating']) && (int)$_POST['rating'] === $i) ? 'checked' : ''; ?>>
                            <label for="star<?php echo $i; ?>" title="<?php echo $i; ?> star<?php echo $i>1?'s':''; ?>">★</label>
                            <?php endfor; ?>
                        </div>
                        <div style="font-size:.78rem;color:var(--slate-400);margin-top:.35rem;">Click a star to rate</div>
                    </div>

                    <!-- Name + Location row -->
                    <div style="display:grid;grid-template-columns:1fr 1fr;gap:.85rem;">
                        <div class="form-group">
                            <label for="reviewer_name">Your Name <span style="color:var(--red);">*</span></label>
                            <input type="text" id="reviewer_name" name="reviewer_name" class="form-control"
                                   placeholder="e.g. Priya S." maxlength="100" required
                                   value="<?php echo htmlspecialchars($_POST['reviewer_name'] ?? ''); ?>">
                        </div>
                        <div class="form-group">
                            <label for="reviewer_location">Your City <span style="font-weight:400;color:var(--slate-400);">(optional)</span></label>
                            <input type="text" id="reviewer_location" name="reviewer_location" class="form-control"
                                   placeholder="e.g. Chennai, Tamil Nadu" maxlength="100"
                                   value="<?php echo htmlspecialchars($_POST['reviewer_location'] ?? ''); ?>">
                        </div>
                    </div>

                    <!-- Email — now REQUIRED -->
                    <div class="form-group">
                        <label for="reviewer_email">Your Email Address <span style="color:var(--red);">*</span></label>
                        <input type="email" id="reviewer_email" name="reviewer_email" class="form-control"
                               placeholder="your@email.com" maxlength="255" required
                               value="<?php echo htmlspecialchars($_POST['reviewer_email'] ?? ''); ?>">
                        <div style="font-size:.75rem;color:var(--slate-400);margin-top:.3rem;">
                            Required to verify your review. Never displayed publicly.
                        </div>
                    </div>

                    <!-- Newsletter Consent -->
                    <div style="background:var(--emerald-pale);border:1.5px solid var(--emerald-light);border-radius:var(--r-sm);padding:1rem 1.1rem;margin-bottom:1.1rem;">
                        <label style="display:flex;align-items:flex-start;gap:.6rem;cursor:pointer;margin:0;">
                            <input type="checkbox" name="newsletter_consent" value="1"
                                   <?php echo !empty($_POST['newsletter_consent']) ? 'checked' : ''; ?>
                                   style="width:17px;height:17px;margin-top:.1rem;flex-shrink:0;accent-color:var(--emerald);cursor:pointer;">
                            <span style="font-size:.84rem;color:var(--emerald-xd);line-height:1.6;">
                                <strong>📩 Yes, keep me updated</strong> — Send me occasional emails about new verified survey sites, earning tips, and India-specific opportunities. I can unsubscribe anytime.
                            </span>
                        </label>
                    </div>

                    <!-- Review Text -->
                    <div class="form-group">
                        <label for="feedback">Your Review <span style="color:var(--red);">*</span></label>
                        <textarea id="feedback" name="feedback" class="form-control" rows="5" maxlength="2000"
                                  placeholder="Share your honest experience — did it pay? How many surveys did you receive? Would you recommend it to other Indians?"
                                  required><?php echo htmlspecialchars($_POST['feedback'] ?? ''); ?></textarea>
                        <div style="font-size:.75rem;color:var(--slate-400);margin-top:.3rem;">Minimum 20 characters. Maximum 2,000 characters.</div>
                    </div>

                    <!-- Proof Upload -->
                    <div class="form-group">
                        <label for="proof_file">Upload Proof <span style="font-weight:400;color:var(--slate-400);">(optional)</span></label>
                        <div style="border:2px dashed var(--slate-300);border-radius:var(--r-md);padding:1.25rem;text-align:center;cursor:pointer;transition:border-color .2s;background:var(--slate-50);" id="proof-drop-zone">
                            <div style="font-size:1.75rem;margin-bottom:.4rem;">📎</div>
                            <div style="font-size:.85rem;font-weight:600;color:var(--slate-700);margin-bottom:.2rem;">Drop your proof here or click to browse</div>
                            <div style="font-size:.75rem;color:var(--slate-400);">Payment screenshot, reward proof, or complaint — JPG, PNG, GIF or PDF · Max 5MB</div>
                            <input type="file" id="proof_file" name="proof_file"
                                   accept="image/jpeg,image/jpg,image/png,image/gif,application/pdf"
                                   style="position:absolute;width:100%;height:100%;opacity:0;cursor:pointer;top:0;left:0;"
                                   onchange="showPreview(this)">
                        </div>
                        <div id="proof-preview" style="display:none;margin-top:.75rem;padding:.75rem;background:var(--emerald-pale);border:1.5px solid var(--emerald-light);border-radius:var(--r-sm);font-size:.82rem;color:var(--emerald-xd);display:flex;align-items:center;gap:.5rem;">
                            <span>📄</span> <span id="proof-filename"></span>
                            <button type="button" onclick="clearProof()" style="margin-left:auto;background:none;border:none;color:var(--red);cursor:pointer;font-size:.8rem;font-weight:700;">✕ Remove</button>
                        </div>
                        <div style="font-size:.72rem;color:var(--slate-400);margin-top:.3rem;">This helps other members trust your review. Your proof will be shown alongside your review after approval.</div>
                    </div>

                    <div style="background:#fef3c7;border:1.5px solid #fcd34d;border-radius:var(--r-sm);padding:.85rem 1rem;font-size:.78rem;color:#78350f;margin-bottom:1rem;">
                        <strong>📋 Important — Proof Required for Approval:</strong> Regardless of whether your experience is positive or negative, <strong>only reviews supported by a screenshot or proof will be approved</strong>. Please upload a payment proof, survey completion screenshot, or any relevant evidence using the upload field above. Reviews without proof will not be published. By submitting you agree to our <a href="<?php echo SITE_URL; ?>/terms-conditions.php" style="color:#92400e;">Terms</a>.
                    </div>

                    <button type="submit" class="btn btn-primary btn-lg" style="width:100%;">Submit Review →</button>
                </form>
                <?php endif; ?>
            </div>

            <!-- Disclaimer -->
            <div style="background:var(--amber-bg);border:1px solid #fcd34d;border-radius:var(--r-sm);padding:1rem;font-size:.8rem;color:#78350f;margin-bottom:1.5rem;">
                <strong>⚠️ Disclaimer:</strong> PaidSurveyHub India is an independent directory. We are not affiliated with this platform and do not conduct surveys. Earnings are not guaranteed. Always research a platform before providing personal information.
            </div>

        </div><!-- /left col -->

        <!-- ── Right Sidebar ─────────────────────────────── -->
        <div>

            <!-- Quick Facts -->
            <div class="detail-section">
                <h3>Quick Facts</h3>
                <div class="quick-facts">

                    <div class="qf-item">
                        <div class="qf-label">Verified</div>
                        <div class="qf-val" style="color:var(--emerald);">✓ Yes</div>
                    </div>
                    <div class="qf-item">
                        <div class="qf-label">Free to Join</div>
                        <div class="qf-val" style="color:var(--emerald);">✓ Yes</div>
                    </div>

                    <?php if ($survey['id'] == 1): ?>
                    <div class="qf-item">
                        <div class="qf-label">Payment Method</div>
                        <div class="qf-val">UPI (PhonePe · GPay · Paytm)</div>
                    </div>
                    <div class="qf-item">
                        <div class="qf-label">Min. Payout</div>
                        <div class="qf-val">₹250 <span style="font-size:.75rem;font-weight:400;color:var(--slate-500);">(500 pts × ₹0.50)</span></div>
                    </div>
                    <div class="qf-item">
                        <div class="qf-label">Based In</div>
                        <div class="qf-val">India (Tamil Nadu)</div>
                    </div>
                    <div class="qf-item">
                        <div class="qf-label">Members</div>
                        <div class="qf-val">50,000+</div>
                    </div>
                    <div class="qf-item">
                        <div class="qf-label">Founded</div>
                        <div class="qf-val">2021</div>
                    </div>
                    <?php endif; ?>

                    <?php if ($survey['rank']): ?>
                    <div class="qf-item">
                        <div class="qf-label">Our Rank</div>
                        <div class="qf-val">#<?php echo $survey['rank']; ?> in India</div>
                    </div>
                    <?php endif; ?>

                    <?php if ($total_reviews > 0): ?>
                    <div class="qf-item">
                        <div class="qf-label">Rating</div>
                        <div class="qf-val"><?php echo $avg_rating; ?>/5 (<?php echo $total_reviews; ?> reviews)</div>
                    </div>
                    <?php endif; ?>

                    <!-- Smart Contact Display -->
                    <?php if ($contact_info): ?>
                    <div class="qf-item" style="grid-column:1/-1;">
                        <div class="qf-label">Support</div>
                        <div class="qf-val" style="margin-top:.2rem;">
                            <?php if ($contact_info['type'] === 'email'): ?>
                            <a href="mailto:<?php echo htmlspecialchars($contact_info['value']); ?>" class="contact-link">
                                <svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><rect x="2" y="4" width="20" height="16" rx="2"/><path d="m22 7-8.97 5.7a1.94 1.94 0 0 1-2.06 0L2 7"/></svg>
                                <?php echo htmlspecialchars($contact_info['display']); ?>
                            </a>
                            <?php else: ?>
                            <a href="<?php echo htmlspecialchars($contact_info['value']); ?>" target="_blank" rel="noopener" class="contact-link">
                                <svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M21 15a2 2 0 0 1-2 2H7l-4 4V5a2 2 0 0 1 2-2h14a2 2 0 0 1 2 2z"/></svg>
                                <?php echo htmlspecialchars($contact_info['display']); ?>
                            </a>
                            <?php endif; ?>
                        </div>
                    </div>
                    <?php endif; ?>

                </div>
            </div>

            <!-- Visit CTA -->
            <div style="background:linear-gradient(135deg,var(--emerald-xd),var(--emerald-dark));border-radius:var(--r-md);padding:1.5rem;text-align:center;margin-bottom:1.25rem;">
                <div style="font-size:1.75rem;margin-bottom:.5rem;">🚀</div>
                <h4 style="color:#fff;margin-bottom:.4rem;">Ready to Join?</h4>
                <p style="color:rgba(255,255,255,.8);font-size:.83rem;margin-bottom:1rem;">It's free. No investment required.</p>
                <a href="<?php echo htmlspecialchars($survey['website_link']); ?>"
                   target="_blank" rel="noopener sponsored"
                   class="btn btn-white btn-block" style="justify-content:center;">
                   Visit <?php echo htmlspecialchars($survey['title']); ?> ↗
                </a>
            </div>

            <!-- Tips -->
            <div class="detail-section">
                <h3>Tips for Success</h3>
                <ul style="margin-left:1.1rem;list-style:disc;font-size:.84rem;color:var(--slate-600);line-height:2;">
                    <li>Complete your profile 100% on day 1</li>
                    <li>Log in daily — surveys close when quotas fill</li>
                    <li>Answer honestly — inconsistencies get flagged</li>
                    <li>Check email promptly for invitations</li>
                    <li>Join 3–5 platforms to maximise earnings</li>
                </ul>
                <a href="<?php echo SITE_URL; ?>/faq.php#tips" style="font-size:.82rem;color:var(--emerald);display:block;margin-top:.75rem;">Read all earning tips →</a>
            </div>

            <!-- Other sites -->
            <div class="detail-section">
                <h3>Other Sites to Try</h3>
                <?php
                $other_sql = "SELECT id, title, image, rank FROM survey_sites
                              WHERE id != $survey_id
                              ORDER BY CASE WHEN rank IS NOT NULL THEN rank ELSE 99 END ASC, RAND()
                              LIMIT 5";
                $other_result = $conn->query($other_sql);
                if ($other_result):
                    while ($other = $other_result->fetch_assoc()):
                ?>
                <a href="<?php echo SITE_URL; ?>/survey-detail.php?id=<?php echo $other['id']; ?>"
                   style="display:flex;align-items:center;gap:.75rem;padding:.6rem 0;border-bottom:1px solid var(--slate-100);text-decoration:none;">
                    <img src="<?php echo SITE_URL; ?>/uploads/<?php echo htmlspecialchars($other['image']); ?>"
                         alt="<?php echo htmlspecialchars($other['title']); ?>"
                         style="width:36px;height:36px;border-radius:6px;object-fit:contain;border:1.5px solid var(--slate-200);padding:.2rem;">
                    <span style="font-size:.87rem;font-weight:600;color:var(--slate-800);"><?php echo htmlspecialchars($other['title']); ?></span>
                    <?php if ($other['rank']): ?><span class="badge badge-emerald" style="margin-left:auto;">#<?php echo $other['rank']; ?></span><?php endif; ?>
                </a>
                <?php endwhile; endif; ?>
                <a href="<?php echo SITE_URL; ?>/" style="font-size:.82rem;color:var(--emerald);display:block;margin-top:.75rem;font-weight:600;">View all survey sites →</a>
            </div>

        </div><!-- /right col -->
    </div>

</div>
</main>

<?php echo $extra_schema; ?>

<script>
// Quick star hover on the green CTA banner
function highlightStars(n) {
    var stars = document.querySelectorAll('#quick-stars a');
    stars.forEach(function(s, i){ s.style.color = i < n ? '#fbbf24' : 'rgba(255,255,255,.35)'; });
}
function resetStars() {
    document.querySelectorAll('#quick-stars a').forEach(function(s){ s.style.color = 'rgba(255,255,255,.35)'; });
}

// File upload drop zone
var dropZone = document.getElementById('proof-drop-zone');
if (dropZone) {
    dropZone.style.position = 'relative';
    dropZone.addEventListener('dragover', function(e){
        e.preventDefault(); this.style.borderColor = 'var(--emerald)'; this.style.background = 'var(--emerald-pale)';
    });
    dropZone.addEventListener('dragleave', function(){
        this.style.borderColor = 'var(--slate-300)'; this.style.background = 'var(--slate-50)';
    });
    dropZone.addEventListener('drop', function(e){
        e.preventDefault(); this.style.borderColor = 'var(--slate-300)'; this.style.background = 'var(--slate-50)';
        var file = e.dataTransfer.files[0];
        if (file) { document.getElementById('proof_file').files = e.dataTransfer.files; showPreview({files:[file]}); }
    });
}

function showPreview(input) {
    var file = input.files ? input.files[0] : null;
    if (!file) return;
    var preview = document.getElementById('proof-preview');
    var fname   = document.getElementById('proof-filename');
    if (preview && fname) {
        fname.textContent = file.name + ' (' + (file.size/1024/1024).toFixed(2) + ' MB)';
        preview.style.display = 'flex';
    }
    // Highlight drop zone
    if (dropZone) { dropZone.style.borderColor = 'var(--emerald)'; dropZone.style.background = 'var(--emerald-pale)'; }
}

function clearProof() {
    document.getElementById('proof_file').value = '';
    var preview = document.getElementById('proof-preview');
    if (preview) preview.style.display = 'none';
    if (dropZone) { dropZone.style.borderColor = 'var(--slate-300)'; dropZone.style.background = 'var(--slate-50)'; }
}
</script>

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

### FILE 10: PSH IN/terms-conditions.php
- Type: PHP
- Size: 7.19 KB
- Path: PSH IN
- Name: terms-conditions.php
------------------------------------------------------------
<?php
require_once 'config/config.php';
$page_title       = 'Terms and Conditions — Paid Survey Hub India';
$meta_description = 'Terms and Conditions for using Paid Survey Hub India — a free, public directory of verified paid survey sites for Indian users.';
$canonical        = SITE_URL . '/terms-conditions.php';
$robots           = 'index, follow';
include 'includes/header.php';
?>

<main class="page-wrap">
<div class="container">

    <nav class="breadcrumb" aria-label="Breadcrumb">
        <a href="<?php echo SITE_URL; ?>/">Home</a>
        <span class="breadcrumb-sep">›</span>
        <span>Terms and Conditions</span>
    </nav>

    <div class="page-card">
        <h1>Terms and Conditions</h1>
        <p class="text-muted" style="margin-bottom:1.5rem;font-size:.85rem;"><strong>Last Updated:</strong> April 10, 2026</p>

        <div class="page-lead">
            <p>Welcome to Paid Survey Hub India. By accessing and using this website, you agree to these Terms and Conditions. Please read them carefully.</p>
        </div>

        <h2>1. About This Website</h2>
        <p>Paid Survey Hub India (paidsurveyhub.in) is a <strong>free, publicly accessible information directory</strong>. We list and describe paid online survey websites that accept Indian members. We are not a survey company, not a paid membership service, and we do not conduct surveys ourselves.</p>
        <p>Access to this directory is completely free. No registration, no membership fee, and no personal information is required to browse our content.</p>

        <h2>2. Acceptance of Terms</h2>
        <p>By accessing paidsurveyhub.in, you acknowledge that you have read, understood, and agree to be bound by these Terms and Conditions. If you do not agree, please do not use this website.</p>

        <h2>3. Who May Use This Website</h2>
        <p>This website may be used by anyone who:</p>
        <ul>
            <li>Is at least 18 years of age</li>
            <li>Uses the website for lawful purposes only</li>
            <li>Does not attempt to misuse, disrupt, or damage the website or its infrastructure</li>
        </ul>

        <h2>4. Nature of Our Service</h2>
        <p>Paid Survey Hub India provides:</p>
        <ul>
            <li>A curated directory of paid survey websites verified for Indian accessibility</li>
            <li>Descriptions, quick facts, and user reviews for listed platforms</li>
            <li>General information and guidance for survey takers in India</li>
        </ul>
        <p>We do <strong>not</strong> provide:</p>
        <ul>
            <li>Survey participation (we are not a survey panel)</li>
            <li>Guaranteed earnings of any kind</li>
            <li>Endorsement of any listed platform beyond our verification criteria</li>
            <li>Support for issues arising from third-party survey sites</li>
        </ul>

        <h2>5. Accuracy of Information</h2>
        <p>We make reasonable efforts to ensure information in our directory is accurate and current. However:</p>
        <ul>
            <li>Survey site payment policies, minimum thresholds, and terms change without notice</li>
            <li>We cannot guarantee the ongoing legitimacy or payment practices of any listed platform</li>
            <li>Verification is performed at the time of listing — conditions may have changed since</li>
            <li>You should always do your own research before registering with any survey site</li>
        </ul>

        <h2>6. Third-Party Survey Websites</h2>
        <p>This website contains links to third-party survey platforms. When you click through to any listed survey site:</p>
        <ul>
            <li>You are leaving paidsurveyhub.in and entering a website we do not control</li>
            <li>Each platform has its own terms, privacy policy, and earning conditions</li>
            <li>Any issues with earnings, payments, account suspension, or data use are between you and the survey site</li>
            <li>We are not responsible for and take no liability for your experiences with third-party platforms</li>
        </ul>
        <p><strong>Disclosure:</strong> Relevant Reflex (relevantreflex.com), listed as our #1 recommended platform, is owned by the same team as Paid Survey Hub India. This relationship is disclosed clearly on our site. All other listings are independent and we receive no compensation from them for being listed.</p>

        <h2>7. User Reviews</h2>
        <p>We may display user-submitted reviews of listed survey sites. By submitting a review:</p>
        <ul>
            <li>You confirm the review is based on your genuine personal experience</li>
            <li>You grant us a non-exclusive licence to display your review on this website</li>
            <li>You must not submit false, defamatory, or misleading reviews</li>
            <li>We reserve the right to moderate, edit, or remove reviews at our discretion</li>
        </ul>

        <h2>8. Prohibited Activities</h2>
        <p>You must not:</p>
        <ul>
            <li>Attempt to hack, disrupt, or gain unauthorised access to any part of this website</li>
            <li>Submit spam, abusive content, or deliberately false reviews</li>
            <li>Use automated tools to scrape or copy our directory content without permission</li>
            <li>Misrepresent your affiliation with any survey company or our platform</li>
        </ul>

        <h2>9. Intellectual Property</h2>
        <p>All original content on this website — including text, design, and layout — is the property of Paid Survey Hub India. Survey site names, logos, and descriptions belong to their respective owners and are used for informational and editorial purposes only.</p>
        <p>You may not reproduce, distribute, or create derivative works from our directory content without written permission.</p>

        <h2>10. Limitation of Liability</h2>
        <p>To the maximum extent permitted by Indian law, Paid Survey Hub India shall not be liable for:</p>
        <ul>
            <li>Any earnings loss, payment disputes, or account issues with third-party survey sites</li>
            <li>Inaccuracies in survey site information that arise after the time of verification</li>
            <li>Any indirect, incidental, or consequential damages arising from use of this website</li>
            <li>Decisions made based on information contained in this directory</li>
        </ul>

        <h2>11. Changes to These Terms</h2>
        <p>We reserve the right to update these Terms and Conditions at any time. The "Last Updated" date reflects the most recent revision. Continued use of the website after changes constitutes acceptance.</p>

        <h2>12. Governing Law</h2>
        <p>These Terms are governed by the laws of India. Any disputes arising from use of this website shall be subject to the jurisdiction of courts in Tamil Nadu, India.</p>

        <h2>13. Contact Us</h2>
        <p>If you have any questions about these Terms, please contact us:</p>
        <ul>
            <li>Email: <a href="mailto:gethelp@paidsurveyhub.in">gethelp@paidsurveyhub.in</a></li>
            <li>Contact form: <a href="<?php echo SITE_URL; ?>/contact.php">paidsurveyhub.in/contact.php</a></li>
        </ul>
    </div>

</div>
</main>

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

### FILE 11: PSH IN/assets/style.css
- Type: CSS
- Size: 32.97 KB
- Path: PSH IN/assets
- Name: style.css
------------------------------------------------------------
/* ================================================================
   PaidSurveyHub India — Premium Stylesheet v2
   Design: Sharp Editorial — Emerald & Slate
   Fonts: Plus Jakarta Sans (headings) + Nunito (body)
   ================================================================ */

@import url('https://fonts.googleapis.com/css2?family=Plus+Jakarta+Sans:wght@400;500;600;700;800&family=Nunito:wght@400;500;600;700&display=swap');

/* ── Variables ─────────────────────────────────────────────── */
:root {
  /* Brand */
  --emerald:       #059669;
  --emerald-dark:  #047857;
  --emerald-xd:    #064e3b;
  --emerald-light: #d1fae5;
  --emerald-pale:  #f0fdf4;
  --emerald-mid:   #6ee7b7;

  /* UI Colours */
  --slate-900:  #0f172a;
  --slate-800:  #1e293b;
  --slate-700:  #334155;
  --slate-600:  #475569;
  --slate-500:  #64748b;
  --slate-400:  #94a3b8;
  --slate-300:  #cbd5e1;
  --slate-200:  #e2e8f0;
  --slate-100:  #f1f5f9;
  --slate-50:   #f8fafc;
  --white:      #ffffff;

  /* Accent */
  --amber:      #d97706;
  --amber-bg:   #fef3c7;
  --blue:       #2563eb;
  --blue-bg:    #dbeafe;
  --red:        #dc2626;

  /* Shadows */
  --shadow-xs:  0 1px 2px rgba(0,0,0,.06);
  --shadow-sm:  0 2px 6px rgba(0,0,0,.07), 0 1px 3px rgba(0,0,0,.05);
  --shadow-md:  0 6px 18px rgba(0,0,0,.09), 0 2px 6px rgba(0,0,0,.05);
  --shadow-lg:  0 12px 32px rgba(0,0,0,.1), 0 4px 10px rgba(0,0,0,.06);
  --shadow-green: 0 8px 24px rgba(5,150,105,.18);

  /* Radii */
  --r-xs: 4px;
  --r-sm: 8px;
  --r-md: 12px;
  --r-lg: 18px;
  --r-xl: 24px;
  --r-full: 9999px;

  /* Typography */
  --font-head: 'Plus Jakarta Sans', sans-serif;
  --font-body: 'Nunito', sans-serif;

  /* Layout */
  --max-w: 1160px;
  --nav-h: 62px;
}

/* ── Reset ─────────────────────────────────────────────────── */
*, *::before, *::after { box-sizing: border-box; margin: 0; padding: 0; }
html { font-size: 16px; scroll-behavior: smooth; -webkit-text-size-adjust: 100%; }
body {
  font-family: var(--font-body);
  color: var(--slate-800);
  background: var(--slate-50);
  line-height: 1.65;
  min-height: 100vh;
  display: flex;
  flex-direction: column;
  -webkit-font-smoothing: antialiased;
}
img { max-width: 100%; display: block; }
a { color: var(--emerald); text-decoration: none; transition: color .15s; }
a:hover { color: var(--emerald-dark); }
ul { list-style: none; }
button { font-family: var(--font-body); }

/* ── Container ─────────────────────────────────────────────── */
.container { width: 100%; max-width: var(--max-w); margin: 0 auto; padding: 0 1.25rem; }

/* ── Typography ────────────────────────────────────────────── */
h1,h2,h3,h4,h5 {
  font-family: var(--font-head);
  color: var(--slate-900);
  line-height: 1.22;
  letter-spacing: -.01em;
}
h1 { font-size: clamp(1.7rem, 4vw, 2.6rem); font-weight: 800; }
h2 { font-size: clamp(1.3rem, 3vw, 1.85rem); font-weight: 700; }
h3 { font-size: 1.1rem; font-weight: 700; }
h4 { font-size: .97rem; font-weight: 700; }
p  { color: var(--slate-600); line-height: 1.8; }

/* ── Buttons ───────────────────────────────────────────────── */
.btn {
  display: inline-flex; align-items: center; justify-content: center; gap: .4rem;
  font-family: var(--font-head); font-weight: 700; font-size: .87rem;
  padding: .6rem 1.4rem; border-radius: var(--r-sm);
  border: 2px solid transparent; cursor: pointer;
  transition: all .18s cubic-bezier(.4,0,.2,1);
  white-space: nowrap; text-decoration: none; letter-spacing: .01em;
}
.btn-primary { background: var(--emerald); color: #fff; border-color: var(--emerald); box-shadow: var(--shadow-green); }
.btn-primary:hover { background: var(--emerald-dark); border-color: var(--emerald-dark); color: #fff; transform: translateY(-1px); box-shadow: 0 12px 28px rgba(5,150,105,.25); }
.btn-outline { background: transparent; color: var(--emerald); border-color: var(--emerald); }
.btn-outline:hover { background: var(--emerald); color: #fff; }
.btn-ghost  { background: var(--slate-100); color: var(--slate-700); border-color: var(--slate-200); }
.btn-ghost:hover { background: var(--slate-200); color: var(--slate-900); }
.btn-white  { background: #fff; color: var(--emerald-dark); border-color: #fff; font-weight: 700; }
.btn-white:hover { background: var(--emerald-light); color: var(--emerald-xd); }
.btn-sm     { padding: .38rem .85rem; font-size: .8rem; }
.btn-lg     { padding: .75rem 1.85rem; font-size: .95rem; }
.btn-xl     { padding: .9rem 2.25rem; font-size: 1rem; }
.btn-block  { display: flex; width: 100%; }

/* ── Badges ────────────────────────────────────────────────── */
.badge {
  display: inline-flex; align-items: center; gap: .2rem;
  font-family: var(--font-head); font-size: .68rem; font-weight: 700;
  text-transform: uppercase; letter-spacing: .06em;
  padding: .2rem .65rem; border-radius: var(--r-full);
}
.badge-emerald { background: var(--emerald-light); color: var(--emerald-xd); }
.badge-amber   { background: var(--amber-bg); color: #78350f; }
.badge-blue    { background: var(--blue-bg); color: #1e40af; }
.badge-slate   { background: var(--slate-100); color: var(--slate-600); }
.badge-india   { background: #fff7ed; color: #9a3412; }

/* ── Notice Bar ────────────────────────────────────────────── */
.notice-bar {
  background: var(--emerald-xd);
  padding: .48rem 0;
  text-align: center;
}
.notice-bar p { font-size: .78rem; color: var(--emerald-light); font-family: var(--font-head); font-weight: 500; }
.notice-bar a { color: var(--emerald-mid); font-weight: 700; }
.notice-bar a:hover { color: #fff; }

/* ── Navigation ────────────────────────────────────────────── */
.site-nav {
  background: var(--white);
  border-bottom: 1px solid var(--slate-200);
  position: sticky; top: 0; z-index: 100;
  box-shadow: 0 1px 12px rgba(15,23,42,.07);
}
.nav-inner {
  display: flex; align-items: center;
  justify-content: space-between;
  height: var(--nav-h); gap: 1rem;
}
.nav-logo {
  font-family: var(--font-head); font-weight: 800; font-size: 1.18rem;
  color: var(--slate-900); white-space: nowrap; text-decoration: none;
  display: flex; align-items: center; gap: .3rem;
}
.nav-logo-icon {
  width: 32px; height: 32px; background: var(--emerald);
  border-radius: var(--r-xs); display: flex; align-items: center;
  justify-content: center; font-size: 1rem; flex-shrink: 0;
}
.nav-logo span.accent { color: var(--emerald); }
.nav-links {
  display: flex; align-items: center; gap: .25rem;
  flex: 1; justify-content: center;
}
.nav-links a {
  font-family: var(--font-head); font-size: .84rem; font-weight: 600;
  color: var(--slate-600); padding: .4rem .75rem; border-radius: var(--r-sm);
  transition: all .15s; text-decoration: none;
}
.nav-links a:hover, .nav-links a.active {
  color: var(--emerald); background: var(--emerald-pale);
}
.nav-actions { display: flex; align-items: center; gap: .5rem; }
.nav-hamburger {
  display: none; background: none; border: 1.5px solid var(--slate-200);
  border-radius: var(--r-sm); cursor: pointer; padding: .4rem .5rem;
  color: var(--slate-600);
}
.nav-hamburger svg { width: 18px; height: 18px; }

/* ── Hero ──────────────────────────────────────────────────── */
.hero {
  background: var(--emerald-xd);
  padding: 3.75rem 0 3rem;
  position: relative; overflow: hidden;
}
.hero::after {
  content: '';
  position: absolute; bottom: -2px; left: 0; right: 0; height: 40px;
  background: var(--slate-50);
  clip-path: ellipse(55% 100% at 50% 100%);
}
.hero-inner { position: relative; text-align: center; max-width: 740px; margin: 0 auto; }
.hero h1 { color: #fff; margin-bottom: .6rem; }
.hero p  { color: rgba(255,255,255,.8); font-size: 1.02rem; margin-bottom: 1.75rem; max-width: 520px; margin-left: auto; margin-right: auto; }

.hero-search {
  max-width: 500px; margin: 0 auto 1.5rem;
  display: flex; background: #fff; border-radius: var(--r-sm);
  box-shadow: var(--shadow-lg); overflow: hidden;
  border: 2px solid transparent; transition: border-color .2s;
}
.hero-search:focus-within { border-color: var(--emerald-mid); }
.hero-search input {
  flex: 1; padding: .75rem 1.1rem; border: none; outline: none;
  font-family: var(--font-body); font-size: .93rem; color: var(--slate-800);
  background: transparent;
}
.hero-search button {
  background: var(--emerald); color: #fff; border: none; cursor: pointer;
  padding: 0 1.25rem; font-family: var(--font-head); font-size: .84rem; font-weight: 700;
  transition: background .15s; white-space: nowrap;
}
.hero-search button:hover { background: var(--emerald-dark); }

.hero-tags { display: flex; justify-content: center; gap: .5rem; flex-wrap: wrap; margin-bottom: 2rem; }
.hero-tag {
  font-size: .78rem; font-weight: 600; color: rgba(255,255,255,.75);
  background: rgba(255,255,255,.1); border: 1px solid rgba(255,255,255,.15);
  padding: .22rem .7rem; border-radius: var(--r-full);
  cursor: pointer; transition: all .15s; text-decoration: none;
}
.hero-tag:hover { background: rgba(255,255,255,.2); color: #fff; }

.hero-stats {
  display: flex; justify-content: center; gap: 0;
  margin-top: 2.5rem; padding-top: 2rem;
  border-top: 1px solid rgba(255,255,255,.12);
  flex-wrap: wrap;
}
.hero-stat { text-align: center; padding: 0 2rem; }
.hero-stat + .hero-stat { border-left: 1px solid rgba(255,255,255,.12); }
.hero-stat strong {
  display: block; font-family: var(--font-head);
  font-size: 1.7rem; font-weight: 800; color: #fff; line-height: 1;
  margin-bottom: .2rem;
}
.hero-stat span { font-size: .73rem; color: rgba(255,255,255,.6); text-transform: uppercase; letter-spacing: .06em; }

/* ── Filter Bar ────────────────────────────────────────────── */
.filter-bar {
  background: var(--white);
  border-bottom: 1px solid var(--slate-200);
  padding: .7rem 0;
  position: sticky; top: var(--nav-h); z-index: 90;
}
.filter-inner { display: flex; align-items: center; gap: .6rem; flex-wrap: wrap; }
.filter-label {
  font-family: var(--font-head); font-size: .72rem; font-weight: 700;
  text-transform: uppercase; letter-spacing: .07em;
  color: var(--slate-400); white-space: nowrap;
}
.filter-btns { display: flex; gap: .35rem; flex-wrap: wrap; }
.filter-btn {
  font-family: var(--font-head); font-size: .78rem; font-weight: 700;
  padding: .32rem .9rem; border-radius: var(--r-full);
  border: 1.5px solid var(--slate-200); background: var(--white);
  color: var(--slate-600); cursor: pointer; transition: all .15s;
  white-space: nowrap; text-decoration: none;
}
.filter-btn:hover  { border-color: var(--emerald); color: var(--emerald); }
.filter-btn.active { background: var(--emerald); border-color: var(--emerald); color: #fff; }
.filter-count { margin-left: auto; font-size: .78rem; color: var(--slate-400); white-space: nowrap; }

/* ── Main Content ──────────────────────────────────────────── */
main { flex: 1; padding: 1.75rem 0 3.5rem; }

.section-divider {
  display: flex; align-items: center; gap: .75rem;
  font-family: var(--font-head); font-size: .72rem; font-weight: 800;
  text-transform: uppercase; letter-spacing: .08em;
  color: var(--slate-500); margin: 1.75rem 0 1.1rem;
}
.section-divider::before, .section-divider::after {
  content: ''; flex: 1; height: 1px; background: var(--slate-200);
}
.section-divider::before { flex: 0 0 0; }

/* ── Featured Card ─────────────────────────────────────────── */
.featured-wrap {
  background: linear-gradient(135deg, var(--emerald-xd) 0%, #065f46 100%);
  border-radius: var(--r-lg); padding: 2.5rem;
  display: grid; grid-template-columns: auto 1fr;
  gap: 2.25rem; align-items: center;
  position: relative; overflow: hidden;
  box-shadow: var(--shadow-green);
  margin-bottom: 2rem;
}
.featured-wrap::before {
  content: '';
  position: absolute; top: -40px; right: -40px;
  width: 220px; height: 220px;
  background: radial-gradient(circle, rgba(110,231,183,.15) 0%, transparent 70%);
  pointer-events: none;
}
.featured-ribbon {
  position: absolute; top: 18px; right: -26px;
  background: var(--amber); color: #fff;
  font-family: var(--font-head); font-size: .62rem; font-weight: 800;
  letter-spacing: .08em; text-transform: uppercase;
  padding: .22rem 2.5rem; transform: rotate(45deg);
}
.featured-logo {
  width: 88px; height: 88px; border-radius: var(--r-md);
  object-fit: contain; background: rgba(255,255,255,.95);
  padding: .6rem; border: 2px solid rgba(255,255,255,.2);
  flex-shrink: 0;
}
.featured-body { display: flex; flex-direction: column; gap: .75rem; }
.featured-body h2 { color: #fff; font-size: 1.45rem; margin: 0; }
.featured-body > p { color: rgba(255,255,255,.78); font-size: .88rem; margin: 0; line-height: 1.7; }
.featured-pills { display: flex; flex-wrap: wrap; gap: .4rem; margin: 0; }
.featured-pill {
  font-family: var(--font-head); font-size: .72rem; font-weight: 700;
  padding: .22rem .65rem; border-radius: var(--r-full);
  background: rgba(255,255,255,.12); color: rgba(255,255,255,.9);
  border: 1px solid rgba(255,255,255,.18);
}
.featured-pill.upi { background: rgba(110,231,183,.2); color: var(--emerald-mid); border-color: rgba(110,231,183,.25); }
.featured-actions { display: flex; gap: .65rem; flex-wrap: wrap; }
.featured-rating { margin-top: .85rem; font-size: .8rem; color: rgba(255,255,255,.6); }
.featured-rating strong { color: var(--emerald-mid); }

/* ── Survey Grid ───────────────────────────────────────────── */
.survey-grid     { display: grid; grid-template-columns: repeat(3,1fr); gap: 1.1rem; }
.survey-grid-2   { grid-template-columns: repeat(2,1fr); }

/* ── Survey Card ───────────────────────────────────────────── */
.survey-card {
  background: var(--white);
  border: 1.5px solid var(--slate-200);
  border-radius: var(--r-md);
  padding: 1.25rem;
  display: flex; flex-direction: column;
  transition: box-shadow .22s cubic-bezier(.4,0,.2,1), transform .22s, border-color .2s;
  cursor: pointer;
}
.survey-card:hover {
  box-shadow: var(--shadow-lg);
  transform: translateY(-4px);
  border-color: var(--emerald);
}
.card-head { display: flex; align-items: flex-start; gap: .85rem; margin-bottom: .85rem; }
.card-logo {
  width: 50px; height: 50px; flex-shrink: 0;
  border: 1.5px solid var(--slate-200); border-radius: var(--r-sm);
  object-fit: contain; padding: .3rem; background: var(--white);
  transition: border-color .2s;
}
.survey-card:hover .card-logo { border-color: var(--emerald); }
.card-title-area { flex: 1; min-width: 0; }
.card-title-area h4 { margin-bottom: .15rem; white-space: nowrap; overflow: hidden; text-overflow: ellipsis; }
.card-rank { font-family: var(--font-head); font-size: .65rem; font-weight: 800; text-transform: uppercase; letter-spacing: .06em; color: var(--emerald); }
.card-desc {
  font-size: .82rem; color: var(--slate-500); line-height: 1.65;
  flex: 1; margin-bottom: .85rem;
  display: -webkit-box; -webkit-line-clamp: 3; -webkit-box-orient: vertical; overflow: hidden;
}
.card-foot {
  display: flex; align-items: center; justify-content: space-between;
  flex-wrap: wrap; gap: .4rem; margin-top: auto;
  padding-top: .75rem; border-top: 1px solid var(--slate-100);
}
.card-stars { color: var(--amber); font-size: .82rem; letter-spacing: -.03em; }
.card-rev   { font-size: .73rem; color: var(--slate-400); }
.card-link  {
  font-family: var(--font-head); font-size: .78rem; font-weight: 700;
  color: var(--emerald); display: flex; align-items: center; gap: .2rem;
  transition: gap .15s;
}
.card-link:hover { gap: .45rem; }
.card-link svg { width: 13px; height: 13px; }

/* ── Ranked 2-col cards ────────────────────────────────────── */
.ranked-card { border: 2px solid var(--emerald-light); background: var(--emerald-pale); }
.ranked-card:hover { border-color: var(--emerald); }

/* ── Info Strip ────────────────────────────────────────────── */
.info-strip { display: grid; grid-template-columns: repeat(3,1fr); gap: 1rem; margin: 2.5rem 0 1.5rem; }
.info-item {
  background: var(--white); border: 1.5px solid var(--slate-200);
  border-radius: var(--r-md); padding: 1.5rem; text-align: center;
  transition: box-shadow .2s;
}
.info-item:hover { box-shadow: var(--shadow-sm); }
.info-emoji { font-size: 2rem; margin-bottom: .65rem; display: block; }
.info-item h3 { font-size: .97rem; margin-bottom: .35rem; }
.info-item p  { font-size: .83rem; }

/* ── CTA Section ───────────────────────────────────────────── */
.cta-section {
  background: linear-gradient(135deg, var(--emerald-xd), var(--emerald-dark));
  border-radius: var(--r-lg); padding: 3rem 2.5rem;
  text-align: center; margin: 2rem 0;
  position: relative; overflow: hidden;
}
.cta-section::before {
  content: ''; position: absolute; inset: 0;
  background: url("data:image/svg+xml,%3Csvg width='40' height='40' viewBox='0 0 40 40' xmlns='http://www.w3.org/2000/svg'%3E%3Cg fill='%23ffffff' fill-opacity='0.03'%3E%3Ccircle cx='20' cy='20' r='3'/%3E%3C/g%3E%3C/svg%3E");
}
.cta-section h2 { color: #fff; position: relative; }
.cta-section p  { color: rgba(255,255,255,.8); position: relative; margin-bottom: 1.5rem; }

/* ── Page Card ─────────────────────────────────────────────── */
.page-wrap { padding: 1.5rem 0 3rem; }
.page-card {
  background: var(--white); border: 1.5px solid var(--slate-200);
  border-radius: var(--r-lg); padding: 2.75rem 3rem; margin-bottom: 1.5rem;
}
.page-card h1 { margin-bottom: 1.5rem; }
.page-card h2 { font-size: 1.15rem; margin: 2rem 0 .65rem; color: var(--emerald-dark); }
.page-card h3 { font-size: 1rem; margin: 1.5rem 0 .5rem; }
.page-card p  { font-size: .9rem; margin-bottom: .9rem; }
.page-card ul { margin: .65rem 0 1rem 1.4rem; list-style: disc; }
.page-card ul li { margin-bottom: .4rem; font-size: .9rem; color: var(--slate-600); }
.page-intro { font-size: 1.05rem !important; color: var(--slate-700) !important; font-weight: 500; line-height: 1.75 !important; }
.page-lead { background: var(--emerald-pale); border-left: 3px solid var(--emerald); border-radius: 0 var(--r-sm) var(--r-sm) 0; padding: 1rem 1.25rem; margin-bottom: 1.75rem; }
.page-lead p { color: var(--emerald-xd); font-size: .9rem; margin: 0; font-weight: 500; }

/* ── Breadcrumb ────────────────────────────────────────────── */
.breadcrumb {
  display: flex; align-items: center; gap: .35rem;
  font-size: .8rem; color: var(--slate-400);
  padding: .65rem 0; flex-wrap: wrap;
}
.breadcrumb a { color: var(--emerald); font-weight: 500; }
.breadcrumb-sep { color: var(--slate-300); }

/* ── Detail Page ───────────────────────────────────────────── */
.detail-hero-card {
  background: var(--white); border: 1.5px solid var(--slate-200);
  border-radius: var(--r-lg); padding: 2rem;
  display: flex; align-items: flex-start; gap: 1.75rem;
  margin-bottom: 1.5rem; flex-wrap: wrap;
}
.detail-logo {
  width: 100px; height: 100px; border: 1.5px solid var(--slate-200);
  border-radius: var(--r-md); padding: .75rem; object-fit: contain; flex-shrink: 0;
}
.detail-info { flex: 1; min-width: 240px; }
.detail-meta { display: flex; flex-wrap: wrap; gap: .35rem; margin: .6rem 0; }
.detail-actions { display: flex; gap: .65rem; flex-wrap: wrap; margin-top: 1rem; }
.detail-grid { display: grid; grid-template-columns: 1fr 340px; gap: 1.5rem; align-items: start; }
.detail-section {
  background: var(--white); border: 1.5px solid var(--slate-200);
  border-radius: var(--r-md); padding: 1.6rem; margin-bottom: 1.25rem;
}
.detail-section h3 { margin-bottom: .85rem; padding-bottom: .6rem; border-bottom: 1px solid var(--slate-100); }
.detail-section p  { font-size: .88rem; }
.quick-facts { display: grid; grid-template-columns: 1fr 1fr; gap: .5rem .75rem; }
.qf-item {}
.qf-label { font-family: var(--font-head); font-size: .7rem; font-weight: 700; text-transform: uppercase; letter-spacing: .05em; color: var(--slate-400); margin-bottom: .1rem; }
.qf-val   { font-size: .88rem; font-weight: 600; color: var(--slate-800); }

/* ── Alerts ────────────────────────────────────────────────── */
.alert { border-radius: var(--r-sm); padding: .85rem 1.1rem; margin-bottom: 1rem; font-size: .87rem; line-height: 1.6; }
.alert-success { background: var(--emerald-light); color: var(--emerald-xd); border: 1px solid #6ee7b7; }
.alert-error   { background: #fee2e2; color: #991b1b; border: 1px solid #fca5a5; }
.alert-info    { background: var(--blue-bg); color: #1e40af; border: 1px solid #93c5fd; }
.alert-warning { background: var(--amber-bg); color: #78350f; border: 1px solid #fcd34d; }

/* ── Forms ─────────────────────────────────────────────────── */
.form-group { margin-bottom: 1.1rem; }
.form-group label { display: block; font-family: var(--font-head); font-size: .82rem; font-weight: 700; margin-bottom: .4rem; color: var(--slate-700); }
.form-control {
  width: 100%; padding: .68rem 1rem;
  border: 1.5px solid var(--slate-300); border-radius: var(--r-sm);
  font-family: var(--font-body); font-size: .9rem; color: var(--slate-800);
  background: var(--white); transition: border-color .15s, box-shadow .15s; outline: none;
}
.form-control:focus { border-color: var(--emerald); box-shadow: 0 0 0 3px rgba(5,150,105,.1); }
textarea.form-control { resize: vertical; min-height: 110px; }

/* ── Footer ────────────────────────────────────────────────── */
.site-footer {
  background: var(--slate-900); color: rgba(255,255,255,.6);
  padding: 3rem 0 1.75rem; margin-top: auto;
}
.footer-grid {
  display: grid; grid-template-columns: 2.2fr 1fr 1fr 1fr;
  gap: 2rem; margin-bottom: 2.75rem;
}
.footer-brand .logo-text {
  font-family: var(--font-head); font-weight: 800; font-size: 1.1rem;
  color: #fff; display: flex; align-items: center; gap: .4rem; margin-bottom: .75rem;
}
.footer-brand .logo-dot { width: 8px; height: 8px; border-radius: 50%; background: var(--emerald); display: inline-block; }
.footer-brand p { font-size: .83rem; line-height: 1.75; max-width: 290px; }
.footer-brand .footer-email { font-size: .82rem; color: rgba(255,255,255,.5); margin-top: .6rem; }
.footer-brand .footer-email a { color: var(--emerald); }
.footer-col h4 { font-family: var(--font-head); font-size: .82rem; font-weight: 800; color: #fff; text-transform: uppercase; letter-spacing: .07em; margin-bottom: 1rem; }
.footer-col ul li { margin-bottom: .42rem; }
.footer-col ul li a { font-size: .83rem; color: rgba(255,255,255,.55); transition: color .15s; }
.footer-col ul li a:hover { color: #fff; }
.footer-col ul li a.footer-featured { color: var(--emerald-mid); font-weight: 600; }
.footer-bottom {
  border-top: 1px solid rgba(255,255,255,.08); padding-top: 1.5rem;
  display: flex; justify-content: space-between; align-items: center; flex-wrap: wrap; gap: .75rem;
}
.footer-bottom-links { display: flex; gap: 1.5rem; }
.footer-bottom p, .footer-bottom a { font-size: .78rem; color: rgba(255,255,255,.4); }
.footer-bottom a:hover { color: rgba(255,255,255,.8); }

/* ── About page specifics ──────────────────────────────────── */
.feature-grid { display: grid; grid-template-columns: repeat(2,1fr); gap: 1rem; margin: 1.5rem 0; }
.feature-item { background: var(--slate-50); border: 1.5px solid var(--slate-200); border-radius: var(--r-md); padding: 1.25rem; }
.feature-item .fi-icon { font-size: 1.5rem; margin-bottom: .5rem; }
.feature-item h4 { margin-bottom: .3rem; font-size: .95rem; }
.feature-item p  { font-size: .84rem; }
.audience-grid { display: grid; grid-template-columns: repeat(4,1fr); gap: .75rem; margin: 1.25rem 0; }
.audience-card { text-align: center; background: var(--emerald-pale); border: 1.5px solid var(--emerald-light); border-radius: var(--r-md); padding: 1.25rem .75rem; }
.audience-card .ac-icon { font-size: 1.6rem; margin-bottom: .4rem; }
.audience-card h4 { font-size: .9rem; color: var(--emerald-xd); }

/* ── FAQ specifics ─────────────────────────────────────────── */
.faq-item { border: 1.5px solid var(--slate-200); border-radius: var(--r-md); margin-bottom: .65rem; overflow: hidden; }
.faq-q {
  padding: 1rem 1.25rem; cursor: pointer; font-family: var(--font-head);
  font-size: .92rem; font-weight: 700; color: var(--slate-800);
  display: flex; justify-content: space-between; align-items: center;
  transition: background .15s; user-select: none;
}
.faq-q:hover { background: var(--slate-50); }
.faq-q.open  { color: var(--emerald); background: var(--emerald-pale); border-bottom: 1px solid var(--emerald-light); }
.faq-q .faq-icon { font-size: .9rem; transition: transform .25s; flex-shrink: 0; margin-left: 1rem; }
.faq-q.open .faq-icon { transform: rotate(180deg); }
.faq-a { padding: 0 1.25rem; max-height: 0; overflow: hidden; transition: max-height .35s ease, padding .3s; }
.faq-a.open { padding: 1rem 1.25rem; max-height: 500px; }
.faq-a p { font-size: .88rem; margin: 0; }

/* ── Misc utilities ────────────────────────────────────────── */
.mt-1 { margin-top: .5rem; }
.mt-2 { margin-top: 1rem; }
.mt-3 { margin-top: 1.75rem; }
.mb-1 { margin-bottom: .5rem; }
.mb-2 { margin-bottom: 1rem; }
.text-center { text-align: center; }
.text-emerald { color: var(--emerald); }
.text-muted   { color: var(--slate-500); }
.fw-700 { font-weight: 700; }
.font-head { font-family: var(--font-head); }
.hidden { display: none; }

/* ── Responsive ────────────────────────────────────────────── */
@media (max-width: 1024px) {
  .survey-grid    { grid-template-columns: repeat(2,1fr); }
  .detail-grid    { grid-template-columns: 1fr; }
  .footer-grid    { grid-template-columns: 1fr 1fr; gap: 1.5rem; }
  .audience-grid  { grid-template-columns: repeat(2,1fr); }
}

@media (max-width: 768px) {
  .nav-links, .nav-actions .btn:not(.nav-mobile-cta) { display: none; }
  .nav-links.open {
    display: flex; flex-direction: column;
    position: absolute; top: calc(var(--nav-h) + 1px);
    left: 0; right: 0;
    background: var(--white); border-bottom: 1.5px solid var(--slate-200);
    padding: .75rem 1.25rem; gap: .25rem; z-index: 99;
    box-shadow: var(--shadow-md);
  }
  .nav-links.open a { padding: .6rem .85rem; border-radius: var(--r-sm); }
  .nav-hamburger { display: flex; align-items: center; }

  .featured-wrap { grid-template-columns: 1fr; }
  .featured-ribbon { display: none; }
  

/* ── PATCH: Additional fixes ──────────────────────────────── */

/* Card logo — bigger on all screens */
.card-logo {
  width: 64px !important;
  height: 64px !important;
  padding: .4rem !important;
}

/* Info strip — fix emoji size and card spacing */
.info-strip {
  margin: 4rem 0 2.5rem !important;
  gap: 1.5rem !important;
}
.info-item {
  padding: 2.5rem 2rem !important;
  border-radius: var(--r-lg) !important;
}
.info-item h3 { font-size: 1.1rem !important; margin-bottom: .5rem !important; }
.info-item p  { font-size: .9rem !important; line-height: 1.7 !important; }
.info-emoji {
  font-size: 2.75rem !important;
  margin-bottom: 1rem !important;
  display: block;
  line-height: 1;
}

/* CTA section — fix button and spacing */
.cta-section {
  margin: 4rem 0 2rem !important;
  padding: 4rem 3rem !important;
}
.cta-section h2 { font-size: 2rem !important; }
.cta-section h2 { margin-bottom: .6rem !important; }
.cta-section p  { max-width: 520px; margin: 0 auto 1.75rem !important; }
.cta-section .btn-white {
  display: inline-flex !important;
  width: auto !important;
  padding: .85rem 2.25rem !important;
  font-size: .98rem !important;
  box-shadow: 0 4px 18px rgba(0,0,0,.15);
}

/* FAQ page styles */
.faq-page-wrap { max-width: 820px; margin: 0 auto; padding: 2.5rem 1.25rem; }
.faq-page-title { margin-bottom: .5rem; }
.faq-page-subtitle { font-size: 1.05rem; color: var(--slate-500); margin-bottom: 2.5rem; }
.faq-group { margin-bottom: 2.5rem; }
.faq-group-title {
  font-family: var(--font-head); font-size: .72rem; font-weight: 800;
  text-transform: uppercase; letter-spacing: .1em; color: var(--slate-400);
  margin-bottom: 1rem; padding-bottom: .5rem;
  border-bottom: 1px solid var(--slate-200);
  display: flex; align-items: center; gap: .5rem;
}
.faq-item { border: 1.5px solid var(--slate-200); border-radius: var(--r-md); margin-bottom: .55rem; overflow: hidden; background: var(--white); }
.faq-q {
  padding: 1.1rem 1.35rem; cursor: pointer;
  font-family: var(--font-head); font-size: .93rem; font-weight: 700; color: var(--slate-800);
  display: flex; justify-content: space-between; align-items: center;
  transition: background .15s; user-select: none; gap: 1rem;
}
.faq-q .faq-icon-q { color: var(--emerald); font-size: .85rem; flex-shrink: 0; }
.faq-q:hover { background: var(--slate-50); }
.faq-q.open   { background: var(--emerald-pale); color: var(--emerald-xd); border-bottom: 1px solid var(--emerald-light); }
.faq-q .faq-chevron { font-size: .8rem; transition: transform .25s; flex-shrink: 0; }
.faq-q.open .faq-chevron { transform: rotate(180deg); }
.faq-a { max-height: 0; overflow: hidden; transition: max-height .35s ease, padding .3s; padding: 0 1.35rem; }
.faq-a.open { max-height: 600px; padding: .9rem 1.35rem 1.1rem; }
.faq-a p { font-size: .88rem; color: var(--slate-600); margin: 0; line-height: 1.8; }

/* Contact page */
.contact-wrap { max-width: 620px; margin: 0 auto; padding: 2.5rem 1.25rem; }
.contact-card { background: var(--white); border: 1.5px solid var(--slate-200); border-radius: var(--r-lg); padding: 2.5rem; }
.contact-info-strip { display: grid; grid-template-columns: 1fr 1fr; gap: .75rem; margin: 1.75rem 0; }
.contact-info-item { background: var(--slate-50); border: 1.5px solid var(--slate-200); border-radius: var(--r-sm); padding: 1rem; }
.contact-info-item .ci-label { font-size: .7rem; font-weight: 800; text-transform: uppercase; letter-spacing: .06em; color: var(--slate-400); margin-bottom: .3rem; }
.contact-info-item .ci-val   { font-size: .87rem; font-weight: 600; color: var(--slate-800); }
.contact-info-item a { color: var(--emerald); }
.contact-divider { display: flex; align-items: center; gap: .75rem; margin: 1.75rem 0; }
.contact-divider::before, .contact-divider::after { content:''; flex:1; height:1px; background:var(--slate-200); }
.contact-divider span { font-size: .75rem; font-weight: 700; color: var(--slate-400); text-transform: uppercase; letter-spacing: .06em; }

@media (max-width: 640px) {
  .contact-info-strip { grid-template-columns: 1fr; }
  .contact-card { padding: 1.5rem; }
  .card-logo { width: 52px !important; height: 52px !important; }
}

/* ── COLOUR SCHEME PATCH ───────────────────────────────────── */

/* Ranked cards #2-5: Rich blue tint — clearly different from green */
.ranked-card {
  background: #eff6ff !important;
  border: 2px solid #93c5fd !important;
}
.ranked-card:hover {
  border-color: #3b82f6 !important;
  box-shadow: 0 12px 32px rgba(59,130,246,.15) !important;
}
.ranked-card .card-rank { color: #2563eb !important; }
.ranked-card .card-link { color: #2563eb !important; }

/* Unranked cards: Warm white with clear visible border */
.plain-card {
  background: #fffdf7 !important;
  border: 1.5px solid #e5e0d5 !important;
}
.plain-card:hover {
  border-color: var(--emerald) !important;
  background: var(--white) !important;
}

/* Featured actions handled in main section */

/* Nav actions — no join free button now, just hamburger */
.nav-actions {
  display: flex;
  align-items: center;
  gap: .5rem;
}
-------------------- END OF FILE --------------------

### FILE 12: PSH IN/config/config.php
- Type: PHP
- Size: 2.62 KB
- Path: PSH IN/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://www.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 13: PSH IN/includes/footer.php
- Type: PHP
- Size: 2.98 KB
- Path: PSH IN/includes
- Name: footer.php
------------------------------------------------------------
<footer class="site-footer" role="contentinfo">
    <div class="container">
        <div class="footer-grid">
            <div class="footer-brand">
                <div class="logo-text">
                    <span class="logo-dot"></span> PaidSurveyHub India
                </div>
                <p>India's most complete directory of verified paid online survey sites. We research, test and list platforms that genuinely accept Indian members — so you can focus on earning.</p>
                <p class="footer-email">📧 <a href="mailto:gethelp@paidsurveyhub.in">gethelp@paidsurveyhub.in</a></p>
            </div>
            <div class="footer-col">
                <h4>Survey Sites</h4>
                <ul>
                    <li><a href="<?php echo SITE_URL; ?>/">All Sites</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/?filter=india">🇮🇳 India-Based</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/?filter=upi">💳 UPI Payment</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/?filter=top">⭐ Top Rated</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/survey-detail.php?id=1" class="footer-featured">★ Relevant Reflex</a></li>
                </ul>
            </div>
            <div class="footer-col">
                <h4>Info</h4>
                <ul>
                    <li><a href="<?php echo SITE_URL; ?>/about-us.php">About Us</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/faq.php">FAQ</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/contact.php">Contact</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/privacy-policy.php">Privacy Policy</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/terms-conditions.php">Terms</a></li>
                </ul>
            </div>
            <div class="footer-col">
                <h4>For Earners</h4>
                <ul>
                    <li><a href="<?php echo SITE_URL; ?>/faq.php#getting-started">Getting Started</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/faq.php#upi-payment">UPI Payment Guide</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/faq.php#avoid-scams">Avoid Scams</a></li>
                    <li><a href="<?php echo SITE_URL; ?>/faq.php#tips">Earning Tips</a></li>
                    <li><a href="https://relevantreflex.com/articles.php" target="_blank" rel="noopener">Survey Guides ↗</a></li>
                </ul>
            </div>
        </div>
        <div class="footer-bottom">
            <p>© <?php echo date('Y'); ?> Paid Survey Hub India. All rights reserved. We are a directory — not a survey company.</p>
            <div class="footer-bottom-links">
                <a href="<?php echo SITE_URL; ?>/privacy-policy.php">Privacy</a>
                <a href="<?php echo SITE_URL; ?>/terms-conditions.php">Terms</a>
                <a href="<?php echo SITE_URL; ?>/contact.php">Contact</a>
            </div>
        </div>
    </div>
</footer>
</body>
</html>
-------------------- END OF FILE --------------------

### FILE 14: PSH IN/includes/header.php
- Type: PHP
- Size: 5.74 KB
- Path: PSH IN/includes
- Name: header.php
------------------------------------------------------------
<!DOCTYPE html>
<html lang="en">
<head>
    <!-- Google Tag -->
    <script async src="https://www.googletagmanager.com/gtag/js?id=AW-17649955598"></script>
    <script>
        window.dataLayer = window.dataLayer || [];
        function gtag(){dataLayer.push(arguments);}
        gtag('js', new Date()); gtag('config', 'AW-17649955598');
    </script>

    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo isset($page_title) ? htmlspecialchars($page_title) : 'Best Paid Survey Sites India 2026 | PaidSurveyHub'; ?></title>
    <meta name="description" content="<?php echo isset($meta_description) ? htmlspecialchars($meta_description) : 'Discover 25+ verified paid survey sites for Indian users in 2026. Compare platforms, payment methods and start earning. Free directory — no signup needed.'; ?>">
    <?php if (!empty($meta_keywords)): ?><meta name="keywords" content="<?php echo htmlspecialchars($meta_keywords); ?>"><?php endif; ?>
    <meta name="author" content="Paid Survey Hub India">
    <meta name="robots" content="<?php echo isset($robots) ? htmlspecialchars($robots) : 'index, follow'; ?>">
    <link rel="canonical" href="<?php echo isset($canonical) ? htmlspecialchars($canonical) : SITE_URL . strtok($_SERVER['REQUEST_URI'],'?'); ?>">

    <!-- Open Graph -->
    <meta property="og:type"        content="website">
    <meta property="og:site_name"   content="Paid Survey Hub India">
    <meta property="og:title"       content="<?php echo isset($page_title) ? htmlspecialchars($page_title) : 'Paid Survey Hub India'; ?>">
    <meta property="og:description" content="<?php echo isset($meta_description) ? htmlspecialchars($meta_description) : 'India\'s most complete survey site directory.'; ?>">
    <meta property="og:url"         content="<?php echo isset($canonical) ? htmlspecialchars($canonical) : SITE_URL . $_SERVER['REQUEST_URI']; ?>">
    <meta property="og:image"       content="<?php echo SITE_URL; ?>/assets/og-image.png">
    <meta name="twitter:card"       content="summary_large_image">
    <meta name="twitter:title"      content="<?php echo isset($page_title) ? htmlspecialchars($page_title) : 'Paid Survey Hub India'; ?>">
    <meta name="twitter:description" content="<?php echo isset($meta_description) ? htmlspecialchars($meta_description) : 'India\'s most complete survey site directory.'; ?>">

    <link rel="icon" type="image/png" href="<?php echo SITE_URL; ?>/assets/favicon.png">
    <link rel="apple-touch-icon"      href="<?php echo SITE_URL; ?>/assets/favicon.png">

    <!-- Organisation + Website Schema -->
    <script type="application/ld+json">
    {"@context":"https://schema.org","@graph":[
      {"@type":"Organization","@id":"<?php echo SITE_URL; ?>/#org","name":"Paid Survey Hub India","url":"<?php echo SITE_URL; ?>","email":"gethelp@paidsurveyhub.in"},
      {"@type":"WebSite","@id":"<?php echo SITE_URL; ?>/#web","name":"Paid Survey Hub India","url":"<?php echo SITE_URL; ?>","publisher":{"@id":"<?php echo SITE_URL; ?>/#org"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"<?php echo SITE_URL; ?>/?search={search_term_string}"},"query-input":"required name=search_term_string"}}
    ]}
    </script>
    <?php if (!empty($extra_schema)) echo $extra_schema; ?>

    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link rel="stylesheet" href="<?php echo SITE_URL; ?>/assets/style.css">
</head>
<body>

<!-- Notice Bar -->
<div class="notice-bar" role="banner">
    <div class="container">
        <p>🇮🇳 India's most complete survey directory &nbsp;—&nbsp; <strong>free to browse, no signup needed</strong> &nbsp;|&nbsp; <a href="<?php echo SITE_URL; ?>/">View all survey sites →</a></p>
    </div>
</div>

<!-- Navigation -->
<nav class="site-nav" role="navigation" aria-label="Main navigation">
    <div class="container">
        <div class="nav-inner">
            <a href="<?php echo SITE_URL; ?>/" class="nav-logo" aria-label="Paid Survey Hub India Home">
                <span class="nav-logo-icon">🔍</span>
                <span>PaidSurvey<span class="accent">Hub</span></span>
            </a>

            <div class="nav-links" id="navLinks">
                <a href="<?php echo SITE_URL; ?>/"           class="<?php echo basename($_SERVER['PHP_SELF'])=='index.php' ? 'active':'' ?>">Survey Sites</a>
                <a href="<?php echo SITE_URL; ?>/about-us.php" class="<?php echo basename($_SERVER['PHP_SELF'])=='about-us.php' ? 'active':'' ?>">About</a>
                <a href="<?php echo SITE_URL; ?>/faq.php"      class="<?php echo basename($_SERVER['PHP_SELF'])=='faq.php' ? 'active':'' ?>">FAQ</a>
                <a href="<?php echo SITE_URL; ?>/contact.php"  class="<?php echo basename($_SERVER['PHP_SELF'])=='contact.php' ? 'active':'' ?>">Contact</a>
            </div>

            <div class="nav-actions">
                <button class="nav-hamburger" id="navHamburger" aria-label="Toggle navigation" aria-expanded="false" aria-controls="navLinks">
                    <svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M4 6h16M4 12h16M4 18h16"/></svg>
                </button>
            </div>
        </div>
    </div>
</nav>

<script>
(function(){
    var btn=document.getElementById('navHamburger'),nav=document.getElementById('navLinks');
    if(btn&&nav){btn.addEventListener('click',function(){var o=nav.classList.toggle('open');btn.setAttribute('aria-expanded',o);});}
    // Close on outside click
    document.addEventListener('click',function(e){if(nav.classList.contains('open')&&!nav.contains(e.target)&&!btn.contains(e.target)){nav.classList.remove('open');btn.setAttribute('aria-expanded','false');}});
})();
</script>
-------------------- END OF FILE --------------------

### FILE 15: PSH IN/management/add-survey.php
- Type: PHP
- Size: 6.29 KB
- Path: PSH IN/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']);
    $rank = $_POST['rank'] !== '' ? (int)$_POST['rank'] : NULL;
    $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 except rank are required";
    } elseif (!isset($_FILES['image']) || $_FILES['image']['error'] != 0) {
        $error = "Please upload an image";
    } else {
        // Check if rank already exists
        if ($rank !== NULL) {
            $check_rank = "SELECT id FROM survey_sites WHERE rank = $rank";
            $rank_result = $conn->query($check_rank);
            if ($rank_result->num_rows > 0) {
                $error = "Rank #$rank is already assigned to another survey";
            }
        }
        
        if (empty($error)) {
            // 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)) {
                    $rank_value = $rank !== NULL ? $rank : 'NULL';
                    
                    // Insert survey site
                    $sql = "INSERT INTO survey_sites (rank, title, website_link, description, support_contact, image) 
                            VALUES ($rank_value, '$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="rank">Ranking (Optional)</label>
                    <input type="number" id="rank" name="rank" min="1" 
                           value="<?php echo isset($_POST['rank']) ? htmlspecialchars($_POST['rank']) : ''; ?>"
                           placeholder="Leave empty for no ranking">
                    <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">
                        Rank #1 displays full-width. Ranks #2+ display 2 per row. Unranked sites display 3 per row (randomized).
                    </small>
                </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 16: PSH IN/management/change-password.php
- Type: PHP
- Size: 4.45 KB
- Path: PSH IN/management
- Name: change-password.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

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

$admin_id = $_SESSION['admin_id'];
$error = '';
$success = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $current_password = $_POST['current_password'];
    $new_password = $_POST['new_password'];
    $confirm_password = $_POST['confirm_password'];
    
    // Validation
    if (empty($current_password) || empty($new_password) || empty($confirm_password)) {
        $error = "All fields are required";
    } elseif (strlen($new_password) < 6) {
        $error = "New password must be at least 6 characters long";
    } elseif ($new_password !== $confirm_password) {
        $error = "New password and confirm password do not match";
    } else {
        // Get current admin details
        $sql = "SELECT password FROM admins WHERE id = $admin_id";
        $result = $conn->query($sql);
        
        if ($result->num_rows > 0) {
            $admin = $result->fetch_assoc();
            
            // Verify current password
            if (password_verify($current_password, $admin['password'])) {
                // Hash new password
                $hashed_password = password_hash($new_password, PASSWORD_DEFAULT);
                
                // Update password
                $update_sql = "UPDATE admins SET password = '$hashed_password' WHERE id = $admin_id";
                
                if ($conn->query($update_sql)) {
                    $success = "Password changed successfully!";
                    // Clear form fields
                    $_POST = array();
                } else {
                    $error = "Failed to update password. Please try again.";
                }
            } else {
                $error = "Current password is incorrect";
            }
        } else {
            $error = "Admin not found";
        }
    }
}

$page_title = 'Change Password';
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">Change Admin Password</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; ?>
        
        <div style="max-width: 500px;">
            <form method="POST" action="">
                <div class="form-group">
                    <label for="current_password">Current Password *</label>
                    <input type="password" id="current_password" name="current_password" required autocomplete="current-password">
                </div>
                
                <div class="form-group">
                    <label for="new_password">New Password *</label>
                    <input type="password" id="new_password" name="new_password" required minlength="6" autocomplete="new-password">
                    <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">Minimum 6 characters</small>
                </div>
                
                <div class="form-group">
                    <label for="confirm_password">Confirm New Password *</label>
                    <input type="password" id="confirm_password" name="confirm_password" required minlength="6" autocomplete="new-password">
                </div>
                
                <button type="submit" class="btn btn-primary">Change Password</button>
            </form>
        </div>
        
        <div style="background: #fff3cd; padding: 1.5rem; border-radius: 8px; margin-top: 2rem; border-left: 4px solid #ffc107;">
            <h3 style="color: var(--navy-blue); margin-bottom: 0.5rem;">🔒 Password Security Tips</h3>
            <ul style="margin: 0.5rem 0 0 1.5rem; line-height: 1.8;">
                <li>Use at least 8 characters (minimum 6 required)</li>
                <li>Mix uppercase and lowercase letters</li>
                <li>Include numbers and special characters</li>
                <li>Don't use common words or personal information</li>
                <li>Change your password regularly</li>
            </ul>
        </div>
    </div>
</div>

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

### FILE 17: PSH IN/management/dashboard.php
- Type: PHP
- Size: 8.75 KB
- Path: PSH IN/management
- Name: dashboard.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

// ── Stats ─────────────────────────────────────────────────────
$total_surveys   = $conn->query("SELECT COUNT(*) as c FROM survey_sites")->fetch_assoc()['c'];
$ranked_surveys  = $conn->query("SELECT COUNT(*) as c FROM survey_sites WHERE rank IS NOT NULL")->fetch_assoc()['c'];

$pending_reviews = $conn->query("SELECT COUNT(*) as c FROM survey_reviews WHERE is_approved = 0")->fetch_assoc()['c'];
$total_reviews   = $conn->query("SELECT COUNT(*) as c FROM survey_reviews WHERE is_approved = 1")->fetch_assoc()['c'];

$new_tickets     = $conn->query("SELECT COUNT(*) as c FROM contact_messages WHERE ticket_status = 'new'")->fetch_assoc()['c'];
$open_tickets    = $conn->query("SELECT COUNT(*) as c FROM contact_messages WHERE ticket_status IN ('new','in_progress')")->fetch_assoc()['c'];

// Newsletter subscribers table may not exist yet — handle gracefully
$active_subs = 0;
$today_subs  = 0;
$subs_check = $conn->query("SHOW TABLES LIKE 'newsletter_subscribers'");
if ($subs_check && $subs_check->num_rows > 0) {
    $active_subs = $conn->query("SELECT COUNT(*) as c FROM newsletter_subscribers WHERE is_active = 1")->fetch_assoc()['c'];
    $today_subs  = $conn->query("SELECT COUNT(*) as c FROM newsletter_subscribers WHERE DATE(created_at) = CURDATE()")->fetch_assoc()['c'];
}

// Recent activity
$recent_reviews = $conn->query("SELECT r.reviewer_name, r.rating, r.created_at, s.title
                                FROM survey_reviews r
                                JOIN survey_sites s ON r.survey_id = s.id
                                WHERE r.is_approved = 0
                                ORDER BY r.created_at DESC LIMIT 5");

$recent_tickets = $conn->query("SELECT id, name, email, ticket_status, created_at
                                FROM contact_messages
                                ORDER BY created_at DESC LIMIT 5");

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

<div class="dash-wrap">

    <div class="dash-header">
        <div>
            <h1 class="dash-title">Dashboard</h1>
            <p class="dash-sub">Welcome back, <?php echo htmlspecialchars($_SESSION['admin_username'] ?? 'Admin'); ?> — <?php echo date('l, d F Y'); ?></p>
        </div>
        <a href="<?php echo SITE_URL; ?>/" target="_blank" class="dash-view-site">↗ View Site</a>
    </div>

    <!-- ── Stat Cards ───────────────────────────────────────── -->
    <div class="stat-grid">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-surveys.php" class="stat-card">
            <div class="stat-icon" style="background:#dcfce7;color:#059669;">📋</div>
            <div class="stat-body">
                <div class="stat-num"><?php echo $total_surveys; ?></div>
                <div class="stat-label">Survey Sites</div>
                <div class="stat-sub"><?php echo $ranked_surveys; ?> ranked</div>
            </div>
        </a>

        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-reviews.php?status=pending" class="stat-card <?php echo $pending_reviews > 0 ? 'stat-alert' : ''; ?>">
            <div class="stat-icon" style="background:#fef3c7;color:#d97706;">⭐</div>
            <div class="stat-body">
                <div class="stat-num"><?php echo $pending_reviews; ?></div>
                <div class="stat-label">Pending Reviews</div>
                <div class="stat-sub"><?php echo $total_reviews; ?> approved total</div>
            </div>
            <?php if ($pending_reviews > 0): ?>
            <span class="stat-badge">Action needed</span>
            <?php endif; ?>
        </a>

        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-tickets.php" class="stat-card <?php echo $new_tickets > 0 ? 'stat-alert' : ''; ?>">
            <div class="stat-icon" style="background:#dbeafe;color:#2563eb;">✉️</div>
            <div class="stat-body">
                <div class="stat-num"><?php echo $new_tickets; ?></div>
                <div class="stat-label">New Messages</div>
                <div class="stat-sub"><?php echo $open_tickets; ?> open total</div>
            </div>
            <?php if ($new_tickets > 0): ?>
            <span class="stat-badge stat-badge-blue">Needs reply</span>
            <?php endif; ?>
        </a>

        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/newsletter-subscribers.php" class="stat-card">
            <div class="stat-icon" style="background:#f3e8ff;color:#7c3aed;">📩</div>
            <div class="stat-body">
                <div class="stat-num"><?php echo $active_subs; ?></div>
                <div class="stat-label">Newsletter Subs</div>
                <div class="stat-sub">+<?php echo $today_subs; ?> today</div>
            </div>
        </a>
    </div>

    <!-- ── Quick Actions ─────────────────────────────────────── -->
    <div class="section-title">Quick Actions</div>
    <div class="action-grid">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/add-survey.php" class="action-btn action-primary">
            <span>➕</span> Add Survey Site
        </a>
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-surveys.php" class="action-btn">
            <span>📋</span> Manage Surveys
        </a>
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-reviews.php" class="action-btn">
            <span>⭐</span> Manage Reviews
        </a>
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-tickets.php" class="action-btn">
            <span>✉️</span> View Messages
        </a>
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/newsletter-subscribers.php" class="action-btn">
            <span>📩</span> Newsletter Subscribers
        </a>
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/change-password.php" class="action-btn">
            <span>🔒</span> Change Password
        </a>
    </div>

    <!-- ── Recent Activity ────────────────────────────────────── -->
    <div class="two-col">

        <!-- Pending Reviews -->
        <div class="activity-card">
            <div class="activity-header">
                <h3>Pending Reviews</h3>
                <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-reviews.php?status=pending">View all →</a>
            </div>
            <?php if ($recent_reviews && $recent_reviews->num_rows > 0): ?>
            <?php while ($r = $recent_reviews->fetch_assoc()): ?>
            <div class="activity-row">
                <div class="activity-stars"><?php echo str_repeat('★', $r['rating']) . str_repeat('☆', 5-$r['rating']); ?></div>
                <div class="activity-info">
                    <div class="activity-name"><?php echo htmlspecialchars($r['reviewer_name'] ?: 'Anonymous'); ?></div>
                    <div class="activity-meta">on <?php echo htmlspecialchars($r['title']); ?> · <?php echo date('d M', strtotime($r['created_at'])); ?></div>
                </div>
                <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-reviews.php?status=pending" class="activity-action">Approve</a>
            </div>
            <?php endwhile; ?>
            <?php else: ?>
            <div class="activity-empty">✓ No pending reviews</div>
            <?php endif; ?>
        </div>

        <!-- Recent Messages -->
        <div class="activity-card">
            <div class="activity-header">
                <h3>Recent Messages</h3>
                <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-tickets.php">View all →</a>
            </div>
            <?php if ($recent_tickets && $recent_tickets->num_rows > 0): ?>
            <?php while ($t = $recent_tickets->fetch_assoc()): ?>
            <div class="activity-row">
                <div class="activity-status-dot <?php echo $t['ticket_status'] === 'new' ? 'dot-new' : 'dot-open'; ?>"></div>
                <div class="activity-info">
                    <div class="activity-name"><?php echo htmlspecialchars($t['name']); ?></div>
                    <div class="activity-meta"><?php echo htmlspecialchars($t['email']); ?> · <?php echo date('d M', strtotime($t['created_at'])); ?></div>
                </div>
                <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/view-ticket.php?id=<?php echo $t['id']; ?>" class="activity-action">Reply</a>
            </div>
            <?php endwhile; ?>
            <?php else: ?>
            <div class="activity-empty">✓ No messages</div>
            <?php endif; ?>
        </div>

    </div>

</div>

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

### FILE 18: PSH IN/management/delete-survey.php
- Type: PHP
- Size: 858 B
- Path: PSH IN/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 19: PSH IN/management/edit-survey.php
- Type: PHP
- Size: 7.16 KB
- Path: PSH IN/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']);
    $rank = $_POST['rank'] !== '' ? (int)$_POST['rank'] : NULL;
    $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 except rank are required";
    } else {
        // Check if rank already exists for another survey
        if ($rank !== NULL) {
            $check_rank = "SELECT id FROM survey_sites WHERE rank = $rank AND id != $survey_id";
            $rank_result = $conn->query($check_rank);
            if ($rank_result->num_rows > 0) {
                $error = "Rank #$rank is already assigned to another survey";
            }
        }
        
        if (empty($error)) {
            $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)) {
                $rank_sql = $rank !== NULL ? "rank = $rank," : "rank = NULL,";
                
                // Update survey site
                $sql = "UPDATE survey_sites SET 
                        $rank_sql
                        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="rank">Ranking (Optional)</label>
                <input type="number" id="rank" name="rank" min="1" 
                       value="<?php echo $survey['rank'] !== null ? $survey['rank'] : ''; ?>"
                       placeholder="Leave empty for no ranking">
                <small style="display: block; margin-top: 0.5rem; color: var(--dark-grey);">
                    Rank #1 displays full-width. Ranks #2+ display 2 per row. Unranked sites display 3 per row (randomized).
                </small>
            </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 20: PSH IN/management/index.php
- Type: PHP
- Size: 2.19 KB
- Path: PSH IN/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 21: PSH IN/management/logout.php
- Type: PHP
- Size: 266 B
- Path: PSH IN/management
- Name: logout.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

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

// Destroy admin session
session_destroy();

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

### FILE 22: PSH IN/management/manage-reviews.php
- Type: PHP
- Size: 13.44 KB
- Path: PSH IN/management
- Name: manage-reviews.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

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

// ── ACTIONS ──────────────────────────────────────────────────

// Approve
if (isset($_GET['approve'])) {
    $rid = (int)$_GET['approve'];
    $conn->query("UPDATE survey_reviews SET is_approved = 1, approved_at = NOW(), approved_by = {$_SESSION['admin_id']} WHERE id = $rid");
    $success = 'Review approved and now visible to the public.';
}

// Reject / delete
if (isset($_GET['reject'])) {
    $rid = (int)$_GET['reject'];
    $conn->query("DELETE FROM survey_reviews WHERE id = $rid");
    $success = 'Review rejected and deleted.';
}

// Bulk actions
if ($_SERVER['REQUEST_METHOD'] === 'POST' && !empty($_POST['bulk_ids'])) {
    $ids    = array_map('intval', (array)$_POST['bulk_ids']);
    $id_str = implode(',', $ids);
    if ($_POST['bulk_action'] === 'approve') {
        $conn->query("UPDATE survey_reviews SET is_approved = 1, approved_at = NOW(), approved_by = {$_SESSION['admin_id']} WHERE id IN ($id_str)");
        $success = count($ids) . ' review(s) approved.';
    } elseif ($_POST['bulk_action'] === 'reject') {
        $conn->query("DELETE FROM survey_reviews WHERE id IN ($id_str)");
        $success = count($ids) . ' review(s) deleted.';
    }
}

// ── FILTERS ──────────────────────────────────────────────────
$status_filter = $_GET['status'] ?? 'pending';
$survey_filter = isset($_GET['survey']) ? (int)$_GET['survey'] : 0;
$rating_filter = isset($_GET['rating']) ? (int)$_GET['rating'] : 0;

$where = ['1=1'];
if ($status_filter === 'pending')  $where[] = 'r.is_approved = 0';
if ($status_filter === 'approved') $where[] = 'r.is_approved = 1';
if ($survey_filter > 0) $where[] = "r.survey_id = $survey_filter";
if ($rating_filter > 0) $where[] = "r.rating = $rating_filter";

$where_sql = implode(' AND ', $where);

$reviews_sql = "SELECT r.*, s.title as survey_title
                FROM survey_reviews r
                JOIN survey_sites s ON r.survey_id = s.id
                WHERE $where_sql
                ORDER BY r.created_at DESC";
$reviews = $conn->query($reviews_sql);

// Stats
$pending_count  = $conn->query("SELECT COUNT(*) as c FROM survey_reviews WHERE is_approved = 0")->fetch_assoc()['c'];
$approved_count = $conn->query("SELECT COUNT(*) as c FROM survey_reviews WHERE is_approved = 1")->fetch_assoc()['c'];
$total_count    = $pending_count + $approved_count;

// All survey sites for filter dropdown
$sites_result = $conn->query("SELECT id, title FROM survey_sites ORDER BY title ASC");

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

<style>
.stats-row   { display:grid; grid-template-columns:repeat(3,1fr); gap:1.25rem; margin-bottom:2rem; }
.stat-box    { background:#fff; border:1px solid #e2e8f0; border-radius:12px; padding:2rem; text-align:center; }
.stat-box strong { display:block; font-size:2.2rem; font-weight:800; color:#0f172a; line-height:1; margin-bottom:.3rem; }
.stat-box span   { font-size:.85rem; color:#64748b; text-transform:uppercase; letter-spacing:.05em; font-weight:600; }
.stat-box.pending  { border-color:#fcd34d; background:#fefce8; }
.stat-box.pending strong { color:#d97706; }
.filter-bar-admin { display:flex; gap:.75rem; flex-wrap:wrap; align-items:center; margin-bottom:1.5rem; width:100%; }
.filter-bar-admin select, .filter-bar-admin a, .filter-bar-admin button {
    font-size:.88rem; padding:.55rem 1.1rem; border-radius:7px;
    border:1.5px solid #cbd5e1; background:#fff; cursor:pointer;
    text-decoration:none; color:#475569;
}
.filter-bar-admin a.active { background:#059669; border-color:#059669; color:#fff; font-weight:700; }
.filter-bar-admin select { color:#475569; }

.reviews-table { width:100%; border-collapse:collapse; font-size:.9rem; }
.reviews-table th { background:#f8fafc; padding:.85rem 1.1rem; text-align:left; font-weight:700; color:#64748b; border-bottom:2px solid #e2e8f0; white-space:nowrap; font-size:.85rem; }
.reviews-table td { padding:.9rem 1.1rem; border-bottom:1px solid #f1f5f9; vertical-align:top; line-height:1.6; }
.reviews-table tr:hover td { background:#fafbfc; }
.stars-admin  { color:#d97706; font-size:.95rem; letter-spacing:-.03em; }
.review-text-cell { max-width:420px; }
.review-text-cell p { margin:0; color:#475569; line-height:1.6; display:-webkit-box; -webkit-line-clamp:3; -webkit-box-orient:vertical; overflow:hidden; }
.badge-pending  { background:#fef3c7; color:#92400e; padding:.15rem .5rem; border-radius:99px; font-size:.68rem; font-weight:700; }
.badge-approved { background:#d1fae5; color:#064e3b; padding:.15rem .5rem; border-radius:99px; font-size:.68rem; font-weight:700; }
.action-btn { display:inline-flex; align-items:center; gap:.3rem; padding:.38rem .85rem; border-radius:6px; font-size:.82rem; font-weight:700; text-decoration:none; white-space:nowrap; cursor:pointer; border:none; }
.btn-approve { background:#d1fae5; color:#064e3b; }
.btn-approve:hover { background:#059669; color:#fff; }
.btn-reject  { background:#fee2e2; color:#991b1b; }
.btn-reject:hover  { background:#dc2626; color:#fff; }
.reviewer-cell { }
.reviewer-name-row { font-weight:700; color:#1e293b; font-size:.92rem; }
.reviewer-sub  { font-size:.8rem; color:#94a3b8; margin-top:.2rem; }
.bulk-bar { display:flex; align-items:center; gap:.85rem; flex-wrap:wrap; background:#f8fafc; border:1px solid #e2e8f0; border-radius:8px; padding:1rem 1.5rem; margin-bottom:1.5rem; width:100%; box-sizing:border-box; }
.empty-state { text-align:center; padding:5rem 2rem; color:#94a3b8; }
.empty-state .es-icon { font-size:3.5rem; margin-bottom:1rem; }
</style>

<div style="width:100%;padding:2.5rem 3rem;box-sizing:border-box;">

    <div style="display:flex;justify-content:space-between;align-items:center;margin-bottom:1.5rem;flex-wrap:wrap;gap:.75rem;">
        <div>
            <h1 style="font-size:1.85rem;font-weight:800;color:#0f172a;margin:0;">Manage Reviews</h1>
            <p style="font-size:.92rem;color:#64748b;margin:.3rem 0 0;">Approve, reject, and manage member reviews for all survey sites.</p>
        </div>
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/dashboard.php" style="font-size:.82rem;color:#059669;font-weight:600;">← Dashboard</a>
    </div>

    <?php if ($success): ?>
    <div style="background:#d1fae5;border:1px solid #6ee7b7;border-radius:8px;padding:.85rem 1rem;margin-bottom:1.25rem;font-size:.87rem;color:#064e3b;font-weight:600;">✓ <?php echo htmlspecialchars($success); ?></div>
    <?php endif; ?>

    <!-- Stats -->
    <div class="stats-row">
        <div class="stat-box pending">
            <strong><?php echo $pending_count; ?></strong>
            <span>Pending</span>
        </div>
        <div class="stat-box">
            <strong><?php echo $approved_count; ?></strong>
            <span>Approved</span>
        </div>
        <div class="stat-box">
            <strong><?php echo $total_count; ?></strong>
            <span>Total</span>
        </div>
    </div>

    <!-- Filters -->
    <div class="filter-bar-admin">
        <a href="?status=pending"  class="<?php echo $status_filter==='pending' ?'active':''; ?>">⏳ Pending (<?php echo $pending_count; ?>)</a>
        <a href="?status=approved" class="<?php echo $status_filter==='approved'?'active':''; ?>">✓ Approved (<?php echo $approved_count; ?>)</a>
        <a href="?status=all"      class="<?php echo $status_filter==='all'     ?'active':''; ?>">All</a>

        <select onchange="window.location='?status=<?php echo $status_filter; ?>&survey='+this.value">
            <option value="0">All Survey Sites</option>
            <?php while ($site = $sites_result->fetch_assoc()): ?>
            <option value="<?php echo $site['id']; ?>" <?php echo $survey_filter==$site['id']?'selected':''; ?>>
                <?php echo htmlspecialchars($site['title']); ?>
            </option>
            <?php endwhile; ?>
        </select>

        <select onchange="window.location='?status=<?php echo $status_filter; ?>&rating='+this.value">
            <option value="0">All Ratings</option>
            <?php for ($i=5;$i>=1;$i--): ?>
            <option value="<?php echo $i; ?>" <?php echo $rating_filter==$i?'selected':''; ?>>
                <?php echo $i; ?> Star<?php echo $i>1?'s':''; ?>
            </option>
            <?php endfor; ?>
        </select>
    </div>

    <!-- Bulk actions form -->
    <form method="POST" action="">
    <input type="hidden" name="bulk_action" id="bulk_action_input" value="">

    <?php if ($reviews && $reviews->num_rows > 0): ?>

    <div class="bulk-bar">
        <input type="checkbox" id="select_all" style="width:16px;height:16px;cursor:pointer;" title="Select all">
        <label for="select_all" style="font-size:.82rem;font-weight:600;color:#475569;cursor:pointer;">Select All</label>
        <span style="color:#cbd5e1;">|</span>
        <button type="submit" class="action-btn btn-approve" onclick="document.getElementById('bulk_action_input').value='approve'">✓ Approve Selected</button>
        <button type="submit" class="action-btn btn-reject" onclick="return confirm('Delete selected reviews?') && (document.getElementById(\'bulk_action_input\').value=\'reject\',true)">✗ Delete Selected</button>
        <span style="font-size:.78rem;color:#94a3b8;margin-left:auto;"><?php echo $reviews->num_rows; ?> review(s) shown</span>
    </div>

    <div style="overflow-x:auto;">
    <table class="reviews-table">
        <thead>
            <tr>
                <th style="width:32px;"></th>
                <th>Survey Site</th>
                <th>Reviewer</th>
                <th>Rating</th>
                <th>Review</th>
                <th>Date</th>
                <th>Status</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
        <?php while ($review = $reviews->fetch_assoc()): ?>
        <tr>
            <td><input type="checkbox" name="bulk_ids[]" value="<?php echo $review['id']; ?>" class="review-checkbox" style="width:15px;height:15px;cursor:pointer;"></td>
            <td style="font-weight:600;color:#1e293b;white-space:nowrap;"><?php echo htmlspecialchars($review['survey_title']); ?></td>
            <td class="reviewer-cell">
                <div class="reviewer-name-row"><?php echo htmlspecialchars($review['reviewer_name'] ?: 'Anonymous'); ?></div>
                <?php if (!empty($review['reviewer_location'])): ?>
                <div class="reviewer-sub">📍 <?php echo htmlspecialchars($review['reviewer_location']); ?></div>
                <?php endif; ?>
                <?php if (!empty($review['reviewer_email'])): ?>
                <div class="reviewer-sub">✉ <?php echo htmlspecialchars($review['reviewer_email']); ?></div>
                <?php endif; ?>
                <?php if (!empty($review['ip_address'])): ?>
                <div class="reviewer-sub" style="font-size:.68rem;">IP: <?php echo htmlspecialchars($review['ip_address']); ?></div>
                <?php endif; ?>
            </td>
            <td>
                <span class="stars-admin"><?php echo str_repeat('★', $review['rating']) . str_repeat('☆', 5-$review['rating']); ?></span>
                <div style="font-size:.72rem;color:#94a3b8;"><?php echo $review['rating']; ?>/5</div>
            </td>
            <td class="review-text-cell">
                <p><?php echo htmlspecialchars($review['feedback']); ?></p>
                <div style="font-size:.72rem;color:#94a3b8;margin-top:.35rem;"><?php echo mb_strlen($review['feedback']); ?> chars</div>
            </td>
            <td style="white-space:nowrap;font-size:.78rem;color:#94a3b8;"><?php echo date('d M Y', strtotime($review['created_at'])); ?><br><?php echo date('H:i', strtotime($review['created_at'])); ?></td>
            <td>
                <?php if ($review['is_approved']): ?>
                <span class="badge-approved">✓ Approved</span>
                <?php else: ?>
                <span class="badge-pending">⏳ Pending</span>
                <?php endif; ?>
            </td>
            <td style="white-space:nowrap;">
                <?php if (!$review['is_approved']): ?>
                <a href="?approve=<?php echo $review['id']; ?>&status=<?php echo $status_filter; ?>" class="action-btn btn-approve">✓ Approve</a>
                <?php endif; ?>
                <a href="?reject=<?php echo $review['id']; ?>&status=<?php echo $status_filter; ?>"
                   class="action-btn btn-reject"
                   onclick="return confirm('Delete this review? This cannot be undone.')">✗ Delete</a>
                <a href="<?php echo SITE_URL; ?>/survey-detail.php?id=<?php echo $review['survey_id']; ?>#reviews"
                   target="_blank" class="action-btn" style="background:#f1f5f9;color:#475569;">↗ View</a>
            </td>
        </tr>
        <?php endwhile; ?>
        </tbody>
    </table>
    </div>

    <?php else: ?>
    <div class="empty-state">
        <div class="es-icon">📭</div>
        <p style="font-weight:700;color:#1e293b;margin-bottom:.3rem;">No reviews found</p>
        <p style="font-size:.85rem;">No <?php echo $status_filter; ?> reviews match your filters.</p>
    </div>
    <?php endif; ?>

    </form>
</div>

<script>
// Select all checkbox
document.getElementById('select_all')?.addEventListener('change', function() {
    document.querySelectorAll('.review-checkbox').forEach(cb => cb.checked = this.checked);
});
</script>

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

### FILE 23: PSH IN/management/manage-surveys.php
- Type: PHP
- Size: 10.96 KB
- Path: PSH IN/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 . '/');
}

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

// Handle rank update via AJAX or form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_rank'])) {
    $survey_id = (int)$_POST['survey_id'];
    $new_rank = $_POST['rank'] !== '' ? (int)$_POST['rank'] : NULL;
    
    // Check if rank already exists for another survey
    if ($new_rank !== NULL) {
        $check_rank = "SELECT id FROM survey_sites WHERE rank = $new_rank AND id != $survey_id";
        $rank_result = $conn->query($check_rank);
        if ($rank_result->num_rows > 0) {
            $error = "Rank #$new_rank is already assigned to another survey";
        }
    }
    
    if (empty($error)) {
        $rank_value = $new_rank !== NULL ? $new_rank : 'NULL';
        $update_sql = "UPDATE survey_sites SET rank = $rank_value WHERE id = $survey_id";
        
        if ($conn->query($update_sql)) {
            $success = "Rank updated successfully!";
        } else {
            $error = "Failed to update rank: " . $conn->error;
        }
    }
}

// Get all survey sites with review stats
$sql = "SELECT s.*, 
        COALESCE(AVG(r.rating), 0) as avg_rating,
        COUNT(r.id) as review_count
        FROM survey_sites s
        LEFT JOIN survey_reviews r ON s.id = r.survey_id AND r.is_approved = 1
        GROUP BY s.id
        ORDER BY 
            CASE WHEN s.rank IS NULL THEN 1 ELSE 0 END,
            s.rank ASC,
            s.created_at DESC";
$result = $conn->query($sql);

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

<style>
.rank-input {
    width: 80px;
    padding: 0.4rem;
    border: 2px solid var(--dark-grey);
    border-radius: 4px;
    text-align: center;
    font-weight: bold;
}

.rank-cell {
    text-align: center;
    vertical-align: middle;
}

.rank-badge {
    display: inline-block;
    background: var(--yellow);
    color: var(--navy-blue);
    padding: 0.4rem 0.8rem;
    border-radius: 20px;
    font-weight: bold;
    font-size: 0.9rem;
}

.rank-badge.rank-1 {
    background: linear-gradient(135deg, #FFD700, #FFA500);
    font-size: 1rem;
}

.rank-form {
    display: inline-block;
}

.quick-save-btn {
    padding: 0.4rem 0.8rem;
    font-size: 0.85rem;
    margin-left: 0.3rem;
}

.ranking-info {
    background: var(--light-grey);
    padding: 1rem;
    border-radius: 8px;
    margin-bottom: 1.5rem;
    border-left: 4px solid var(--yellow);
}
</style>

<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 ($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; ?>
        
        <div class="ranking-info">
            <p style="margin: 0; line-height: 1.6;">
                <strong>🏆 Ranking System:</strong><br>
                <strong>Rank #1:</strong> Displays full-width with premium styling<br>
                <strong>Ranks #2+:</strong> Display 2 per row with rank badges<br>
                <strong>No Rank:</strong> Display 3 per row, randomized order<br>
                <em style="color: var(--dark-grey);">Click the rank field below to edit directly. Leave empty to remove ranking.</em>
            </p>
        </div>
        
        <?php if ($result->num_rows > 0): ?>
            <div style="overflow-x: auto;">
                <table>
                    <thead>
                        <tr>
                            <th style="width: 120px; text-align: center;">Rank</th>
                            <th style="width: 80px;">Image</th>
                            <th>Title</th>
                            <th style="width: 150px; text-align: center;">Reviews</th>
                            <th style="width: 150px;">Website Link</th>
                            <th style="width: 120px;">Created</th>
                            <th style="width: 200px;">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php while ($survey = $result->fetch_assoc()): ?>
                            <tr>
                                <td class="rank-cell">
                                    <form method="POST" class="rank-form" id="rank-form-<?php echo $survey['id']; ?>">
                                        <input type="hidden" name="update_rank" value="1">
                                        <input type="hidden" name="survey_id" value="<?php echo $survey['id']; ?>">
                                        
                                        <input 
                                            type="number" 
                                            name="rank" 
                                            class="rank-input" 
                                            value="<?php echo $survey['rank'] !== null ? $survey['rank'] : ''; ?>"
                                            placeholder="None"
                                            min="1"
                                            max="999"
                                            onchange="document.getElementById('rank-form-<?php echo $survey['id']; ?>').submit();"
                                            title="Click to edit rank, leave empty for no rank">
                                        
                                        <?php if ($survey['rank'] !== null): ?>
                                            <br>
                                            <span class="rank-badge <?php echo $survey['rank'] == 1 ? 'rank-1' : ''; ?>" style="margin-top: 0.5rem;">
                                                <?php echo $survey['rank'] == 1 ? '🏆 ' : ''; ?>#<?php echo $survey['rank']; ?>
                                            </span>
                                        <?php endif; ?>
                                    </form>
                                </td>
                                
                                <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>
                                    <strong><?php echo htmlspecialchars($survey['title']); ?></strong>
                                </td>
                                
                                <td style="text-align: center;">
                                    <?php if ($survey['review_count'] > 0): ?>
                                        <div style="color: #FFA500; font-size: 1rem; margin-bottom: 0.25rem;">
                                            <?php 
                                            $avg_rating = round($survey['avg_rating'], 1);
                                            for ($i = 1; $i <= 5; $i++) {
                                                echo ($i <= floor($avg_rating)) ? '★' : '☆';
                                            }
                                            ?>
                                        </div>
                                        <small style="color: var(--dark-grey);">
                                            <?php echo number_format($avg_rating, 1); ?> (<?php echo $survey['review_count']; ?>)
                                        </small>
                                    <?php else: ?>
                                        <small style="color: var(--dark-grey);">No reviews yet</small>
                                    <?php endif; ?>
                                </td>
                                
                                <td>
                                    <a href="<?php echo htmlspecialchars($survey['website_link']); ?>" 
                                       target="_blank" 
                                       style="color: var(--yellow); font-size: 0.9rem;">
                                        Visit Site →
                                    </a>
                                </td>
                                
                                <td><?php echo date('M d, Y', strtotime($survey['created_at'])); ?></td>
                                
                                <td style="white-space: nowrap;">
                                    <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>
            
            <p style="margin-top: 1rem; color: var(--dark-grey);">
                Total: <?php echo $result->num_rows; ?> survey site(s)
            </p>
        <?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>

<script>
// Optional: Add visual feedback when rank is being updated
document.addEventListener('DOMContentLoaded', function() {
    const rankInputs = document.querySelectorAll('.rank-input');
    
    rankInputs.forEach(input => {
        input.addEventListener('focus', function() {
            this.style.borderColor = '#FFD700';
            this.style.boxShadow = '0 0 5px rgba(255, 215, 0, 0.5)';
        });
        
        input.addEventListener('blur', function() {
            this.style.borderColor = '#666';
            this.style.boxShadow = 'none';
        });
    });
});
</script>

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

### FILE 24: PSH IN/management/manage-tickets.php
- Type: PHP
- Size: 12.78 KB
- Path: PSH IN/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 25: PSH IN/management/newsletter-subscribers.php
- Type: PHP
- Size: 16.68 KB
- Path: PSH IN/management
- Name: newsletter-subscribers.php
------------------------------------------------------------
<?php
require_once '../config/config.php';

if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

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

// ── ACTIONS ──────────────────────────────────────────────────

// Unsubscribe single
if (isset($_GET['unsubscribe'])) {
    $sid = (int)$_GET['unsubscribe'];
    $conn->query("UPDATE newsletter_subscribers SET is_active = 0, unsubscribed_at = NOW() WHERE id = $sid");
    $success = 'Subscriber marked as unsubscribed.';
}

// Re-subscribe
if (isset($_GET['resubscribe'])) {
    $sid = (int)$_GET['resubscribe'];
    $conn->query("UPDATE newsletter_subscribers SET is_active = 1, unsubscribed_at = NULL WHERE id = $sid");
    $success = 'Subscriber reactivated.';
}

// Delete single
if (isset($_GET['delete'])) {
    $sid = (int)$_GET['delete'];
    $conn->query("DELETE FROM newsletter_subscribers WHERE id = $sid");
    $success = 'Subscriber deleted permanently.';
}

// Bulk actions
if ($_SERVER['REQUEST_METHOD'] === 'POST' && !empty($_POST['bulk_ids'])) {
    $ids    = array_map('intval', (array)$_POST['bulk_ids']);
    $id_str = implode(',', $ids);
    if ($_POST['bulk_action'] === 'unsubscribe') {
        $conn->query("UPDATE newsletter_subscribers SET is_active = 0, unsubscribed_at = NOW() WHERE id IN ($id_str)");
        $success = count($ids) . ' subscriber(s) unsubscribed.';
    } elseif ($_POST['bulk_action'] === 'delete') {
        $conn->query("DELETE FROM newsletter_subscribers WHERE id IN ($id_str)");
        $success = count($ids) . ' subscriber(s) deleted.';
    }
}

// CSV Export
if (isset($_GET['export'])) {
    $status_exp = $_GET['export'] === 'active' ? 'WHERE is_active = 1' : '';
    $exp_result = $conn->query("SELECT email, name, source_survey_name, created_at FROM newsletter_subscribers $status_exp ORDER BY created_at DESC");
    header('Content-Type: text/csv; charset=UTF-8');
    header('Content-Disposition: attachment; filename="psh_subscribers_' . date('Y-m-d') . '.csv"');
    $out = fopen('php://output', 'w');
    fputcsv($out, ['Email', 'Name', 'Source Survey', 'Subscribed Date']);
    while ($row = $exp_result->fetch_assoc()) {
        fputcsv($out, [$row['email'], $row['name'], $row['source_survey_name'], $row['created_at']]);
    }
    fclose($out);
    exit;
}

// ── FILTERS ──────────────────────────────────────────────────
$status_filter = $_GET['status'] ?? 'active';
$search        = isset($_GET['search']) ? $conn->real_escape_string(trim($_GET['search'])) : '';

$where = ['1=1'];
if ($status_filter === 'active')       $where[] = 'is_active = 1';
if ($status_filter === 'unsubscribed') $where[] = 'is_active = 0';
if (!empty($search))                   $where[] = "(email LIKE '%$search%' OR name LIKE '%$search%')";
$where_sql = implode(' AND ', $where);

// Pagination
$per_page   = 30;
$page_num   = max(1, (int)($_GET['page'] ?? 1));
$offset     = ($page_num - 1) * $per_page;

$total_rows = $conn->query("SELECT COUNT(*) as c FROM newsletter_subscribers WHERE $where_sql")->fetch_assoc()['c'];
$total_pages = ceil($total_rows / $per_page);

$subs = $conn->query("SELECT * FROM newsletter_subscribers WHERE $where_sql ORDER BY created_at DESC LIMIT $per_page OFFSET $offset");

// Stats
$active_count  = $conn->query("SELECT COUNT(*) as c FROM newsletter_subscribers WHERE is_active = 1")->fetch_assoc()['c'];
$unsub_count   = $conn->query("SELECT COUNT(*) as c FROM newsletter_subscribers WHERE is_active = 0")->fetch_assoc()['c'];
$today_count   = $conn->query("SELECT COUNT(*) as c FROM newsletter_subscribers WHERE DATE(created_at) = CURDATE()")->fetch_assoc()['c'];
$total_all     = $active_count + $unsub_count;

// Top source surveys
$top_sources = $conn->query("SELECT source_survey_name, COUNT(*) as cnt FROM newsletter_subscribers WHERE is_active = 1 AND source_survey_name IS NOT NULL GROUP BY source_survey_name ORDER BY cnt DESC LIMIT 5");

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

<style>
.stats-row   { display:flex; gap:.75rem; margin-bottom:1.5rem; flex-wrap:wrap; }
.stat-box    { background:#fff; border:1px solid #e2e8f0; border-radius:8px; padding:.85rem 1.25rem; text-align:center; min-width:110px; flex:1; }
.stat-box strong { display:block; font-size:1.7rem; font-weight:800; color:#0f172a; line-height:1; }
.stat-box span   { font-size:.73rem; color:#64748b; text-transform:uppercase; letter-spacing:.05em; }
.stat-box.green  { border-color:#6ee7b7; background:#f0fdf4; }
.stat-box.green strong { color:#059669; }
.stat-box.today  { border-color:#93c5fd; background:#eff6ff; }
.stat-box.today strong { color:#2563eb; }

.filter-row { display:flex; gap:.5rem; flex-wrap:wrap; align-items:center; margin-bottom:1.1rem; }
.filter-row a { font-size:.82rem; padding:.38rem .85rem; border-radius:6px; border:1.5px solid #cbd5e1; color:#475569; text-decoration:none; }
.filter-row a.active { background:#059669; border-color:#059669; color:#fff; font-weight:700; }
.filter-row input[type=text] { font-size:.82rem; padding:.38rem .85rem; border-radius:6px; border:1.5px solid #cbd5e1; color:#1e293b; min-width:200px; }
.filter-row .btn-export { font-size:.82rem; padding:.38rem .85rem; border-radius:6px; background:#0f172a; color:#fff; border:none; cursor:pointer; font-weight:600; text-decoration:none; display:inline-flex; align-items:center; gap:.3rem; }

.subs-table  { width:100%; border-collapse:collapse; font-size:.82rem; }
.subs-table th { background:#f8fafc; padding:.55rem .8rem; text-align:left; font-weight:700; color:#64748b; border-bottom:2px solid #e2e8f0; white-space:nowrap; }
.subs-table td { padding:.6rem .8rem; border-bottom:1px solid #f1f5f9; vertical-align:middle; }
.subs-table tr:hover td { background:#fafbfc; }
.status-active { background:#d1fae5; color:#064e3b; padding:.15rem .55rem; border-radius:99px; font-size:.68rem; font-weight:700; }
.status-unsub  { background:#f1f5f9; color:#94a3b8; padding:.15rem .55rem; border-radius:99px; font-size:.68rem; font-weight:700; }
.action-btn { display:inline-flex; align-items:center; gap:.2rem; padding:.25rem .6rem; border-radius:5px; font-size:.73rem; font-weight:700; text-decoration:none; white-space:nowrap; border:none; cursor:pointer; }
.btn-unsub  { background:#fee2e2; color:#991b1b; }
.btn-unsub:hover { background:#dc2626; color:#fff; }
.btn-resub  { background:#d1fae5; color:#064e3b; }
.btn-resub:hover { background:#059669; color:#fff; }
.btn-del    { background:#f1f5f9; color:#64748b; }
.btn-del:hover { background:#ef4444; color:#fff; }
.bulk-bar   { display:flex; align-items:center; gap:.65rem; flex-wrap:wrap; background:#f8fafc; border:1px solid #e2e8f0; border-radius:8px; padding:.6rem 1rem; margin-bottom:.85rem; }
.source-tag { font-size:.72rem; color:#64748b; background:#f1f5f9; padding:.1rem .4rem; border-radius:4px; }
.pagination { display:flex; gap:.35rem; flex-wrap:wrap; margin-top:1.25rem; align-items:center; }
.pagination a, .pagination span { font-size:.8rem; padding:.3rem .7rem; border-radius:6px; border:1px solid #e2e8f0; color:#475569; text-decoration:none; }
.pagination a:hover { background:#059669; color:#fff; border-color:#059669; }
.pagination span.current { background:#059669; color:#fff; border-color:#059669; font-weight:700; }
.top-sources { display:flex; flex-direction:column; gap:.4rem; }
.source-row  { display:flex; align-items:center; gap:.65rem; font-size:.8rem; }
.source-bar  { flex:1; height:6px; background:#e2e8f0; border-radius:99px; overflow:hidden; }
.source-fill { height:6px; background:#059669; border-radius:99px; }
</style>

<div style="max-width:1200px;margin:0 auto;padding:1.5rem 1.25rem;">

    <!-- Header -->
    <div style="display:flex;justify-content:space-between;align-items:flex-start;margin-bottom:1.5rem;flex-wrap:wrap;gap:.75rem;">
        <div>
            <h1 style="font-size:1.45rem;font-weight:800;color:#0f172a;margin:0;">Newsletter Subscribers</h1>
            <p style="font-size:.82rem;color:#64748b;margin:.2rem 0 0;">Members who opted in for survey updates via the review form.</p>
        </div>
        <div style="display:flex;gap:.5rem;flex-wrap:wrap;align-items:center;">
            <a href="?export=active" class="btn-export">📥 Export Active CSV</a>
            <a href="?export=all" class="btn-export" style="background:#334155;">📥 Export All CSV</a>
            <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/dashboard.php" style="font-size:.82rem;color:#059669;font-weight:600;">← Dashboard</a>
        </div>
    </div>

    <?php if ($success): ?>
    <div style="background:#d1fae5;border:1px solid #6ee7b7;border-radius:8px;padding:.85rem 1rem;margin-bottom:1.25rem;font-size:.87rem;color:#064e3b;font-weight:600;">✓ <?php echo htmlspecialchars($success); ?></div>
    <?php endif; ?>

    <!-- Stats -->
    <div class="stats-row">
        <div class="stat-box green">
            <strong><?php echo $active_count; ?></strong>
            <span>Active</span>
        </div>
        <div class="stat-box today">
            <strong><?php echo $today_count; ?></strong>
            <span>Today</span>
        </div>
        <div class="stat-box">
            <strong><?php echo $unsub_count; ?></strong>
            <span>Unsubscribed</span>
        </div>
        <div class="stat-box">
            <strong><?php echo $total_all; ?></strong>
            <span>Total Ever</span>
        </div>

        <!-- Top sources mini widget -->
        <?php if ($top_sources && $top_sources->num_rows > 0): ?>
        <div style="background:#fff;border:1px solid #e2e8f0;border-radius:8px;padding:.85rem 1.25rem;flex:2;min-width:250px;">
            <div style="font-size:.73rem;font-weight:700;text-transform:uppercase;letter-spacing:.05em;color:#64748b;margin-bottom:.75rem;">Top Survey Pages</div>
            <?php
            $top_rows = [];
            while ($tr = $top_sources->fetch_assoc()) $top_rows[] = $tr;
            $max_cnt = $top_rows[0]['cnt'] ?? 1;
            foreach ($top_rows as $tr):
            ?>
            <div class="source-row">
                <span style="width:160px;white-space:nowrap;overflow:hidden;text-overflow:ellipsis;" title="<?php echo htmlspecialchars($tr['source_survey_name']); ?>"><?php echo htmlspecialchars($tr['source_survey_name']); ?></span>
                <div class="source-bar"><div class="source-fill" style="width:<?php echo round(($tr['cnt']/$max_cnt)*100); ?>%"></div></div>
                <span style="color:#64748b;min-width:24px;text-align:right;"><?php echo $tr['cnt']; ?></span>
            </div>
            <?php endforeach; ?>
        </div>
        <?php endif; ?>
    </div>

    <!-- Filter row -->
    <form method="GET" action="">
    <div class="filter-row">
        <a href="?status=active"       class="<?php echo $status_filter==='active'?'active':''; ?>">✅ Active (<?php echo $active_count; ?>)</a>
        <a href="?status=unsubscribed" class="<?php echo $status_filter==='unsubscribed'?'active':''; ?>">🚫 Unsubscribed (<?php echo $unsub_count; ?>)</a>
        <a href="?status=all"          class="<?php echo $status_filter==='all'?'active':''; ?>">All</a>
        <input type="text" name="search" placeholder="Search email or name…" value="<?php echo htmlspecialchars($search); ?>" onchange="this.form.submit()">
        <input type="hidden" name="status" value="<?php echo htmlspecialchars($status_filter); ?>">
    </div>
    </form>

    <!-- Bulk actions -->
    <form method="POST" action="">
    <input type="hidden" name="bulk_action" id="bulk_action_val" value="">

    <div class="bulk-bar">
        <input type="checkbox" id="sel_all" style="width:15px;height:15px;cursor:pointer;">
        <label for="sel_all" style="font-size:.82rem;font-weight:600;color:#475569;cursor:pointer;">Select All</label>
        <span style="color:#cbd5e1;">|</span>
        <button type="submit" class="action-btn btn-unsub" onclick="document.getElementById('bulk_action_val').value='unsubscribe'">🚫 Unsubscribe Selected</button>
        <button type="submit" class="action-btn btn-del" onclick="return confirm('Permanently delete selected?')&&(document.getElementById('bulk_action_val').value='delete',true)">🗑 Delete Selected</button>
        <span style="font-size:.78rem;color:#94a3b8;margin-left:auto;"><?php echo $total_rows; ?> subscriber(s) <?php echo $status_filter!=='all'?'('.$status_filter.')':''; ?></span>
    </div>

    <?php if ($subs && $subs->num_rows > 0): ?>
    <div style="overflow-x:auto;">
    <table class="subs-table">
        <thead>
            <tr>
                <th style="width:30px;"></th>
                <th>Email</th>
                <th>Name</th>
                <th>Source Survey</th>
                <th>Status</th>
                <th>Subscribed</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
        <?php while ($sub = $subs->fetch_assoc()): ?>
        <tr>
            <td><input type="checkbox" name="bulk_ids[]" value="<?php echo $sub['id']; ?>" class="sub-checkbox" style="width:14px;height:14px;cursor:pointer;"></td>
            <td style="font-weight:600;color:#1e293b;">
                <a href="mailto:<?php echo htmlspecialchars($sub['email']); ?>" style="color:#1e293b;text-decoration:none;">
                    <?php echo htmlspecialchars($sub['email']); ?>
                </a>
            </td>
            <td style="color:#475569;"><?php echo htmlspecialchars($sub['name'] ?: '—'); ?></td>
            <td>
                <?php if ($sub['source_survey_name']): ?>
                <span class="source-tag"><?php echo htmlspecialchars($sub['source_survey_name']); ?></span>
                <?php else: ?>
                <span style="color:#94a3b8;font-size:.78rem;">—</span>
                <?php endif; ?>
            </td>
            <td>
                <?php if ($sub['is_active']): ?>
                <span class="status-active">✅ Active</span>
                <?php else: ?>
                <span class="status-unsub">🚫 Unsubscribed</span>
                <?php if ($sub['unsubscribed_at']): ?>
                <div style="font-size:.7rem;color:#94a3b8;margin-top:.1rem;"><?php echo date('d M Y', strtotime($sub['unsubscribed_at'])); ?></div>
                <?php endif; ?>
                <?php endif; ?>
            </td>
            <td style="color:#94a3b8;font-size:.78rem;white-space:nowrap;"><?php echo date('d M Y', strtotime($sub['created_at'])); ?></td>
            <td style="white-space:nowrap;">
                <?php if ($sub['is_active']): ?>
                <a href="?unsubscribe=<?php echo $sub['id']; ?>&status=<?php echo $status_filter; ?>" class="action-btn btn-unsub">🚫 Unsub</a>
                <?php else: ?>
                <a href="?resubscribe=<?php echo $sub['id']; ?>&status=<?php echo $status_filter; ?>" class="action-btn btn-resub">✅ Resub</a>
                <?php endif; ?>
                <a href="?delete=<?php echo $sub['id']; ?>&status=<?php echo $status_filter; ?>" class="action-btn btn-del" onclick="return confirm('Permanently delete this subscriber?')">🗑</a>
            </td>
        </tr>
        <?php endwhile; ?>
        </tbody>
    </table>
    </div>

    <!-- Pagination -->
    <?php if ($total_pages > 1): ?>
    <div class="pagination">
        <span>Page <?php echo $page_num; ?> of <?php echo $total_pages; ?></span>
        <?php for ($p = 1; $p <= $total_pages; $p++): ?>
        <?php if ($p === $page_num): ?>
        <span class="current"><?php echo $p; ?></span>
        <?php else: ?>
        <a href="?status=<?php echo $status_filter; ?>&page=<?php echo $p; ?>"><?php echo $p; ?></a>
        <?php endif; ?>
        <?php endfor; ?>
    </div>
    <?php endif; ?>

    <?php else: ?>
    <div style="text-align:center;padding:3rem;color:#94a3b8;">
        <div style="font-size:2.5rem;margin-bottom:.5rem;">📭</div>
        <p style="font-weight:700;color:#1e293b;">No subscribers found</p>
        <p style="font-size:.85rem;">Subscribers will appear here as people review survey sites and opt in.</p>
    </div>
    <?php endif; ?>

    </form>

    <!-- Email compliance note -->
    <div style="background:#fef3c7;border:1px solid #fcd34d;border-radius:8px;padding:1rem 1.25rem;margin-top:2rem;font-size:.82rem;color:#78350f;">
        <strong>📋 Compliance Note:</strong> All subscribers have explicitly opted in via the review form. Always include an unsubscribe link in every marketing email you send. Sending to unsubscribed addresses is a violation of India's IT Act and international email laws (GDPR, CAN-SPAM). Export only active subscribers for campaigns.
    </div>
</div>

<script>
document.getElementById('sel_all')?.addEventListener('change', function() {
    document.querySelectorAll('.sub-checkbox').forEach(cb => cb.checked = this.checked);
});
</script>

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

### FILE 26: PSH IN/management/reply-ticket.php
- Type: PHP
- Size: 9.29 KB
- Path: PSH IN/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 27: PSH IN/management/view-ticket.php
- Type: PHP
- Size: 17.27 KB
- Path: PSH IN/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 28: PSH IN/management/includes/footer.php
- Type: PHP
- Size: 220 B
- Path: PSH IN/management/includes
- Name: footer.php
------------------------------------------------------------
<footer class="admin-footer">
    PaidSurveyHub India Admin &nbsp;·&nbsp; <?php echo date('Y'); ?> &nbsp;·&nbsp;
    <a href="<?php echo SITE_URL; ?>/" target="_blank">View Public Site ↗</a>
</footer>
</body>
</html>
-------------------- END OF FILE --------------------

### FILE 29: PSH IN/management/includes/header.php
- Type: PHP
- Size: 14.09 KB
- Path: PSH IN/management/includes
- Name: header.php
------------------------------------------------------------
<!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) ? htmlspecialchars($page_title) : 'Admin — PaidSurveyHub'; ?></title>
    <meta name="robots" content="noindex, nofollow">
    <link rel="icon" type="image/png" href="<?php echo SITE_URL; ?>/assets/favicon.png">
    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Plus+Jakarta+Sans:wght@400;500;600;700;800&family=Nunito:wght@400;500;600;700&display=swap">
<style>
/* ── Admin UI ───────────────────────────────────────────────── */
*,*::before,*::after{box-sizing:border-box;margin:0;padding:0}
:root{
  --g:#059669;--gd:#047857;--gxd:#064e3b;--gl:#d1fae5;--gp:#f0fdf4;
  --s9:#0f172a;--s8:#1e293b;--s7:#334155;--s6:#475569;--s5:#64748b;
  --s4:#94a3b8;--s3:#cbd5e1;--s2:#e2e8f0;--s1:#f1f5f9;--s0:#f8fafc;
  --w:#fff;--amber:#d97706;--blue:#2563eb;--red:#dc2626;
  --sh-sm:0 1px 4px rgba(0,0,0,.07);
  --sh-md:0 4px 14px rgba(0,0,0,.09);
  --r:8px;--rl:14px;
  --fh:'Plus Jakarta Sans',sans-serif;
  --fb:'Nunito',sans-serif;
}
html{font-size:16px;-webkit-text-size-adjust:100%}
body{font-family:var(--fb);color:var(--s8);background:var(--s0);min-height:100vh;display:flex;flex-direction:column}
a{color:var(--g);text-decoration:none}
a:hover{color:var(--gd)}
img{max-width:100%;display:block}

/* ── Top Nav ────────────────────────────────────────────────── */
.admin-nav{background:var(--s9);padding:0;position:sticky;top:0;z-index:100;box-shadow:var(--sh-md)}
.admin-nav-inner{display:flex;align-items:center;justify-content:space-between;height:62px;max-width:1400px;margin:0 auto;padding:0 2rem;gap:1.5rem}
.admin-brand{font-family:var(--fh);font-weight:800;font-size:1.15rem;color:#fff;display:flex;align-items:center;gap:.4rem;white-space:nowrap}
.admin-brand span{color:var(--gl);font-size:.7rem;font-weight:600;background:rgba(255,255,255,.1);padding:.15rem .5rem;border-radius:99px}
.admin-links{display:flex;align-items:center;gap:.15rem;flex:1;justify-content:center}
.admin-links a{font-family:var(--fh);font-size:.88rem;font-weight:600;color:rgba(255,255,255,.65);padding:.45rem .9rem;border-radius:var(--r);transition:all .15s;white-space:nowrap}
.admin-links a:hover{color:#fff;background:rgba(255,255,255,.1)}
.admin-links a.active{color:#fff;background:var(--g)}
.admin-links .nav-badge{background:var(--amber);color:#fff;font-size:.6rem;font-weight:800;padding:.1rem .35rem;border-radius:99px;margin-left:.3rem;vertical-align:middle}
.admin-links .nav-badge-blue{background:var(--blue)}
.admin-right{display:flex;align-items:center;gap:.5rem}
.admin-user{font-size:.75rem;color:rgba(255,255,255,.55);white-space:nowrap}
.admin-logout{font-size:.75rem;font-weight:700;color:#fff;background:rgba(220,38,38,.7);padding:.3rem .7rem;border-radius:var(--r);transition:background .15s}
.admin-logout:hover{background:var(--red);color:#fff}

/* ── Layout ─────────────────────────────────────────────────── */
.dash-wrap{max-width:1400px;margin:0 auto;padding:2.5rem 2rem 4rem}
.dash-header{display:flex;justify-content:space-between;align-items:flex-start;margin-bottom:1.75rem;flex-wrap:wrap;gap:.75rem}
.dash-title{font-family:var(--fh);font-size:1.85rem;font-weight:800;color:var(--s9);margin:0}
.dash-sub{font-size:.92rem;color:var(--s5);margin-top:.2rem}
.dash-view-site{font-size:.8rem;font-weight:700;color:var(--g);background:var(--gp);border:1.5px solid var(--gl);padding:.35rem .9rem;border-radius:var(--r)}

/* ── Stat Cards ──────────────────────────────────────────────── */
.stat-grid{display:grid;grid-template-columns:repeat(4,1fr);gap:1rem;margin-bottom:2rem}
.stat-card{background:var(--w);border:1.5px solid var(--s2);border-radius:var(--rl);padding:1.75rem 1.5rem;display:flex;align-items:flex-start;gap:1rem;transition:box-shadow .2s,border-color .2s;text-decoration:none;position:relative}
.stat-card:hover{box-shadow:var(--sh-md);border-color:var(--s3)}
.stat-alert{border-color:#fcd34d!important;background:#fefce8!important}
.stat-icon{width:54px;height:54px;border-radius:var(--r);display:flex;align-items:center;justify-content:center;font-size:1.5rem;flex-shrink:0}
.stat-num{font-family:var(--fh);font-size:2.4rem;font-weight:800;color:var(--s9);line-height:1}
.stat-label{font-family:var(--fh);font-size:.9rem;font-weight:700;color:var(--s6);margin-top:.3rem}
.stat-sub{font-size:.82rem;color:var(--s4);margin-top:.15rem}
.stat-badge{position:absolute;top:.7rem;right:.7rem;font-size:.63rem;font-weight:800;text-transform:uppercase;letter-spacing:.04em;background:#fef3c7;color:#92400e;padding:.15rem .5rem;border-radius:99px}
.stat-badge-blue{background:#dbeafe;color:#1e40af}

/* ── Section title ───────────────────────────────────────────── */
.section-title{font-family:var(--fh);font-size:.82rem;font-weight:800;text-transform:uppercase;letter-spacing:.08em;color:var(--s5);margin-bottom:1.25rem;padding-bottom:.6rem;border-bottom:1px solid var(--s2)}

/* ── Quick Actions ───────────────────────────────────────────── */
.action-grid{display:grid;grid-template-columns:repeat(6,1fr);gap:.75rem;margin-bottom:2rem}
.action-btn{background:var(--w);border:1.5px solid var(--s2);border-radius:var(--r);padding:1.5rem 1rem;text-align:center;font-family:var(--fh);font-size:.9rem;font-weight:700;color:var(--s7);transition:all .18s;display:flex;flex-direction:column;align-items:center;gap:.4rem}
.action-btn span{font-size:1.7rem}
.action-btn:hover{border-color:var(--g);color:var(--g);box-shadow:var(--sh-sm)}
.action-primary{background:var(--g)!important;border-color:var(--g)!important;color:#fff!important}
.action-primary:hover{background:var(--gd)!important;border-color:var(--gd)!important;color:#fff!important}

/* ── Two col activity ─────────────────────────────────────────── */
.two-col{display:grid;grid-template-columns:1fr 1fr;gap:1.25rem}
.activity-card{background:var(--w);border:1.5px solid var(--s2);border-radius:var(--rl);overflow:hidden}
.activity-header{display:flex;justify-content:space-between;align-items:center;padding:1.2rem 1.5rem;border-bottom:1px solid var(--s2)}
.activity-header h3{font-family:var(--fh);font-size:1rem;font-weight:700;color:var(--s8);margin:0}
.activity-header a{font-size:.75rem;font-weight:600;color:var(--g)}
.activity-row{display:flex;align-items:center;gap:1rem;padding:.9rem 1.5rem;border-bottom:1px solid var(--s1)}
.activity-row:last-child{border-bottom:none}
.activity-stars{color:#d97706;font-size:.85rem;letter-spacing:-.02em;flex-shrink:0}
.activity-status-dot{width:9px;height:9px;border-radius:50%;flex-shrink:0}
.dot-new{background:#d97706}
.dot-open{background:var(--blue)}
.activity-info{flex:1;min-width:0}
.activity-name{font-size:.95rem;font-weight:600;color:var(--s8);white-space:nowrap;overflow:hidden;text-overflow:ellipsis}
.activity-meta{font-size:.82rem;color:var(--s4);margin-top:.2rem;white-space:nowrap;overflow:hidden;text-overflow:ellipsis}
.activity-action{font-size:.73rem;font-weight:700;color:var(--g);white-space:nowrap;padding:.2rem .5rem;background:var(--gp);border-radius:5px}
.activity-empty{padding:1.5rem;text-align:center;font-size:.83rem;color:var(--s4)}

/* ── Generic page card ───────────────────────────────────────── */
.page-card{max-width:1400px;margin:2rem auto;padding:0 2rem 4rem}
.card{background:var(--w);border:1.5px solid var(--s2);border-radius:var(--rl);padding:2.5rem}
.card-title{font-family:var(--fh);font-size:1.5rem;font-weight:800;color:var(--s9);margin-bottom:1.25rem}
.back-link{font-size:.8rem;font-weight:600;color:var(--g);display:inline-flex;align-items:center;gap:.3rem;margin-bottom:1rem}

/* ── Alerts ──────────────────────────────────────────────────── */
.alert{border-radius:var(--r);padding:.8rem 1rem;margin-bottom:1rem;font-size:.85rem;line-height:1.6}
.alert-success{background:var(--gl);color:var(--gxd);border:1px solid #6ee7b7}
.alert-error{background:#fee2e2;color:#991b1b;border:1px solid #fca5a5}
.alert-info{background:#dbeafe;color:#1e40af;border:1px solid #93c5fd}

/* ── Forms ───────────────────────────────────────────────────── */
.form-group{margin-bottom:1rem}
.form-group label{display:block;font-family:var(--fh);font-size:.88rem;font-weight:700;margin-bottom:.4rem;color:var(--s7)}
.form-group input,.form-group textarea,.form-group select{width:100%;padding:.75rem 1rem;border:1.5px solid var(--s3);border-radius:var(--r);font-family:var(--fb);font-size:.95rem;color:var(--s8);background:var(--w);outline:none;transition:border-color .15s}
.form-group input:focus,.form-group textarea:focus,.form-group select:focus{border-color:var(--g);box-shadow:0 0 0 3px rgba(5,150,105,.1)}
.form-group textarea{resize:vertical;min-height:110px}

/* ── Buttons ─────────────────────────────────────────────────── */
.btn{display:inline-flex;align-items:center;justify-content:center;gap:.4rem;font-family:var(--fh);font-weight:700;font-size:.82rem;padding:.55rem 1.2rem;border-radius:var(--r);border:2px solid transparent;cursor:pointer;transition:all .15s;text-decoration:none;white-space:nowrap}
.btn-primary{background:var(--g);color:#fff;border-color:var(--g)}
.btn-primary:hover{background:var(--gd);border-color:var(--gd);color:#fff}
.btn-secondary{background:var(--s1);color:var(--s7);border-color:var(--s2)}
.btn-secondary:hover{background:var(--s2);color:var(--s8)}
.btn-danger{background:#fee2e2;color:#991b1b;border-color:#fca5a5}
.btn-danger:hover{background:var(--red);color:#fff;border-color:var(--red)}
.btn-sm{padding:.3rem .7rem;font-size:.75rem}

/* ── Tables ──────────────────────────────────────────────────── */
table{width:100%;border-collapse:collapse;font-size:.82rem}
th{background:var(--s1);padding:.75rem 1rem;text-align:left;font-family:var(--fh);font-weight:700;color:var(--s6);border-bottom:2px solid var(--s2);white-space:nowrap;font-size:.88rem}
td{padding:.8rem 1rem;border-bottom:1px solid var(--s1);vertical-align:middle;font-size:.9rem}
tr:hover td{background:#fafbfc}

/* ── Footer ──────────────────────────────────────────────────── */
.admin-footer{margin-top:auto;border-top:1px solid var(--s2);padding:.75rem 1.25rem;text-align:center;font-size:.72rem;color:var(--s4)}

/* ── Responsive ──────────────────────────────────────────────── */
@media(max-width:1024px){
  .stat-grid{grid-template-columns:repeat(2,1fr)}
  .action-grid{grid-template-columns:repeat(3,1fr)}
  .two-col{grid-template-columns:1fr}
  .admin-links{display:none}
}
@media(max-width:640px){
  .stat-grid{grid-template-columns:1fr 1fr}
  .action-grid{grid-template-columns:repeat(2,1fr)}
}
</style>
</head>
<body>

<!-- Admin Nav -->
<nav class="admin-nav">
  <div class="admin-nav-inner">
    <div class="admin-brand">
      PaidSurveyHub <span>Admin</span>
    </div>

    <?php if (is_admin_logged_in()):
      // Get counts for badges
      $nav_pending_reviews = $conn->query("SELECT COUNT(*) as c FROM survey_reviews WHERE is_approved = 0")->fetch_assoc()['c'];
      $nav_new_tickets     = $conn->query("SELECT COUNT(*) as c FROM contact_messages WHERE ticket_status = 'new'")->fetch_assoc()['c'];
      $cur = basename($_SERVER['PHP_SELF']);
    ?>
    <div class="admin-links">
      <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/dashboard.php"
         class="<?php echo $cur==='dashboard.php'?'active':''; ?>">Dashboard</a>

      <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-surveys.php"
         class="<?php echo in_array($cur,['manage-surveys.php','add-survey.php','edit-survey.php'])?'active':''; ?>">Surveys</a>

      <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-reviews.php"
         class="<?php echo $cur==='manage-reviews.php'?'active':''; ?>">
        Reviews
        <?php if ($nav_pending_reviews > 0): ?>
        <span class="nav-badge"><?php echo $nav_pending_reviews; ?></span>
        <?php endif; ?>
      </a>

      <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/manage-tickets.php"
         class="<?php echo in_array($cur,['manage-tickets.php','view-ticket.php','reply-ticket.php'])?'active':''; ?>">
        Messages
        <?php if ($nav_new_tickets > 0): ?>
        <span class="nav-badge nav-badge-blue"><?php echo $nav_new_tickets; ?></span>
        <?php endif; ?>
      </a>

      <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/newsletter-subscribers.php"
         class="<?php echo $cur==='newsletter-subscribers.php'?'active':''; ?>">Newsletter</a>

      <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/change-password.php"
         class="<?php echo $cur==='change-password.php'?'active':''; ?>">🔒 Password</a>
    </div>

    <div class="admin-right">
      <span class="admin-user">👤 <?php echo htmlspecialchars($_SESSION['admin_username'] ?? ''); ?></span>
      <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/logout.php" class="admin-logout">Logout</a>
    </div>
    <?php endif; ?>
  </div>
</nav>
-------------------- END OF FILE --------------------


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

Repository contains 29 files total.
All file contents have been extracted and are shown above.
This repository snapshot was generated on: 2026-04-18 05:40:02

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