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
require("class.phpmailer.php");

function GenPassword() {
 // Password generation 
 $length = 8; // Must be a multiple of 2
 $conso=array("b","c","d","f","g","h","j","k","l", "m","n","p","r","s","t","v","w","x","y","z"); 
 $vocal=array("a","e","i","o","u"); 
 $password=""; 
 srand ((double)microtime()*1000000); 
 $max = $length/2; 
 for($i=1; $i<=$max; $i++) 
 { 
 $password.=$conso[rand(0,19)]; 
 $password.=$vocal[rand(0,4)]; 
 }
 
 return $password;
}

function CaseCorrect($str) {
	$newstr = ucwords(strtolower($str));
	return $newstr;
}
function XMail($to, $subject, $msg, $from, $CC, $type) {

$mail = new PHPMailer();
	$mail->Mailer="smtp";
	$mail->Host="relay.aitonline.co.za";
	$mail->Port=587;
	$mail->Username="mail@cesa.co.za";
	$mail->Password="c3SAmail!@!";
	$mail->SMTPDebug=false;
	$mail->SMTPAuth=true;
	if ($type=="html") $mail->IsHTML(true);
	
	$mail->From = $from;
	$mail->FromName = $from;
	$arrto = explode(",",$to);
	for ($i=0; $i<count($arrto); $i++) {
		if (!empty($arrto[$i])) $mail->AddAddress($arrto[$i]);
	}
//	if (!empty($CC)) $mail->AddCC($CC);

$mail->AddAddress("bonolo@cesa.co.za");
$mail->AddAddress("athromethm@cesa.co.za");
$mail->AddBCC("patriciaf@cesa.co.za");
	
	$mail->Subject=$subject;
	$mail->Body=$msg;
	
	if (!$mail->Send()) echo $mail->ErrorInfo;

}

$sendto = "bonolo@cesa.co.za";
// $sendto = "julia@xe.co.za";

$sendfrom = "bonolo@cesa.co.za";
//$sendto = "julia@xe.co.za";

$EventID = $_POST["EventID"];
$Organisation = $_POST["Organisation"];
$CompanyType = $_POST["CompanyType"];
$Address1 = $_POST["Address1"];
$Address2 = $_POST["Address2"];
$Address3 = $_POST["Address3"];
$City = $_POST["City"];
$PostalCode = $_POST["PostalCode"];
$OrderNumber = $_POST["OrderNumber"];
$VATNumber = $_POST["VATNumber"];
$SAACEMemNum = $_POST["SAACEMemNum"];
$BookingName = $_POST["BookingName"];
$BookingTel = $_POST["BookingTel"];
$BookingFax = $_POST["BookingFax"];
$BookingEmail = $_POST["BookingEmail"];

$bFormErrors = false;
if (empty($Organisation)) {
	$bFormErrors = true;
	$sError[] = "Your organisation is required.";
}
$i=1;
		if (empty($_POST["FirstName".$i])) {
			$bFormErrors = true;
			$sError[] = "Your first name is required.";
		}
		if (empty($_POST["Surname".$i])) {
			$bFormErrors = true;
			$sError[] = "Your surname is required.";
		}
/*
		if (empty($_POST["KnownAs".$i])) {
			$bFormErrors = true;
			$sError[] = "Attendee ".$i."'s name \"known as\" is required.";
		}
*/
		if (empty($_POST["Email".$i])) {
			$bFormErrors = true;
			$sError[] = "Your email address is required.";
		}
		if (empty($_POST["Mobile".$i])) {
			$bFormErrors = true;
			$sError[] = "Your cell number is required.";
		}

