\n"; }
if (!@$_REQUEST['attendee_number'] && !@$_REQUEST['last_name']) { $errorsAndAlerts .= "You must enter your Last Name \n"; }
if (!@$_REQUEST['attendee_number'] && !@$_REQUEST['email_address']) { $errorsAndAlerts .= "You must enter your E-mail Address \n"; }
else if(!@$_REQUEST['attendee_number'] && !isValidEmail(@$_REQUEST['email_address'])) { $errorsAndAlerts .= "Please enter a valid E-mail address (example: user@example.com) \n"; }
$count = mysql_select_count_from('attendance_test', "'".mysql_escape($_REQUEST['email_address'])."' IN (email_address)");
$count2 = mysql_select_count_from('attendance_test', "'".mysql_escape($_REQUEST['attendee_number'])."' IN (num)");
if (!@$count2 != 0) { $errorsAndAlerts .= "Sorry, the Attendee ID Number you entered, doesn't match our records, please try again or entrer your name and email address. \n"; } ?>
\n". htmlspecialchars(mysql_error()) . "\n");
$userNum = mysql_insert_id();
// on success
unset($_REQUEST['first_name'], $_REQUEST['last_name'], $_REQUEST['email_address']); // clear form
$errorsAndAlerts = "Thanks, we've signed you in, and we're ready for the next guest.";
}
// Check for first name, last name, and duplicate email address. Update record if email address is found.
if (!@$_REQUEST['attendee_number'] && $count > 0 && !$errorsAndAlerts) {
@$_REQUEST['first_name']=ucwords(@$_REQUEST['first_name']);
@$_REQUEST['last_name']=ucwords(@$_REQUEST['last_name']);
$lecturedate = date("m-Y, ") ;
$query = "UPDATE `{$TABLE_PREFIX}attendance_test` SET
first_name = '".mysql_escape( $_REQUEST['first_name'] )."',
last_name = '".mysql_escape( $_REQUEST['last_name'] )."',
salon_name = 'MMM',
mmm_attended = CONCAT(mmm_attended, '$lecturedate'),
updatedByUserNum = '".mysql_escape( $CMS_USER['num'] )."',
updatedDate = NOW()
WHERE email_address = '".mysql_escape( $_REQUEST['email_address'] )."'";
mysql_query($query) or die("MySQL Error: \n". htmlspecialchars(mysql_error()) . "\n");
$userNum = mysql_insert_id();
// on success
unset($_REQUEST['first_name'], $_REQUEST['last_name'], $_REQUEST['email_address']); // clear form
$errorsAndAlerts = "Thanks, we've signed you in, and we're ready for the next guest.";
}
// Check for attendee ID number. Update record if ID number is found.
if (@$_REQUEST['attendee_number'] && !$errorsAndAlerts) {
$lecturedate = date("m-Y, ") ;
$query = "UPDATE `{$TABLE_PREFIX}attendance_test` SET
salon_name = 'MMM',
mmm_attended = CONCAT(mmm_attended, '$lecturedate'),
updatedByUserNum = '".mysql_escape( $CMS_USER['num'] )."',
updatedDate = NOW()
WHERE num = '".mysql_escape( $_REQUEST['attendee_number'] )."'";
// Placeholder variable which should pull the attendees first name from the updated record.
$first_name = 'ATTENDEE\'S FIRST NAME' ;
mysql_query($query) or die("MySQL Error: \n". htmlspecialchars(mysql_error()) . "\n");
$userNum = mysql_insert_id();
// on success
unset($_REQUEST['attendee_number'], $_REQUEST['first_name'], $_REQUEST['last_name'], $_REQUEST['email_address']); // clear form
// Should insert attendee's first_name in the $first _name variable.
$errorsAndAlerts = "Thanks, $first_name we've signed you in, and we're ready for the next guest.";
}
}
/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/hsphere/local/home/a887307/elleschorrphotography.com/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
// load records
list($attendance_testRecords, $attendance_testMetaData) = getRecords(array(
'tableName' => 'attendance_test',
));
?>
Mixed / Multi-Media Salon Sign In