notorm->slide_item ->select("image as slide_pic,url as slide_url") ->where($where) ->order("list_order asc") ->fetchAll(); foreach($rs as $k=>$v){ $rs[$k]['slide_pic']=get_upload_path($v['slide_pic']); } return $rs; } /* 热门主播 */ public function getHot($p) { if($p<1){ $p=1; } $pnum=50; $start=($p-1)*$pnum; $where=" islive= '1' "; if($p==1){ $_SESSION['hot_starttime']=time(); $hotvotes=DI()->notorm->live->where("islive= '1'")->max('hotvotes'); $_SESSION['hot_hotvotes']=$hotvotes; } if($p>1){ $endtime=$_SESSION['hot_starttime']; if($endtime){ $where.=" and starttime < {$endtime}"; } $hotvotes=$_SESSION['hot_hotvotes']; if($hotvotes>0){ $where.=" and hotvotes < {$hotvotes}"; }else{ $where.=" and hotvotes = 0"; } } $result=DI()->notorm->live ->select($this->live_fields.',hotvotes') ->where($where) ->order('hotvotes desc,starttime desc') ->limit($start,$pnum) ->fetchAll(); foreach($result as $k=>$v){ $v=handleLive($v); $result[$k]=$v; } if($result){ $last=end($result); $_SESSION['hot_starttime']=$last['starttime']; $_SESSION['hot_hotvotes']=$last['hotvotes']; } return $result; } /* 搜索 */ public function search($uid,$key,$p) { if($p<1){ $p=1; } $pnum=50; $start=($p-1)*$pnum; $where=' user_type="2" and ( id=? or user_nicename like ? ) and id!=?'; if($p!=1){ $id=$_SESSION['search']; if($id){ $where.=" and id < {$id}"; } } $result=DI()->notorm->user ->select("id,user_nicename,avatar,sex,signature,consumption,votestotal") ->where($where,$key,'%'.$key.'%',$uid) ->order("id desc") ->limit($start,$pnum) ->fetchAll(); foreach($result as $k=>$v){ $v['level']=(string)getLevel($v['consumption']); $v['level_anchor']=(string)getLevelAnchor($v['votestotal']); $v['avatar']=get_upload_path($v['avatar']); unset($v['consumption']); $result[$k]=$v; } if($result){ $last=end($result); $_SESSION['search']=$last['id']; } return $result; } /* 分类下直播 */ public function getClassLive($liveclassid,$p) { if($p<1){ $p=1; } $pnum=50; $start=0; $where=" islive='1' and liveclassid={$liveclassid}"; if($p!=1){ $endtime=$_SESSION['getClassLive_starttime']; if($endtime){ $where.=" and starttime < {$endtime}"; } } $last_starttime=0; $result=DI()->notorm->live ->select($this->live_fields) ->where($where) ->order("starttime desc") ->limit(0,$pnum) ->fetchAll(); foreach($result as $k=>$v){ $v=handleLive($v); $result[$k]=$v; } if($result){ $last=end($result); $_SESSION['getClassLive_starttime']=$last['starttime']; } return $result; } }