0) {
$sql = "SELECT nav_name, nav_link, nav_link_desc FROM navigation WHERE nav_id = '$nv_nav_parent_id' ORDER BY nav_sequence";
$result = mysqli_query($conn,$sql);
$row = mysqli_fetch_array($result, MYSQL_ASSOC);
$navparent_name = $row["nav_name"];
$navparent_link_desc = $row["nav_link_desc"];
$navparent_link = $row["nav_link"];
if ($projcat_id > 0) {
$sql2 = "SELECT projcat_id, projcat_name, projcat_link_desc FROM project_categories WHERE projcat_hide = 'N' ORDER BY projcat_sequence";
$result2 = mysqli_query($conn,$sql2);
if (mysqli_num_rows($result2)>0) {
print "
\n";
print "
\n";
print "
".$navparent_name."
";
print "
\n";
while ($row2 = mysqli_fetch_array($result2, MYSQL_ASSOC)) {
$projcat_id2 = $row2["projcat_id"];
$projcat_name2 = $row2["projcat_name"];
$projcat_link_desc2 = $row2["projcat_link_desc"];
if ($cfg_clean_urls) {
$href_link = $navparent_link_desc."/".$projcat_link_desc2;
} else {
$href_link = "projects_featured.php?projcatid=".$projcat_id2."&nv=".$nv_nav_parent_id;
}
if ($projcat_id2 != $projcat_id) {
print "
".$projcat_name2."![\"divider](\"images_sub/sidenav_divider.png\")
\n";
} else {
if ($proj_id == "") {
print "
\n";
$page_title = $projcat_name2;
} else {
print "
".$projcat_name2."\n";
$sql3 = "SELECT proj_id, proj_name FROM projects WHERE proj_projcat_id = '$projcat_id2' AND proj_featured = 'Y' AND proj_hide = 'N' ORDER BY proj_sequence";
$result3 = mysqli_query($conn,$sql3);
if (mysqli_num_rows($result3)>0) {
while ($row3 = mysqli_fetch_array($result3, MYSQL_ASSOC)) {
$proj_id3 = $row3["proj_id"];
$proj_name3 = $row3["proj_name"];
if ($proj_id3 != $proj_id) {
print " -
".$proj_name3."\n";
} else {
print "
\n";
}
}
}
}
}
}
print "
\n";
print "
![\"decorative](\"images_nav/sidenav_bot_shadow.png\")
\n";
}
} else {
$sql2 = "SELECT nav_id, nav_name, nav_link, nav_link_desc, nav_pl_id FROM navigation WHERE nav_parent_id = '$nv_nav_parent_id' AND nav_hide != 'Y' ORDER BY nav_sequence";
$result2 = mysqli_query($conn,$sql2);
if (mysqli_num_rows($result2)>0) {
print "
\n";
print "
\n";
print "
".$navparent_name."
";
print "
\n";
while ($row2 = mysqli_fetch_array($result2, MYSQL_ASSOC)) {
$navchild_id = $row2["nav_id"];
$navchild_name = $row2["nav_name"];
$navchild_link = $row2["nav_link"];
$navchild_link_desc = $row2["nav_link_desc"];
$nav_pl_id = $row2["nav_pl_id"];
if (substr($navchild_link,0,11) == "product.php") { /* this section just in case the sublink is the main link to the shopping cart */
$sql23 = "SELECT prodcat_id, prodcat_name FROM product_categories WHERE prodcat_prodline_id = '$nav_pl_id' AND prodcat_hide = 'N' ORDER BY prodcat_sequence";
$result23 = mysqli_query($conn,$sql23);
if (mysqli_num_rows($result23)>0) {
while ($row23 = mysqli_fetch_array($result23, MYSQL_ASSOC)) {
$prodcat_id23 = $row23["prodcat_id"];
$prodcat_name23 = $row23["prodcat_name"];
$sql24 = "SELECT prod_id, prod_url_desc FROM products WHERE prod_prodcat_id = '$prodcat_id23' AND prod_hide != 'Y' ORDER BY prod_sequence";
$result24 = mysqli_query($conn,$sql24);
if (mysqli_num_rows($result24)>0) {
while ($row24 = mysqli_fetch_array($result24, MYSQL_ASSOC)) {
$prod_id24 = $row24["prod_id"];
$prod_url_desc24 = $row24["prod_url_desc"];
$link_query = BuildLinkQuery($navchild_id, "", $prodcat_id23, $prod_id24, "");
break;
}
}
break;
}
}
if ($cfg_clean_urls) {
$href_link = $prod_url_desc24."/".$link_query;
} else {
$href_link = $navchild_link."?product_description=".$prod_url_desc24."&product_query=".$link_query;
}
} else {
if ($cfg_clean_urls) {
if ($navchild_link_desc != "writer") { /* special code for wordpress blog link to folder 'writer' */
$href_link = $navparent_link_desc."/".$navchild_link_desc;
} else {
$href_link = $navchild_link_desc;
}
} else {
$href_link = $navchild_link;
}
}
if ($navchild_id != $nv) {
print "
".$navchild_name."\n";
} else {
print "
\n";
}
}
print "
\n";
print "
\n";
}
}
}
?>
