$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>