1、齐博CMS:前台显示全部栏目的办法(支持多级分类和栏目) for v6 这是效果图: 先在do目录下新建allsort.php,代码如下: 1 复制代码only=$only; 6 $Guidedb->mid=$mid; 7 8 $fi
2、d=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
3、 $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("SEL
4、ECT 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->ge
5、t_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/f
6、oot.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
7、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($
8、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
9、getnum); 60 } 61 } 62 ?> 再在template/default目录下新建allsort.htm,代码如下: 63 复制代码 67
|
70 10、
$showpage
135 |
136






