About PubStumpers

Sensing that the North American trivia-oriented pub games market was relatively untapped and that technological innovations are, ironically, polarizing individuals in theoretically social eating and drinking environments, the PubStumpers concept was hatched.

Based loosely on the British-style pub quiz, PubStumpers is a North America-wide federation of trivia leagues in which teams of contestants compete in weekly live-hosted trivia nights at participating bars. A 12-week season trivia package includes all the game materials and marketing tools necessary to administer a successful trivia league.

All a prospective bar needs is a sound system, an engaging host, an agile bartender and enthusiastic servers to keep the food and spirits flowing.

Any bar or pub, cosmopolitan or rural, corporate franchise or independent "mom and pop" operation, will score a home run with PubStumpers. Launch your league today! If you host it, the players will come!



Copyright © 2016 Braintrust Games, Inc. All rights reserved.


Debugging Information
ColdFusion Server Standard 2016,0,03,301771
Template /index.cfm
Time Stamp 09-Feb-23 01:15 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 199.38.148.63
Host Name 199.38.148.63


Execution Time

Total Time Avg Time Count Template
188 ms 188 ms 1 top level c:\rave7ps\index.cfm
172 ms 172 ms 1 C:/rave7ps/p_layout.cfm
78 ms 78 ms 1 C:/rave7ps/p_prebody.cfm
32 ms 32 ms 1 C:/rave7ps/p_headerplugins.cfm
31 ms 31 ms 1 C:/rave7ps/p_body.cfm
31 ms 31 ms 1 C:/rave7ps/p_stager.cfm
31 ms 31 ms 1 C:/rave7ps/pubstumpers/templates/splash/index.cfm
16 ms 16 ms 1 C:/rave7ps/p_initializesites.cfm
16 ms 16 ms 1 C:/rave7ps/p_showcontent.cfm
15 ms 15 ms 1 c:/rave7ps/Application.cfm
0 ms 0 ms 1 C:/rave7ps/pubstumpers/default/home/docvars_10725.cfm
0 ms 0 ms 1 C:/rave7ps/pubstumpers/default/home/docvars_home.cfm
0 ms 0 ms 1 C:/rave7ps/pubstumpers/default/home/page_10725.cfm
0 ms 0 ms 1 C:/rave7ps/pubstumpers/default/home/urltrail_10000.cfm
0 ms 0 ms 1 C:/rave7ps/pubstumpers/default/home/urltrail_10725.cfm
0 ms 0 ms 1 C:/rave7ps/pubstumpers/inimasterdsn.cfm
0 ms 0 ms 1 C:/rave7ps/pubstumpers/plg_splash.cfm
0 ms 0 ms 1 C:/rave7ps/pubstumpers/templates/splash/styles.cfm
0 ms 0 ms 1 C:/rave7ps/pwtreconfigure.cfm
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
219 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

d (Datasource=rave7domainDSN, Time=15ms, Records=1) in c:\rave7ps\Application.cfm @ 01:15:38.038
		select directory,template from domains where domain_name='pubs.pubstumpers.com'
		
q (Datasource=pubstumpers, Time=16ms, Records=120) in C:\rave7ps\p_initializesites.cfm @ 01:15:38.038
	select option_name,p_portal as V from website_settings
	
webpage (Datasource=pubstumpers, Time=15ms, Records=1) in C:\rave7ps\p_prebody.cfm @ 01:15:38.038
select document_id,crosssite_content from 
p_portal 
	where 
	p_portal.document_id='10725'
	
		and p_portal.published='Y'
		and (published_start_date is null or ( published_start_date<={d '2023-02-09'} and published_end_date>={d '2023-02-09'} ))
	
checklog (Datasource=pubstumpers, Time=0ms, Records=1) in C:\rave7ps\p_prebody.cfm @ 01:15:38.038
			select log_type from weblog  where log_ipaddress='199.38.148.63' and log_date={d'2023-02-09'} and log_page='Splash'
			
(Datasource=pubstumpers, Time=0ms, Records=1) in C:\rave7ps\p_prebody.cfm @ 01:15:38.038
				insert into weblog (broadcast_id,global_id,form_name,unique_hit,log_type,log_date,log_time,log_userid,log_ipaddress,log_page,referer, log_website)
				values (null,null,null,0,'portal',{d'2023-02-09'},'01:15:38','UNKNOWN','199.38.148.63','Splash','', 'default')
				


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=c:\rave7ps\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=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=pubs.pubstumpers.com
HTTP_REFERER=
HTTP_URL=/index.cfm?DocId=14704
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.169.61.13
PATH_INFO=
PATH_TRANSLATED=c:\rave7ps\index.cfm
QUERY_STRING=DocId=14704
REMOTE_ADDR=199.38.148.63
REMOTE_HOST=199.38.148.63
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=pubs.pubstumpers.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Client Variables:
cfid=20339465
cftoken=881e2b0fce40c84f-102D7405-AC97-B26F-0384EEF9A56C69B0
client_plugin_stage=
css_profile=Default
currency=
currentbanner=
customeremulator=
devstage=
hitcount=1
lastdocid=10725
lastvisit={ts '2023-02-09 01:15:38'}
pluginstage=plugins
timecreated={ts '2023-02-09 01:15:38'}
urltoken=CFID=20339465&CFTOKEN=881e2b0fce40c84f-102D7405-AC97-B26F-0384EEF9A56C69B0&jsessionid=F4CF6FC8D27ECEF778725EDE56CE2004.cfusion
webdbf=p_portal
website=default
website_language=home
Cookie Variables:
CFID=20339465
CFTOKEN=881e2b0fce40c84f-102D7405-AC97-B26F-0384EEF9A56C69B0
SPLASH=1
Session Variables:
sessionid=F4CF6FC8D27ECEF778725EDE56CE2004.cfusion
template_flavicon=pubstumpers/images/favicon.ico
urltoken=CFID=20339465&CFTOKEN=881e2b0fce40c84f-102D7405-AC97-B26F-0384EEF9A56C69B0&jsessionid=F4CF6FC8D27ECEF778725EDE56CE2004.cfusion
URL Parameters:
DocId=14704
Debug Rendering Time: 15 ms