query("SELECT role FROM users WHERE id = {$_SESSION['user_id']}")->fetch_assoc();
if (($check['role'] ?? '') !== 'admin') { die("Access Denied"); }
// 2. Handle Create Reseller
if (isset($_POST['create_reseller'])) {
$name = $conn->real_escape_string($_POST['name']);
$email = $conn->real_escape_string($_POST['email']);
$password = password_hash($_POST['password'], PASSWORD_DEFAULT);
$brand = $conn->real_escape_string($_POST['brand_name']);
// Check Email
$check_mail = $conn->query("SELECT id FROM users WHERE email = '$email'");
if ($check_mail->num_rows > 0) {
$error = "Email already registered.";
} else {
// Create User with role='reseller'
$stmt = $conn->prepare("INSERT INTO users (name, email, password, role, brand_name, plan_id) VALUES (?, ?, ?, 'reseller', ?, 3)");
// Note: Plan ID 3 should be your Agency Plan (create in DB if missing, or use 2)
$stmt->bind_param("ssss", $name, $email, $password, $brand);
if ($stmt->execute()) {
$msg = "New Reseller Agency Created!";
} else {
$error = "Error: " . $conn->error;
}
}
}
?>
Manage Resellers - Admin
Agency Partners (Resellers)
$msg
"; ?>
$error"; ?>
Create New Agency
Agency / Owner
Clients
Actions
query("SELECT * FROM users WHERE role = 'reseller' ORDER BY id DESC");
if ($resellers->num_rows > 0):
while($r = $resellers->fetch_assoc()):
// Count their sub-users
$sub_count = $conn->query("SELECT COUNT(*) as c FROM users WHERE parent_id = {$r['id']}")->fetch_assoc()['c'];
?>