<?php
Header("Cache-Control: max-age=3000, must-revalidate");

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;
use PHPMailer\PHPMailer\Exception;

if ($_SERVER['REQUEST_METHOD'] == 'POST') {

//Import PHPMailer classes into the global namespace
//These must be at the top of your script, not inside a function


//Load Composer's autoloader
require 'vendor/autoload.php';



//Rg49@6cP1x!0
$servername = "localhost";
$username = "playHockey";
$password = "Rg49@6cP1x!0";
$dbname = "playHockey";

$seasonId = "3";

$DEBUG = FALSE;

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO draftRegistrations (draftEmail, draftSeasonId, draftContactNumber, draftSkaterFirst, draftSkaterLast, draftLeague, draftDOB, draftHighestLevel, draftOtherLeagues, draftShoots) VALUES " .
	"('" . mysqli_real_escape_string($conn, $_POST["draftEmail"]) . "', '" . $seasonId . "', '" . mysqli_real_escape_string($conn, $_POST["draftNumber"]) . "', '" . mysqli_real_escape_string($conn, $_POST["skaterFirst"]) . "', '" . mysqli_real_escape_string($conn, $_POST["skaterLast"]) . "', '" . mysqli_real_escape_string($conn, $_POST["league"]) . "', '" . mysqli_real_escape_string($conn, $_POST["DOB"]) . "', '" . mysqli_real_escape_string($conn, $_POST["highestLevel"]) . "', '" . mysqli_real_escape_string($conn, $_POST["otherLeagues"]) . "', '". mysqli_real_escape_string($conn, $_POST["shoots"]) . "')";
if (!$result = mysqli_query($conn, $sql)) {
	echo("Error: " . mysqli_error($conn));
} else {

$mail = new PHPMailer(true);

try {
    //Server settings
//    $mail->SMTPDebug = SMTP::DEBUG_SERVER;                      //Enable verbose debug output
    $mail->isSMTP();                                            //Send using SMTP
    $mail->Host       = 'smtp.zoho.com';                     //Set the SMTP server to send through
    $mail->SMTPAuth   = true;                                   //Enable SMTP authentication
    $mail->Username   = 'noreply@mvhl.org';                     //SMTP username
    $mail->Password   = 'yxni5-Lm';                               //SMTP password
    $mail->SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS;            //Enable implicit TLS encryption
    $mail->Port       = 587;                                    //TCP port to connect to; use 587 if you have set `SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS`

    //Recipients
    $mail->setFrom('noreply@mvhl.org', 'MVHL Draft');
    $mail->addAddress($_POST["draftEmail"]);     //Add a recipient
    $mail->addBCC('jlamb009@gmail.com');

    //Content
    $mail->isHTML(true);                                  //Set email format to HTML
    $mail->Subject = '2025-2026 B & C League Draft Registration';
    $mail->Body    = 'Congratulations, this email is confirming your registration for this seasons draft!';
    $mail->AltBody = 'Congratulations! This email is confirming your registration for this seasons draft!';

    $mail->send();
//    echo 'Message has been sent';
} catch (Exception $e) {
//    echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";
}

}

}
?>
<!DOCTYPE html>
<html lang="zxx">
<head>

	<!-- Basic Page Needs
	================================================== -->
	<title>Mohawk Valley Hockey League - Draft Registration</title>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="description" content="Draft registration">
	<meta name="author" content="Jon Lamb">
	<meta name="keywords" content="sports hockey b c draft">

	<!-- Favicons
	================================================== -->
	<link rel="shortcut icon" href="assets/images/hockey/favicons/favicon.ico">
	<link rel="apple-touch-icon" sizes="120x120" href="assets/images/hockey/favicons/favicon-120.png">
	<link rel="apple-touch-icon" sizes="152x152" href="assets/images/hockey/favicons/favicon-152.png">

	<!-- Mobile Specific Metas
	================================================== -->
	<meta name="viewport" content="width=device-width,initial-scale=1.0,maximum-scale=1.0,user-scalable=0">

	<!-- Google Web Fonts
	================================================== -->
	<link rel="preconnect" href="https://fonts.googleapis.com">
	<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
	<link href="https://fonts.googleapis.com/css2?family=Ubuntu:ital,wght@0,400;0,500;0,700;1,400;1,500;1,700&amp;display&#x3D;swap" rel="stylesheet">

	<!-- CSS
	================================================== -->
	<!-- Vendor CSS -->
	<link href="assets/vendor/bootstrap/css/bootstrap.css" rel="stylesheet">
	<link href="assets/fonts/font-awesome/css/all.min.css" rel="stylesheet">
	<link href="assets/fonts/simple-line-icons/css/simple-line-icons.css" rel="stylesheet">
	<link href="assets/vendor/magnific-popup/dist/magnific-popup.css" rel="stylesheet">
	<link href="assets/vendor/slick/slick.css" rel="stylesheet">
	<link href="assets/vendor/swiper/css/swiper-bundle.min.css" rel="stylesheet">

	<!-- Template CSS-->
	<link href="assets/css/style-hockey.css" rel="stylesheet">

	<!-- Custom CSS-->
	<link href="assets/css/custom.css" rel="stylesheet">

