\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('salon_listings', "'".mysql_escape($_REQUEST['email_address'])."' IN (email_address)");
$count2 = mysql_select_count_from('salon_listings', "'".mysql_escape($_REQUEST['attendee_number'])."' IN (num)");
if (@$_REQUEST['attendee_number'] && @$count2 != 1) { $errorsAndAlerts .= "Sorry, the Attendee ID Number you entered, doesn't match our records, please try again or enter your name and email address. \n"; } ?>
\n". htmlspecialchars(mysql_error()) . "\n");
$userNum = mysql_insert_id();
// on success
$first_name = $_REQUEST['first_name'] ;
$last_name = $_REQUEST['last_name'] ;
$email_address = $_REQUEST['email_address'] ;
$welcome_email = '1';
unset($_REQUEST['first_name'], $_REQUEST['last_name'], $_REQUEST['email_address']
); // clear form
$errorsAndAlerts = "Thanks $first_name, 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) {
$email_address = $_REQUEST['email_address'] ;
@$_REQUEST['first_name']=ucwords(@$_REQUEST['first_name']);
@$_REQUEST['last_name']=ucwords(@$_REQUEST['last_name']);
$lecturedate = date("m-y").'AWC, ' ;
list($salon_listingsRecords, $salon_listingsMetaData) = getRecords(array(
'tableName' => 'salon_listings',
'where' => "email_address = '$email_address'",
));
?>
$updatedValue));
// remove "NONE" since we're adding a salon_name
$my_var1 = mysql_get('salon_listings',$recnumber2);
function removeValueFromListValues($values, $removeValue){
if(strstr($values, "\t$removeValue\t")){
return $updatedValue = str_replace($removeValue."\t",'', $values);
}else{
return $values;
}
}
$updatedValue = removeValueFromListValues($my_var1['salon_name'],'3');
mysql_update('salon_listings',$recnumber2, null, array('salon_name' => $updatedValue));
mysql_query($query) or die("MySQL Error: \n". htmlspecialchars(mysql_error()) . "\n");
$userNum = mysql_insert_id();
// on success
$first_name = $_REQUEST['first_name'] ;
unset($_REQUEST['first_name'], $_REQUEST['last_name'], $_REQUEST['email_address']); // clear form
$errorsAndAlerts = "Thanks $first_name, 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").'AWC, ' ;
$query = "UPDATE `{$TABLE_PREFIX}salon_listings` SET
attended = CONCAT(attended, '$lecturedate'),
updatedByUserNum = '".mysql_escape( $CMS_USER['num'] )."',
updatedDate = NOW()
WHERE num = '".mysql_escape( $_REQUEST['attendee_number'] )."'";
$recnumber = mysql_escape(@$_REQUEST['attendee_number']);
// Add "AWC" (1) to the list if it's not already there.
$my_var = mysql_get('salon_listings',$recnumber);
function addValueToListValues($values, $newValue){
if(!strstr($values, "\t$newValue\t")){
return $updatedValue = $values.$newValue."\t";
}else{
return $values;
}
}
$updatedValue = addValueToListValues($my_var['salon_name'],'1');
mysql_update('salon_listings',$recnumber, null, array('salon_name' => $updatedValue));
$my_var1 = mysql_get('salon_listings',$recnumber);
// remove "NONE" since we're adding a salon_name
function removeValueFromListValues($values, $removeValue){
if(strstr($values, "\t$removeValue\t")){
return $updatedValue = str_replace($removeValue."\t",'', $values);
}else{
return $values;
}
}
$updatedValue = removeValueFromListValues($my_var1['salon_name'],'3');
mysql_update('salon_listings',$recnumber, null, array('salon_name' => $updatedValue));
// Get the attendee's first name from the updated record.
$loggedInUser = mysql_get('salon_listings', $_REQUEST['attendee_number']);
$first_name = @$loggedInUser['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
$errorsAndAlerts = "Thanks $first_name. We've signed you in, and we're ready for the next guest.";
}
}
// 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($salon_listingsRecords, $salon_listingsMetaData) = getRecords(array(
'tableName' => 'salon_listings',
));
// load record from 'salon_messages'
list($salon_messagesRecords, $salon_messagesMetaData) = getRecords(array(
'tableName' => 'salon_messages',
'where' => '', // load first record
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$salon_messagesRecord = @$salon_messagesRecords[0]; // get first record
?>
Art, Women, and Culture Salon Sign In