Пример #1
0
 public function del()
 {
     if (!$GLOBALS['islogin']) {
         exit;
     }
     if (!checkpost()) {
         exit;
     }
     $ids = postvar('fids');
     $str = orsql('id', $ids);
     $msg = M('msg');
     $rs = $msg->field('SUM(new)')->where("uid={$GLOBALS['i']['uid']} AND ({$str})")->find();
     $sum = $rs['SUM(new)'];
     $num = $GLOBALS['i']['new_msg'] - $sum;
     $member_field = M('member_field');
     $edit['new_msg'] = $num < 0 ? 0 : $num;
     $member_field->where("uid={$GLOBALS['i']['uid']}")->save($edit);
     //echo $member_field->getLastSql();
     //exit();
     $data['status'] = 0;
     $data['new'] = 0;
     $msg->where("uid={$GLOBALS['i']['uid']} AND ({$str})")->save($data);
     //echo $msg->getLastSql();
     //exit();
     echo '200';
 }
Пример #2
0
 public function _assign_feed($face_size, $type = 'more', $page = 0, $is_last = 0, $last_id = 0)
 {
     $feed = M('feed');
     $page = max(0, $page);
     $perpage = 10;
     $startnum = $perpage * $page;
     $where = '';
     if ($type == 'index') {
         $where .= orsql('qh_feed.uid', trim($GLOBALS['i']['ifav_uids'], ','));
     }
     $result = $feed->field('qh_feed.uid, qh_feed.body, qh_feed.count, qh_feed.type, qh_feed.body, qh_feed.add_time, qh_member.username, qh_member.default_pic, qh_member.sex')->join("LEFT JOIN qh_member ON qh_feed.uid=qh_member.uid")->where($where)->order('add_time DESC')->limit($startnum . ',' . $perpage)->select();
     //echo $feed->getLastSql();
     $feedlist = array();
     foreach ($result as $row) {
         $feedlist[$row['uid']]['uid'] = $row['uid'];
         $feedlist[$row['uid']]['username'] = $row['username'];
         $feedlist[$row['uid']]['default_pic'] = $row['default_pic'];
         $feedlist[$row['uid']]['sex'] = $row['sex'];
         $feedlist[$row['uid']]['data'][] = $row;
     }
     $this->assign('face_size', $face_size);
     $this->assign('feedlist', $feedlist);
     $this->assign('is_last', $is_last);
     $this->assign('last_id', $last_id);
 }