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

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,
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

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

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

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

Does this consider in Security? I am just curious.

Rick

The condition (tp.RoleID = - 1) only allows the display of public pages.

Regards

www.nukewizard.net
is 100%FREE website for dnn skins and also modules
JUST REGISTER(100%free) Login and Download