3Ws Oval

 
Name:
Built:
Capacity:
Features:
About:

 
3Ws Oval
------
700
Pavilion, Secretariat, Media Centre, Reception Area, Bar
The 3Ws Oval is named in memory of three great Barbadian and West Indian cricketers - Sir Frank Worrell, Sir Clyde Walcott and Sir Everton Weekes.


 
Usain Bolt Sports Complex

 
Name:
Built:
Capacity:

Features:
Usain Bolt Sports Complex
In progress
950
FIFA certified artificial field, FIFA class 3 lighting, IAAF certified track, Biomechanic Labs, Classrooms, Strength and Conditioning Centre.


Students' Gym

 
Name:
Built:
Capacity:
About:

 
Students' Gym
------
------
The gym is located in the basement of the UWI Cafeteria, with access through the UWI Student’s Guild. At maximum capacity, the gym can accommodate twenty-five (25) persons and is well supervised with qualified student assistants and professional instructors.


 
Hockey Turf
Hockey Turf
 
Name:
Built:
Capacity:
Features:

About:




 
Hockey Turf
2010
300
Players' Changing Rooms, Bathroom Facilities, Team Dugouts, Technical Officials Dugout, Sand-based Artificial Turf
The “1, 2, 3…UWI!!!” chant rings out at the Hockey Turf just before the Cave Hill Blackbirds’ starting players take their positions for the start of a match. Supporters sit eagerly in the stands...
Basketball Court

 
Name:
Built:
Capacity:
Features:
About:

 
Basketball Court
-----
-----
Outdoor, International Markings
The outdoor Basketball Court is home to the Cave Hill Blackbirds Basketball Club of which the men’s team has played undefeated in the UWI Games since 2007. Marked to international standards, the outdoor court facilitates preparation for local, regional...

 
Multi-purpose Court

 
Name:
Built:
Capacity:
Features:

About:
 Multi-purpose Court
-----
-----
Facilitates Tennis, Netball and Volleyball
Are you up for some Tennis, Volleyball or Netball? This multipurpose outdoor court facilitates all three sports! Be prepared to hit groundstrokes within the white lines of the doubles/singles tennis court, spike that volleyball within the confines of the yellow volleyball...

 
Sir Garfield Sobers Coaching Centre

 
Name:
Built:
Capacity:
Features:
About:

 
Sir Garfield Sobers Coaching Centre
----
----
4 Lanes, BOLA Mechanical Bowling Machines, Indoor
Named after the great Sir Garfield Sobers, the Coaching Centre (formerly the Indoor Cricket School)  is the perfect complement to the 3Ws Oval. The Centre rises to approximately 35 feet, is complete with a storage room and can accommodate up to four different types of...

 
Malcolm Marshall Nets
Name:
Built:
Capacity:
Features:

 
Malcolm Marshall Nets
----
----
2 Lanes, Outdoor





Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute ApplicationModule.BeginRequest
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute ApplicationModule.AuthenticateRequest
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute ApplicationModule.AuthorizeRequest
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute ApplicationModule.PostAuthorizeRequest
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute ApplicationModule.PostResolveRequestCache
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData ApplicationModule.PostResolveRequestCache
7 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostResolveRequestCache
8 >> URLRewritingEvents.ProcessABTest.Execute ApplicationModule.PostResolveRequestCache
>>> ABHandlers.ProcessABTest
9 >> URLRewritingEvents.ProcessRewritingResult ApplicationModule.PostResolveRequestCache
10 RequestEvents.PostMapRequestHandler.Execute ApplicationModule.PostMapRequestHandler
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
11 ApplicationEvents.SessionStart.Execute CMSHttpApplication.Session_Start
> MembershipHandlers.SessionStart
12 >> SessionEvents.UpdateSession CMSHttpApplication.Session_Start
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
13 RequestEvents.AcquireRequestState.Execute ApplicationModule.AcquireRequestState
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
14 RequestEvents.PostAcquireRequestState.Execute ApplicationModule.PostAcquireRequestState
> MembershipHandlers.UpdateSession
15 >> SessionEvents.UpdateSession ApplicationModule.PostAcquireRequestState
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
16 >> DocumentEvents.GetData ApplicationModule.PostAcquireRequestState
17 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostAcquireRequestState
18 >>>> TypeInfo(cms.versionhistory).Events.GetData ApplicationModule.PostAcquireRequestState
19 >> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
20 >>> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
21 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
22 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
23 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
24 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
25 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
26 TypeInfo(cms.acl).Events.GetData CMSAbstractMenuProperties.OnLoad
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Data/Persistent/Cache/SportTest/outputdata/0079/m307712002.cache Local ApplicationModule.AuthorizeRequest
2 DIREXISTS
~/App_Themes/CaveHillSportNew Local ContentPage.OnPreInit
3 EXISTS
~/CMSControls/Sports/960_cave_footer.ascx Local DbPathProvider.GetFileHash
4 EXISTS
~/CMSControls/Sports/960_cave_header_new.ascx Local
5 EXISTS
~/CMSControls/Sports/960_cave_header_new.ascx.cs Local
6 EXISTS
~/CMSControls/Sports/cave_footer.ascx.cs Local
7 EXISTS
~/CMSWebParts/navigation/cmsbreadcrumbs.ascx Local
8 EXISTS
~/CMSWebParts/Navigation/cmsbreadcrumbs.ascx.cs Local
9 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
10 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
11 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
12 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Security checks called by this request / thread:
 UserOperationResultResource / Class / IDPermission / UI element / ValueSite / DomainContext
1 public FilterDataSetByPermissions DataSet: DataSet: Table (1 [37], 205 B) read SportTest CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False
CheckPrivilegeLevel False GlobalAdmin CMSAbstractMenuProperties.OnLoad
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|sporttest|/facilities|en-us|/facilities|true
template|412
nodeid|10121
pageinfo
ApplicationModule.PostResolveRequestCache
2 ADD pageinfobyurl|sporttest|https://www.cavehill.uwi.edu/sport/facilities.aspx|en-us||true|true
template|412
nodeid|10121
pageinfo
ApplicationModule.PostResolveRequestCache
3 GET cms.searchengine|cachedids|crawlers ApplicationModule.PostAcquireRequestState
4 GET pageinfo|sporttest|/|en-us||false PageContext.CurrentPage_InitComplete
5 GET siteresourcerolespermissions|75|cms.content CMSAbstractMenuProperties.OnLoad
6 ADD breadcrumbs|sporttest|/facilities|en-us|false|cms.menuitem;cms.office||true|
node|sporttest|/facilities|childnodes
CMSAbstractMenuProperties.OnLoad
7 GET cmsmenudatasource||en-us|sporttest|/%|en-us|false|cms.menuitem|||-1|true||false|false CMSListMenu.OnLoad
8 GET cmsdatasource||en-us|sporttest|/facilities|en-us|false||||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|1||false|| BasicDataList.OnLoad
9 GET cmsmenudatasource||en-us|sporttest|/facilities/%|en-us|false||||-1|true||false|false CMSListMenu.OnLoad
10 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /facilities.aspx 0.000
0.625
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.625
1.219
 
3 > OnPreInit 1.844
0.000
 
4 > OnInit 1.844
0.078
 
5 > OnLoad 1.922
0.469
 
6 > OnPreRender 2.391
N/A
    2.391  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookieDT7tSwLRxmWurYVJzJzLZHuhTwJKwD/fwyu9/Q2o
3 ASP.NET_SessionIdi0eh0l5rxj1iz0gfokioow0i
4 Campaign 
5 Source 
6 CMSCurrentThemeCaveHillSportNew
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US4/23/2020 6:41:27 PM
2 CMSCsrfCookieDT7tSwLRxmWurYVJzJzLZHuhTwJKwD/fwyu9/Q2o 
3 ASP.NET_SessionIdi0eh0l5rxj1iz0gfokioow0i 
4 Campaign 4/23/2018 6:41:27 PM
5 Source 4/23/2018 6:41:27 PM
6 CMSCurrentThemeCaveHillSportNew4/24/2019 6:41:28 PM
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress54.91.121.255
5 UserLanguagesen-US;en;q=0.5
6 UserName 
7 SessionIDi0eh0l5rxj1iz0gfokioow0i
8 ServerNameARES2_sport
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
1
(.generalselect)
DECLARE @NodeSiteID int = 75;
DECLARE @DocumentUrlPath nvarchar(max) = N'/facilities';
DECLARE @NodeAliasPath nvarchar(max) = N'/facilities';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @Now datetime2 = '4/23/2019 6:41:27 PM';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/facilities' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.6 kB
 
