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

die();

error_reporting(E_ALL); 
ini_set("display_errors", 1);

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   = "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++) {
		$mail->AddAddress($arrto[$i]);
	}
	$mail->Subject=$subject;
	$mail->Body=$msg;
	
	if (!$mail->Send()) echo $mail->ErrorInfo;

}

?>
<link rel="stylesheet" href="/autosuggest/css/autosuggest_inquisitor.css" type="text/css" media="screen" charset="utf-8" />
<script type="text/javascript" src="/autosuggest/js/bsn.AutoSuggest_c_2.0.js"></script>
<SCRIPT LANGUAGE="JavaScript">
function IsEmpty(aTextField) {
   if ((aTextField.value.length==0) || (aTextField.value==null)) {
      return true;
   } else { 
	return false; 
	}
}

// Declaring required variables
var digits = "0123456789";
// non-digit characters which are allowed in phone numbers
var phoneNumberDelimiters = "()- ";
// characters which are allowed in international phone numbers
// (a leading + is OK)
var validWorldPhoneChars = phoneNumberDelimiters + "+";
// Minimum no of digits in an international phone no.
var minDigitsInIPhoneNumber = 7;

function isInteger(s)
{   var i;
    for (i = 0; i < s.length; i++)
    {   
        // Check that current character is number.
        var c = s.charAt(i);
        if (((c < "0") || (c > "9"))) return false;
    }
    // All characters are numbers.
    return true;
}

function stripCharsInBag(s, bag)
{   var i;
    var returnString = "";
    // Search through string's characters one by one.
    // If character is not in bag, append to returnString.
    for (i = 0; i < s.length; i++)
    {   
        // Check that current character isn't whitespace.
        var c = s.charAt(i);
        if (bag.indexOf(c) == -1) returnString += c;
    }
    return returnString;
}

function checkInternationalPhone(strPhone){
s=stripCharsInBag(strPhone,validWorldPhoneChars);
return (isInteger(s) && s.length >= minDigitsInIPhoneNumber);
}

function ValidateForm(){
	var Phone=document.frmSample.txtPhone
	
	if ((Phone.value==null)||(Phone.value=="")){
		alert("Please Enter your Phone Number")
		Phone.focus()
		return false
	}
	if (checkInternationalPhone(Phone.value)==false){
		alert("Please Enter a Valid Phone Number")
		Phone.value=""
		Phone.focus()
		return false
	}
	return true
 }

function formCheck(objForm) {
	bOK = true;

if (IsEmpty(objForm.BookingName)) {
		bOK = false;
		alert('Please fill in your name.');
	} else if (IsEmpty(objForm.Organisation)) {
		bOK = false;
		alert('Please fill in your organisation.');
	} else if (IsEmpty(objForm.Address1)) {
		bOK = false;
		alert('Please fill in the address.');
	} else if (IsEmpty(objForm.City)) {
		bOK = false;
		alert('Please fill in the city.');
	} else if (IsEmpty(objForm.PostalCode)) {
		bOK = false;
		alert('Please fill in the postal code.');
	}
<?php
	for ($i=1; $i <= 10; $i++) {
?>		
	if (bOK && (objForm.DivDisplayed<?php echo $i; ?>.value == 1)) {
		if (IsEmpty(objForm.Surname<?php echo $i; ?>)) {
			bOK = false;
			alert('Please fill in attendee <?php echo $i; ?>\'s surname.');
		} else if (IsEmpty(objForm.FirstName<?php echo $i; ?>)) {
			bOK = false;
			alert('Please fill in attendee <?php echo $i; ?>\'s first name.');
		} else if (IsEmpty(objForm.Tel<?php echo $i; ?>) && IsEmpty(objForm.Mobile<?php echo $i; ?>)) {
			bOK = false;
			alert('Please fill in attendee <?php echo $i; ?>\'s telephone number.');
		}	else {
			bOK = emailCheck(objForm.Email<?php echo $i; ?>.value);
		}
	}
<?php
	}
?>
/*
	} else if (IsEmpty(objForm.OrderNumber)) {
		bOK = false;
		alert('Please fill in the order number.');
	} else if ((checkInternationalPhone(objForm.Tel.value)==false) && (checkInternationalPhone(objForm.Mobile.value)==false)) {
		bOK = false;
		alert('Please provide a valid telephone number.');
	} else if (!isInteger(objForm.PostalCode.value)) {
		bOK = false;
		alert('Please provide a numeric postal code.');
*/
	return bOK;
}

