'menu_new', 'allowSearch' => '0', 'limit' => '1', )); $menu_newRecord = @$menu_newRecords[0]; // get first record list($directories_menuRecords, $directories_menuMetaData) = getRecords(array( 'tableName' => 'directories_menu', )); list($publicationsmenuRecords, $publicationsmenuMetaData) = getRecords(array( 'tableName' => 'publicationsmenu', )); list($globalRecords, $globalMetaData) = getRecords(array( 'tableName' => 'global', 'allowSearch' => '0', 'limit' => '1', )); $globalRecord = @$globalRecords[0]; // get first list($directory_membershipRecords, $directory_membershipMetaData) = getRecords(array( 'tableName' => 'directory_membership', 'allowSearch' => false, 'limit' => '1', )); $directory_membershipRecord = @$directory_membershipRecords[0]; // get first record //checkbox list($days_dirRecords) = getRecords(array( 'tableName' => 'days_dir', 'loadUploads' => true, 'allowSearch' => false, )); list($dir_categoriesRecords, $dir_categoriesMetaData) = getRecords(array( 'tableName' => 'dir_categories', 'where' => 'include = 0', )); // This form requires: CMSB v2.04 Build 1 require_once "C:/Inetpub/charlotteparent/cmsAdmin/lib/viewer_functions.php"; $tableName = 'dir_listings'; $recordNum = null; // you must set either $recordNum or $preSaveTempId to null $preSaveTempId = @$_REQUEST['preSaveTempId'] ? $_REQUEST['preSaveTempId'] : uniqid('x'); $errorsAndAlerts = ''; ### upload actions if (@$_REQUEST['submitForm'] && !preg_match("/multipart\/form-data/", @$_SERVER['CONTENT_TYPE'])) { die("Upload Error: <form> tag must have enctype=\"multipart/form-data\""); } foreach (getUploadInfoArrays() as $uploadInfo) { // add uploads $errorsAndAlerts .= saveUpload($tableName, $uploadInfo['_fieldname'], $recordNum, $preSaveTempId, $uploadInfo, $newUploadNums); } if (@$_REQUEST['removeUpload']) { // delete upload $uploadNum = @$_REQUEST['removeUpload']; removeUpload($uploadNum, $recordNum, $preSaveTempId); } ### insert record $onlyUploadAction = @$_REQUEST['submitUpload'] || @$_REQUEST['removeUpload']; // don't save the record when the user uploads a file if (@$_REQUEST['submitForm'] && !$onlyUploadAction) { // error checking if (!@$_REQUEST['category']) { $errorsAndAlerts .= "*Required: Please select a category!
\n"; } if (!@$_REQUEST['title']) { $errorsAndAlerts .= "*Required: Please specify a title!
\n"; } if (!@$_REQUEST['address']) { $errorsAndAlerts .= "*Required: Please specify a address!
\n"; } if (!@$_REQUEST['website']) { $errorsAndAlerts .= "*Required: Please specify a website!
\n"; } if (!@$_REQUEST['phone']) { $errorsAndAlerts .= "*Required: Please specify a listing phone number!
\n"; } if (!@$_REQUEST['county']) { $errorsAndAlerts .= "*Required: Please specify a county!
\n"; } if (!@$_REQUEST['summary']) { $errorsAndAlerts .= "*Required: Please enter a description!
\n"; } if (!@$_REQUEST['contact_name']) { $errorsAndAlerts .= "*Required: Please specify a contact name!
\n"; } if (!@$_REQUEST['email_address']) { $errorsAndAlerts .= "*Required: Please specify an contact e-mail address!
\n"; } if (!@$_REQUEST['contact_phone']) { $errorsAndAlerts .= "*Required: Please specify a contact phone number!
\n"; } if (@$_REQUEST['category'] == "Family Dining") if (!@$_REQUEST['eat_free']) { $errorsAndAlerts .= "*Required: Kids Eat Free: Please specify Yes or No!
\n"; } // setup checkbox days if(isset($_REQUEST['days'])) { $days_TSV = "\t" . implode("\t", $_REQUEST['days'] ) . "\t"; } else { $days_TSV = ""; } // update record if (!@$errorsAndAlerts) { mysqlStrictMode(false); // disable Mysql strict errors for when a field isn't defined below (can be caused when fields are added later) $query = "INSERT INTO `{$TABLE_PREFIX}$tableName` SET createdDate = NOW(), createdByUserNum = '" .intval( @$CURRENT_USER['num'] ). "', updatedDate = NOW(), updatedByUserNum = '" .intval( @$CURRENT_USER['num'] ). "', publishDate = NOW(), date = NOW(), hidden = '1', reg_listing = '1', url_link = '0', neverRemove = '1', days = '". @$days_TSV ."', category = '" .mysql_escape( @$_REQUEST['category'] ). "', contact_name = '".mysql_escape(@$_REQUEST['contact_name'])."', contact_phone = '".mysql_escape(@$_REQUEST['contact_phone'])."', title = '".mysql_escape(@$_REQUEST['title'])."', website = '".mysql_escape(@$_REQUEST['website'])."', address = '".mysql_escape(@$_REQUEST['address'])."', city = '".mysql_escape(@$_REQUEST['city'])."', state = '".mysql_escape(@$_REQUEST['state'])."', zipcode = '".mysql_escape(@$_REQUEST['zipcode'])."', phone = '".mysql_escape(@$_REQUEST['phone'])."', summary = '".mysql_escape(@$_REQUEST['summary'])."', email_address = '".mysql_escape(@$_REQUEST['email_address'])."', county = '".mysql_escape(@$_REQUEST['county'])."', ages = '".mysql_escape(@$_REQUEST['ages'])."', fees = '".mysql_escape(@$_REQUEST['fees'])."', eat_free = '".mysql_escape(@$_REQUEST['eat_free'])."', hours = '".mysql_escape(@$_REQUEST['hours'])."'"; mysql_query($query) or die("MySQL Error:
\n". htmlspecialchars(mysql_error()) . "\n"); $recordNum = mysql_insert_id(); // adopt temp uploads adoptUploads($tableName, $preSaveTempId, $recordNum); removeExpiredUploads(); // erase old expired uploads // display thanks message and clear form $errorsAndAlerts = "Thanks, we've added your record!"; $preSaveTempId = uniqid('x'); $recordNum = null; // send message to admin $placeholders = array( 'user.email' => $_REQUEST['email_address'], 'user.fullname' => $_REQUEST['contact_name'], 'category' => $_REQUEST['category'], 'title' => $_REQUEST['title'], 'summary' => $_REQUEST['summary'], 'directoryAdminUrl' => $GLOBALS['SETTINGS']['adminUrl'] . "?menu=dir_listings", ); // email admin $errors = sendMessage(wsc_emailTemplate_loadFromDB(array( 'template_id' => 'DIRECTORY-ENTRY-ADDED', 'placeholders' => $placeholders, ))); if ($errors) { die("Error sending message: $errors\n\nPlease let us know about this error!"); } // send message to user $placeholders = array( 'user.email' => $_REQUEST['email_address'], 'user.fullname' => $_REQUEST['contact_name'], 'contact_phone' => $_REQUEST['contact_phone'], 'category' => $_REQUEST['category'], 'title' => $_REQUEST['title'], 'website' => $_REQUEST['website'], 'address' => $_REQUEST['address'], 'city' => $_REQUEST['city'], 'state' => $_REQUEST['state'], 'zipcode' => $_REQUEST['zipcode'], 'phone' => $_REQUEST['phone'], 'county' => $_REQUEST['county'], 'summary' => $_REQUEST['summary'], 'ages' => $_REQUEST['ages'], 'fees' => $_REQUEST['fees'], 'eat_free' => $_REQUEST['eat_free'], 'hours' => $_REQUEST['hours'], ); // email user $errors = sendMessage(wsc_emailTemplate_loadFromDB(array( 'template_id' => 'DIRECTORY-ENTRY-USER', 'placeholders' => $placeholders, ))); if ($errors) { die("Error sending message: $errors\n\nPlease let us know about this error!"); } } } ?> <?php echo $directory_membershipRecord['page_title'] ?>

Free directory Listing Form

divider



* = Required

- Select a Category


*Category:

- Listing Details


*Listing Name:
*Website:
*Address:
City:
State:
Zipcode:
*Phone:
*County:
*Brief Description:

35 word limit. You have words left.

Ages:
Fees:
*Kids Eat Free:
Hours:
Days of Week:
name="days[]" /> 


- Contact Details

This information is used for internal purposes only and will not be published.
*Contact Name:
*Contact Email:
*Contact Phone: