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 20-Mar-23 10:57 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
171 ms 171 ms 1 top level c:\rave7ps\index.cfm
156 ms 156 ms 1 C:/rave7ps/p_layout.cfm
94 ms 94 ms 1 C:/rave7ps/p_prebody.cfm
31 ms 31 ms 1 C:/rave7ps/pubstumpers/templates/splash/index.cfm
16 ms 16 ms 1 C:/rave7ps/p_stager.cfm
16 ms 16 ms 1 c:/rave7ps/Application.cfm
15 ms 15 ms 1 C:/rave7ps/p_headerplugins.cfm
0 ms 0 ms 1 C:/rave7ps/p_body.cfm
0 ms 0 ms 1 C:/rave7ps/p_initializesites.cfm
0 ms 0 ms 1 C:/rave7ps/p_showcontent.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
203 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

d (Datasource=rave7domainDSN, Time=0ms, Records=1) in c:\rave7ps\Application.cfm @ 10:57:41.041
		select directory,template from domains where domain_name='players.pubstumpers.com'
		
q (Datasource=pubstumpers, Time=0ms, Records=120) in C:\rave7ps\p_initializesites.cfm @ 10:57:41.041
	select option_name,p_portal as V from website_settings
	
webpage (Datasource=pubstumpers, Time=15ms, Records=1) in C:\rave7ps\p_prebody.cfm @ 10:57:41.041
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-03-20'} and published_end_date>={d '2023-03-20'} ))
	
checklog (Datasource=pubstumpers, Time=0ms, Records=1) in C:\rave7ps\p_prebody.cfm @ 10:57:41.041
			select log_type from weblog  where log_ipaddress='199.38.148.63' and log_date={d'2023-03-20'} and log_page='Splash'
			
(Datasource=pubstumpers, Time=0ms, Records=1) in C:\rave7ps\p_prebody.cfm @ 10:57:41.041
				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-03-20'},'10:57:41','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=players.pubstumpers.com
HTTP_REFERER=
HTTP_URL=/index.cfm
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=
REMOTE_ADDR=199.38.148.63
REMOTE_HOST=199.38.148.63
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=players.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=20871567
cftoken=fe71e7f02890cd69-FB44C31E-AEB0-7053-880BFD0944CDD00F
client_plugin_stage=
css_profile=Default
currency=
currentbanner=
customeremulator=
devstage=
hitcount=1
lastdocid=10725
lastvisit={ts '2023-03-20 10:57:41'}
pluginstage=plugins
timecreated={ts '2023-03-20 10:57:41'}
urltoken=CFID=20871567&CFTOKEN=fe71e7f02890cd69-FB44C31E-AEB0-7053-880BFD0944CDD00F&jsessionid=0EC066EDC0FF4B334F956E7B4CC51A38.cfusion
webdbf=p_portal
website=default
website_language=home
Cookie Variables:
CFID=20871567
CFTOKEN=fe71e7f02890cd69-FB44C31E-AEB0-7053-880BFD0944CDD00F
SPLASH=1
Session Variables:
sessionid=0EC066EDC0FF4B334F956E7B4CC51A38.cfusion
template_flavicon=pubstumpers/images/favicon.ico
urltoken=CFID=20871567&CFTOKEN=fe71e7f02890cd69-FB44C31E-AEB0-7053-880BFD0944CDD00F&jsessionid=0EC066EDC0FF4B334F956E7B4CC51A38.cfusion
URL Parameters:
DOCID=10725
PDOCID=10000
Debug Rendering Time: 16 ms