$sql_select = "SELECT plFirstName, plSurname, plEmail FROM {$db_prefix}players WHERE plPlayerID = " . $item_number;
$result = ba_db_query($link, $sql_select);
$row = ba_db_fetch_assoc($result);
//Send e-mail
$sBody = "Your payment for the upcoming event has been received.\n";
if (PAYPAL_AUTO_MARK_PAID) {
$sBody .= "You are now fully booked.\n\n";
} else {
$sBody .= "You will be fully booked once your booking has been confirmed by a system administrator.\n\n";
}
$sBody .= "Thank you.\n\n";
$sBody .= "Player ID: " . PID_PREFIX . sprintf('%03s', $iPlayerID) . "\n";
$sBody .= "OOC Name: " . $row['plFirstName'] . " " . $row['plSurname'];
if ($bEmailPaymentReceived) {
mail($row['plEmail'], SYSTEM_NAME . ' - payment received', $sBody, "From:" . SYSTEM_NAME . " <" . EVENT_CONTACT_MAIL . ">");
}
//Clear any payment requests for this booking
$sql = "delete from {$db_prefix}paymentrequests where prBookingID = " . $custom;
$result = ba_db_query($link, $sql);
}
} else {
if (strcmp($res, "INVALID") == 0) {
// log for manual investigation
LogError("There was a problem with PayPal payment - PayPal returned 'INVALID' when verifying payment.\n" . "Item name; '{$item_name}'");
fnMailer("There was a problem with PayPal payment - PayPal returned 'INVALID' when verifying payment." . "Payment will have to be manually processed.\n" . "Item name; '{$item_name}'", True);
}
}
}
fclose($fp);
}
include 'inc/inc_foot.php';
generatePaypalButton("Event booking - " . $bookinginfo['evEventName'] . " (" . PID_PREFIX . sprintf('%03s', $PLAYER_ID) . ")", $PLAYER_ID, $bookingtotal, $bookinginfo['bkID']);
echo "</td></tr>";
echo "<tr><td>Pay another amount:</td><td><input type='text' value='" . $bookingtotal . "' onChange='updatePaypalButton()' id='txtAnotherAmount' class='paypalamount'/>";
generatePaypalButton("Event booking - " . $bookinginfo['evEventName'] . " (" . PID_PREFIX . sprintf('%03s', $PLAYER_ID) . ") - Partial Payment", $PLAYER_ID, $bookingtotal, $bookinginfo['bkID'], 'anotheramount');
echo "</td></tr>";
}
echo "<tr><td>Request payment by another user:</td><td>";
echo "<form action='start.php' method='post'><input type=hidden name='hBooking' value='" . $bookinginfo['bkID'] . "' /><input type=text name='txtEmail'/><input type='submit' name='btnSubmit' value='Send Email' /></form>";
echo "</td></tr>";
echo "</table>";
} else {
echo "<p>Your booking is now complete, as it does not require any payment</p>";
$bookinginfo['bkDatePaymentConfirmed'] = $today;
}
} else {
echo "<p>Your booking has been placed in a queue because {$queuereason}</p>";
echo "<p>You will be able to pay once it is removed from the queue by an admin.</p>";
fnMailer("Event booking - " . $eventinfo['evEventName'] . " (" . PID_PREFIX . sprintf('%03s', $PLAYER_ID) . ")\nA booking has been placed in the queue", false);
}
//Save booking info
$sql = "UPDATE {$db_prefix}bookings SET ";
foreach ($bookinginfo as $key => $value) {
if (!is_numeric($value)) {
$value = "'" . $value . "'";
}
$sql .= "{$key} = {$value},";
}
$sql = substr($sql, 0, -1);
$sql .= " WHERE bkID = " . $bookinginfo['bkID'];
$result = ba_db_query($link, $sql);
include 'inc/inc_foot.php';
