Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
_notes	[ DIR ]	drwxr-sr-x	2022-12-20 11:09
_vti_cnf	[ DIR ]	drwxr-sr-x	2022-12-20 11:09
certificate	[ DIR ]	drwxr-sr-x	2023-03-22 11:22
includes	[ DIR ]	drwxr-sr-x	2026-08-24 10:12
mail_interface	[ DIR ]	drwxr-sr-x	2025-06-14 09:47
security	[ DIR ]	drwxr-sr-x	2023-09-17 08:02
temp	[ DIR ]	drwxr-sr-x	2026-04-18 22:25
templates	[ DIR ]	drwxr-sr-x	2026-05-25 12:12
tests	[ DIR ]	drwxr-sr-x	2025-07-07 15:54
CaptchaSecurityImages.php	2.26 KB	-rw-r--r--	2022-12-20 11:09
Inc_calendarnew.php	8.59 KB	-rw-r--r--	2017-11-20 10:34
accredcourses.php	7.04 KB	-rw-r--r--	2023-08-22 10:55
adecquestionnaire.php	26.54 KB	-rw-r--r--	2025-08-01 10:38
advisory.php	7.21 KB	-rw-r--r--	2022-12-20 11:09
advisory_full.php	1.31 KB	-rw-r--r--	2022-12-20 11:09
annualdeclaration.php	15.28 KB	-rw-r--r--	2026-01-22 10:25
awardsentry.php	14.55 KB	-rw-r--r--	2025-08-01 10:38
awardsentry.php.bak	11.22 KB	-rw-r--r--	2016-04-13 12:45
bookdetail.php	954 B	-rw-r--r--	2022-12-20 11:09
books.php	4.4 KB	-rw-r--r--	2023-05-16 13:08
branchdocuments.php	1.14 KB	-rw-r--r--	2022-12-20 11:09
branches.php	2.82 KB	-rw-r--r--	2025-08-06 12:54
calendarpdf.php	1.75 KB	-rw-r--r--	2025-08-26 16:52
cceregister.php	55.59 KB	-rw-r--r--	2026-08-14 12:05
ccmregister.php	71.57 KB	-rw-r--r--	2022-12-20 11:09
class.phpmailer.php	44.39 KB	-rw-r--r--	2022-12-20 11:09
class.smtp.php	32.74 KB	-rw-r--r--	2022-12-20 11:09
committeedocs.php	932 B	-rw-r--r--	2022-12-20 11:09
committees.php	2.69 KB	-rw-r--r--	2025-08-06 12:58
cpdapply.php	5.73 KB	-rw-r--r--	2022-12-20 11:09
cpdapplyform.php	34.06 KB	-rw-r--r--	2025-08-01 10:38
cpdproviderapply.php	42.09 KB	-rw-r--r--	2026-02-10 10:10
cpdproviderportal.php	79.47 KB	-rw-r--r--	2025-09-08 07:23
cpdspverify.php	4.27 KB	-rw-r--r--	2025-10-10 10:45
cpdtmverify.php	4.45 KB	-rw-r--r--	2023-06-19 13:44
declineeventreg.php	3.73 KB	-rw-r--r--	2022-12-20 11:09
directorybooking.php	7.39 KB	-rw-r--r--	2022-12-20 11:09
downloadPN.php	385 B	-rw-r--r--	2025-06-26 13:02
downloadfile.php	280 B	-rw-r--r--	2025-08-01 10:38
enews.php	1.33 KB	-rw-r--r--	2022-12-20 11:09
enewsarchive.php	1.09 KB	-rw-r--r--	2022-12-20 11:09
event.php	12.39 KB	-rw-r--r--	2026-08-19 12:22
event_allvenues.php	18.93 KB	-rw-r--r--	2026-08-09 11:44
eventdecline_awards.php	11.79 KB	-rw-r--r--	2022-12-20 11:09
eventregister.php	26.85 KB	-rw-r--r--	2026-02-10 07:56
eventregister_awards.php	19.4 KB	-rw-r--r--	2025-06-20 06:38
eventregister_golf.php	28.83 KB	-rw-r--r--	2025-08-19 08:12
eventtables.php	24.13 KB	-rw-r--r--	2023-06-01 09:51
eventtables.php.bak	3.49 KB	-rw-r--r--	2022-12-20 11:09
fidicgama2018.php	1012 B	-rw-r--r--	2022-12-20 11:09
forum.php	3.25 KB	-rw-r--r--	2022-12-20 11:09
getoffices.php	799 B	-rw-r--r--	2022-12-20 11:09
hrforumsubscribe.php	2.62 KB	-rw-r--r--	2022-12-20 11:09
hrforumunsubscribe.php	1.32 KB	-rw-r--r--	2022-12-20 11:09
inc_calendarnew.php	10.56 KB	-rw-r--r--	2025-08-21 10:11
inc_captcha.php	337 B	-rw-r--r--	2022-12-20 11:09
inc_db.php	12.33 KB	-rw-r--r--	2025-06-18 12:05
inc_php7.php	6 KB	-rw-r--r--	2025-07-07 12:51
inc_practicenoteslist.php	4.1 KB	-rw-r--r--	2024-07-03 13:52
inc_scecalendar.php	8.55 KB	-rw-r--r--	2025-06-13 08:57
inc_scecalendar_backup.php	6.66 KB	-rw-r--r--	2022-12-20 11:09
inc_scecalendarnew.php	7.84 KB	-rw-r--r--	2026-05-09 09:39
jobshadowschools.php	7.26 KB	-rw-r--r--	2025-06-20 06:38
logout.php	593 B	-rw-r--r--	2025-02-25 08:19
marketingevent.php	122.75 KB	-rw-r--r--	2026-08-03 13:40
marketingeventdecline.php	15.21 KB	-rw-r--r--	2022-12-20 11:09
marketingsurvey.php	5.95 KB	-rw-r--r--	2022-12-20 11:09
matrixtemplate.htm	2.13 KB	-rw-r--r--	2022-12-20 11:09
member_portal_becs.php	2.14 KB	-rw-r--r--	2025-09-12 07:50
member_portal_transformation.php	10.45 KB	-rw-r--r--	2026-05-20 10:07
member_portal_transformation_proxy.php	538 B	-rw-r--r--	2026-05-20 09:08
memberauth.php	991 B	-rw-r--r--	2025-02-25 08:19
memberportal.php	11.79 KB	-rw-r--r--	2026-05-20 09:54
membersearch.php	22.72 KB	-rw-r--r--	2025-02-27 08:02
membersearch_smme.php	6.2 KB	-rw-r--r--	2024-11-27 11:41
memberverify.php	5.25 KB	-rw-r--r--	2022-12-20 11:09
mentors.php	21.68 KB	-rw-r--r--	2025-06-20 06:38
migratenode.php	1.26 KB	-rw-r--r--	2022-12-20 11:09
monofont.ttf	40.07 KB	-rw-r--r--	2022-12-20 11:09
nlc.php	855 B	-rw-r--r--	2022-12-20 11:09
nlcreports.php	2.51 KB	-rw-r--r--	2022-12-20 11:09
php_errors.log	1.06 KB	-rw-r--r--	2026-08-20 23:37
practicenotes.php	4.63 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_full.php	1.33 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_help.php	2.17 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_list.php	2.03 KB	-rw-r--r--	2024-07-03 13:52
practicenotes_search.php	9.43 KB	-rw-r--r--	2022-12-20 11:09
querynlcmatrix.php	15 KB	-rw-r--r--	2022-12-20 11:09
querynlcmatrix.php4	15.38 KB	-rw-r--r--	2012-03-05 08:01
register.php	58.18 KB	-rw-r--r--	2026-05-26 14:55
relay.php	20.33 KB	-rw-r--r--	2025-06-20 06:38
relayteams.php	12.53 KB	-rw-r--r--	2022-12-20 11:09
resendcpdform.php	7.28 KB	-rw-r--r--	2025-08-01 10:38
retiredeng.php	13.45 KB	-rw-r--r--	2025-06-20 06:38
retiredeng_members.php	1.81 KB	-rw-r--r--	2022-12-20 11:09
sanitize.php	10 B	-rw-r--r--	2022-12-20 11:09
sce_survey2015.php	25.85 KB	-rw-r--r--	2022-12-20 11:09
sceallevents.php	8.13 KB	-rw-r--r--	2026-01-20 08:45
scecalendar.php	4.86 KB	-rw-r--r--	2025-06-18 11:18
scecalendar_backup.php	3.17 KB	-rw-r--r--	2025-06-18 11:18
scecalendarnew.php	5.98 KB	-rw-r--r--	2025-08-28 11:14
scecalendarnewtest.php	5.7 KB	-rw-r--r--	2022-03-04 12:37
scecalendartest.php	3.57 KB	-rw-r--r--	2022-03-04 12:38
scecategories.php	914 B	-rw-r--r--	2022-12-20 11:09
scecourses.php	7.18 KB	-rw-r--r--	2026-08-19 12:15
scelist.php	7.72 KB	-rw-r--r--	2025-08-29 07:18
scesubscribe.php	2.06 KB	-rw-r--r--	2022-12-20 11:09
sceupdate.php	1.67 KB	-rw-r--r--	2025-06-18 11:18
scevenuehire.php	6.15 KB	-rw-r--r--	2026-01-23 13:12
sendeventreg.php	19.5 KB	-rw-r--r--	2026-08-14 12:05
sendeventreg2.php	2.83 KB	-rw-r--r--	2026-07-17 14:57
sendeventreg_golf.php	20.23 KB	-rw-r--r--	2026-08-14 12:05
sendeventreg_golf.php.bak	11.69 KB	-rw-r--r--	2016-09-07 09:48
sendreg.php	35.15 KB	-rw-r--r--	2026-08-14 12:05
smsunsub.php	1.89 KB	-rw-r--r--	2025-06-18 11:18
template.php	54.36 KB	-rw-r--r--	2022-12-20 11:09
tenders.php	1.34 KB	-rw-r--r--	2022-12-20 11:09
trainerportal.php	50.27 KB	-rw-r--r--	2025-08-01 11:06
trainerportal.php.bak	2.57 KB	-rw-r--r--	2022-12-20 11:09
unempgrad_members.php	2.38 KB	-rw-r--r--	2025-06-18 11:18
unemployed.php	14.13 KB	-rw-r--r--	2025-06-20 06:38
unemployedreg.php	23.38 KB	-rw-r--r--	2025-06-20 06:38
unempreg_members.php	2.36 KB	-rw-r--r--	2025-06-18 11:18
ypfbranchcommittee.php	1.63 KB	-rw-r--r--	2022-12-20 11:09
ypfcommittees.php	1.57 KB	-rw-r--r--	2022-12-20 11:09
ypfjoin.php	30.29 KB	-rw-r--r--	2025-07-07 15:53
ypfjoin2.php	28.13 KB	-rw-r--r--	2025-06-18 11:18
ypfjoinmatches.php	9.46 KB	-rw-r--r--	2025-06-18 11:18
ypfmentees.php	20.81 KB	-rw-r--r--	2026-08-24 11:52
ypfmentees_members.php	2.42 KB	-rw-r--r--	2025-06-18 11:18

