齐博CMS：前台显示全部栏目办法(支持多级分类及栏目)-for-v6.doc

齐博CMS：前台显示全部栏目的办法（支持多级分类和栏目） for v6
这是效果图：

先在do目录下新建allsort.php，代码如下：

1 复制代码<?php
2 require_once(dirname(__FILE__)."/"."global.php");
3 require_once(dirname(__FILE__)."/"."../inc/class.inc.php");
4 $Guidedb=new Guide_DB;
5 $Guidedb->only=$only;
6 $Guidedb->mid=$mid;
7
8 $fid=intval($fid);
9
10 $sortdb=array();
11 if( count($Fid_db[name])>200||$fid ){
12 $rows=50;
13 $page<1 && $page=1;
14 $min=($page-1)*$rows;
15 $showpage=getpage("{$pre}sort","WHERE fup='$fid'","allsort.php?only=$only&mid=$mid&fid=$fid",$rows);
16 $query = $db->query("SELECT * FROM {$pre}sort WHERE fup='$fid' ORDER BY list DESC,fid ASC LIMIT $min,$rows");
17 while($rs = $db->fetch_array($query)){
18 if(!$rs[type]){
19 $erp=$Fid_db[iftable][$rs[fid]];
20 @extract($db->get_one("SELECT COUNT(*) AS NUM FROM {$pre}article$erp WHERE fid='$rs[fid]'"));
21 $rs[NUM]=intval($NUM);
22 }
23 $sortdb[]=$rs;
24 }
25 }else{
26 list_allsort($fid,'sort',1);
27 }
28
29 if($fid){
30 $rsdb=$db->get_one(" SELECT * FROM {$pre}sort WHERE fid='$fid' ");
31 }
32 $sort_fup=$Guidedb->Select("{$pre}sort","fup",$fid);
33 $article_show_step[$webdb[article_show_step]]='red;';
34 require(PHP168_PATH."inc/head.php");
35 require(html("allsort"));
36 require(PHP168_PATH."inc/foot.php");
37 /*栏目列表*/
38 function list_allsort($fid,$table='sort',$getnum=''){
39 global $db,$pre,$sortdb,$Fid_db;
40 $query=$db->query("SELECT * FROM {$pre}$table where fup='$fid' ORDER BY list DESC");
41 while( $rs=$db->fetch_array($query) ){
42 $icon="";
43 for($i=1;$i<$rs['class'];$i++){
44 $icon.=" | ";
45 }
46 if($icon){
47 $icon=substr($icon,0,-24);
48 $icon.="--";
49 }
50 $rs[config]=unserialize($rs[config]);
51 $rs[icon]=$icon;
52 $NUM=0;
53 if($getnum&&!$rs[type]){
54 $erp=$Fid_db[iftable][$rs[fid]];
55 @extract($db->get_one("SELECT COUNT(*) AS NUM FROM {$pre}article$erp WHERE fid='$rs[fid]'"));
56 $rs[NUM]=intval($NUM);
57 }
58 $sortdb[]=$rs;
59 list_allsort($rs[fid],$table,$getnum);
60 }
61 }
62 ?>

再在template/default目录下新建allsort.htm，代码如下：
63 复制代码<!--
64 <?php
65 print<<<EOT
66 -->
67 <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="MainTable">
68 <tr>
69 <td bgcolor=#FFFFFF align="left">
70 <table width="100%" border="0" cellspacing="0" cellpadding="0" class="guide">
71 <tr align="center" class="head">
72 <td width="6%" style="border-right:1px solid #fff;">FID</td>
73 <td width="81%" style="border-right:1px solid #fff;">栏目名称</td>
74 <td width="6%" style="border-right:1px solid #fff;">类型</td>
75 <td width="7%" style="border-right:1px solid #fff;">记录</td>
76 </tr>
77 <!--
78 EOT;
79 foreach($sortdb AS $key=>$rs){
80 if($only&&$rs[fmid]!=$mid){continue;}
81 $tr_class='';
82 print <<<EOT
83 -->
84 <tr class="trA $tr_class" onmouseover="this.className='trB $tr_class'" onmouseout="this.className='trA $tr_class'">
85 <td width="6%" bgcolor="#FFFFFF" align="center" style="border-bottom:1px dotted #ccc;"><b><font color="#FF0000">$rs[fid]</font></b></td>
86 <td width="81%" bgcolor="#FFFFFF" style="border-bottom:1px dotted #ccc;">
87 <a href="$webdb[www_url]/do/rss.php?fid=$rs[fid]" target="_blank"><img src="$webdb[www_url]/images/default/rss.gif" border="0"></a>
88 $rs[icon]【<a href='$webdb[www_url]/list.php?fid=$rs[fid]' target="_blank">{$rs[name]}</a>】<span class='sort_span'></span></td>
89
90 <td width="6%" bgcolor="#FFFFFF" style="border-bottom:1px dotted #ccc;" align="center" class="big_sort">
91 <!--
92 EOT;
93 if($rs[type]==2){print <<<EOT
94 -->
95 <font color="#0000FF">文章</font>
96 <!--
97 EOT;
98 }elseif($rs[type]==1){print <<<EOT
99 -->
100 大分类
101 <!--
102 EOT;
103 }else{print <<<EOT
104 -->
105 子栏目
106 <!--
107 EOT;
108 }print <<<EOT
109 -->
110 </td>
111 <td width="7%" bgcolor="#FFFFFF" align="center" style="border-bottom:1px dotted #ccc;">
112 <!--
113 EOT;
114 if(!$rs[type]){print <<<EOT
115 -->
116 {$rs[NUM]}条
117 <!--
118 EOT;
119 }else{print <<<EOT
120 -->
121
122 <!--
123 EOT;
124 }print <<<EOT
125 -->
126 </td>
127
128
129 </tr>
130 <!--
131 EOT;
132 }print <<<EOT
133 -->
134 </table><div align="center" style="margin:10px;">$showpage</div>
135 </td>
136 </tr>
137 </table>
138 <!--
139 EOT;
140 ?>
141 -->

查看全部栏目路径：http://v6整站/do/allsort.php