Gaining control over header menu

[BassFace]

I am modifying my cart (v1.3.8) to add control over which top-level categories' links show in the header menu.

So far I've:

• added a column to the categories table called 'menu_status', which will have a value of 1 or 0.
• edited the sql query in the header that retrieves the top-level categories to build the header links menu
• edited the admin/categories.php file to show a radio group (modeled after another radio group on that page) while action='edit_category', but they do not work yet

At this point I can manually edit the db 'menu_status' value 1 or 0 and control which categories show links in the header.

So my question - where are the sql queries for admin/categories.php that select and update a category when editing?

Thanks very much!

[BassFace]

Got this working! I now have full control over which top-level categories display in the header menu. Control is from simple red/green buttons (like Category/Product Status) in the Categories/Products table in the ACP. If anyone is interested in this code, please PM me and I'll get you the instructions.

[schoolboy]

It would be VERY NICE to see some in-depth detail here... Look at how "popular" your post is...

[BassFace]

It would be VERY NICE to see some in-depth detail here... Look at how "popular" your post is...

I'd be happy to answer any questions I can, but I don't know how 'popular' the thread is, you are the only other person to post in it!
In the screenshot below, you can see the Header Navigation Menu, which ZC normally populates with all your top-level categories. I added a new column to the 'Categories - Top' page in the admin with buttons that control if each category will display in the header nav menu. Note that if the regular 'Category Status' is off, it will act as it did before and not display in the menu.


[SCR]http://www.bassface3d.com/uploads/headercontrol.jpg[/SCR]

[lankeeyankee]

Definitely interested in this! Could you please post the step-by-step? This would be worth packaging up for the contributions section. Thanks for sharing!!

[clydejones]

I have to agree, this would make a good add-on module.

[schoolboy]

I'd be happy to answer any questions I can, but I don't know how 'popular' the thread is, you are the only other person to post in it!

... but nearly 1000 have looked at it...

(Almost better results than an "adult" site ! )

[BassFace]

Definitely interested in this! Could you please post the step-by-step? This would be worth packaging up for the contributions section. Thanks for sharing!!

Working on making this a contribution; turning text into language constants and writing up install instructions. Stay tuned....

[BassFace]

Could someone give this a try before I submit it as a Contribution and post back here with their results?

HeaderMenuControl.zip

Thanks!

[clydejones]

Could someone give this a try before I submit it as a Contribution and post back here with their results?

HeaderMenuControl.zip

Thanks!

You've only provided one file to be uploaded.

As a general rule you should provide ALL the files necessary for the mod to work.

• admin/categories.php
• admin/includes/modules/category_product_listing.php
• admin/includes/languages/english/extra_definitions/header_menu_control.php
• includes/modules/categories_tabs.php

(Just make sure you've add comments to the changed files where you made the edits:
//BOF header menu control

//EOF header menu control

provide the necessary sql file (header_menu_control.sql)

Make sure you note in the readme.txt file that the mod does overwrite 3 core files.

Make sure you include an install.txt file with the mod. (this is in addition to the html files