/**
* return "OK" only delete
* > 0 - usual behavior: first delete then insert
* 0 error
*/
function insert_vote($value = 0) {
global $current_user, $db;
if (!$value) $value = $current_user->user_karma;
$vote = new Vote('comments', $this->id, $current_user->user_id);
$result = 'CREATE'; // vote doesn't exits?
if ($old_value = $vote->exists(false)) { // save old vote value
$result = 'REPLACE';
$vote->delete_comment_vote($old_value); // always destroy current vote
// check if they have the same sign
if ($value * $old_value > 0) {
return Array('DELETE',$old_value); // equal => only delete
}
}
// Affinity
if ($current_user->user_id != $this->author
&& ($affinity = User::get_affinity($this->author, $current_user->user_id)) ) {
if ($value < -1 && $affinity < 0) {
$value = round(min(-1, $value * abs($affinity/100)));
} elseif ($value > 1 && $affinity > 0) {
$value = round(max($value * $affinity/100, 1));
}
}
$value>0?$svalue='+'.$value:$svalue=$value;
$vote->value = $value;
$db->transaction();
if($vote->insert()) {
if ($current_user->user_id != $this->author) {
//echo "update comments set comment_votes=comment_votes+1, comment_karma=comment_karma$svalue, comment_date=comment_date where comment_id=$this->id";
$db->query("update comments set comment_votes=comment_votes+1, comment_karma=comment_karma$svalue, comment_date=comment_date where comment_id=$this->id");
}
} else {
$vote->value = false;
}
$db->commit();
if ($result == 'CREATE') {
return Array($result, $vote->value);
} else { // replace
return Array($result, $old_value);
}
}
function do_profile() {
global $user, $current_user, $login, $db, $globals;
$options = array();
$options[$user->username] = get_user_uri($user->username);
$options[_('categorías personalizadas')] = get_user_uri($user->username, 'categories');
if ($current_user->user_id == $user->id || $current_user->user_level == 'god') {
$options[_('modificar perfil').' →'] = $globals['base_url'].'profile.php?login='******'rss2.php?sent_by='.$user->id, _('envíos en rss2'));
if(!empty($user->url)) {
if ($user->karma < 10) $nofollow = 'rel="nofollow"';
if (!preg_match('/^http/', $user->url)) $url = 'http://'.$user->url;
else $url = $user->url;
}
// Print last user's note
$post = new Post;
if ($post->read_last($user->id)) {
echo '<div id="addpost"></div>';
echo '<ol class="comments-list" id="last_post">';
echo '<li>';
$post->print_summary();
echo '</li>';
echo "</ol>\n";
}
echo '<fieldset><legend>';
echo _('información personal');
echo '</legend>';
// Avatar
echo '<div style="float:right;text-align:center">';
echo '<img id="avatar" class="avatar" src="'.get_avatar_url($user->id, $user->avatar, 80).'" width="80" height="80" alt="'.$user->username.'" title="avatar" />';
// Print the button and associated div to change the avatar
if ($current_user->user_id == $user->id) {
echo '<div id="avatar_indicator" style="margin:0;padding:0;height:12px"></div>';
echo '<button id="avatar_upload" style="margin:0" title="'._('imagen cuadrada de no más de 400 KB, sin transparencias').'">'._('cambiar avatar').'</button>'."\n";
@include(mnminclude.'foreign/avatar_upload.html');
}
echo '</div>';
// Geo div
echo '<div style="width:140px; float:left;">';
if($globals['do_geo']) {
echo '<div id="map" class="thumbnail" style="width:130px; height:130px; overflow:hidden; float:left"></div>';
if ($current_user->user_id > 0 && $current_user->user_id != $user->id && $globals['latlng'] && ($my_latlng = geo_latlng('user', $current_user->user_id))) {
$distance = (int) geo_distance($my_latlng, $globals['latlng']);
echo '<p style="color: #FF9400; font-size: 90%">'."$user->username "._('está a')." <strong>$distance kms</strong></p>";
}
}
echo ' </div>';
echo '<div style="float:left;min-width:65%">';
echo '<dl>';
if(!empty($user->username)) {
echo '<dt>'._('usuario').':</dt><dd>';
if (!empty($url)) {
echo '<a href="'.$url.'" '.$nofollow.'>'.$user->username.'</a>';
} else {
echo $user->username;
}
$user->print_medals();
$clones_from = "and clon_date > date_sub(now(), interval 30 day)";
if ($current_user->admin &&
($nclones = $db->get_var("select count(distinct clon_to) from clones where clon_from = $user->id $clones_from")) > 0 ) {
echo ' (<a href="javascript:modal_from_ajax(\''.$globals['base_url'].'backend/ip_clones.php?id='.
$user->id.'\', \''. _('clones por IP'). '\')" title="'._('clones').'">'._('clones').'</a><sup>'.$nclones.'</sup>) ';
}
// Print friend icon
if ($current_user->user_id > 0 && $current_user->user_id != $user->id) {
echo ' <a id="friend-'.$current_user->user_id.'-'.$user->id.'" href="javascript:get_votes(\'get_friend.php\',\''.$current_user->user_id.'\',\'friend-'.$current_user->user_id.'-'.$user->id.'\',0,\''.$user->id.'\')">'.User::friend_teaser($current_user->user_id, $user->id).'</a>';
}
// Print user detailed info
if ($user->id==$current_user->user_id || $current_user->admin) {
echo " (" . _('id'). ": <em>$user->id</em>, ";
echo "<em>$user->level</em>)";
}
if($current_user->user_level=='god') {
echo " (<em>$user->username_register</em>)";
}
echo '</dd>';
}
if(!empty($user->names)) {
echo '<dt>'._('nombre').':</dt><dd>'.$user->names.'</dd>';
}
// Show public info is it's a friend or god
if($current_user->user_id > 0 && !empty($user->public_info) && (
$current_user->user_id == $user->id
|| $current_user->user_level=='god'
/*|| friend_exists($user->id, $current_user->user_id)*/ )) { //friends cannot see the IM address (it was public before)
echo '<dt>'._('IM/email').':</dt><dd> '.$user->public_info.'</dd>';
}
if(!empty($url)) {
echo '<dt>'._('sitio web').':</dt><dd><a href="'.$url.'" '.$nofollow.'>'.$url.'</a></dd>';
}
echo '<dt>'._('desde').':</dt><dd>'.get_date_time($user->date).'</dd>';
if($current_user->user_level=='god') {
echo '<dt>'._('email').':</dt><dd>'.$user->email. " (<em>$user->email_register</em>)</dd>";
}
if ($user->id == $current_user->user_id || $current_user->user_level=='god' ) {
echo '<dt>'._('clave API').':</dt><dd id="api-key"><a href="javascript:get_votes(\'get_user_api_key.php\',\'\',\'api-key\',0,\''.$user->id.'\')">'._('leer clave API').'</a> ('._('no la divulgues').')</dd>';
if(!empty($user->adcode)) {
echo '<dt>'._('Código AdSense').':</dt><dd>'.$user->adcode.' </dd>';
echo '<dt>'._('Canal AdSense').':</dt><dd>'.$user->adchannel.' </dd>';
}
}
echo '<dt>'._('karma').':</dt><dd>'.$user->karma;
// Karma details
if ($user->id == $current_user->user_id || $current_user->user_level=='god' ) {
echo ' (<a href="javascript:modal_from_ajax(\''.$globals['base_url'].'backend/get_karma_numbers.php?id='.$user->id.'\', \''.
_('cálculo del karma').
'\')" title="'._('detalles').'">'._('detalle cálculo').'</a>)';
}
echo '</dd>';
echo '<dt>'._('ranking').':</dt><dd>#'.$user->ranking().'</dd>';
$user->all_stats();
echo '<dt>'._('noticias enviadas').':</dt><dd>'.$user->total_links.'</dd>';
if ($user->total_links > 0 && $user->published_links > 0) {
$percent = intval($user->published_links/$user->total_links*100);
} else {
$percent = 0;
}
if ($user->total_links > 1) {
$entropy = intval(($user->blogs() - 1) / ($user->total_links - 1) * 100);
echo '<dt><em>'._('entropía').'</em>:</dt><dd>'.$entropy.'%</dd>';
}
echo '<dt>'._('noticias publicadas').':</dt><dd>'.$user->published_links.' ('.$percent.'%)</dd>';
echo '<dt>'._('comentarios').':</dt><dd>'.$user->total_comments.'</dd>';
echo '<dt>'._('notas').':</dt><dd>'.$user->total_posts.'</dd>';
echo '<dt>'._('número de votos').':</dt><dd>'.$user->total_votes.'</dd>';
// Print affinity to this user
if ($current_user->user_id && ($aff_to = User::get_affinity($user->id, $current_user->user_id))) {
$aff_to = round($aff_to/100, 2);
echo '<dt><strong>'._('afinidad con este usuario').'</strong>:</dt><dd>'.$aff_to .'</dd>';
}
echo '</dl>';
if ($user->id == $current_user->user_id) {
echo '<div style="margin-top: 20px" align="center">';
print_oauth_icons($_REQUEST['return']);
echo '</div>'."\n";
}
echo '</div>';
echo '</fieldset>';
// Print GEO form
if($globals['do_geo'] && $current_user->user_id == $user->id) {
echo '<div class="geoform">';
geo_coder_print_form('user', $current_user->user_id, $globals['latlng'], _('ubícate en el mapa (si te apetece)'), 'user');
echo '</div>';
}
// Print a chart of the last 30 days activity
if ($user->total_votes > 20 && ($current_user->user_id == $user->id || $current_user->admin)) {
echo '<fieldset><legend>'._('votos/hora últimos 30 días').'</legend>';
// Call to generate HMTL and javascript for the Flot chart
echo '<script src="'.$globals['base_static'].'js/jquery.flot.min.js" type="text/javascript"></script>'."\n";
//echo '<div id="flot" style="width:600px;height:150px;"></div>'."\n";
echo '<div id="flot" style="width:100%;height:150px;"></div>'."\n";
@include (mnminclude.'foreign/chart_user_votes_history.js');
echo '</fieldset>';
}
// Show first numbers of the address if the user has god privileges
if ($current_user->user_level == 'god' && ! $user->admin ) { // gods and admins know each other for sure, keep privacy
$addresses = $db->get_results("select INET_NTOA(vote_ip_int) as ip from votes where vote_type='links' and vote_user_id = $user->id order by vote_date desc limit 30");
// Try with comments
if (! $addresses) {
$addresses = $db->get_results("select comment_ip as ip from comments where comment_user_id = $user->id and comment_date > date_sub(now(), interval 30 day) order by comment_date desc limit 30");
}
if (! $addresses) {
// Use register IP
$addresses = $db->get_results("select user_ip as ip from users where user_id = $user->id");
}
// Not addresses to show
if (! $addresses) {
return;
}
$clone_counter = 0;
echo '<fieldset><legend>'._('últimas direcciones IP').'</legend>';
$prev_address = '';
foreach ($addresses as $dbaddress) {
$ip_pattern = preg_replace('/\.[0-9]+$/', '', $dbaddress->ip);
if($ip_pattern != $prev_address) {
echo '<p>'. $ip_pattern . '</p>';
$clone_counter++;
$prev_address = $ip_pattern;
if ($clone_counter >= 30) break;
}
}
echo '</fieldset>';
}
}
function calculate_karma() {
global $db, $globals;
require_once(mnminclude.'log.php');
require_once(mnminclude.'ban.php');
$this->old_karma = round($this->karma);
if (! $globals['users_karma_avg'] ) {
$globals['users_karma_avg'] = (float) $db->get_var("select SQL_NO_CACHE avg(link_votes_avg) from links where link_status = 'published' and link_date > date_sub(now(), interval 72 hour)");
}
$this->annotation = '';
// Read the stored affinity for the author
$affinity = User::get_affinity($this->author);
// high =~ users with higher karma greater than average
// low =~ users with higher karma less-equal than average
$votes_pos = $votes_neg = $karma_pos_user_high = $karma_pos_user_low = $karma_neg_user = 0;
$db->transaction();
$votes_pos_anon = intval($db->get_var("select SQL_NO_CACHE count(*) from votes where vote_type='links' AND vote_link_id=$this->id and vote_user_id = 0 and vote_value > 0"));
$votes = $db->get_results("select SQL_NO_CACHE user_id, vote_value, user_karma from votes, users where vote_type='links' AND vote_link_id=$this->id and vote_user_id > 0 and vote_user_id = user_id and user_level !='disabled'");
$n = $vlow = $vhigh = 0;
foreach ($votes as $vote) {
if ($vote->vote_value > 0) {
$votes_pos++;
if ($affinity && $affinity[$vote->user_id] > 0) {
$n++;
// Change vote_value if there is affinity
//echo "$vote->vote_value -> ";
$vote->vote_value = max($vote->user_karma * $affinity[$vote->user_id]/100, 6);
//echo "$vote->vote_value ($this->author -> $vote->user_id)\n";
}
if ($vote->vote_value >= $globals['users_karma_avg']) {
$karma_pos_user_high += $vote->vote_value;
$vhigh++;
} else {
$karma_pos_user_low += $vote->vote_value;
$vlow++;
}
} else {
$votes_neg++;
if ($affinity && $affinity[$vote->user_id] < 0) {
$karma_neg_user += min(-6, $vote->user_karma * $affinity[$vote->user_id]/100);
//echo "Negativo: " . min(-5, $vote->user_karma * $affinity[$vote->user_id]/100) . "$vote->user_id\n";
} else {
$karma_neg_user -= $vote->user_karma;
}
}
}
if ($n > $votes_pos/5) {
$perc = intval($n/$votes_pos * 100);
$this->annotation .= $perc. _('% de votos con afinidad elevada'). "<br/>";
}
$karma_pos_ano = intval($db->get_var("select SQL_NO_CACHE sum(vote_value) from votes where vote_type='links' AND vote_link_id=$this->id and vote_user_id = 0 and vote_value > 0"));
$db->commit();
if ($this->votes != $votes_pos || $this->anonymous != $votes_pos_anon || $this->negatives != $votes_neg) {
$this->votes = $votes_pos;
$this->anonymous = $votes_pos_anon;
$this->negatives = $votes_neg;
}
// Make sure we don't deviate too much from the average (it avoids vote spams and abuses)
// Allowed difference up to 3%$karma_pos_user_high
if ($karma_pos_user_low/$karma_pos_user_high > 1.15) {
$perc = intval($vlow/($vlow+$vhigh) * 100);
$this->annotation .= $perc._('% de votos con karma menores que la media')." (".round($globals['users_karma_avg'],2).")<br/>";
}
$karma_pos_user = (int) $karma_pos_user_high + (int) min(max($karma_pos_user_high * 1.07, 4), $karma_pos_user_low);
$karma_pos_ano = min($karma_pos_user_high*0.1, $karma_pos_ano);
// Small quadratic punishment for links having too many negatives
if ($karma_pos_user+$karma_pos_ano > abs($karma_neg_user) && abs($karma_neg_user)/$karma_pos_user > 0.075) {
$r = min(max(0,abs($karma_neg_user)*2/$karma_pos_user), 0.5);
$karma_neg_user = max(-($karma_pos_user+$karma_pos_ano), $karma_neg_user * pow((1+$r), 2));
}
// Get met categories coefficientes that will be used below
$meta_coef = $this->metas_coef_get();
// BONUS
// Give more karma to news voted very fast during the first two hours (ish)
if (abs($karma_neg_user)/$karma_pos_user < 0.05
&& $globals['now'] - $this->sent_date < 7200
&& $globals['now'] - $this->sent_date > 600) {
$this->coef = $globals['bonus_coef'] - ($globals['now']-$this->sent_date)/7200;
// It applies the same meta coefficient to the bonus'
// Check 1 <= bonus <= $bonus_coef
$this->coef = max(min($this->coef, $globals['bonus_coef']), 1);
// if it's has bonus and therefore time-related, use the base min_karma
} elseif ($karma_pos_user+$karma_pos_ano > abs($karma_neg_user)) {
// Aged karma
if ($globals['news_meta'] > 0 && $this->meta_id != $globals['news_meta']) {
$plain_hours = $globals['karma_start_decay'];
$max_hours = $globals['karma_decay'];
} else {
$plain_hours = $globals['karma_news_start_decay'];
$max_hours = $globals['karma_news_decay'];
}
$d = 3600*$max_hours*(1+$globals['min_decay']);
$diff = max(0, $globals['now'] - ($this->sent_date + $plain_hours*3600));
$c = 1 - $diff/$d;
$c = max($globals['min_decay'], $c);
$c = min(1, $c);
$this->coef = $c;
} else {
$this->coef = 1;
}
if ($this->coef < .99) {
$this->annotation .= _('Noticia «antigua»'). "<br/>";
} elseif ($this->coef > 1.01) {
$this->annotation .= _('Bonus por noticia reciente'). "<br/>";
}
// Give the "new source" only if if has less than %5 of negative karma
if (abs($karma_neg_user)/$karma_pos_user < 0.05) {
$c = $this->calculate_source_bonus();
if ($c > 1) {
$this->coef = min($globals['bonus_coef'], $this->coef*$c);
$c = round($c, 2);
$this->annotation .= _('Bonus por fuente esporádica'). " ($c)<br/>";
}
}
$this->karma = ($karma_pos_user+$karma_pos_ano+$karma_neg_user)*$this->coef;
if ($meta_coef && $meta_coef[$this->meta_id]) {
$this->karma *= $meta_coef[$this->meta_id];
// Annotate meta's coeeficient if the variation > 5%
if (abs(1 - $meta_coef[$this->meta_id]) > 0.05) {
$this->annotation .= _('Coeficiente categoría').': '.round($meta_coef[$this->meta_id], 2)."<br/>";
}
}
$this->karma = round($this->karma);
}
function insert_vote($value = 0)
{
global $current_user, $db;
if (!$value) {
$value = $current_user->user_karma;
}
$vote = new Vote('comments', $this->id, $current_user->user_id);
// Affinity
if ($current_user->user_id != $this->author && ($affinity = User::get_affinity($this->author, $current_user->user_id))) {
if ($value < -1 && $affinity < 0) {
$value = round(min(-1, $value * abs($affinity / 100)));
} elseif ($value > 1 && $affinity > 0) {
$value = round(max($value * $affinity / 100, 1));
}
}
if ($vote->exists(true)) {
return false;
}
$vote->value = $value;
$db->transaction();
if ($r = $vote->insert()) {
if ($current_user->user_id != $this->author) {
$r = $db->query("update comments set comment_votes=comment_votes+1, comment_karma=comment_karma+{$value}, comment_date=comment_date where comment_id={$this->id}");
}
}
if ($r && $db->commit()) {
return $vote->value;
}
syslog(LOG_INFO, "failed insert comment vote for {$this->id}");
return false;
}
