This event has completed. This information has been preserved for archival purposes.
Ultra Draft

Gastonia Ultra Draft

Event: Spooktacular Ultra Draft (Other Events)
Sport: Softball
CoedSocialDraft
Event Director
League Joe
Contact / Learn More
Venue
Dallas Park
Dallas, NC
Dates
Oct 26, 2024
This event has completed. This information has been preserved for archival purposes.
Join as Alternate
Registration Details
DatesCost Guaranteed Min Games
Oct 26, 202410/26/24Multiple Play Packages Available
Starting at $35.00		4View Package Options
Helpful Links:

Description

Get ready to light up the field at our Spooktacular Ultra Draft Tournament! Whether you come with a friend or fly solo, our innovative draft system promises fair play and fun for all. Open to everyone 18 and up, this is your chance to compete, connect, and celebrate with other enthusiasts. Join us for the game and stay for the unforgettable after-party!

Schedule Overview

Full Day of Spooky Good Times

Come out for the ball, stay for the party! The Spooktacular Ultra Draft is a one day tournament where we celebrate the best holiday of the year with costumes, prizes, and a trip to the Pickle to hang out in the evening!

Game Schedule

First game will occur in the mid-morning, giving everyone time to suit up and head to the fields. Before the evening is over, we'll have played a four game guarantee tournament that ends around dinner time. After that, we head out to the local watering hole to celebrate a day of ball.

Preliminary Schedule

  • Player Draft - 9:00am (at the fields)
  • First Game - 10:00am
  • Championship Game - 7-ish
  • After Party at the Pickle - 9pm+

Official After Party - The Pickle Bar & Bistro

pickleafterparty_recjoe1729196435.png

103 N Holland St, Dallas, NC 28034

Keep those costumes on and get ready to party at The Pickle Bar & Bistro. They have their official Halloween Party that same night, including cash prizes for their own costume contest!

Win Bats, Fielding Gloves, and More!

Think up a great costume and show up ready to look good, play good! Prizes for costumes include brand new bats and fielding gloves! Plus, one random player will receive their choice of a bat or fielding glove.

Individual and Team Prize List

https3a2f2fprod-files-secure-2_recjoe1729942295.png
alienscorn_recjoe1728509603.png
smalysen_recjoe1728509636.png
costumes_recjoe1728510002.png

Updates

  • UPDATE
  • Smitty AvatarSmitty

Spooktacular Gastonia Update

The Spooktacular is just a few days away, and we hope everyone is getting their costumes ready. If you're reading this email right now and haven't finished signing up, get in today!

Win Bats, Free Leagues, and More for Best Costumes

alienscorn_recjoe1728509603.png

We weren't kidding when we said we wanted to see y'all dress up, but we'll show you how serious we are by giving out a FREE BAT to the best costume in the tournament! Additionally, we'll have extra door prizes for snazzy dressers and a FREE LEAGUE to the best costume that is worn through the entire event. You gotta look good on and off the field after all, right?

Weekend Prize List

Get Drafted LIVE On Saturday

We will kick off the event on Saturday morning at 9am at the fields, where we will have our coaches draft the players LIVE! Come hang out, meet the other players, and find out in person where you'll be playing for the day. Play will kick off starting around 10am and the full schedule will be published soon.  Player kits and jerseys will also be picked up on Saturday morning before play begins.

After Party at the Pickle

The tournament will end in the evening, but you gotta get maximum mileage out of those costumes, right? So join us at the Pickle Bistro for our official After Party. The Pickle will have their own costume contest as well, with cash prizes and more!

Event Schedule
Continue Reading

Event Operator

League Joe
Contact Organizer
PEAK MEMORY: 11.4 MiB
MEMORY USAGE AFTER: 10.37 MiB

Debug Information


Request Variables

var = tournament

varb = gastonia-ultra-draft

varc = spooktacular-ultra-draft

vara =

vard =

vare =

view_var = tournament

view_varb = gastonia-ultra-draft

view_varc = spooktacular-ultra-draft

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: 8f9a1a893da5c3d23444f506eb28cef0

