{php}> global $xoopsDB,$xoopsTpl; $sql = "select `menu_sn` from ".$xoopsDB->prefix('ugm_page_menu')." where `menu_type`='4' and `menu_enable`='1' and `menu_ofsn`='0' order by `menu_sort` limit 1 ";//die($sql); $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error()); list($menu_sn)=$xoopsDB->fetchRow($result); if($menu_sn){ $main= get_ugm_page_tpl_theme_menu_body($menu_sn); //print_r($main);die(); $xoopsTpl->assign('ugm_page_menu',$main); // $xoopsTpl->assign('ugm_page_menu_ofsn',$menu_sn); } function get_ugm_page_tpl_theme_menu_body($menu_ofsn=0,$level=0){ global $xoopsDB; $sql = "select * from ".$xoopsDB->prefix('ugm_page_menu')." where `menu_type`='4' and `menu_enable`='1' and `menu_ofsn`='{$menu_ofsn}' order by `menu_sort` ";//die($sql); $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error()); $total=$xoopsDB->getRowsNum($result); #記錄筆數 if($total==0)return; while($all=$xoopsDB->fetchArray($result)){ //以下會產生這些變數: `menu_sn`, `menu_type`, `menu_ofsn`, `menu_sort`, `menu_title`, `menu_op`, `menu_tip`, `menu_enable`, `menu_new`, `menu_url`, `menu_date`, `menu_uid` foreach($all as $k=>$v){ $$k=$v; } if($level==0){ $sub2=get_ugm_page_tpl_theme_menu_body($menu_sn,1); $menu_new=$menu_new?" target='_blank'":""; if($sub2){ # ----有第2層 ---- $main.="