include "../admin/connect.php3";
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"; */
$sql = "select * from Seminar 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");
} elseif ($num > 0 && $submit) {
$SeminarDeluxeID = mysql_result($result,0,"SeminarDeluxeID");
}
}
}
}
}
if ($submit) {
if (!$errors) {
/* echo "hello";exit; */
$now = Date("Y-m-d h:m:s");
if (!$seminarID) {
$sql = "insert into Seminar (SeminarDeluxeID, seminarID,courseObjectives,summary,audience,instructorBio,topics,price,schedule,registrationNumber,accreditation,dateModified,open,image,upsize,active,processed)values ('', $seminarID, '$courseObjectives', '$summary', '$audience', '$instructorBio', '$topics', '$price', '$schedule', '$registrationNumber', '$accreditation', '$now', 0, '', '', 0, 0)";
}
else {
# if ($SeminarDeluxeID == 0) {
# $q = "select SeminarDeluxeID from Seminar order by SeminarDeluxeID desc";
# $aResult = mysql($database, $q);
# $aNum = mysql_numrows($aResult);
# if ($aNum > 0) {
# $SeminarDeluxeID = mysql_result($aResult,0,"SeminarDeluxeID");
# $SeminarDeluxeID++;
# $sql = "update Seminar set SeminarDeluxeID='$SeminarDeluxeID', courseObjectives='$courseObjectives', summary='$summary', audience='$audience', instructorBio='$instructorBio', topics='$topics', price='$price', schedule='$schedule', registrationNumber='$registrationNumber', accreditation='$accreditation', dateModified='$now' where seminarID=$seminarID";
# } else {
# $sql = "update Seminar set courseObjectives='$courseObjectives', summary='$summary', audience='$audience', instructorBio='$instructorBio', topics='$topics', price='$price', schedule='$schedule', registrationNumber='$registrationNumber', accreditation='$accreditation', dateModified='$now' where seminarID=$seminarID";
# }
# } else {
$sql = "update Seminar set courseObjectives='$courseObjectives', summary='$summary', audience='$audience', instructorBio='$instructorBio', topics='$topics', price='$price', schedule='$schedule', registrationNumber='$registrationNumber', accreditation='$accreditation', dateModified='$now' where seminarID=$seminarID";
# }
}
/* echo $sql; exit; */
$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.php3?sid=$sid&message=$encMessage\n\n");
exit;
}
}
if ($errors) {
$errors = "