include_once 'pager.php'; global $db, $globals; if (!isset($globals['link_id']) && !empty($_GET['id'])) { $globals['link_id'] = intval($_GET['id']); } if (!$globals['link_id'] > 0) { die; } if (!isset($_GET['p'])) { $favorites_page = 1; } else { $favorites_page = intval($_GET['p']); } $favorites_page_size = 20; $favorites_offset = ($favorites_page - 1) * $favorites_page_size; $favorites_users = $db->get_var("SELECT count(*) FROM favorites WHERE favorite_link_id=" . $globals['link_id']); $favorites = $db->get_results("SELECT favorite_user_id, user_avatar, user_login, date_format(favorite_date,'%d/%m %T') as date FROM favorites, users WHERE favorite_link_id=" . $globals['link_id'] . " AND user_id = favorite_user_id LIMIT {$favorites_offset},{$favorites_page_size}"); if (!$favorites) { return; } echo '<div class="voters-list">'; foreach ($favorites as $vote) { echo '<div class="item">'; echo '<a href="' . get_user_uri($vote->user_login, 'favorites') . '" title="' . $vote->date . '">'; echo '<img src="' . get_avatar_url($vote->favorite_user_id, $vote->user_avatar, 20) . '" width="20" height="20" alt="' . $vote->user_login . '"/>'; echo $vote->user_login . '</a>'; echo '</div>'; } echo "</div>\n"; do_contained_pages($globals['link_id'], $favorites_users, $favorites_page, $favorites_page_size, 'get_link_favorites.php', 'voters', 'voters-container');
} $votes_page_size = 40; $votes_offset = ($votes_page - 1) * $votes_page_size; $votes_users = $db->get_var("SELECT count(*) FROM league_votes WHERE match_id=" . $globals['match_id']); $sql = "SELECT \n league_votes.*, \n league_votes.date as vdate,\n user_avatar, \n score_visitor,\n score_local,\n m.date,\n user_login \nFROM \n league_votes, users, league_matches m\nWHERE \n m.id = {$globals['match_id']} \n AND m.id = match_id\n AND users.user_id = league_votes.user_id \nORDER BY league_votes.date DESC LIMIT {$votes_offset}, 40"; $votes = $db->get_results($sql); $globals['vote_values'] = array("empate", "al equipo local", "al equipo visitante"); if (!$votes) { return; } echo '<div class="game-voters-list">'; $win_class = ''; if (!empty($votes[0])) { if (strtotime($votes[0]->date) < time()) { $local = $votes[0]->score_local; $vis = $votes[0]->score_visitor; $win_class = $local == $vis ? 0 : ($local > $vis ? 1 : 2); } } foreach ($votes as $vote) { echo '<div class="item' . ($vote->value == $win_class ? ' winner' : '') . '">'; $vote_detail = _('votó') . " " . $globals['vote_values'][$vote->value]; $vote_detail .= ' ' . _('el') . date(" d-m-Y, H:i:s", strtotime($vote->vdate)); echo '<a href="' . get_user_uri($vote->user_login) . '" title="' . $vote_detail . '">'; echo '<img class="avatar" src="' . get_avatar_url($vote->user_id, $vote->user_avatar, 20) . '" width="20" height="20" alt=""/>'; echo $vote->user_login . '</a>'; echo '</div>'; } echo "</div>\n"; do_contained_pages($globals['match_id'], $votes_users, $votes_page, $votes_page_size, 'league_meneos.php', 'voters', 'voters-container-' . $globals['match_id']);
} $prefered_page_size = 20; $prefered_offset = ($prefered_page - 1) * $prefered_page_size; switch ($prefered_type) { case 'friends': $prefered_total = $db->get_var("SELECT count(*) FROM friends WHERE friend_type='affiliate' AND friend_from={$prefered_id} AND friend_to !=0"); $dbusers = $db->get_results("SELECT friend_to as who, friend_value FROM friends WHERE friend_type='affiliate' AND friend_from={$prefered_id} AND friend_to !=0 ORDER BY friend_value DESC LIMIT {$prefered_offset},{$prefered_page_size}"); break; case 'voters': $prefered_total = $db->get_var("SELECT count(*) FROM friends WHERE friend_type='affiliate' AND friend_to={$prefered_id} AND friend_from !=0"); $dbusers = $db->get_results("SELECT friend_from as who, friend_value FROM friends WHERE friend_type='affiliate' AND friend_to={$prefered_id} AND friend_from !=0 ORDER BY friend_value DESC LIMIT {$prefered_offset},{$prefered_page_size}"); break; } if ($dbusers) { $friend = new User(); echo '<div class="voters-list">'; foreach ($dbusers as $dbuser) { $friend->id = $dbuser->who; $value = $dbuser->friend_value * 100; $value = sprintf("%6.2f", $value); $friend->read(); echo '<div class="item">'; echo '<a href="' . get_user_uri($friend->username) . '" title="' . $value . ' %">'; echo '<img src="' . get_avatar_url($friend->id, $friend->avatar, 20) . '" width="20" height="20" alt="' . $friend->username . '"/>'; echo $friend->username . '</a>'; echo '</div>'; echo "\n"; } echo '</div>'; do_contained_pages($prefered_id, $prefered_total, $prefered_page, $prefered_page_size, 'get_prefered.php', $prefered_type, $prefered_type . '-container'); }
case 'ignored': if ($prefered_id != $current_user->user_id) { return; } $friend_value = 'AND friend_value < 0'; $prefered_total = $db->get_var("SELECT count(*) FROM friends WHERE friend_type='manual' AND friend_from={$prefered_id} {$friend_value}"); $dbusers = $db->get_results("SELECT friend_to as who, unix_timestamp(friend_date) as date FROM friends, users WHERE friend_type='manual' AND friend_from={$prefered_id} and user_id = friend_to {$friend_value} order by user_login asc LIMIT {$prefered_offset},{$prefered_page_size}"); break; } if ($dbusers) { $friend = new User(); foreach ($dbusers as $dbuser) { $friend->id = $dbuser->who; $friend->read(); $title = $friend->username; if ($dbuser->date > 0) { $title .= sprintf(' %s %s', _('desde'), get_date_time($dbuser->date)); } echo '<div class="friends-item">'; echo '<a href="' . get_user_uri($friend->username) . '" title="' . $title . '">'; echo '<img class="avatar" src="' . get_avatar_url($friend->id, $friend->avatar, 20) . '" width="20" height="20" alt="' . $friend->username . '"/>'; echo $friend->username . '</a> '; if ($current_user->user_id > 0 && $current_user->user_id != $friend->id) { echo '<a id="friend-' . $prefered_type . '-' . $current_user->user_id . '-' . $friend->id . '" href="javascript:get_votes(\'get_friend.php\',\'' . $current_user->user_id . '\',\'friend-' . $prefered_type . '-' . $current_user->user_id . '-' . $friend->id . '\',0,\'' . $friend->id . '\')">' . User::friend_teaser($current_user->user_id, $friend->id) . '</a>'; } echo '</div>'; } echo "<br clear='left'/>\n"; do_contained_pages($prefered_id, $prefered_total, $prefered_page, $prefered_page_size, 'get_friends_bars.php', $prefered_type, $prefered_type . '-container'); echo "<br clear='all'/>\n"; }
die; } echo '<div class="voters-list">'; foreach ($votes as $vote) { echo '<div class="item">'; $vote_detail = get_date_time($vote->ts); // If current users is a god, show the first IP addresses if ($current_user->user_level == 'god') { $vote_detail .= ' (' . preg_replace('/\\.[0-9]+$/', '', $vote->ip) . ')'; } if ($vote->vote_value > 0) { $vote_detail .= ' ' . _('valor') . ": {$vote->vote_value}"; echo '<a href="' . get_user_uri($vote->user_login) . '" title="' . $vote->user_login . ': ' . $vote_detail . '">'; echo '<img class="avatar" src="' . get_avatar_url($vote->vote_user_id, $vote->user_avatar, 20) . '" width="20" height="20" alt=""/>'; echo $vote->user_login . '</a>'; } else { if ($globals['show_negatives'] > 0 && $vote->ts > $globals['show_negatives']) { echo '<a href="' . get_user_uri($vote->user_login) . '" title="' . $vote->user_login . ': ' . $vote_detail . '">'; echo '<img src="' . get_avatar_url($vote->vote_user_id, $vote->user_avatar, 20) . '" width="20" height="20" alt=""/></a>'; echo '<span>' . get_negative_vote($vote->vote_value) . '</span>'; } else { echo '<span>'; echo '<img src="' . $globals['base_static'] . 'img/mnm/mnm-anonym-vote-01.png" width="20" height="20" alt="' . _('anónimo') . '" title="' . $vote_detail . '"/>'; echo get_negative_vote($vote->vote_value) . '</span>'; } } echo '</div>'; } echo "</div>\n"; do_contained_pages($globals['link_id'], $votes_users, $votes_page, $votes_page_size, 'meneos.php', 'voters', 'voters-container'); }
$votes_offset = ($votes_page - 1) * $votes_page_size; $comment = $db->get_row("select user_login as login, comment_votes, comment_karma, comment_user_id as author from users, comments where comment_id = {$id} and user_id = comment_user_id"); echo "\n" . '<script>$("#modalTitle").html("' . _('comentario') . ' #' . $id . ' (' . $comment->login . ')")</script>' . "\n"; echo '<div style="padding-top: 20px">'; $votes = $db->get_results("SELECT vote_user_id, vote_value, user_avatar, user_login, date_format(vote_date,'%d/%m-%T') as date, UNIX_TIMESTAMP(vote_date) as ts,inet_ntoa(vote_ip_int) as ip FROM votes, users WHERE vote_type='comments' and vote_link_id={$id} AND vote_user_id > 0 AND user_id = vote_user_id ORDER BY vote_date DESC LIMIT {$votes_offset},{$votes_page_size}"); if ($votes) { echo '<div class="voters-list">'; foreach ($votes as $vote) { if ($vote->vote_user_id == $comment->author) { continue; } echo '<div class="item">'; $vote_detail = "{$vote->date} karma: {$vote->vote_value}"; // If current users is a god, show the first IP addresses if ($current_user->user_level == 'god') { $vote_detail .= ' (' . preg_replace('/\\.[0-9]+$/', '', $vote->ip) . ')'; } if ($vote->vote_value < 0) { $style = 'style="color: #f00"'; } else { $style = ''; } echo '<a ' . $style . ' href="' . get_user_uri($vote->user_login) . '" title="' . $vote->user_login . ': ' . $vote_detail . '" target="_blank">'; echo '<img class="avatar" src="' . get_avatar_url($vote->vote_user_id, $vote->user_avatar, 20) . '" width="20" height="20" alt=""/>'; echo $vote->user_login . '</a>'; echo '</div>'; } echo "</div>\n"; } do_contained_pages($id, $comment->comment_votes, $votes_page, $votes_page_size, 'get_c_v.php', 'voters', 'modalContent'); echo '</div>';
$post = $db->get_row("select user_login as login, post_votes, post_karma, post_user_id as author from users, posts where post_id = {$id} and user_id = post_user_id"); echo '<div style="width:550px;padding: 5px 5px;text-align:left">'; echo '<div style="padding-top: 20px">'; $votes = $db->get_results("SELECT vote_user_id, vote_value, user_avatar, user_login, date_format(vote_date,'%d/%m-%T') as date, UNIX_TIMESTAMP(vote_date) as ts,inet_ntoa(vote_ip_int) as ip FROM votes, users WHERE vote_type='posts' and vote_link_id={$id} AND vote_user_id > 0 AND user_id = vote_user_id ORDER BY vote_date DESC LIMIT {$votes_offset},{$votes_page_size}"); if ($votes) { echo '<div class="voters-list">'; foreach ($votes as $vote) { if ($vote->vote_user_id == $post->author) { continue; } echo '<div class="item">'; $vote_detail = "{$vote->date} karma: {$vote->vote_value}"; // If current users is a god, show the first IP addresses if ($current_user->user_level == 'god') { $vote_detail .= ' (' . preg_replace('/\\.[0-9]+$/', '', $vote->ip) . ')'; } if ($vote->vote_value < 0) { $style = 'style="color: #f00"'; } else { $style = ''; } echo '<a ' . $style . ' href="' . get_user_uri($vote->user_login) . '" title="' . $vote->user_login . ': ' . $vote_detail . '" target="_blank">'; echo '<img class="avatar" src="' . get_avatar_url($vote->vote_user_id, $vote->user_avatar, 20) . '" width="20" height="20" alt=""/>'; echo $vote->user_login . '</a>'; echo '</div>'; } echo "</div>\n"; } do_contained_pages($id, $post->post_votes, $votes_page, $votes_page_size, 'get_p_v.php', 'voters'); echo '</div>'; echo '</div>';
$users_offset = ($users_page - 1) * $users_page_size; $from = "and clon_date > date_sub(now(), interval 30 day)"; $nclones = $db->get_var("select count(distinct user_id) from clones, users where clon_from = {$user_id} and user_id = clon_to {$from}"); $clones = $db->get_results("select distinct user_id, user_login, user_avatar from clones, users where clon_from = {$user_id} and user_id = clon_to {$from} order by clon_date desc limit {$users_offset},{$users_page_size}"); if (!$clones) { print _('no hay clones para este usuario'); die; } echo '<div style="width:550px;padding: 5px 5px;text-align:left">'; echo '<div style="padding-top: 20px">'; echo '<div class="voters-list">'; foreach ($clones as $clon) { $highlight = ''; $details = ''; $ips = $db->get_col("select distinct clon_ip from clones where clon_from = {$user_id} and clon_to = {$clon->user_id} {$from}"); foreach ($ips as $ip) { $details .= preg_replace('/\\.[0-9]+$/', '', $ip) . ', '; if (preg_match('/COOK:/', $ip)) { $highlight = 'style="color:#ff0000"'; } } echo '<div class="item" ' . $highlight . '>'; echo '<a ' . $highlight . ' href="' . get_user_uri($clon->user_login) . '/' . $clon->user_id . '" title="' . $details . '" target="_blank">'; echo '<img class="avatar" src="' . get_avatar_url($clon->user_id, $clon->user_avatar, 20) . '" width="20" height="20" alt=""/>'; echo $clon->user_login . '</a>'; echo '</div>'; } echo "</div>\n"; do_contained_pages($user_id, $nclones, $users_page, $users_page_size, 'ip_clones.php', 'voters'); echo '</div>'; echo '</div>';