if (!$bFormErrors) {
	// Save all the form fields
	foreach ($_POST as $FieldName => $FieldValue) {
		$sql = "INSERT INTO EventFormFields (EventID, FirstName, LastName, FieldName, FieldValue, DateCreated) VALUES ('".$EventID."', '".$FirstName . "', '" . $Surname . "', '".$FieldName."', '".$FieldValue."', '".date("Y-m-d H:i")."')";
		$queryresult = mysql_query($sql);
	}
	//Send the confirmation
	
	//ini_set("SMTP", "SAACEMAIL");
	
	$sql = "SELECT MarketingEvents.EventName, MarketingEvents.EventName, MarketingEvents.Level, MarketingEvents.City, MarketingEvents.Venue, MarketingEvents.RegDeadline,
		MarketingEvents.MemberDiscount, MarketingEvents.EarlyBirdDiscount, MarketingEvents.BankAccName,
		MarketingEvents.AvailableSpaces, MarketingEvents.CostPerPerson, 
		MarketingEvents.Hours, MarketingEvents.CPD, MarketingEvents.CODE, 
		MarketingEvents.AccredNum, MarketingEvents.Province, StartDate, 
		EndDate
		FROM MarketingEvents
		WHERE MarketingEvents.EventID=".$EventID;
	
	$queryresult = mysql_query($sql);
	
	if ($row = mysql_fetch_array($queryresult)) {

$iNumInserted = 0;
	$iNumDuplicates = 0;
	 
	for ($i=1; $i <= 2; $i++) {
		if (isset($_POST["FirstName".$i]) && !empty($_POST["FirstName".$i])) {
			$Designation = $_POST["Designation".$i];
			$Title = $_POST["Title".$i];
			$FirstName = $_POST["FirstName".$i];
			$Surname = $_POST["Surname".$i];
//			$KnownAs = $_POST["KnownAs".$i];
			$Tel = $_POST["Tel".$i];
			$Mobile = $_POST["Mobile".$i];
			$Fax = $_POST["Fax".$i];
			$Email = $_POST["Email".$i];
			$IDNumber = $_POST["IDNumber".$i];
			$ECSANumber = $_POST["ECSANumber".$i];
			$SAICENumber = $_POST["SAICENumber".$i];
			
			$bInserted = false;
			
			// Try to correct case
			$FirstName = CaseCorrect($FirstName);
			$Surname = CaseCorrect($Surname);
			//$KnownAs = CaseCorrect($KnownAs);
			$KnownAs=$FirstName;
			
			// Check for duplicates
			$sql = "SELECT * FROM MarketingAttendees WHERE ContactFirstName='" . $FirstName . "'
			AND ContactLastName='" . $Surname . "'
			AND PhoneNumber='" . $Tel . "'
			AND EmailAddress='" . $Email . "'
			AND EventID=" . $EventID;
			$queryresult = mysql_query($sql);
			if ($queryrows = mysql_fetch_assoc($queryresult)) {
//				echo "You are already registered for this event!";
//				die();
				$iNumDuplicates++;
			} else {

$sPassword=GenPassword();	
				$sql = "INSERT INTO MarketingAttendees (ContactTitle, ContactFirstName, ContactLastName, CompanyName, AddressLine1, AddressLine2, AddressLine3, 
					City, PostalCode, PhoneNumber, MobileNumber, FaxNumber, EmailAddress, DietaryReq, EventID, Attended, OrderNum, OrgVATNum, IDNumber, SAACEMemNumber, ECSANumber, SAICEMemNumber, Designation, BookingName, BookingTel, BookingFax, BookingEmail, KnownAs, CompanyType, Password)
					VALUES ('" . mysql_real_escape_string($Title) . "', '" . mysql_real_escape_string($FirstName) . "', '" . mysql_real_escape_string($Surname) . "', 
					'" . mysql_real_escape_string($Organisation) . "', '" . mysql_real_escape_string($Address1) . "', '" . mysql_real_escape_string($Address2) . "', 
					'" . mysql_real_escape_string($Address3) . "', '" . mysql_real_escape_string($City) . "', '" . $PostalCode . "', 
					'" . $Tel . "', '" . $Mobile . "', '" . $Fax . "', 
					'" . $Email . "', '" . mysql_real_escape_string($DietaryReq) . "', " . $EventID . ", 'u', 
					'" . $OrderNumber . "', '" . $VATNumber . "', '".$IDNumber."', '".$SAACEMemNum."', '".$ECSANumber."',
					'".$SAICENumber."', 
					'" . $Designation . "', '".mysql_real_escape_string($BookingName)."', '".$BookingTel."', '".$BookingFax."', '".$BookingEmail."',
					'".mysql_real_escape_string($KnownAs)."', '".$CompanyType."', '".$sPassword."')";
				
				$queryresult = mysql_query($sql);
				
				$AttendeeID=mysql_insert_id();
				
				if (!$queryresult) {
					XMail("julia@xe.co.za", "Error on marketing db insert", $sql, "sce@cesa.co.za", "", "");
				} else {
					
					$sql="INSERT INTO MarketingExtraInfo (AttendeeID, FieldName, FieldValue) VALUES (".$AttendeeID.", 'Teams', '".$_REQUEST["Teams"]."')";
					mysql_query($sql);

$sql="INSERT INTO MarketingExtraInfo (AttendeeID, FieldName, FieldValue) VALUES (".$AttendeeID.", 'NumTeams', '".$_REQUEST["NumTeams"]."')";
					mysql_query($sql);

$sql="INSERT INTO MarketingExtraInfo (AttendeeID, FieldName, FieldValue) VALUES (".$AttendeeID.", 'Premium_Hole', '".$_REQUEST["Premium_Hole"]."')";
					mysql_query($sql);
					
					$sql="INSERT INTO MarketingExtraInfo (AttendeeID, FieldName, FieldValue) VALUES (".$AttendeeID.", 'Carts', '".$_REQUEST["Carts"]."')";
					mysql_query($sql);

$sql="INSERT INTO MarketingExtraInfo (AttendeeID, FieldName, FieldValue) VALUES (".$AttendeeID.", 'NumCarts', '".$_REQUEST["NumCarts"]."')";
					mysql_query($sql);
					
					for ($j=1; $j<=intval($_POST["NumPlayers"]); $j++) {
						$sql="INSERT INTO MarketingExtraInfo (AttendeeID, FieldName, FieldValue) VALUES (".$AttendeeID.", 'Player".$j."', '".$_REQUEST["Player".$j]."')";
						mysql_query($sql);
						$sql="INSERT INTO MarketingExtraInfo (AttendeeID, FieldName, FieldValue) VALUES (".$AttendeeID.", 'Cell".$j."', '".$_REQUEST["Cell".$j]."')";
						mysql_query($sql);
						$sql="INSERT INTO MarketingExtraInfo (AttendeeID, FieldName, FieldValue) VALUES (".$AttendeeID.", 'Shirt".$j."', '".$_REQUEST["Shirt".$j]."')";
						mysql_query($sql);
					}

$bInserted = true;
					$iNumInserted++;
				}
			}
			
			if ($bInserted) {
	
				$FirstName= stripslashes($FirstName);
				$Surname= stripslashes($Surname);
				
$msg="Dear " . $FirstName . " " . $Surname . ",
We are delighted to have received your online registration for " . $row["EventName"] . " to be held on " . date("D j F Y", strtotime($row["StartDate"])) . " at " . $row["Venue"].". Please direct any questions to bonolo@cesa.co.za.<table border=0><tr><td>Company Name:</td><td>".$Organisation."</td></tr><tr><td>Order Number:</td><td>".$OrderNumber."</td></tr><tr><td>VAT Number:</td><td>".$VATNumber."</td></tr><tr><td>Address:</td><td>".$Address1." ".$Address2." ".$Address3." ".$City." ".$PostalCode."</td></tr><tr><td>Email:</td><td>".$Email."</td></tr><tr><td>Mobile:</td><td>".$Mobile."</td></tr><tr><td>Telephone:</td><td>".$Tel."</td></tr><tr><td>Registration type:</td><td>".$_REQUEST["Teams"]."</td></tr><tr><td>Number of teams:</td><td>".$_REQUEST["NumTeams"]."</td></tr><tr><td>Premium hole:</td><td>".$_REQUEST["Premium_Hole"]."</td></tr><tr><td>Golf carts:</td><td>".$_REQUEST["Carts"]."</td></tr><tr><td>Number of carts:</td><td>".$_REQUEST["NumCarts"]."</td></tr></table>
Player details
<table border=0>
<tr><td>&nbsp;</td><td>Player name</td><td>Cell</td><td>Shirt Size</td></tr>
";
for ($j=1; $j<=intval($_POST["NumPlayers"]); $j++) {
	$msg.="<tr><td>".$j."</td><td>".$_POST["Player".$j]."</td><td>".$_POST["Cell".$j]."</td><td>".$_POST["Shirt".$j]."</td></tr>";
}
$msg.="</table>";
//if ($_REQUEST["type"]!="vip") $msg.="To reserve your table, please login at: <a href='http://www.cesa.co.za/eventtables'>http://www.cesa.co.za/eventtables</a> using your email address and the password: ".$sPassword.". Please save this email for future reference.";
$msg.="With kind regards,
CESA Marketing";

XMail($Email.",".$BookingEmail, "Confirmation of CESA Event Registration", "<html>
				<head>
				<style>
				body, td { 
					font-family: Arial, Verdana, sans-serif;
					font-size: 11pt;
				}
				</style>
				</head>
				<body>".$msg."</body></html>", $sendfrom, $sendfrom, "html");
				
			}

}
	}
	
	if ($iNumInserted == 0) {
?>
No attendees were registered.
<?php
		if ($iNumDuplicates > 0) {
			echo "".$iNumDuplicates." duplicate(s) were found, these attendees have already been registered for this event.";
		}
	} else {	
	
	
	?>
 Thank you for your RSVP
 
We look forward to welcoming you to this event.

<?php
if ($_REQUEST["type"]!="vip") {
?> 

	<?php
}
//		echo $formmsg;
	}
	}
}
?>