Table (1 [64], 24 kB)
 
ApplicationModule.PostResolveRequestCache 0.563
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 75;
DECLARE @DocumentCulture nvarchar(max) = N'en-us';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath = N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (1 [157], 925 B)
 
ApplicationModule.PostResolveRequestCache 0.047
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 75;
DECLARE @NodeGUID uniqueidentifier = '4a654cc0-1a0f-44c4-8f27-92a7393c2933';
DECLARE @Now datetime2 = '4/23/2019 6:41:27 PM';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [NodeGUID] = @NodeGUID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
523 B
 
Table (1 [157], 24 kB)
 
ApplicationModule.PostAcquireRequestState 0.063
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
4
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 21707
Table (1 [23], 30 kB)
 
ApplicationModule.PostAcquireRequestState 1.063
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
5
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/Facilities';
DECLARE @ABVariantSiteID int = 75;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
ApplicationModule.PostAcquireRequestState 0.047
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
6
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 10196
PageContext.CurrentPage_InitComplete 0.047
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
7
(cms.document.generalselect)
DECLARE @NodeSiteID int = 75;
DECLARE @Now datetime2 = '4/23/2019 6:41:28 PM';
DECLARE @NodeLevel int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings], [DocumentID]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Facilities', N'/'))) AND ([ClassName] IN (N'CMS.MenuItem', N'cms.office')) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeAliasPath DESC
1.5 kB
 
Table (1 [37], 205 B)
 
CMSAbstractMenuProperties.OnLoad 0.094
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
8
(cms.acl.generalselect)
DECLARE @ACLID int = 105;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
Table (1 [5], 52 B)
 
CMSAbstractMenuProperties.OnLoad 0.047
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
9
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 75;
DECLARE @Date datetime2 = '4/23/2019 6:41:29 PM';

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 (105)

1.3 kB
 
CMSAbstractMenuProperties.OnLoad 0.047
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
10
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 2214;
DECLARE @PermissionName nvarchar(max) = N'read';
DECLARE @SiteID int = 75;

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)
CMSAbstractMenuProperties.OnLoad 0.266
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
  10 queries, 8 kB write, 79 kB read   2.281
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% prefix %} Sport Cave Hill | The University of the West Indies at Cave Hill, Barbados ContentPage.OnLoad 0.000
> prefix Sport Cave Hill | The University of the West Indies at Cave Hill, Barbados 0.000
2 {% pagetitle_orelse_name %} Facilities 0.000
> pagetitle_orelse_name Facilities 0.000
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/sport/facilities.aspx" (22 B)
22 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 lt
cave_header1
DropDownList1
No
No
AutoPostBack = True
Width = 119px
0 B
 
4 lt
cave_header1
ImageButton1
No
ImageUrl = "http://www.cavehill.uwi.edu/CMSSiteFiles/images/go_button.png" (61 B)
61 B
 
5 lt
partPlaceholder
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
6 RightContent
cmsdatalist
lstElem
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
NestedControlsID = "" (0 B)
DataBindByDefault = True
TransformationName = "CMS.MenuItem.SportsNavLinksSectionTitle" (39 B)
RepeatLayout = Flow
ShowEditButton = False
_!ItemCount = 1
HideControlForZeroRows = True
RepeatColumns = 1
ShowDeleteButton = False
RepeatDirection = Vertical
DataSourceName = "" (0 B)
ZeroRowsText = "No data found" (13 B)
AlternatingTransformationName = "" (0 B)
DataKeys = System.Collections.ArrayList
EnablePaging = False
52 B
 
7 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes