Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
ads.php	10.11 KB	-rw-r--r--	2025-12-22 20:20
announcements.php	8.13 KB	-rw-r--r--	2025-12-25 17:46
banners.php	9.86 KB	-rw-r--r--	2025-12-22 19:19
boosts.php	5.51 KB	-rw-r--r--	2025-12-24 21:41
daily_targets.php	11.29 KB	-rw-r--r--	2025-12-26 07:59
dashboard.php	9.23 KB	-rw-r--r--	2025-12-25 12:46
deposits.php	13.59 KB	-rw-r--r--	2026-01-26 16:58
dpin_requests.php	7.43 KB	-rw-r--r--	2025-12-24 21:41
dpins.php	9.37 KB	-rw-r--r--	2025-12-23 19:48
error_log	1.14 KB	-rw-r--r--	2026-01-07 16:39
footer.php	122 B	-rw-r--r--	2025-12-25 18:15
header.php	6.83 KB	-rw-r--r--	2026-01-26 17:15
login.php	4.42 KB	-rw-r--r--	2026-01-26 17:46
lucky_wheel.php	24.12 KB	-rw-r--r--	2026-01-26 16:57
orders.php	12.63 KB	-rw-r--r--	2026-01-07 16:27
payment_methods.php	6.53 KB	-rw-r--r--	2025-12-23 19:24
plans.php	22.86 KB	-rw-r--r--	2025-12-29 11:03
products.php	10.72 KB	-rw-r--r--	2026-01-07 16:15
ranks.php	7.31 KB	-rw-r--r--	2025-12-25 16:48
referrals.php	8.7 KB	-rw-r--r--	2025-12-25 12:43
return.php	440 B	-rw-r--r--	2025-12-29 13:55
settings.php	10.77 KB	-rw-r--r--	2026-01-07 16:26
tickets.php	11.98 KB	-rw-r--r--	2025-12-22 19:21
users.php	18.1 KB	-rw-r--r--	2025-12-29 13:53
withdraws.php	11.42 KB	-rw-r--r--	2025-12-24 22:29
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('ADMIN_PANEL', true);
require_once '../includes/config.php';
requireAdmin();

$page_title = 'D-Pin Requests';

// Handle Actions (Approve/Reject)
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $requestId = intval($_POST['request_id']);
    $action = $_POST['action'];

