prepare("SELECT * FROM reseller_requests WHERE id = ?");
$stmt->execute([$req_id]);
$request = $stmt->fetch();
if ($request) {
$email = $request['email'];
$company = $request['business_name'];
// Check if user has an account
$uCheck = $pdo->prepare("SELECT id FROM users WHERE email = ?");
$uCheck->execute([$email]);
$user = $uCheck->fetch();
if ($user) {
// Upgrade existing user
$pdo->prepare("UPDATE users SET reseller_status = 'approved', company_name = ? WHERE id = ?")
->execute([$company, $user['id']]);
// Mark request as approved
$pdo->prepare("UPDATE reseller_requests SET status = 'approved' WHERE id = ?")->execute([$req_id]);
$msg = "User upgraded to Reseller successfully!";
$msgClass = "success";
} else {
// User doesn't exist yet
$msg = "Application marked Approved, but user has no account yet. They must register with email: $email";
$msgClass = "warning";
$pdo->prepare("UPDATE reseller_requests SET status = 'approved' WHERE id = ?")->execute([$req_id]);
}
}
}
// 2. HANDLE REJECT
if (isset($_GET['reject'])) {
$id = $_GET['reject'];
$pdo->prepare("UPDATE reseller_requests SET status = 'rejected' WHERE id = ?")->execute([$id]);
header("Location: resellers.php?msg=rejected"); exit();
}
// 3. FETCH REQUESTS
try {
$new_requests = $pdo->query("SELECT * FROM reseller_requests WHERE status = 'new' ORDER BY created_at DESC")->fetchAll();
$history = $pdo->query("SELECT * FROM reseller_requests WHERE status != 'new' ORDER BY created_at DESC LIMIT 50")->fetchAll();
} catch (Exception $e) {
$new_requests = [];
$history = [];
$msg = "Error: Table 'reseller_requests' missing. Please run the SQL command below.";
$msgClass = "error";
}
?>
Manage Resellers