prepare("SELECT id FROM users WHERE email = ?");
$check->execute([$email]);
if ($check->rowCount() > 0) {
$error = "Email already registered. Please login.";
} else {
$hash = password_hash($password, PASSWORD_DEFAULT);
// Generate Unique Referral Code
$my_ref_code = strtoupper(substr(str_replace(' ', '', $name), 0, 4) . rand(100, 999));
// Find Referrer ID
$referred_by = 0;
if (!empty($ref_code_input)) {
$refStmt = $pdo->prepare("SELECT id FROM users WHERE referral_code = ?");
$refStmt->execute([$ref_code_input]);
$referrer = $refStmt->fetch();
if ($referrer) {
$referred_by = $referrer['id'];
}
}
// Insert User (Auto-Verified = 1)
// We removed 'otp_code' and set 'is_verified' to 1 directly
$stmt = $pdo->prepare("INSERT INTO users (name, email, phone, password_hash, referral_code, referred_by, is_verified) VALUES (?, ?, ?, ?, ?, ?, 1)");
if ($stmt->execute([$name, $email, $phone, $hash, $my_ref_code, $referred_by])) {
$new_user_id = $pdo->lastInsertId();
// Log Referral
if ($referred_by > 0) {
$pdo->prepare("INSERT INTO referrals (referrer_id, referred_user_id, status) VALUES (?, ?, 'pending')")
->execute([$referred_by, $new_user_id]);
}
// AUTO LOGIN AFTER REGISTRATION
$_SESSION['user_id'] = $new_user_id;
$_SESSION['user_name'] = $name;
$_SESSION['role'] = 'user';
$_SESSION['reseller_status'] = 'none';
// Redirect to Dashboard
header("Location: profile.php");
exit();
} else {
$error = "Registration failed. Please try again.";
}
}
}
include 'includes/header.php';
?>