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
$pagetitle = "Join the YPF";

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

?>
<img src="https://www.cesa.co.za/sites/default/files/CESA%20YPF_Logo_small.jpg" alt="YPF" hspace="10" align="left" />
<?php
if ($_POST["selContact"] == "NONE") {
	// If there was no match to existing data, add this as a new contact
	$sDOB = "NULL";
	if (!empty($_POST["DOBDay"]) && !empty($_POST["DOBMonth"]) && !empty($_POST["DOBYear"]) && is_numeric($_POST["DOBDay"]) && is_numeric($_POST["DOBYear"])) $sDOB = "'" . $_POST["DOBYear"] . "-" . $_POST["DOBMonth"] . "-" . substr("00" . $_POST["DOBDay"], -2) . "'";

$iOfficeHead = 0;
	if (isset($_POST["OfficeHead"]) && ($_POST["OfficeHead"] == "y")) $iOfficeHead = 1;
	$iPrincipal = 0;
	if (isset($_POST["Principal"]) && ($_POST["Principal"] == "y")) $iPrincipal = 1;

$sql = "INSERT INTO Contacts (ContactSurname, ContactInitials, ContactFirstName, ContactDesignation)
	VALUES ('" . addslashes($_POST["Surname"]) . "', 
	'" . addslashes($_POST["Initials"]) . "', '" . addslashes($_POST["FirstName"]) . "', 
	'" . addslashes($_POST["Designation"]) . "')";
	mysql_query($sql);

// Get new ContactsID
	$query = "SELECT MAX(ContactsID) FROM Contacts AS ContactsID";
	$result = mysql_query($query) or die("Scope_Identity Failed");
	$row = mysql_fetch_array($result);
	$NewContactsID = $row[0];

$sql = "INSERT INTO OfficeContacts (ContactsID, OfficeID, YPF, ContactPosition,
	OfficeHead, Principal, MandatedPrincipal, Mail) 
	VALUES ('" . $NewContactsID . "', '" . intval($_POST["OfficeID"]) . "', 'y', '" . addslashes($_POST["Position"]) . "',
	" . $iOfficeHead . ", " . $iPrincipal . ", 0, 0)";
	mysql_query($sql);

$sql = "INSERT INTO MemberContacts (ContactID, OfficeID, ContactSurname, ContactInitials, ContactFirstName, ContactDesignation, YPF) 
	VALUES (" . $NewContactsID . ", " . intval($_POST["OfficeID"]) . ", '" . addslashes($_POST["Surname"]) . "', 
	'" . addslashes($_POST["Initials"]) . "', '" . addslashes($_POST["FirstName"]) . "', 
	'" . addslashes($_POST["Designation"]) . "', 'y')";
	mysql_query($sql);

$sql = "UPDATE MemberContacts SET PersonalTel='" . addslashes($_POST["TelNum"]) . "', 
	PersonalFax='" . addslashes($_POST["PersonalFax"]) . "', CellPhone='" . addslashes($_POST["CellPhone"]) . "', 
	Email='" . addslashes($_POST["Email"]) . "', BirthDate=" . addslashes($sDOB) . ", 
	ContactPosition='" . addslashes($_POST["Position"]) . "',
	OfficeHead=" . $iOfficeHead . ", Principal=" . $iPrincipal . ", 
	MandatedPrincipal=0, Mail=0, YPF='y',
	ProfessionalRegistrations='" . addslashes($_POST["ProfReg"]) . "', 
	Qualifications='" . addslashes($_POST["Qual"]) . "',
	IDNumber='" . addslashes($_POST["IDNumber"]) . "', Comments='" . addslashes($_POST["Expertise"]) . "'
	WHERE ContactID = " . $NewContactsID;
	mysql_query($sql);

$sql = "UPDATE Contacts SET PersonalTel='" . addslashes($_POST["TelNum"]) . "', 
	PersonalFax='" . addslashes($_POST["PersonalFax"]) . "', CellPhone='" . addslashes($_POST["CellPhone"]) . "', 
	PreferredEmail='" . addslashes($_POST["Email"]) . "', BirthDate=" . addslashes($sDOB) . ", 
	ProfessionalRegistrations='" . addslashes($_POST["ProfReg"]) . "', 
	Qualifications='" . addslashes($_POST["Qual"]) . "',
	IDNumber='" . addslashes($_POST["IDNumber"]) . "', Comments='" . addslashes($_POST["Expertise"]) . "'
	WHERE ContactsID = " . $NewContactsID;
	mysql_query($sql);

echo "Thank you. We have added your information to our database.";