function emailCheck (emailStr) {

/* The following variable tells the rest of the function whether or not
to verify that the address ends in a two-letter country or well-known
TLD.  1 means check it, 0 means don't. */

var checkTLD=0;

/* The following is the list of known TLDs that an e-mail address must end with. */

var knownDomsPat=/^(com|net|org|edu|int|mil|gov|arpa|biz|aero|name|coop|info|pro|museum)$/;

/* The following pattern is used to check if the entered e-mail address
fits the user@domain format.  It also is used to separate the username
from the domain. */

var emailPat=/^(.+)@(.+)$/;

/* The following string represents the pattern for matching all special
characters.  We don't want to allow special characters in the address. 
These characters include ( ) < > @ , ; : \ " . [ ] */

var specialChars="\$\$><@,;:\\\\\\\"\\.\\[\\]";

/* The following string represents the range of characters allowed in a 
username or domainname.  It really states which chars aren't allowed.*/

var validChars="\[^\\s" + specialChars + "\]";

/* The following pattern applies if the "user" is a quoted string (in
which case, there are no rules about which characters are allowed
and which aren't; anything goes).  E.g. "jiminy cricket"@disney.com
is a legal e-mail address. */

var quotedUser="(\"[^\"]*\")";

/* The following pattern applies for domains that are IP addresses,
rather than symbolic names.  E.g. joe@[123.124.233.4] is a legal
e-mail address. NOTE: The square brackets are required. */

var ipDomainPat=/^\[(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})\]$/;

/* The following string represents an atom (basically a series of non-special characters.) */

var atom=validChars + '+';

/* The following string represents one word in the typical username.
For example, in john.doe@somewhere.com, john and doe are words.
Basically, a word is either an atom or quoted string. */

var word="(" + atom + "|" + quotedUser + ")";

// The following pattern describes the structure of the user

var userPat=new RegExp("^" + word + "(\\." + word + ")*$");

/* The following pattern describes the structure of a normal symbolic
domain, as opposed to ipDomainPat, shown above. */

var domainPat=new RegExp("^" + atom + "(\\." + atom +")*$");

/* Finally, let's start trying to figure out if the supplied address is valid. */

/* Begin with the coarse pattern to simply break up user@domain into
different pieces that are easy to analyze. */

var matchArray=emailStr.match(emailPat);

if (matchArray==null) {

/* Too many/few @'s or something; basically, this address doesn't
even fit the general mould of a valid e-mail address. */

alert("Email address seems incorrect (check @ and .'s)");
return false;
}
var user=matchArray[1];
var domain=matchArray[2];

// Start by checking that only basic ASCII characters are in the strings (0-127).

for (i=0; i<user.length; i++) {
if (user.charCodeAt(i)>127) {
alert("The email address contains invalid characters.");
return false;
   }
}
for (i=0; i<domain.length; i++) {
if (domain.charCodeAt(i)>127) {
alert("The email address contains invalid characters.");
return false;
   }
}

// See if "user" is valid

if (user.match(userPat)==null) {

// user is not valid

alert("The email address doesn't seem to be valid.");
return false;
}

/* if the e-mail address is at an IP address (as opposed to a symbolic
host name) make sure the IP address is valid. */

var IPArray=domain.match(ipDomainPat);
if (IPArray!=null) {

// this is an IP address

for (var i=1;i<=4;i++) {
if (IPArray[i]>255) {
alert("Destination IP address is invalid!");
return false;
   }
}
return true;
}

// Domain is symbolic name.  Check if it's valid.
 
var atomPat=new RegExp("^" + atom + "$");
var domArr=domain.split(".");
var len=domArr.length;
for (i=0;i<len;i++) {
if (domArr[i].search(atomPat)==-1) {
alert("The email address does not seem to be valid.");
return false;
   }
}

/* domain name seems valid, but now make sure that it ends in a
known top-level domain (like com, edu, gov) or a two-letter word,
representing country (uk, nl), and that there's a hostname preceding 
the domain or country. */

if (checkTLD && domArr[domArr.length-1].length!=2 && 
domArr[domArr.length-1].search(knownDomsPat)==-1) {
alert("The email address must end in a well-known domain or two letter " + "country.");
return false;
}

// Make sure there's a host name preceding the domain.

if (len<2) {
alert("The email address is missing a hostname!");
return false;
}

// If we've gotten this far, everything's valid!
return true;
}

</script>
<?php
//$id = intval($_REQUEST["id"]);

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

mysql_select_db($dbname,$db);

