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 = 'D.Pin';
include 'header.php';

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

// Handle D-Pin application
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['apply_pin'])) {
    $pin_code = trim($_POST['pin_code']);
    
    if (empty($pin_code)) {
        $error = 'Please enter a D-Pin.';
    } else {
        try {
            // Check if D-Pin exists and is active
            $stmt = $pdo->prepare("SELECT * FROM dpins WHERE pin_code = ? AND status = 'active'");
            $stmt->execute([$pin_code]);
            $dpin = $stmt->fetch();
            
            if ($dpin) {
                // Get the amount for this D-Pin (you might want to store this in the dpins table)
                // For now, we'll assume a fixed amount or calculate based on some logic
                $amount = 1000; // This should come from your business logic
                
                // Update D-Pin status to used
                $stmt = $pdo->prepare("UPDATE dpins SET status = 'used', used_at = NOW() WHERE id = ?");
                $stmt->execute([$dpin['id']]);
                
                // Add amount to user balance
                $stmt = $pdo->prepare("UPDATE users SET balance = balance + ? WHERE id = ?");
                $stmt->execute([$amount, $_SESSION['user_id']]);
                
                // Add transaction record
                $stmt = $pdo->prepare("INSERT INTO transactions (user_id, type, amount, note) VALUES (?, 'deposit', ?, 'D-Pin deposit')");
                $stmt->execute([$_SESSION['user_id'], $amount]);
                
                $success = 'D-Pin applied successfully! ₨' . number_format($amount, 2) . ' has been added to your balance.';
            } else {
                $error = 'Invalid or expired D-Pin.';
            }
        } catch (PDOException $e) {
            $error = 'Failed to apply D-Pin. Please try again.';
        }
    }
}

// Get user's D-Pins
try {
    $stmt = $pdo->prepare("SELECT * FROM dpins WHERE user_id = ? ORDER BY created_at DESC");
    $stmt->execute([$_SESSION['user_id']]);
    $dpins = $stmt->fetchAll();
} catch (PDOException $e) {
    $dpins = [];
}
?>

<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">D.Pin Management</h1>
</div>

<?php if ($error): ?>
    <div class="alert alert-danger"><?php echo htmlspecialchars($error); ?></div>
<?php endif; ?>

<?php if ($success): ?>
    <div class="alert alert-success"><?php echo htmlspecialchars($success); ?></div>
<?php endif; ?>

<div class="row">
    <div class="col-md-6">
        <div class="card">
            <div class="card-body">
                <h5 class="card-title">Apply D.Pin</h5>
                <form method="POST">
                    <div class="mb-3">
                        <label for="pin_code" class="form-label">Enter D.Pin</label>
                        <input type="text" class="form-control" id="pin_code" name="pin_code" placeholder="Enter your 15-character D.Pin" required>
                    </div>
                    <button type="submit" name="apply_pin" class="btn btn-primary">Apply D.Pin</button>
                </form>
            </div>
        </div>
    </div>
    <div class="col-md-6">
        <div class="card">
            <div class="card-body">
                <h5 class="card-title">What is D.Pin?</h5>
                <p>D.Pin is a 15-character code that can be used to deposit funds into your account instantly.</p>
                <p>These pins are generated by the admin and sent to you for bulk deposits.</p>
            </div>
        </div>
    </div>
</div>

<div class="row mt-4">
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <h5 class="card-title">Your D.Pins</h5>
                <?php if (count($dpins) > 0): ?>
                    <div class="table-responsive">
                        <table class="table table-striped">
                            <thead>
                                <tr>
                                    <th>D.Pin Code</th>
                                    <th>Status</th>
                                    <th>Created At</th>
                                    <th>Used At</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($dpins as $dpin): ?>
                                    <tr>
                                        <td><?php echo htmlspecialchars($dpin['pin_code']); ?></td>
                                        <td>
                                            <?php if ($dpin['status'] === 'active'): ?>
                                                <span class="badge bg-success">Active</span>
                                            <?php elseif ($dpin['status'] === 'used'): ?>
                                                <span class="badge bg-secondary">Used</span>
                                            <?php else: ?>
                                                <span class="badge bg-danger">Expired</span>
                                            <?php endif; ?>
                                        </td>
                                        <td><?php echo date('M d, Y H:i', strtotime($dpin['created_at'])); ?></td>
                                        <td><?php echo $dpin['used_at'] ? date('M d, Y H:i', strtotime($dpin['used_at'])) : '-'; ?></td>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                <?php else: ?>
                    <p>You don't have any D.Pins yet.</p>
                <?php endif; ?>
            </div>
        </div>
    </div>
</div>

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