This stored procedure is used by the ModuleSettings administration page to set the properties of a specific module. The input parameters include the item's primary key (ModuleID), plus title, position within the tab and security settings.
Definition:CREATE PROCEDURE UpdateModule ( @ModuleID int, @ModuleOrder int, @ModuleTitle nvarchar(256), @PaneName nvarchar(50), @CacheTime int, @EditRoles nvarchar(256), @ShowMobile bit ) AS UPDATE Modules SET ModuleOrder = @ModuleOrder, ModuleTitle = @ModuleTitle, PaneName = @PaneName, CacheTime = @CacheTime, ShowMobile = @ShowMobile, AuthorizedEditRoles = @EditRoles WHERE ModuleID = @ModuleIDDatabase Tables Used:
Modules: Each record in the Modules table represents a single module instance on a specific tab in the selected portal. The definition for the module type is pulled via the ModuleDefID field from the ModuleDefinitions table. The data for the module is stored in a database table for the selected module type, and indexed by ModuleID.
The primary key in this table is the ModuleID identity field.