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

<html>

<head>
	<style>
		body,
		p,
		td,
		th {
			font: 12px/170% Verdana, sans-serif;
		}
	</style>
</head>

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

mysql_select_db($dbname, $db);

$sql = "SELECT SchoolEvents.EventID, SchoolEvents.EventName, SchoolEvents.City,	SchoolEvents.CostPerPerson, 
			SchoolEvents.AccredNum, SchoolEvents.CPD, SchoolEvents.Cancelled, SchoolEvents.Venue, 
			CourseVenues.CourseVenueCity, MIN(EventSchedules.ScheduleDate) AS StartDate, 
			MAX(EventSchedules.ScheduleDate) AS EndDate
		FROM (SchoolEvents 
		LEFT JOIN CourseVenues ON SchoolEvents.Venue = CourseVenues.CourseVenueName)
		LEFT JOIN EventSchedules ON SchoolEvents.EventID=EventSchedules.EventID
		LEFT JOIN SchoolWebCategories ON (SchoolEvents.WebCategory=SchoolWebCategories.WebCategoryID)
		WHERE Cancelled = 0 AND (SchoolWebCategories.DisplayOrder IS NULL OR SchoolWebCategories.DisplayOrder > 0)
		GROUP BY SchoolEvents.EventID, SchoolEvents.EventName, SchoolEvents.City, SchoolEvents.CostPerPerson, 
			SchoolEvents.AccredNum, SchoolEvents.CPD, SchoolEvents.Cancelled, SchoolEvents.Venue, 
			CourseVenues.CourseVenueCity
		HAVING StartDate >= '2020-06-01'
		ORDER BY EventName, Cancelled, AccredNum, CPD, StartDate";

$queryresultall = mysql_query($sql) or die(mysql_error() . " " . $sql);

while ($rowall = mysql_fetch_array($queryresultall)) {

$id = intval($rowall["EventID"]);

$sql = "SELECT SchoolEvents.EventID, SchoolEvents.EventName, SchoolEvents.Level, SchoolEvents.City, SchoolEvents.Venue, SchoolEvents.StartTime, 
					SchoolEvents.EndTime, 
					SchoolEvents.AvailableSpaces, SchoolEvents.CostPerPerson, SchoolEvents.EventDescription, SchoolFacilitators.FacilitatorName, 
					SchoolFacilitators.PhoneNumber, SchoolFacilitators.MobileNumber, SchoolFacilitators.FaxNumber, SchoolFacilitators.EmailAddress, 
					SchoolProviders.ProviderName, SchoolProviders.PhoneNumber, SchoolProviders.MobileNumber, SchoolProviders.FaxNumber, 
					SchoolProviders.EmailAddress, 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,
					CourseVenues.CourseVenueCity, CourseVenues.CourseVenueArea, SchoolEvents.ProviderID,
					SchoolEvents.SACPCMPNum, SchoolEvents.SACPCMPCategory, SchoolEvents.SACPCMP_CPDPoints
				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;

// echo 'Please ignore debug info: ' . $sql . '<br />';

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

//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;
			}
	?>
			<center>
				<h3><? echo $eventname; ?></h3>
			</center>
			<table border=0 width=100% cellspacing=5 cellpadding=5>
				<tr>
					<td valign=top colspan="2">
						<? 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>Fee:</b></td>
						<td>
							<?php
							$sql = "SELECT SELECT SchoolCostPackageOptions.`CostPackageOptionID`, EventID, StartDate, 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);

$courseStartDate = new DateTime($row["StartDate"]);

if (mysql_num_rows($recCO) == 0) {
							?>
								<b><? echo "R " . number_format($row["CostPerPerson"], 2, ".", " "); ?>&nbsp;excl. VAT<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
									
									$numRows = mysql_num_rows($recCO);

while ($rowCO = mysql_fetch_assoc($recCO)) {
										$courseStartDate = new DateTime($rowCO["StartDate"]);
									?>
										<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 class="fee-display">CESA <?php if ($row["ProviderID"] == 155) echo "/ SAICE "; ?>member fee:
										R<?php echo number_format($row["CostPerPerson"] - $row["MemberDiscount"], 2, ".", " "); ?> excl. VAT</b></i><br />
							<?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>CESA Validation Num:</b></td>
						<td><? echo $row["AccredNum"]; ?></td>
					</tr>
					<tr>
						<td valign=top><b>CPD Points:</b></td>
						<td><? echo $row["CPD"]; ?></td>
					</tr>
					<?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 $row["SACPCMP_CPDPoints"]; ?></td>
						</tr>
						<?php
					}
					
					if (!empty($row["SACNASP_ValidationNumber"])) {
						?>
							<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 $row["SACNASP_CPD_Points"]; ?></td>
							</tr>
						<?php
					}
				?>
			</table>
			<hr style="page-break-after:always">
<?php
				}
			}
		}

mysql_close();

?>
</body>

</html>