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