'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($photocontests_newRecords, $photocontests_newMetaData) = getRecords(array(
'tableName' => 'photocontests_new',
));
list($photocontests_mainRecords, $photocontests_mainMetaData) = getRecords(array(
'tableName' => 'photocontests_main',
'allowSearch' => '0',
'limit' => '1',
));
$photocontests_mainRecord = @$photocontests_mainRecords[0]; // get first record
list($photocontests_catRecords, $photocontests_catMetaData) = getRecords(array(
'tableName' => 'photocontests_cat',
));
list($photocontests_listRecords, $photocontests_listMetaData) = getRecords(array(
'tableName' => 'photocontests_list',
));
list($linkRecords, $linkMetaData) = getRecords(array(
'tableName' => 'photocontests_new',
));
$linkRecord = @$linkRecords[0]; // get first record
list($ros_adsRecords, $ros_adsMetaData) = getRecords(array(
'tableName' => 'ros_ads',
'allowSearch' => '0',
'limit' => '1',
));
$ros_adsRecord = @$ros_adsRecords[0]; // get first record
list($globalRecords, $globalMetaData) = getRecords(array(
'tableName' => 'global',
'allowSearch' => '0',
'limit' => '1',
));
$globalRecord = @$globalRecords[0]; // get first record
// This form requires: CMSB v2.04 Build 1
require_once "C:/Inetpub/charlotteparent/cmsAdmin/lib/viewer_functions.php";
$tableName = 'photocontests_new';
$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['name']) { $errorsAndAlerts .= "*Required: Please specify a name!
\n"; }
if (!@$_REQUEST['title']) { $errorsAndAlerts .= "*Required: Please specify a title!
\n"; }
if (!@$_REQUEST['email']) { $errorsAndAlerts .= "*Required: Please specify an e-mail address!
\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'] ). "',
date = NOW(),
hidden = '1',
name = '".mysql_escape(@$_REQUEST['name'])."',
content = '".mysql_escape(@$_REQUEST['content'])."',
email = '".mysql_escape(@$_REQUEST['email'])."',
category = '" .mysql_escape( @$_REQUEST['category'] ). "',
title = '".mysql_escape( $_REQUEST['title'] )."'";
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!";
$_REQUEST = array();
$preSaveTempId = uniqid('x');
$recordNum = null;
// send message
$placeholders = array(
'user.email' => $_REQUEST['email'],
'user.fullname' => $_REQUEST['name'],
'content' => $_REQUEST['content'],
'contestAdminUrl' => $GLOBALS['SETTINGS']['adminUrl'] . "?menu=calendar&action=edit&num=" . mysql_insert_id(),
);
// email admin
$errors = sendMessage(wsc_emailTemplate_loadFromDB(array(
'template_id' => 'ADMIN-ENTRY-ADDED',
'placeholders' => $placeholders,
)));
if ($errors) { die("Error sending message: $errors\n\nPlease let us know about this error!"); }
}
}
?>
<?php echo $photocontests_mainRecord['page_title'] ?>
