$value){ $eventclass = explode("|",$value); $offlineclass[$eventclass[0]] = $eventclass[1]; } $tmp = explode("\n",$_G['cache']['plugin']['xj_event']['event_online_class']); $onlineclass = array(); foreach($tmp as $key=>$value){ $eventclass = explode("|",$value); $onlineclass[$eventclass[0]] = $eventclass[1]; } $perpage = 10; //每页数 if($_GET['act']=='cj'){ $listcount = DB::result_first("SELECT count(*) FROM ".DB::table('xj_eventapply')." A,".DB::table('xj_event')." B,".DB::table('forum_thread')." C WHERE A.tid=B.tid and B.tid=C.tid and A.uid=".intval($_G['uid'])); $page = $_GET['page']?$_GET['page']:1; //if(@ceil($listcount/$perpage) < $page) { // $page = 1; //} $start_limit = ($page - 1) * $perpage; $query = DB::query("SELECT * FROM ".DB::table('xj_eventapply')." A,".DB::table('xj_event')." B,".DB::table('forum_thread')." C WHERE A.tid=B.tid and B.tid=C.tid AND A.uid=".intval($_G['uid'])." ORDER BY B.eid DESC LIMIT $start_limit,$perpage"); }elseif($_GET['act']=='zz'){ $listcount = DB::result_first("SELECT count(*) FROM ".DB::table('xj_event')." A,".DB::table('forum_thread')." B WHERE A.tid=B.tid and B.authorid=".intval($_G['uid'])." ORDER BY A.eid"); $page = $_GET['page']?$_GET['page']:1; //if(@ceil($listcount/$perpage) < $page) { // $page = 1; //} $start_limit = ($page - 1) * $perpage; $query = DB::query("SELECT * FROM ".DB::table('xj_event')." A,".DB::table('forum_thread')." B WHERE A.tid=B.tid and B.authorid=".intval($_G['uid'])." ORDER BY A.eid DESC LIMIT $start_limit,$perpage"); } $toplist = array(); while($value = DB::fetch($query)){ $value['subject'] = cutstr($value['subject'],50); //获取报名人数 $value['zynumber'] = DB::result_first("SELECT count(*) FROM ".DB::table('xj_eventthread')." WHERE eid=".$value['eid']); $value['applynumber'] = DB::result_first("SELECT SUM(applynumber) FROM ".DB::table('xj_eventapply')." WHERE tid=".$value['tid']." and verify=1"); $value['applynumber'] = $value['applynumber']?$value['applynumber']:0; $value['activityaid_url'] = $value['activityaid']?getforumimg($value['activityaid'],0,80,80):'static/image/common/nophoto.gif'; $value['starttime'] = date('Y-m-d',$value['starttime']); $value['message'] = DB::result_first("SELECT message FROM ".DB::table('forum_post')." WHERE tid=".$value['tid']); $value['message'] = messagecutstr($value['message'],50); $value['setting'] = unserialize($value['setting']); $toplist[] = $value; } if($_GET['output']=='json'){ foreach($toplist as $key=>$value){ if($value['setting']['eventaa']){ $toplist[$key]['use_cost_str'] = 'AA'; }else{ if($value['use_cost']>0){ $toplist[$key]['use_cost_str'] = $value['use_cost'].lang('plugin/xj_event', 'yuan'); }else{ $toplist[$key]['use_cost_str'] = lang('plugin/xj_event', 'mianfei'); } } if($value['postclass']==1){ $toplist[$key]['postclass'] = lang('plugin/xj_event', 'xianxia'); }else{ $toplist[$key]['postclass'] = lang('plugin/xj_event', 'xianshan'); } if($value['postclass']==1){ $toplist[$key]['zclass'] = $offlineclass[$value['offlineclass']]; }else{ $toplist[$key]['zclass'] = $onlineclass[$value['onlineclass']]; } if($_G['charset']=='gbk'){ $toplist[$key]['subject'] = iconv("GBK", "UTF-8", $value['subject']); $toplist[$key]['zclass'] = iconv("GBK", "UTF-8", $toplist[$key]['zclass']); $toplist[$key]['postclass'] = iconv("GBK", "UTF-8", $toplist[$key]['postclass']); $toplist[$key]['use_cost_str'] = iconv("GBK", "UTF-8", $toplist[$key]['use_cost_str']); } } exit(json_encode($toplist)); } ?>