Rename

<?php
// ini_set('display_errors', 1);
// error_reporting(E_ALL);

$bDietaryReq = false;
?>
<link rel="stylesheet" href="/autosuggest/css/autosuggest_inquisitor.css" type="text/css" media="screen" charset="utf-8" />
<script type="text/javascript" src="/autosuggest/js/bsn.AutoSuggest_c_2.0.js"></script>
<script src="https://www.google.com/recaptcha/api.js" async defer></script>

<?php
    if (isset($row) && $row["PilotCourse"] <= 0) {
        // No more pilot courses
        //echo 'pilotCourse = true;';
    }
    ?>

function IsEmpty(aTextField) {
        if ((aTextField.value.length == 0) || (aTextField.value == null)) {
            return true;
        } else {
            return false;
        }
    }

// Declaring required variables
    var digits = "0123456789";
    // non-digit characters which are allowed in phone numbers
    var phoneNumberDelimiters = "()- ";
    // characters which are allowed in international phone numbers
    // (a leading + is OK)
    var validWorldPhoneChars = phoneNumberDelimiters + "+";
    // Minimum no of digits in an international phone no.
    var minDigitsInIPhoneNumber = 7;

function isInteger(s) {
        var i;
        for (i = 0; i < s.length; i++) {
            // Check that current character is number.
            var c = s.charAt(i);
            if (((c < "0") || (c > "9")))
                return false;
        }
        // All characters are numbers.
        return true;
    }

function stripCharsInBag(s, bag) {
        var i;
        var returnString = "";
        // Search through string's characters one by one.
        // If character is not in bag, append to returnString.
        for (i = 0; i < s.length; i++) {
            // Check that current character isn't whitespace.
            var c = s.charAt(i);
            if (bag.indexOf(c) == -1)
                returnString += c;
        }
        return returnString;
    }

function checkInternationalPhone(strPhone) {
        s = stripCharsInBag(strPhone, validWorldPhoneChars);
        return (isInteger(s) && s.length >= minDigitsInIPhoneNumber);
    }

function ValidateForm() {
        var Phone = document.frmSample.txtPhone

if ((Phone.value == null) || (Phone.value == "")) {
            alert("Please Enter your Phone Number")
            Phone.focus()
            return false
        }
        if (checkInternationalPhone(Phone.value) == false) {
            alert("Please Enter a Valid Phone Number")
            Phone.value = ""
            Phone.focus()
            return false
        }
        return true
    }

