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  |  

AspDotNetStoreFront
  Ads  
Webhost4Life - $4.95 Windows Hosting
 


  Sponsors  

Meet Our Sponsors

SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
 


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.

 


DotNetNuke® in Sweden
All service of DotNetNuke® in Sweden.
Olsmar Konsult
DocuPeak Business Process Management RAD
Comprehensive enterprise and government process management. Forms, documents, indexing, workflow, views, content intelligence, capture, etc. Point and click rapid application development.
www.Webiplex.com
ADefWebserver.com
DotNetNuke® Module Development Help Website
ADefWebserver.com

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