Hide category links in CSS Flyout Menu without disabling them

[Joseph M]

v157c with Bootstrap template.
I've installed the CSS Flyout Menu, and it's working great. However, I need to remove or hide some of the main category links that are duplicates of those featured in my header navigation.
How do I remove the unwanted categories from the CSS Flyout Menu without deactivating the categories in my shop?

[DrByte]

It might work by editing the categories_ul_generator.php file by adding the additional AND statement as shown:

    function __construct($load_from_database = true)
    {
        global $db;
        $this->data = array();
        $categories_query = "SELECT c.categories_id, cd.categories_name, c.parent_id
                             FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                             WHERE c.categories_id = cd.categories_id
                             AND c.categories_status = 1
                             AND cd.language_id = " . (int)$_SESSION['languages_id'] . "
                     AND c.categories_id NOT IN (5,6,7,8)
                             ORDER BY c.parent_id, c.sort_order, cd.categories_name";
        $categories = $db->Execute($categories_query);

and substituting your own comma-separated list of category id numbers in place of 5,6,7,8

[Joseph M]

It might work by editing the categories_ul_generator.php file by adding the additional AND statement as shown:

    function __construct($load_from_database = true)
    {
        global $db;
        $this->data = array();
        $categories_query = "SELECT c.categories_id, cd.categories_name, c.parent_id
                             FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                             WHERE c.categories_id = cd.categories_id
                             AND c.categories_status = 1
                             AND cd.language_id = " . (int)$_SESSION['languages_id'] . "
                     AND c.categories_id NOT IN (5,6,7,8)
                             ORDER BY c.parent_id, c.sort_order, cd.categories_name";
        $categories = $db->Execute($categories_query);

and substituting your own comma-separated list of category id numbers in place of 5,6,7,8

Yes, that's it! It works better than I hoped since it can be applied to multiple level subcategories too. Brilliant, DrByte. Thank you!