Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 
Monday, December 01, 2008 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
General
We aren't shy - our skins are always on public display! Post your questions and comments in this discussion forum.
Forums > Bi4ce.Skins > General
Subject: SiteMap Module
You are not authorized to post a reply.
 
Author Messages
rtonerii
Superweight
Posts:310
05/21/2007 11:57 AM Alert 
I was wondering what SiteMap module you are using?  I have been looking for a simple one like the one I see here.

Thanks
Rick
rgallais
Cruiserweight
Posts:147
05/21/2007 1:07 PM Alert 
Hi Rick,

In fact we are using listX to generate the site Map: a simple request to get the data from the Tabs table and a formatting based on the [Level] column. Simple :)!

Regards
Romain Gallais
Business Intelligence Force, Inc. (bi4ce)
rtonerii
Superweight
Posts:310
05/21/2007 1:19 PM Alert 
Romain,
Is it just doing a select or how are you separating the main from the sub pages? All of the work I have done with LX has been on separate data and not on DNN data.

Thanks
Rick
rgallais
Cruiserweight
Posts:147
05/21/2007 1:32 PM Alert 
Rick,

It is just doing a simple select.
The display in managed by setting the padding based on the [level] column value.
That's it :).

Regards
Romain Gallais
Business Intelligence Force, Inc. (bi4ce)
rtonerii
Superweight
Posts:310
05/21/2007 5:23 PM Alert 
Hi Romain,
I started looking into the Tab Table and it does not just look like a simple select. Do you think you could share how you are handling the levels? How do you handle Security and other parts like hidden and disables tabs?

I think I can get LX to do looping (never tried b4). But I am just not having any luck on the select on this structure.

Thanks
Rick
rgallais
Cruiserweight
Posts:147
05/22/2007 4:20 PM Alert 
Sorry for the delay in my reply,

the sql statement is the following:
SELECT t.TabOrder, t.TabName, t.[Level], CASE WHEN t .url = '' THEN cast(t .tabid as nvarchar) ELSE t .Url END AS TabID
FROM Tabs AS t INNER JOIN
TabPermission AS tp ON t.TabID = tp.TabID
WHERE (tp.RoleID = - 1) AND (t.TabOrder < 10001) AND (t.IsDeleted = 0) AND (t.PortalID = 0) AND (t.IsVisible = 1)
ORDER BY t.TabOrder

And we define the style as follows:
style="padding-left:[Level] 0px;"

Hope this helps,

Regards
Romain Gallais
Business Intelligence Force, Inc. (bi4ce)
rtonerii
Superweight
Posts:310
05/23/2007 8:13 AM Alert 
Does this consider in Security? I am just curious.

Rick
rgallais
Cruiserweight
Posts:147
05/23/2007 11:11 AM Alert 
The condition (tp.RoleID = - 1) only allows the display of public pages.

Regards
Romain Gallais
Business Intelligence Force, Inc. (bi4ce)
You are not authorized to post a reply.
Forums > Bi4ce.Skins > General > SiteMap Module


ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation