This page doesn’t exist. Back to home';
require __DIR__ . '/inc/footer.php';
exit;
}
// Una sola dirección por combinación de filtros: otro orden, mayúsculas, sin barra final o
// parámetros antiguos (?tag=milf) redirigen a la canónica.
$canonicalPath = listing_url(array_merge($filters, ['q' => '', 'p' => 1]));
if ($path !== $canonicalPath || array_intersect_key($_GET, array_flip(LISTING_FILTERS))) {
header('Location: ' . listing_url($filters), true, 301);
exit;
}
['source' => $source, 'g' => $gender, 'tag' => $tag, 'country' => $country, 'age' => $age, 'new' => $onlyNew, 'hd' => $onlyHd, 'q' => $search, 'p' => $page] = $filters;
$link = fn(array $changes): string => listing_url(array_merge($filters, $changes));
$perPage = (int) config('site.per_page');
$where = ['r.is_online = 1'];
$params = [];
if (isset(SOURCES[$source])) {
$where[] = 'r.source = ?';
$params[] = $source;
}
if (isset(GENDERS[$gender])) {
$where[] = 'r.gender = ?';
$params[] = $gender;
}
if (isset(AGE_RANGES[$age])) {
$where[] = 'r.age BETWEEN ? AND ?';
array_push($params, ...AGE_RANGES[$age]);
}
if ($country === OTHER_COUNTRY) {
$where[] = "r.country = ''";
} elseif ($country !== '') {
$where[] = 'r.country = ?';
$params[] = $country;
}
if ($onlyNew !== '') {
$where[] = 'r.is_new = 1';
}
if ($onlyHd !== '') {
$where[] = 'r.is_hd = 1';
}
if ($tag !== '') {
$where[] = 'EXISTS (SELECT 1 FROM room_tags rt JOIN tags t ON t.id = rt.tag_id WHERE rt.room_id = r.id AND t.name = ?)';
$params[] = $tag;
}
if ($search !== '') {
$like = '%' . addcslashes($search, '%_\\') . '%';
$where[] = '(r.username LIKE ? OR r.display_name LIKE ? OR EXISTS (SELECT 1 FROM room_tags rt JOIN tags t ON t.id = rt.tag_id WHERE rt.room_id = r.id AND t.name = ?))';
array_push($params, $like, $like, mb_strtolower(ltrim($search, '#')));
}
$whereSql = implode(' AND ', $where);
$countStmt = db()->prepare("SELECT COUNT(*) FROM rooms r WHERE $whereSql");
$countStmt->execute($params);
$total = (int) $countStmt->fetchColumn();
$pages = max(1, (int) ceil($total / $perPage));
$page = min($page, $pages);
$stmt = db()->prepare("
SELECT r.source, r.username, r.display_name, r.gender, r.age, r.country, r.room_subject, r.current_show,
r.is_new, r.is_hd, r.num_users, r.image_url_360x270, r.image_url
FROM rooms r
WHERE $whereSql
ORDER BY r.num_users DESC
LIMIT $perPage OFFSET " . (($page - 1) * $perPage));
$stmt->execute($params);
$rooms = $stmt->fetchAll();
// Tags y ubicaciones más frecuentes, de todas las plataformas o de la filtrada. Son iguales para
// el resto de filtros, así que se guardan en caché (ver cached()): una entrada por plataforma.
$sourceSql = isset(SOURCES[$source]) ? 'AND r.source = ' . db()->quote($source) : '';
$cacheSuffix = isset(SOURCES[$source]) ? "_$source" : '';
$topTags = cached("top_tags$cacheSuffix", fn(): array => $sourceSql !== ''
? db()->query("
SELECT t.name, COUNT(*) AS total
FROM room_tags rt
JOIN tags t ON t.id = rt.tag_id
JOIN rooms r ON r.id = rt.room_id AND r.is_online = 1 $sourceSql
WHERE rt.is_online = 1
GROUP BY t.id
ORDER BY total DESC
LIMIT 30
")->fetchAll()
: top_tags_all_sources(30));
$topCountries = cached("top_countries$cacheSuffix", function () use ($sourceSql): array {
$countries = db()->query("
SELECT country, COUNT(*) AS total
FROM rooms r
WHERE is_online = 1 AND country <> '' $sourceSql
GROUP BY country
ORDER BY total DESC
LIMIT 40
")->fetchAll();
// Las salas sin país se agrupan al final como "Rest of the world".
$other = (int) db()->query("SELECT COUNT(*) FROM rooms r WHERE is_online = 1 AND country = '' $sourceSql")->fetchColumn();
if ($other > 0) {
$countries[] = ['country' => OTHER_COUNTRY, 'total' => $other];
}
return $countries;
});
$canonical = config('site.url') . $canonicalPath;
$titleParts = array_filter([
SOURCES[$source] ?? '',
GENDERS[$gender] ?? '',
$tag !== '' ? "#$tag" : '',
$country !== '' ? country_name($country) : '',
$age !== '' ? 'Age ' . age_range_label($age) : '',
$onlyNew !== '' ? 'New' : '',
$onlyHd !== '' ? 'HD' : '',
]);
$pageTitle = $titleParts ? implode(' · ', $titleParts) : null;
require __DIR__ . '/inc/header.php';
?>
new ✕
HD ✕
live cams
tagged # ✕
aged ✕
on ✕
from ✕
for “”
No cams match your filters. Try a different one.
1): ?>
Locations