<?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'})";
