Administrating Skins and Containers using SQL

By Lee Sykes

June 2008

In this tutorial we demonstrate how to administer Skins and Containers in DotNetNuke through the use of SQL queries.

In particular we demonstrate how to change the container of a module displayed on all or several pages, how to change the container of a module to a new container based on the name of the old container, and how to change the skin of a page to a new skin based on the name of the old skin.

The techniques used in this tutorial are especially useful when re-skinning an existing site and will save you a lot of time. Using SQL queries instead of logging in as an administrator and manually updating the settings for skins and containers can literally reduce days of work into seconds.

Tutorial References

Introduction to using SQL queries with SQL Server Express and DotNetNuke

The videos contain:

Video 1 - How to Change Module Containers Using SQL

Introduction
How to change the container of a copied module which is displayed on all or several pages
How to identify the Module ID of module
How to change the container of a module
How to view all of the copied instances of a module from several pages using a SQL query
How to use a ‘SELECT’ query to find a modules settings from a specific page

Time length: 8min 14secs

Video 2 - How to Change Module Containers Based On The Container Name Using SQL

How to use an ‘UPDATE’ query to change the container of all instances of a copied module from several pages
How to create a test page
How to view the module settings data of all modules on a page using SQL
How the change the container of a module based on the name of the old container

Time length: 8min 26secs

Video 3 - How to Change a Page Skin Based On The Skin Name Using SQL

How to create a test page
How to view the data from the Tabs table
How to view the page settings for a page using SQL
How to change the skin of a page to a new skin based on the name of the old skin

Time length: 7min 10secs

Total time length: 23min 50secs

You need to Subscribe as a member of DNN Creative Magazine and Login to download this video tutorial.