$sql = "SELECT MarketingEvents.EventName, MarketingEvents.Level, MarketingEvents.City, MarketingEvents.Venue, 
	MarketingEvents.AvailableSpaces, MarketingEvents.CostPerPerson, MarketingEvents.EventDescription, MarketingEvents.Hours, MarketingEvents.CPD, MarketingEvents.CODE, MarketingEvents.AccredNum, MarketingEvents.Province, MarketingEvents.RegDeadline,
	MarketingEvents.MemberDiscount, MarketingEvents.EarlyBirdDiscount, MarketingEvents.Cancelled, MarketingEvents.BankAccName,
	CourseVenues.CourseVenueCity, CourseVenues.CourseVenueArea
	FROM MarketingEvents LEFT JOIN CourseVenues ON MarketingEvents.Venue = CourseVenues.CourseVenueName
	WHERE MarketingEvents.EventID=".$id;

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

if ($row = mysql_fetch_array($queryresult)) {

$bShowForm = true;
		if (isset($_POST["ProcessForm"]) && ($_POST["ProcessForm"]==1)) {

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

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

$EventID = $_POST["EventID"];
$Organisation = $_POST["Organisation"];
$BookingName = $_POST["FirstName1"]." ".$_POST["Surname1"];
$BookingTel = $_POST["Tel1"];
$BookingMobile = $_POST["Mobile1"];
$BookingEmail = $_POST["Email1"];

$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 (!$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)) {
		
		$msg="<p><b>DECLINED: ".$row["EventName"]."</b></p>
		<table border=1 cellspacing=0 cellpadding=5>
		<tr><td><b>Organisation:</b></td><td>".$Organisation."</td></tr>
		<tr><td><b>Name:</b></td><td>".$BookingName."</td></tr>
		<tr><td><b>Email:</b></td><td>".$BookingEmail."</td></tr>
		<tr><td><b>Tel:</b></td><td>".$BookingTel."</td></tr>
		<tr><td><b>Mobile:</b></td><td>".$BookingMobile."</td></tr></table>";
	
		XMail($sendto, "Marketing event invitation DECLINED", $msg, $sendfrom, "", "html");
	}
	
	
	?>
    <p align="center" style="font-size:20px"><i><b>Thank you for your response</b></i></p>
    <p align="center">We are sorry that you are unable to attend this event.</p>
	<?php
}

if (!$bFormErrors) $bShowForm = false;
		}
		
		if ($bShowForm) {
if ($bFormErrors) {
	echo "<p><font color=red><b>The following errors occurred:</b></font><br>".join("<br>",$sError)."<br><b>Please correct the errors and submit again. Thank you!</b></p>";
}
?>          
          <br>
        <p align=center style='text-align:center'><b>INVITATION DECLINED<br>
        </b></p>
<form name="form1" method="post" action="/node/534">
  <input type="hidden" name="ProcessForm" value="1">
<input type="hidden" name="EventID" value="<? echo $id; ?>">
<input type="hidden" name="id" value="<? echo $id; ?>">
<input type="hidden" name="type" value="<?php echo $_REQUEST["type"]; ?>">
<table border=0 cellpadding=2 cellspacing=0 bgcolor="#FFFFFF">
          <tr>
            <td valign=top nowrap="nowrap"><strong>First Name:</strong></td>
            <td valign=top><input name="FirstName1" type="text" size="40" value="<?php echo stripslashes($_POST["FirstName1"].""); ?>">&nbsp;*</td>
          </tr>
          <tr>
            <td valign=top nowrap="nowrap"><strong>Surname:</strong></td>
            <td valign=top><input name="Surname1" type="text" size="40" value="<?php echo $_POST["Surname1"]; ?>">&nbsp;*</td>
          </tr>
          <tr>
                <td valign=top nowrap="nowrap"><p><strong>Company Name: </strong></p></td>
              <td valign=top><input name="Organisation" id="Organisation" type="text" size="40" value="<?php echo stripslashes($_POST["Organisation"].""); ?>">&nbsp;*</td>
            </tr>
          <tr>
            <td valign=top nowrap="nowrap"><strong>E-mail:</strong></td>
            <td valign=top><input name="Email1" type="text" size="40" value="<?php echo $_POST["Email1"]; ?>">&nbsp;*</td>
          </tr>
          <tr>
            <td valign=top nowrap="nowrap"><strong>Mobile:</strong></td>
            <td valign=top><input name="Mobile1" type="text" size="40" value="<?php echo $_POST["Mobile1"]; ?>"></td>
          </tr>
          <tr>
            <td valign=top nowrap="nowrap"><strong>Telephone:</strong></td>
            <td valign=top><input name="Tel1" type="text" size="40" value="<?php echo $_POST["Tel1"]; ?>"></td>
          </tr>
          <tr><td colspan="2" align="center"><input type="submit"></td></tr>
        </table>
              <p>&nbsp;</p>
</form>
<?php
		}
} else {
	echo "Event not found.";
}
?>
</table>