=0"); $page = $_GET['page']?$_GET['page']:1; if(@ceil($listcount/$perpage) < $page) { $page = 1; } $start_limit = ($page - 1) * $perpage; $multipage = multi($listcount,$perpage,$page,"plugin.php?id=xj_event:event_threadlist&eid=$eid&order=".$_GET['order'],0,10,false,true); $multipage = str_replace('class="pg"','class="jlpg"',$multipage); $sqlorder = 'B.lastpost DESC'; if($_GET['order']=='tp'){ $sqlorder = 'A.votes DESC'; }elseif($_GET['order']=='dj'){ $sqlorder = 'B.views DESC'; }elseif($_GET['order']=='hf'){ $sqlorder = 'B.replies DESC'; }elseif($_GET['order']=='sj'){ $sqlorder = 'B.dateline DESC'; } $query = DB::query("SELECT * FROM ".DB::table('xj_eventthread')." A,".DB::table('forum_thread')." B WHERE A.tid = B.tid and A.eid = '$eid' AND B.displayorder>=0 ORDER BY ".$sqlorder." LIMIT $start_limit,$perpage"); $threadlist = array(); while($value = DB::fetch($query)){ $value['avatar'] = ''; $value['strdateline'] = dgmdate($value['dateline'],'dt'); $threadlist[] = $value; } include template('xj_event:threadlist'); ?>