$out .= "</table>";
} else {
echo "<h3>No Results Found</h3>{$tryAgain}";
}
$sql = "SELECT CONCAT( p.first, \" \", p.last, \", \", p.position, \", \", s.school_shortname ) as playerID FROM fch_draft_customplayer p, fch_schools s WHERE leagueID = {$leagueID} AND s.school_id = p.schoolID AND p.playerID like \"%{$playerQuery}%\"";
debug($sql);
$result = $con->query($sql);
if ($result->num_rows > 0) {
$out .= "<h3>Nonstandard Players</h3>The following players are not in our database but have been claimed.<p/>";
while ($row = $result->fetch_assoc()) {
$out .= $row[playerID] . "<br/>";
}
}
echo $alert . $out;
closeDB($con);
$schoolOptionSet = getOptionSet("fch_schools", "school_id", "school_name", "", "schoolID");
if ($allowPick) {
?>
<form method="post" name="submit_customplayer_a" class="form-validate form-horizontal">
<fieldset>
<legend>Player Not Listed?</legend>
Sometimes roster data isn't complete, particularly early in the season. <B>If you're sure your player hasn't left early for the pros,</b> you can write in your pick here. <p/>
<input type = "hidden" name = "action" value = "doCustomPick" />
<input name = "transactionID" value = "<?php
echo $transactionID;
?>
" type = "hidden" />
<div class="control-group">
<div class="control-label">
<label id="jform_contact_name-lbl" for="jform_contact_name" class="hasTooltip required" title="<strong>Name</strong><br />Your name.">
<div class="contact-form">
<form name="leagueEnroll" method="post" class="form-validate form-horizontal" >
<input name = "action" value = "leagueEnroll" type = "hidden">
<fieldset>
<legend>What League Would You Like to Join?</legend>
<div class="control-group">
<div class="control-label">
<label id="jform_contact_name-lbl" for="jform_contact_name" class="hasTooltip required" title="<strong>Name</strong><br />Your name.">
League</label>
</div>
<div class="controls">
<?php
echo getOptionSet("fch_leagues", "id", "display_name", " WHERE (id not in (select leagueID from fch_league_membership where userID = {$userID})) AND season = \"{$season}\" AND (registrationDeadline > date_add(now(),interval - 3 hour) OR allowRegAfterDeadline = TRUE)", "leagueID");
?>
<br/>
</div>
</div>
<div class="control-group">
<div class="control-label"><label id="jform_contact_name-lbl" for="jform_contact_name" class="hasTooltip required" title="<strong>Name</strong><br />Your name.">
Password</label>
</div>
<div class="controls">
<input type="text" name="password" id="password" class="required" size="30" required aria-required="true" />
</div>
</div>
<div class="control-group">
<div class="control-label"><label id="jform_contact_name-lbl" for="jform_contact_name" class="hasTooltip required" title="<strong>Name</strong><br />Your name.">
Your Team Name</label>
<form method="post" name="removeGM" class="form-validate form-horizontal">
<fieldset>
<legend>Remove a GM From League</legend>
<input name = "action" value = "removeGM" type = "hidden">
<input name = "transactionID" value = "<?php
echo $transactionID;
?>
" type = "hidden">
<div class="control-group">
<div class="control-label">
<label id="jform_contact_teamDisplayName-lbl" for="teamDisplayName" class="hasTooltip required" title="teamDisplayName">
GM
</label>
</div>
<div class="controls">
<?php
echo getOptionSet("fch_league_membership", "userID", "teamDisplayName", " WHERE leagueID = {$leagueID} and userID != {$userID} and season = \"{$season}\" and status = \"active\"", "gmToDelete");
?>
Warning: Irreverisible!
</div>
</div>
</fieldset>
<div class="form-actions">
<button id = "removeGM" class="btn btn-primary validate" type="button" onClick="javascript:confirmSubmit('removeGM','removeGM')">Remove GM >></button>
</div>
</form>
