帝国CMS高级应用—灵动标签调用二级导航 循环子栏目和信息

帝国CMS高级应用 灵动标签调用二级导航 循环子栏目和信息:

<div class="nav">
<div class="nav">
 <div class="nav-inner">
  <div class="clearfix nav-inner" id="menu">
   <ul class="navlist">
    <li><a href="[!---news.url--]"><span>网站首页</span></a></li>
    [e:loop={"select classid,classname,islast,sonclass from {$dbtbpre}enewsclass where bclassid='0' order by myorder,classid ASC limit 11",0,24,0}]
    <?php
    $classurl=sys_ReturnBqClassname($bqr,9); //取得栏目地址
    $tbname=$class_r[$bqr[classid]][tbname]; //取得表名
    $navshow=ReturnClassAddField($bqr[classid],'nav'); //取得栏目自定义字段navshow值?>
    <li><a href="<?=$classurl?>" target="_blank"><span>
     <?=$bqr[classname]?>
     </span></a>
     <?php
     //值为0时显示二级，值为1时不显示二级
     if(!$navshow){
     //终极栏目Start
     if(!$bqr[islast]) {
     //判断是否有子栏目Start
     if($bqr[sonclass]) {
     echo '<ul>';
     //循环栏目下的子栏目Start
     $newsclass=$empire->query("select classid,classname from ".$dbtbpre."enewsclass where bclassid=".$bqr[classid]." order by myorder,classid desc limit 10");
     while($classr=$empire->fetch($newsclass)) {
     $classrurl=sys_ReturnBqClassname($classr,9); //取得子栏目地址
    ?>
    <li><a href="<?=$classrurl?>"><?=$classr[classname]?></a></li>
    <?php
    }
    //循环栏目下的子栏目End
    echo '</ul>';
    }
    //判断是否有子栏目End
    }
    //终极栏目End
     else
     //非终极栏目Start
      {
      $numinfo=$empire->gettotal("select count(*) as total from ".$dbtbpre."ecms_".$tbname." where classid=".$bqr[classid]); //统计子栏目信息
      //判断终极栏目下是否有信息Start
      if($numinfo){
      echo '<ul>';
      //循环栏目下的信息Start
      $newsinfo=$empire->query("select title,id,classid,newspath,filename,groupid,titleurl from ".$dbtbpre."ecms_".$tbname." where classid=".$bqr[classid]." order by newstime desc limit 10");
       while($infor=$empire->fetch($newsinfo)) {
       $titleurl=sys_ReturnBqTitleLink($infor);
       ?>
    <li><a href="<?=$titleurl?>"><?=$infor[title]?></a></li>
    <?php
    }
    //循环栏目下的信息End
     echo '</ul>';
     }
     //判断终极栏目下是否有信息End
     }
     //非终极栏目End
    }
    ?>
    </li>
    [/e:loop]
   </ul>
  </div>
 </div>
</div>