function onCommonGetNavs($type = '') { switch ($type) { case 'footer': $navtype = 1; break; case 'space': $navtype = 2; break; case 'my': $navtype = 3; break; case 'header': $navtype = 0; break; } $navs = array(); $sql = "SELECT * FROM " . DB::table('common_nav'); if ($type) { $sql .= " WHERE navtype = '{$navtype}'"; } $sql .= ' ORDER BY displayorder'; $query = DB::query($sql); $navs = $subNavs = array(); while ($nav = DB::fetch($query)) { if (!$nav['parentid']) { $navs[$nav['id']] = SearchHelper::convertNav($nav); } else { $subNavs[$nav['id']] = $nav; } } foreach ($subNavs as $k => $v) { $navs[$v['parentid']]['navs'][$v['id']] = SearchHelper::convertNav($v); } return $navs; }