class plugin_bullmarket_onlinetime { function plugin_bullmarket_onlinetime() { } }class plugin_bullmarket_onlinetime_forum{ function viewthread_sidebottom_output($a) { global $_G, $postlist; $result=array(); //根據應用審核員返回結果，現對數據庫查詢進行優化，增加一次循環，用于將$postlist中的pid篩選為一維數組,以減少查詢次數, //將分次查詢改成單次查詢，且改為聯合查詢 $pidlist=array(); foreach($postlist as $pids) { array_push($pidlist,$pids['pid']); } $totallist=DB::fetch_all("select total from ".DB::table("common_onlinetime ")." left join ".DB::table("forum_post ")." on ".DB::table("common_onlinetime ").".uid"."=".DB::table("forum_post ").".authorid where pid IN (%n)",array($pidlist)); for($i=0;$i<count($postlist);$i++) { $total=empty($totallist[$i]['total'])?"0":$totallist[$i]['total']; array_push($result,'<dl class="pil cl"><dt>'.lang('plugin/bullmarket_onlinetime', 's001') .'</dt><dd style="color:#F00">'.$total.lang('plugin/bullmarket_onlinetime', 's002').'</dd></dl>'); } return $result; }}