uchome 积分体系

一。总体流程

1）：管理员在后台修改积分规则
2）：数据被写入数据表creditrule 中,并将数据写入缓存文件data/data_creditrule.php 中
3）：用户发表文章或者进行其他操作的时候，通过getreward函数来获取奖罚积分　　
4）：将数据写入用户数据库表space中，从而增加或减少用户积分

二。具体文件

1）：UCHOME积分变动提示是通过footer.htm的showreward()来监控

2）：showreward()在source/script_common.js中

function showreward() {
    if(Cookie.get('reward_notice_disable')) {
        return false;
    }
    var x = new Ajax();
    x.get('do.php?ac=ajax&op=getreward', function(s){
        if(s) {
            msgwin(s, 2000);
        }
    });
}

3）：AJAX处理页面source/do_ajax.php中的getreward部分

elseif($op == 'getreward') {
    $reward = '';
    if($_SCOOKIE['reward_log']) {
        $log = explode(',', $_SCOOKIE['reward_log']);
        if(count($log) == 2 && $log[1]) {
            @include_once(S_ROOT.'./data/data_creditrule.php');
            $query = $_SGLOBAL['db']->query("SELECT * FROM ".tname('creditlog')." WHERE clid='$log[1]'");
            $creditlog = $_SGLOBAL['db']->fetch_array($query);
            $rule = $_SGLOBAL['creditrule'][$log[0]];
            $rule['cyclenum'] = $rule['rewardnum']? $rule['rewardnum'] - $creditlog['cyclenum'] : 0;
        }
        ssetcookie('reward_log', '');
    }
    
}

 

三。关键函数

