include "../admin/connect.phtml";
if (!$sid) {
$errors = "Sorry - required parameters not passed.";
}
else {
$sql = "select * from Sid where sid='$sid'";
$result = mysql($database, $sql);
$num = mysql_numrows($result);
if ($num == 0) {
$errors = "Sorry - invalid sid.";
}
else {
$companyID = mysql_result($result,0,"companyID");
$sql = "select * from Company where companyID=$companyID";
$result = mysql($database, $sql);
$num = mysql_numrows($result);
if ($num == 0) {
$errors = "Sorry - invalid companyID.";
}
else {
$company = mysql_result($result,0,"company");
$sql = "select * from Seminar where seminarID=$seminarID and companyID=$companyID";
$result = mysql($database, $sql);
$num = mysql_numrows($result);
if ($num == 0) {
$errors = "Sorry - seminar and company do not match.";
}
else {
$sql = "select * from SeminarDeluxe where seminarID=$seminarID";
$result = mysql($database, $sql);
$num = mysql_numrows($result);
if ($num > 0 && !$submit) {
$seminarDeluxeID = mysql_result($result,0,"seminarDeluxeID");
$courseObjectives = mysql_result($result,0,"courseObjectives");
$summary = mysql_result($result,0,"summary");
$audience = mysql_result($result,0,"audience");
$instructorBio = mysql_result($result,0,"instructorBio");
$price = mysql_result($result,0,"price");
$schedule = mysql_result($result,0,"schedule");
$registrationNumber = mysql_result($result,0,"registrationNumber");
$accreditation = mysql_result($result,0,"accreditation");
$topics = mysql_result($result,0,"topics");
}
}
}
}
}
if ($submit) {
if (!$errors) {
$now = Date("Y-m-d h:m:s");
if (!$seminarDeluxeID) {
$sql = "insert into SeminarDeluxe values ('', $seminarID, '$courseObjectives', '$summary', '$audience', '$instructorBio', '$topics', '$price', '$schedule', '$registrationNumber', '$accreditation', '$now', 0, '', '', '', 0, 0)";
}
else {
$sql = "update SeminarDeluxe set courseObjectives='$courseObjectives', summary='$summary', audience='$audience', instructorBio='$instructorBio', topics='$topics', price='$price', schedule='$schedule', registrationNumber='$registrationNumber', accreditation='$accreditation', dateModified='$now' where seminarDeluxeID=$seminarDeluxeID";
}
$result = mysql($database, $sql);
$message = "Thank you! Your seminar deluxe listing has been successfully submitted.
Please allow up to 3 days for approval.";
$encMessage = UrlEncode($message);
Header("Location: ./seminars.phtml?sid=$sid&message=$encMessage\n\n");
exit;
}
}
if ($errors) {
$errors = "