Improved SiteMap Display

[clydejones]

Hey, Clyde

Thank you for your instructions. I copied and modified the code( below) from information.php then added them to tpl_site_map_default.php. Now, the site map looks just as I want.

<?php if (DEFINE_ABOUT_US_STATUS <= 1) {?>
<li><?php echo '<a href="' . zen_href_link(FILENAME_ABOUT_US) . '">' . BOX_INFORMATION_ABOUT_US . '</a>'; ?></li>
<?php } ?>

Thanks again,

glad you got it working

[g_force]

I haven't downloaded this mod yet but it sounds interesting..

I first wanted to ask if it can segment categories into columns of their own..

_thanks

[clydejones]

I haven't downloaded this mod yet but it sounds interesting..

I first wanted to ask if it can segment categories into columns of their own..

_thanks

no

You can style the page any way you want

[g_force]

oh thanks.. I'm just trying to find out how right now..

[DivaVocals]

I hope someone can help.. I'm using the Hidden Categories add-on, and my hidden categories and products are showing up on the Improved SiteMap.. I was trying to figure out how to add code from the Hidden Categories add-on code to the "classes/site_map.php" and BOY am I really confused..

I think this is the code I need to add to the site map.. I just haven't a clue how to integrate it into the site map file. I thought (hoped) that this would be something I could figure out on my own, but alas I'm stuck..

//  Begin hideCategories code
    list($nada, $mycpath)= split('=', $box_categories_array[$i]['path']);
    $mycid = split('_', $mycpath);
    $categories_id = array_pop($mycid);
    $hide_status = $db->Execute("select visibility_status 
                    FROM " . TABLE_HIDE_CATEGORIES . "
                    WHERE categories_id = " . $categories_id . "
                    LIMIT 1");
    if ($hide_status->fields['visibility_status'] < 1) {
//  End hideCategories code

So here's my question/plea for help.. I'm hoping that I could get some assistance in how to add the right code to hide the hidden categories from the site. (That would make me a very a happy camper..)

However, the alternate is finding out how to hide a specific list of categories from the site map. Either one would get me what I want.. (Obviously the first is the better solution because it will work with the Hidden Categories add-on.. but I'll settle for some assistance and a working solution )

Can anybody offer a helping hand??

[DivaVocals]

Found my answer BURIED in the Hidden Categories support thread (1.5 year old post too!).. Thought I'd post it here for anyone using both of these add-ons..

http://www.zen-cart.com/forum/showpo...2&postcount=94

So far this solution seems to be working just fine.. I've only done some VERY quick testing. This particular store only has one hidden product, so I still have to test if it works with more than one hidden product (looking at the query in the code it should work just fine with any number of hidden categories) I still suggest anyone doing this should do their own testing..

I hope someone can help.. I'm using the Hidden Categories add-on, and my hidden categories and products are showing up on the Improved SiteMap.. I was trying to figure out how to add code from the Hidden Categories add-on code to the "classes/site_map.php" and BOY am I really confused..

I think this is the code I need to add to the site map.. I just haven't a clue how to integrate it into the site map file. I thought (hoped) that this would be something I could figure out on my own, but alas I'm stuck..

//  Begin hideCategories code
    list($nada, $mycpath)= split('=', $box_categories_array[$i]['path']);
    $mycid = split('_', $mycpath);
    $categories_id = array_pop($mycid);
    $hide_status = $db->Execute("select visibility_status 
                    FROM " . TABLE_HIDE_CATEGORIES . "
                    WHERE categories_id = " . $categories_id . "
                    LIMIT 1");
    if ($hide_status->fields['visibility_status'] < 1) {
//  End hideCategories code

So here's my question/plea for help.. I'm hoping that I could get some assistance in how to add the right code to hide the hidden categories from the site. (That would make me a very a happy camper..)

However, the alternate is finding out how to hide a specific list of categories from the site map. Either one would get me what I want.. (Obviously the first is the better solution because it will work with the Hidden Categories add-on.. but I'll settle for some assistance and a working solution )

Can anybody offer a helping hand??

[g_force]

OK - I give up how do I style the sitemap?? - I'm trying to put each category (with sub-categories) into separate columns with three columns on the page (6 categories in all).. I've looked at sitemap.php and category_tree.php and had an extensive play around but I'm still not sure the exact way of doing it...

Help here would be hugely appreciated!

_thanks to anyone heading the call!!

[DivaVocals]

Another question.. My inactive products are showing up on my sitemap.. Anyone have a clue what I need to do to make sure these don't display??

[DivaVocals]

Another question.. My inactive products are showing up on my sitemap.. Anyone have a clue what I need to do to make sure these don't display??

Okay.. so I know this is the query I need to modify.. I am just not entirely sure how to make the correct edits.. Can anyone help??

$categories_query = "select c.categories_id, cd.categories_name, c.parent_id
    from " . TABLE_CATEGORIES . " c LEFT JOIN "
    . TABLE_HIDE_CATEGORIES . " h ON (c.categories_id = h.categories_id), "
    . TABLE_CATEGORIES_DESCRIPTION . " cd
    where (h.visibility_status < 2 OR h.visibility_status IS NULL)
    and c.categories_id = cd.categories_id
    and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
    and c.categories_status != '0'
    order by c.parent_id, c.sort_order, cd.categories_name";

[DivaVocals]

So I tried this, and still no dice.. All of my inactive products still show up on the site map.. **sigh** I am stumped..

$categories_query = "select c.categories_id, cd.categories_name, c.parent_id, p.products_status 
    from " . TABLE_CATEGORIES . " c LEFT JOIN "
    . TABLE_HIDE_CATEGORIES . " h ON (c.categories_id = h.categories_id), "
    . TABLE_CATEGORIES_DESCRIPTION . " cd, "
    . TABLE_PRODUCTS . " p
    where (h.visibility_status < 2 OR h.visibility_status IS NULL)
    and c.categories_id = cd.categories_id
    and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
    and c.categories_status != '0'
    and p.products_status != '0'
    order by c.parent_id, c.sort_order, cd.categories_name, p.products_status";