//获取指定动作能获得多少积分
function getreward($action, $update=1, $uid=0, $needle='', $setcookie = 1) {
    global $_SGLOBAL, $_SCOOKIE;

    $credit = 0;
    $reward = array(
        'credit' => 0,
        'experience' => 0
    );
    $creditlog = array();
    @include_once(S_ROOT.'./data/data_creditrule.php');
    $rule = $_SGLOBAL['creditrule'][$action];

    if($rule['credit'] || $rule['experience']) {
        $uid = $uid ? intval($uid) : $_SGLOBAL['supe_uid'];
        if($rule['rewardtype']) {
            //增加积分
            $query = $_SGLOBAL['db']->query("SELECT * FROM ".tname('creditlog')." WHERE uid='$uid' AND rid='$rule[rid]'");
            $creditlog = $_SGLOBAL['db']->fetch_array($query);

            if(empty($creditlog)) {
                $reward['credit'] = $rule['credit'];
                $reward['experience'] = $rule['experience'];
                $setarr = array(
                    'uid' => $uid,
                    'rid' => $rule['rid'],
                    'total' => 1,
                    'cyclenum' => 1,
                    'credit' => $rule['credit'],
                    'experience' => $rule['experience'],
                    'dateline' => $_SGLOBAL['timestamp']
                );
                //判断是否需要去重
                if($rule['norepeat']) {
                    if($rule['norepeat'] == 1) {
                        $setarr['info'] = $needle;
                    } elseif($rule['norepeat'] == 2) {
                        $setarr['user'] = $needle;
                    } elseif($rule['norepeat'] == 3) {
                        $setarr['app'] = $needle;
                    }
                }

                if(in_array($rule['cycletype'], array(2,3))) {
                    $setarr['starttime'] = $_SGLOBAL['timestamp'];
                }
                $clid = inserttable('creditlog', $setarr, 1);
            } else {
                $newcycle = false;
                $setarr = array();
                $clid = $creditlog['clid'];
                switch($rule['cycletype']) {
                    case 0:        //一次性奖励
                        break;
                    case 1:        //每天限次数
                    case 4:        //不限周期
                        $sql = 'cyclenum+1';
                        if($rule['cycletype'] == 1) {
                            $today = sstrtotime(sgmdate('Y-m-d'));
                            //判断是否为昨天
                            if($creditlog['dateline'] < $today && $rule['rewardnum']) {
                                $creditlog['cyclenum'] =  0;
                                $sql = 1;
                                $newcycle = true;
                            }
                        }
                        if(empty($rule['rewardnum']) || $creditlog['cyclenum'] < $rule['rewardnum']) {
                            //验证是否为需要去重操作
                            if($rule['norepeat']) {
                                $repeat = checkcheating($creditlog, $needle, $rule['norepeat']);
                                if($repeat && !$newcycle) {
                                    return $reward;
                                }
                            }
                            $reward['credit'] = $rule['credit'];
                            $reward['experience'] = $rule['experience'];
                            //更新次数
                            $setarr = array(
                                'cyclenum' => "cyclenum=$sql",
                                'total' => 'total=total+1',
                                'dateline' => "dateline='$_SGLOBAL[timestamp]'",
                                'credit' => "credit='$reward[credit]'",
                                'experience' => "experience='$reward[experience]'",
                            );
                        }
                        break;

                    case 2:        //整点
                    case 3:        //间隔分钟
                        $nextcycle = 0;
                        if($creditlog['starttime']) {
                            if($rule['cycletype'] == 2) {
                                //上一次执行时间
                                $start = sstrtotime(sgmdate('Y-m-d H:00:00', $creditlog['starttime']));
                                $nextcycle = $start+$rule['cycletime']*3600;
                            } else {
                                $nextcycle = $creditlog['starttime']+$rule['cycletime']*60;
                            }
                        }
                        if($_SGLOBAL['timestamp'] <= $nextcycle && $creditlog['cyclenum'] < $rule['rewardnum']) {
                            //验证是否为需要去重操作
                            if($rule['norepeat']) {
                                $repeat = checkcheating($creditlog, $needle, $rule['norepeat']);
                                if($repeat && !$newcycle) {
                                    return $reward;
                                }
                            }
                            $reward['experience'] = $rule['experience'];
                            $reward['credit'] = $rule['credit'];

                            $setarr = array(
                                'cyclenum' => "cyclenum=cyclenum+1",
                                'total' => 'total=total+1',
                                'dateline' => "dateline='$_SGLOBAL[timestamp]'",
                                'credit' => "credit='$reward[credit]'",
                                'experience' => "experience='$reward[experience]'",
                            );
                        } elseif($_SGLOBAL['timestamp'] >= $nextcycle) {
                            $newcycle = true;
                            $reward['experience'] = $rule['experience'];
                            $reward['credit'] = $rule['credit'];

                            $setarr = array(
                                'cyclenum' => "cyclenum=1",
                                'total' => 'total=total+1',
                                'dateline' => "dateline='$_SGLOBAL[timestamp]'",
                                'credit' => "credit='$reward[credit]'",
                                'starttime' => "starttime='$_SGLOBAL[timestamp]'",
                                'experience' => "experience='$reward[experience]'",
                            );
                        }
                        break;
                }

                //记录操作历史
                if($rule['norepeat'] && $needle) {
                    switch($rule['norepeat']) {
                        case 0:
                            break;
                        case 1:        //信息去重
                            $info = empty($creditlog['info'])||$newcycle ? $needle : $creditlog['info'].','.$needle;
                            $setarr['info'] = "`info`='$info'";
                            break;
                        case 2:        //用户去重
                            $user = empty($creditlog['user'])||$newcycle ? $needle : $creditlog['user'].','.$needle;
                            $setarr['user'] = "`user`='$user'";
                            break;
                        case 3:        //应用去重
                            $app = empty($creditlog['app'])||$newcycle ? $needle : $creditlog['app'].','.$needle;
                            $setarr['app'] = "`app`='$app'";
                            break;
                    }
                }
                if($setarr) {
                    $_SGLOBAL['db']->query("UPDATE ".tname('creditlog')." SET ".implode(',', $setarr)." WHERE clid='$creditlog[clid]'");
                }

            }
            if($setcookie && $uid = $_SGLOBAL['supe_uid']) {
                //其中有新值时才重写cookie值
                if($reward['credit'] || $reward['experience']) {
                    $logstr = $action.','.$clid;
                    ssetcookie('reward_log', $logstr);
                    $_SCOOKIE['reward_log'] = $logstr;
                }
            }
        } else {
            //扣除积分
            $reward['credit'] = "-$rule[credit]";
            $reward['experience'] = "-$rule[experience]";
        }
        if($update && ($reward['credit'] || $reward['experience'])) {
            $setarr = array();
            if($reward['credit']) {
                $setarr['credit'] = "credit=credit+$reward[credit]";
            }
            if($reward['experience']) {
                $setarr['experience'] = "experience=experience+$reward[experience]";
            }
            $_SGLOBAL['db']->query("UPDATE ".tname('space')." SET ".implode(',', $setarr)." WHERE uid='$uid'");
        }
    }
    return array('credit'=>abs($reward['credit']), 'experience' => abs($reward['experience']));
}