$report_user = '******' . ProfileUrl($get_user['id'], $get_user['seo_url']) . '">' . $get_user['username'] . '</a>';
$user_id = $get_user['id'];
}
if ($report['type'] == 4) {
$get_post = mysql_fetch_array(mysql_query("SELECT * FROM ava_posts WHERE id=" . $report['link_id']));
$get_topic = mysql_fetch_array(mysql_query("SELECT * FROM ava_topics WHERE id=" . $get_post['topic']));
$name = '<a href="' . TopicUrl($get_topic['id'], $get_topic['seo_url'], $get_topic['forum_id'], 1) . '#' . $get_post['id'] . '"/>' . $get_topic['title'] . '</a>';
$get_post_user = mysql_fetch_array(mysql_query("SELECT * FROM ava_users WHERE id=" . $get_post['user_id']));
} elseif ($report['type'] == 1) {
$get_game = mysql_fetch_array(mysql_query("SELECT * FROM ava_games WHERE id=" . $report['link_id']));
$game_url = GameUrl($get_game['id'], $get_game['seo_url'], $get_game['category_id']);
} elseif ($report['type'] == 2 || $report['type'] == 3) {
if ($report['type'] == 2) {
$get_comment = mysql_fetch_array(mysql_query("SELECT * FROM ava_comments WHERE id=" . $report['link_id']));
$get_game = mysql_fetch_array(mysql_query("SELECT * FROM ava_games WHERE id=" . $get_comment['link_id']));
$name = '<a href="' . GameUrl($get_game['id'], $get_game['seo_url'], $get_game['category_id']) . '#comment' . $get_comment['id'] . '"/>' . $get_game['name'] . '</a>';
} else {
$get_comment = mysql_fetch_array(mysql_query("SELECT * FROM ava_news_comments WHERE id=" . $report['link_id']));
$get_news = mysql_fetch_array(mysql_query("SELECT * FROM ava_news WHERE id=" . $get_comment['link_id']));
$name = '<a href="' . NewsUrl($get_news['id'], $get_news['seo_url']) . '#comment' . $get_comment['id'] . '"/>' . $get_news['title'] . '</a>';
}
$get_comment_user = mysql_fetch_array(mysql_query("SELECT * FROM ava_users WHERE id=" . $get_comment['user']));
} elseif ($report['type'] == 5) {
$get_reported_user = mysql_fetch_array(mysql_query("SELECT * FROM ava_users WHERE id=" . $report['link_id']));
$reported_user_url = ProfileUrl($get_reported_user['id'], $get_reported_user['seo_url']);
} elseif ($report['type'] == 6) {
$get_pm = mysql_fetch_array(mysql_query("SELECT * FROM ava_messages WHERE id=" . $report['link_id']));
$get_pm_user = mysql_fetch_array(mysql_query("SELECT * FROM ava_users WHERE id=" . $get_pm['sender_id']));
}
include 'report_item.php';
}
font-family:Verdana, Geneva, sans-serif;
}
.site_name a {
color:#FFF;
}
.site_name a:visited {
color:#FFF;
}
-->
</style>
</head>
<?php
require_once '../../config.php';
include '../../includes/core.php';
include '../../language/' . $setting['language'] . '.php';
$id = intval($_GET['id']);
$sql = mysql_query("SELECT * FROM ava_games WHERE id='" . $id . "'") or die(mysql_error());
$row = mysql_fetch_assoc($sql);
$url = GameUrl($id, $row['seo_url'], $row['category_id']);
?>
<body>
<p class="site_name"><?php
echo $setting['site_name'];
?>
| <a target="_parent" href="<?php
echo $url;
?>
">< Return to game page</a></p>
</body>
</html>
$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>';
}
if (!isset($_GET['page'])) {
$page = 1;
} else {
if ($_GET['page'] == '') {
$page = 1;
} else {
$page = $_GET['page'];
}
}
$max_results = 30;
$from = $page * $max_results - $max_results;
$query = mysql_query("SELECT * FROM ava_leaderboards LIMIT {$from}, {$max_results}");
while ($go = mysql_fetch_array($query)) {
$lb_game = mysql_fetch_array(mysql_query("SELECT * FROM ava_games WHERE id= {$go['game_id']}"));
$score_count = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_highscores WHERE game = {$go['game_id']} AND leaderboard = '{$go['leaderboard_id']}'"), 0);
$url = GameUrl($lb_game['id'], $lb_game['seo_url'], $lb_game['category_id']);
echo '
<div id="leaderboard-' . $go['id'] . '" class="manage_item"><div class="manage_column0">' . $go['id'] . '</div><div id="tgame_name' . $go['id'] . '" class="manage_lb_column_gamename"><a href="' . $url . '" class="manage_link">' . $lb_game['name'] . '</a></div><div id="tcategory_name' . $go['id'] . '" class="manage_lb_column2">' . $go['leaderboard_name'] . '</div>
<div id="tdate' . $go['id'] . '" class="manage_lb_column_date">' . $score_count . '</div>
<div class="manage_column3" id="edit-image-' . $go['id'] . '"><img src="images/edit.png" width="24" height="24" onclick="gotourl(\'?task=manage_highscores&id=' . $go['game_id'] . '#page=1&leaderboard=' . $go['leaderboard_id'] . '&game=' . $go['game_id'] . '\')"></div>
<div class="manage_column3" id="delete-image-' . $go['id'] . '"><img src="images/delete.png" width="24" height="24" onclick="DeleteAsk(' . $go['id'] . ');"></div>';
echo '<div id="edit-leaderboard-' . $go['id'] . '" class="edit_game_container"></div>
</div>';
}
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_leaderboards"), 0);
$total_pages = ceil($total_results / $max_results);
echo '<form id="form1" name="form1" method="get" action="manage_games_ajax.php">';
if ($total_pages > 1) {
echo '<label>
<select name="page" id="page"';
<?php
defined('AVARCADE_') or die('');
$comment = array();
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_comments WHERE user='******'"), 0);
if ($total_results <= 0) {
echo "{$profile['name']} " . PROFILE_NO_COMMENTS;
} else {
if ($_GET['task'] == 'profile') {
$sql = mysql_query("SELECT * FROM ava_comments WHERE user="******" ORDER BY id DESC LIMIT 8");
} else {
$sql = mysql_query("SELECT * FROM ava_comments WHERE user="******" ORDER BY id DESC");
}
while ($row = mysql_fetch_array($sql)) {
$game_exists = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_games WHERE id={$row['link_id']}"), 0);
if ($game_exists == 1) {
$sql2 = mysql_query("SELECT * FROM ava_games WHERE id=" . $row['link_id'] . " LIMIT 1");
$row2 = mysql_fetch_array($sql2);
$comment['the_comment'] = nl2br(htmlspecialchars($row['comment']));
$comment['game_name'] = $row2['name'];
$comment['game_url'] = GameUrl($row2['id'], $row2['seo_url'], $row2['category_id']);
if ($user['admin'] == 1) {
$comment['admin_options'] = ' <a href=' . $setting['site_url'] . '/admin/index.php?action=delete_comment&id=' . $row['id'] . '&link_id=' . $row2['id'] . '><img src="' . $setting['site_url'] . '/admin/delete.png" align="absmiddle" /></a>';
}
include '.' . $setting['template_url'] . '/' . $template['users_comments'];
}
}
}
echo ' - ' . PAGE . ' ' . $page;
}
echo ' - ';
} elseif (isset($_GET['task']) && isset($page) && $page > 1 && $_GET['task'] != 'view_page') {
include './includes/modules/content_title.php';
echo ' - ' . PAGE . ' ' . $page . " - ";
} elseif (isset($_GET['task'])) {
include './includes/modules/content_title.php';
echo ' - ';
}
echo $setting['site_name'] . '</title>';
if (isset($_GET['task']) && $_GET['task'] == 'view') {
echo '<meta name="description" content="' . shortenStr(strip_tags($game['description']), 157) . '" />
<meta name="keywords" content="' . $game_keywords . '" />
<meta property="og:image" content="' . $game['image_url'] . '" />';
$can_url = GameUrl($game['id'], $game['seo_url'], $game['category']);
echo '<link rel="canonical" href="' . $can_url . '" />';
} else {
if (isset($_GET['task']) && $_GET['task'] == 'category') {
$page_info = '';
$sort_info = '';
if (isset($page) && $page > 1) {
$page_info = PAGE . ' ' . $page . ' - ';
}
if (isset($_GET['sortby'])) {
$sort = secure($_GET['sortby']);
$sort_info = $sort_options[$sort] . ' - ';
}
echo '<meta name="description" content="' . $cat_info['name'] . ' ' . $sort_info . $page_info . shortenStr(strip_tags($cat_info['description']), 157) . '" />
<meta name="keywords" content="' . $cat_info['keywords'] . '" />';
} else {
<!--
Social buttons for AV Arcade
Icon images copyright komodomedia.com
-->
<?php
$long_url = htmlspecialchars(GameUrl($game['id'], $game['seo_url'], $row2['category_id']));
$short_url = htmlspecialchars(ShortUrl($game['id']));
?>
<div class="social_icons">
<div class="social_text">
<?php
if (defined("SHARE_INFO")) {
echo SHARE_INFO;
$share_message = SHARE_MESSAGE;
$your_url_title = YOUR_URL_TITLE;
} else {
echo 'Share on social sites and earn points';
$share_message = 'I have been playing this great game';
$your_url_title = 'Your unique referral url';
}
?>
</div>
<!- Twitter ->
<a href="http://twitter.com/home?status=<?php
echo $share_message;
?>
: <?php
echo $short_url;
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;
}
<?php
if (!defined('AVARCADE_')) {
include '../../config.php';
include '../core.php';
}
$cat_numb = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_games WHERE published=1"), 0);
if (isset($_POST["lastid"]) && $_POST["lastid"] != "0") {
if ($cat_numb > 0) {
$lastid = $_POST["lastid"];
$sort = 'id DESC';
$sql = mysql_query("SELECT * FROM ava_games WHERE id < {$lastid} AND published=1 ORDER BY {$sort} LIMIT 30");
$row = mysql_fetch_array($sql);
while ($row = mysql_fetch_array($sql)) {
$gameurl = GameUrl($row['id'], $row['seo_url'], $row['category_id']);
$image_url = GameImageUrl($row['image'], $row['import'], $row['url']);
//$size = getimagesize($image_url);
?>
<div class="post" id="<?php
echo $row['id'];
?>
" style="margin-left: 0px;">
<a href="<?php
echo $gameurl;
?>
">
<img src="<?php
echo $setting['site_url'] . $setting['template_url'];
?>
/images/samples/dragon_age_legends_remix_01_1379835624_image_lx.png" width="133" height="148" alt="<?php
}
$name = escape($_POST['game_name']);
$category = mysql_fetch_array(mysql_query("SELECT parent_id FROM ava_cats WHERE id = {$_POST['game_category']}"));
// If the id is 0 that means we are adding a new game instead of editing
if ($_POST['id'] == 0) {
$date = date("Y-m-d H:i:s");
$seo_url = create_seoname($name, 0, 'game');
mysql_query("INSERT INTO ava_games (name, description, url, category_id, category_parent, width, height, image, published, filetype, instructions, date_added, advert_id, highscores, mochi_id, seo_url, submitter, html_code)\n\tVALUES ('" . escape($_POST['game_name']) . "', '" . escape($_POST['game_description']) . "', '{$url}', {$_POST['game_category']}, {$category['parent_id']}, '{$_POST['width']}', '{$_POST['height']}', '{$img}', {$_POST['published']}, '{$ext}', '" . escape($_POST['game_instructions']) . "', '{$date}', {$_POST['game_advert']}, {$_POST['highscores']}, '{$_POST['mochi_id']}', '{$seo_url}', '{$_POST['submitter']}', '{$code}')") or die('There was a MySql error when adding the game: ' . mysql_error());
$newid = mysql_insert_id();
$category = mysql_query("SELECT * FROM ava_cats WHERE id=" . $_POST['game_category'] . "");
$category = mysql_fetch_array($category);
if (isset($_POST['homepage'])) {
echo 'Game added successfully';
} else {
// Send back the newly added game container if not submitted from homepage
$url = GameUrl($newid, $seo_url, $category['id']);
echo '
<div id="game-' . $newid . '" class="manage_item_new"><div class="manage_column0">' . $newid . '</div><div id="tgame_name' . $newid . '" class="' . $link_class . '"><a href="' . $url . '" class="manage_link">' . stripslashes($_POST['game_name']) . '</a></div><div id="tcategory_name' . $newid . '" class="manage_column2">' . $category['name'] . '</div><div class="manage_column3" id="edit-image-' . $newid . '"><img src="images/edit.png" width="24" height="24" onclick="edit_game(' . $newid . ');"></div><div class="manage_column3" id="delete-image-' . $newid . '"><img src="images/delete.png" width="24" height="24" onclick="DeleteAsk(' . $newid . ');"></div><div class="manage_column3" id="feature_icon' . $newid . '"><img src="images/feature.png" width="24" height="24" onclick="FeatureGame(' . $newid . ', 1);"></div>';
if ($_POST['published'] == 1) {
echo '<div class="manage_column3" id="published-image-' . $newid . '"><img src="images/published.png" width="24" height="24" onclick="TogglePublished(' . $newid . ', 0);"></div>';
} else {
echo '<div class="manage_column3" id="published-image-' . $newid . '"><img src="images/unpublished.png" width="24" height="24" onclick="TogglePublished(' . $newid . ', 1);"></div>';
}
echo '<div class="manage_column4" id="comments-image-' . $newid . '"><img src="images/comments.gif" width="24" height="24" onclick="gotourl(\'index.php?task=manage_comments#page=1&id=' . $newid . '\')"></div>';
if ($_POST['highscores'] == 1) {
echo '<div class="manage_column3" id="delete-image-' . $newid . '"><img src="images/highscores.png" width="22" height="23" onclick="gotourl(\'?task=manage_highscores&id=' . $newid . '#page=1&leaderboard=default&game=' . $newid . '\')"></div>';
}
echo '<div id="edit-game-' . $newid . '" class="edit_game_container"></div></div>';
}
} else {
$seo_url = create_seoname($name, $_POST['id'], 'game');
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'})";
}
