'terms_and_conditions',
'where' => '', // load first record
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$terms_and_conditionsRecord = @$terms_and_conditionsRecords[0]; // get first record
if (!$terms_and_conditionsRecord) { dieWith404("Record not found!"); } // show error message if no record found
?>
<?php echo htmlspecialchars($page['name']) ?>. <?php echo htmlspecialchars($website_config['website_name']) ?>
\n"; }
if (!@$_REQUEST['address']) { $errorsAndAlerts .= "Please enter your address \n"; }
if (!@$_REQUEST['city']) { $errorsAndAlerts .= "Please enter your city \n"; }
if (!@$_REQUEST['postcode']) { $errorsAndAlerts .= "Please enter your postcode \n"; }
if (!@$_REQUEST['email']) { $errorsAndAlerts .= "Please enter your email address \n"; }
if (!@$_REQUEST['telephone']) { $errorsAndAlerts .= "Please enter your telephone number \n"; }
if (!@$_REQUEST['petname']) { $errorsAndAlerts .= "Please enter your pet's name \n"; }
if (!@$_REQUEST['breed']) { $errorsAndAlerts .= "Please enter the breed of your dog \n"; }
if (!@$_REQUEST['size']) { $errorsAndAlerts .= "Please enter the size of your dog \n"; }
if (!@$_REQUEST['vetaddress']) { $errorsAndAlerts .= "Please enter your vet's name and address \n"; }
if (!@$_REQUEST['accessinfo']) { $errorsAndAlerts .= "Please give us some details on how to gain access to your dog \n"; }
if (!@$_REQUEST['termsandconditions']) { $errorsAndAlerts .= "Please accept the terms and conditions \n"; }
if (!@$_REQUEST['collar']) { $errorsAndAlerts .= "Please confirm that you will supply a collar or harness \n"; }
if (!@$_REQUEST['collar']) { $errorsAndAlerts .= "Please confirm that you allow Mad Dogs & Englishmen to exercise your dog off-leash \n"; }
// turn off strict mysql error checking for: STRICT_ALL_TABLES
mysqlStrictMode(false); // disable Mysql strict errors for when a field isn't defined below (can be caused when fields are added later)
// add record
if (!@$errorsAndAlerts) {
mysql_query("INSERT INTO `{$TABLE_PREFIX}registration_forms` SET
title = '".mysql_real_escape_string( $_REQUEST['title'] )."',
address = '".mysql_real_escape_string( $_REQUEST['address'] )."',
city = '".mysql_real_escape_string( $_REQUEST['city'] )."',
postcode = '".mysql_real_escape_string( $_REQUEST['postcode'] )."',
email = '".mysql_real_escape_string( $_REQUEST['email'] )."',
telephone = '".mysql_real_escape_string( $_REQUEST['telephone'] )."',
petname = '".mysql_real_escape_string( $_REQUEST['petname'] )."',
breed = '".mysql_real_escape_string( $_REQUEST['breed'] )."',
size = '".mysql_real_escape_string( $_REQUEST['size'] )."',
vetaddress = '".mysql_real_escape_string( $_REQUEST['vetaddress'] )."',
Monday = '".(@$_REQUEST['Monday'] ? '1' : '0')."',
Tuesday = '".(@$_REQUEST['Tuesday'] ? '1' : '0')."',
Wednesday = '".(@$_REQUEST['Wednesday'] ? '1' : '0')."',
Thursday = '".(@$_REQUEST['Thursday'] ? '1' : '0')."',
Friday = '".(@$_REQUEST['Friday'] ? '1' : '0')."',
type = '".mysql_real_escape_string( $_REQUEST['type'] )."',
date = '".mysql_real_escape_string( $_REQUEST['date'] )."',
accessinfo = '".mysql_real_escape_string( $_REQUEST['accessinfo'] )."',
otherinfo = '".mysql_real_escape_string( $_REQUEST['otherinfo'] )."',
termsandconditions = '".(@$_REQUEST['termsandconditions'] ? '1' : '0')."',
collar = '".(@$_REQUEST['collar'] ? '1' : '0')."',
offleash = '".(@$_REQUEST['offleash'] ? '1' : '0')."',
earlywalk = '".(@$_REQUEST['earlywalk'] ? '1' : '0')."',
createdDate = NOW(),
updatedDate = NOW(),
createdByUserNum = '0',
updatedByUserNum = '0'")
or die("MySQL Error Creating Record: \n". htmlspecialchars(mysql_error()) . "\n");
$recordNum = mysql_insert_id();
// send email alert
$mon = @$_REQUEST['Monday'] ? "Yes" : "No";
$tue = @$_REQUEST['Tuesday'] ? "Yes" : "No";
$wed = @$_REQUEST['Wednesday'] ? "Yes" : "No";
$thu = @$_REQUEST['Thursday'] ? "Yes" : "No";
$fri = @$_REQUEST['Friday'] ? "Yes" : "No";
$termsandconditions = @$_REQUEST['termsandconditions'] ? "Yes" : "No";
$collar = @$_REQUEST['collar'] ? "Yes" : "No";
$offleash = @$_REQUEST['offleash'] ? "Yes" : "No";
$earlywalk = @$_REQUEST['earlywalk'] ? "Yes" : "No";
$to="james@maddogsdogwalking.com.au";
$subject="A new registration form has been added to the database";
if(@$_REQUEST['info_request']){$_REQUEST['info_request']=1;}else{$_REQUEST['info_request']=0;}
$message=<<<__TEXT__
A new registration form has been added to the database. The completed form can be viewed in the CMS.
Do not reply to this email as it is automatically generated and will not be read. To contact the person who has submitted the form use the contact details below:
Pet Details
Pet Name: {$_REQUEST['petname'] }
Breed: {$_REQUEST['breed'] }
Size: {$_REQUEST['size'] }
Owner Details
Name: {$_REQUEST['title']}
Address (pick-up): {$_REQUEST['address']}, {$_REQUEST['city']}, {$_REQUEST['postcode']}
Email: {$_REQUEST['email'] }
Telephone: {$_REQUEST['telephone'] }
Vet Details: {$_REQUEST['vetaddress']}
Booking Details
Type of walk: {$_REQUEST['type']}
Commence Date: {$_REQUEST['date']}
Monday: {$mon}
Tuesday: {$tue}
Wednesday: {$wed}
Thursday: {$thu}
Friday: {$fri}
Access details: {$_REQUEST['accessinfo']}
Other info: {$_REQUEST['otherinfo']}
Terms and Conditions: {$termsandconditions}
Collar: {$collar}
Off leash: {$offleash}
Early Walk: {$earlywalk}
__TEXT__;
$from="FROM: jeff@wemakemagazines.co.uk";
mail($to,$subject,$message,$from);
// display thanks message and clear form
$successAlerts = "Thanks, we have received your registration form.";
$_REQUEST = array();
}
}
?>