function cot_ukarma($userid, $area = 'users', $code = '', $onlyscore = false)
{
    global $db, $cfg, $db_ukarma, $db_users;
    if ($area == 'users' && $db->fieldExists($db_users, "user_ukarma")) {
        $score = $db->query("SELECT user_ukarma FROM {$db_users} WHERE user_id=" . $userid)->fetchColumn();
    } else {
        $where['ukarma_userid'] = "ukarma_userid=" . $userid;
        if (!empty($area) && $area != 'users') {
            $where['ukarma_area'] = "ukarma_area='" . $area . "'";
        }
        if (!empty($code)) {
            $where['ukarma_code'] = "ukarma_code='" . $code . "'";
        }
        $where = $where ? 'WHERE ' . implode(' AND ', $where) : '';
        $score = $db->query("SELECT SUM(ukarma_value) FROM {$db_ukarma} {$where}")->fetchColumn();
    }
    if ($onlyscore) {
        return !empty($score) ? $score : 0;
    }
    if ($score > 0) {
        $sign = '+';
    } elseif ($score < 0) {
        $sign = '-';
    }
    $t = new XTemplate(cot_tplfile(array('ukarma', $area), 'plug'));
    $t->assign(cot_generate_usertags($userid, 'UKARMA_USER_'));
    $t->assign(array('UKARMA_AREA' => $area, 'UKARMA_CODE' => $code, 'UKARMA_SELECTOR' => 'ukarma_' . $userid . $area . $code, 'UKARMA_SCOREENABLED' => cot_ukarma_checkenablescore($userid, $area, $code), 'UKARMA_SCORE' => !empty($score) ? $score : 0, 'UKARMA_SCORE_ABS' => !empty($score) ? abs($score) : 0, 'UKARMA_SIGN' => $sign));
    $t->parse('MAIN');
    return $t->text('MAIN');
}
Example #2
0
[END_COT_EXT]
==================== */
/**
 * ukarma plugin
 *
 * @package ukarma
 * @version 1.0.0
 * @author CMSWorks Team
 * @copyright Copyright (c) CMSWorks.ru
 * @license BSD
 */
defined('COT_CODE') or die('Wrong URL');
$userid = cot_import('userid', 'G', 'INT');
$area = cot_import('area', 'G', 'ALP');
$code = cot_import('code', 'G', 'ALP');
$score = cot_import('score', 'G', 'INT');
if ($m == 'add') {
    $score_enabled = cot_ukarma_checkenablescore($userid, $area, $code);
    if (in_array($score, array(-1, 1)) && !empty($userid) && $score_enabled) {
        $rscore['ukarma_value'] = $score;
        $rscore['ukarma_userid'] = $userid;
        $rscore['ukarma_ownerid'] = $usr['id'];
        $rscore['ukarma_date'] = $sys['now'];
        $rscore['ukarma_area'] = $area;
        $rscore['ukarma_code'] = $code;
        $db->insert($db_ukarma, $rscore);
        $score = $db->query("SELECT SUM(ukarma_value) FROM {$db_ukarma} WHERE ukarma_userid=" . $userid)->fetchColumn();
        $db->update($db_users, array('user_ukarma' => $score), "user_id=" . $userid);
    }
}
echo cot_ukarma($userid, $area, $code);