query($sql);
if ($inDB->num_rows($rs)){
$data = $inDB->fetch_assoc($rs);
$rating = $data['rating'] * 5;
} else {
$rating = 0;
}
$sql = "UPDATE cms_clubs SET rating = '$rating' WHERE id = '$club_id'";
$inDB->query($sql);
}
function setUsersRating(){
$inCore = cmsCore::getInstance();
$inDB = cmsDatabase::getInstance();
$target = $inCore->request('target', 'str', '');
$item_id = $inCore->request('item_id', 'int', 0);
$opt = $inCore->request('opt', 'str', 'plus');
$comment_id = $inCore->request('comment_id', 'int', 0);
$comment_vote = $inCore->request('vote', 'int', 1);
if ($comment_id) { $target = 'comment'; $item_id = $comment_id; }
$table = '';
switch($target){
case 'blogpost': $table = 'cms_blog_posts'; break;
case 'content': $table = 'cms_content'; break;
case 'comment': $table = 'cms_comments'; break;
}
if (!$table) { return false; }
$author_sql = "SELECT u.id as id
FROM cms_users u, {$table} t
WHERE t.id = {$item_id} AND t.user_id = u.id
LIMIT 1";
$author_res = $inDB->query($author_sql);
if (!$inDB->num_rows($author_res)) { return false; }
$author = $inDB->fetch_assoc($author_res);
if ($comment_id){
$inc = ($comment_vote>0 ? ('+'.$comment_vote*2) : ($comment_vote*2));
} else {
$inc = ($opt=='plus' ? '+ 5' : '- 5');
}
$inDB->query("UPDATE cms_users SET rating = rating {$inc} WHERE id = {$author['id']}");
}
function cmsClearKarma($target, $item_id){
$inDB = cmsDatabase::getInstance();
$inDB->query("DELETE FROM cms_ratings WHERE target='$target' AND item_id = $item_id");
return;
}
function cmsKarma($target, $item_id){ //returns array with total votes and total points of karma
if (!preg_match('/^([a-zA-Z0-9\_]+)$/i', $target)) { return; }
$item_id = intval($item_id);
$inDB = cmsDatabase::getInstance();
$item = $inDB->get_fields('cms_ratings_total', "item_id = '$item_id' AND target='$target'", 'total_rating, total_votes');
if (!$item){ return array('points'=>0, 'votes'=>0); }
return array('points'=>$item['total_rating'], 'votes'=>$item['total_votes']);
}
function cmsAlreadyKarmed($target, $item_id, $user_id){
$inDB = cmsDatabase::getInstance();
return $inDB->rows_count('cms_ratings', "target='$target' AND item_id = $item_id AND user_id = '$user_id'");
}
function cmsAlreadyKarmedIP($target, $item_id, $ip){
$inDB = cmsDatabase::getInstance();
return $inDB->rows_count('cms_ratings', "target='$target' AND item_id = $item_id AND ip = '$ip'");
}
function cmsAlreadyKarmedAny($target, $user_id){
$inDB = cmsDatabase::getInstance();
return $inDB->rows_count('cms_ratings', "target='$target' AND user_id = '$user_id'");
}
function cmsAlreadyKarmedAnyIP($target, $ip){
$inDB = cmsDatabase::getInstance();
return $inDB->rows_count('cms_ratings', "target='$target' AND ip = '$ip'");
}
function cmsSubmitKarma($target, $item_id, $points){
$inUser = cmsUser::getInstance();
$inDB = cmsDatabase::getInstance();
$id = $inUser->id;
$ip = $_SERVER['REMOTE_ADDR'];
if(cmsAlreadyKarmed($target, $item_id, $id)){ return false; }
//вставляем новый голос
$sql = "INSERT INTO cms_ratings (item_id, points, ip, target, user_id, pubdate)
VALUES ('$item_id', '$points', '$ip', '$target', '$id', NOW())";
$inDB->query($sql);
//проверяем была ли сделана агрегация для этой цели ранее
$is_agr = $inDB->rows_count('cms_ratings_total', "target='$target' AND item_id = '$item_id'", 1);
//если была, то обновляем
if ($is_agr) { $agr_sql = "UPDATE cms_ratings_total
SET total_rating = total_rating + ({$points}),
total_votes = total_votes + 1
WHERE target='$target' AND item_id = '$item_id'"; }
//если не было, то вставляем
if (!$is_agr) { $agr_sql = "INSERT INTO cms_ratings_total (target, item_id, total_rating, total_votes)
VALUES ('{$target}', '{$item_id}', '{$points}', '1')"; }
$inDB->query($agr_sql);
//получаем информацию о цели
$info = $inDB->get_fields('cms_rating_targets', "target='{$target}'", '*');
//если нужно, изменяем рейтинг автора цели
if ($info['is_user_affect'] && $info['user_weight'] && $info['target_table']){
$user_sql = "UPDATE cms_users u,
{$info['target_table']} t
SET u.rating = u.rating + ({$points}*{$info['user_weight']})
WHERE t.user_id = u.id AND t.id = '$item_id'";
$inDB->query($user_sql);
}
//проверяем наличие метода updateRatingHook(target, item_id, points) в модели
//компонента, ответственного за цель
if ($info['component']){
$inCore = cmsCore::getInstance();
$inCore->loadModel($info['component']);
if (class_exists('cms_model_'.$info['component'])){
$model_class = 'cms_model_'.$info['component'];
$model = new $model_class();
if (method_exists($model, 'updateRatingHook')){
$model->updateRatingHook($target, $item_id, $points);
}
}
}
return true;
}
function cmsKarmaFormat($points){
if ($points==0) {
$html = '0';
} elseif ($points>0){
$html = '+'.$points.'↑';
} else {
$html = ''.$points.'↓';
}
return $html;
}
function cmsKarmaFormatSmall($points){
if ($points==0) {
$html = '0';
} elseif ($points>0){
$html = '+'.$points.'';
} else {
$html = ''.$points.'';
}
return $html;
}
function cmsKarmaForm($target, $target_id, $points = 0, $is_author = false){
$inUser = cmsUser::getInstance();
$inPage = cmsPage::getInstance();
$html = '';
global $_LANG;
if (!$points) {
$postkarma = cmsKarma($target, $target_id);
$points = cmsKarmaFormat($postkarma['points']);
} else {
$points = $points;
}
$control = '';
//PREPARE RATING FORM
if ($inUser->id && !$is_author){
if(!cmsAlreadyKarmed($target, $target_id, $inUser->id)){
$inPage->addHeadJS('core/js/karma.js');
$control .= '';
$control .= '
';
$control .= '
';
$control .= '
';
$control .= '
';
$control .= '
';
$control .= '