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);

if ($id == 375) {
    header("Location: https://www.cesa.co.za/cesaway/index.htm");
    die();
}

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

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

mysql_select_db($dbname, $db);

$schoolEventObj = new SchoolEvents($sqlf);

if (isset($_GET["id"]) && !empty($_GET["id"])) {
    $sql = "SELECT SchoolCourseID FROM SchoolEvents WHERE EventID=" . intval($_GET["id"]);
    $queryresult = mysql_query($sql) or die();
    if ($row = mysql_fetch_array($queryresult)) {
        $courseid = $row["SchoolCourseID"];
    }
}
if (isset($_GET["courseid"]) && !empty($_GET["courseid"])) {
    $courseid = intval($_GET["courseid"]);
}

if (isset($courseid) && !empty($courseid)) {
    $sql = "SELECT SchoolCourses.*, SchoolFacilitators.FacilitatorName 
        FROM SchoolCourses LEFT JOIN SchoolFacilitators USING (FacilitatorID) WHERE SchoolCourseID=" . $courseid;
} else {
    $sql = "SELECT SchoolEvents.*, SchoolFacilitators.FacilitatorName, '' AS DescOverview, '' AS DescWhyAttend, '' AS DescOutcomes, '' AS DescObjectives, '' AS DescProgram, '' AS CourseDescription "
        . "FROM SchoolEvents LEFT JOIN SchoolFacilitators USING (FacilitatorID) WHERE EventID=" . intval($_GET["id"]);
}

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

//odbc_longreadlen($queryresult, 16384);

if ($row = mysql_fetch_array($queryresult)) {
    if (isset($row["CourseName"])) {
        $eventname = $row["CourseName"];
    } else {
        $eventname = $row["EventName"];
    }
    $pagetitle = "SCE Course: " . $eventname;
?>
    <table width="98%" cellspacing="0" cellpadding="4" align="center">
        <tr>
            <td align="right" style="text-align:right !important;">
                <b><a href="/sce/school-of-consulting-engineers/cpd-training/training-calendar/">&lt;&lt; Return to Calendar</a></b>
            </td>
        </tr>
        <tr>
            <td>

<center>
                    <h3 style="font-size: 28px !important;"><?php echo $eventname; ?></h3>
                </center>
                <?php
                $scheduleDebugEnabled = false;
                if (isset($_GET['debug'])) {
                    $debugVal = strtolower(trim((string) $_GET['debug']));
                    $scheduleDebugEnabled = in_array($debugVal, array('1', 'true', 'yes', 'on'), true);
                }

$upcoming = $schoolEventObj->getUpcomingEventsForCoursePage(
                    isset($courseid) ? $courseid : null,
                    $eventname,
                    isset($row['AccredNum']) ? $row['AccredNum'] : null,
                    isset($row['CPD']) ? $row['CPD'] : null
                );
                $upcomingEvents = isset($upcoming['events']) && is_array($upcoming['events']) ? $upcoming['events'] : array();
                $scheduleDebug = isset($upcoming['debug']) && is_array($upcoming['debug']) ? $upcoming['debug'] : array();

$sScheduleHTML = "<table border=1>";
                $scheduleEventCount = 0;
                $hasAccreddNum = false;
                $hasSACPCMP = false;
                $hasSACNASP = false;

if (!empty($scheduleDebug['sql'])) {
                    echo '';
                }

foreach ($upcomingEvents as $rowAll) {
                    $accredNum = $rowAll['AccredNum'];
                    $sacpcmpNum = $rowAll['SACPCMPNum'];
                    $sacpcmpCategory = $rowAll['SACPCMPCategory'];
                    $sacpcmpCpdPoints = $rowAll['SACPCMP_CPDPoints'];

$bEventInPast = true;
                    $DateList = "";
                    $dates = array();
                    $scheduleDays = isset($rowAll['_schedule_days']) && is_array($rowAll['_schedule_days'])
                        ? $rowAll['_schedule_days']
                        : array();

foreach ($scheduleDays as $row2) {
                        $dedupeKey = strtotime($row2["ScheduleDate"]) . "_" . substr($row2["StartTime"], 0, 5) . "_" . substr($row2["EndTime"], 0, 5);
                        if (in_array($dedupeKey, $dates)) {
                            continue;
                        }

$StartDatePlusTime = date("Y-m-d", strtotime($row2["ScheduleDate"])) . " " . date("H:i:s", strtotime($row2["StartTime"]));
                        $DateList .= "<li>" . date("D j F Y", strtotime($row2["ScheduleDate"])) . "&nbsp;&nbsp;" . substr($row2["StartTime"], 0, 5) . " to " . substr($row2["EndTime"], 0, 5) . "<BR></li>";
                        if (strtotime($StartDatePlusTime) > time()) {
                            $bEventInPast = false;
                        }

$dates[] = $dedupeKey;
                    }

if (empty($DateList)) {
                        continue;
                    }

$scheduleEventCount++;
                    $venueLine = $rowAll['Venue'];

if (!empty($rowAll["City"]) && strlen($rowAll["City"]) > 0) {
                        $venueLine .= ", " . $rowAll["City"];
                    } elseif (!empty($rowAll["CourseVenueCity"]) && strlen($rowAll["CourseVenueCity"]) > 0) {
                        $venueLine .= ", " . $rowAll["CourseVenueCity"];
                    }

$sScheduleHTML .= "<tr><td><ul><li>" . $venueLine;

if (!empty($rowAll["CourseVenueArea"])) {
                        $sScheduleHTML .= ", " . $rowAll["CourseVenueArea"];
                    }

$sScheduleHTML .= "</li>";

if (!empty($rowAll["Level"]) && $rowAll['Level'] != $rowAll['Venue']) {
                        $sScheduleHTML .= '<li>Type: ' . $rowAll["Level"] . '</li>';
                    }

$sScheduleHTML .= $DateList;

if ($accredNum != '') {
                        $hasAccreddNum = true;
                        $sScheduleHTML .= '<li>Validation Number: ' . $rowAll['AccredNum'] . '</li>';
                    }

if (!empty($rowAll["CPD"])) {
                        $sScheduleHTML .= '<li>ECSA CPD Points: ' . number_format(floatval($rowAll["CPD"]), 2) . '</li>';
                    }

if ($sacpcmpNum != '') {
                        $hasSACPCMP = true;
                        $sScheduleHTML .= '<li>SACPCMP Num: ' . $sacpcmpNum . '</li>';
                        $sScheduleHTML .= '<li>SACPCMP Category: ' . $sacpcmpCategory . '</li>';
                        $sScheduleHTML .= '<li>SACPCMP CPD Points: ' . number_format(floatval($sacpcmpCpdPoints), 2) . '</li>';
                    }

if (!empty($rowAll["SACNASP_ValidationNumber"])) {
                        $hasSACNASP = true;
                        $sScheduleHTML .= '<li>SACNASP Validation Number: ' . $rowAll["SACNASP_ValidationNumber"] . '</li>';
                        $sScheduleHTML .= '<li>SACNASP CPD Points: ' . number_format(floatval($rowAll["SACNASP_CPD_Points"]), 2) . '</li>';
                    }

$sScheduleHTML .= "</ul>";

if (isset($row["EventID"]) && ($handle = @opendir('../school/eventdocs'))) {
                        while (false !== ($file = readdir($handle))) {
                            if ($file != "." && $file != "..") {
                                $tofind = "." . $row["EventID"];
                                $pos = strpos($file, $tofind);
                                if ($pos > 0) {
                                    $handle2 = @opendir('./eventdocs/' . $file);
                                    $files = '';
                                    if ($handle2) {
                                        while (false !== ($file2 = readdir($handle2))) {
                                            if (substr($file2, 0, 1) != ".") {
                                                $files .= '<a href="/school/eventdocs/' . $file . '/' . $file2 . '" target="_blank">' . $file2 . '</a><br>';
                                            }
                                        }
                                        closedir($handle2);
                                    }
                                    $sScheduleHTML .= '<br><i>Directions / Map:</i><br>' . $files;
                                }
                            }
                        }
                        closedir($handle);
                    }

$sScheduleHTML .= "</td><td>";
                    if (!$bEventInPast && ($rowAll["Cancelled"] == 0)) {
                        $sScheduleHTML .= '<a href="/sce/school-event-registration?id=' . $rowAll["EventID"] . '"><img src="/images/schoolreg.jpg" width=132 height=89 border=0></a>';
                    }
                    if ($rowAll["Cancelled"] == 1) {
                        $sScheduleHTML .= "<b>This event has been cancelled</b>";
                    }
                    $sScheduleHTML .= "</td></tr>";
                }

$sScheduleHTML .= "</table>";

if ($scheduleEventCount <= 0) {
                    $sScheduleHTML = '<p><b>No upcoming schedules were found for this course.</b></p>';

$cancelledFuture = isset($scheduleDebug['cancelled_future_events']) && is_array($scheduleDebug['cancelled_future_events'])
                        ? $scheduleDebug['cancelled_future_events']
                        : array();
                    if (count($cancelledFuture) > 0) {
                        $sScheduleHTML .= '<p><i>Note: '
                            . count($cancelledFuture)
                            . ' future event(s) exist but are marked Cancelled, so they are not shown on the public schedule list. '
                            . 'Set Cancelled = No on the School Event if it should appear.</i></p>';
                    }

$linkedSql = isset($scheduleDebug['linked_events_sql']) ? (string) $scheduleDebug['linked_events_sql'] : '';
                    $filterSql = isset($scheduleDebug['sql']) ? (string) $scheduleDebug['sql'] : '';

$sScheduleHTML .= '<div class="sce-schedule-sql" style="margin-top:10px;padding:10px;border:1px solid #ccc;background:#fafafa;font:12px/1.4 monospace;white-space:pre-wrap;">'
                        . '<b>SQL to check events linked to this course:</b>' . "\n"
                        . htmlspecialchars($linkedSql !== '' ? $linkedSql : '(not available)') . "\n\n"
                        . '<b>SQL used for upcoming (non-cancelled) candidates:</b>' . "\n"
                        . htmlspecialchars($filterSql !== '' ? $filterSql : '(not available)')
                        . '</div>';
                }

if ($scheduleDebugEnabled) {
                    $sScheduleHTML .= '<div class="sce-schedule-debug" style="margin-top:12px;padding:10px;border:1px solid #999;background:#f7f7f7;font:12px/1.4 monospace;white-space:pre-wrap;">'
                        . '<b>Schedule debug (?debug=1)</b>' . "\n"
                        . htmlspecialchars(print_r($scheduleDebug, true))
                        . '</div>';
                }

?>
                <table border=0 width=100% cellspacing=5 cellpadding=5>
                    <tr>
                        <td valign=top colspan="2"><?php
                                                    //echo $row["EventDescription"];
                                                    if (!empty($row["DescOverview"]) || !empty($row["DescWhyAttend"]) || !empty($row["DescOutcomes"]) || !empty($row["DescProgram"]) || !empty($row["DescWhoAttend"])) {
                                                    ?>
                                <?php if (!empty(strip_tags(trim(str_replace("&nbsp;", "", $row["DescOverview"]))))) {
                                ?><h2><u>Overview</u></h2><?php echo stripInlineStyleTags($row["DescOverview"]); ?><?php
                                                                                                                } ?>
                                    <?php if (!empty(strip_tags(trim(str_replace("&nbsp;", "", $row["DescWhyAttend"]))))) {
                                    ?><h2><u>Why Should an Individual Attend?</u></h2><?php echo stripInlineStyleTags($row["DescWhyAttend"]); ?><?php } ?>
                                        <?php if (!empty(strip_tags(trim(str_replace("&nbsp;", "", $row["DescOutcomes"]))))) { ?><h2><u>Outcomes</u></h2><?php echo stripInlineStyleTags($row["DescOutcomes"]); ?><?php } ?>
                                            <?php if (!empty(strip_tags(trim(str_replace("&nbsp;", "", $row["DescProgram"]))))) { ?><h2><u>Program Outline</u></h2><?php echo stripInlineStyleTags($row["DescProgram"]); ?><?php } ?>
                                                <?php if (!empty(strip_tags(trim(str_replace("&nbsp;", "", $row["DescWhoAttend"]))))) { ?><h2><u>Who Should Attend?</u></h2><?php echo stripInlineStyleTags($row["DescWhoAttend"]); ?><?php } ?>
                                                <?php
                                                    } elseif (!empty(strip_tags(trim(str_replace("&nbsp;", "", $row["CourseDescription"]))))) {
                                                        echo stripInlineStyleTags($row["CourseDescription"]);
                                                    } else {
                                                        echo stripInlineStyleTags($row["EventDescription"]);
                                                    }
                                                ?></td>
                    </tr>
                    
                    <?php
                    if (!$hasAccreddNum) {
                    ?>
                        <tr>
                            <td valign=top><b>Validation Number/s:</b></td>
                            <td><?php
                                echo $row["AccredNum"];
                                if (!empty($row["AccredNum2"]))
                                    echo "<br>" . $row["AccredNum2"];
                                ?>
                            </td>
                        </tr>
                    <?php
                    }
                    ?>
                    
                    <?php if (!empty($row["FacilitatorName"])) { ?>
                        <tr>
                            <td><b>Coordinator:</b></td>
                            <td><?php echo $row["FacilitatorName"]; ?></td>
                        </tr>
                        
                        <tr>
                            <td valign=top><b>Fee:</b></td>
                            <td><?php

$eventOptionRows = $schoolEventObj->getEventCostOptions($row);
                                ?>
                                <table border="1" cellspacing="0" cellpadding="2">
                                    <?php
                                    foreach ($eventOptionRows as $rowCO) {
                                        if (!empty($rowCO["CostPerPerson"]) && $rowCO["CostPerPerson"] > 0) {
                                            $courseStartDate = new DateTime($rowCO["StartDate"]);
                                    ?>
                                            <tr><?php if (!empty($rowCO["OptionName"])) { ?><td><?php echo $rowCO["OptionName"]; ?></td><?php } ?><td>
                                                <?php
                                                if (count($eventOptionRows) > 1) {
                                                    echo '<h6>From '. $courseStartDate->format('j F Y') . '</h6>';
                                                }
                                                ?>
                                                    <b><?php echo "R " . number_format($rowCO["CostPerPerson"] + floatval($rowCO["AddCost"]), 2, ".", " "); ?>&nbsp;excl. VAT<br />
                                                        <?php echo "R " . number_format(ceil(($rowCO["CostPerPerson"] + floatval($rowCO["AddCost"])) * $incvat), 2, ".", " "); ?>&nbsp;incl. VAT<br /></b>
                                                    <i><?php echo nl2br($rowCO["OptionDesc"]); ?></i>
                                                </td>
                                        <?php
                                        }
                                    } //while
                                        ?>
                                </table>
                                <?php

if (is_array($eventOptionRows) && count($eventOptionRows) > 0) {
                                    $rowCO = $eventOptionRows[0];
                                    if (!empty($rowCO["CostPerPerson"]) && !empty($rowCO["MemberDiscount"]) && ($rowCO["MemberDiscount"] > 0)) {
                                ?>
                                        <i><b>CESA <?php if ($row["ProviderID"] == 155) echo "/ SAICE "; ?>member fee:
                                                R<?php echo number_format(($rowCO["CostPerPerson"] - $rowCO["MemberDiscount"]), 2, ".", " "); ?> excl. VAT</b></i><br />
                                        <i><b>CESA <?php if ($row["ProviderID"] == 155) echo "/ SAICE "; ?>member fee:
                                                R<?php echo number_format(ceil(($rowCO["CostPerPerson"] - $rowCO["MemberDiscount"]) * $incvat), 2, ".", " "); ?> incl. VAT</b></i><br />
                                <?php
                                    }
                                }
                                ?>
                            </td>
                        </tr>
                        <tr>
                            <td valign=top><b>Schedules:</b></td>
                            <td>
                                <?php echo $sScheduleHTML; ?>
                            </td>
                        </tr>
                </table>
            </td>
        </tr>
    </table>
<?php
} else {
    $pagetitle = "SCE Error";

echo "Event not found.";
}

// mysql_close();

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