$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>';