db_Select("links", "*", "ORDER BY link_order ASC", "nowhere"); // get main category links
$linkArray = $sql->db_getList();
// all main links now held in array, we now need to loop through them and assign the sublinks to the correct parent links ...
$mainLinkArray = array();
foreach($linkArray as $links) {
extract ($links);
if (check_class($link_class)) {
if (!strstr($link_name, "submenu")) {
// main link - add to main array ...
$mainLinkArray[$link_name]['id'] = $link_id;
$mainLinkArray[$link_name]['name'] = strip_tags($link_name);
$mainLinkArray[$link_name]['url'] = $link_url;
$mainLinkArray[$link_name]['description'] = $link_description;
$mainLinkArray[$link_name]['image'] = $link_button;
$mainLinkArray[$link_name]['openMethod'] = $link_open;
$mainLinkArray[$link_name]['class'] = $link_class;
} else {
// submenu - add to parent's array entry ...
list($null, $parent_name, $submenu_name) = explode(".", $link_name);
// get parent name ...
$mainLinkArray[$parent_name]['sublink'][$link_id]['parent_name'] = $parent_name;
$mainLinkArray[$parent_name]['sublink'][$link_id]['id'] = $link_id;
$mainLinkArray[$parent_name]['sublink'][$link_id]['name'] = strip_tags($submenu_name);
$mainLinkArray[$parent_name]['sublink'][$link_id]['url'] = $link_url;
$mainLinkArray[$parent_name]['sublink'][$link_id]['description'] = $link_description;
$mainLinkArray[$parent_name]['sublink'][$link_id]['image'] = $link_button;
$mainLinkArray[$parent_name]['sublink'][$link_id]['openMethod'] = $link_open;
$mainLinkArray[$parent_name]['sublink'][$link_id]['class'] = $link_class;
}
}
}
// ok, now all mainlinks and sublinks are held in the array, now we have to loop through and build the text to send to screen ...
$text = "";
foreach($mainLinkArray as $links) {
extract ($links);
if (array_key_exists("sublink", $links) && $links['name'] != "") {
// sublinks found ...
$url = "javascript:void(0);";
$spanName = str_replace(" ", "_", $name);
$image = ($image ? "" : "»");
$plink = "