$ct = 0;
$sql = mysql_query("SELECT * FROM ava_users WHERE id != '1' ORDER BY 0+points desc LIMIT 5");
while ($row = mysql_fetch_array($sql)) {
$ct = $ct + 1;
$seo_name = seoname($row['username']);
if (strlen($row['username']) > $template['player_module_max_chars']) {
$name = substr($row['username'], 0, $template['player_module_max_chars']);
//."...";
} else {
$name = $row['username'];
}
$username = htmlspecialchars($name);
$avatar = 'uploads/avatars/' . $row['avatar'] . '';
if ($setting['module_thumbs'] == 1) {
$avatar = '<img class="sidebar_memberIMG" src="' . AvatarUrl($row['avatar'], $row['facebook'], $row['facebook_id']) . '" />';
} else {
$avatar = '';
}
if ($setting['seo_on'] == 0) {
$url = 'index.php?task=profile&id=' . $row['id'];
} else {
$url = $setting['site_url'] . '/profile/' . $row['id'] . '/' . $seo_name . $setting['seo_extension'];
}
//show trophy for the top 3 players of the site and numbers for the 4th to the 10th.
if ($ct == 1) {
//first position
echo '<li class="top_medals"><a href="' . $url . '">' . $avatar . '</a>';
echo '<div class="medalbox"><img class="medal_gold" src="' . $setting['site_url'] . '/templates/macaw/images/medal_gold.png" alt="" /></div>';
echo '<a href="' . $url . '">' . $username . '</a><br />';
} else {
if ($_POST['type'] == 'send_request') {
$request_exists = mysql_query("SELECT * FROM tbl_friend_requests WHERE (from_user = {$friend} AND to_user = {$xuserid}) OR (from_user = {$xuserid} AND to_user = {$friend})");
$already_friends = mysql_query("SELECT * FROM tbl_friends WHERE user1 = {$friend} AND user2 = {$xuserid}");
if (mysql_num_rows($request_exists)) {
$_POST['type'] = 'accept_request';
}
if (!mysql_num_rows($request_exists) && !mysql_num_rows($already_friends)) {
mysql_query("INSERT INTO tbl_friend_requests SET from_user = {$xuserid}, to_user = {$friend}");
mysql_query("UPDATE tbl_users SET friend_requests = friend_requests + 1 WHERE id = {$friend}");
$user_data = mysql_query("SELECT * FROM tbl_users WHERE id = {$friend} OR id = {$xuserid}");
while ($user = mysql_fetch_array($user_data)) {
if ($user['id'] == $friend) {
$to_data = array('email_address' => $user['email'], 'to_username' => $user['username'], 'send_email' => $user['email_friend_request']);
} else {
$from_data = array('from_username' => $user['username'], 'from_join_date' => $user['joined'], 'from_location' => $user['location']);
$from_data['from_avatar'] = AvatarUrl($user['avatar'], $user['facebook'], $user['facebook_id']);
}
}
$data = $to_data + $from_data;
$data['subject'] = EMAIL_FR_HEADING;
if ($setting['seo_on'] != 0) {
$data['accept_link'] = $setting['site_url'] . '/friends';
} else {
$data['accept_link'] = $setting['site_url'] . '/?task=friends';
}
SendEmail($data, 'friend_request');
}
}
}
}
// Accept friend request
$query = mysql_query("SELECT ava_users.*, ava_highscores.score, ava_highscores.date, ava_highscores.id as score_id \n\t\t\tFROM ava_users\n\t\t\tLEFT JOIN ava_friends\n\t\t\tON ava_users.id = ava_friends.user1 AND ava_friends.user2 = {$user_id}\n\t\t\tRIGHT JOIN ava_highscores\n\t\t\tON ava_highscores.user = ava_users.id\n\t\t\tWHERE game = {$id} AND leaderboard = '{$get_leaderboard['leaderboard_id']}' AND (user2 = {$user_id} OR ava_users.id = {$user_id})\n\t\t\tORDER BY score {$get_leaderboard['order_by']} LIMIT {$from}, {$max_results}") or die(mysql_error());
} else {
$query = mysql_query("SELECT ava_users.*, ava_highscores.score, ava_highscores.date, ava_highscores.id as score_id \n\t\t\tFROM ava_highscores \n\t\t\tLEFT JOIN ava_users\n\t\t\tON ava_users.id = ava_highscores.user\n\t\t\tWHERE game = {$id} AND leaderboard = '{$get_leaderboard['leaderboard_id']}'\n\t\t\tORDER BY score {$get_leaderboard['order_by']} LIMIT {$from}, {$max_results}");
}
echo '<ul class="game_highscore_list">
<li>
<div id="game_highscore_header">
<div class="game_highscore_name">' . HIGHSCORE_USER . '</div>
<div class="game_highscore_score">' . $get_leaderboard['label'] . '</div>
<div class="game_highscore_date">' . HIGHSCORE_DATE . '</div>
</div>
</li>';
while ($highscore = mysql_fetch_array($query)) {
$date = FormatDate($highscore['date'], 'short');
$profile_url = ProfileUrl($highscore['id'], $highscore['seo_url']);
$avatar_url = AvatarUrl($highscore['avatar'], $highscore['facebook'], $highscore['facebook_id']);
echo '<li>
<div class="game_highscore_container" id="game_highscore' . $highscore['score_id'] . '">
<div class="game_highscore_avatar">
<a href="' . $profile_url . '"><img src="' . $avatar_url . '" width="30" height="30"/></a>
</div>
<div class="game_highscore_name"><a href="' . $profile_url . '">' . $highscore['username'] . '</a></div>
<div class="game_highscore_score">' . $highscore['score'];
if ($user['admin'] == 1) {
echo ' <img src="' . $setting['site_url'] . '/images/smallx.png" title="Delete score" onclick="DeleteHighscore(' . $highscore['score_id'] . ', \'' . $setting['site_url'] . '\');"/>';
}
echo '</div>
<div class="game_highscore_date">' . $date . '</div>
</div>
</li>';
}
if (mysql_num_rows($requests_q)) {
echo '<div class="friend_requests_header">Friend Requests</div> <div class="friend_requests_container">';
while ($friend = mysql_fetch_array($requests_q)) {
$friend['url'] = ProfileUrl($friend['id'], $friend['seo_url']);
$friend['avatar_url'] = AvatarUrl($friend['avatar'], $friend['facebook'], $friend['facebook_id']);
$friend['last_activity'] = FormatDate($friend['last_activity'], 'time');
$friend['buttons'] = '<a href="#" onclick="ManageFriend(' . $friend['id'] . ', \'accept_request\', \'friends_page\');return false"><img src="images/add_friend.png" /></a>
<a href="#" onclick="ManageFriend(' . $friend['id'] . ', \'delete_request\', \'friends_page\');return false"><img src="images/delete_friend.png" /></a>';
include '.' . $setting['template_url'] . '/' . $template['friend'];
}
echo '</div>';
}
echo '<div class="friends_header">Friends</div> <div class="friends_container">';
// Mutual friends
$friends_q = mysql_query("SELECT ava_users.*\n\tFROM ava_friends\n\tLEFT JOIN ava_users \n\tON ava_friends.user2 = ava_users.id\n\tWHERE ava_friends.user1 = {$user['id']}");
if (mysql_num_rows($friends_q)) {
while ($friend = mysql_fetch_array($friends_q)) {
$friend['url'] = ProfileUrl($friend['id'], $friend['seo_url']);
$friend['avatar_url'] = AvatarUrl($friend['avatar'], $friend['facebook'], $friend['facebook_id']);
$friend['last_activity'] = FormatDate($friend['last_activity'], 'time');
$friend['buttons'] = '<a href="index.php?task=send_message&id=' . $friend['id'] . '"><img src="images/friend_message.png" /></a>
<a href="#" onclick="ManageFriend(' . $friend['id'] . ', \'delete_friend\', \'friends_page\');return false"><img src="images/delete_friend.png" /></a>';
include '.' . $setting['template_url'] . '/' . $template['friend'];
}
} else {
echo '<div class="no_friends">' . NO_FRIENDS . '</div>';
}
echo '</div>';
} else {
echo FRIENDS_LOGIN;
}
<?php
echo '<ul>';
$sql = mysql_query("SELECT * FROM ava_users ORDER BY 0+points desc LIMIT 10");
while ($row = mysql_fetch_array($sql)) {
$name = shortenStr($row['username'], $template['module_max_chars']);
$username = htmlspecialchars($name);
$url = ProfileUrl($row['id'], $row['seo_url']);
if ($setting['module_thumbs'] == 1) {
$avatar = '<img src="' . AvatarUrl($row['avatar'], $row['facebook'], $row['facebook_id']) . '" width="25" height="25" style="vertical-align: middle;" alt="' . $username . '" />';
} else {
$avatar = '';
}
echo '<li>' . $avatar . ' <a href="' . $url . '">' . $username . '</a>';
if ($row['points'] != '') {
echo ' (' . $row['points'] . ' ' . POINTS . ')';
} else {
echo ' (0 ' . POINTS . ')';
}
echo '</li>';
}
echo '</ul>';