function formCheck(objForm) {
        bOK = true;

if (!objForm.checkTCs.checked) {
            bOK = false;
            alert('Please accept the terms and conditions.');
            objForm.checkTCs.focus();
            objForm.checkTCs.scrollIntoView();

} else if (!objForm.checkPerm.checked && !pilotCourse) {
            bOK = false;
            alert('Please confirm that payment has been authorised.');
            objForm.checkPerm.focus();
            objForm.checkPerm.scrollIntoView();
        } else if (IsEmpty(objForm.BookingName)) {
            bOK = false;
            alert('Please fill in your name.');
            objForm.BookingName.focus();
            objForm.BookingName.scrollIntoView();
        } else if (IsEmpty(objForm.Organisation)) {
            bOK = false;
            alert('Please fill in your organisation.');
            objForm.Organisation.focus();
            objForm.Organisation.scrollIntoView();
        } else if (IsEmpty(objForm.Address1)) {
            bOK = false;
            alert('Please fill in the address.');
            objForm.Address1.focus();
            objForm.Address1.scrollIntoView();
        } else if (IsEmpty(objForm.City)) {
            bOK = false;
            alert('Please fill in the city.');
            objForm.City.focus();
            objForm.City.scrollIntoView();
        } else if (IsEmpty(objForm.PostalCode)) {
            bOK = false;
            alert('Please fill in the postal code.');
            objForm.PostalCode.focus();
            objForm.PostalCode.scrollIntoView();
        }

<?php
        for ($i = 1; $i <= 10; $i++) {
        ?>
            if (bOK && (objForm.DivDisplayed<?php echo $i; ?>.value == 1)) {
                if (IsEmpty(objForm.Surname<?php echo $i; ?>)) {
                    bOK = false;
                    alert('Please fill in attendee <?php echo $i; ?>\'s surname.');
                } else if (IsEmpty(objForm.FirstName<?php echo $i; ?>)) {
                    bOK = false;
                    alert('Please fill in attendee <?php echo $i; ?>\'s first name.');
                } else if (IsEmpty(objForm.Tel<?php echo $i; ?>) && IsEmpty(objForm.Mobile<?php echo $i; ?>)) {
                    bOK = false;
                    alert('Please fill in attendee <?php echo $i; ?>\'s telephone or cell number.');
                } else {
                    bOK = emailCheck(objForm.Email<?php echo $i; ?>.value);
                }
            }
        <?php
        }
        ?>
        if (bOK && IsEmpty(objForm.MarketingSource)) {
            bOK = false;
            alert('Please let us know where you heard about us.');
            objForm.MarketingSource.focus();
            objForm.MarketingSource.scrollIntoView();
        }
        /*
         } else if (IsEmpty(objForm.OrderNumber)) {
         bOK = false;
         alert('Please fill in the order number.');
         } else if ((checkInternationalPhone(objForm.Tel.value)==false) && (checkInternationalPhone(objForm.Mobile.value)==false)) {
         bOK = false;
         alert('Please provide a valid telephone number.');
         } else if (!isInteger(objForm.PostalCode.value)) {
         bOK = false;
         alert('Please provide a numeric postal code.');
         */
        if (bOK) {
            objForm.formsubmit.disabled = true;
            objForm.formsubmit.value = "Please wait...";
            objForm.submit();
        } else {
            alert('Some fields were not completed.');
        }

return bOK;
    }

function emailCheck(emailStr) {

/* The following variable tells the rest of the function whether or not
         to verify that the address ends in a two-letter country or well-known
         TLD.  1 means check it, 0 means don't. */

var checkTLD = 0;

/* The following is the list of known TLDs that an e-mail address must end with. */

var knownDomsPat = /^(com|net|org|edu|int|mil|gov|arpa|biz|aero|name|coop|info|pro|museum)$/;

/* The following pattern is used to check if the entered e-mail address
         fits the user@domain format.  It also is used to separate the username
         from the domain. */

var emailPat = /^(.+)@(.+)$/;

/* The following string represents the pattern for matching all special
         characters.  We don't want to allow special characters in the address.
         These characters include ( ) < > @ , ; : \ " . [ ] */

var specialChars = "\$\$><@,;:\\\\\\\"\\.\\[\\]";

/* The following string represents the range of characters allowed in a
         username or domainname.  It really states which chars aren't allowed.*/

var validChars = "\[^\\s" + specialChars + "\]";

/* The following pattern applies if the "user" is a quoted string (in
         which case, there are no rules about which characters are allowed
         and which aren't; anything goes).  E.g. "jiminy cricket"@disney.com
         is a legal e-mail address. */

var quotedUser = "(\"[^\"]*\")";

/* The following pattern applies for domains that are IP addresses,
         rather than symbolic names.  E.g. joe@[123.124.233.4] is a legal
         e-mail address. NOTE: The square brackets are required. */

var ipDomainPat = /^\[(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})\]$/;

/* The following string represents an atom (basically a series of non-special characters.) */

var atom = validChars + '+';

/* The following string represents one word in the typical username.
         For example, in john.doe@somewhere.com, john and doe are words.
         Basically, a word is either an atom or quoted string. */

var word = "(" + atom + "|" + quotedUser + ")";

// The following pattern describes the structure of the user

var userPat = new RegExp("^" + word + "(\\." + word + ")*$");

/* The following pattern describes the structure of a normal symbolic
         domain, as opposed to ipDomainPat, shown above. */

var domainPat = new RegExp("^" + atom + "(\\." + atom + ")*$");

/* Finally, let's start trying to figure out if the supplied address is valid. */

/* Begin with the coarse pattern to simply break up user@domain into
         different pieces that are easy to analyze. */

var matchArray = emailStr.match(emailPat);

if (matchArray == null) {

/* Too many/few @'s or something; basically, this address doesn't
             even fit the general mould of a valid e-mail address. */

alert("Email address seems incorrect (check @ and .'s)");
            return false;
        }
        var user = matchArray[1];
        var domain = matchArray[2];

// Start by checking that only basic ASCII characters are in the strings (0-127).

for (i = 0; i < user.length; i++) {
            if (user.charCodeAt(i) > 127) {
                alert("The email address contains invalid characters.");
                return false;
            }
        }
        for (i = 0; i < domain.length; i++) {
            if (domain.charCodeAt(i) > 127) {
                alert("The email address contains invalid characters.");
                return false;
            }
        }

// See if "user" is valid

if (user.match(userPat) == null) {

// user is not valid

alert("The email address doesn't seem to be valid.");
            return false;
        }

/* if the e-mail address is at an IP address (as opposed to a symbolic
         host name) make sure the IP address is valid. */

var IPArray = domain.match(ipDomainPat);
        if (IPArray != null) {

// this is an IP address

for (var i = 1; i <= 4; i++) {
                if (IPArray[i] > 255) {
                    alert("Destination IP address is invalid!");
                    return false;
                }
            }
            return true;
        }

// Domain is symbolic name.  Check if it's valid.

var atomPat = new RegExp("^" + atom + "$");
        var domArr = domain.split(".");
        var len = domArr.length;
        for (i = 0; i < len; i++) {
            if (domArr[i].search(atomPat) == -1) {
                alert("The email address does not seem to be valid.");
                return false;
            }
        }

/* domain name seems valid, but now make sure that it ends in a
         known top-level domain (like com, edu, gov) or a two-letter word,
         representing country (uk, nl), and that there's a hostname preceding
         the domain or country. */

if (checkTLD && domArr[domArr.length - 1].length != 2 &&
            domArr[domArr.length - 1].search(knownDomsPat) == -1) {
            alert("The email address must end in a well-known domain or two letter " + "country.");
            return false;
        }

// Make sure there's a host name preceding the domain.

if (len < 2) {
            alert("The email address is missing a hostname!");
            return false;
        }

// If we've gotten this far, everything's valid!
        return true;
    }
</script>
<?php
$id = intval($_REQUEST["id"]);