if (!empty($_POST["Email"])) mail($_POST["Email"], "CESA YPF", "Thank you for joining the CESA YPF. Your details have been added to our database and we will send future relevant YPF communications to you at this email address.

Best regards,

The YPF Committee", "From: webmaster@cesa.co.za");

$sql = "SELECT tblMemberFirms.FirmName, tblMemberFirmOffices.OfficeStatus, tblMemberFirmOffices.Province, tblMemberFirmOffices.GeoLocation
	FROM tblMemberFirms, tblMemberFirmOffices 
	WHERE tblMemberFirms.FirmID = tblMemberFirmOffices.FirmID AND tblMemberFirmOffices.OfficeID=" . intval($_POST["OfficeID"]);
	$recOffices = mysql_query($sql);
	$rowOffices = mysql_fetch_assoc($recOffices);

$mailbody = "YPF Contact information submitted on the CESA website: 
	<table border=1 width=600 cellspacing=0 cellpadding=10>
	<tr><td>Firm</td><td>" . $rowOffices["FirmName"] . "</td></tr>
	<tr><td>Office</td><td>" . $rowOffices["OfficeStatus"] . "-" . $rowOffices["Province"] . "-" . $rowOffices["GeoLocation"] . "</td></tr>
	<tr><td>Position</td><td>" . $_POST["Position"] . "</td></tr>
	<tr><td>Designation</td><td>" . $_POST["Designation"] . "</td></tr>
	<tr><td>Initials</td><td>" . $_POST["Initials"] . "</td></tr>
	<tr><td>First Name</td><td>" . $_POST["FirstName"] . "</td></tr>
	<tr><td>Surname</td><td>" . $_POST["Surname"] . "</td></tr>
	<tr><td>Tel Num</td><td>" . $_POST["TelNum"] . "</td></tr>
	<tr><td>Cell Num</td><td>" . $_POST["CellPhone"] . "</td></tr>
	<tr><td>Email Address</td><td>" . $_POST["Email"] . "</td></tr>
	<tr><td>Birth Date</td><td>" . $_POST["DOBDay"] . "/" . $_POST["DOBMonth"] . "/" . $_POST["DOBYear"] . "</td></tr>
	<tr><td>Professional Registrations</td><td>" . $_POST["ProfReg"] . "</td></tr>
	<tr><td>Qualifications</td><td>" . $_POST["Qual"] . "</td></tr>
	<tr><td>Fields of Expertise</td><td>" . $_POST["Expertise"] . "</td></tr>
	</table>
	";

$headers  = 'MIME-Version: 1.0' . "\r\n";
	$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
	$headers .= 'From: webmaster@cesa.co.za' . "\r\n";

mail("godfrey@cesa.co.za", "New YPF Contact", $mailbody, $headers);
} elseif (isset($_POST["selContact"])) {
	// Send email

$mailbody = "The following individual has registered on the website as a YPF member, but the information they supplied matches another contact already in the database. They have confirmed that they are already on the database with the information displayed below. Please update the contact in the database with the newly provided information.
	Existing contact in the database:
	";

$sql = "SELECT Contacts.ContactsID, Contacts.ContactFirstName, Contacts.ContactSurname, Contacts.ContactInitials, 
	tblMemberFirms.FirmName, tblMemberFirmOffices.OfficeStatus, tblMemberFirmOffices.Province, tblMemberFirmOffices.GeoLocation
	FROM tblMemberFirms, tblMemberFirmOffices, OfficeContacts, Contacts
	WHERE tblMemberFirms.FirmID = tblMemberFirmOffices.FirmID
	AND tblMemberFirmOffices.OfficeID = OfficeContacts.OfficeID
	AND OfficeContacts.ContactsID = Contacts.ContactsID
	AND Contacts.ContactsID = " . intval($_POST["selContact"]);
	$recContacts = mysql_query($sql);
	if ($rowContacts = mysql_fetch_assoc($recContacts)) {
		$mailbody .= "
	<table border=1 width=600 cellspacing=0 cellpadding=10>
 <tr><td>Firm</td><td>" . $rowContacts["FirmName"] . "</td></tr>
	<tr><td>Office</td><td>" . $rowContacts["OfficeStatus"] . "-" . $rowContacts["Province"] . "-" . $rowContacts["GeoLocation"] . "</td></tr>
	<tr><td>Initials</td><td>" . $rowContacts["ContactInitials"] . "</td></tr>
	<tr><td>First Name</td><td>" . $rowContacts["ContactFirstName"] . "</td></tr>
	<tr><td>Surname</td><td>" . $rowContacts["ContactSurname"] . "</td></tr>
 </table>
	";
	}
	mysql_free_result($recContacts);

$mailbody .= "
	New information provided on the website: 
	<table border=1 width=600 cellspacing=0 cellpadding=10>
 <tr><td>Firm</td><td>" . $rowOffices["FirmName"] . "</td></tr>
	<tr><td>Office</td><td>" . $rowOffices["OfficeStatus"] . "-" . $rowOffices["Province"] . "-" . $rowOffices["GeoLocation"] . "</td></tr>
	<tr><td>Designation</td><td>" . $_POST["Designation"] . "</td></tr>
	<tr><td>Initials</td><td>" . $_POST["Initials"] . "</td></tr>
	<tr><td>First Name</td><td>" . $_POST["FirstName"] . "</td></tr>
	<tr><td>Surname</td><td>" . $_POST["Surname"] . "</td></tr>
	<tr><td>Tel Num</td><td>" . $_POST["TelNum"] . "</td></tr>
	<tr><td>Fax Num</td><td>" . $_POST["PersonalFax"] . "</td></tr>
	<tr><td>Cell Num</td><td>" . $_POST["CellPhone"] . "</td></tr>
	<tr><td>Email Address</td><td>" . $_POST["Email"] . "</td></tr>
	<tr><td>Birth Date</td><td>" . $_POST["DOBDay"] . "/" . $_POST["DOBMonth"] . "/" . $_POST["DOBYear"] . "</td></tr>
 </table>
	";

$headers  = 'MIME-Version: 1.0' . "\r\n";
	$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
	$headers .= 'From: webmaster@cesa.co.za' . "\r\n";

mail("gillian@cesa.co.za", "New YPF member matches existing contact", $mailbody, $headers);

echo "Thank you. The updated information has been sent to us, so that we can update our database.";

Best regards,

The YPF Committee", "From: webmaster@cesa.co.za");
}
?>