Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AppTheory specializes in solutions based on the DotNetNuke platform and has 2 employees on the DotNetNuke Core Team.
  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
telerik
ExactTarget email software solutions
Merak Mail Server
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Make it Hot! ( ...  Menu Information in Database
Previous Previous
 
Next Next
New Post 5/6/2008 8:11 AM
User is offline GMartin
14 posts
10th Ranked


Menu Information in Database 

Where is the Menu information for DotNetNuke stored in the Database?

 

 
New Post 5/6/2008 9:04 AM
User is offline Brandon Haynes
701 posts
brandonhaynes.org
7th Ranked


Re: Menu Information in Database 

Hi Martin,

The menu is constructed from the Tabs table.  DNN constructs a hierarchy based off of the TabID and ParentId, partitioned by the PortalID.  Tabs with IsVisible=False are not included in the hierarchy.

Hope this gets you started!

Brandon


Brandon Haynes
BrandonHaynes.org
 
New Post 5/6/2008 9:17 AM
User is offline GMartin
14 posts
10th Ranked


Re: Menu Information in Database 

Thank you Brandon.

With that info, I took a look and it would appear that the TabPath corresponds roughly to the menu location as well.  I'm going to assume it's not as reliable as using the TabID and ParentId recursively in each PortalID.

(I'm guessing the TabOrder in the TabPath table corresponds to where each Tab appears within the menu level that it resides?)

Thanks for the info.

 

 
New Post 5/6/2008 11:25 AM
User is offline Brandon Haynes
701 posts
brandonhaynes.org
7th Ranked


Re: Menu Information in Database 

Hi Martin,

Your TabOrder inference seems reasonable.  I actually haven't looked at how DNN loads the menu hierarchy, so it's entirely possible that the TabPath is used as a cache for these relationships, and can be relied upon.  Someone else would have to chime in with insight in this direction.

You might also take a look at the SP that DNN uses to load this data; I am not sure offhand if DNN loads up all the data from the Tabs table (dbo.GetTabs or something similar) and constructs the hierarchy internally, or if it performs this task in the data layer (e.g.; dbo.GetTabHierarchy).  More likely is the former -- dig around and see what you can find!

Brandon


Brandon Haynes
BrandonHaynes.org
 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Make it Hot! ( ...  Menu Information in Database
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Sunset Hill Solutions - Consulting and Development
We offer general DNN consulting services - including custom module development and commercial module integration/setup.
www.sunsethill.ca
MaximumASP
MaximumASP provides a wide array of web hosting plans to fit any hosting need. We also provide software and services needed to keep it running optimally.
MaximumASP.com
Mad Development: dotnetnuke design and development
We are an expert Dotnetnuke shop specializing in developing solutions that merge the requirements of design and branding, content management, ecommerce, search engine optimization and business logic.
www.MadDevelopment.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP