AUCD 2018 Conference

	    Error processing CFX custom tag CFX_GIFGD.
	    

	    Error processing CFX custom tag CFX_GIFGD.
	    

	SELECT name, value FROM config
	WHERE
		
		host = 'remote' OR host = '' OR host is null
		

SELECT id, description FROM code WHERE name = 'content_language' ORDER BY orderby

	SELECT page_id, page_filename FROM page_am WHERE year = 2018 ORDER BY orderby LIMIT 1
	

SELECT page.page_id, page.page_filename, page.page_section, page.page_title, page.hide_search, page.hide_navigation,
	page.year, page.browser_title, page.meta_description, page.header_image,
	CASE WHEN gparent.page_id IS NOT NULL THEN gparent.page_title 
		WHEN parent.page_id IS NOT NULL THEN parent.page_title
		ELSE page.page_title END AS section_name,
	CASE WHEN gparent.page_id IS NOT NULL THEN gparent.page_id 
		WHEN parent.page_id IS NOT NULL THEN parent.page_id
		ELSE page.page_id END AS section_id,
	CASE WHEN gparent.page_id IS NOT NULL THEN gparent.page_filename 
		WHEN parent.page_id IS NOT NULL THEN parent.page_filename
		ELSE page.page_filename END AS section_filename,
	gparent.page_title AS gparent_name, gparent.page_id AS gparent_id,
	gparent.page_filename AS gparent_filename,
	parent.page_title AS parent_name, parent.page_id AS parent_id,
	parent.page_filename AS parent_filename
FROM page_am AS page 
	LEFT JOIN page_am AS parent ON page.page_section = parent.page_id
	LEFT JOIN page_am AS gparent ON parent.page_section = gparent.page_id
WHERE 
	page.template = 'am' AND
	
	page.page_id = 50183 
ORDER BY page_id

	SELECT page.page_id, page.page_title, page.page_section, page.orderby, page.meta_description,
		ifnull(parent.page_title,page.page_title) AS section_name,
		CASE WHEN ifnull(page.page_filename,'') <> '' THEN page.page_filename
			ELSE concat('template/page.cfm?id=',page.page_id) 
			END AS page_filename
	FROM page_am AS page 
		LEFT JOIN page_am AS parent ON page.page_section = parent.page_id
	WHERE ifnull(page.hide_navigation,0) = 0 AND page.live = 1 AND
		page.year = 2018 AND
		parent.page_section is null
	ORDER BY page.orderby

SELECT * FROM annual_meeting WHERE year = 2018 

SELECT * FROM annual_meeting WHERE live = 1 ORDER BY year DESC

SELECT page_module.link_id, page_type, page_module.title, page_module.orderby,
	page_subtype, page_topic, page_layout, page_criteria, replace(module.type,' ','') AS type,
	module.subtype, rssaddress, topic.topic_title, replace(page_module.custom,',',' ') as custom,
	'' AS rss,
	
	concat_ws(',',page_module.detail1_id,page_module.detail2_id,page_module.detail3_id) AS detail_id
	
FROM page_module INNER JOIN module ON page_module.page_type = module.type AND (module.sidebar = 0 OR module.sidebar is null)
	LEFT JOIN topic ON page_module.page_topic = topic.topic_id
WHERE
	
		page_id = 50183 
ORDER BY page_module.orderby

SELECT code.name, code.other, 
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(code.id,parent.id) AS parentid 
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type' 
WHERE code.id = 0 

	SELECT topic_title FROM topic WHERE topic_id = 89 

/* Article Title & Summary */
SELECT news.news_id, news.url,
	CASE WHEN length(url) > 0 THEN url
		WHEN ifnull(body,'') = '' AND length(document_file) > 0 THEN concat('/docs/',document_file)
		 
		ELSE concat('../template/news.cfm?news_id=',news_id,'&id=50183&parent=50183') END AS link,
		
	if(ifnull(body,'') <> '' AND length(document_file) > 0,1,0) AS multiple,
	if(ifnull(body,'') = '' AND (length(document_file) > 0 OR length(url) > 0),'target="_blank"','') AS target,
	document_file, news.title, news.subtitle, news.date, news.summary, news.body,
	code.description AS news_type, thumbnail_file AS photo, caption
FROM news INNER JOIN code ON news.type = code.id
WHERE live = 1
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 89)
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	
	LIMIT 3 

	SELECT title, content
	FROM page_module
	WHERE link_id = 2895 

	SELECT title, content
	FROM page_module
	WHERE link_id = 2787 

SELECT sidebar_module.link_id, page_type, sidebar_module.title, sidebar_module.orderby,
	page_topic, page_subtype, page_layout, page_criteria, replace(module.type,' ','') AS type,
	module.subtype, rssaddress, topic.topic_title, sidebar_module.custom,
	CASE WHEN exists (Select link_id from sidebar_annualMeeting where page_id = ? and link_id = sidebar_module.link_id) THEN 1 ELSE 0 END as HomepageSidebar,
	'' AS rss,
	
	concat_ws(',',sidebar_module.detail1_id,sidebar_module.detail2_id,sidebar_module.detail3_id) AS detail_id
	
FROM sidebar_module INNER JOIN module ON sidebar_module.page_type = module.type AND module.sidebar = 1
	LEFT JOIN topic ON sidebar_module.page_topic = topic.topic_id
WHERE (page_id = 50183 
			or exists (Select link_id from sidebar_annualMeeting where page_id = ? and link_id = sidebar_module.link_id)
		
		)
	
	AND position = 'R'
	
ORDER BY sidebar_module.orderby

	SELECT title, content
	FROM sidebar_module
	WHERE link_id = 1089 

	SELECT title, content
	FROM sidebar_module
	WHERE link_id = 1101 

	SELECT title, content
	FROM sidebar_module
	WHERE link_id = 1091 

	SELECT title, content
	FROM sidebar_module
	WHERE link_id = 1092 

	SELECT title, content
	FROM sidebar_module
	WHERE link_id = 1093 

	SELECT title, content
	FROM sidebar_module
	WHERE link_id = 1090 

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
CERT_SERVER_SUBJECT=OU=Domain Control Validated, OU=EssentialSSL, CN=www.aucd.org
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\www\aauapweb\aucd\conference\index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
HTTPS_SERVER_SUBJECT=OU=Domain Control Validated, OU=EssentialSSL, CN=www.aucd.org
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.aucd.org
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=/conference/index.cfm
PATH_TRANSLATED=E:\www\aauapweb\aucd\conference\index.cfm
QUERY_STRING=
REMOTE_ADDR=54.162.128.159
REMOTE_HOST=54.162.128.159
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/conference/index.cfm
SERVER_NAME=www.aucd.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=

Client Variables:
cfid=22758170
cftoken=38118854
hitcount=1
lastvisit={ts '2018-07-20 10:51:23'}
timecreated={ts '2018-07-20 10:51:23'}
urltoken=CFID=22758170&CFTOKEN=38118854

Cookie Variables:
CFID=22758170
CFTOKEN=38118854

Session Variables:
cfg_admin_directory=/aucd_admin/
cfg_article_url=../resources/digest/issue.cfm?article_id=
cfg_authentication=HTML
cfg_client_full_name=AUCD
cfg_client_id=247
cfg_client_short_name=AUCD
cfg_database_type=mysql
cfg_dateformat=m/d/yyyy
cfg_doc_extension=doc,pdf,xls,txt,wpd,rtf,jpg,jpeg,gif,bmp,png,ppt,pps,mp3
cfg_doc_path=/docs/
cfg_ecp_feedback=bkaufman@AUCD.ORG
cfg_ecp_share=bkaufman@AUCD.ORG
cfg_editor_path=/tiny_mce/
cfg_email_actearlynews_submission=agriffen@AUCD.ORG, oklimova@aucd.org
cfg_email_council_cis=
cfg_email_council_coca=
cfg_email_council_core=
cfg_email_council_mcc=oklimova@aucd.org
cfg_email_council_ncedc=
cfg_email_council_ntdc=
cfg_email_developments_submission=lvaldez@aucd.org
cfg_email_digest_submission=acostalas@AUCD.ORG
cfg_email_hdd_submission=jminor@aucd.org
cfg_email_lend_application_submission=jperry@AUCD.ORG
cfg_email_pmu_submission=ynikola-lisa@aucd.org
cfg_email_spotlight_submission=cpariseau@aucd.org
cfg_email_stimulus=oklimova@aucd.org
cfg_email_website_feedback=oklimova@aucd.org
cfg_encoding=ISO-8859-1
cfg_evaluation_review=agriffen@AUCD.ORG
cfg_has_article_dept=Yes
cfg_has_article_issue=Yes
cfg_has_article_issuedept=Yes
cfg_has_article_type=0
cfg_has_crm=No
cfg_has_document=0
cfg_has_event_topic=Yes
cfg_has_feature_home_page=0
cfg_has_friendly_urls=No
cfg_has_issue_number=Yes
cfg_has_issue_summary=Yes
cfg_has_issue_volume=Yes
cfg_has_module_heading=Yes
cfg_has_new_topic=Yes
cfg_has_news_author=1
cfg_has_news_topic=Yes
cfg_has_person_address=0
cfg_has_person_board=Yes
cfg_has_person_country=0
cfg_has_person_custom=Yes
cfg_has_person_department=1
cfg_has_person_fax=Yes
cfg_has_person_photo=Yes
cfg_has_photo_expiration=0
cfg_has_sidebar=0
cfg_has_topic_parent_id=0
cfg_has_xml_import=0
cfg_live_default=No
cfg_log_number_of_months=4
cfg_mail_from=aucdinfo@aucd.org
cfg_mail_server=
cfg_module_detail_options=3
cfg_ngsd_about=681
cfg_ngsd_email_notification=oklimova@aucd.org,drudolph@aucd.org,beckmanncc@umkc.edu,spalmer@ku.edu,walkerla@umkc.edu,ericecook@sbcglobal.net,gottog@umkc.edu
cfg_ngsd_events=685
cfg_ngsd_join_listserve=687
cfg_ngsd_links=686
cfg_ngsd_news=684
cfg_ngsd_resources=683
cfg_ngsd_topics=682
cfg_ngsd_training=680
cfg_paging_count_landing=3
cfg_paging_count_list=15
cfg_path=
cfg_path_include=
cfg_paths_relative_to=root
cfg_person_notes_label=Notes
cfg_photo_album_view=JavaScript:openNewWindow('../template/slideshow.cfm?album_id={{id}}',800,750);
cfg_photo_path=/images2/
cfg_remember_login=1
cfg_rtoi_year=2012
cfg_search_resilience=per session
cfg_show_error_details=0
cfg_sidebar_positions=Left,Right
cfg_specific_items_days=730
cfg_specific_items_sort=Name
cfg_title=Content Management System
cfg_type_link_to=code
cfid=22758170
cftoken=38118854
sessionid=AUCDWEBSITE_22758170_38118854
urltoken=CFID=22758170&CFTOKEN=38118854

URL Parameters:
ID=50183
MODE=view