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
if ($id == 375) {
	header("Location: https://www.cesa.co.za/cesaway/index.htm");
	die();
}

include('inc_db.php');
$db = mysql_connect($loghost, $logid, $logpwd);

mysql_select_db($dbname, $db);

$id = intval($_GET["id"]);

if (!empty($id)) {
	$sql = "SELECT 
  SchoolEvents.`EventID`,
  IF(ISNULL(SchoolCourses.CourseName),SchoolEvents.`EventName`,SchoolCourses.CourseName) AS EventName,
  IF(ISNULL(SchoolCourses.`Level`),SchoolEvents.`Level`,SchoolCourses.`Level`) AS `Level`,
  SchoolEvents.`City`,  SchoolEvents.`Venue`,  SchoolEvents.`StartDate`,  SchoolEvents.`EndDate`,
  SchoolEvents.`StartTime`,  SchoolEvents.`EndTime`,  SchoolEvents.`AvailableSpaces`,
  SchoolEvents.`CostPerPerson`,  SchoolEvents.`EventDescription`,
  IF(ISNULL(SchoolCourses.`FacilitatorID`),SchoolEvents.`FacilitatorID`,SchoolCourses.`FacilitatorID`) AS `FacilitatorID`,
  IF(ISNULL(SchoolCourses.`ProviderID`),SchoolEvents.`ProviderID`,SchoolCourses.`ProviderID`) AS `ProviderID`,
  SchoolEvents.`PresenterID`,
  IF(ISNULL(SchoolCourses.`Hours`),SchoolEvents.`Hours`,SchoolCourses.`Hours`) AS `Hours`,
  SchoolEvents.`Hours` AS `EventHours`,
  IF(ISNULL(SchoolCourses.`CPD`),SchoolEvents.`CPD`,SchoolCourses.`CPD`) AS `CPD`,
  SchoolEvents.`CODE`,
  IF(ISNULL(SchoolCourses.`NQFLevel`),SchoolEvents.`NQFLevel`,SchoolCourses.`NQFLevel`) AS `NQFLevel`,
  IF(ISNULL(SchoolCourses.`AccredNum`),SchoolEvents.`AccredNum`,SchoolCourses.`AccredNum`) AS `AccredNum`,
  SchoolEvents.`Province`,  SchoolEvents.`RegDeadline`,
  IF(ISNULL(SchoolCourses.`Category`),SchoolEvents.`Category`,SchoolCourses.`Category`) AS `Category`,
  SchoolEvents.`Onceoff`,  SchoolEvents.`OnceoffSeq`,
  SchoolEvents.`MemberDiscount`,  SchoolEvents.`EarlyBirdDiscount`,  SchoolEvents.`EarlyBirdDate`,  SchoolEvents.`Cancelled`,
  SchoolEvents.`BankAccName`,  SchoolEvents.`ExternalLink`,  SchoolEvents.`SchoolCourseID`,
  IF(ISNULL(SchoolCourses.`FileAttachment`),SchoolEvents.`FileAttachment`,SchoolCourses.`FileAttachment`) AS `FileAttachment`,
  IF(ISNULL(SchoolCourses.`WebCategory`),SchoolEvents.`WebCategory`,SchoolCourses.`WebCategory`) AS `WebCategory`,
  SchoolEvents.`CandidateAcademy`,  SchoolEvents.`BookingConfirmed`,  SchoolEvents.`AttendanceRegister`,
  IF(ISNULL(SchoolCourses.`SACPCMPNum`),SchoolEvents.`SACPCMPNum`,SchoolCourses.`SACPCMPNum`) AS `SACPCMPNum`,
  SchoolEvents.`SACPCMP_CPDPoints`, SchoolEvents.`SACPCMPCategory`,
  IF(ISNULL(SchoolCourses.`AccredNum2`),SchoolEvents.`AccredNum2`,SchoolCourses.`AccredNum2`) AS `AccredNum2`,
  SchoolEvents.`CostPackage`,  SchoolEvents.`ContactPerson`,  SchoolEvents.`ContactTel`,  SchoolEvents.`ContactEmail`,
  IF(ISNULL(SchoolCourses.`CourseType`),SchoolEvents.`CourseType`,SchoolCourses.`CourseType`) AS `CourseType`,
  SchoolEvents.`OnlineCourseLink`,  CourseVenues.CourseVenueCity, CourseVenues.CourseVenueArea,
	SchoolCourses.DescOverview, SchoolCourses.DescWhyAttend, SchoolCourses.DescOutcomes, 
	SchoolCourses.DescObjectives, SchoolCourses.DescProgram, SchoolCourses.DescWhoAttend, SchoolCourses.CourseDescription,
	SchoolEvents.`SACNASP_ValidationNumber`, SchoolEvents.`SACNASP_CPD_Points`
	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
		LEFT JOIN SchoolCourses ON (SchoolEvents.SchoolCourseID=SchoolCourses.SchoolCourseID)
	WHERE SchoolEvents.EventID=" . $id;

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

//odbc_longreadlen($queryresult, 16384);

if ($row = mysql_fetch_array($queryresult)) {
		$eventname = $row["EventName"];
		$pagetitle = "SCE Event: " . $eventname;

$bEventInPast = true;
		$DateList = "";

$sql2 = "SELECT * FROM EventSchedules WHERE EventID=" . $id . " ORDER BY ScheduleDate";
		$queryresult2 = mysql_query($sql2);
		while ($row2 = mysql_fetch_array($queryresult2)) {
			$StartDatePlusTime = date("Y-m-d", strtotime($row2["ScheduleDate"])) . " " . date("H:i:s", strtotime(substr($row2["StartTime"], 11, 5)));
			// echo $StartDatePlusTime;
			$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;
		}
?>
		<p align="right"><b><a href="/sce/school-of-consulting-engineers/cpd-training/training-calendar/">&lt;&lt; Return to Calendar</a></b></p>
		<center>
			<h3><? echo $eventname; ?></h3>
		</center>
		<table border=0 width=100% cellspacing=5 cellpadding=5>
			<tr>
				<td valign=top colspan="2">
					<?php
					if (!$bEventInPast && ($row["Cancelled"] == 0)) {
					?>
						<a href="/sce/school-event-registration?id=<? echo $id; ?>"><img src="/images/schoolreg.jpg" width=132 height=89 border=0></a>
					<?php
					}
					?>
					<?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 $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 $row["DescWhyAttend"]; ?><?php } ?>
								<?php if (!empty(strip_tags(trim(str_replace("&nbsp;", "", $row["DescOutcomes"]))))) { ?><h2><u>Outcomes</u></h2><?php echo $row["DescOutcomes"]; ?><?php } ?>
									<?php if (!empty(strip_tags(trim(str_replace("&nbsp;", "", $row["DescProgram"]))))) { ?><h2><u>Program Outline</u></h2><?php echo $row["DescProgram"]; ?><?php } ?>
										<?php if (!empty(strip_tags(trim(str_replace("&nbsp;", "", $row["DescWhoAttend"]))))) { ?><h2><u>Who Should Attend?</u></h2><?php echo $row["DescWhoAttend"]; ?><?php } ?>
										<?php
									} elseif (!empty(strip_tags(trim(str_replace("&nbsp;", "", $row["CourseDescription"]))))) {
										echo $row["CourseDescription"];
									} else {
										echo $row["EventDescription"];
									}
										?>
				</td>
			</tr>
			<?php
			if ($row["Cancelled"] == 1) {
				echo "</table><p><b>This event has been cancelled</b></p>";
			} else {
			?>
				<tr>
					<td valign=top><b>Dates and Times:</b></td>
					<td>
						<ul><? echo $DateList; ?></ul>
					</td>
				</tr>
				<tr>
					<td valign=top><b>Type:</b></td>
					<td><? echo $row["Level"];
						// . ", pitched at NQF " . $row["NQFLevel"]; 
						?></td>
				</tr>
				<tr>
					<td valign=top><b>Venue:</b></td>
					<td><? echo $row["Venue"] . ", " . (empty($row["City"]) ? $row["CourseVenueCity"] : $row["City"]); ?>
						<?php if (!empty($row["CourseVenueArea"])) echo ", " . $row["CourseVenueArea"]; ?>
						<?php
						if ($handle = opendir('./eventdocs')) {
							/* This is the correct way to loop over the directory. */
							while (false !== ($file = readdir($handle))) {
								if ($file != "." && $file != "..") {
									$tofind = "." . $row["EventID"];
									$pos = strpos($file, $tofind);
									if ($pos > 0) {
										$handle2 = opendir('../school/eventdocs/' . $file);
										$files = '';
										while (false !== ($file2 = readdir($handle2))) {
											if (substr($file2, 0, 1) != ".") {
												$files .= '<a href="/school/eventdocs/' . $file . '/' . $file2 . '" target="_blank">' . $file2 . '</a><br>';
											}
										}
										echo '<br><i>Directions / Map:</i><br>' . $files;
										closedir($handle2);
									}
								}
							}

closedir($handle);
						}
						?>
					</td>
				</tr>
				<tr>
					<td valign=top><b>Fee:</b></td>
					<td>
						<?php
						$sql = "SELECT 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=" . $row["EventID"] . " ORDER BY SchoolCostPackageOptions.DisplayOrder";
						$recCO = mysql_query($sql);
						if (mysql_num_rows($recCO) == 0) {
						?>
							<b><? echo "R " . number_format($row["CostPerPerson"], 2, ".", " "); ?>&nbsp;excl. VAT</b><br />
							<? echo "R " . number_format(ceil($row["CostPerPerson"] * $incvat), 2, ".", " "); ?>&nbsp;incl. VAT<br /></b>
						<?php
						} else {
						?>
							<table border="1" cellspacing="0" cellpadding="2">
								<?php
								while ($rowCO = mysql_fetch_assoc($recCO)) {
								?>
									<tr>
										<td><?php echo $rowCO["OptionName"]; ?></td>
										<td>
											<b><? echo "R " . number_format($row["CostPerPerson"] + $rowCO["AddCost"], 2, ".", " "); ?>&nbsp;excl. VAT<br />
												<? echo "R " . number_format(ceil(($row["CostPerPerson"] + $rowCO["AddCost"]) * $incvat), 2, ".", " "); ?>&nbsp;incl. VAT<br /></b>
											<i><?php echo nl2br($rowCO["OptionDesc"]); ?></i>
										</td>
									<?php
								}
									?>
							</table>
						<?php
						}
						if (!empty($row["MemberDiscount"]) && ($row["MemberDiscount"] > 0)) {
						?>
							<i><b>CESA <?php if ($row["ProviderID"] == 155) echo "/ SAICE "; ?>member fee:
									R<?php echo number_format(($row["CostPerPerson"] - $row["MemberDiscount"]), 2, ".", " "); ?> excl. VAT</i><br />
							<i>CESA <?php if ($row["ProviderID"] == 155) echo "/ SAICE "; ?>member fee:
								R<?php echo number_format(ceil(($row["CostPerPerson"] - $row["MemberDiscount"]) * $incvat), 2, ".", " "); ?> incl. VAT</i><br /></b>
						<?php
						}
						//echo strtotime($row["RegDeadline"])."<br>".time()."<br>";
						if (!empty($row["EarlyBirdDiscount"]) && ($row["EarlyBirdDiscount"] > 0) && (strtotime($row["RegDeadline"]) > time())) {
						?>
							<i><b>R<?php echo number_format($row["EarlyBirdDiscount"], 2); ?> discount excl. VAT for registrations received before
									<?php echo date("d M Y", strtotime($row["RegDeadline"])); ?></b></i><br />
						<?php
						}
						?>
					</td>
				</tr>
				<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>
				<tr>
					<td valign=top><b>ECSA CPD Points:</b></td>
					<td><? echo number_format(floatval($row["CPD"]), 2); ?></td>
				</tr>
				<?php
				if (!empty($row["EventHours"]) && floatval($row["EventHours"]) > 0) {
					?>
					<tr>
						<td colspan="2" align="center"><b><? echo intval($row["EventHours"]); ?> PDUs/Hours</b></td>
					</tr>
					<?php
				}
				?>
				<?php
				if (!empty($row["SACPCMPNum"])) {
				?>
					<tr>
						<td valign=top><b>SACPCMP Num:</b></td>
						<td><? echo $row["SACPCMPNum"]; ?></td>
					</tr>
					<tr>
						<td valign=top><b>SACPCMP Category:</b></td>
						<td><? echo $row["SACPCMPCategory"]; ?></td>
					</tr>
					<tr>
						<td valign=top><b>SACPCMP CPD Points:</b></td>
						<td><? echo number_format(floatval($row["SACPCMP_CPDPoints"]), 2); ?></td>
					</tr>
				<?php
				}
				?>
				<tr>
					<td valign=top><b>SACNASP Validation Number:</b></td>
					<td><? echo $row["SACNASP_ValidationNumber"]; ?></td>
				</tr>
				<tr>
					<td valign=top><b>SACNASP CPD Points:</b></td>
					<td><? echo number_format(floatval($row["SACNASP_CPD_Points"]), 2); ?></td>
				</tr>
				<tr>
					<td><b>Coordinator:</b></td>
					<td><? echo $row["FacilitatorName"]; ?></td>
				</tr>
				
		</table>
		<br>
		<?php
				if (!$bEventInPast && ($row["Cancelled"] == 0)) {
		?>
			<a href="/sce/school-event-registration?id=<? echo $id; ?>"><img src="/images/schoolreg.jpg" width=132 height=89 border=0></a>
	<?php
				}
			}
	?>

<?php

} else {
		$pagetitle = "SCE Error";

echo "Event not found.";
	}
} else {
	$pagetitle = "SCE Error";

echo "Event not found.";
}

mysql_close();