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 = 'Manage D-Pins';

// Handle D-Pin actions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $action = $_POST['action'];

try {
        if ($action === 'generate') {
            $quantity = intval($_POST['quantity']);
            $price = floatval($_POST['price']);
            $userId = !empty($_POST['user_id']) ? intval($_POST['user_id']) : null;

$pdo->beginTransaction();

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

$pdo->commit();
            setSuccess("Generated $quantity D-Pin(s) successfully!");

} elseif ($action === 'delete') {
            $stmt = $pdo->prepare("DELETE FROM d_pins WHERE id = ?");
            $stmt->execute([intval($_POST['dpin_id'])]);
            setSuccess("D-Pin deleted successfully!");
        }
    } catch (Exception $e) {
        if ($pdo->inTransaction()) {
            $pdo->rollBack();
        }
        setError("Failed to perform action: " . $e->getMessage());
    }

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

// Get filter
$filter = $_GET['filter'] ?? 'all';

$query = "
    SELECT d.*, u.full_name, u.email, ub.full_name as used_by_name
    FROM d_pins d
    LEFT JOIN users u ON d.user_id = u.id
    LEFT JOIN users ub ON d.used_by = ub.id
";

if ($filter === 'unused') {
    $query .= " WHERE d.status = 'unused'";
} elseif ($filter === 'used') {
    $query .= " WHERE d.status = 'used'";
}

$query .= " ORDER BY d.created_at DESC";

$stmt = $pdo->query($query);
$dpins = $stmt->fetchAll();

// Get all users for assignment
$stmt = $pdo->query("SELECT id, full_name, email FROM users WHERE id != 1 ORDER BY full_name ASC");
$users = $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-plus"></i> Generate D-Pins
    </div>
    <div class="card-body">
        <form method="POST" action="">
            <input type="hidden" name="action" value="generate">

<div class="form-group">
                <label class="form-label">Quantity</label>
                <input type="number" name="quantity" class="form-control" placeholder="How many D-Pins to generate"
                    min="1" max="100" value="1" required>
            </div>

<div class="form-group">
                <label class="form-label">Price per D-Pin (<?php echo getSetting('currency_symbol', '$'); ?>)</label>
                <input type="number" name="price" class="form-control" placeholder="e.g., 10.00" step="0.01"
                    value="<?php echo getSetting('dpin_price', '10.00'); ?>" required>
            </div>

<div class="form-group">
                <label class="form-label">Assign to User (Optional)</label>
                <select name="user_id" class="form-control">
                    <option value="">-- No Assignment --</option>
                    <?php foreach ($users as $user): ?>
                        <option value="<?php echo $user['id']; ?>">
                            <?php echo htmlspecialchars($user['full_name']); ?>
                            (<?php echo htmlspecialchars($user['email']); ?>)
                        </option>
                    <?php endforeach; ?>
                </select>
                <small style="color: var(--text-secondary); display: block; margin-top: 5px;">
                    Leave empty for unassigned D-Pins
                </small>
            </div>

<button type="submit" class="btn btn-primary btn-block">
                <i class="fas fa-magic"></i> Generate D-Pins
            </button>
        </form>
    </div>
</div>

<div class="card">
    <div class="card-body">
        <div style="display: flex; gap: 10px; flex-wrap: wrap;">
            <a href="dpins.php?filter=all" class="btn btn-<?php echo $filter === 'all' ? 'primary' : 'secondary'; ?>">
                All
            </a>
            <a href="dpins.php?filter=unused"
                class="btn btn-<?php echo $filter === 'unused' ? 'success' : 'secondary'; ?>">
                Unused
            </a>
            <a href="dpins.php?filter=used" class="btn btn-<?php echo $filter === 'used' ? 'danger' : 'secondary'; ?>">
                Used
            </a>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <i class="fas fa-ticket-alt"></i> D-Pins (<?php echo count($dpins); ?>)
    </div>
    <div class="card-body">
        <?php if (empty($dpins)): ?>
            <p style="color: var(--text-secondary); text-align: center;">No D-Pins generated yet.</p>
        <?php else: ?>
            <div class="table-responsive" style="max-height: 350px; overflow-y: auto;">
                <table>
                    <thead>
                        <tr>
                            <th>Pin Code</th>
                            <th>Price</th>
                            <th>Owner</th>
                            <th>Status</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($dpins as $dpin): ?>
                            <tr>
                                <td>
                                    <strong style="font-family: monospace; color: var(--primary-color); font-size: 14px;">
                                        <?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['full_name']): ?>
                                        <strong><?php echo htmlspecialchars($dpin['full_name']); ?></strong>
                                        <br>
                                        <small style="color: var(--text-secondary);">
                                            <?php echo htmlspecialchars($dpin['email']); ?>
                                        </small>
                                    <?php else: ?>
                                        <span style="color: var(--text-secondary);">Unassigned</span>
                                    <?php endif; ?>
                                </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_name']): ?>
                                            <br>
                                            <small style="color: var(--text-secondary);">
                                                By: <?php echo htmlspecialchars($dpin['used_by_name']); ?>
                                            </small>
                                            <br>
                                            <small style="color: var(--text-secondary);">
                                                <?php echo date('M d, Y', strtotime($dpin['used_at'])); ?>
                                            </small>
                                        <?php endif; ?>
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <form method="POST" action="" style="margin: 0;">
                                        <input type="hidden" name="action" value="delete">
                                        <input type="hidden" name="dpin_id" value="<?php echo $dpin['id']; ?>">
                                        <button type="submit" class="btn btn-danger btn-sm"
                                            onclick="return confirm('Are you sure you want to delete this D-Pin?')">
                                            <i class="fas fa-trash"></i>
                                        </button>
                                    </form>
                                </td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        <?php endif; ?>
    </div>
</div>

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