prepare('SELECT affiliate_id, public_code, email, contact_name, status FROM affiliates WHERE public_code = ? LIMIT 1');
$stmt->execute([$refCode]);
$referrer = $stmt->fetch() ?: null;
if (!$referrer || (($referrer['status'] ?? '') !== 'active')) {
$referrer = null;
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
$signup_error = 'Invalid referral code.';
}
}
}
if ($referralLinkCode !== '') {
$referralLink = get_affiliate_referral_link_by_code($referralLinkCode);
if (!$referralLink || (($referralLink['status'] ?? '') !== 'active')) {
$referralLink = null;
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
$signup_error = 'Invalid referral link.';
}
} elseif (!$referrer || (int)($referralLink['affiliate_id'] ?? 0) !== (int)($referrer['affiliate_id'] ?? 0)) {
$referralLink = null;
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
$signup_error = 'Referral link does not match referral code.';
}
}
}
if ($_SERVER['REQUEST_METHOD'] !== 'POST' && $referrer) {
track_affiliate_referral_click(
(int)$referrer['affiliate_id'],
$referralLink ? (int)($referralLink['referral_link_id'] ?? 0) : null,
(string)$referrer['public_code']
);
}
// Handle signup form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['_csrf'])) {
if (!csrf_validate($_POST['_csrf'] ?? null)) {
$signup_error = 'Invalid CSRF token';
} else {
$email = strtolower(trim((string)($_POST['email'] ?? '')));
$password = (string)($_POST['password'] ?? '');
$confirm = (string)($_POST['confirm_password'] ?? '');
$contact = trim((string)($_POST['contact_name'] ?? ''));
$company = trim((string)($_POST['company_name'] ?? ''));
$instantMessenger = trim((string)($_POST['preferred_instant_messenger'] ?? ''));
$accept = (string)($_POST['accept_terms'] ?? '');
if ($email === '' || !filter_var($email, FILTER_VALIDATE_EMAIL)) {
$signup_error = 'Please enter a valid email address.';
} elseif (strlen($password) < 8) {
$signup_error = 'Password must be at least 8 characters.';
} elseif (!hash_equals($password, $confirm)) {
$signup_error = 'Passwords do not match.';
} elseif ($accept !== '1') {
$signup_error = 'You must accept the terms to continue.';
} elseif ($contact === '') {
$signup_error = 'Contact Name is required.';
} elseif ($company === '') {
$signup_error = 'Company is required.';
} else {
$exists = $pdo->prepare('SELECT affiliate_id FROM affiliates WHERE email = ?');
$exists->execute([$email]);
if ($exists->fetch()) {
$signup_error = 'An account with this email already exists.';
} else {
$referredBy = null;
$referredViaLinkId = null;
if ($refCode !== '') {
if (!$referrer) {
$signup_error = 'Invalid referral code.';
} elseif (strtolower((string)$referrer['email']) === $email) {
$signup_error = 'You cannot use your own affiliate referral code.';
} else {
$referredBy = (int)$referrer['affiliate_id'];
}
}
if ($referralLinkCode !== '') {
if (!$referralLink) {
$signup_error = 'Invalid referral link.';
} elseif (!$referrer || (int)($referralLink['affiliate_id'] ?? 0) !== (int)($referrer['affiliate_id'] ?? 0)) {
$signup_error = 'Referral link does not match referral code.';
} else {
$referredViaLinkId = (int)$referralLink['referral_link_id'];
}
}
if ($signup_error !== null) {
goto render_index;
}
// Generate unique code
for ($i = 0; $i < 30; $i++) {
$raw = random_bytes(6);
$code = strtoupper(substr(base64_encode($raw), 0, 10));
$code = preg_replace('/[^A-Z0-9]/', 'A', $code);
$stmt = $pdo->prepare('SELECT affiliate_id FROM affiliates WHERE public_code = ?');
$stmt->execute([$code]);
if (!$stmt->fetch()) {
break;
}
}
$hash = password_hash($password, PASSWORD_DEFAULT);
$ipBin = ip_to_binary($_SERVER['REMOTE_ADDR'] ?? '');
$termsVersion = defined('TERMS_VERSION') ? (string)TERMS_VERSION : 'v1';
try {
$stmt = $pdo->prepare('INSERT INTO affiliates (public_code, referred_by, referred_via_link_id, status, email, password_hash, created_at, terms_version, terms_accepted_at, terms_accepted_ip, contact_name, company_name, preferred_instant_messenger)
VALUES (?, ?, ?, \'pending\', ?, ?, UTC_TIMESTAMP(), ?, UTC_TIMESTAMP(), ?, ?, ?, ?)');
$stmt->execute([
$code,
$referredBy,
$referredViaLinkId,
$email,
$hash,
$termsVersion,
$ipBin,
substr($contact, 0, 120),
substr($company, 0, 120),
$instantMessenger !== '' ? substr($instantMessenger, 0, 255) : null,
]);
// Send email notification to admin
$ipAddress = $_SERVER['REMOTE_ADDR'] ?? 'Unknown';
sendAffiliateSignupNotification($code, $email, $contact, $company, $ipAddress);
$signup_success = true;
} catch (Throwable $e) {
$signup_error = 'Signup failed. Please try again.';
}
}
}
}
}
render_index:
// Load hero box content from database
$stmt = $pdo->prepare('SELECT content_html FROM hero_box_content ORDER BY id DESC LIMIT 1');
$stmt->execute();
$heroContent = $stmt->fetch();
// Get commission percentages for variable substitution
$stmt = $pdo->prepare("SELECT revshare_bps, applies_to FROM commission_plans WHERE type = 'revshare' AND active = 1");
$stmt->execute();
$plans = $stmt->fetchAll();
$membership_percentage = 50; // default
$token_percentage = 15; // default
foreach ($plans as $plan) {
$percentage = $plan['revshare_bps'] / 100;
if ($plan['applies_to'] === 'membership_purchase' || $plan['applies_to'] === 'all_sales') {
$membership_percentage = $percentage;
}
if ($plan['applies_to'] === 'token_purchase' || $plan['applies_to'] === 'all_sales') {
$token_percentage = $percentage;
}
}
// Prepare hero box HTML with variable substitution
if ($heroContent) {
$heroBoxHtml = $heroContent['content_html'];
// Replace variables
$heroBoxHtml = str_replace('{membership_percentage}', $membership_percentage, $heroBoxHtml);
$heroBoxHtml = str_replace('{token_percentage}', $token_percentage, $heroBoxHtml);
} else {
// Fallback to default content if database is empty
$heroBoxHtml = '
FantasyXXX.ai Affiliate Program
Turn AI fantasies into recurring revenue
Promote FantasyXXX.ai and earn ' . $membership_percentage . '% lifetime revshare on Memberships and ' . $token_percentage . '% on ALL Token sales with only one tracking link.
from one of the most advanced AI fantasy platforms online.
High-converting funnels, real-time tracking, and on-time payouts — built for serious adult affiliates.
Lifetime revshare on recurring memberships and ALL token salesLifetime cookie attributionToken & membership salesFast, flexible payouts
Why promote FantasyXXX.ai?
Built by adult industry veterans for performance marketers, FantasyXXX.ai is optimized to convert your traffic into paying, returning users.
Everything you need to scale profitable campaigns, from flexible payouts to battle-tested funnels.
High-converting AI offers: AI companions, fantasy chats, image and video generation are token-based content that keep users engaged, spending, and coming back.
Lifetime revshare: Earn on recurring memberships, token top-ups, and ALL token sales from returning users.
Lifetime cookie: Lifetime cookie attribution means you keep getting credit when your users come back and spend again.
Commission model: Lifetime revshare on recurring memberships and ALL token sales
Attribution: Lifetime cookie • last-click, affiliate-first — fair and transparent