Membership
Update your site by replacing this text with your own message.
Update your site by replacing this text with your own message.
Debugging Information
Execution Time
SQL Queries checkAccessControlRules (Datasource=LumensCustomers, Time=0ms, Records=6) in E:\Lumens\Versions\v81QA\checkPermission.cfm @ 10:27:44.044 SELECT DISTINCT ACA.int_actor_type_id FROM tbl_access_control_rules ACR INNER JOIN tbl_access_control_allow ACA ON ACR.int_access_rule_id = ACA.int_access_rule_id WHERE str_fuse_action LIKE ? AND ISNULL(ACA.int_actor_type_id,'')<>'' AND ACA.bit_allow = 1 Query Parameter Value(s) - MenuQry (Datasource=v8Template1, Time=0ms, Records=18) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 10:27:44.044 SET NOCOUNT ON SELECT OrgID , RegionID , MenuItemID , MenuItemType , MainLevel , SubLevel ,MainLevelSortOrder , SubLevelSortOrder , SiteURL , AccessLevel , IsNull(DisplayCriteria_1, '') AS DisplayCriteria_1 , IsNull(DisplayValue_1, '') AS DisplayValue_1 , IsNull(DisplayCriteria_2, '') AS DisplayCriteria_2 , IsNull(DisplayValue_2, '') AS DisplayValue_2 , Condition , LTRIM(RTRIM(IsNull(NewWindowName, ''))) AS NewWindowName , m.Label AS UniqueLable , CASE WHEN str_user_nav_label IS NULL THEN CASE WHEN MenuItemType != 'Lnk' AND SiteURL = 'index.cfm?fuseaction=9440' THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Membership', 'Membership') WHEN MenuItemType != 'Lnk' AND SiteURL = 'index.cfm?fuseaction=9620' THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Member', 'Member') /*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */ WHEN m.Label LIKE 'Donate' THEN Replace(m.Label, 'Donate', 'Donate') /*END NEO 00106 20 FEB 2015 Student Donations UC-02 */ WHEN m.Label LIKE 'MERCHANDISE' THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise') WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships' THEN Replace(m.Label, 'Scholarships', 'Scholarship') ELSE Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"') END ELSE /*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */ CASE WHEN str_menu_label LIKE 'Donate' THEN (str_user_nav_label) ELSE str_user_nav_label END /*END NEO 00106 20 FEB 2015 Student Donations UC-02 */ END AS Label , CASE WHEN str_user_nav_label IS NULL THEN CASE WHEN MenuItemType != 'Lnk' AND SiteURL = 'index.cfm?fuseaction=9440' THEN Replace(m.Label, 'Membership', 'Membership') WHEN MenuItemType != 'Lnk' AND SiteURL = 'index.cfm?fuseaction=9620' THEN Replace(m.Label, 'Member', 'Member') /*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */ WHEN m.Label LIKE 'Donate' THEN Replace(m.Label, 'Donate', 'Donate') /*END NEO 00106 20 FEB 2015 Student Donations UC-02 */ WHEN m.Label LIKE 'MERCHANDISE' THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise') WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships' THEN Replace(m.Label, 'Scholarships', 'Scholarship') ELSE m.Label END ELSE /*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */ CASE WHEN str_menu_label LIKE 'Donate' THEN dbo.fun_strip_html((str_user_nav_label)) ELSE dbo.fun_strip_html(str_user_nav_label) END /*END NEO 00106 20 FEB 2015 Student Donations UC-02 */ END AS LabelNoHTML , ISNULL(int_parent_id,0) as int_parent_id , int_sort_order , m.UniqueLabel , m.bit_default_behavior FROM MenuItems m LEFT JOIN tbl_user_nav_menu_label u ON m.MenuItemID = u.int_menu_item_id WHERE STATUS = 'A' AND SubCategoryID IS NULL AND ( int_actor_type_id = ? OR ( int_actor_type_id IS NULL AND AccessLevel = ? ) ) AND ISNULL(SiteURL, '') NOT LIKE 'index.cfm?fuseaction=1010' /*29 MAY 2012 NEO 00043 TRACKER 29863*/ ORDER BY int_sort_order Query Parameter Value(s) - qGetDashboardName (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 10:27:44.044 SET ANSI_NULLS ON SELECT IsNull(( CASE WHEN str_dashboard_name = '' THEN NULL ELSE str_dashboard_name END ), CASE WHEN ActorTypeID = 55 THEN 'Dashboard' ELSE 'my dashboard' END) AS str_dashboard_name /* 02 APRIL 2014 NEO 0088 TRACKER 40005 */ FROM ActorTypes WHERE ActorTypeID = ? Query Parameter Value(s) - qLearnerfields (Datasource=v8Template1, Time=16ms, Records=95) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:27:44.044 SELECT pfo.int_order , pf.str_field_display_name , pf.str_field_name , pfo.int_profile_field_tab_id , pf.str_actor_types , pf.chr_field_type FROM tbl_profile_field_order pfo INNER JOIN tbl_profile_field pf ON pfo.int_profile_field_id = pf.int_profile_field_id WHERE pf.int_region_id = ? AND bit_enabled = ? AND ( ( pf.chr_field_type not in ('C','O') ) OR ( pf.chr_field_type in ('C','O') AND ( pf.str_actor_types LIKE ? ) ) ) ORDER BY pfo.int_profile_field_tab_id , pfo.int_order ASC Query Parameter Value(s) - qsocialNetFieldDetails (Datasource=v8Template1, Time=0ms, Records=4) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:27:44.044 select * from tbl_social_media_details WHERE int_region_id = ? order by int_order asc Query Parameter Value(s) - qGraphics (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:27:44.044 select * from UIVariables where RegionID = ? Query Parameter Value(s) - qUserNavItems (Datasource=v8Template1, Time=0ms, Records=7) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 10:27:44.044 SELECT menitms.SiteURL AS nav_site_url , menitms.label AS nav_label , menitms.rowNum , COUNT(menitms.rowNum) OVER () AS Total_Rows , menitms.DisplayCriteria_1 , menitms.DisplayValue_1 , menitms.DisplayCriteria_2 , menitms.DisplayValue_2 , menitms.Condition , menitms.NewWindowName FROM ( SELECT SiteURL , label , DisplayCriteria_1 , DisplayValue_1 , DisplayCriteria_2 , DisplayValue_2 , Condition , Row_Number() OVER ( ORDER BY MenuitemID ASC ) AS rowNum , NewWindowName FROM MenuItems WHERE AccessLevel = ? AND RegionID = ? AND bit_display_in_nav=1 AND STATUS = ? ) menitms Query Parameter Value(s) - qFooterNavItems (Datasource=v8Template1, Time=0ms, Records=6) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 10:27:44.044 SELECT menitms.SiteURL , menitms.label , menitms.AccessLevel , menitms.rowNum , ((rowNum - 1) / 4) + 1 AS block , menitms.DisplayCriteria_1 , menitms.DisplayValue_1 , menitms.DisplayCriteria_2 , menitms.DisplayValue_2 , menitms.Condition , menitms.NewWindowName FROM ( SELECT SiteURL , label , AccessLevel , DisplayCriteria_1 , DisplayValue_1 , DisplayCriteria_2 , DisplayValue_2 , Condition , Row_Number() OVER ( ORDER BY MenuitemID ASC ) AS rowNum , NewWindowName FROM MenuItems WHERE AccessLevel = ? AND RegionID = ? AND bit_display_in_footer=1 AND STATUS = ? ) menitms Query Parameter Value(s) - CommonPasswords (Datasource=v8Template1, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 10:27:44.044 DECLARE @currentTime DATETIME2 = ? UPDATE tbl_cart_class_detail SET EnteredDate = @currentTime WHERE SessionID = ?; UPDATE tbl_cart_merchandise_detail SET EnteredDate = @currentTime WHERE SessionID = ?; Query Parameter Value(s) - variables.custom_scripts (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 10:27:44.044 SELECT str_header_script , str_footer_script FROM tbl_style_settings WITH (NOLOCK) -- WHERE int_region_id = Commented as long as multiple regions are not there qGraphics (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:27:44.044 select * from UIVariables where RegionID = ? Query Parameter Value(s) - qTempMenu (Datasource=, Time=0ms, Records=16) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\menu_action.cfm @ 10:27:44.044 select * from qTempMenu where MenuItemID NOT IN (582,655) qSocialMediaHeader (Datasource=, Time=0ms, Records=4) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 10:27:44.044 select * from qSocialMedia order by int_order desc qGetDonateUserNavLabel (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 10:27:44.044 SELECT isNull(str_user_nav_label,'') AS str_menu_label FROM tbl_user_nav_menu_label WHERE int_actor_type_id = ? AND str_menu_label LIKE 'DONATE' AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1'; Query Parameter Value(s) - qGetDonateUserNavLabel (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 10:27:44.044 SELECT isNull(str_user_nav_label,'') AS str_menu_label FROM tbl_user_nav_menu_label WHERE int_actor_type_id = ? AND str_menu_label LIKE 'DONATE' AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1'; Query Parameter Value(s) - qGetDonateUserNavLabel (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 10:27:44.044 SELECT isNull(str_user_nav_label,'') AS str_menu_label FROM tbl_user_nav_menu_label WHERE int_actor_type_id = ? AND str_menu_label LIKE 'DONATE' AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1'; Query Parameter Value(s) - qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qCourseMenu where int_parent_id = ? and MenuItemType = ? and Label <> ? and int_parent_id<>0 Query Parameter Value(s) - qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qCourseMenu where int_parent_id = ? and MenuItemType = ? and Label <> ? and int_parent_id<>0 Query Parameter Value(s) - qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qCourseMenu where int_parent_id = ? and MenuItemType = ? and Label <> ? and int_parent_id<>0 Query Parameter Value(s) - qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qCourseMenu where int_parent_id = ? and MenuItemType = ? and Label <> ? and int_parent_id<>0 Query Parameter Value(s) - qTempCourseMenu (Datasource=, Time=0ms, Records=4) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qCourseMenu where int_parent_id = ? and MenuItemType = ? and Label <> ? and int_parent_id<>0 Query Parameter Value(s) - qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qMenu where int_parent_id = 627 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qMenu where int_parent_id = 502 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qMenu where int_parent_id = 7 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qMenu where int_parent_id = 555 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qMenu where int_parent_id = 551 qTempMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qMenu where int_parent_id = 515 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qMenu where int_parent_id = 5 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 10:27:44.044 select * from qMenu where int_parent_id = 491 CustomizationsQry (Datasource=v8Template1, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\Administration\SQL\CustomizationsQry.cfm @ 10:27:44.044 SELECT OrgID, RegionID, CustomizationID, rtrim(ltrim(FuseAction)) as fuseAction, Status, CASE Status When 'A' Then 'Active' When 'I' Then 'Inactive' END AS StatusDesc, CreateDate, CustomizationName, CustomizationDesc FROM Customizations c WHERE Status = 'A' AND RegionID = 1 Order By Status, Fuseaction ContentsQry (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\ContentsQry.cfm @ 10:27:44.044 SELECT ContentID , OrgID , RegionID , Section , Path , Contents , ContentsNoHTML , Description , Name , emailTemplate , str_default_condition , str_page_title , str_meta_description , str_keywords FROM Contents WHERE Path = ? AND orgid = ? AND regionid= ? Query Parameter Value(s) - Content2 (Datasource=v8Template1, Time=15ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\Contents2Qry.cfm @ 10:27:44.044 SELECT ContentID , OrgID , RegionID , Section , Path , Contents , ContentsNoHTML , Description , Name , emailTemplate , str_default_condition , str_page_title , str_meta_description , str_keywords FROM Contents WHERE Path = ? AND regionid= ? Query Parameter Value(s) - MembershipTypesQry (Datasource=v8Template1, Time=31ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\MembershipTypesQry.cfm @ 10:27:44.044 SELECT MembershipTypeID, Code, Name, Description, AnnualFee, RenewalFee, TermInMonths, DiscountRate, DiscountAmount, MaxNumberMembers, SortOrder,flt_early_renewal_fee ,bit_allow_student_purchase_mbrship /*Added Dec 14 2012 AI MembershipEnhancement Uc 10 Neo 00110*/ FROM MembershipTypes WHERE Status = 'A' AND RegionID = 1 AND CASE WHEN str_mbrship_duration_type ='Terms' THEN (SELECT MAX(ClassesEndDate) FROM InstructionCalendar WHERE TermID IN(SELECT int_term_id FROM tbl_membership_type_terms WHERE int_membership_type_id = MembershipTypeID)) ELSE 1 END > CASE WHEN str_mbrship_duration_type ='Terms' THEN dbo.fun_GetDateCT() ELSE 0 END /*Added Jan 17 2013 AI Membership Enhancement:To avoid expired membership types Neo 00110*/ AND bit_allow_student_purchase_mbrship=1 ORDER BY IsDefault desc, SortOrder, Name qGetMembershipTypes (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\MembershipTypesQry.cfm @ 10:27:44.044 SELECT count(distinct maxNumberMembers) as MembershipTypeCount FROM MembershipTypes WHERE Status = ? AND RegionID = ? Query Parameter Value(s) - Scope Variables CGI Variables: AUTH_PASSWORD= AUTH_TYPE= AUTH_USER= CERT_COOKIE= CERT_FLAGS= CERT_ISSUER= CERT_KEYSIZE= CERT_SECRETKEYSIZE= CERT_SERIALNUMBER= CERT_SERVER_ISSUER= CERT_SERVER_SUBJECT= CERT_SUBJECT= CF_TEMPLATE_PATH=E:\Lumens\index.cfm CONTENT_LENGTH=0 CONTENT_TYPE= CONTEXT_PATH= GATEWAY_INTERFACE=CGI/1.1 HTTPS=off HTTPS_KEYSIZE= HTTPS_SECRETKEYSIZE= HTTPS_SERVER_ISSUER= HTTPS_SERVER_SUBJECT= HTTP_ACCEPT=*/* HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate HTTP_ACCEPT_LANGUAGE= HTTP_CONNECTION= HTTP_COOKIE=AWSALBAPP-1=_remove_; AWSALBAPP-2=_remove_; JSESSIONID=50C0BB528EB7675BC24450DFC705E3FF.cfusion; AWSALBAPP-3=_remove_; LUMPERSIST=0976CD6C399E5E99B44DCA75771B5C6E; AWSALBAPP-0=AAAAAAAAAAArR6/EnVFhhamHdTOEeuhJLyaqi96aYVnFQfbrz2cNSd5DAX+ClqoseekJC3IJE2Oxi9oq/FuiVvW2dfbcMKk7t8VNx87cPaeoqC8EkDxnBED0ODtkP2A/lpyWZvtYBFw5ag== HTTP_HOST=v8template1.augusoft.net HTTP_REFERER= HTTP_URL=/index.cfm?fuseaction=1050 HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) LOCAL_ADDR=172.31.100.167 PATH_INFO= PATH_TRANSLATED=E:\Lumens\index.cfm QUERY_STRING=fuseaction=1050 REMOTE_ADDR=172.31.102.122 REMOTE_HOST=172.31.102.122 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/index.cfm SERVER_NAME=v8template1.augusoft.net SERVER_PORT=80 SERVER_PORT_SECURE=0 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/10.0 WEB_SERVER_API= Cookie Variables: AWSALBAPP-0=AAAAAAAAAAArR6/EnVFhhamHdTOEeuhJLyaqi96aYVnFQfbrz2cNSd5DAX ClqoseekJC3IJE2Oxi9oq/FuiVvW2dfbcMKk7t8VNx87cPaeoqC8EkDxnBED0ODtkP2A/lpyWZvtYBFw5ag AWSALBAPP-1=_remove_ AWSALBAPP-2=_remove_ AWSALBAPP-3=_remove_ JSESSIONID=50C0BB528EB7675BC24450DFC705E3FF.cfusion LUMPERSIST=0976CD6C399E5E99B44DCA75771B5C6E Session Variables: actortypeid=90 addtoken=CFID=10156203&CFTOKEN=1ad2d33098b3211d-E22760E5-E649-9C62-EB7F894E1C39D710&jsessionid=50C0BB528EB7675BC24450DFC705E3FF.cfusion allowunmaskeddata=0 appname=v8Template1 basecfcs=versions.v81QA basecode=/versions/v81QA bit_canvas_failed_process=false bit_member=0 customcct= customcfcs=Customers.v8Template1 customerid=486 custompath=/Customers/v8Template1/custom debug=0 debugoutput=1 docxdir=DocxHTML domain=v8template1.augusoft.net ds=v8Template1 enabledlivechat=false enabledsupportwidget=false enteredsiteusingipaddress=1 foundeo_firewall_ip=18.222.191.8 foundeo_firewall_ua=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) loggedin=No loggeduseremail= loggeduserfname=Guest loggeduserlname= membershiptypeid=0 menuid=1 orgid=1 privacypolicyack= regionid=1 sessionid=50C0BB528EB7675BC24450DFC705E3FF.cfusion sitepath=/Customers/v8Template1 sslreturnurl=https://v8template1.augusoft.net/ stylesheetpath=/Customers/v8Template1/StyleSheets/style.css timeoutminutes=60 urltoken=CFID=10156204&CFTOKEN=fd22f5d4708fda02-E2278508-DBD7-059B-FCDB1A9FDBCBFDD7&jsessionid=50C0BB528EB7675BC24450DFC705E3FF.cfusion version=v81QA URL Parameters: fuseaction=1050Debug Rendering Time: 16 ms |