public function index()
    {
        if (isset($_REQUEST['tid'])) {
            $tid = intval($_REQUEST['tid']);
        } else {
            $tid = intval($_SESSION['forum_post_tid']);
        }
        $_SESSION['forum_post_tid'] = $tid;
        $where = 'WHERE fp.tid = ' . $tid;
        $parameter = array();
        $uname = trim($_REQUEST['uname']);
        if (!empty($uname)) {
            $this->assign("uname", $uname);
            $parameter['uname'] = $uname;
            $match_key = segmentToUnicodeA($uname, '+');
            $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
        }
        $model = M();
        $sql = 'SELECT COUNT(DISTINCT fp.pid) AS pcount 
			FROM ' . C("DB_PREFIX") . 'forum_post AS fp 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = fp.uid 
			' . $where;
        $count = $model->query($sql);
        $count = $count[0]['pcount'];
        $sql = 'SELECT fp.pid,LEFT(fp.content,80) AS content,u.user_name,fp.create_time,fp.share_id  
			FROM ' . C("DB_PREFIX") . 'forum_post AS fp 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = fp.uid 
			' . $where . ' GROUP BY fp.pid';
        $this->_sqlList($model, $sql, $count, $parameter, 'fp.pid', false, 'returnUrl1');
        $this->display();
        return;
    }
    public function index()
    {
        $where = '';
        $parameter = array();
        $keyword = trim($_REQUEST['keyword']);
        $uname = trim($_REQUEST['uname']);
        $sid = intval($_REQUEST['sid']);
        $city_id = intval($_REQUEST['city_id']);
        if (!empty($keyword)) {
            $this->assign("keyword", $keyword);
            $parameter['keyword'] = $keyword;
            $where .= " AND sg.name LIKE '%" . mysqlLikeQuote($keyword) . "%' ";
        }
        if (!empty($uname)) {
            $this->assign("uname", $uname);
            $parameter['uname'] = $uname;
            $match_key = segmentToUnicodeA($uname, '+');
            $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
            $like_name = mysqlLikeQuote($uname);
            $where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
        }
        if ($sid > 0) {
            $this->assign("sid", $sid);
            $parameter['sid'] = $sid;
            $where .= " AND sg.sid = {$sid}";
        }
        if ($city_id > 0) {
            $this->assign("city_id", $city_id);
            $parameter['city_id'] = $city_id;
            $where .= " AND sg.city_id = {$city_id}";
        }
        $model = M();
        if (!empty($where)) {
            $where = 'WHERE 1' . $where;
        }
        $sql = 'SELECT COUNT(DISTINCT sg.gid) AS tcount
			FROM ' . C("DB_PREFIX") . 'second_goods AS sg 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = sg.uid 
			' . $where;
        $count = $model->query($sql);
        $count = $count[0]['tcount'];
        $sql = 'SELECT sg.*,s.name AS sname,u.user_name   
			FROM ' . C("DB_PREFIX") . 'second_goods AS sg 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = sg.uid 
			LEFT JOIN ' . C("DB_PREFIX") . 'second AS s ON s.sid = sg.sid 
			' . $where . ' GROUP BY sg.gid';
        $this->_sqlList($model, $sql, $count, $parameter, 'sg.gid');
        $second_list = D("Second")->order('sort asc,sid asc')->findAll();
        $this->assign("second_list", $second_list);
        $city_list = D("Region")->where('parent_id = 0')->order('sort asc,id asc')->findAll();
        $this->assign("city_list", $city_list);
        $this->display();
        return;
    }
    public function index()
    {
        $where = '';
        $parameter = array();
        $uname = trim($_REQUEST['uname']);
        $begin_time_str = trim($_REQUEST['begin_time']);
        $end_time_str = trim($_REQUEST['end_time']);
        $begin_time = !empty($begin_time_str) ? strZTime($begin_time_str) : 0;
        $end_time = !empty($end_time_str) ? strZTime($end_time_str) : 0;
        if (!empty($uname)) {
            $this->assign("uname", $uname);
            $parameter['uname'] = $uname;
            $match_key = segmentToUnicodeA($uname, '+');
            $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
            $like_name = mysqlLikeQuote($uname);
            $where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
        }
        if ($begin_time > 0) {
            $this->assign("begin_time", $begin_time_str);
            $parameter['begin_time'] = $begin_time_str;
            $where .= " AND usl.create_day >= '" . $begin_time . "'";
        }
        if ($end_time > 0) {
            $this->assign("end_time", $end_time_str);
            $parameter['end_time'] = $end_time_str;
            $where .= " AND usl.create_day < '" . ($end_time + 86400) . "'";
        }
        $model = M();
        if (!empty($where)) {
            $where = 'WHERE 1' . $where;
        }
        $sql = 'SELECT COUNT(DISTINCT usl.id) AS tcount
			FROM ' . C("DB_PREFIX") . 'user_score_log AS usl 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = usl.uid 
			' . $where;
        $count = $model->query($sql);
        $count = $count[0]['tcount'];
        $sql = 'SELECT usl.*,u.user_name   
			FROM ' . C("DB_PREFIX") . 'user_score_log AS usl 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = usl.uid 
			' . $where . ' GROUP BY usl.id';
        $this->_sqlList($model, $sql, $count, $parameter, 'usl.id');
        $list = $this->get('list');
        foreach ($list as $k => $v) {
            if ($v['score'] >= 0) {
                $list[$k]['inc_score'] = abs($v['score']);
            } else {
                $list[$k]['dec_score'] = abs($v['score']);
            }
        }
        $this->assign('list', $list);
        $this->display();
        return;
    }
    public function index()
    {
        $where = '';
        $parameter = array();
        $uname = trim($_REQUEST['uname']);
        $begin_time_str = trim($_REQUEST['begin_time']);
        $end_time_str = trim($_REQUEST['end_time']);
        $begin_time = !empty($begin_time_str) ? strZTime($begin_time_str) : 0;
        $end_time = !empty($end_time_str) ? strZTime($end_time_str) : 0;
        if (!empty($uname)) {
            $this->assign("uname", $uname);
            $parameter['uname'] = $uname;
            $match_key = segmentToUnicodeA($uname, '+');
            $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
            $like_name = mysqlLikeQuote($uname);
            $where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
        }
        if ($begin_time > 0) {
            $this->assign("begin_time", $begin_time_str);
            $parameter['begin_time'] = $begin_time_str;
            $where .= " AND r.create_day >= '" . $begin_time . "'";
        }
        if ($end_time > 0) {
            $this->assign("end_time", $end_time_str);
            $parameter['end_time'] = $end_time_str;
            $where .= " AND r.create_day < '" . ($end_time + 86400) . "'";
        }
        $model = M();
        if (!empty($where)) {
            $where = 'WHERE 1' . $where;
        }
        $sql = 'SELECT COUNT(DISTINCT r.id) AS tcount
			FROM ' . C("DB_PREFIX") . 'referrals AS r 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = r.rid 
			' . $where;
        $count = $model->query($sql);
        $count = $count[0]['tcount'];
        $sql = 'SELECT r.*,CONCAT(u.user_name,\':\',us.reg_ip) as ruser_name,CONCAT(u1.user_name,\':\',us1.reg_ip) as user_name   
			FROM ' . C("DB_PREFIX") . 'referrals AS r 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = r.rid 
			LEFT JOIN ' . C("DB_PREFIX") . 'user_status AS us ON us.uid = r.rid 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u1 ON u1.uid = r.uid 
			LEFT JOIN ' . C("DB_PREFIX") . 'user_status AS us1 ON us1.uid = r.uid 
			' . $where . ' GROUP BY r.id';
        $this->_sqlList($model, $sql, $count, $parameter, 'r.id');
        $this->display();
        return;
    }
    public function index()
    {
        $where = '';
        $parameter = array();
        $keyword = trim($_REQUEST['keyword']);
        $uname = trim($_REQUEST['uname']);
        $cid = (int) $_REQUEST['cid'];
        if (!empty($keyword)) {
            $this->assign("keyword", $keyword);
            $parameter['keyword'] = $keyword;
            $where .= " AND a.title LIKE '%" . mysqlLikeQuote($keyword) . "%' ";
        }
        if (!empty($uname)) {
            $this->assign("uname", $uname);
            $parameter['uname'] = $uname;
            $match_key = segmentToUnicodeA($uname, '+');
            $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
            $like_name = mysqlLikeQuote($uname);
            $where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
        }
        if ($cid > 0) {
            $this->assign("cid", $cid);
            $parameter['cid'] = $cid;
            $where .= " AND a.cid = {$cid}";
        }
        $model = M();
        if (!empty($where)) {
            $where = 'WHERE' . $where;
            $where = str_replace('WHERE AND', 'WHERE', $where);
        }
        $sql = 'SELECT COUNT(DISTINCT a.id) AS tcount 
			FROM ' . C("DB_PREFIX") . 'album AS a 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = a.uid 
			' . $where;
        $count = $model->query($sql);
        $count = $count[0]['tcount'];
        $sql = 'SELECT a.*,ac.name AS cname,u.user_name   
			FROM ' . C("DB_PREFIX") . 'album AS a 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = a.uid 
			LEFT JOIN ' . C("DB_PREFIX") . 'album_category AS ac ON ac.id = a.cid 
			' . $where . ' GROUP BY a.id';
        $this->_sqlList($model, $sql, $count, $parameter, 'a.id');
        $category_list = D("AlbumCategory")->order('sort asc,id asc')->findAll();
        $this->assign("category_list", $category_list);
        $this->display();
        return;
    }
    public function index()
    {
        $where = '';
        $parameter = array();
        $keyword = trim($_REQUEST['keyword']);
        $uname = trim($_REQUEST['uname']);
        $fid = intval($_REQUEST['fid']);
        if (!empty($keyword)) {
            $this->assign("keyword", $keyword);
            $parameter['keyword'] = $keyword;
            $where .= " AND ft.title LIKE '%" . mysqlLikeQuote($keyword) . "%' ";
        }
        if (!empty($uname)) {
            $this->assign("uname", $uname);
            $parameter['uname'] = $uname;
            $match_key = segmentToUnicodeA($uname, '+');
            $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
        }
        if ($fid > 0) {
            $this->assign("fid", $fid);
            $parameter['fid'] = $fid;
            $where .= " AND ft.fid = {$fid}";
        }
        $model = M();
        if (!empty($where)) {
            $where = 'WHERE 1' . $where;
        }
        $sql = 'SELECT COUNT(DISTINCT ft.tid) AS tcount
			FROM ' . C("DB_PREFIX") . 'forum_thread AS ft 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ft.uid 
			' . $where;
        $count = $model->query($sql);
        $count = $count[0]['tcount'];
        $sql = 'SELECT ft.tid,LEFT(ft.title,80) AS title,u.user_name,ft.create_time,ft.post_count,ft.is_top,ft.is_best,
			ft.is_event,f.name AS fname,ft.share_id  
			FROM ' . C("DB_PREFIX") . 'forum_thread AS ft 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ft.uid 
			LEFT JOIN ' . C("DB_PREFIX") . 'forum AS f ON f.fid = ft.fid 
			' . $where . ' GROUP BY ft.tid';
        $this->_sqlList($model, $sql, $count, $parameter, 'ft.tid');
        $cate_tree = M("Forum")->findAll();
        $cate_tree = D("Forum")->toFormatTree($cate_tree, 'name', 'fid', 'parent_id');
        $this->assign("cate_tree", $cate_tree);
        $this->display();
        return;
    }
    public function index()
    {
        $where = '';
        $parameter = array();
        $keyword = trim($_REQUEST['keyword']);
        $uname = trim($_REQUEST['uname']);
        $aid = intval($_REQUEST['aid']);
        if (!empty($keyword)) {
            $this->assign("keyword", $keyword);
            $parameter['keyword'] = $keyword;
            $where .= " AND at.title LIKE '%" . mysqlLikeQuote($keyword) . "%' ";
        }
        if (!empty($uname)) {
            $this->assign("uname", $uname);
            $parameter['uname'] = $uname;
            $match_key = segmentToUnicodeA($uname, '+');
            $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
        }
        if ($aid > 0) {
            $this->assign("aid", $aid);
            $parameter['aid'] = $aid;
            $where .= " AND at.aid = {$aid}";
        }
        $model = M();
        if (!empty($where)) {
            $where = 'WHERE 1' . $where;
        }
        $sql = 'SELECT COUNT(DISTINCT at.tid) AS tcount
			FROM ' . C("DB_PREFIX") . 'ask_thread AS at 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = at.uid 
			' . $where;
        $count = $model->query($sql);
        $count = $count[0]['tcount'];
        $sql = 'SELECT at.tid,LEFT(at.title,80) AS title,u.user_name,at.create_time,at.post_count,at.is_top,at.is_best,
			a.name AS aname,at.share_id  
			FROM ' . C("DB_PREFIX") . 'ask_thread AS at 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = at.uid 
			LEFT JOIN ' . C("DB_PREFIX") . 'ask AS a ON a.aid = at.aid 
			' . $where . ' GROUP BY at.tid';
        $this->_sqlList($model, $sql, $count, $parameter, 'at.tid');
        $cate_tree = M("Ask")->order('sort asc,aid asc')->findAll();
        $this->assign("cate_tree", $cate_tree);
        $this->display();
        return;
    }
    public function index()
    {
        $where = '';
        $parameter = array();
        $user_name = trim($_REQUEST['user_name']);
        $day_time = trim($_REQUEST['day_time']);
        $status = !isset($_REQUEST['status']) ? -1 : intval($_REQUEST['status']);
        if (!empty($user_name)) {
            $this->assign("user_name", $user_name);
            $parameter['user_name'] = $user_name;
            $match_key = segmentToUnicodeA($user_name, '+');
            $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
        }
        if (!empty($day_time)) {
            $this->assign("day_time", $day_time);
            $parameter['day_time'] = $day_time;
            $day_time = strZTime($day_time);
            $where .= " AND ud.day_time = '{$day_time}'";
        }
        if ($status > -1) {
            $this->assign("status", $status);
            $parameter['status'] = $status;
            $where .= " AND ud.status = {$status}";
        } else {
            $this->assign("status", -1);
        }
        $model = M();
        if (!empty($where)) {
            $where = 'WHERE 1' . $where;
        }
        $sql = 'SELECT COUNT(ud.id) AS tcount 
			FROM ' . C("DB_PREFIX") . 'user_daren AS ud
			INNER JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ud.uid ' . $where;
        $count = $model->query($sql);
        $count = $count[0]['tcount'];
        $sql = 'SELECT ud.*,u.user_name  
			FROM ' . C("DB_PREFIX") . 'user_daren AS ud
			INNER JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ud.uid ' . $where;
        $this->_sqlList($model, $sql, $count, $parameter);
        $this->display();
    }
 public function getUserList()
 {
     $key = trim($_REQUEST['key']);
     $where = '';
     if (!empty($key)) {
         $match_key = segmentToUnicodeA($key, '+');
         $where .= " AND match(user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
         $like_name = mysqlLikeQuote($key);
         $where .= ' AND user_name LIKE \'%' . $like_name . '%\'';
     }
     $sql = 'SELECT uid,user_name FROM ' . C("DB_PREFIX") . 'user WHERE status = 1 ' . $where . ' ORDER BY uid DESC limit 0,30';
     $userList = M()->query($sql);
     echo json_encode($userList);
 }
    public function look()
    {
        $where = '';
        $parameter = array();
        $keyword = trim($_REQUEST['keyword']);
        $uname = trim($_REQUEST['uname']);
        $type = trim($_REQUEST['type']);
        $share_data = !isset($_REQUEST['share_data']) ? 'img' : trim($_REQUEST['share_data']);
        $cate_id = intval($_REQUEST['cate_id']);
        $status = !isset($_REQUEST['status']) ? 0 : intval($_REQUEST['status']);
        $inner_sql = '';
        $where .= " WHERE sp.type = 'look'";
        if (!empty($keyword)) {
            $this->assign("keyword", $keyword);
            $parameter['keyword'] = $keyword;
            $match_key = segmentToUnicodeA($keyword, '+');
            $where .= " AND match(sm.content_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
            $inner_sql .= 'INNER JOIN ' . C("DB_PREFIX") . 'share_match AS sm ON sm.share_id = s.share_id ';
        }
        if (!empty($uname)) {
            $this->assign("uname", $uname);
            $parameter['uname'] = $uname;
            $match_key = segmentToUnicodeA($uname, '+');
            $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
            $like_name = mysqlLikeQuote($uname);
            $where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
        }
        $model = M();
        $sql = 'SELECT COUNT(DISTINCT s.share_id) AS scount
			FROM ' . C("DB_PREFIX") . 'share_photo AS sp
			INNER JOIN ' . C("DB_PREFIX") . 'share AS s ON s.share_id = sp.share_id 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = s.uid 
			' . $inner_sql . $where;
        $count = $model->query($sql);
        $count = $count[0]['scount'];
        $sql = 'SELECT s.share_id,LEFT(s.content,80) AS content,u.user_name,s.create_time,s.collect_count,s.relay_count,			s.comment_count,s.type,s.share_data,s.status,s.is_best 
			FROM ' . C("DB_PREFIX") . 'share_photo AS sp  
			INNER JOIN ' . C("DB_PREFIX") . 'share AS s ON s.share_id = sp.share_id 
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = s.uid 
			' . $inner_sql . $where . ' GROUP BY s.share_id';
        $this->_sqlList($model, $sql, $count, $parameter, 's.share_id');
        $this->display();
    }
    public function check()
    {
        $where = '';
        $parameter = array();
        $uname = trim($_REQUEST['uname']);
        $mid = intval($_REQUEST['mid']);
        if (!empty($uname)) {
            $this->assign("uname", $uname);
            $parameter['uname'] = $uname;
            $match_key = segmentToUnicodeA($uname, '+');
            $where .= " AND match(u.user_name_match) against('" . $match_key . "' IN BOOLEAN MODE) ";
            $like_name = mysqlLikeQuote($uname);
            $where .= ' AND u.user_name LIKE \'%' . $like_name . '%\'';
        }
        if ($mid > 0) {
            $this->assign("mid", $mid);
            $parameter['mid'] = $mid;
            $where .= " AND ma.mid = {$mid}";
        }
        if (!empty($where)) {
            $where = ' WHERE' . $where;
            $where = str_replace('WHERE AND', 'WHERE', $where);
        }
        $model = M();
        $sql = 'SELECT COUNT(DISTINCT ma.id) AS scount
			FROM ' . C("DB_PREFIX") . 'medal_apply AS ma 
			LEFT JOIN ' . C("DB_PREFIX") . 'medal AS m ON m.mid = ma.mid  
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ma.uid 
			' . $where;
        $count = $model->query($sql);
        $count = $count[0]['scount'];
        $sql = 'SELECT ma.id,ma.reason,ma.create_time,u.user_name,m.name,m.image,m.give_type 
			FROM ' . C("DB_PREFIX") . 'medal_apply AS ma 
			LEFT JOIN ' . C("DB_PREFIX") . 'medal AS m ON m.mid = ma.mid  
			LEFT JOIN ' . C("DB_PREFIX") . 'user AS u ON u.uid = ma.uid 
			' . $where;
        $this->_sqlList($model, $sql, $count, $parameter, 'ma.id');
        $medal_list = D('Medal')->where('status = 1 AND give_type = 1')->order('sort asc')->findAll();
        $this->assign("medal_list", $medal_list);
        $this->display();
    }