Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
ajax_spin_wheel.php	3.28 KB	-rw-r--r--	2026-01-26 20:21
announcements.php	3.18 KB	-rw-r--r--	2025-12-25 17:46
daily_targets.php	15.36 KB	-rw-r--r--	2025-12-27 13:56
dashboard.php	35.82 KB	-rw-r--r--	2026-01-07 21:06
dpin_manage.php	8.8 KB	-rw-r--r--	2025-12-29 16:57
dpin_request.php	10.85 KB	-rw-r--r--	2025-12-29 16:53
footer.php	101 B	-rw-r--r--	2025-12-25 18:14
header.php	6.83 KB	-rw-r--r--	2026-01-26 22:06
history.php	23.07 KB	-rw-r--r--	2026-01-26 22:21
level_earning.php	18.53 KB	-rw-r--r--	2025-12-29 18:08
lucky_wheel.php	40.55 KB	-rw-r--r--	2026-01-26 22:22
my_plan.php	9.99 KB	-rw-r--r--	2025-12-29 16:00
plan_payment.php	19.84 KB	-rw-r--r--	2026-01-26 21:51
profile.php	9.06 KB	-rw-r--r--	2025-12-24 21:13
ranks.php	21.24 KB	-rw-r--r--	2025-12-27 13:42
referral.php	11.8 KB	-rw-r--r--	2025-12-24 21:26
support.php	10.32 KB	-rw-r--r--	2025-12-22 19:07
update_rank_popup.php	1.1 KB	-rw-r--r--	2025-12-27 13:31
watch_ad.php	6.68 KB	-rw-r--r--	2025-12-26 12:42
watch_ad_complete.php	4.34 KB	-rw-r--r--	2025-12-24 08:07
watch_ads.php	6.73 KB	-rw-r--r--	2025-12-26 12:01
withdraw.php	11.24 KB	-rw-r--r--	2025-12-24 22:35
wp-blog-header.php	2.74 KB	-r--r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

<?php
define('USER_PANEL', true);
require_once '../includes/config.php';
requireLogin();

$page_title = 'D-Pin Manage';

