query("SELECT style_key FROM nova_layout_styles WHERE is_active = 1 LIMIT 1"); if ($layout_stmt && $layout_stmt->num_rows > 0) { $layout_style = $layout_stmt->fetch_assoc()['style_key']; } $display_settings = []; $display_settings_query = $conn->query("SELECT setting_key, setting_value FROM nova_display_settings"); if ($display_settings_query) { while ($row = $display_settings_query->fetch_assoc()) { $display_settings[$row['setting_key']] = $row['setting_value']; } } else { error_log("Error fetching display settings: " . $conn->error); } $default_limit_popular = 20; $default_limit_new = 20; $default_limit_may_like = 10; $default_moderngrid_popular = 42; $default_moderngrid_new = 42; $default_moderngrid_may_like = 21; if ($layout_style === 'moderngrid') { $limit_popular = $display_settings['popular_limit_custom'] ?? $default_moderngrid_popular; } else { $limit_popular = $display_settings['popular_limit_default'] ?? $default_limit_popular; } if ($layout_style === 'moderngrid') { $limit_new = $display_settings['new_limit_custom'] ?? $default_moderngrid_new; } else { $limit_new = $display_settings['new_limit_default'] ?? $default_limit_new; } if ($layout_style === 'moderngrid') { $limit_may_like = $display_settings['may_like_limit_custom'] ?? $default_moderngrid_may_like; } else { $limit_may_like = $display_settings['may_like_limit_default'] ?? $default_limit_may_like; } $categories_result = $conn->query("SELECT * FROM nova_categories ORDER BY name ASC"); $all_categories = []; if ($categories_result) { while ($cat = $categories_result->fetch_assoc()) { $all_categories[] = $cat; } } $total_categories = count($all_categories); $all_categories_json = json_encode($all_categories); $ads = []; $ads_sql = "SELECT ad_name, code FROM nova_ads WHERE status = 1"; $ads_result = $conn->query($ads_sql); if ($ads_result) { while ($row = $ads_result->fetch_assoc()) { $ads[$row['ad_name']] = $row['code']; } } $pages_result = $conn->query("SELECT title, slug FROM nova_pages ORDER BY title ASC"); $all_pages = []; if ($pages_result) { while ($page = $pages_result->fetch_assoc()) { $all_pages[] = $page; } } $search_query = ""; $search_results = []; $display_message = ""; $is_searching = false; if (isset($_GET['q']) && !empty($_GET['q'])) { $search_query = $conn->real_escape_string($_GET['q']); $is_searching = true; $sql_search = "SELECT id, name, slug, image_url FROM nova_games WHERE name LIKE '%$search_query%' AND status = 'active' ORDER BY name ASC"; $result_search = $conn->query($sql_search); if ($result_search) { if ($result_search->num_rows > 0) { while ($row = $result_search->fetch_assoc()) { $search_results[] = $row; } } else { $display_message = "Your search for \"" . htmlspecialchars($search_query) . "\" yielded no results. Try a different game or category!"; } } else { $display_message = "Error performing search: " . $conn->error; } } ?> <?= htmlspecialchars($settings['site_title'] ?? 'NovaArcade - Game Portal') ?>

NovaArcade - Best Games Here!

<?= htmlspecialchars($settings['site_name'] ?? 'NovaArcade Logo') ?>

Search Results for ""

<?= htmlspecialchars($game['name']) ?>

Popular Games

query($sql); if ($result): while ($row = $result->fetch_assoc()): ?>
<?= htmlspecialchars($row['name']) ?>

<?= htmlspecialchars($row['name']) ?>

<?= htmlspecialchars($row['name']) ?>

New Games

query($sql); if ($result): while ($row = $result->fetch_assoc()): ?>
<?= htmlspecialchars($row['name']) ?>

<?= htmlspecialchars($row['name']) ?>

<?= htmlspecialchars($row['name']) ?>

You May Like

query($sql); if ($result): while ($row = $result->fetch_assoc()): ?>
<?= htmlspecialchars($row['name']) ?>

<?= htmlspecialchars($row['name']) ?>

<?= htmlspecialchars($row['name']) ?>