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_once($_SERVER['DOCUMENT_ROOT'] . '/cfg/config.php');
require_once($_SERVER['DOCUMENT_ROOT'] . '/php/includes/load_phpmailer.php');
require_once($_SERVER['DOCUMENT_ROOT'] . '/cesanet/inc_shared.php');

use PHPMailer\PHPMailer\PHPMailer;

$marketingAttendeeObj = new MarketingAttendees($sqlf);

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((float) 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 = "mail";
    /*
      $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->AddAddress("ann-marie@cesa.co.za");
    $mail->AddAddress("events@cesa.co.za");

$mail->Subject = $subject;
    $mail->Body = $msg;

if (!$mail->Send())
        echo $mail->ErrorInfo;
}

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

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

$sEmailFooter = "Consulting Engineers South Africa Tel: 011 463 2022 Website: www.cesa.co.za<img src='https://www.cesa.co.za/images/emailfooter.jpg'>";

$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 (!reCaptcha($_POST["g-recaptcha-response"])) {
if (1 == 0) {
    $bFormErrors = true;
    $sError[] = "You could not be verified as not being a robot, please tick the reCaptcha verification option at the bottom of the form.";
} else {

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 (!filter_var($_POST["Email" . $i], FILTER_VALIDATE_EMAIL)) {
        $bFormErrors = true;
        $sError[] = "Your email address is invalid.";
    }
    
    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];
 $DietaryReq = $_POST["DietaryReq" . $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='" . mysql_real_escape_string($FirstName) . "' "
                    . "AND ContactLastName='" . mysql_real_escape_string($Surname) . "' "
                    . "AND PhoneNumber='" . mysql_real_escape_string($Tel) . "' "
                    . "AND EmailAddress='" . mysql_real_escape_string($Email) . "' "
                    . "AND EventID=" . $EventID;
                
                $queryresult = mysql_query($sql);

$msg = '';

if ($queryrows = mysql_fetch_assoc($queryresult)) {
                    //				echo "You are already registered for this event!";
                    //				die();
                    $iNumDuplicates++;
                } else {

$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='https://www.cesa.co.za/eventtables'>https://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" 
 . $sEmailFooter;

$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, DateBooked, "
                        . "Subscribed, SponsorSubscribed, SocialMediaConsent, BookingForm)
					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) . "', "
                    . "'" . mysql_real_escape_string($PostalCode) . "', '" . mysql_real_escape_string($Tel) . "', "
                    . "'" . mysql_real_escape_string($Mobile) . "', '" . mysql_real_escape_string($Fax) . "', "
                    . "'" . mysql_real_escape_string($Email) . "', '" . mysql_real_escape_string($DietaryReq) . "', " 
                    . $EventID . ", 'u', '" . mysql_real_escape_string($OrderNumber) . "', "
                    . "'" . mysql_real_escape_string($VATNumber) . "', '" . mysql_real_escape_string($IDNumber) . "', "
                    . "'" . mysql_real_escape_string($SAACEMemNum) . "', '" . mysql_real_escape_string($ECSANumber) . "', "
                    . "'" . mysql_real_escape_string($SAICENumber) . "', '" . mysql_real_escape_string($Designation) . "', "
                    . "'" . mysql_real_escape_string($BookingName) . "', '" . mysql_real_escape_string($BookingTel) . "', "
                    . "'" . mysql_real_escape_string($BookingFax) . "', '" . mysql_real_escape_string($BookingEmail) . "', "
                    . "'" . mysql_real_escape_string($KnownAs) . "', '" . mysql_real_escape_string($CompanyType) . "', "
                    . "'" . $sPassword . "', '" . date("Y-m-d H:i:s") . "', "
                    . "'" . mysql_real_escape_string($_REQUEST["subscribe"]) . "', "
                    . "'" . mysql_real_escape_string($_REQUEST["sponsor_subscribe"]) . "', "
                    . "'". mysql_real_escape_string($_REQUEST["social_media_consent"]) . "', "
                    . "'" . mysql_real_escape_string($msg) . "')";

$queryresult = mysql_query($sql);

$AttendeeID = mysql_insert_id();

if (!$queryresult) {
                        // XMail("cesa-marketing@igotafrica.com", "Error on marketing db insert", $sql, "info@cesa.co.za", "", "");
                        // echo mysql_error(get_current_connection()) . ' - ' . $sql;
                        maill(
                            "cesa-marketing@igotafrica.com",
                            "Error on marketing db insert",
                            mysql_error(get_current_connection()) . ' - ' . $sql,
                            null,
                            [
                                'from-name' => 'CESA Events',
                                'from-address' => 'events@cesa.co.za',
                                'reply-to-address' => 'events@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);

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

maill(
 $Email . "," . $BookingEmail,
 "Confirmation of " . $sOrgName . " Event Registration: " . $row["EventName"],
 "<html>
							<head>
							<style>
							body, td {
								font-family: Arial, Verdana, sans-serif;
								font-size: 11pt;
							}
							</style>
							</head>
							<body>" . $msg . "</body></html>",
 null,
 array(
 'isHTML' => true,
 'from-address' => $sendfrom,
 'from-name' => 'CESA Events',
 'i-cal' => Mailer::getICalText($row, array(
 'ContactFirstName' => $FirstName,
 'ContactLastName' => $Surname,
 'EmailAddress' => $Email,
 )),
 'bcc' => ['cesa-events@igotafrica.com'],
 )
 );

maill(
                        $sendto,
                        "Golf Day Registration",
                        $msg,
                        null,
                        array(
                            'from-address' => $sendfrom,
                            'from-name' => 'CESA Events',
                            'isHTML' => true,
                            'bcc' => ['cesa-events@igotafrica.com'],
                        )
                    );
                }
            }
        }

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;
 }
 }
}
?>