Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
activate_dpin.php	7.76 KB	-rw-r--r--	2025-10-18 22:14
ads.php	11.49 KB	-rw-r--r--	2025-10-18 22:44
commission.php	7.01 KB	-rw-r--r--	2025-10-18 21:56
dashboard.php	17.28 KB	-rw-r--r--	2025-10-18 22:49
deposit.php	6.03 KB	-rw-r--r--	2025-10-18 21:45
deposit_history.php	4.26 KB	-rw-r--r--	2025-10-18 21:55
dpin.php	7.2 KB	-rw-r--r--	2025-10-18 22:26
dpin_history.php	5.91 KB	-rw-r--r--	2025-10-18 22:15
invite.php	6.44 KB	-rw-r--r--	2025-10-18 21:43
logout.php	91 B	-rw-r--r--	2025-10-18 21:42
notifications.php	3.73 KB	-rw-r--r--	2025-10-18 21:47
plans.php	10.34 KB	-rw-r--r--	2025-10-18 22:43
profile.php	6.69 KB	-rw-r--r--	2025-10-18 21:43
purchase_plan.php	4.99 KB	-rw-r--r--	2025-10-18 21:46
sidebar.php	5.16 KB	-rw-r--r--	2025-10-18 22:15
team.php	6.81 KB	-rw-r--r--	2025-10-18 21:47
transactions.php	4.37 KB	-rw-r--r--	2025-10-18 21:47
withdraw.php	7.92 KB	-rw-r--r--	2025-10-18 21:56
withdraw_history.php	7.74 KB	-rw-r--r--	2025-10-18 21:56

Rename

<?php
require_once '../includes/header.php';

$error_message = '';
$success_message = '';

// Handle D.Pin activation
if (isset($_POST['activate_dpin'])) {
    $dpin_code = sanitize_input($_POST['dpin_code']);
    
    // Validate input
    if (empty($dpin_code)) {
        $error_message = "Please enter a D.Pin code.";
    } else {
        // Check if D.Pin exists and is valid
        $stmt = $conn->prepare("SELECT id, user_id, pin_code, amount, status FROM dpins WHERE pin_code = ? AND status = 'active'");
        $stmt->bind_param("s", $dpin_code);
        $stmt->execute();
        $dpin_result = $stmt->get_result();
        
        if ($dpin_result->num_rows == 0) {
            $error_message = "Invalid or inactive D.Pin code.";
        } else {
            $dpin_data = $dpin_result->fetch_assoc();
            
            // Check if D.Pin belongs to this user
            if ($dpin_data['user_id'] != $_SESSION['user_id']) {
                $error_message = "This D.Pin does not belong to your account.";
            } else {
                // Start transaction
                $conn->begin_transaction();
                
                try {
                    // Update D.Pin status to used
                    $stmt = $conn->prepare("UPDATE dpins SET status = 'used', activated_at = NOW() WHERE id = ?");
                    $stmt->bind_param("i", $dpin_data['id']);
                    $stmt->execute();
                    
                    // Add amount to user's balance
                    $new_balance = $user['balance'] + $dpin_data['amount'];
                    $stmt = $conn->prepare("UPDATE users SET balance = ? WHERE id = ?");
                    $stmt->bind_param("di", $new_balance, $_SESSION['user_id']);
                    $stmt->execute();
                    
                    // Add transaction record
                    $stmt = $conn->prepare("INSERT INTO transactions (user_id, type, amount, status, description) VALUES (?, 'pin_purchase', ?, 'completed', 'D.Pin activated and balance added')");
                    $stmt->bind_param("id", $_SESSION['user_id'], $dpin_data['amount']);
                    $stmt->execute();
                    
                    // Add notification
                    $message = "D.Pin successfully activated. " . format_currency($dpin_data['amount']) . " has been added to your account balance.";
                    $stmt = $conn->prepare("INSERT INTO notifications (user_id, message, type) VALUES (?, ?, 'success')");
                    $stmt->bind_param("is", $_SESSION['user_id'], $message);
                    $stmt->execute();
                    
                    // Commit transaction
                    $conn->commit();
                    
                    $success_message = $message;
                    
                    // Refresh user data
                    $stmt = $conn->prepare("SELECT * FROM users WHERE id = ?");
                    $stmt->bind_param("i", $_SESSION['user_id']);
                    $stmt->execute();
                    $user_result = $stmt->get_result();
                    $user = $user_result->fetch_assoc();
                } catch (Exception $e) {
                    // Rollback transaction
                    $conn->rollback();
                    
                    $error_message = "Failed to activate D.Pin. Please try again.";
                }
            }
        }
    }
}
?>

<div class="container-fluid">
    <div class="row">
        
        <?php include 'sidebar.php'; ?>
        
        
        <main class="col-md-9 ms-sm-auto col-lg-10 main-content">
            <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">Activate D.Pin</h1>
            </div>
            
            <?php if ($error_message): ?>
                <div class="alert alert-danger"><?php echo $error_message; ?></div>
            <?php endif; ?>
            
            <?php if ($success_message): ?>
                <div class="alert alert-success"><?php echo $success_message; ?></div>
            <?php endif; ?>
            
            <div class="row">
                <div class="col-md-6">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="mb-0">Activate D.Pin</h5>
                        </div>
                        <div class="card-body">
                            <form method="POST">
                                <div class="mb-3">
                                    <label class="form-label">Current Balance</label>
                                    <input type="text" class="form-control" value="<?php echo format_currency($user['balance']); ?>" readonly>
                                </div>
                                
                                <div class="mb-3">
                                    <label for="dpin_code" class="form-label">Enter D.Pin Code</label>
                                    <input type="text" class="form-control" id="dpin_code" name="dpin_code" placeholder="Enter your 15-digit D.Pin code" maxlength="20" required>
                                    <div class="form-text">Enter the D.Pin code you received from admin or purchased</div>
                                </div>
                                
                                <button type="submit" name="activate_dpin" class="btn btn-primary">Activate D.Pin</button>
                            </form>
                        </div>
                    </div>
                </div>
                
                <div class="col-md-6">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="mb-0">How to Use D.Pin</h5>
                        </div>
                        <div class="card-body">
                            <ol>
                                <li class="mb-3">
                                    <strong>Get D.Pin</strong>
                                    <p class="mb-0">Request D.Pin from admin or purchase it using the D.Pin page</p>
                                </li>
                                <li class="mb-3">
                                    <strong>Receive Code</strong>
                                    <p class="mb-0">You'll receive a 15-digit D.Pin code in your D.Pin history</p>
                                </li>
                                <li class="mb-3">
                                    <strong>Activate D.Pin</strong>
                                    <p class="mb-0">Enter the code here to add balance to your account</p>
                                </li>
                                <li>
                                    <strong>Use Balance</strong>
                                    <p class="mb-0">Use your account balance to purchase membership plans</p>
                                </li>
                            </ol>
                        </div>
                    </div>
                    
                    <div class="card mt-4">
                        <div class="card-header">
                            <h5 class="mb-0">Need More D.Pin?</h5>
                        </div>
                        <div class="card-body">
                            <p>If you need more D.Pin codes, you can request them from the admin.</p>
                            <a href="dpin.php" class="btn btn-primary">Request D.Pin</a>
                        </div>
                    </div>
                </div>
            </div>
        </main>
    </div>
</div>

<?php
require_once '../includes/footer.php';
?>