try {
        $pdo->beginTransaction();

$stmt = $pdo->prepare("SELECT * FROM dpin_requests WHERE id = ?");
        $stmt->execute([$requestId]);
        $request = $stmt->fetch();

if (!$request)
            throw new Exception("Request not found");
        if ($request['status'] !== 'pending')
            throw new Exception("Request already processed");

if ($action === 'approve') {
            // 1. Generate Pins
            $pinPrice = $request['total_amount'] / $request['pin_count'];

for ($i = 0; $i < $request['pin_count']; $i++) {
                $pinCode = generateDPin();
                $stmt = $pdo->prepare("
                    INSERT INTO d_pins (pin_code, user_id, price, status) 
                    VALUES (?, ?, ?, 'unused')
                ");
                $stmt->execute([$pinCode, $request['user_id'], $pinPrice]);
            }

// 2. Update Request Status
            $stmt = $pdo->prepare("UPDATE dpin_requests SET status = 'approved', admin_note = 'Approved via Panel' WHERE id = ?");
            $stmt->execute([$requestId]);

$pdo->commit();
            setSuccess("Approved! Generated {$request['pin_count']} D-Pins for user.");

} elseif ($action === 'reject') {
            $stmt = $pdo->prepare("UPDATE dpin_requests SET status = 'rejected' WHERE id = ?");
            $stmt->execute([$requestId]);

$pdo->commit();
            setSuccess("Request rejected.");
        }

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

header('Location: dpin_requests.php');
    exit;
}

// Fetch Pending Requests
$stmt = $pdo->query("
    SELECT r.*, u.full_name, u.email 
    FROM dpin_requests r 
    JOIN users u ON r.user_id = u.id 
    WHERE r.status = 'pending' 
    ORDER BY r.created_at DESC
");
$pendingRequests = $stmt->fetchAll();

// Fetch History
$stmt = $pdo->query("
    SELECT r.*, u.full_name 
    FROM dpin_requests r 
    JOIN users u ON r.user_id = u.id 
    WHERE r.status != 'pending' 
    ORDER BY r.created_at DESC 
    LIMIT 20
");
$historyRequests = $stmt->fetchAll();

include 'header.php';
?>

<?php
$success = getSuccess();
if ($success): ?>
    <div class="alert alert-success"><i class="fas fa-check"></i> <?php echo $success; ?></div>
<?php endif; ?>

<?php
$error = getError();
if ($error): ?>
    <div class="alert alert-danger"><i class="fas fa-exclamation"></i> <?php echo $error; ?></div>
<?php endif; ?>

<div class="card">
    <div class="card-header bg-warning">
        <i class="fas fa-clock"></i> Pending D-Pin Requests
    </div>
    <div class="card-body">
        <?php if (empty($pendingRequests)): ?>
            <p class="text-center text-muted">No pending requests.</p>
        <?php else: ?>
            <div class="table-responsive">
                <table class="table">
                    <thead>
                        <tr>
                            <th>User</th>
                            <th>Pins</th>
                            <th>Total</th>
                            <th>Method</th>
                            <th>Proof</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($pendingRequests as $req): ?>
                            <tr>
                                <td>
                                    <strong><?php echo htmlspecialchars($req['full_name']); ?></strong><br>
                                    <small><?php echo htmlspecialchars($req['email']); ?></small>
                                </td>
                                <td><span class="badge badge-info"><?php echo $req['pin_count']; ?></span></td>
                                <td><?php echo formatCurrency($req['total_amount']); ?></td>
                                <td><?php echo htmlspecialchars($req['method']); ?></td>
                                <td>
                                    <a href="../uploads/screenshots/<?php echo htmlspecialchars($req['screenshot']); ?>"
                                        target="_blank">
                                        <img src="../uploads/screenshots/<?php echo htmlspecialchars($req['screenshot']); ?>"
                                            style="height: 40px; border-radius: 4px;">
                                    </a>
                                </td>
                                <td>
                                    <form method="POST" style="display:inline;">
                                        <input type="hidden" name="request_id" value="<?php echo $req['id']; ?>">
                                        <button type="submit" name="action" value="approve" class="btn btn-sm btn-success"
                                            onclick="return confirm('Approve and Generate Pins?')">
                                            <i class="fas fa-check"></i>
                                        </button>
                                        <button type="submit" name="action" value="reject" class="btn btn-sm btn-danger"
                                            onclick="return confirm('Reject request?')">
                                            <i class="fas fa-times"></i>
                                        </button>
                                    </form>
                                </td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        <?php endif; ?>
    </div>
</div>

<div class="card mt-4">
    <div class="card-header">
        <i class="fas fa-history"></i> Recent History
    </div>
    <div class="card-body">
        <div class="table-responsive" style="max-height: 450px; overflow-y: auto;">
            <table class="table">
                <thead>
                    <tr>
                        <th>User</th>
                        <th>Count</th>
                        <th>Status</th>
                        <th>Date</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($historyRequests as $req): ?>
                        <tr>
                            <td><?php echo htmlspecialchars($req['full_name']); ?></td>
                            <td><?php echo $req['pin_count']; ?></td>
                            <td>
                                <span
                                    class="badge badge-<?php echo $req['status'] == 'approved' ? 'success' : 'danger'; ?>">
                                    <?php echo ucfirst($req['status']); ?>
                                </span>
                            </td>
                            <td><?php echo date('M d, H:i', strtotime($req['created_at'])); ?></td>
                        </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
    </div>

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