";
$sql="SELECT * FROM `VNSB_squares` WHERE $whereclause";
//echo $sql."";
$result = mysqli_query($conn, $sql);
if (!$result) {
echo mysqli_error();
exit;
}
$USER_EMAIL_LIST = '';
while ($record = mysqli_fetch_assoc($result)) {
$USER_EMAIL = '';
$USER_EMAIL = $record["EMAIL"];
$pos = strpos($USER_EMAIL_LIST,$USER_EMAIL);
if($pos === false) {
// string $USER_EMAIL NOT found in $USER_EMAIL_LIST
$USER_EMAIL_LIST = $USER_EMAIL_LIST .",".$USER_EMAIL;
}
}
$USER_EMAIL_LIST = substr_replace($USER_EMAIL_LIST,"",0,1);
$bodyMessage = "\r\nNOTIFICATION\r\n";
//echo $bodyMessage."";
if ($CONFIRM==1 AND $RELEASE!=1) {
$sql="UPDATE `VNSB_squares` SET CONFIRM='1' WHERE $whereclause";
$bodyMessage .= "Your square $square_list is now confirmed.\r\n\n";
} else if ($RELEASE==1 AND $CONFIRM!=1) {
$sql="UPDATE `VNSB_squares` SET NAME='AVAILABLE', EMAIL='', NOTES='', DATE='', CONFIRM='0' WHERE $whereclause";
$bodyMessage .= "Your square $square_list selection is now released due to no payment.\r\n";
$bodyMessage .= "If this is an error, please contact me or re-select your square.\r\n\n";
} else if (($CONFIRM!=1 AND $RELEASE!=1) OR ($RELEASE==1 AND $CONFIRM==1) ) {
echo "Must select ONLY one 'Confirm' or 'Release' !!!
";
echo "Back
";
exit;
}
//echo $sql."";
$result = mysqli_query($conn, $sql);
if (!$result) {
echo mysqli_error();
} else {
$bodyMessage .= $NOTES."\r\n\n";
$bodyMessage .= "Good Luck and enjoy the game.\r\n";
$bodyMessage .= "The Commissioner\r\n";
$bodyMessage .= "$superbowlURL\r\n";
notify_admin($USER_EMAIL_LIST,$bodyMessage,$headers);
echo "Square(s) ".$square_list." updated successful
";
echo "Emailed to: ".$USER_EMAIL_LIST."
";
echo "
";
unset($confirmation, $SQUARE, $CONFIRM, $RELEASE, $NOTES, $ADM_EMAIL, $ADM_PASSWORD);
}
}else{
echo "Must select at least one Square to Confirm or Release' !!!
";
echo "Back
";
exit;
}
} ?>