'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 list($dir_categoriesRecords, $dir_categoriesMetaData) = getRecords(array( 'tableName' => 'dir_categories', )); // 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['title']) { $errorsAndAlerts .= "*Required: Please specify a title!
\n"; } if (!@$_REQUEST['address']) { $errorsAndAlerts .= "*Required: Please specify a address!
\n"; } if (!@$_REQUEST['url']) { $errorsAndAlerts .= "*Required: Please specify a website!
\n"; } if (!@$_REQUEST['phone']) { $errorsAndAlerts .= "*Required: Please specify a phone number!
\n"; } if (!@$_REQUEST['county']) { $errorsAndAlerts .= "*Required: Please specify a county!
\n"; } if (!@$_REQUEST['county']) { $errorsAndAlerts .= "*Required: Please specify a county!
\n"; } if (!@$_REQUEST['summary']) { $errorsAndAlerts .= "*Required: Please enter a description!
\n"; } if (!@$_REQUEST['email_address']) { $errorsAndAlerts .= "*Required: Please specify an e-mail address!
\n"; } if (!@$_REQUEST['contact_phone']) { $errorsAndAlerts .= "*Required: Please specify a phone number!
\n"; } if (@$_REQUEST['category'] == "Family Dining") if (!@$_REQUEST['eat_free']) { $errorsAndAlerts .= "*Required: Please specify Yes or No!
\n"; } // 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', category = '" .mysql_escape( @$_REQUEST['category'] ). "', contact_name = '".mysql_escape(@$_REQUEST['contact_name'])."', contact_phone = '".mysql_escape(@$_REQUEST['contact_phone'])."', title = '".mysql_escape(@$_REQUEST['title'])."', 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'])."', program_ed = '".mysql_escape(@$_REQUEST['program_ed'])."', days = '".mysql_escape(@$_REQUEST['days'])."', url = '".mysql_escape(@$_REQUEST['url'])."'"; 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 $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 $placeholders = array( 'user.email' => $_REQUEST['email_address'], 'user.fullname' => $_REQUEST['contact_name'], 'category' => $_REQUEST['category'], 'title' => $_REQUEST['title'], 'summary' => $_REQUEST['summary'], ); // email admin $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

- Listing Details


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

35 word limit. You have words left.

35 word limit.


- Select a Category:


*Category:


- Other


*Contact Name:
*Contact Email:
*Contact Phone: