to join the same match.", "
Click SUBMIT", 0);
$MessageStyle = messageStyle(0);
$Requestor = "";
$TextNumber = "";
$Email = "";
$Uniform = "";
$Color = "";
$Notes = "";
$Album = "";
$AES_Club_Schedule_Opened = true;
include "TexStarVSS-requestBlankTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestBlankBottom.inc";
}
else if (isset($_POST["cancel"])) {
$Message = message("Invitation cancelled", "", 0);
$MessageStyle = messageStyle(0);
include "TexStarVSS-requestBlankTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestBlankBottom.inc";
}
else if (isset($_POST["find"]) ) {
if (!$Team) {
if (!$Division) $TeamQ = "Team IS NOT NULL";
else $TeamQ = "Team LIKE '%_" . $Division . "'";
}
else {
if ($Division) {
if ($Team) $TeamQ = "Team = '" . $Team . "_" . $Division . "'";
else $TeamQ = "Team LIKE '%_" . $Division . "'";
}
else $TeamQ = "Team LIKE '" . $Team . "%'";
}
if (!$Age) $AgeQ = "Age IS NOT NULL";
else $AgeQ = "Age = '" . $Age . "'";
if (!$Court) $CourtQ = "Court IS NOT NULL";
else $CourtQ = "Court = '" . $Court . "'";
if (!$Uniform) $UniformQ = "Uniform IS NOT NULL";
else $UniformQ = "Uniform = '" . $Uniform . "'";
if (!$Date) $DateQ = "Date IS NOT NULL";
else $DateQ = "Date = '" . $Date . "'";
if (!$Time) $TimeQ = "Time IS NOT NULL";
else $TimeQ = "Time = '" . $Time . "'";
if (!$Minute) $MinuteQ = "Minute IS NOT NULL";
else $MinuteQ = "Minute = '" . $Minute . "'";
if ($Requestor) {
$query1 = sprintf("SELECT Requestor, TextNumber, Email, Team, Court, Date, Time, Minute, Uniform, Age, Color, Product, Notes, Album, Event FROM requests WHERE GalleryId = %s AND Requestor = '%s' AND %s AND %s AND %s AND %s AND %s AND %s AND %s ORDER BY Date DESC, Time DESC, Uniform",
$galleryId,
$Requestor,
$DateQ,
$TimeQ,
$MinuteQ,
$TeamQ,
$AgeQ,
$CourtQ,
$UniformQ);
}
else if ($Event) {
$query1 = sprintf("SELECT Requestor, TextNumber, Email, Team, Court, Date, Time, Minute, Uniform, Age, Color, Product, Notes, Album, Event FROM requests WHERE GalleryId = %s AND Event = %s",
$galleryId,
$Event);
}
else {
$query1 = sprintf("SELECT Requestor, TextNumber, Email, Team, Court, Date, Time, Minute, Uniform, Age, Color, Product, Notes, Album, Event FROM requests WHERE GalleryId = %s AND %s AND %s AND %s AND %s AND %s AND %s AND %s ORDER BY Date DESC, Time DESC, Uniform",
$galleryId,
$DateQ,
$TimeQ,
$MinuteQ,
$TeamQ,
$AgeQ,
$CourtQ,
$UniformQ);
}
//echo $query1;
$result1 = mysqli_query($conn, $query1);
$num1=mysqli_num_rows($result1);
If ($num1) {
if ($num1 >= 1) {
$rowsFound=mysqli_fetch_array($result1);
$FromAge = $rowsFound["Age"];
$FromTeam = substr($rowsFound["Team"], 0, strpos($rowsFound["Team"],'_'));
//$FromTeam = rtrim($FromTeam);
$FromDivision = substr($rowsFound["Team"],strpos($rowsFound["Team"],'_')+1);
$FromCourt = $rowsFound["Court"];
$FromDate = $rowsFound["Date"];
$FromTime = $rowsFound["Time"];
$FromMinute = $rowsFound["Minute"];
$FromEvent = $rowsFound["Event"];
$Court = $rowsFound["Court"];
$Age = $rowsFound["Age"];
$Division = substr($rowsFound["Team"],strpos($rowsFound["Team"],'_')+1);
$currentTeam = $rowsFound["Team"];
$Date = $rowsFound["Date"];
$Time = $rowsFound["Time"];
$Minute = $rowsFound["Minute"];
$currentEvent = $rowsFound["Event"];
$eventId = $currentEvent;
if ($Team || $Requestor) {
$Team = substr($rowsFound["Team"], 0, strpos($rowsFound["Team"],'_'));
}
else if ($Event) {
$eventId = $rowsFound["Event"];
$Event = $eventId;
}
else if ($Requestor) {
$Product = $rowsFound["Product"];
$Notes = $rowsFound["Notes"];
$Album = $rowsFound["Album"];
}
if (($Requestor && $num1 == 1) || $num1 == 1) {
$Requestor = $rowsFound["Requestor"];
$TextNumber = $rowsFound["TextNumber"];
$Email = $rowsFound["Email"];
$Age = $rowsFound["Age"];
$Product = $rowsFound["Product"];
$eventId = $rowsFound["Event"];
$Uniform = $rowsFound["Uniform"];
$Color = $rowsFound["Color"];
$Event = $eventId;
}
else if ($Requestor && $num1 > 1) {
$Requestor = "";
$TextNumber = "";
$Email = "";
$Uniform = "";
$Color = "";
}
$aliasEvent = 0;
$aliasTeam = "";
if ($num1 > 1) {
while ($rowsFound=mysqli_fetch_array($result1)) {
$newEvent = $rowsFound["Event"];
$newTeam = $rowsFound["Team"];
if ($newEvent != $currentEvent) $aliasEvent = $newEvent;
if ($newTeam != $currentTeam) $aliasTeam = $newTeam;
}
}
$Message = "
- Click FIND after refining search above.
- Click UPDATE after changing info below.
- Click MOVE after changing info above.
";
if ($from == "TexStarMain") $Message .= "- Click COPY after changing info to duplicate.
";
$Message .= "- Click DELETE to remove.
";
if ($num1 == 1) $messagePrefix = "REQUEST ";
else $messagePrefix = $num1 . " REQUESTS ";
$messagePrefix .= " from Match# " . $currentEvent;
if ($aliasEvent) $messagePrefix .= " & " . $aliasEvent;
$Message = message($messagePrefix . " FOUND
" . $Message, "", 0);
$MessageStyle = messageStyle(0);
mysqli_data_seek($result1, 0);
}
include "TexStarVSS-requestDeleteTop.inc";
include "TexStarVSS-requestAll.inc";
include ("TexStarVSS-requestDeleteBottom.inc");
}
else {
$Message = message("Request NOT found.","Change info above and click Find again.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestBlankTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestBlankBottom.inc";
}
}
else if (isset($_POST["update"]) ) {
$message = "Request(s) updated.
" . $messageStandard;
$Message = message($message,"",0);
$MessageStyle = messageStyle(0);
include "TexStarVSS-requestBlankTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestBlankBottom.inc";
}
else if (isset($_POST["delete"]) ) {
$TeamDivision = $Team . "_" . $Division;
if (!$Uniform) {
$query1 = sprintf("DELETE FROM requests WHERE Date='%s' AND Time='%s' AND Minute='%s'
AND Court='%s' AND Team='%s' AND Age='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
mysqli_real_escape_string($conn, $Court),
mysqli_real_escape_string($conn, $TeamDivision),
mysqli_real_escape_string($conn, $Age),
$galleryId);
}
else {
$query1 = sprintf("DELETE FROM requests WHERE Date='%s' AND Time='%s' AND Minute='%s'
AND Court='%s' AND Team='%s' AND Age='%s' AND Uniform='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
mysqli_real_escape_string($conn, $Court),
mysqli_real_escape_string($conn, $TeamDivision),
mysqli_real_escape_string($conn, $Age),
mysqli_real_escape_string($conn, $Uniform),
$galleryId);
}
//echo $query1;
$result1 = mysqli_query($conn, $query1);
//mysql_remote($query1, $syncInternet, $hostType);
If ($result1) {
$Message = message("Request(s) matching info above deleted.", "",0);
$MessageStyle = messageStyle(0);
include "TexStarVSS-requestBlankTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestBlankBottom.inc";
$mysqlQuery1 = mysqli_real_escape_string($conn, $query1);
}
else {
$Message = message("Request(s) not deleted.", "",1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestBlankTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestBlankBottom.inc";
}
}
else if (isset($_POST["movePrep"]) || isset($_POST["copyPrep"]) ) {
$FromAge = $_POST["Age"];
$FromDivision = $_POST["Division"];
$FromTeam = $_POST["Team"];
$FromTeam = preg_replace('/[^A-Za-z0-9 \-]/', ' ', $FromTeam);
$FromColor = $_POST["Color"];
$FromUniform = $_POST["Uniform"];
$FromCourt = $_POST["Court"];
$FromDate = $_POST["Date"];
$FromTime = $_POST["Time"];
$FromMinute = $_POST["Minute"];
$FromProduct = $_POST["Product"];
/* Perhaps Date = $_POST['Date']; */
if (!$Team) $TeamQ = "Team IS NOT NULL";
else $TeamQ = "Team = '" . $Team . "_" . $Division . "'";
if (!$Age) $AgeQ = "Age IS NOT NULL";
else $AgeQ = "Age = '" . $Age . "'";
if (!$Court) $CourtQ = "Court IS NOT NULL";
else $CourtQ = "Court = '" . $Court . "'";
if (!$Uniform) $UniformQ = "Uniform IS NOT NULL";
else $UniformQ = "Uniform = '" . $Uniform . "'";
$query1 = sprintf("SELECT Team, Court, Uniform, Age, Color, Event, Date, Time FROM requests WHERE Date='%s' AND Time='%s' AND Minute='%s' AND %s AND %s AND %s AND %s ORDER BY Court, Team, Uniform",
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
$TeamQ,
$AgeQ,
$CourtQ,
$UniformQ);
$result1 = mysqli_query($conn, $query1);
$num1=mysqli_num_rows($result1);
if (isset($_POST["movePrep"])) {
$Message = message("Update info above for moving.","Click MOVE below to complete.", 0);
$MessageStyle = messageStyle(0);
}
else if (isset($_POST["copyPrep"])) {
$Message = message("Update Copy-To Info","Click COPY to complete.", 0);
$MessageStyle = messageStyle(0);
}
include ("TexStarVSS-requestDeleteTop.inc");
include "TexStarVSS-requestAll.inc";
include ("TexStarVSS-requestDeleteBottom.inc");
}
else if (isset($_POST["move"]) || isset($_POST["copy"]) ) {
$FromDate = $_POST["FromDate"];
$FromTime = $_POST["FromTime"];
$FromMinute = $_POST["FromMinute"];
$FromCourt = $_POST["FromCourt"];
$FromTeam = $_POST["FromTeam"];
//$FromTeam = rtrim($FromTeam);
$FromTeam = preg_replace('/[^A-Za-z0-9 \-]/', ' ', $FromTeam);
$FromAge = $_POST["FromAge"];
$FromDivision = $_POST["FromDivision"];
$FromEvent = $_POST["FromEvent"];
//echo "FrormDate=", $FromDate, " FromTeam=", $FromTeam, " FromAge=", $FromAge, " FromDivision=", $FromDivision, " FromCourt=", $FromCourt, " FromEvent=", $FromEvent;
if (isset($_POST["move"])) {
$operation = "MOVE";
$completed = "MOVED";
}
else {
$operation = "COPY";
$completed = "COPIED";
}
$TeamDivision = $Team . "_" . $Division;
$timeMinuteSeparator = "";
$Name = $TeamDivision . "_CT" . $Court . "_" . SUBSTR($Time,0,2) . $timeMinuteSeparator . $Minute . SUBSTR($Time, 2) . "_" . SUBSTR($Date,5);
if (!$FromEvent) {
$query1 = sprintf("SELECT * FROM requests WHERE Date='%s' AND Time='%s' AND Minute='%s'
AND Court='%s' AND Team='%s' AND Age='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $FromDate),
mysqli_real_escape_string($conn, $FromTime),
mysqli_real_escape_string($conn, $FromMinute),
mysqli_real_escape_string($conn, $FromCourt),
mysqli_real_escape_string($conn, $FromTeam . "_" . $FromDivision),
mysqli_real_escape_string($conn, $FromAge),
$galleryId);
}
else {
$query1 = sprintf("SELECT * FROM requests WHERE Event='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $FromEvent),
$galleryId);
}
//echo $query1;
$result1=mysqli_query($conn, $query1);
$num1=mysqli_num_rows($result1);
if ($Court == $FromCourt && $Date == $FromDate && $Time == $FromTime && $Minute == $FromMinute && $Team == $FromTeam && $Age == $FromAge && $FromDivision == $Division) {
$Message = message($operation . " not done since info identical.","Change info and repeat " . $operation . ".", 0);
$MessageStyle = messageStyle(0);
include "TexStarVSS-requestDeleteTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestDeleteBottom.inc";
}
else {
$EventName = $TeamDivision . "_CT" . $Court . "_" . SUBSTR($Time,0,2) . $timeMinuteSeparator . $Minute . SUBSTR($Time,2) . "_" . SUBSTR($Date,5);
$FromTeamDivision = $FromTeam . "_" . $FromDivision;
$query5 = sprintf("SELECT Id, IdAlias FROM events WHERE Name='%s' AND GalleryId=%s",
mysqli_real_escape_string($conn, $EventName),
$galleryId);
$result5=mysqli_query($conn, $query5);
$num5=mysqli_num_rows($result5);
// If same team, court, exists already, then reuse the event and use the eventId for the requests.
if ($num5) {
$myrow5 = mysqli_fetch_array($result5);
$Id = $myrow5['Id'];
$IdAlias = $myrow5['IdAlias'];
}
// Otherwise, create a new event for the request
else {
$query7 = sprintf("SELECT Id FROM eventnumber WHERE GalleryId=%s",
$galleryId);
$result7=mysqli_query($conn, $query7);
$num7=mysqli_num_rows($result7);
if ($num7) {
$myrow7 = mysqli_fetch_array($result7);
$Id = $myrow7['Id'];
$Id += 1;
$query8 = sprintf("UPDATE eventnumber SET Id = %s WHERE GalleryId=%s",
$Id,
$galleryId);
$result8=mysqli_query($conn, $query8);
//mysql_remote($query8, $syncInternet, $hostType);
$mysqlQuery2 = mysqli_real_escape_string($conn, $query8);
}
// See if there is another team at the same court, date, time, minute
$queryEventAlias = sprintf("SELECT Id, Team from events WHERE GalleryId = '%s' AND Team != '%s' AND Court = '%s' AND Date = '%s' AND Time = '%s' AND Minute = '%s'",
$galleryId,
mysqli_real_escape_string($conn, $FromTeamDivision),
mysqli_real_escape_string($conn, $Court),
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute));
$resultEventAlias = mysqli_query($conn, $queryEventAlias);
$numEventAlias = mysqli_num_rows($resultEventAlias);
//echo $queryEventAlias, " ", $numEventAlias;
if ($numEventAlias == 0) {
$idAlias = 0;
}
else if ($numEventAlias == 1) {
$myrowAlias = mysqli_fetch_array($resultEventAlias);
$idAlias = $myrowAlias['Id'];
// echo "idAlias = ", $idAlias;
}
$query9 = sprintf("INSERT INTO events (GalleryId, Id, IdAlias, Age, Name, Team, Court, Time, Minute, Date, Uploaded, Photographer, PhotoCount) VALUES (%s, %s, %s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",
$galleryId,
$Id,
$idAlias,
mysqli_real_escape_string($conn, $Age),
mysqli_real_escape_string($conn, $EventName),
mysqli_real_escape_string($conn, $TeamDivision),
mysqli_real_escape_string($conn, $Court),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, ""),
mysqli_real_escape_string($conn, ""),
mysqli_real_escape_string($conn, "0"));
//echo $query9;
mysqli_query($conn, $query9) or die('Error, event insert query failed');
//mysql_remote($query9, $syncInternet, $hostType);
$mysqlQuery3 = mysqli_real_escape_string($conn, $query9);
if ($idAlias) {
$query5=sprintf("UPDATE events SET IdAlias = '%s' WHERE Id='%s' AND GalleryId=%s",
mysqli_real_escape_string($conn, $Id),
mysqli_real_escape_string($conn, $idAlias),
$galleryId);
$result5 = mysqli_query($conn, $query5);
//mysql_remote($query5, $syncInternet, $hostType);
$mysqlQuery4 = mysqli_real_escape_string($conn, $query5);
}
}
if (isset($_POST["move"])) {
$FromTeamDivision = $FromTeam . "_" . $FromDivision;
$query5 = sprintf("SELECT Id,IdAlias FROM events WHERE GalleryId = '%s' AND Team != '%s' AND Court = '%s' AND Date = '%s' AND Time = '%s' AND Minute = '%s'",
$galleryId,
mysqli_real_escape_string($conn, $FromTeamDivision),
mysqli_real_escape_string($conn, $FromCourt),
mysqli_real_escape_string($conn, $FromDate),
mysqli_real_escape_string($conn, $FromTime),
mysqli_real_escape_string($conn, $FromMinute));
$result5=mysqli_query($conn, $query5);
$num5=mysqli_num_rows($result5);
if ($num5) {
$FromEventRow = mysqli_fetch_array($result5);
$IdAlias = $FromEventRow['IdAlias'];
$IdOther = $FromEventRow['Id'];
if ($IdAlias) {
$queryEventAlias = sprintf("UPDATE events SET IdAlias = 0 WHERE GalleryId = %s AND Id = %s",
$galleryId,
$IdOther);
$resultEventAlias=mysqli_query($conn, $queryEventAlias);
//mysql_remote($queryEventAlias, $syncInternet, $hostType);
$mysqlQuery5 = mysqli_real_escape_string($conn, $queryEventAlias);
}
}
$FromEventName = $FromTeam . "_" . $FromDivision . "_CT" . $FromCourt . "_" . SUBSTR($FromTime,0,2) . $FromMinute . SUBSTR($FromTime,2) . "_" . SUBSTR($FromDate,5);
$query5 = sprintf("DELETE FROM events WHERE Name='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $FromEventName),
$galleryId);
$result5=mysqli_query($conn, $query5);
//mysql_remote($query5, $syncInternet, $hostType);
$mysqlQuery6 = mysqli_real_escape_string($conn, $query5);
}
$num6=mysqli_num_rows($result1);
//echo "num6=", $num6;
$i = 0;
while ($i < $num6) {
$rows6=mysqli_fetch_array($result1);
$query6 = sprintf("INSERT INTO requests (GalleryId, Event, Age, Team, Color, Uniform, Court, Date, Time, Minute, Notes, Album, StandBy, Requestor, TextNumber, Email, Product) VALUES (%s, %u, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",
$galleryId,
mysqli_real_escape_string($conn, $Id),
mysqli_real_escape_string($conn, $Age),
mysqli_real_escape_string($conn, $TeamDivision),
mysqli_real_escape_string($conn, $rows6['Color']),
mysqli_real_escape_string($conn, $rows6['Uniform']),
mysqli_real_escape_string($conn, $Court),
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
mysqli_real_escape_string($conn, $rows6['Notes']),
mysqli_real_escape_string($conn, $rows6['Album']),
mysqli_real_escape_string($conn, $rows6['StandBy']),
mysqli_real_escape_string($conn, $rows6['Requestor']),
mysqli_real_escape_string($conn, $rows6['TextNumber']),
mysqli_real_escape_string($conn, $rows6['Email']),
mysqli_real_escape_string($conn, $rows6['Product']));
//echo $query6;
$result6=mysqli_query($conn, $query6);
//mysql_remote($query6, $syncInternet, $hostType);
$mysqlQuery7 = mysqli_real_escape_string($conn, $query6);
$i++;
}
/* $name = $ToTeamDivision . " CT" . $ToCourt . " " . SUBSTR($ToTime,0,2) . $timeMinuteSeparator . $ToMinute . SUBSTR($time, 2) . " " . $date;
$query2=sprintf("UPDATE events SET Age = '%s', Photographer = '%s', Time = '%s', Minute = '%s', Court = '%s', Name='%s', Team='%s' WHERE Id='%s' AND GalleryId=%s",
mysqli_real_escape_string($conn, $age),
mysqli_real_escape_string($conn, $photographer),
mysqli_real_escape_string($conn, $time),
mysqli_real_escape_string($conn, $minute),
mysqli_real_escape_string($conn, $court),
mysqli_real_escape_string($conn, $name),
mysqli_real_escape_string($conn, $team),
mysqli_real_escape_string($conn, $id),
$galleryId);
$result2=mysqli_query($conn, $query2); */
if (isset($_POST["move"])) {
$query8 = sprintf("SELECT Team FROM teams WHERE Team='%s' AND Age='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $Team),
mysqli_real_escape_string($conn, $Age),
$galleryId);
$result8=mysqli_query($conn, $query8);
$num8=mysqli_num_rows($result8);
If (!$num8) {
$query9 = sprintf("INSERT INTO teams (GalleryId, Team, Age) VALUES (%s, '%s', '%s')",
$galleryId,
mysqli_real_escape_string($conn, $Team),
mysqli_real_escape_string($conn, $Age));
$result9=mysqli_query($conn, $query9);
//mysql_remote($query9, $syncInternet, $hostType);
$mysqlQuery8 = mysqli_real_escape_string($conn, $query9);
}
$query1 = sprintf("DELETE FROM requests WHERE Date='%s' AND Time='%s' AND Minute='%s'
AND Court='%s' AND Team='%s' AND Age='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $FromDate),
mysqli_real_escape_string($conn, $FromTime),
mysqli_real_escape_string($conn, $FromMinute),
mysqli_real_escape_string($conn, $FromCourt),
mysqli_real_escape_string($conn, $FromTeam . "_" . $FromDivision),
mysqli_real_escape_string($conn, $FromAge),
$galleryId);
//echo $query1;
$result1 = mysqli_query($conn, $query1);
//mysql_remote($query1, $syncInternet, $hostType);
$mysqlQuery9 = mysqli_real_escape_string($conn, $query1);
}
$Message = message($num1 . " Request(s) " . $completed . " to court " . $Court . " at " . SUBSTR($Time,0,2) . $Minute . SUBSTR($Time,2) .
" on " . SUBSTR($Date,5) . " for team " . $TeamDivision . " with match #" . $Id, "", 0);
$MessageStyle = messageStyle(0);
$Event = $Id;
include "TexStarVSS-requestBlankTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestBlankBottom.inc";
}
}
else if (!isset($_POST["submit"]) ) {
include "TexStarVSS-requestBlankTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestBlankBottom.inc";
}
IF (isset($_POST["submit"])) {
$totalPhotoCount = 0;
$Team = preg_replace('/[^A-Za-z0-9 \-]/', ' ', $Team);
$TeamAndDivision = $Team . "_" . $Division;
$Message = "";
$MessageStyle = messageStyle(0);
/*} ELSE {$Notes1 = "";}
IF (isset($_POST["Notes2"])) {
$Notes2 = $_POST["Notes2"];
} ELSE {$Notes2 = "";}
IF (isset($_POST["Notes3"])) {
$Notes3 = $_POST["Notes3"];
} ELSE {$Notes3 = "";}
IF (isset($_POST["Notes4"])) {
$Notes4 = $_POST["Notes4"];
} ELSE {$Notes4 = "";}
IF (isset($_POST["Notes5"])) {
$Notes5 = $_POST["Notes5"];
} ELSE {$Notes5 = "";}
IF (isset($_POST["Notes6"])) {
$Notes6 = $_POST["Notes6"];
} ELSE {$Notes6 = "";}
IF (isset($_POST["Notes7"])) {
$Notes7 = $_POST["Notes7"];
} ELSE {$Notes7 = "";}
IF (isset($_POST["Notes8"])) {
$Notes8 = $_POST["Notes8"];
} ELSE {$Notes8 = "";}
IF (isset($_POST["Notes9"])) {
$Notes9 = $_POST["Notes9"];
$Priority = 1;
} ELSE {
$Notes9 = "";
$Priority = 0;
}
IF (isset($_POST["Notes10"])) {
$Notes10 = $_POST["Notes10"];
$StandBy = $_POST["Notes10"];
}
ELSE {
$Notes10 = "";
$StandBy = "";
} */
$Submit = $_POST["submit"];
$Quote="'";
$query1 = sprintf("SELECT DISTINCT Court FROM requests WHERE Date='%s' AND Time='%s' AND GalleryId = %s AND Court != '%s'",
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
$galleryId,
mysqli_real_escape_string($conn, $Court));
$result1=mysqli_query($conn, $query1);
$num1=mysqli_num_rows($result1);
$query2 = sprintf("SELECT * FROM requests WHERE Date='%s' AND Time='%s' AND Minute='%s' AND GalleryId = %s AND Court='%s' AND StandBy<>'+' ORDER BY Team",
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
$galleryId,
mysqli_real_escape_string($conn, $Court));
$result2=mysqli_query($conn, $query2);
$num2=mysqli_num_rows($result2);
$query2b = sprintf("SELECT * FROM requests WHERE Team = '%s' AND Date='%s' AND Time='%s' AND Minute='%s' AND GalleryId = %s AND Court='%s' AND StandBy<>'+' ORDER BY Team",
mysqli_real_escape_string($conn, $TeamAndDivision),
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
$galleryId,
mysqli_real_escape_string($conn, $Court));
$result2b=mysqli_query($conn, $query2b);
$num2b=mysqli_num_rows($result2b);
$query2c = sprintf("SELECT * FROM requests WHERE Team = '%s' AND Age = '%s' AND Event=0 AND GalleryId = %s AND StandBy<>'+' ORDER BY Age, Team, Uniform",
mysqli_real_escape_string($conn, $TeamAndDivision),
mysqli_real_escape_string($conn, $Age),
$galleryId);
//echo $query2c;
$result2c=mysqli_query($conn, $query2c);
$num2c=mysqli_num_rows($result2c);
$query3 = sprintf("SELECT Available, CourtsPerHour,PlayersPerCourt FROM photographers WHERE Date='%s' AND Time='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
$galleryId);
$result3=mysqli_query($conn, $query3);
$num3=mysqli_num_rows($result3);
$query4 = sprintf("SELECT Uniform, requests.Court, requests.Date, requests.Time, requests.Minute, requests.Event, PhotoCount FROM requests JOIN events ON requests.GalleryId = events.GalleryId AND requests.Event = events.Id WHERE requests.Age='%s' AND requests.Team='%s' AND Uniform='%s' AND requests.GalleryId = %s AND StandBy<>'+' AND Event<>0",
mysqli_real_escape_string($conn, $Age),
mysqli_real_escape_string($conn, $TeamAndDivision),
mysqli_real_escape_string($conn, $Uniform),
$galleryId);
$result4=mysqli_query($conn, $query4);
if($result4) $num4=mysqli_num_rows($result4);
else $num4 = 0;
$query10 = sprintf("SELECT DISTINCT GalleryId, Team, Age, Court, Date, Time, Minute, Event FROM requests WHERE Age='%s' AND Team='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $Age),
mysqli_real_escape_string($conn, $TeamAndDivision),
$galleryId);
$result10=mysqli_query($conn, $query10);
$num10=mysqli_num_rows($result10);
$query12 = sprintf("SELECT DISTINCT GalleryId, Team, Age, Court, Date, Time, Minute, Event, Uniform FROM requests WHERE Age='%s' AND Team='%s' AND Date='%s' AND (Court != '%s' OR Time != '%s') AND GalleryId = %s AND Event != 0 ORDER BY Uniform ASC",
mysqli_real_escape_string($conn, $Age),
mysqli_real_escape_string($conn, $TeamAndDivision),
mysqli_real_escape_string($conn, $Date),
$Court,
mysqli_real_escape_string($conn, $Time),
$galleryId);
$result12=mysqli_query($conn, $query12);
$num12=mysqli_num_rows($result12);
$query6 = sprintf("SELECT DISTINCT Uniform FROM requests WHERE Age='%s' AND Team='%s' AND Uniform='%s' AND Date='%s' AND Time='%s' AND Minute='%s' AND Court='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $Age),
mysqli_real_escape_string($conn, $TeamAndDivision),
mysqli_real_escape_string($conn, $Uniform),
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
mysqli_real_escape_string($conn, $Court),
$galleryId);
$result6=mysqli_query($conn, $query6);
$num6=mysqli_num_rows($result6);
$Available=0;
$CourtsPerHour = 0;
$PlayersPerCourt = 0;
if ($num3) {
$myrow = mysqli_fetch_row($result3);
$Available = $myrow[0];
$CourtsPerHour = $myrow[1];
$PlayersPerCourt = $myrow[2];
}
$EventName = $Team . "_" . $Division . "_CT" . $Court . "_" . SUBSTR($Time,0,2) . $Minute . SUBSTR($Time,2) . "_" . SUBSTR($Date,5);
$query5 = sprintf("SELECT Id FROM events WHERE Name='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $EventName),
$galleryId);
$result5=mysqli_query($conn, $query5);
$num5=mysqli_num_rows($result5);
$queryEventAlias = sprintf("SELECT Id, Team from events WHERE GalleryId = '%s' AND Team != '%s' AND Court = '%s' AND Date = '%s' AND Time = '%s' AND Minute = '%s'",
$galleryId,
mysqli_real_escape_string($conn, $TeamAndDivision),
mysqli_real_escape_string($conn, $Court),
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute));
$resultEventAlias = mysqli_query($conn, $queryEventAlias);
$numEventAlias = mysqli_num_rows($resultEventAlias);
if ($numEventAlias == 0) {
$idAlias = 0;
}
else if ($numEventAlias == 1) {
$myrowAlias = mysqli_fetch_array($resultEventAlias);
$idAlias = $myrowAlias['Id'];
}
if (!$Requestor) {
$Message=message("Requestor is blank.", "Enter Requestor and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if (!$TextNumber) {
$Message=message("Text Number is blank.", "Enter Text Number and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if (!$Email) {
$Message=message("Email is blank.", "Enter Email and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if (!$Age) {
echo "Age is blank";
$Message=message("Age is blank.", "Select Age and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if (!$Team) {
$Message=message("Team is blank.", "Enter Team and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if (!$Division) {
$Message=message("Division is blank.", "Enter Division and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if (!$Uniform) {
$Message=message("Uniform is blank.", "Enter Uniform and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if (!$Product) {
$Message=message("Product is blank.", "Enter Product and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if ((!$preSchedule) && !$Color) {
$Message=message("Color is blank.", "Enter main uniform color or if appropriate, LIBERO. If uncertain, enter 2 colors.
If very uncertain, enter ?", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if ((!$preSchedule) && !$Court) {
$Message=message("Court not entered.", "Enter Court and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if ((!$preSchedule) && !$Time) {
$Message=message("Time is blank.", "Select Time and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if ((!$preSchedule) && !$Date) {
$Message=message("Date is blank.", "Select Date and resubmit.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if ($num6 >= 1) {
$Message=message("Duplicate request for this player.", "Change and resubmit.", 1);
$MessageStyle = messageStyle(1);
if ($eventId != 0) $showRowsRequests = 1;
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if ($num12 > 0 && ($Submit <> "CONFIRM")) {
$joinUniformMessage = "Join match with requests below or change day/time and RESUBMIT.";
$showRowsRequestsTeamSameDay = 1;
/*while ($rowsJoin=mysqli_fetch_array($result12)) {
if ($rowsJoin['Uniform'] == $Uniform) {
$joinUniformMessage .= "Uniform #" . $Uniform . " already requested for that day.
To request a different day, Change Date/Time and RESUBMIT.";
$showRowsRequestsTeamSameDay = 0;
}
} */
//mysqli_data_seek($result12, 0);
if ($from == "TexStarMain") $joinUniformMessage .= "
If necessary, click CONFIRM.";
$Message=message("One match per team per day allowed.", $joinUniformMessage, 1);
$MessageStyle = messageStyle(1);
$AES_Club_Schedule_Opened = true;
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitConfirmBottom.inc";
}
else if (!$eventId && ($num10 >= 1) && ($totalPhotoCount) && ($Submit<>"RESUBMIT")) {
$result12 = $result10;
$showRows = 1;
$Message=message($totalPhotoCount . " photos uploaded for this team. ", "Add Notes and resubmit.", 1);
$MessageStyle = messageStyle(1);
$priorityStandby = 1;
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
/*} else if (!$eventId && ($num4 == 1) && ($Submit<>"RESUBMIT")) {
$Message=message($num4 . " request already made for this player.", "Click PHOTOS below to review and add any existing photos to your album.
Only if necessary, request again by clicking RESUBMIT. Otherwise
click HOME.", 1);
$showRowsRequests = 1;
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
} else if (!$eventId && ($num4 >=2) && ($Submit<>"RESUBMIT")) {
$Message=message($num4 . " requests already made for this player.", "Click PHOTOS below to review and add any existing photos to your album.
Only if necessary, request again by clicking RESUBMIT. Otherwise
click HOME.", 1);
$showRowsRequests = 1;
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc"; */
} else if (!$eventId && $numEventAlias >= 2) {
$Message=message("Too many teams requested for this match.", "Click Check AES Schedule button above to verify your match. Then change information and RESUBMIT.", 1);
$MessageStyle = messageStyle(1);
$showRowsAlias = 1;
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if (!$AES_Club_Schedule_Opened && !$preSchedule) {
$Message=message("Click the Check Schedule button
to verify your match.", "
Once you have verified
the date and time of your request,
click RESUBMIT.", 1);
$MessageStyle = messageStyle(1);
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if (($currentDate < $DateStart) || $eventId || ($StandBy == "+" || $Priority) ||
((!$num5 && ($num1< ($Available*$CourtsPerHour)) && ($num2< $PlayersPerCourt)) || ($num5 && ($num2< $PlayersPerCourt)))) {
/*$Notes = "";
if ($Notes1 <> "") $Notes = $Notes . $Notes1 . " ";
if ($Notes2 <> "") $Notes = $Notes . $Notes2 . " ";
if ($Notes3 <> "") $Notes = $Notes . $Notes3 . " ";
if ($Notes4 <> "") $Notes = $Notes . $Notes4 . " ";
if ($Notes5 <> "") $Notes = $Notes . $Notes5 . " ";
if ($Notes6 <> "") $Notes = $Notes . $Notes6 . " ";
if ($Notes7 <> "") $Notes = $Notes . $Notes7 . " ";
if ($Notes8 <> "") $Notes = $Notes . $Notes8 . " ";
if ($Notes9 <> "") $Notes = $Notes . $Notes9 . " ";
if ($Notes10 <> "") $Notes = $Notes . $Notes10 . " "; */
$TeamAndDivision = $Team . "_" . $Division;
if (!$preSchedule) {
$EventName = $TeamAndDivision . "_CT" . $Court . "_" . SUBSTR($Time,0,2) . $Minute . SUBSTR($Time,2) . "_" . SUBSTR($Date,5);
$query5 = sprintf("SELECT Id FROM events WHERE Name='%s' AND GalleryId=%s",
mysqli_real_escape_string($conn, $EventName),
$galleryId);
//echo $query5;
$result5=mysqli_query($conn, $query5);
$num5=mysqli_num_rows($result5);
//echo "num5=", $num5;
if ($num5) {
$myrow5 = mysqli_fetch_array($result5);
$Id = $myrow5['Id'];
}
else {
$query7a = sprintf("BEGIN");
$result7a=mysqli_query($conn, $query7a);
$query7 = sprintf("SELECT Id FROM eventnumber WHERE GalleryId=%s", $galleryId);
$result7=mysqli_query($conn, $query7);
$num7=mysqli_num_rows($result7);
//echo "num7=", $num7;
if ($num7) {
$myrow7 = mysqli_fetch_array($result7);
$Id = $myrow7['Id'];
$Id += 1;
$query8 = sprintf("UPDATE eventnumber SET Id = %s WHERE GalleryId=%s",
$Id,
$galleryId);
$result8=mysqli_query($conn, $query8);
//echo $query8;
$query8b = sprintf("COMMIT");
$result8b=mysqli_query($conn, $query8b);
//mysql_remote($query8, $syncInternet, $hostType);
$mysqlQuery10 = mysqli_real_escape_string($conn, $query8);
}
$query9 = sprintf("INSERT INTO events (GalleryId, Id, IdAlias, Age, Name, Team, Court, Time, Minute, Date, Uploaded, Photographer, PhotoCount) VALUES (%s, %s, %s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",
$galleryId,
$Id,
$idAlias,
mysqli_real_escape_string($conn, $Age),
mysqli_real_escape_string($conn, $EventName),
mysqli_real_escape_string($conn, $TeamAndDivision),
mysqli_real_escape_string($conn, $Court),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, ""),
mysqli_real_escape_string($conn, ""),
mysqli_real_escape_string($conn, "0"));
$result9=mysqli_query($conn, $query9);
//mysql_remote($query9, $syncInternet, $hostType);
$mysqlQuery11 = mysqli_real_escape_string($conn, $query9);
if ($idAlias) {
$query5=sprintf("UPDATE events SET IdAlias = '%s' WHERE Id='%s' AND GalleryId=%s",
mysqli_real_escape_string($conn, $Id),
mysqli_real_escape_string($conn, $idAlias),
$galleryId);
$result5 = mysqli_query($conn, $query5);
//mysql_remote($query5, $syncInternet, $hostType);
$mysqlQuery12 = mysqli_real_escape_string($conn, $query5);
}
}
}
else {
$Id = 0;
$Court = "0";
$Color = "";
$Date = "";
$Time = "";
$Minute = "";
$Notes = "";
$StandBy = "";
}
$TeamAndDivision = $Team . "_" . $Division;
//echo $Id, " ", $eventId, " ", $PriorCourt;
//echo "Id=", $Id, "eventId=", $eventId, " num2c=", $num2c;
if ($Id && !$eventId && $PriorCourt == '0') { // if event and early request and priorcourt is 0
if ($num2c>0) {
$i = 0;
while ($i < $num2c) {
$rows2c=mysqli_fetch_array($result2c);
$query6 = sprintf("UPDATE requests SET Event = %s, Court = %s, Date = '%s', Time = '%s', Minute = '%s' WHERE GalleryId= %s AND Event = %s AND Requestor = '%s' AND Uniform = '%s'",
mysqli_real_escape_string($conn, $Id),
mysqli_real_escape_string($conn, $Court),
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
$galleryId,
$eventId,
$rows2c['Requestor'],
$rows2c['Uniform']);
$query6Result = mysqli_query($conn, $query6) or die('Error, request update query failed');
$i++;
}
}
}
else {
$query6 = sprintf("INSERT INTO requests (GalleryId, Event, Age, Team, Color, Uniform, Court,
Date, Time, Minute, Notes, Album, StandBy, Requestor, TextNumber, Email, Product) VALUES (%s, %u, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",
$galleryId,
mysqli_real_escape_string($conn, $Id),
mysqli_real_escape_string($conn, $Age),
mysqli_real_escape_string($conn, $TeamAndDivision),
mysqli_real_escape_string($conn, $Color),
mysqli_real_escape_string($conn, $Uniform),
mysqli_real_escape_string($conn, $Court),
mysqli_real_escape_string($conn, $Date),
mysqli_real_escape_string($conn, $Time),
mysqli_real_escape_string($conn, $Minute),
mysqli_real_escape_string($conn, $Notes),
mysqli_real_escape_string($conn, $Album),
mysqli_real_escape_string($conn, $StandBy),
mysqli_real_escape_string($conn, $Requestor),
mysqli_real_escape_string($conn, $TextNumber),
mysqli_real_escape_string($conn, $Email),
mysqli_real_escape_string($conn, $Product));
$query6Result = mysqli_query($conn, $query6) or die('Error, request insert query failed');
//echo $query6;
if ($query6Result) $eventId = $Id;
}
$mysqlQuery13 = mysqli_real_escape_string($conn, $query6);
$query8 = sprintf("SELECT Team FROM teams WHERE Team='%s' AND Age='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $Team),
mysqli_real_escape_string($conn, $Age),
$galleryId);
$result8=mysqli_query($conn, $query8);
$num8=mysqli_num_rows($result8);
If (!$num8) {
$query9 = sprintf("INSERT INTO teams (GalleryId, Team, Age) VALUES (%s, '%s', '%s')",
$galleryId,
mysqli_real_escape_string($conn, $Team),
mysqli_real_escape_string($conn, $Age));
$result9=mysqli_query($conn, $query9);
//mysql_remote($query9, $syncInternet, $hostType);
$mysqlQuery14 = mysqli_real_escape_string($conn, $query9);
}
$querycontact = sprintf("SELECT Name FROM phone WHERE Type = 'R' AND Name='%s' AND GalleryId = %s",
mysqli_real_escape_string($conn, $Requestor),
$galleryId);
$resultcontact=mysqli_query($conn, $querycontact);
$numcontact=mysqli_num_rows($resultcontact);
If (!$numcontact) {
$query9 = sprintf("INSERT INTO phone (GalleryId, Type, Name, Phone, Email, OptIn) VALUES (%s, '%s', '%s', '%s', '%s', '%s')",
$galleryId,
'R',
mysqli_real_escape_string($conn, $Requestor),
mysqli_real_escape_string($conn, $TextNumber),
mysqli_real_escape_string($conn, $Email),
$optIn);
$result9=mysqli_query($conn, $query9);
//mysql_remote($query9, $syncInternet, $hostType);
$mysqlQuery15 = mysqli_real_escape_string($conn, $query9);
}
if ($num2c > 0) $requestsAccepted = $num2c;
else $requestsAccepted = ++$num2b;
if (!$preSchedule) $Message=message("Request accepted (Match# " . $Id . ")." . "
" .
"If anything changes,
FIND and MOVE your request ASAP." .
"
" . $requestsAccepted . " total request(s) accepted for this match.", "", 0);
else $Message=message($preScheduleMessageSubmitted, "", 0);
$MessageStyle = messageStyle(0);
if (($preSchedule) && $eventId) {
$newUniform = $Uniform;
$newColor = $Color;
$newRequestor = $Requestor;
$newTextNumber = $TextNumber;
$newEmail = $Email;
$newProduct = $Product;
}
$accepted = 1;
$AES_Club_Schedule_Opened = false;
$InviteButtonDisplay = "display:inline-block";
$Event = $Id;
include "TexStarVSS-requestBlankTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestBlankBottom.inc";
} else {
if ($Available == 0 || $PlayersPerCourt == 0) {
$Message=message("No photographers are available at " . SUBSTR($Time,0,2) . $Minute . SUBSTR($Time,2) .
" on " . $Date . ".", "Enter another date and/or time and resubmit.", 1);
$MessageStyle = messageStyle(1);
$showRows = 1;
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if ($num2 >= $PlayersPerCourt) {
$Message=message($num2 . " requests already booked
on court " . $Court . " at " . SUBSTR($Time,0,2)
. $Minute . SUBSTR($Time,2), "Enter another court or time and resubmit.", 1);
$MessageStyle = messageStyle(1);
$showRowsRequestsUniforms = 1;
$priorityStandby = 1;
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
else if ($Available == 1) {
$Message=message($Available . " photographer is booked at " . SUBSTR($Time,0,2) . $Minute . SUBSTR($Time,2) .
" on " . $Date . " with " . $num1 . " courts.", "Enter another court or time and resubmit.", 1);
$MessageStyle = messageStyle(1);
$showRows = 1;
$priorityStandby = 1;
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
} else {
$Message=message($Available . " photographers are booked at " . SUBSTR($Time,0,2) . $Minute .
SUBSTR($Time,2) . " on " . $Date . " with " . $num1 . " courts.",
"Enter another court or time and resubmit.", 1);
$MessageStyle = messageStyle(1);
$showRowsCourtsBooked = 1;
include "TexStarVSS-requestResubmitTop.inc";
include "TexStarVSS-requestAll.inc";
include "TexStarVSS-requestResubmitBottom.inc";
}
}
}
?>