0) { $outPut = ""; } return $outPut; } function menuTreeNodeList ($selItem = "", $list) { GLOBAL $conn; $outPut = ""; $list .= "— "; $outPut .= ""; $Query = "SELECT * FROM ".TABLE_MENU." WHERE ParentId = '".$selItem."' AND Visible = '1' ORDER by ItemPos ASC"; $query = mysqli_query($conn, $Query); $totRecords = mysqli_num_rows($query); while ($item = mysqli_fetch_array($query)) { $outPut .= "".$item['ID']."".$list." ".getMenuName($item['ID'])."".$item['ItemPos']."".menuTreeCheck($item['ID']).""; $outPut .= menuTreeNodeList($item['ID'], $list); } return $outPut; } function getMenuTreeFinalList ($offset, $rowsPerPage) { GLOBAL $conn; $outPut = ""; $count = 0; $list = ""; $Query = "SELECT * FROM ".TABLE_MENU." WHERE ParentId = 0 AND Visible = '1' ORDER by ItemPos ASC, ParentId, ID ASC LIMIT $offset, $rowsPerPage"; $query = mysqli_query($conn, $Query); while ($item = mysqli_fetch_array($query)) { $count++; if($count % 2) { $rows = 'row0'; } else { $rows = 'row1'; } $outPut .= "".$item['ID']."".getMenuName($item['ID'])."".$item['ItemPos']."".menuTreeCheck($item['ID']).""; $outPut .= menuTreeNodeList($item['ID'], $list); } return $outPut.""; } $xtpl->assign('treeMenu', getMenuTreeFinalList($offset, $rowsPerPage)); $QueryNav = "SELECT COUNT(ID) AS numrows FROM ".TABLE_MENU." WHERE ParentId = 0 AND Visible = '1'"; $queryNav = mysqli_query($conn, $QueryNav); $infoNav = mysqli_fetch_array($queryNav); $numrows = (int)$infoNav['numrows']; if($numrows > $rowsPerPage) { $maxPage = ceil($numrows/$rowsPerPage); $xtpl->assign('nav', getNav($pageNum, $numrows, $maxPage)); $xtpl->parse('main.viewNav'); } $xtpl->parse('main'); $xtpl->out('main'); require_once("../../footer.php"); ?>