$id) {
$key = ":type$index";
$placeholders[] = $key;
$params[$key] = (int)$id; // Ensure integer safety
}
$sql = 'SELECT * FROM assets WHERE AssetType IN (' . implode(', ', $placeholders) . ') AND isPrivate != 1';
if (!empty($keyword) && trim($keyword) !== "") {
$sql .= ' AND Name LIKE :keyword';
$params[':keyword'] = '%' . $keyword . '%';
}elseif(returnVal($categories, $category) === "Featured"){
$sql .= ' ORDER BY AssetID, Sales DESC LIMIT 42'; // featured
}else{
$sql .= ' ORDER BY RAND() LIMIT 42';
}
$offset = ($page - 1) * 42;
if($page >= 2){
$sql .= " OFFSET $offset";
}
//echo $sql;
$stmt = $pdo->prepare($sql);
$stmt->execute($params);
$assets = $stmt->fetchAll();
// Count query (more efficient using COUNT(*))
$countSql = 'SELECT COUNT(*) FROM assets WHERE AssetType IN (' . implode(', ', $placeholders) . ') AND isPrivate != 1';
if (!empty($keyword) && trim($keyword) !== "") {
$countSql .= ' AND Name LIKE :keyword';
}
$count = count($assets) * $page;
$countStmt = $pdo->prepare($countSql);
$countStmt->execute($params);
$maxCount = $countStmt->fetchColumn();
}
?>
»
Showing - of $maxCount results"?>
Sort by:
No Results found";
if(!empty($keyword)){
$x = htmlspecialchars($keyword);
$noresult .= " for \"
{$x}\"";
}
$noresult .= ".";
echo $noresult;
}
foreach ($assets as $asset) {
$id = htmlspecialchars($asset['AssetID']);
$name = htmlspecialchars($asset['Name']);
$price = htmlspecialchars($asset['RobuxPrice']);
$creatorID = htmlspecialchars($asset['CreatorID']);
$sales = number_format($asset['Sales']);
$favorited = number_format($asset['Favorites']);
$updated = htmlspecialchars(timeAgo($asset['Updated_At'])); // Format this as needed
$stmt = $pdo->prepare('SELECT * FROM users where UserId = :uid');
$stmt->execute(['uid' => $asset['CreatorID']]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
$created_by = $user['Username'];
// Generate a URL-friendly version of the name
$urlName = urlencode(str_replace(' ', '-', $name));
$link = "/$urlName-item?id=$id";
$price_tag = "
$price
";
if($asset['RobuxPrice'] == 0 && $asset['TixPrice'] == 0){
$price_tag = '
Free';
}elseif($asset['TixPrice'] > 0 && $asset['RobuxPrice'] == 0){
$price_tag = "
{$asset['TixPrice']}
";
}
// Small catalog items
echo "
Updated: $updated
Sales: $sales
Favorited: $favorited times
";
}
?>
= 2): ?>
Page of