include('inc_db.php');
include_once($_SERVER['DOCUMENT_ROOT'] . "/cesanet/inc_shared.php");

$db = mysql_connect($loghost, $logid, $logpwd);

mysql_select_db($dbname, $db);

$sql = "SELECT SchoolEvents.EventName, SchoolEvents.Level, SchoolEvents.City, SchoolEvents.Venue,
	SchoolEvents.AvailableSpaces, SchoolEvents.CostPerPerson, SchoolEvents.EventDescription, SchoolFacilitators.FacilitatorName,
	SchoolFacilitators.PhoneNumber AS FacTel, SchoolFacilitators.MobileNumber AS FacMobile, SchoolFacilitators.FaxNumber AS FacFax,
	SchoolFacilitators.EmailAddress AS FacEmail, SchoolProviders.ProviderName, SchoolProviders.PhoneNumber AS ProvTel,
	SchoolProviders.MobileNumber AS ProvMobile, SchoolProviders.FaxNumber AS ProvFax, SchoolProviders.EmailAddress AS ProvEmail,
	SchoolPresenters.PresenterName, SchoolPresenters.PhoneNumber, SchoolPresenters.MobileNumber,
	SchoolPresenters.FaxNumber, SchoolPresenters.EmailAddress, SchoolEvents.Hours, SchoolEvents.CPD, SchoolEvents.CODE,
	SchoolEvents.NQFLevel, SchoolEvents.AccredNum, SchoolEvents.Province, SchoolEvents.RegDeadline,
	SchoolEvents.MemberDiscount, SchoolEvents.EarlyBirdDiscount, SchoolEvents.Cancelled, SchoolEvents.BankAccName,
	CourseVenues.CourseVenueCity, CourseVenues.CourseVenueArea, SchoolEvents.SchoolCourseID, SchoolEvents.PilotCourse
	FROM (SchoolProviders 
    RIGHT JOIN (SchoolFacilitators RIGHT JOIN (SchoolEvents LEFT JOIN CourseVenues ON SchoolEvents.Venue = CourseVenues.CourseVenueName) ON SchoolFacilitators.FacilitatorID=SchoolEvents.FacilitatorID)
		ON SchoolProviders.ProviderID=SchoolEvents.ProviderID) LEFT JOIN SchoolPresenters ON SchoolEvents.PresenterID=SchoolPresenters.PresenterID
	WHERE SchoolEvents.EventID=" . $id;

$queryresult = mysql_query($sql); // or die(mysql_error());

