Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
ads.php	4.94 KB	-rw-r--r--	2025-10-17 23:43
dashboard.php	10.78 KB	-rw-r--r--	2025-10-18 00:40
deposit.php	6.02 KB	-rw-r--r--	2025-10-17 23:02
deposit_history.php	3.23 KB	-rw-r--r--	2025-10-17 23:03
dpin.php	5.9 KB	-rw-r--r--	2025-10-17 23:03
footer.php	565 B	-rw-r--r--	2025-10-17 23:02
header.php	12.32 KB	-rw-r--r--	2025-10-18 02:06
invite.php	3.53 KB	-rw-r--r--	2025-10-18 00:19
membership.php	11.7 KB	-rw-r--r--	2025-10-18 00:56
profile.php	5.27 KB	-rw-r--r--	2025-10-17 23:04
team.php	5.26 KB	-rw-r--r--	2025-10-17 23:50
transactions.php	3.85 KB	-rw-r--r--	2025-10-17 23:04
withdraw.php	6.19 KB	-rw-r--r--	2025-10-17 23:03

Rename

<?php
$title = 'Ads Management';
include 'header.php';

// Check if user has an active plan
$has_active_plan = false;
if ($user['current_plan']) {
    try {
        $stmt = $pdo->prepare("SELECT * FROM plans WHERE id = ?");
        $stmt->execute([$user['current_plan']]);
        $plan = $stmt->fetch();
        if ($plan) {
            $has_active_plan = true;
        }
    } catch (PDOException $e) {
        // Handle error
    }
}

// Get all active ads
try {
    $stmt = $pdo->prepare("SELECT * FROM ads WHERE status = 'active' ORDER BY id DESC");
    $stmt->execute();
    $ads = $stmt->fetchAll();
} catch (PDOException $e) {
    $ads = [];
}

// Handle ad completion
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['complete_ad'])) {
    $ad_id = $_POST['ad_id'];
    
    if (!$has_active_plan) {
        $error = 'Please buy a plan first to start earning.';
    } else {
        try {
            // Check if ad exists and is active
            $stmt = $pdo->prepare("SELECT * FROM ads WHERE id = ? AND status = 'active'");
            $stmt->execute([$ad_id]);
            $ad = $stmt->fetch();
            
            if ($ad) {
                // Check if user has already completed this ad today
                $stmt = $pdo->prepare("SELECT COUNT(*) as count FROM transactions WHERE user_id = ? AND note = ? AND DATE(created_at) = CURDATE()");
                $stmt->execute([$_SESSION['user_id'], 'Ad reward: ' . $ad['title']]);
                $already_completed = $stmt->fetch()['count'] > 0;
                
                if ($already_completed) {
                    $error = 'You have already completed this ad today.';
                } else {
                    // Add reward to user balance
                    $stmt = $pdo->prepare("UPDATE users SET balance = balance + ? WHERE id = ?");
                    $stmt->execute([$ad['reward'], $_SESSION['user_id']]);
                    
                    // Add transaction record
                    $stmt = $pdo->prepare("INSERT INTO transactions (user_id, type, amount, note) VALUES (?, 'ad', ?, ?)");
                    $stmt->execute([$_SESSION['user_id'], $ad['reward'], 'Ad reward: ' . $ad['title']]);
                    
                    $success = 'Ad completed successfully! ₨' . number_format($ad['reward'], 2) . ' has been added to your balance.';
                }
            } else {
                $error = 'Invalid ad.';
            }
        } catch (PDOException $e) {
            $error = 'Failed to complete ad. Please try again.';
        }
    }
}
?>

<div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center pt-3 pb-2 mb-3 border-bottom">
    <h1 class="h2">Ads Management</h1>
</div>

<?php if (!$has_active_plan): ?>
    <div class="alert alert-warning">
        <h4>Please buy a plan first to start earning.</h4>
        <p>You need an active membership plan to access ads and earn rewards.</p>
        <a href="membership.php" class="btn btn-primary">Buy Plan with Balance</a>
        <a href="deposit.php" class="btn btn-outline-primary mt-2">Deposit Funds</a>
    </div>
<?php else: ?>
    <?php if (isset($error)): ?>
        <div class="alert alert-danger"><?php echo htmlspecialchars($error); ?></div>
    <?php endif; ?>
    
    <?php if (isset($success)): ?>
        <div class="alert alert-success"><?php echo htmlspecialchars($success); ?></div>
    <?php endif; ?>
    
    <div class="row">
        <?php if (count($ads) > 0): ?>
            <?php foreach ($ads as $ad): ?>
                <div class="col-md-6 col-lg-4 mb-4">
                    <div class="card h-100">
                        <div class="card-body">
                            <h5 class="card-title"><?php echo htmlspecialchars($ad['title']); ?></h5>
                            <p class="card-text"><?php echo htmlspecialchars($ad['description']); ?></p>
                            <ul class="list-unstyled">
                                <li><strong>Reward:</strong> ₨<?php echo number_format($ad['reward'], 2); ?></li>
                                <li><strong>Duration:</strong> <?php echo $ad['duration']; ?> seconds</li>
                            </ul>
                            <form method="POST">
                                <input type="hidden" name="ad_id" value="<?php echo $ad['id']; ?>">
                                <button type="submit" name="complete_ad" class="btn btn-primary">Complete Task</button>
                            </form>
                        </div>
                    </div>
                </div>
            <?php endforeach; ?>
        <?php else: ?>
            <div class="col-12">
                <div class="alert alert-info">
                    <p>No ads available at the moment. Please check back later.</p>
                </div>
            </div>
        <?php endif; ?>
    </div>
<?php endif; ?>

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