Login Type:

BASE:: tournament

FULL LINK:: tournament/gastonia-ultra-draft/spooktacular-ultra-draft

Page ID: 40

Page ID:: 40

Page Template:: lj

Template Layout:: default

Headers: : Loading page header code

Active Blocks: Array ( [0] => [1] => [2] => 1 [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => )

Block Types: Array ( [0] => [1] => [2] => Array ( [0] => module ) [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => )

Element ID: Array ( [0] => [1] => [2] => Array ( [0] => 10 ) [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => )

Admin Login Level: :

Footer: : Loading page footer code


Session Variables

securetoken = 8f9a1a893da5c3d23444f506eb28cef0
fullstate =


Cookie Variables

fikker-InIR-Qh5V = mbyZOTi0cx3R3LgZidkBShUMQdqPNMmO


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
QUERY_STRING = var=tournament&varb=gastonia-ultra-draft&varc=spooktacular-ultra-draft
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=tournament&varb=gastonia-ultra-draft&varc=spooktacular-ultra-draft
REDIRECT_URL = /tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
REMOTE_PORT = 33848
SCRIPT_FILENAME = /home/leaguejo_dev/public_html/index.php
SERVER_ADMIN = support@aod.net
CONTEXT_DOCUMENT_ROOT = /home/leaguejo_dev/public_html
CONTEXT_PREFIX =
REQUEST_SCHEME = https
DOCUMENT_ROOT = /home/leaguejo_dev/public_html
REMOTE_ADDR = 3.137.221.252
SERVER_PORT = 443
SERVER_ADDR = 162.248.190.150
SERVER_NAME = netstuffersdev1.com
SERVER_SOFTWARE = Apache
SERVER_SIGNATURE =
PATH = /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
HTTP_HOST = netstuffersdev1.com
HTTP_REFERER = https://netstuffersdev1.com/tournament/gastonia-ultra-draft/spooktacular-ultra-draft
HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
HTTP_COOKIE = fikker-InIR-Qh5V=mbyZOTi0cx3R3LgZidkBShUMQdqPNMmO
HTTP_USER_AGENT = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_ACCEPT = */*
proxy-nokeepalive = 1
SSL_TLS_SNI = netstuffersdev1.com
HTTPS = on
SCRIPT_URI = https://netstuffersdev1.com/tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
SCRIPT_URL = /tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
UNIQUE_ID = Z26iz1r2U24gX-GqmPSIXQAAABY
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
REDIRECT_SCRIPT_URL = /tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
REDIRECT_UNIQUE_ID = Z26iz1r2U24gX-GqmPSIXQAAABY
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1735303887.8579
REQUEST_TIME = 1735303887


SQL Queries


Total Queries: 61
Total Execution Time: 14.9262ms
Avg Execution Time:0.24469180327869ms

QUERY(1.5562ms) - INSERT INTO security_log (domain,username, log_date, log_time, method, page, ip, address, browser, getvars, postvars, sessionvars,badlogin,userlogin,timestamp) VALUES ('.netstuffersdev1.com','','2024-12-27', '12:51:27', 'GET', '/tournament/gastonia-ultra-draft/spooktacular-ultra-draft/', '3.137.221.252', 'https://netstuffersdev1.com/tournament/gastonia-ultra-draft/spooktacular-ultra-draft' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhenNPNlRXR2JQR2trZHNGWUZhR2NjcCtQSk9XVmJhSzgrcVREeURCZUJnd1F0UUhTSXVKRVd6WGtjRFZPa1BuWDdnTEp1czI5ZnN1V1FhWHJ1VkNRWFY=','0','','1735303887') ON DUPLICATE KEY UPDATE `ip`=`ip`

QUERY(1.6429ms) - SELECT SQL_CACHE `end_timestamp` FROM `security_locks` WHERE ((`who`='3.137.221.252' && `which`='IP'))

QUERY(0.1512ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/tournament/gastonia-ultra-draft/spooktacular-ultra-draft/'

QUERY(0.231ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='tournament/gastonia-ultra-draft/spooktacular-ultra-draft' ORDER BY `domain`='1' DESC,`domain` ASC

QUERY(0.248ms) - SELECT SQL_CACHE `id`,`layout`,`light`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='tournament' ORDER BY `domain`='1' DESC,`domain` ASC

QUERY(0.1309ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay`,`customize` FROM `pages` WHERE `id`='40'

QUERY(0.139ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='userprofiles'

QUERY(0.1321ms) - SELECT * FROM userprofiles_config

QUERY(0.15ms) - SELECT SQL_CACHE `name` FROM `states` WHERE `abbr`='' LIMIT 0,1

QUERY(0.15ms) - SELECT SQL_CACHE title,metakeys,metadescript,seomodule,seotitlefield,seodescfield,seotitletable,seodesctable,urllinkfield FROM pages WHERE `id`='40' && `domain`='1'

QUERY(0.133ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

QUERY(0.118ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5059ms) - SELECT SQL_CACHE `leagues`.*,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`photo`.`img_url`,`photo`.`photo_id` AS `league_logo_id`,`photo`.`thumb_url`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,(SELECT COUNT(*) FROM `league_teams` WHERE `league_id`=`leagues`.`league_id`) AS `teams` FROM `leagues` INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`leagues`.`venue_id` = `venues`.`venue_id`) WHERE `leagues`.`url` = 'gastonia-ultra-draft' LIMIT 0,1

QUERY(0.139ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=1

QUERY(0.489ms) - SELECT SQL_CACHE `league_seasons`.*,`league_seasons`.`url` AS season_url,`photo`.`img_url`,`photo`.`thumb_url`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date`,`league_dates`.`manual_date_display` FROM `league_seasons` LEFT JOIN `photo` ON (`league_seasons`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_seasons`.`league_id` = '137' and `league_seasons`.`url` = 'spooktacular-ultra-draft' ORDER BY `league_dates`.`start_date` ASC

QUERY(0.1299ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=1

QUERY(0.1509ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=288

QUERY(0.1042ms) - SELECT SQL_CACHE `zone_name` FROM `zone` WHERE `zone_id`=1026 LIMIT 0,1

QUERY(0.1411ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit`,`total_pay_required` FROM `league_custom_content` WHERE `league_id`=137 && `season_id`=288 LIMIT 0,1

QUERY(0.1581ms) - SELECT SQL_CACHE `allow_couples`,`disable_standings`,`type`,`groups`,`group_size`,`divisions`,`schedule_type`,`allow_alts`,`show_schedule_level` FROM `league_schedule_options` WHERE `league_id`=137 && `season_id`=288 LIMIT 0,1

QUERY(0.1841ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=137 && `season_id`=288 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

QUERY(0.1659ms) - SELECT SQL_CACHE `enabled` FROM `league_merch` WHERE `season_id`=288 LIMIT 0,1

QUERY(0.2151ms) - SELECT SQL_CACHE `code` FROM `page_headers` WHERE (`domain`=1||domain_global=1) && (`include` LIKE '%:40:%' || (`global`=1 && `exclude` NOT LIKE '%:40:%') ) ORDER BY `sort` ASC

QUERY(0.1218ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='America/Indianapolis'

QUERY(0.1931ms) - SELECT count(`league_id`) FROM `league_players` WHERE `player_id`=''

QUERY(0.1559ms) - SELECT SQL_CACHE `block_id`,`element_id`,`function_id`,`type` FROM `blocks` WHERE `page_id`='40' ORDER BY `order` ASC

QUERY(0.1791ms) - SELECT `abbr`,`name` FROM `states` WHERE `active`=1 ORDER BY `name` ASC

QUERY(0.109ms) - select SQL_CACHE codename,classname,scriptname from modules WHERE `id`='10'

QUERY(0.123ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

QUERY(0.0989ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.2239ms) - SELECT `company`.*,`img_url` FROM `company` INNER JOIN `photo` ON `photo`.`photo_id`=`company`.`logo_onwhite` WHERE `company_id`=1

QUERY(0.1299ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='gastonia-ultra-draft'

QUERY(0.1259ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

QUERY(0.103ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.119ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

QUERY(0.1178ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.1271ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

QUERY(0.1121ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.118ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='137' && `season_id`='288' LIMIT 0,1

QUERY(0.16ms) - SELECT * FROM `league_notices` WHERE `league_id`=137 && `season_id`=288

QUERY(0.7789ms) - SELECT SQL_CACHE `standings_id` FROM `standings` WHERE `season_id`=288 LIMIT 0,1

QUERY(0.2131ms) - SELECT SQL_CACHE `standings_override` FROM `league_schedule_options` WHERE `season_id`=288 LIMIT 0,1

QUERY(0.129ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

QUERY(0.124ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.1988ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=137 && `season_id`=288

QUERY(0.1352ms) - SELECT * FROM `league_hotel_settings` WHERE `league_id`=137 && `season_id`=288

QUERY(0.1009ms) - SELECT `game_term`,`game_terms` FROM `sports` WHERE `sport_id`=1

QUERY(0.114ms) - SELECT `comeswith` FROM `league_custom_content` WHERE `league_id`=137 && `season_id`=288

QUERY(0.2251ms) - SELECT `package_id` FROM `league_players` WHERE `player_id`=0 && `season_id`=288

QUERY(0.134ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='payments'

QUERY(0.0951ms) - SELECT SQL_CACHE * FROM payments_config

QUERY(0.1681ms) - SELECT `fee` FROM `league_seasons` WHERE `season_id`='288'

QUERY(0.4499ms) - SELECT `price` FROM `league_reg_packages` WHERE `season_id`=288 && `active`=1 &&`visible`=1 ORDER BY `price` ASC

QUERY(0.5629ms) - SELECT COUNT(*) FROM `article` INNER JOIN `article_text` ON (`article`.`article_id` = `article_text`.`article_id`) INNER JOIN `users` ON (`article`.`user_id` = `users`.`id`) INNER JOIN `league_updates` ON (`article`.`article_id` = `league_updates`.`article_id`) INNER JOIN `photo` ON (`users`.`avatar_id` = `photo`.`photo_id`) WHERE `league_updates`.`league_id` = '137' and `league_updates`.`season_id` = '288'

QUERY(1.0011ms) - SELECT SQL_CACHE `article`.`title`,`article`.`title_url`,`article`.`user_id`,`article`.`article_id`,`article`.`time_stamp`,`article`.`total_comment`,`article_text`.`text`,`users`.`username`,`users`.`user_url`,`league_updates`.`sent`,`photo`.`img_url` FROM `article` INNER JOIN `article_text` ON (`article`.`article_id` = `article_text`.`article_id`) INNER JOIN `users` ON (`article`.`user_id` = `users`.`id`) INNER JOIN `league_updates` ON (`article`.`article_id` = `league_updates`.`article_id`) INNER JOIN `photo` ON (`users`.`avatar_id` = `photo`.`photo_id`) WHERE `league_updates`.`league_id` = '137' and `league_updates`.`season_id` = '288' ORDER BY `article`.`time_stamp` desc LIMIT 0,3

QUERY(0.1311ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=137 && `season_id`=288

QUERY(0.14ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=137 && `season_id`=288

QUERY(0.1299ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=137 && `season_id`=288

QUERY(0.1841ms) - SELECT COUNT(`photographer_id`) FROM `league_photographers` WHERE `season_id`=288

QUERY(0.1979ms) - SELECT `venues`.*,`photo`.`img_url` FROM `venues` LEFT JOIN `photo` ON `venues`.`logo_id`=`photo`.`photo_id` WHERE `venue_id`=72

QUERY(0.2301ms) - SELECT SQL_CACHE `code`,`name` FROM `page_footers` WHERE (`domain`=1||domain_global=1) && (`include` LIKE '%:40:%' || (`global`=1 && `exclude` NOT LIKE '%:40:%') ) ORDER BY `sort` ASC