<?php echo '<ul>'; $sql = mysql_query("SELECT * FROM ava_games WHERE published=1 ORDER BY hits desc LIMIT 10"); while ($row = mysql_fetch_array($sql)) { $url = GameUrl($row['id'], $row['seo_url'], $row['category_id']); $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 . '" width="25" height="25" style="vertical-align: middle;" alt="' . $row['name'] . '" /> '; } else { $image = ''; } echo '<li>' . $image . '<a href="' . $url . '">' . $name . '</a></li>'; } echo '</ul>';
function GameData($raw_data, $type) { global $setting, $template, $user; $game = array('id' => $raw_data['id'], 'instructions' => nl2br($raw_data['instructions']), 'plays' => $raw_data['hits'], 'highscores' => $raw_data['highscores'], 'seo_url' => $raw_data['seo_url'], 'category' => $raw_data['category_id'], 'submitter' => $raw_data['submitter']); if ($type != 'view_game') { $description_stripped = htmlspecialchars(strip_tags($raw_data['description'])); } if (isset($template[$type . '_game_chars'])) { $game['name'] = shortenStr($raw_data['name'], $template[$type . '_game_chars']); } else { $game['name'] = $raw_data['name']; } if (isset($template[$type . '_game_desc_chars'])) { $game['description'] = shortenStr($description_stripped, $template[$type . '_game_desc_chars']); } else { $game['description'] = $raw_data['description']; } $game['url'] = GameUrl($raw_data['id'], $raw_data['seo_url'], $raw_data['category_id']); $game['image_url'] = GameImageUrl($raw_data['image'], $raw_data['import'], $raw_data['url']); if ($raw_data['highscores'] == 1) { $game['highscore_image'] = $template['highscore_image']; } else { $game['highscore_image'] = ''; } if ($user['admin'] == 1) { $game['admin_edit'] = '<a href="' . $setting['site_url'] . '/admin/?task=manage_games#id=' . $raw_data['id'] . '">Edit</a>'; } else { $game['admin_edit'] = ''; } $game['date_added'] = FormatDate($raw_data['date_added'], 'date'); // Define the overall rating for use in the template $game['rating'] = $game['rating_image'] = GenerateRating($raw_data['rating'], $type); $game['rating_value'] = $raw_data['rating']; // Get the submitter name and URL if ($raw_data['submitter'] != 0) { $submitter = mysql_fetch_array(mysql_query("SELECT * FROM ava_users WHERE id = {$raw_data['submitter']}")); $game['submitter_name'] = $submitter['username']; $game['submitter_url'] = ProfileUrl($submitter['id'], $submitter['seo_url']); } return $game; }
$count = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_highscores WHERE user = {$id}"), 0); if ($count >= 1) { $query = mysql_query("SELECT * FROM ava_highscores WHERE user = {$id} ORDER BY score desc LIMIT 10"); echo '<ul class="user_highscore_list"> <li> <div id="user_highscore_header"> <div class="user_highscore_name">' . GAME . '</div> <div class="user_highscore_score">' . HIGHSCORE_SCORE . '</div> </div> </li>'; while ($highscore = mysql_fetch_array($query)) { $game_query = mysql_query("SELECT * FROM ava_games WHERE id = {$highscore['game']}"); $highscore_game = mysql_fetch_array($game_query); $date = FormatDate($highscore['date'], 'short'); $game_url = GameUrl($highscore_game['id'], $highscore_game['seo_url'], $highscore_game['category_id']); $game_thumbnail = GameImageUrl($highscore_game['image'], $highscore_game['import'], $highscore_game['url']); echo '<li> <div class="user_highscore_container"> <div class="user_highscore_avatar"> <a href="' . $game_url . '"><img src="' . $game_thumbnail . '" width="30" height="30"/></a> </div> <div class="user_highscore_name"><a href="' . $game_url . '">' . shortenStr($highscore_game['name'], 15) . '</a></div> <div class="user_highscore_score">' . $highscore['score'] . '</div> </div> </li>'; } echo '</ul>'; } else { echo '<div class="user_no_highscores">' . HIGHSCORE_NONE . '</div>'; }
$are_friends = mysql_num_rows(mysql_query("SELECT * FROM ava_friends WHERE user1 = {$cookie_id} AND user2 = {$friend_id}")); if ($user['password'] == $code && $user['banned'] == 0 && $are_friends == 1) { if ($leaderboard_id == 'latest') { $score = mysql_query("SELECT * FROM ava_highscores WHERE user = {$user['id']} AND game = {$game_id} ORDER BY id DESC LIMIT 1"); $highscore = mysql_fetch_array($score); $leaderboard = mysql_fetch_array(mysql_query("SELECT * FROM ava_leaderboards WHERE leaderboard_id = '{$highscore['leaderboard']}' AND game_id = {$game_id}")); } else { $leaderboard = mysql_fetch_array(mysql_query("SELECT * FROM ava_leaderboards WHERE leaderboard_id = '{$leaderboard_id}' AND game_id = {$game_id}")); $score = mysql_query("SELECT * FROM ava_highscores WHERE user = {$user['id']} AND game = {$game_id} AND leaderboard = '{$leaderboard_id}' ORDER BY score {$leaderboard['order_by']} LIMIT 1"); $highscore = mysql_fetch_array($score); } $already_challenged = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_messages WHERE highscore_game_id = {$highscore['game']}"), 0); if ($already_challenged == 0) { $game = mysql_fetch_array(mysql_query("SELECT * FROM ava_games WHERE id = {$game_id}")); $subject = CHALLENGE_PM_SUBJECT1 . " {$highscore['score']} " . CHALLENGE_PM_SUBJECT2 . " {$game['name']}"; $game_thumbnail = GameImageUrl($game['image'], $game['import'], $game['url']); $game_url = GameUrl($game['id'], $game['seo_url'], $game['category_id']); $get_to_user = mysql_query("SELECT * FROM ava_users WHERE id= {$friend_id}"); $to_user = mysql_fetch_array($get_to_user); $message = CHALLENGE_PM_GREETING1 . ' ' . $to_user['username'] . ', ' . $user['username'] . ' ' . CHALLENGE_PM_GREETING2 . ' <div class="challenge_pm_container"> <div class="challenge_pm_image"><img src="' . $game_thumbnail . '" width="80" height="80"/></div> <div class="challenge_pm_info"><b>' . GAME . '</b>: <a href="' . $game_url . '">' . $game['name'] . '</a><br /><b>' . LEADERBOARD . '</b>: ' . $leaderboard['leaderboard_name'] . '<br /><b>' . HIGHSCORE_SCORE . '</b>: ' . $highscore['score'] . '</div> </div>'; SendPM($subject, $message, $friend_id, $game['id']); mysql_query("UPDATE ava_users SET points = points + {$setting['points_challenge']} WHERE id = {$user['id']}"); $data = array('to_username' => $to_user['username'], 'email_address' => $to_user['email'], 'from_username' => $user['username'], 'from_avatar' => $user['avatar'], 'subject' => $user['username'] . ' ' . CHALLENGE_PM_GREETING2, 'send_email' => $to_user['email_new_message'], 'game_name' => $game['name'], 'game_url' => $game_url, 'game_image' => $game_thumbnail, 'leaderboard_name' => $leaderboard['leaderboard_name'], 'score' => $highscore['score']); SendEmail($data, 'highscore_challenge'); echo "({success: 1, message: '" . addslashes(N_POINTS_EARNED1) . " <span style=\"font-weight:bold;\">{$setting['points_challenge']} " . addslashes(N_POINTS_EARNED2) . "</span> " . addslashes(N_POINTS_EARNED_CHALLENGE) . "', points: {$setting['points_challenge']}})"; } else { echo "({success: 0, message: 'You have already challenged that friend'})";