if (!check_security_key($_REQUEST['key'])) {
error(_('clave de control incorrecta'));
}
if (empty($_REQUEST['value']) || !is_numeric($_REQUEST['value'])) {
error(_('falta valor del voto'));
}
if ($current_user->user_karma < $globals['min_karma_for_post_votes']) {
error(_('karma bajo para votar comentarios'));
}
$value = intval($_REQUEST['value']);
if ($value != -1 && $value != 1) {
error(_('valor del voto incorrecto'));
}
$vote = new Vote('posts', $id, $current_user->user_id);
$vote->link = $id;
if ($vote->exists()) {
error(_('ya se votó antes con el mismo usuario o IP'));
}
$votes_freq = intval($db->get_var("select count(*) from votes where vote_type='posts' and vote_user_id={$current_user->user_id} and vote_date > subtime(now(), '0:0:30') and vote_ip_int = " . $globals['user_ip_int']));
$freq = 6;
if ($votes_freq > $freq) {
if ($current_user->user_id > 0 && $current_user->user_karma > 4) {
// Crazy votes attack, decrease karma
// she does not deserve it :-)
$user = new User();
$user->id = $current_user->user_id;
$user->read();
$user->karma = $user->karma - 0.1;
$user->store();
error(_('¡tranquilo cowboy!, tu karma ha bajado: ') . $user->karma);
} else {
/**
* 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 insert_vote($user_id = false, $value = 0)
{
global $current_user, $db;
if (!$user_id) {
$user_id = $current_user->user_id;
}
if (!$value && $current_user->user_karma) {
$value = $current_user->user_karma;
}
$vote = new Vote('posts', $this->id, $user_id);
$vote->link = $this->id;
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 posts set post_votes=post_votes+1, post_karma=post_karma+{$value}, post_date=post_date where post_id={$this->id}");
}
}
$c = $db->commit();
if ($r && $c) {
return $vote->value;
}
syslog(LOG_INFO, "failed insert post vote for {$this->id}");
return false;
}
function insert_vote($user_id = false, $value = 0) {
global $current_user, $db;
if (! $user_id) $user_id = $current_user->user_id;
if (! $value && $current_user->user_karma) {
$value = $current_user->user_karma;
}
$vote = new Vote('posts', $this->id, $user_id);
$vote->link=$this->id;
if ($vote->exists(true)) {
return false;
}
$vote->value = $value;
$db->transaction();
if($vote->insert()) {
if ($current_user->user_id != $this->author) {
$db->query("update posts set post_votes=post_votes+1, post_karma=post_karma+$value, post_date=post_date where post_id=$this->id");
}
} else {
$vote->value = false;
}
$db->commit();
return $vote->value;
}
function insert_vote($value, $former_value = null) {
global $db, $current_user, $globals;
$vote = new Vote('links', $this->id, $current_user->user_id);
if ($vote->exists(true)) return false;
// For karma calculation
if ($this->status != 'published') {
if($value < 0 && $current_user->user_id > 0) {
if ($current_user->user_id != $this->author &&
($affinity = User::get_affinity($this->author, $current_user->user_id)) < 0 ) {
$karma_value = round(min(-5, $current_user->user_karma * ($affinity/100)));
} else {
$karma_value = round(-$current_user->user_karma);
}
} else {
if ($current_user->user_id > 0 && $current_user->user_id != $this->author &&
($affinity = User::get_affinity($this->author, $current_user->user_id)) > 0 ) {
$karma_value = $value = round(max($current_user->user_karma * ($affinity/100), 5));
} else {
$karma_value=round($value);
}
}
} else {
$karma_value = 0;
}
// former_value only for negatives
if ($former_value != null) {
$vote->value=$former_value;
$karma_value = $karma_value /3;
} else {
$vote->value=$value;
}
$db->transaction();
if($vote->insert()) {
// For published links we update counter fields
if ($this->status == 'published') {
if ($vote->user > 0) {
if ($value > 0) {
$db->query("update links set link_votes=link_votes+1 where link_id = $this->id");
} else {
$db->query("update links set link_negatives=link_negatives+1 where link_id = $this->id");
}
} else {
$db->query("update links set link_anonymous=link_anonymous+1 where link_id = $this->id");
}
} else {
// If not published we update karma and count all votes
$db->query("update links set link_karma=link_karma+$karma_value where link_id = $this->id");
$this->update_votes();
}
$db->commit();
$this->read_basic();
} else {
$db->commit();
$value = false;
}
return $value;
}
function insert_vote($user=0) {
global $anon_karma;
require_once(mnminclude.'votes.php');
$vote = new Vote;
$vote->user=$user;
$vote->link=$this->id;
if ($vote->exists()) return false;
$vote->value=$anon_karma;
if($user>0) {
require_once(mnminclude.'user.php');
$dbuser = new User($user);
if($dbuser->id>0) {
$vote->value = round($dbuser->karma);
}
}
if($vote->insert()) {
$vote->user=-1;
$this->votes=$vote->count();
$this->store_basic();
return true;
}
return false;
}
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;
}
function insert_vote($user, $value)
{
global $db, $current_user;
require_once mnminclude . 'votes.php';
$vote = new Vote();
$vote->user = $user;
$vote->link = $this->id;
if ($vote->exists()) {
return false;
}
$vote->value = $value;
// For karma calculation
if ($this->status != 'published') {
if ($value < 0 && $user > 0) {
$karma_value = round(($value - $current_user->user_karma) / 2);
} else {
$karma_value = round($value);
}
} else {
$karma_value = 0;
}
if ($vote->insert()) {
if ($value < 0) {
$db->query("update links set link_negatives=link_negatives+1, link_karma=link_karma+{$karma_value} where link_id = {$this->id}");
} else {
$db->query("update links set link_votes = link_votes+1, link_karma=link_karma+{$karma_value} where link_id = {$this->id}");
}
$new = $db->get_row("select link_votes, link_negatives, link_karma from links where link_id = {$this->id}");
$this->votes = $new->link_votes;
$this->negatives = $new->link_negatives;
$this->karma = $new->link_karma;
return true;
}
return false;
}
function insert_vote($value)
{
global $db, $current_user, $globals;
$vote = new Vote('links', $this->id, $current_user->user_id);
if ($vote->exists(true)) {
return false;
}
// For karma calculation
$status = !empty($this->sub_status) ? $this->sub_status : $this->status;
$vote_value = $value > 0 ? $value : -$current_user->user_karma;
$karma_value = round($vote_value);
/******* Simplified, it doesn't make much sense with subs
if ($status != 'published') {
if($value < 0 && $current_user->user_id > 0) {
if ($globals['karma_user_affinity'] && $current_user->user_id != $this->author &&
($affinity = User::get_affinity($this->author, $current_user->user_id)) < 0 ) {
$karma_value = round(min(-5, $current_user->user_karma * $affinity/100));
} else {
$karma_value = round($vote_value);
}
} else {
if ($globals['karma_user_affinity'] && $current_user->user_id > 0 && $current_user->user_id != $this->author &&
($affinity = User::get_affinity($this->author, $current_user->user_id)) > 0 ) {
$karma_value = $value = round(max($current_user->user_karma * $affinity/100, 5));
} else {
$karma_value=round($vote_value);
}
}
} else {
$karma_value=round($vote_value);
}
*/
$vote->value = $value;
$db->transaction();
if ($vote->insert()) {
if ($vote->user > 0) {
if ($value > 0) {
$what = 'link_votes=link_votes+1';
} else {
$what = 'link_negatives=link_negatives+1';
}
} else {
$what = 'link_anonymous=link_anonymous+1';
}
$r = $db->query("update links set {$what}, link_karma=link_karma+{$karma_value} where link_id = {$this->id}");
if (!$r) {
syslog(LOG_INFO, "failed transaction in Link::insert_vote: {$this->id} ({$r})");
$value = false;
} else {
// Update in memory object
if ($vote->user > 0) {
if ($value > 0) {
$this->votes += 1;
} else {
$this->negatives += 1;
}
} else {
$this->anonymous += 1;
}
// Update karma and check votes
if ($status != 'published') {
$this->karma += $karma_value;
$this->update_votes();
}
}
$db->commit();
} else {
$db->rollback();
$value = false;
}
return $value;
}
function vote_exists($user)
{
$vote = new Vote('links', $this->id, $user);
return $vote->exists(false);
}
function insert_vote()
{
global $current_user;
require_once mnminclude . 'votes.php';
$vote = new Vote();
$vote->user = $current_user->user_id;
$vote->type = 'posts';
$vote->link = $this->id;
if ($vote->exists()) {
return false;
}
$vote->value = $current_user->user_karma;
if ($vote->insert()) {
return true;
}
return false;
}
function insert_vote($value)
{
global $db, $current_user, $globals;
$vote = new Vote('links', $this->id, $current_user->user_id);
if ($vote->exists(true)) {
return false;
}
// For karma calculation
if ($this->status != 'published') {
if ($value < 0 && $current_user->user_id > 0) {
if ($globals['karma_user_affinity'] && $current_user->user_id != $this->author && ($affinity = User::get_affinity($this->author, $current_user->user_id)) < 0) {
$karma_value = round(min(-5, $current_user->user_karma * $affinity / 100));
} else {
$karma_value = round(-$current_user->user_karma);
}
} else {
if ($globals['karma_user_affinity'] && $current_user->user_id > 0 && $current_user->user_id != $this->author && ($affinity = User::get_affinity($this->author, $current_user->user_id)) > 0) {
$karma_value = $value = round(max($current_user->user_karma * $affinity / 100, 5));
} else {
$karma_value = round($value);
}
}
} else {
$karma_value = 0;
}
$vote->value = $value;
$db->transaction();
if ($vote->insert()) {
if ($vote->user > 0) {
if ($value > 0) {
$r = $db->query("update links set link_votes=link_votes+1 where link_id = {$this->id}");
} else {
$r = $db->query("update links set link_negatives=link_negatives+1 where link_id = {$this->id}");
}
} else {
$r = $db->query("update links set link_anonymous=link_anonymous+1 where link_id = {$this->id}");
}
// For published links we update counter fields
if ($r && $this->status != 'published') {
// If not published we update karma and count all votes
$r = $db->query("update links set link_karma=link_karma+{$karma_value} where link_id = {$this->id}");
}
if (!$r) {
syslog(LOG_INFO, "failed transaction in Link::insert_vote: {$this->id} ({$r})");
$value = false;
} else {
// Update in memory object
if ($vote->user > 0) {
if ($value > 0) {
$this->votes += 1;
} else {
$this->negatives += 1;
}
} else {
$this->anonymous += 1;
}
// Update karma and check votes
if ($this->status != 'published') {
$this->karma += $karma_value;
$this->update_votes();
}
}
$db->commit();
} else {
$db->rollback();
$value = false;
}
return $value;
}
