![Free Fire Name Style -[2025] 🆒 Stylish Names ff](https://blogger.googleusercontent.com/img/a/AVvXsEgmJeQFSnkBE-FqrH6f4yyPMczDVvfAlSEhFga4YdxSoZR1_URWcoXWsEFYecdnwpIJMQOb0l0PWrHddxjJVYh8PKEXE5ImXiYjYxyajhZ4CNB8BTe6pECay2MMBt85ZlsCwPuW4cptghO1ycAIy4IQxQegQ64OjFEfSz-kw5bRkqhkTrX8D0ksK40cAQ=s150)
PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
]
);
} catch (PDOException $e) {
die("Connection failed: " . $e->getMessage());
}
function ensureGuestUser($pdo) {
if (!isset($_SESSION['user_id'])) {
$guestLabel = 'guest_' . bin2hex(random_bytes(6));
try {
$stmt = $pdo->prepare("INSERT INTO users (nickname, is_guest) VALUES (?, 1)");
$stmt->execute([$guestLabel]);
} catch (PDOException $e) {
$stmt = $pdo->prepare("INSERT INTO users (nickname) VALUES (?)");
$stmt->execute([$guestLabel]);
}
$_SESSION['user_id'] = $pdo->lastInsertId();
$_SESSION['is_guest'] = true;
}
}
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'vote') {
header('Content-Type: application/json');
$response = ['success' => false, 'message' => ''];
ensureGuestUser($pdo);
if (!isset($_SESSION['user_id'])) {
$response['message'] = "Session error. Please refresh and try again.";
echo json_encode($response);
exit;
}
$target_id = (int)($_POST['target_id'] ?? 0);
$vote_type = $_POST['vote_type'] ?? '';
if ($target_id === (int)$_SESSION['user_id']) {
$response['message'] = "You cannot vote on your own nickname!";
} elseif ($target_id > 0 && in_array($vote_type, ['like', 'dislike'])) {
try {
$stmt = $pdo->prepare("
INSERT INTO votes (voter_id, target_id, vote_type)
VALUES (?, ?, ?)
ON DUPLICATE KEY UPDATE vote_type = ?
");
$stmt->execute([$_SESSION['user_id'], $target_id, $vote_type, $vote_type]);
$response['success'] = true;
$response['message'] = "Vote saved!";
} catch (PDOException $e) {
$response['message'] = "Database error: " . $e->getMessage();
}
} else {
$response['message'] = "Invalid vote request";
}
echo json_encode($response);
exit;
}
$messages = [];
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'add_nickname') {
$nick = trim($_POST['nickname'] ?? '');
if (strlen($nick) < 3 || strlen($nick) > 50) {
$messages['error'] = "Nickname must be 3-50 characters long";
} else {
try {
// Try to insert without checking for duplicates first
$stmt = $pdo->prepare("INSERT INTO users (nickname, is_guest, created_at) VALUES (?, 0, NOW())");
$stmt->execute([$nick]);
$new_id = $pdo->lastInsertId();
// Update session to point to the new nickname row
$_SESSION['user_id'] = $new_id;
$_SESSION['nickname'] = $nick;
$_SESSION['is_guest'] = false;
header("Location: index.php?msg=added");
exit;
} catch (PDOException $e) {
// Check if it's a duplicate entry error
if ($e->errorInfo[1] == 1062) { // MySQL duplicate entry error code
$messages['error'] = "This nickname already exists! Please remove the unique constraint from the database to allow duplicates.";
} else {
$messages['error'] = "Error adding nickname: " . $e->getMessage();
}
}
}
}
$current_user = null;
$is_guest = true;
if (isset($_SESSION['user_id'])) {
try {
$stmt = $pdo->prepare("SELECT nickname, is_guest FROM users WHERE id = ?");
$stmt->execute([$_SESSION['user_id']]);
$current_user = $stmt->fetch();
if ($current_user) $is_guest = !empty($current_user['is_guest']);
} catch (PDOException $e) {
$stmt = $pdo->prepare("SELECT nickname FROM users WHERE id = ?");
$stmt->execute([$_SESSION['user_id']]);
$current_user = $stmt->fetch();
$is_guest = isset($_SESSION['is_guest']) ? $_SESSION['is_guest'] : true;
}
}
// ========== PAGINATION ==========
$per_page = 100;
$page = max(1, (int)($_GET['page'] ?? 1));
$offset = ($page - 1) * $per_page;
try {
$count_stmt = $pdo->query("SELECT COUNT(*) FROM users WHERE (is_guest = 0 OR is_guest IS NULL)");
} catch (PDOException $e) {
$count_stmt = $pdo->query("SELECT COUNT(*) FROM users WHERE nickname NOT LIKE 'guest_%'");
}
$total_rows = (int)$count_stmt->fetchColumn();
$total_pages = max(1, ceil($total_rows / $per_page));
$page = min($page, $total_pages);
$offset = ($page - 1) * $per_page;
?>
1): ?>
$msg): ?>
✅ Nickname added successfully!
prepare("
SELECT u.id, u.nickname, u.created_at,
COUNT(CASE WHEN v.vote_type='like' THEN 1 END) AS likes,
COUNT(CASE WHEN v.vote_type='dislike' THEN 1 END) AS dislikes
FROM users u
LEFT JOIN votes v ON v.target_id = u.id
WHERE (u.is_guest = 0 OR u.is_guest IS NULL)
GROUP BY u.id, u.nickname, u.created_at
ORDER BY u.created_at DESC
LIMIT :limit OFFSET :offset
");
$stmt->bindValue(':limit', $per_page, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
} catch (PDOException $e) {
$stmt = $pdo->prepare("
SELECT u.id, u.nickname, u.created_at,
COUNT(CASE WHEN v.vote_type='like' THEN 1 END) AS likes,
COUNT(CASE WHEN v.vote_type='dislike' THEN 1 END) AS dislikes
FROM users u
LEFT JOIN votes v ON v.target_id = u.id
WHERE u.nickname NOT LIKE 'guest_%'
GROUP BY u.id, u.nickname, u.created_at
ORDER BY u.created_at DESC
LIMIT :limit OFFSET :offset
");
$stmt->bindValue(':limit', $per_page, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
}
$now = new DateTime();
$has_rows = false;
while ($row = $stmt->fetch()):
$has_rows = true;
$is_mine = isset($_SESSION['user_id']) && $row['id'] == $_SESSION['user_id'];
$created = new DateTime($row['created_at']);
$interval = $now->diff($created);
$is_new = $interval->days == 0 && $interval->h < 24;
$nick = htmlspecialchars($row['nickname']);
?>
Stylish Name
YOU
NEW
No nicknames found yet. Be the first to add one! 🎉
Post a Comment
Comment your name style