Get Started > How CILC Works  

How CILC Works

Membership Level Capabilities 

Membership Levels Search Programs Search Collaborations Book Programs Receive Discounts  Manage Multiple Users  Billing Managed by CILC  Virtual Expedtions
Guest  X X          
Registered Individual Member X X X        
Premium Member X X X X     X
Organization X X X   X    
Organization with 
Content Dollar Bank or
 Carnival Plan
X X X   X X  
 
 
 
 
 
 

NEED MORE DETAILS?  

 

Contact CILC Help Desk, 507-388-3672.

 
CONTENT PROVIDER SPOTLIGHT

Homestead National Monument of America 

Program: "A School Day in 1872"


 
Reaction from CILC Member

“It just reminded me how great this type of resource is for the classroom teacher and students. There was valuable content provided and it was a great way to use technology and have the students "travel" somewhere new. The students were excited to go home and share their newly gained knowledge with the families.”

Elementary School Teacher

Homestead National Monument of America


Find out more about this Content Provider or
search the Content Provider Directory

FOLLOW US
ADDRESS
Center for Interactive Learning and Collaboration
2075 Lookout Drive
North Mankato, MN 56003
SUPPORT MENU
© 2016 Center for Interactive Learning and Collaboration Privacy Policy
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(SELECT * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (DocumentUrlPath = N'/Get-Started/How-CILC-Works') AND (DocumentUrlPath <> NodeAliasPath)))
UNION ALL
(SELECT TOP 2 * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (NodeAliasPath = N'/Get-Started/How-CILC-Works') AND ([DocumentCulture] = N'en-US')))
Table (1 [67], 8.8 kB)
 
SimpleHandler`2.StartEvent 0.031
 
2
(cms.document.selectdocuments)
SELECT * FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Get-Started', N'/')) AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
190 B
 
Table (2 [172], 12.6 kB)
 
SimpleHandler`2.StartEvent 0.016
 
3
(cms.menuitem.selectdocuments)
SELECT * FROM View_CONTENT_MenuItem_Joined WHERE ([DocumentCulture] = N'en-US') AND (NodeID = 1255)
Table (1 [176], 9.2 kB)
 
SimpleHandler`2.StartEvent 0.000
 
4
(cms.class.selectrequiredroles)
SELECT * FROM CMS_Role WHERE RoleID IN (SELECT RoleID FROM CMS_RolePermission WHERE PermissionID IN (SELECT PermissionID FROM CMS_Permission WHERE ClassID=@ClassID AND PermissionName=@PermissionName)) AND (SiteID=@SiteID OR SiteID IS NULL)
@ClassID (4609)
@PermissionName ("read")
@SiteID (1)
251 B
 
Table (1 [10], 112 B)
 
SimpleHandler`2.StartEvent 0.000
 
5
(cms.user.isauthorizedpernode)
Proc_CMS_User_IsAuthorizedPerNode
@UserID (65)
@NodeID (1255)
@PermissionName ("read")
@GenericRoles ("'_everyone_', '_notauthenticated_'")
@SiteID (1)
@Date (7/19/2018 12:32:27 PM)
91 B
 
SimpleHandler`2.StartEvent 0.000
 
6
(cms.acl.generalselect)
SELECT * FROM CMS_ACL WHERE [ACLID] = @ACLID
@ACLID (1)
48 B
 
Table (1 [6], 56 B)
 
SimpleHandler`2.StartEvent 0.000
 
7
(cms.aclitem.selectaclitemsbyaclidanduserid)
SELECT DISTINCT X.Allowed,X.Denied,X.ValidTo,X.ACLID
FROM (
SELECT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, null AS 'ValidTo',CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
WHERE
--User
(CMS_ACLItem.UserID IN (SELECT CMS_User.UserID FROM CMS_User JOIN CMS_UserSite ON CMS_User.UserID = CMS_UserSite.UserID
WHERE CMS_User.UserID = @UserID AND CMS_UserSite.SiteID = @SiteID )
-- Specific roles
OR CMS_ACLItem.RoleID IN (SELECT RoleID FROM CMS_Role WHERE RoleName IN ('_everyone_','_notauthenticated_'))
)
-- Membership
UNION ALL
SELECT DISTINCT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, UserRole.ValidTo, CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
INNER JOIN [View_CMS_UserRoleMembershipRole] AS UserRole ON UserRole.RoleID = CMS_ACLItem.RoleID
WHERE (UserRole.ValidTo > @Date OR UserRole.ValidTo IS NULL)
AND (UserRole.SiteID = @SiteID OR UserRole.SiteID IS NULL)
AND UserRole.UserID = @UserID
) AS X
WHERE ACLID IN (1)

@UserID (65)
@SiteID (1)
@Date (7/19/2018 12:32:27 PM)
1.2 kB
 
Table (1 [4], 16 B)
 
SimpleHandler`2.StartEvent 0.000
 
8
(cms.document.selectdocuments)
SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentMenuClassOver], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemImageOver], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemLeftImageOver], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuItemRightImageOver], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentMenuStyleOver], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [SiteName], [NodeACLID], [NodeSiteID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings] FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Get-Started/How-CILC-Works', N'/Get-Started', N'/')) AND ([Published] = @Published AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeAliasPath DESC
@NodeSiteID (1)
@Published (True)
@NodeLevel (2)
@DocumentCulture ("en-US")
1.2 kB
 
Table (3 [42], 404 B)
 
CMSAbstractMenuProperties.OnLoad 0.000
 
  8 queries, 3.4 kB write, 31 kB read   0.047