// Handle D-Pin usage
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['use_dpin'])) {
    $pinCode = trim(strtoupper($_POST['pin_code']));

if (empty($pinCode)) {
        setError("Please enter D-Pin code");
    } else {
        try {
            $pdo->beginTransaction();

$hasActive = hasActivePlan($_SESSION['user_id']);

// Check if D-Pin exists and is unused
            $stmt = $pdo->prepare("SELECT * FROM d_pins WHERE pin_code = ? AND status = 'unused'");
            $stmt->execute([$pinCode]);
            $dpin = $stmt->fetch();

if (!$dpin) {
                throw new Exception("Invalid or already used D-Pin");
            }

// Get the plan associated with this D-Pin price
            // Find the best matching plan (price <= pin value)
            $stmt = $pdo->prepare("SELECT * FROM plans WHERE status = 'active' AND plan_price <= ? ORDER BY plan_price DESC LIMIT 1");
            $stmt->execute([$dpin['price']]);
            $plan = $stmt->fetch();

if (!$plan) {
                throw new Exception("No plan found for this D-Pin value (" . number_format($dpin['price'], 2) . ")");
            }

// Mark D-Pin as used
            $stmt = $pdo->prepare("UPDATE d_pins SET status = 'used', used_by = ?, used_at = NOW() WHERE id = ?");
            $stmt->execute([$_SESSION['user_id'], $dpin['id']]);

// Deactivate any existing active plan
            $pdo->prepare("UPDATE user_plans SET status = 'expired' WHERE user_id = ? AND status = 'active'")->execute([$_SESSION['user_id']]);

// Create user plan
            $startDate = date('Y-m-d');
            if ($plan['plan_duration'] > 0) {
                $endDate = date('Y-m-d', strtotime("+{$plan['plan_duration']} days"));
            } else {
                $endDate = '2099-12-31'; // Lifetime
            }

$stmt = $pdo->prepare("
                INSERT INTO user_plans (user_id, plan_id, start_date, end_date, status) 
                VALUES (?, ?, ?, ?, 'active')
            ");
            $stmt->execute([$_SESSION['user_id'], $plan['id'], $startDate, $endDate]);

// Distribute Referral Commission (Critical for MLM)
            // Use the Plan Price for commission calculation
            distributeReferralCommission($_SESSION['user_id'], $plan['plan_price']);

$pdo->commit();

setSuccess("Your account is " . ($hasActive ? "upgraded" : "activated") . " by D-Pin. Best of luck!");
            header('Location: dpin_manage.php');
            exit;

} catch (Exception $e) {
            $pdo->rollBack();
            setError($e->getMessage());
        }
    }
}

// Get user's D-Pins (purchased by user)
$stmt = $pdo->prepare("SELECT * FROM d_pins WHERE user_id = ? ORDER BY created_at DESC");
$stmt->execute([$_SESSION['user_id']]);
$myDpins = $stmt->fetchAll();

// Get used D-Pins (used by user)
$stmt = $pdo->prepare("SELECT * FROM d_pins WHERE used_by = ? ORDER BY used_at DESC");
$stmt->execute([$_SESSION['user_id']]);
$usedDpins = $stmt->fetchAll();

include 'header.php';
?>

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

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

<div class="card">
    <div class="card-header">
        <i class="fas fa-key"></i> Use D-Pin
    </div>
    <div class="card-body">
        <p style="color: var(--text-secondary); margin-bottom: 15px;">
            Enter your D-Pin code to activate your plan instantly:
        </p>

<button type="submit" name="use_dpin" class="btn btn-primary btn-block">
                <i class="fas fa-check"></i> Activate Plan
            </button>
        </form>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <i class="fas fa-ticket-alt"></i> My D-Pins (Purchased)
    </div>
    <div class="card-body">
        <?php if (empty($myDpins)): ?>
            <p style="color: var(--text-secondary); text-align: center;">
                You haven't purchased any D-Pins yet.
                <a href="dpin_request.php" style="color: var(--primary-color);">Purchase now</a>
            </p>
        <?php else: ?>
            <div class="table-responsive">
                <table>
                    <thead>
                        <tr>
                            <th>Pin Code</th>
                            <th>Price</th>
                            <th>Status</th>
                            <th>Date</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($myDpins as $dpin): ?>
                            <tr>
                                <td>
                                    <strong style="font-family: monospace; color: var(--primary-color);">
                                        <?php echo htmlspecialchars($dpin['pin_code']); ?>
                                    </strong>
                                </td>
                                <td>
                                    <?php echo getSetting('currency_symbol', '$'); ?>
                                    <?php echo number_format($dpin['price'], 2); ?>
                                </td>
                                <td>
                                    <?php if ($dpin['status'] === 'unused'): ?>
                                        <span class="badge badge-success">Unused</span>
                                    <?php else: ?>
                                        <span class="badge badge-danger">Used</span>
                                        <?php if ($dpin['used_by']): ?>
                                            <br><small style="color: var(--text-secondary);">
                                                Used on <?php echo date('M d, Y', strtotime($dpin['used_at'])); ?>
                                            </small>
                                        <?php endif; ?>
                                    <?php endif; ?>
                                </td>
                                <td><?php echo date('M d, Y', strtotime($dpin['created_at'])); ?></td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        <?php endif; ?>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <i class="fas fa-history"></i> Used D-Pins History
    </div>
    <div class="card-body">
        <?php if (empty($usedDpins)): ?>
            <p style="color: var(--text-secondary); text-align: center;">
                You haven't used any D-Pins yet.
            </p>
        <?php else: ?>
            <div class="table-responsive">
                <table>
                    <thead>
                        <tr>
                            <th>Pin Code</th>
                            <th>Price</th>
                            <th>Used Date</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($usedDpins as $dpin): ?>
                            <tr>
                                <td>
                                    <strong style="font-family: monospace; color: var(--text-secondary);">
                                        <?php echo htmlspecialchars($dpin['pin_code']); ?>
                                    </strong>
                                </td>
                                <td>
                                    <?php echo getSetting('currency_symbol', '$'); ?>
                                    <?php echo number_format($dpin['price'], 2); ?>
                                </td>
                                <td><?php echo date('M d, Y H:i', strtotime($dpin['used_at'])); ?></td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        <?php endif; ?>
    </div>
</div>

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