if ($row = mysql_fetch_array($queryresult)) {

// check the dates
    $sql2 = "SELECT * FROM EventSchedules WHERE EventID=" . $id . " ORDER BY ScheduleDate";
    $queryresult2 = mysql_query($sql2);
    $ScheduleDates = "";
    $bEventInPast = false;
    $eventDates = [];

while ($row2 = mysql_fetch_array($queryresult2)) {
        $StartDatePlusTime = date("Y-m-d", strtotime($row2["ScheduleDate"])) . " " . date("H:i:s", strtotime(substr($row2["StartTime"], 0, 5)));
        $ScheduleDates .= '<b>.</b> ' . date("D j F Y", strtotime($row2["ScheduleDate"])) . " " . substr($row2["StartTime"], 0, 5) . ' to ' . substr($row2["EndTime"], 0, 5) . "<BR>";

if (strtotime($StartDatePlusTime) < time())
            $bEventInPast = true;

$eventDates[] = $row2;
    }

// check that there are still available spaces
    $iNumBooked = 0;
    $sql2 = "SELECT count(*) AS NumBooked FROM SchoolAttendees WHERE Cancelled=0 AND EventID=" . $id;
    $queryresult2 = mysql_query($sql2);
    if ($row2 = mysql_fetch_array($queryresult2)) {
        $iNumBooked = $row2["NumBooked"];
    }

$bNoSpace = (($row["AvailableSpaces"] > 0) && ($iNumBooked >= $row["AvailableSpaces"]));

if ($bEventInPast || $bNoSpace || ($row["Cancelled"] == 1)) {
        // No space left
        echo '<h1 ALIGN="center">' . $row["EventName"] . '</h1><p align="center">' . $ScheduleDates . '</p>';
        echo "<p><b><center>Registrations have now closed for this course.</center></b></p>";
        echo "<p><b><center>Other options:</center></b></p><ul>";
        $sql = "SELECT * FROM SchoolEvents WHERE SchoolCourseID=" . $row["SchoolCourseID"] . " AND Cancelled=0 AND AvailableSpaces>0 AND StartDate>'" . $StartDatePlusTime . "' AND StartDate>NOW()";
        $recOther = mysql_query($sql);
        while ($rowOther = mysql_fetch_assoc($recOther)) {
            echo "<li><a href='/sce/school-event-registration/?id=" . $rowOther["EventID"] . "'>" . $rowOther["EventName"] . ", " . $rowOther["StartDate"] . "</a></li>";
        }
        echo "<li><a href='/sce/school-of-consulting-engineers/cpd-training/training-calendar/'>View our Calendar to find more courses like this one</a></li>
        <li>Contact Blessings (<a href='mailto:blessings@cesa.co.za'>blessings@cesa.co.za</a>) with your details and the course you are interested in. Should there be enough interest another course will be scheduled.</li>
        </ul>";
    } else {

$bShowForm = true;
        if (isset($_POST["ProcessForm"]) && ($_POST["ProcessForm"] == 1)) {
            include("sendreg.php");
            if (!$bFormErrors)
                $bShowForm = false;
        }

if ($bShowForm) {

$schoolEventObj = new SchoolEvents($sqlf);
            $eventCostOptions = $schoolEventObj->getEventCostOptions($row);

if (count($eventDates) == 1) {
                $ScheduleDates = date("D j F Y", strtotime($eventDates[0]["ScheduleDate"])) . " " . substr($eventDates[0]["StartTime"], 0, 5) . ' to ' . substr($eventDates[0]["EndTime"], 0, 5);
            } elseif (count($eventDates) == 2) {
                $ScheduleDates = 'Start Date/Time: ' . date("D j F Y", strtotime($eventDates[0]["ScheduleDate"])) . " " . substr($eventDates[0]["StartTime"], 0, 5)
                    . ' to ' . substr($eventDates[0]["EndTime"], 0, 5) . '<br />'
                    . 'End Date/Time: ' . date("D j F Y", strtotime($eventDates[1]["ScheduleDate"])) . " " . substr($eventDates[1]["StartTime"], 0, 5)
                    . ' to ' . substr($eventDates[1]["EndTime"], 0, 5);
            }
?>
            <p align="right">
                <b><a href="/sce/school-of-consulting-engineers/cpd-training/training-calendar/">&lt;&lt; Return to Calendar</a></b><br />
                <b><a href="/sce/school-event/?id=<?php echo $id; ?>">&lt;&lt; Return to Event Information</a></b>
            </p>
            <?php
            if ($id == 187) {
                include("inc_gamalogos.php");
            }
            ?>
            <?php
            if ($bFormErrors) {
                echo "<p><font color=red><b>The following errors occurred:</b></font><br>" . join("<br>", $sError) . "<br><b>Please correct the errors and submit again. Thank you!</b></p>";
            }
            ?>

<h1 ALIGN="center"><?php echo $row["EventName"]; ?></h1>
            <h1 align="center">REGISTRATION FORM</h1>
            <p align=center style='text-align:center'><span style="font-size:14px; color: #0e3b9c;">
                    Please fill in the form, and then press the Submit button to send it to CESA.</span></p>
            <form name="form1" method="post" action="/sce/school-event-registration" onSubmit="return formCheck(this)" id="form1">
                <input type="hidden" name="ProcessForm" value="1">
                <input type="hidden" name="EventID" value="<?php echo $id; ?>">
                <input type="hidden" name="id" value="<?php echo $id; ?>">
                
                <table width=760 border=1 cellpadding=2 cellspacing=0 class="regform">
                    <tr>
                        <td colspan="2" valign=top nowrap>
                            <?php echo $ScheduleDates; ?>
                        </td>
                        <td colspan="2" valign=top nowrap>
                            <?php
                            if (is_countable($eventCostOptions) && count($eventCostOptions) > 0) {

foreach ($eventCostOptions as $costpp => $cppRow) {

if (count($eventCostOptions) > 1) {
                                        $fromDate = new DateTime($cppRow['StartDate']);
                                        echo '<p><b>From ' . $fromDate->format('F Y') . '</b></p>';
                                    }
                                    
                                    
                                    if (isset($cppRow['CostPerPerson']) && $cppRow['CostPerPerson'] > 0) {
                                        echo 'R ' . number_format($cppRow['CostPerPerson'], 2, '.', ' ') . ' per person (excl. VAT)<br />';
                                        echo 'R ' . number_format(ceil($cppRow['CostPerPerson'] * $incvat), 2, '.', ' ') . ' per person (incl. VAT)';
                                    }
                                }
                            } else {
                                echo 'No cost information available';
                            }
                            ?>
                        </td>
                    </tr>
                    <tr>
                        <td width="17%" valign=top nowrap>
                            <p>Organisation Name: <span style="color:red">*</span></p>
                        </td>
                        <td valign=top><input name="Organisation" id="Organisation" type="text" size="35" maxlength="255" value="<?php echo stripslashes($_POST["Organisation"] . ""); ?>" placeholder="Required" required><br />
                        </td>
                        <td valign=top nowrap>Organisation Type: <span style="color:red">*</span></td>
                        <td valign=top nowrap>
                            <select name="CompanyType" id="CompanyType" required>
                                <option value="">Please select (required)</option>
                                <?php
                                $queryresultL = mysql_query("SELECT LookupValue "
                                    . "FROM Lookups "
                                    . "WHERE LookupName='SCECompanyType' "
                                    . "AND Active = 1 "
                                    . "ORDER BY LookupOrder, LookupID");

while ($rowL = mysql_fetch_array($queryresultL)) {
                                ?>
                                    <option value="<?php echo $rowL["LookupValue"]; ?>"><?php echo $rowL["LookupValue"]; ?></option>
                                <?php
                                }
                                mysql_free_result($queryresultL);
                                ?>
                            </select>

<p id="companyTypeOther" style="display:none" class="companyTypeOther">
                                <input type="text" name="CompanyTypeOther" id="CompanyTypeOther" size="45" maxlength="50" value="<?php echo stripslashes($_POST["CompanyTypeOther"] . ""); ?>" placeholder="Enter your Organisation Type here">
                            </p>
                        </td>
                    </tr>
                    <tr>
                        <td colspan=2 align=center style="text-align:center; padding:0">
                            <span style="font-size:14px; color: #0e3b9c;">
                                <b>ATTENTION!!<br />If your organisation name isn't listed, continue typing to add it to our database.</b>
                            </span>
                        </td>
                        <td colspan=2 style="padding:0"></td>
                    </tr>
                    <tr>
                        <td valign=top>VAT Number: </td>
                        <td valign=top nowrap><input name="VATNumber" type="text" size="30" maxlength="50" value="<?php echo $_POST["VATNumber"]; ?>">
                        </td>
                        <?php
                        if ($row["PilotCourse"] <= 0) {
                        ?>
                            <td valign=top>Purchase Order Number:</td>
                            <td><input name="OrderNumber" type="text" size="30" maxlength="50" value="<?php echo $_POST["OrderNumber"]; ?>"></td>
                        <?php
                        }
                        ?>
                    </tr>
                    <tr>
                        <td valign=top>
                            <p>Postal Address: <span style="color:red">*</span></p>
                        </td>
                        <td colspan=3 valign=top><input name="Address1" type="text" size="50" maxlength="255" value="<?php echo stripslashes($_POST["Address1"] . ""); ?>" placeholder="Required" required></td>
                    </tr>
                    <tr>
                        <td valign=top>
                            <p> </p>
                        </td>
                        <td colspan=3 valign=top><input name="Address2" type="text" size="50" maxlength="255" value="<?php echo stripslashes($_POST["Address2"] . ""); ?>"> </td>
                    </tr>
                    <tr>
                        <td valign=top>
                            <p>City: <span style="color:red">*</span></p>
                        </td>
                        <td valign=top><input name="City" type="text" size="30" maxlength="50" value="<?php echo stripslashes($_POST["City"] . ""); ?>" placeholder="Required" required> </td>
                        <td valign=top>
                            <p>Postal code: <span style="color:red">*</span></p>
                        </td>
                        <td valign=top><input name="PostalCode" type="text" size="30" maxlength="20" value="<?php echo $_POST["PostalCode"]; ?>" placeholder="Required" required></td>
                    </tr>
                    <tr>
                        <td valign=top>
                            <p>Province: <span style="color:red">*</span></p>
                        </td>
                        <td colspan=3 valign=top>
                            <select name="profile_province" required>
                                <option value="">Please select</option>
                                <option value="Western Cape">Western Cape</option>
                                <option value="Eastern Cape">Eastern Cape</option>
                                <option value="Free State">Free State</option>
                                <option value="Gauteng">Gauteng</option>
                                <option value="Kwazulu Natal">Kwazulu Natal</option>
                                <option value="Limpopo">Limpopo</option>
                                <option value="Mpumalanga">Mpumalanga</option>
                                <option value="Northern Cape">Northern Cape</option>
                                <option value="Northwest">Northwest</option>
                                <option value="Other">Other</option>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td valign=top>
                            <p>Country: <span style="color:red">*</span></p>
                        </td>
                        <td colspan=3 valign=top>
                            <?php

if (!isset($_POST['profile_country']) || strlen($_POST['profile_country']) <= 0) {
                                $_POST['profile_country'] = 'South Africa';
                            }

echo HTMLHelper::getCountrySelect(
                                ['value' => $_POST['profile_country'], 'name' => 'profile_country', 'required' => true]
                            );
                            ?>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2" valign=top><strong>Booking made by:</strong></td>
                        <td valign=top>&nbsp;</td>
                        <td valign=top>&nbsp;</td>
                    </tr>
                    <tr>
                        <td valign=top>Your name & surname: <span style="color:red">*</span></td>
                        <td valign=top><input name="BookingName" type="text" size="40" maxlength="255" id="BookingName" value="<?php echo stripslashes($_POST["BookingName"] . ""); ?>" placeholder="Required" required></td>
                        <td valign=top>Cell No.: <span style="color:red">*</span></td>
                        <td valign=top><input name="BookingTel" type="text" size="30" maxlength="50" id="BookingTel" value="<?php echo $_POST["BookingTel"]; ?>" placeholder="Required" required></td>
                    </tr>
                    <tr>
                        <td valign=top>Email Address: <span style="color:red">*</span></td>
                        <td valign=top colspan=3><input name="BookingEmail" type="text" size="30" maxlength="255" id="BookingEmail" value="<?php echo $_POST["BookingEmail"]; ?>" placeholder="Required" required></td>
                    </tr>
                    <tr>
                        <td colspan="4" valign=top>
                            <strong>HR Manager:</strong>
                        </td>
                    </tr>
                    <tr>
                        <td valign=top>
                            Name & Surname: <span style="color:red">*</span>
                        </td>
                        <td valign=top>
                            <input name="HRManagerName" type="text" size="30" maxlength="255" id="HRManagerName"
                                value="<?php echo $_POST["HRManagerName"]; ?>" placeholder="Required" required>
                        </td>
                        <td valign=top>
                            Cell No.: <span style="color:red">*</span>
                        </td>
                        <td valign=top>
                            <input name="HRManagerCellNo" type="text" size="30" maxlength="20" id="HRManagerCellNo"
                                value="<?php echo $_POST["HRManagerCellNo"]; ?>" placeholder="Required" required>
                        </td>
                    </tr>
                    <tr>
                        <td valign=top>
                            Email Address: <span style="color:red">*</span>
                        </td>
                        <td colspan="3" valign=top>
                            <input name="HRManagerEMail" type="text" size="30" maxlength="255" id="HRManagerEMail"
                                value="<?php echo $_POST["HRManagerEMail"]; ?>" placeholder="Required" required>
                        </td>
                    </tr>
                    <?php
                    if ($row["PilotCourse"] <= 0) {
                    ?>
                        <tr>
                            <td colspan="4" valign=top>
                                <strong>Who is responsible for payment? Please provide details:</strong>
                            </td>
                        </tr>
                        <tr>
                            <td valign=top>
                                Name & Surname: <span style="color:red">*</span>
                            </td>
                            <td valign=top>
                                <input name="ResponsiblePaymentName" type="text" size="30" maxlength="255" id="ResponsiblePaymentName"
                                    value="<?php echo $_POST["ResponsiblePaymentName"]; ?>" placeholder="Required" required>
                            </td>
                            <td valign=top>
                                Cell No.: <span style="color:red">*</span>
                            </td>
                            <td valign=top>
                                <input name="ResponsiblePaymentCellNo" type="text" size="30" maxlength="255" id="ResponsiblePaymentCellNo"
                                    value="<?php echo $_POST["ResponsiblePaymentCellNo"]; ?>" placeholder="Required" required>
                            </td>
                        </tr>
                        <tr>
                            <td valign=top>
                                Designation: <span style="color:red">*</span>
                            </td>
                            <td colspan="3" valign=top>
                                <input name="ResponsiblePaymentDesignation" type="text" size="30" maxlength="255" id="ResponsiblePaymentDesignation"
                                    value="<?php echo $_POST["ResponsiblePaymentDesignation"]; ?>" placeholder="Required" required>
                            </td>
                        </tr>
                        <tr>
                            <td valign=top>
                                Email Address: <span style="color:red">*</span>
                            </td>
                            <td colspan="3" valign=top>
                            <input name="ResponsiblePayment" type="text" size="30" maxlength="255" id="ResponsiblePayment"
                                    value="<?php echo $_POST["ResponsiblePayment"]; ?>" placeholder="Required" required>
                            </td>
                        </tr>
                    <?php
                    } else {
                    ?>
                        <input name="ResponsiblePayment" type="hidden" id="ResponsiblePayment" value="Pilot Course" />
                    <?php
                    }
                    ?>
                </table>
                <p>
                <h3>Attendees</h3>
                </p>
                <p style="font-size:14px; color:#0e3b9c;">ATTENTION!!<br />
                    To add more attendees, click the &quot;Add Another
                    Attendee&quot; button.</p>
                <?php
                for ($i = 1; $i <= 10; $i++) {
                    $ShowThisDiv = 0;
                    if ($i == 1)
                        $ShowThisDiv = 1;
                    if ($_POST["DivDisplayed" . $i] == "1")
                        $ShowThisDiv = 1;
                    echo '<div id="candidate' . $i . '" style="display:' . ($ShowThisDiv == 0 ? "none" : "") . '">';
                ?>
                    <input type="hidden" name="DivDisplayed<?php echo $i; ?>" id="DivDisplayed<?php echo $i; ?>" value="<?php echo $ShowThisDiv; ?>">
                    <table width=760 border=1 cellpadding=2 cellspacing=0 style="margin-bottom:0">
                        <tr>
                            <td width="16%" valign=top>
                                <p>Title:</p>
                            </td>
                            <td width="25%" valign=top>
                                <table border="0" cellspacing="0" cellpadding="0">
                                    <tr>
                                        <td nowrap style="padding:0px 10px 0px 5px">Prof.<input type="radio" name="Title" value="Prof"></td>
                                        <td nowrap style="padding:0px 10px 0px 5px">Dr.<input type="radio" name="Title<?php echo $i; ?>" value="Dr" <?php if ($_POST["Title" . $i] == "Dr") echo " checked"; ?>></td>
                                        <td nowrap style="padding:0px 10px 0px 5px">Mr.<input name="Title<?php echo $i; ?>" type="radio" value="Mr" <?php if (!isset($_POST["Title" . $i]) || ($_POST["Title" . $i] == "Mr")) echo " checked"; ?>></td>
                                    </tr>
                                    <tr>
                                        <td nowrap style="padding:0px 10px 0px 5px">Mrs.
                                            <input type="radio" name="Title<?php echo $i; ?>" value="Mrs" <?php if ($_POST["Title" . $i] == "Mrs") echo " checked"; ?>>
                                        </td>
                                        <td nowrap style="padding:0px 0px 0px 5px">Ms.
                                            <input type="radio" name="Title<?php echo $i; ?>" value="Ms" <?php if ($_POST["Title" . $i] == "Ms") echo " checked"; ?>>
                                        </td>
                                        <td nowrap style="padding:0px 10px 0px 5px">&nbsp;</td>
                                    </tr>
                                </table>
                            </td>
                            <td width="27%" valign=top>Designation:<br><span style="font-size:11px">(e.g. CEO, Managing Director, Personal Assistant etc)</span></td>
                            <td width="32%" valign=top><input name="Designation<?php echo $i; ?>" type="text" size="40" maxlength="50" id="Designation<?php echo $i; ?>" value="<?php echo $_POST["Designation" . $i]; ?>"></td>
                        </tr>
                        <tr>
                            <td valign=top>First Name: <span style="color:red">*</span></td>
                            <td valign=top><input name="FirstName<?php echo $i; ?>" type="text" size="30" maxlength="30" value="<?php echo stripslashes($_POST["FirstName" . $i] . ""); ?>" placeholder="Required" <?php if ($ShowThisDiv == 1) echo " required"; ?>></td>
                            <td valign=top>Surname: <span style="color:red">*</span></td>
                            <td valign=top><input name="Surname<?php echo $i; ?>" type="text" size="40" maxlength="50" value="<?php echo $_POST["Surname" . $i]; ?>" placeholder="Required" <?php if ($ShowThisDiv == 1) echo " required"; ?>></td>
                        </tr>
                        <tr>
                            
                            <td valign=top>
                                ID Number / Passport: <span style="color:red">*</span>
                            </td>
                            <td><input name="IDNumber<?php echo $i; ?>" type="text" size="40" maxlength="50" value="<?php echo $_POST["IDNumber" . $i]; ?>" placeholder="Required" <?php if ($ShowThisDiv == 1) echo " required"; ?>></td>
                            <td valign=top>
                                E-mail: <span style="color:red">*</span>
                            </td>
                            <td valign=top><input name="Email<?php echo $i; ?>" type="text" size="30" maxlength="255" value="<?php echo $_POST["Email" . $i]; ?>" placeholder="Required" <?php if ($ShowThisDiv == 1) echo " required"; ?>></td>
                        </tr>
                        <tr>
                            <td valign=top>
                                Telephone: <span style="color:red">*</span>
                            </td>
                            <td valign=top><input name="Tel<?php echo $i; ?>" type="text" size="30" maxlength="50" value="<?php echo $_POST["Tel" . $i]; ?>" placeholder="Required" <?php if ($ShowThisDiv == 1) echo " required"; ?>></td>
                            <td valign=top>
                                Cell: <span style="color:red">*</span>
                            </td>
                            <td valign=top><input name="Mobile<?php echo $i; ?>" type="text" size="30" maxlength="50" value="<?php echo $_POST["Mobile" . $i]; ?>" placeholder="Required" <?php if ($ShowThisDiv == 1) echo " required"; ?>></td>
                        </tr>
                        <tr>
                            <td valign=top>
                                ECSA registration number:<br>
                                <small>(if registered)</small>
                            </td>
                            <td valign=top><input name="ECSANumber<?php echo $i; ?>" type="text" size="30" maxlength="50" id="ECSANumber<?php echo $i; ?>" value="<?php echo $_POST["ECSANumber" . $i]; ?>" />
                            </td>
                            <td valign=top>
                                SAICE member number:<br>
                                <small>(if a member)</small>
                            </td>
                            <td valign=top><input name="SAICENumber<?php echo $i; ?>" type="text" size="30" maxlength="50" id="SAICENumber<?php echo $i; ?>" value="<?php echo $_POST["SAICENumber" . $i]; ?>" />
                            </td>
                        </tr>
                        <tr>
                            <td colspan="2" valign=top>Are you a member of any of the following professional associations? <span style="color:red">*</span></td>
                            <td colspan="2" valign=top>
                                <select name="profile_institute<?php echo $i; ?>" <?php if ($ShowThisDiv == 1) echo " required"; ?>>
                                    <option value="">Please select</option>
                                    <option value="SAIA">SAIA</option>
                                    <option value="CESA">CESA</option>
                                    <option value="ASAQS">ASAQS</option>
                                    <option value="AAQS">AAQS</option>
                                    <option value="ACPM">ACPM</option>
                                    <option value="SAPOA">SAPOA</option>
                                    <option value="SAIAT">SAIAT</option>
                                    <option value="SABTACO">SABTACO</option>
                                    <option value="MBSA">MBSA</option>
                                    <option value="ILASA">ILASA</option>
                                    <option value="SAIBD">SAIBD</option>
                                    <option value="SAID">SAID</option>
                                    <option value="IID">IID</option>
                                    <option value="SAICE">SAICE</option>
                                    <option value="ACHASM">ACHASM</option>
                                    <option value="ACEN">ACEN</option>
                                    <option value="OTHER">OTHER</option>
                                    <option value="NONE">NONE</option>
                                </select>
                            </td>
                        </tr>

<?php
                        if ($bDietaryReq) {
                        ?>
                            <tr>
                                <td colspan="4" valign=top>Dietary restrictions / allergies:
                                    <input name="DietaryReq<?php echo $i; ?>" type="text" size="80" value="<?php echo stripslashes($_POST["DietaryReq" . $i] . ""); ?>">
                                </td>
                            </tr>
                        <?php
                        }
                        $sql = "SELECT SchoolCostPackageOptions.`CostPackageOptionID`, EventID, OptionName, OptionDesc, AddCost, DisplayOrder
FROM SchoolEvents JOIN SchoolCostPackages ON (SchoolEvents.`CostPackage`=SchoolCostPackages.`CostPackageID`)
JOIN SchoolCostPackageOptions ON (SchoolCostPackages.`CostPackageID`=SchoolCostPackageOptions.`PackageID`)
WHERE SchoolEvents.EventID=" . $id . " ORDER BY SchoolCostPackageOptions.DisplayOrder";
                        $recCO = mysql_query($sql);
                        if (mysql_num_rows($recCO) > 0) {
                        ?>
                            <tr>
                                <td>Select an option:</td>
                                <td colspan="3">
                                    <table border="1" cellspacing="0" cellpadding="2">
                                        <?php
                                        while ($rowCO = mysql_fetch_assoc($recCO)) {
                                        ?>
                                            <tr>
                                                <td><input type="radio" name="PackageChosen<?php echo $i; ?>" value="<?php echo $rowCO["OptionName"]; ?>" <?php if (($_POST["PackageChosen" . $i] == $rowCO["OptionName"]) || (!isset($_POST["PackageChosen" . $i]) && ($rowCO["DisplayOrder"] == 1))) echo " checked"; ?>><?php echo $rowCO["OptionName"]; ?></td>
                                                <td><b><?php echo "R " . number_format($row["CostPerPerson"] + $rowCO["AddCost"], 2, ".", " "); ?>&nbsp;excl. VAT<br />
                                                        <?php echo "R " . number_format(ceil(($row["CostPerPerson"] + $rowCO["AddCost"]) * $incvat), 2, ".", " "); ?>&nbsp;incl. VAT<br /></b>
                                                    <i><?php echo nl2br($rowCO["OptionDesc"]); ?></i>
                                                </td>
                                            </tr>
                                        <?php
                                        }
                                        ?>
                                    </table>
                                </td>
                            </tr>
                        <?php
                        }
                        if ($row["Venue"] == "CESA Training Centre") {
                        ?>
                            <tr>
                                <td>Do you require parking?</td>
                                <td colspan="3">
                                    <input type="radio" name="Parking<?php echo $i; ?>" value="1" <?php if ($_POST["Parking" . $i] == 1) echo " checked"; ?>> Yes<br>
                                    <input type="radio" name="Parking<?php echo $i; ?>" value="0" <?php if ($_POST["Parking" . $i] == 0) echo " checked"; ?>> No
                                </td>
                            </tr>
                        <?php
                        }
                        ?>
                    </table>
                    <?php
                    if ($id == 187) {
                        $showform = true;
                        include("inc_gama.php");
                    }
                    ?>
                    <?php
                    if ($i > 1) {
                    ?>
                        <p align="center"><input type="button" onclick="javascript:document.getElementById('candidate<?php echo $i; ?>').style.display = 'none';
                                                    document.getElementById('DivDisplayed<?php echo $i; ?>').value = '0'" value="Remove This Attendee">
                        <?php
                    }
                        ?>
                        <?php
                        if ($i < 10) {
                        ?>
                        <p align="center"><input type="button" onclick="javascript:document.getElementById('candidate<?php echo $i + 1; ?>').style.display = '';
                                                    document.getElementById('DivDisplayed<?php echo $i + 1; ?>').value = '1'" value="Add Another Attendee">
                        <?php
                        }
                        ?>
                        </div>
                    <?php
                }
                    ?>
                        <div align="left">
                            <?php
                            if ($bDietaryReq) {
                            ?>
                                <p><strong style='color:red'>NB! Did you remember to fill-in your / the attendees' dietary restrictions? i.e. Halaal / Kosher / Strictly Halaal / Vegetarian</strong></p>
                            <?php
                            }
                            ?>
                            <p>Where did you hear about us? <span style="color:red">*</span> <select name="MarketingSource" id="MarketingSource" required>
                                    <option value="">Please select (required)</option>
                                    <option value="Internet search">Internet search</option>
                                    <option value="CESA website">CESA website</option>
                                    <option value="Promotional email received">Promotional email received</option>
                                    <option value="CESA newsletter">CESA newsletter</option>
                                    <option value="I work at a CESA member firm">I work at a CESA member firm</option>
                                    <option value="I have previously attended courses">I have previously attended courses</option>
                                    <option value="Facebook">Facebook</option>
                                    <option value="LinkedIn">LinkedIn</option>
                                    <option value="Twitter">Twitter</option>
                                    <option value="Word of mouth">Word of mouth</option>
                                    <option value="Other">Other</option>
                                </select>
                            </p>
                            <p id="MarketingSourceOther" style="display:none;">
                                <input type="text" name="MarketingSourceOther" id="MarketingSourceOther" value="<?php echo $_POST["MarketingSourceOther"]; ?>" placeholder="Please specify">
                            </p>

<h3 style='color:red;'>Terms and Conditions:</h3>
                            <p>
                            <ol><?php
                                if ($row["PilotCourse"] <= 0) {
                                ?>
                                    <li>Full payment (i.e. received proof of payment) is required before the start of the course, seminar, webinar, workshop (event).
                                        <ul>
                                            <li>Non- payment or non-attendance does not constitute cancellation.</li>
                                            <li>No show (without prior notice) will be charged the full registration fee.</li>
                                            <li>Substitution is allowed.</li>
                                            <li>Cancellations and refunds will only be accepted in writing, 3 working days
                                                prior to the training date. Cancellations on the day of the course may result
                                                in the forfeiture of the event fee.</li>
                                        </ul>
                                    </li><?php
                                        }
                                            ?>
                                <li>CESA NPC's School of Consulting Engineering (SCE) reserves the right to refuse participants
                                    entry into the event, change the event programme, postpone, or cancel an
                                    event, due to unforeseen circumstances, including without limitation, any fortuitous event,
                                    Act of God, unforeseen occurrence or any other event that renders
                                    performance of the event impracticable or impossible.</li>
                                <li>Strict online protocols will be adhered to at all times during the event.</li>
                                <li>At the end of the event, the delegate will be required to complete an online quiz. This
                                    quiz is a multiple choice quiz, in which the participant must score at least 60%, before
                                    receiving their CPD attendance certificate.</li>
                                <li>The participants will only receive their CPD attendance certificate, once the participant has passed
                                    their online quiz<?php

if ($row["PilotCourse"] <= 0) {
                                                        ?>, completed an online event evaluation form, and payment has been received in full by the SCE<?php
                                                                                                                                                    } else {
                                                                                                                                                        ?> and completed an online event evaluation form<?php
                                                                                                                                                                                                    }
                                                                                                                                                                                                        ?>.</li>
                                <li>The online link (the link to join the course) will be sent to the participant in the confirmation email.
                                    It is the responsibility of the participant to let the SCE know if
                                    they have not received the online link to the event prior to the event</li>
                                <li>Our events are conducted via Zoom or Ms Teams, kindly let us know if there are any restrictions from your
                                    organisation, pertaining to the use of these platforms.</li>
                            </ol>
                            </span></i></p>

<p>
                                <input type="checkbox" name="checkTCs" id="checkTCs" value="1" required>
                                <label for="checkbox">I accept the terms and conditions as stated above</label>
                            </p>

<?php
                            if ($row["PilotCourse"] <= 0) {
                            ?>
                                <p>
                                    <input type="checkbox" name="checkPerm" id="checkPerm" value="1" required>
                                    I confirm that the training has been approved, and I fully commit to ensuring that the
                                    PAYMENT WILL BE MADE IN FULL BEFORE THE TRAINING BEGINS.
                                </p><?php
                                } else {
                                    ?>
                                <input type="hidden" name="checkPerm" id="checkPerm" value="1">
                            <?php
                                }
                            ?>
                            <p>
                                <input type="checkbox" name="subscribe" value="Y" checked="checked"> I confirm my approval to
                                be added to the mailing list and look forward to receiving updates and communications.
                                <i>You can unsubscribe at any time.</i>
                            </p>
                            <div class="g-recaptcha" data-sitekey="6LcoIWUrAAAAAKBLHpjS7GyroBey9G6yhilbpyNa"></div>
                            <p>
                                <input type="submit" value="Submit to CESA"
                                    style="background-color:red;color:white;font-style:bold;width:150px;height:50px"
                                    name="formsubmit" id="formsubmit" onclick="return formCheck(document.getElementById('form1'));">
                                Please click only ONCE. A confirmation will be sent to your email address.
                            </p>

</div>
            </form>
<?php
            $sBankAccName = "SAACE";
            if (!empty($row["BankAccName"]))
                $sBankAccName = $row["BankAccName"];
            $sqlbank = "SELECT * FROM SchoolBankAccs WHERE BankAccName = '" . $sBankAccName . "'";
            $recbank = mysql_query($sqlbank);
            if ($rowbank = mysql_fetch_assoc($recbank)) {
                extract($rowbank);
            }
        }
    }
} else {
    echo "Event not found.";
}

include_once($_SERVER['DOCUMENT_ROOT'] . "/php/templates/inc_footer.php");

?>
</table>
<script language="JavaScript" type="text/javascript">
    function Orgcallback(oInfo) {
        document.getElementById('Organisation').value = oInfo.id;
    }

function MarketingSourceOther() {
        if (document.getElementById('MarketingSource').value === 'Other') {
            document.getElementById('MarketingSourceOther').style.display = 'block';
        } else {
            document.getElementById('MarketingSourceOther').style.display = 'none';
        }
    }

sScriptPrefix = "/autosuggest/organisation.php?r=<?php echo rand(1, 9999999); ?>&";
    var options1 = {
        script: sScriptPrefix,
        varname: "Input",
        delay: 0,
        timeout: 10000,
        shownoresults: false,
        minchars: 3,
        maxheight: 250,
        callback: Orgcallback
    };
    var as1 = new AutoSuggest('Organisation', options1);

document.getElementById('MarketingSource').addEventListener('change', MarketingSourceOther);
</script>