<div id="featured_games_container"> <?php if (!defined('AVARCADE_')) { include '../../config.php'; include '../core.php'; } $cat_numb = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_games WHERE featured=1 AND published=1"), 0); if ($cat_numb > 0) { $category_games = mysql_query("SELECT * FROM ava_games WHERE featured=1 AND published=1 ORDER BY id desc"); while ($cat_games = mysql_fetch_array($category_games)) { $featured_game = GameData($cat_games, 'featured'); include '.' . $setting['template_url'] . '/' . $template['featured_game']; } } ?> </div>
<?php $sql = mysql_query("SELECT * FROM ava_games WHERE published=1 ORDER BY id desc LIMIT 6"); while ($row = mysql_fetch_array($sql)) { $url = GameUrl($row['id'], $row['seo_url'], $row['category_id']); $game = GameData($row, 'new'); $name = shortenStr($row['name'], $template['module_max_chars']); if ($setting['module_thumbs'] == 1) { $image_url = GameImageUrl($row['image'], $row['import'], $row['url']); $image = '<img src="' . $image_url . '" class="newgamesBOXIMG" alt="" /> '; } else { $image = ''; } $toolnip = '<div class=\'tooltipBOX_HORIZON\'><div style=\'float:left; width: 200px; padding: 10px 0 0 0px;\'> <img class=\'BOXGAMESTIP_IMG\' src=\'' . $image_url . '\' alt=\'\' /><br /> <span class=\'tooltipBOX_title\'>' . $name . '</span><br /> <span style=\'display:block; padding: 5px;\'>' . $game['description'] . '</span> <span style=\'display: block; width: 100px; padding: 0px 0 0 50px;\'> ' . $game['rating'] . ' </span> <div style=\'float:left; width: 200px; margin: 10px 0 5px 0;\'><span style=\'font-weight:bold; color: #ff7800;\'>' . $game['plays'] . ' People Played</span> </div> </div></div>'; if (strlen($name) > 25) { $name = substr($row['name'], 0, 25) . '...'; } echo '<li> <a href="' . $url . '" rel="tooltip" title="' . $toolnip . '"> ' . $image . '<br />' . $name . ' </a> </li>'; }
$sort = 'rating DESC'; } else { if ($_GET['sortby'] == 'plays') { $sort = 'hits DESC'; } else { if ($_GET['sortby'] == 'highscores') { $sort = 'highscores DESC'; } else { $sort = 'id DESC'; } } } } } } } } else { $sort = 'id DESC'; } $sql = mysql_query("SELECT * FROM ava_games WHERE {$where} published=1 ORDER BY {$sort} LIMIT {$from}, {$template['games_per_page']}"); while ($row = mysql_fetch_array($sql)) { $therow = $therow + 1; $game = GameData($row, 'category'); include '.' . $setting['template_url'] . '/' . $template['category_game']; if ($therow == $template['category_columns']) { $therow = 0; } } } else { echo '<div id="no_games">' . CATEGORY_NO_GAMES . '</div>'; }
<?php defined('AVARCADE_') or die(''); $sqla = mysql_query("SELECT * FROM ava_games WHERE submitter={$id}"); $count = mysql_num_rows($sqla); if ($count >= 1) { while ($row = mysql_fetch_array($sqla)) { $game = GameData($row, 'random'); include '.' . $setting['template_url'] . '/' . $template['submitted_game']; } } else { echo NO_SUBMITTED_GAMES; }
<?php defined('AVARCADE_') or die(''); if ($setting['homepage_order'] == 'random') { $order = "rand()"; } else { if ($setting['homepage_order'] == 'newest') { $order = "id DESC"; } else { $order = "rating DESC"; } } $category_games = mysql_query("SELECT * FROM ava_games WHERE (category_id = {$row['id']} OR category_parent = {$row['id']}) AND published=1 ORDER BY {$order} LIMIT " . $template['homepage_game_limit'] . ""); while ($cat_games = mysql_fetch_array($category_games)) { $game = GameData($cat_games, 'homepage'); include '.' . $setting['template_url'] . '/' . $template['home_game']; }
} } else { // Game not found header("HTTP/1.0 404 Not Found"); include 'includes/misc/404.php'; exit; } if (isset($_GET['name'])) { $sql = mysql_query("SELECT * FROM ava_games WHERE seo_url = '{$seo_url}'"); } else { $sql = mysql_query("SELECT * FROM ava_games WHERE id = {$id}"); } $row2 = mysql_fetch_array($sql); $id = $row2['id']; // Define 'game_info' array for usage in the view game template $game = GameData($row2, 'view_game'); // Detect the right fullscreen mode $game['full_screen'] = 1; if ($row2['filetype'] == 'swf' && $setting['fullscreen_mode'] == 1) { $game['full_screen_url'] = '#" onclick="ResizeFlash(' . $row2['height'] . ', ' . $row2['width'] . '); return false'; } else { if ($row2['filetype'] == 'unity' || $row2['filetype'] == 'unity3d' || $row2['filetype'] == 'code') { $game['full_screen_url'] = '#'; $game['full_screen'] = 0; } else { $game['full_screen_url'] = $setting['site_url'] . '/full_screen.php?id=' . $id; } } // Favourite game button if ($user['login_status'] == 1) { $user_fav_yet = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_favourites WHERE user_id='{$user['id']}' AND game_id='{$id}'"), 0);
<?php defined('AVARCADE_') or die(''); $q = mysql_query("SELECT favourites from ava_users WHERE id={$id}"); $favs = mysql_fetch_array($q); if ($favs['favourites'] == '') { echo PROFILE_NO_FAVS; } else { $favourites = substr($favs['favourites'], 2); $q2 = mysql_query("SELECT * from ava_games WHERE id IN ({$favourites}) AND published = 1"); while ($games = mysql_fetch_array($q2)) { $game = GameData($games, 'favourite'); // Include the template for favourite games include '.' . $setting['template_url'] . '/' . $template['favourite_game']; } }
<?php defined('AVARCADE_') or die(''); $cat_numb = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_games WHERE published=1"), 0); if ($cat_numb > 0) { //$from = (($page * $template['games_per_page']) - $template['games_per_page']); $sort = 'id DESC'; $sql = mysql_query("SELECT * FROM ava_games WHERE published=1 ORDER BY {$sort} LIMIT 0, {$template['games_per_page']}"); //$row = mysql_fetch_array($sql); while ($row = mysql_fetch_array($sql)) { //echo $row['id'] . '<br/>'; $game = GameData($row, 'homepage'); include '.' . $setting['template_url'] . '/' . $template['all_game']; } } else { echo '<div id="no_games">' . CATEGORY_NO_GAMES . '</div>'; }