选择筛选,使用Use_Showreply,或用搜索语进行搜索时 if($s_que) { $_dbTimeStart = getmicrotime(); $que="select * from $t_board"."_$id $s_que order by $select_arrange $desc limit $start_num, $page_num"; $result=mysql_query($que,$connect) or Error(mysql_error()); $_dbTime += getmicrotime()-$_dbTimeStart; } // 没有搜索条件时:现状 -> 一般排序,或具备排序标准,或DESC,ASC时. else { // 无搜索条件,按headnum排序时;;即一般排序时;; if ($select_arrange=="headnum"&&$desc=="asc") { while($division_data=mysql_fetch_array($division_result)) { $sum=$sum+$division_data[num]; $division=$division_data[division]; if($sum>=$start_num) { $start_num=$start_num-($sum-$division_data[num]); $_dbTimeStart = getmicrotime(); $que="select * from $t_board"."_$id where division='$division' and headnum<0 order by headnum,arrangenum limit $start_num, $page_num"; $result=mysql_query($que) or error(mysql_error()); $_dbTime += getmicrotime()-$_dbTimeStart; $check1=1; $returnNum = mysql_num_rows($result); if($returnNum>=$page_num) { break; } else { if($division>1) { $division--; $minus=$page_num-$returnNum; $_dbTimeStart = getmicrotime(); $que2="select * from $t_board"."_$id where division=$division and headnum!=0 order by headnum,arrangenum limit $minus"; $result2=mysql_query($que2) or error(mysql_error()); $_dbTime += getmicrotime()-$_dbTimeStart; $check2=1; break; } } } } } // 虽然没有搜索条件,但生成排序值时;;; ////////////////////////////// else { $que="select * from $t_board"."_$id $s_que order by $select_arrange $desc $add_on limit $start_num, $page_num"; $_dbTimeStart = getmicrotime(); $result=mysql_query($que,$connect) or Error(mysql_error()); $_dbTime += getmicrotime()-$_dbTimeStart; } } // 管理员时移动论坛版块的帖子,所以显示论坛版块表;; if($is_admin) { $_dbTimeStart = getmicrotime(); $board_result=mysql_query("select no,name from $admin_table where no!='$setup[no]'"); $_dbTime += getmicrotime()-$_dbTimeStart; } /*************************************************************************** * 整理在SKIN使用的页面 **************************************************************************/ $print_page=""; $show_page_num=$setup[page_num]; // 一次要显示的页数 $start_page=(int)(($page-1)/$show_page_num)*$show_page_num; $i=1; $a_1_prev_page= "1) $a_1_prev_page=""; if($page<$total_page) $a_1_next_page=""; if($page>$show_page_num) { $prev_page=$start_page; $a_prev_page=""; $print_page.="[1].."; $prev_page_exists = true; } while($i+$start_page<=$total_page&&$i<=$show_page_num) { $move_page=$i+$start_page; if($page==$move_page) $print_page.=" $move_page "; else $print_page.="[$move_page]"; $i++; } if($total_page>$move_page) { $next_page=$move_page+1; $a_next_page=""; $print_page.="..[$total_page]"; $next_page_exists = true; } // 搜索时表示Divsion页面的移动 if($use_division) { if($prevdivpage&&!$prev_page_exists) $a_div_prev_page="[前面结果]..."; if($nextdivpage&&!$next_page_exists) $a_div_next_page="...[後面结果]"; $print_page = $a_div_prev_page.$print_page.$a_div_next_page; } /*************************************************************************** * 提前指定各种连接的部分 **************************************************************************/ // 发表帖子按钮 if($is_admin||$member[level]<=$setup[grant_write]) $a_write=""; else $a_write="-2000000000) {include $dir."/list_main.html";} else {include $dir."/list_notice.html"; } $_skinTime += getmicrotime()-$_skinTimeStart; $loop_number--; } if($check2) { while($data=@mysql_fetch_array($result2)) { list_check(&$data); $_skinTimeStart = getmicrotime(); if($data[headnum]>-2000000000) {include $dir."/list_main.html";} else {include $dir."/list_notice.html"; } $_skinTime += getmicrotime()-$_skinTimeStart; $loop_number--; } } // 输出结尾部分;; $_skinTimeStart = getmicrotime(); include $dir."/list_foot.html"; $_skinTime += getmicrotime()-$_skinTimeStart; if($zbLayer) { $_skinTimeStart = getmicrotime(); echo "\n"; unset($zbLayer); $_skinTime += getmicrotime()-$_skinTimeStart; } foot(); /*************************************************************************** * 结尾部分include **************************************************************************/ include "_foot.html"; ?>