Ultra Draft

Gin & Juice Draft Tourney

Event: Showcase Draft - Spring 2025 (Other Events)
Sport: Softball
Men's / Women'sCompetitiveDraft
Event Director
Gin & Juice
Contact / Learn More
Venue
International Drive Fields
Myrtle Beach, SC
Dates
Mar 29, 2025 - Mar 30, 2025
Days
Hours
Minutes
Seconds
Join Ultra Draft

Player Packages

Free Agent Package

You will be drafted onto a team and will be clearly identified as a Free Agent so both your own coaches and others can keep an eye on you for future tourney team consideration.

  • 1 Fully Custom FREE AGENT Style Jersey ($45 Retail)*
  • You Pick Your Playing Position for Pool Play
  • You Can't Be Sat During Pool Play (Unless Injured)
  • Min 2 Innings of Defense + Bat in Bracket
  • 5 Game Guarantee
  • Eligible for Prizes

$75

Select This Package

Package Disclaimer: Packages with customized elements must have minimum payment received no later than 21 days before the event. If payment is delayed, items may be ordered late but could be missing some customized data such as names and/or numbers.

Coach

Bring up to 6 players (other than yourself) and draft the rest of the team. If you bring a full team (6 players), receive your fee back in merch credit.

  • 5 Game Guarantee
  • Eligible for Prizes

$39

Select This Package

Package Disclaimer: Packages with customized elements must have minimum payment received no later than 21 days before the event. If payment is delayed, items may be ordered late but could be missing some customized data such as names and/or numbers.

Play Only (Pre-Recruited)

Select if you have been recruited by your coach to play on a specific team for this event. After completing payment, your coach can add you to their roster.

  • Play Only
  • 5 Game Guarantee
  • Eligible for Prizes

$39

Select This Package

Package Disclaimer: Packages with customized elements must have minimum payment received no later than 21 days before the event. If payment is delayed, items may be ordered late but could be missing some customized data such as names and/or numbers.

91 325
PEAK MEMORY: 9.24 MiB
MEMORY USAGE AFTER: 8.36 MiB

Debug Information


Request Variables

var = ultra

varb = gin-juice-draft-tourney

varc = showcase-draft-2025

vard = packages

vara =

vare =

view_var = ultra

view_varb = gin-juice-draft-tourney

view_varc = showcase-draft-2025

view_vard = packages

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: 76e947bc738ee757386973b68dadbf85

Login Type:

BASE:: ultra

FULL LINK:: ultra/gin-juice-draft-tourney/showcase-draft-2025/packages

Page ID: 57

Page ID:: 57

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 = 76e947bc738ee757386973b68dadbf85
fullstate =


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/gin-juice-draft-tourney/showcase-draft-2025/packages/
QUERY_STRING = var=ultra&varb=gin-juice-draft-tourney&varc=showcase-draft-2025&vard=packages
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=gin-juice-draft-tourney&varc=showcase-draft-2025&vard=packages
REDIRECT_URL = /ultra/gin-juice-draft-tourney/showcase-draft-2025/packages/
REMOTE_PORT = 28715
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 = 18.222.51.159
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/ultra/gin-juice-draft-tourney/showcase-draft-2025/packages
HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
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/ultra/gin-juice-draft-tourney/showcase-draft-2025/packages/
SCRIPT_URL = /ultra/gin-juice-draft-tourney/showcase-draft-2025/packages/
UNIQUE_ID = Z1CognSeijHn5oEqGX5GTAAAAdA
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/gin-juice-draft-tourney/showcase-draft-2025/packages/
REDIRECT_SCRIPT_URL = /ultra/gin-juice-draft-tourney/showcase-draft-2025/packages/
REDIRECT_UNIQUE_ID = Z1CognSeijHn5oEqGX5GTAAAAdA
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1733339266.5601
REQUEST_TIME = 1733339266


SQL Queries


Total Queries: 55
Total Execution Time: 12.6519ms
Avg Execution Time:0.23003454545455ms

QUERY(1.1342ms) - 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-04', '19:07:46', 'GET', '/ultra/gin-juice-draft-tourney/showcase-draft-2025/packages/', '18.222.51.159', 'https://netstuffersdev1.com/ultra/gin-juice-draft-tourney/showcase-draft-2025/packages' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhd0tzN3NhcU9WQnd6TXpjcVZXanIrc3NJT2JVZHl1TnVwQ0xDVXgybFpoMEIwOXc0M2E4WUFoWndYd0E4WXZXY3M2Z3lhVTRxVy9qME82L1J5ZWhWeUE=','0','','1733339266') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1588ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/gin-juice-draft-tourney/showcase-draft-2025/packages/'

QUERY(0.2429ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='ultra/gin-juice-draft-tourney/showcase-draft-2025/packages' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.149ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.1419ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5741ms) - 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` = 'gin-juice-draft-tourney' LIMIT 0,1

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

QUERY(0.494ms) - 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` = '91' and `league_seasons`.`url` = 'showcase-draft-2025' ORDER BY `league_dates`.`start_date` ASC

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

QUERY(0.169ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=325

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

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

QUERY(0.1919ms) - 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`=91 && `season_id`=325 LIMIT 0,1

QUERY(0.252ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=91 && `season_id`=325 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

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

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

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

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

QUERY(0.1311ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.169ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='gin-juice-draft-tourney'

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

QUERY(0.114ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.108ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1099ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.129ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='91' && `season_id`='325' LIMIT 0,1

QUERY(0.1268ms) - SELECT * FROM `league_notices` WHERE `league_id`=91 && `season_id`=325

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

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

QUERY(0.201ms) - SELECT SQL_CACHE `img_url`,`name`,`moreinfo` FROM `league_sponsors` LEFT JOIN `photo` ON `photo_id`=`logo_id` WHERE `league_id`=91 && `season_id`=325

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

QUERY(0.109ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.0999ms) - SELECT SQL_CACHE * FROM draft_config

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

QUERY(0.097ms) - SELECT SQL_CACHE * FROM payments_config

QUERY(0.1469ms) - SELECT `contactinfo` FROM `league_custom_content` WHERE `league_id`=91 && `season_id`=325

QUERY(0.2341ms) - SELECT COUNT(`package_id`) FROM `league_reg_packages` WHERE `season_id`=325 && `active`=1 ORDER BY `active` DESC

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

QUERY(0.113ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.283ms) - SELECT * FROM `league_reg_packages` WHERE `season_id`=325 && `visible`=1 ORDER BY `active` DESC,`sort` ASC,`price` DESC

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