интересный алгоритм голосования

function setUsersRating(){
    $inDB = cmsDatabase::getInstance();
	$sql = "SELECT id FROM cms_users WHERE is_locked = 0 AND is_deleted = 0";
	$res = $inDB->query($sql);
 
	while($user = $inDB->fetch_assoc($res)){
		$sql = "SELECT SUM( r.points ) AS rating
				FROM cms_ratings r
				LEFT JOIN cms_content c ON r.item_id = c.id AND r.target = 'content'
				LEFT JOIN cms_photo_files f ON r.item_id = f.id AND r.target = 'photo'
				LEFT JOIN cms_blog_posts p ON r.item_id = p.id AND r.target = 'blogpost'
				WHERE c.user_id = ".$user['id']." OR f.user_id = ".$user['id']." OR p.user_id = ".$user['id'];
		$rs = $inDB->query($sql);
		if ($inDB->num_rows($rs)){
			$data = $inDB->fetch_assoc($rs);
			$rating = $data['rating'] * 5;
		} else {
			$rating = 0;
		}
 
        $sql = "SELECT SUM(v.vote) AS votes
				FROM cms_comments_votes v
				LEFT JOIN cms_comments c ON v.comment_id = c.id
				WHERE c.user_id = ".$user['id']." AND v.comment_type = 'com'";
		$rs = $inDB->query($sql);
		if ($inDB->num_rows($rs)){
			$data = $inDB->fetch_assoc($rs);
			$rating += $data['votes'] * 2;
		}
 
		$sql = "UPDATE cms_users SET rating = $rating WHERE id = ".$user['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']}");
 
}