</head>
<body data-template="template-hockey"  >
<?php if ($DEBUG == TRUE) { echo "<pre>" . print_r($_POST) . "</pre>"; }
?>
	<div class="site-wrapper clearfix">
		<div class="site-overlay"></div>


		<!-- Header
		================================================== -->
		
		<!-- Header Mobile -->
		<div class="header-mobile clearfix" id="header-mobile">
			<div class="header-mobile__logo">
				<a href="_hockey_index.html"><img src="assets/images/hockey/logo.png" srcset="assets/images/hockey/logo@2x.png 2x" alt="Alchemists" class="header-mobile__logo-img"></a>
			</div>
			<div class="header-mobile__inner">
				<a id="header-mobile__toggle" class="burger-menu-icon"><span class="burger-menu-icon__line"></span></a>
				<span class="header-mobile__search-icon" id="header-mobile__search-icon"></span>
			</div>
		</div>
		
		<!-- Header Desktop -->
		<header class="header header--layout-5">
		
			<!-- Header Secondary -->
			<div class="header__secondary header__secondary--split-bg">
				<!-- Header Secondary Background -->
				<div class="header__secondary-bg-layer effect-duotone effect-duotone--primary"></div>
				<!-- Header Secondary Background / End -->
		
				<div class="container">
		
					<!-- Header Search Form -->
					<div class="header-search-form d-block d-lg-none">
						<form action="#" id="mobile-search-form" class="search-form">
							<input type="text" class="form-control header-mobile__search-control" value="" placeholder="Enter your search here...">
							<button type="submit" class="header-mobile__search-submit"><i class="fas fa-search"></i></button>
						</form>
					</div>
					<!-- Header Search Form / End -->
		
					<!-- Social Icons -->
					<ul class="info-block info-block--header info-block--social">
						<li class="info-block__item info-block__item--sm">
							<div class="df-icon df-icon--custom">
								<i class="fab fa-facebook"></i>
							</div>
							<h6 class="info-block__heading">Facebook</h6>
							<a class="info-block__link" href="https://www.facebook.com/groups/cshlb">/clintonB</a>
						</li>
						<li class="info-block__item info-block__item--sm">
							<div class="df-icon df-icon--custom">
								<i class="fab fa-twitter"></i>
							</div>
							<h6 class="info-block__heading">Twitter</h6>
							<a class="info-block__link" href="#">/@mvhlB</a>
						</li>
						<li class="info-block__item info-block__item--sm">
							<div class="df-icon df-icon--custom">
								<i class="fab fa-instagram"></i>
							</div>
							<h6 class="info-block__heading">Instagram</h6>
							<a class="info-block__link" href="#">@mvhlB</a>
						</li>
					</ul>
					<!-- Social Icons / End -->
		
					<!-- Info Block -->
					<ul class="info-block info-block--header">
						<li class="info-block__item info-block__item--contact-primary">
							<svg role="img" class="df-icon df-icon--tshirt">
								<use xlink:href="assets/images/hockey/icons-hockey.svg#tshirt"/>
							</svg>
							<h6 class="info-block__heading">Join Our League!</h6>
							<a class="info-block__link" href="#">Draft Registration</a>
						</li>
						<li class="info-block__item info-block__item--contact-secondary">
							<svg role="img" class="df-icon df-icon--puck">
								<use xlink:href="assets/images/hockey/icons-hockey.svg#puck"/>
							</svg>
							<h6 class="info-block__heading">Contact Us</h6>
							<a class="info-block__link" href="mailto:jlamb009@gmail.com">leagueinfo</a>
						</li>











					</ul>
					<!-- Info Block / End -->
				</div>
			</div>
			<!-- Header Secondary / End -->
		
			<!-- Header Primary -->
			<div class="header__primary">
				<div class="container">
					<div class="header__primary-inner">
		
						<!-- Header Logo -->
						<div class="header-logo">
							<a href="_hockey_index.html"><img src="assets/images/hockey/logo.png" srcset="assets/images/hockey/logo@2x.png 2x" alt="Alchemists" class="header-logo__img"></a>
						</div>
						<!-- Header Logo / End -->
		
						<!-- Main Navigation -->
						<nav class="main-nav clearfix">
							<ul class="main-nav__list">
								<li class=""><a href="#">Home</a>
									<ul class="main-nav__sub">
										<li class=""><a href="#">2025 Draft Registration</a></li>
									</ul>
								</li>
								<li class=""><a href="#">Our Leagues</a>
									<div class="main-nav__megamenu clearfix">
										<ul class="col-lg-4 col-md-3 col-12 main-nav__ul main-nav__ul-2cols">
											<li class="main-nav__title">Features</li>
											<li><a href="#">Constitution & Bylaws</a></li>
											<li><a href="#">Player Waivers</a></li>
											<li><a href="#">League Rules</a></li>
											<li><a href="#">Goaltender Substitutions</a></li>
											<li><a href="#">News Archive</a></li>
											<li><a href="#">Our Sponsors</a></li>
											<li><a href="#">Entry Draft</a></li>
											<li><a href="#">Playoff Tiebreaker Reference</a></li>
										</ul>
										<ul class="col-lg-2 col-md-3 col-12 main-nav__ul">
											<li class="main-nav__title">Team Pages</li>
											<li class=""><a href="#">Overview</a></li>
											<li class=""><a href="#">Roster</a></li>
											<li class=""><a href="#">Standings</a></li>
											<li class=""><a href="#">Latest Results</a></li>
											<li class=""><a href="#">Schedule</a></li>
											<li class=""><a href="#">Gallery</a></li>
										</ul>
										<ul class="col-lg-2 col-md-3 col-12 main-nav__ul">
											<li class="main-nav__title">Player Pages</li>
											<li class=""><a href="#">Overview</a></li>
											<li class=""><a href="#">Profile Entry</a></li>
										</ul>
										<ul class="col-lg-2 col-md-3 col-12 main-nav__ul">
											<li class="main-nav__title">Match Pages</li>
											<li class=""><a href="#">Overview</a></li>
											<li class=""><a href="#">Box Score</a></li>
											<li class=""><a href="#">Team Stats</a></li>
											<li class=""><a href="#">News Recap</a></li>
										</ul>
									</div>
								</li>
								<li class=""><a href="#">Team</a>
									<ul class="main-nav__sub">
										<li><a href="#">Team</a>
											<ul class="main-nav__sub-2">
												<li class="">
													<a href="#">Overview</a>
												</li>
												<li class="">
													<a href="#">Roster</a>
												</li>
												<li class="">
													<a href="#">Standings</a>
												</li>
												<li class="">
													<a href="#">Latest Results</a>
												</li>
												<li class="">
													<a href="#">Schedule</a>
												</li>
												<li class="">
													<a href="#">Gallery</a>
													<ul class="main-nav__sub-2">
														<li><a href="#">Single Album</a></li>
													</ul>
												</li>
											</ul>
										</li>
										<li><a href="#">Player</a>
											<ul class="main-nav__sub-2">
												<li class=""><a href="#">Overview</a></li>
												<li class=""><a href="#">Career Stats</a></li>
												<li class=""><a href="#">Games Log</a></li>
												<li class=""><a href="#">Awards</a></li>
											</ul>
										</li>
										<li><a href="#">Staff Member</a></li>
										<li><a href="#">Event</a>
											<ul class="main-nav__sub-2">
												<li class=""><a href="#">Overview</a></li>
												<li class=""><a href="#">Box Score</a></li>
												<li class=""><a href="#">Play-by-Play</a></li>
												<li class=""><a href="#">Team Stats</a></li>
												<li class=""><a href="#">News Recap</a></li>
												<li class=""><a href="#">Videos</a></li>
											</ul>
										</li>
										<li><a href="#">Game Overview</a></li>
										<li><a href="#">Tournament</a></li>
									</ul>
								</li>
								<li class=""><a href="#">News</a>
									<ul class="main-nav__sub">
										<li class=""><a href="#">Recent</a></li>
										<li class=""><a href="#">Archive</a></li>
									</ul>
								</li>
							</ul>
		
							<!-- Account Navigation -->
							<ul class="nav-account">
								<li class="nav-account__item">
									<a href="#">
										<svg role="img" class="df-icon df-icon--helmet">
											<use xlink:href="assets/images/hockey/icons-hockey.svg#helmet"/>
										</svg>
									</a>
									<ul class="main-nav__sub main-nav__sub--account">
										<li class="main-nav__sub-heading">
											<a href="#">
												Hello!
												<img src="assets/images/hockey/samples/header-user-avatar.jpg" alt="" class="main-nav__sub-heading-avatar">
												<span class="highlight">Anonymous</span>
											</a>
										</li>
										<li><a href="#">Account Settings</a></li>
										<li><a href="#">Logout</a></li>
									</ul>
								</li>
							</ul>
							<!-- Account Navigation / End -->
		
							<!-- Search Toggle -->
							<a href="#" class="search__toggle search__toggle--skewed">
								<svg role="img" class="df-icon df-icon--search">
									<use xlink:href="assets/images/hockey/icons-hockey.svg#search"/>
								</svg>
							</a>
							<!-- Search Toggle / Eng -->
		
						</nav>
						<!-- Main Navigation / End -->
		
		
					</div>
				</div>
			</div>
			<!-- Header Primary / End -->
		
		</header>
		<!-- Header / End -->
		
		<!-- Search Panel -->
		<aside class="search-panel">
			<form action="https://necromancers-wp.dan-fisher.dev/" id="search-panel-form" class="search-panel-form">
				<input type="text" name="s" id="s" class="form-control" placeholder="What are you looking for...?">
			</form>
		</aside>
		<!-- Search Panel / End -->

		<!-- Page Heading
		================================================== -->
		<div class="page-heading page-heading--horizontal page-heading--title-highlight">
			<div class="container">
				<div class="row justify-content-between">
					<div class="col-6">
						<div class="page-heading__inner page-heading__inner--highlight">
							<h1 class="page-heading__title">2025 MVHL Draft Registration</h1>
						</div>
					</div>
					<div class="col-6">
						<div class="page-heading__inner ml-auto">
							<ol class="page-heading__breadcrumb breadcrumb">
								<li class="breadcrumb-item"><a href="_hockey_index.html">Home</a></li>
								<li class="breadcrumb-item active" aria-current="page">Login and Register</li>
							</ol>
						</div>
					</div>
				</div>
			</div>
		</div>
		<!-- Page Heading / End -->
		
		
		<!-- Content
		================================================== form-group--floating-label -->
		<div class="site-content">
			<div class="container">
		
				<div class="row justify-content-center">
		
		
					<div class="col-lg-10">
		
						<!-- Register -->
						<div class="card">
							<div class="card__header card__header--hero">
								<hgroup class="card__header-hgroup">
									<h4 class="card__header-title">Thank you!</h4>
									<h5 class="card__header-subtitle">This page confirms your registration for the upcoming draft.</h5>
								</hgroup>
								<div class="card__header-bg card__header-bg--2 effect-duotone effect-duotone--warning"></div>
							</div>
							<div class="card__content">
						<?php
							if ($_SERVER['REQUEST_METHOD'] == 'POST') {
//								echo "<p>Registration for the 2025 draft has closed!  Your entry was NOT received.</p>";
								echo "<p>This page confirms you have registered for the upcoming draft.  See you then!</p>";
								} else {
								echo "<p>This page must be called from the appropriate form.</p>";
							}
						?>







					</div>
		
				</div>
			</div>
		</div>
		<!-- Content / End -->
		

		<!-- Footer
		================================================== -->
		<footer id="footer" class="footer">
		
			<!-- Widget: Instagram Section -->
			<aside class="widget widget-instagram">
				<div class="widget__content">
					<ul id="instagram-feed-section" class="widget-instagram__list widget-instagram__list-section widget-instagram__list-section--skewed">
						<li class="widget-instagram__item">
							<a href="#" class="widget-instagram__link-wrapper" target="_blank">
								<span class="widget-instagram__plus-sign">
									<img src="assets/images/hockey/samples/instagram-img-1.jpg" class="widget-instagram__img" alt="Image 1" />
								</span>
							</a>
						</li>
						<li class="widget-instagram__item">
							<a href="#" class="widget-instagram__link-wrapper" target="_blank">
								<span class="widget-instagram__plus-sign">
									<img src="assets/images/hockey/samples/instagram-img-2.jpg" class="widget-instagram__img" alt="Image 2" />
								</span>
							</a>
						</li>
						<li class="widget-instagram__item">
							<a href="#" class="widget-instagram__link-wrapper" target="_blank">
								<span class="widget-instagram__plus-sign">
									<img src="assets/images/hockey/samples/instagram-img-3.jpg" class="widget-instagram__img" alt="Image 3" />
								</span>
							</a>
						</li>
						<li class="widget-instagram__item">
							<a href="#" class="widget-instagram__link-wrapper" target="_blank">
								<span class="widget-instagram__plus-sign">
									<img src="assets/images/hockey/samples/instagram-img-4.jpg" class="widget-instagram__img" alt="Image 4" />
								</span>
							</a>
						</li>
						<li class="widget-instagram__item">
							<a href="#" class="widget-instagram__link-wrapper" target="_blank">
								<span class="widget-instagram__plus-sign">
									<img src="assets/images/hockey/samples/instagram-img-5.jpg" class="widget-instagram__img" alt="Image 5" />
								</span>
							</a>
						</li>
						<li class="widget-instagram__item">
							<a href="#" class="widget-instagram__link-wrapper" target="_blank">
								<span class="widget-instagram__plus-sign">
									<img src="assets/images/hockey/samples/instagram-img-6.jpg" class="widget-instagram__img" alt="Image 6" />
								</span>
							</a>
						</li>
						<li class="widget-instagram__item widget-instagram__item--logo">
							<a href="_hockey_index.html"><img src="assets/images/hockey/logo-footer.png" srcset="assets/images/hockey/logo-footer@2x.png 2x" alt="Alchemists" class="widget-instagram__item__logo"></a>
						</li>
					</ul>
				</div>
			</aside>
			<!-- Widget: Instagram Section / End -->
		
		
			<!-- Footer Secondary -->
			<div class="footer-secondary">
				<div class="container">
					<div class="footer-secondary__inner">
						<div class="row">
							<div class="col-lg-6">
								<!-- Social Links -->
								<ul class="social-links social-links--btn social-links--btn-plus">
									<li class="social-links__item">
										<a href="#" class="social-links__link social-links__link--facebook">
											<i class="fab fa-facebook"></i>
											<span class="social-links__label">Facebook</span>
											<span class="social-links__icon"><i class="fas fa-plus"></i></span>
										</a>
									</li>
									<li class="social-links__item">
										<a href="#" class="social-links__link social-links__link--twitter">
											<i class="fab fa-twitter"></i>
											<span class="social-links__label">Twitter</span>
											<span class="social-links__icon"><i class="fas fa-plus"></i></span>
										</a>
									</li>
									<li class="social-links__item">
										<a href="#" class="social-links__link social-links__link--instagram">
											<i class="fab fa-instagram"></i>
											<span class="social-links__label">Instagram</span>
											<span class="social-links__icon"><i class="fas fa-plus"></i></span>
										</a>
									</li>
								</ul>
								<!-- Social Links / End -->
							</div>
							<div class="col-lg-6">
								<!-- Sponsors -->
								<div class="sponsors-slider">
									<h6 class="sponsors-slider__title">Our Sponsors:</h6>
									<div class="sponsors-slider__items">
										<!-- Slider main container -->
										<div class="swiper sponsors-slider__container js-alc-sponsors-slider">
											<div class="swiper-wrapper">
												<div class="swiper-slide">
													<a href="#"><img src="assets/images/hockey/sponsor-logo-1.png" alt="HTML5"></a>
												</div>
												<div class="swiper-slide">
													<a href="#"><img src="assets/images/hockey/sponsor-logo-2.png" alt="Google Fonts"></a>
												</div>
												<div class="swiper-slide">
													<a href="#"><img src="assets/images/hockey/sponsor-logo-3.png" alt="SportsPress"></a>
												</div>
												<div class="swiper-slide">
													<a href="#"><img src="assets/images/hockey/sponsor-logo-4.png" alt="Envato"></a>
												</div>
											</div>
										</div>
										<!-- Slider main container / End -->
										<!-- Slider navigation -->
										<div class="js-alc-sponsors-slider__button-prev swiper-button-prev swiper-button--xs swiper-button--fa"></div>
										<div class="js-alc-sponsors-slider__button-next swiper-button-next swiper-button--xs swiper-button--fa"></div>
										<!-- Slider navigation / End -->
									</div>
								</div>
								<!-- Sponsors / End -->
							</div>
						</div>
					</div>
				</div>
			</div>
			<!-- Footer Secondary / End -->
		</footer>
		<!-- Footer / End -->

	</div>

	<!-- Javascript Files
	================================================== -->
	<!-- Core JS -->
	<script src="assets/vendor/jquery/jquery.min.js"></script>
	<script src="assets/vendor/jquery/jquery-migrate.min.js"></script>
	<script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
	<script src="assets/vendor/swiper/js/swiper-bundle.min.js"></script>
	<script src="assets/js/core.js"></script>
	
	<!-- Vendor JS -->
	
	<!-- Template JS -->
	<script src="assets/js/init.js"></script>
	<script src="assets/js/custom.js"></script>

</body>
</html>
