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 {
$numSeminars = mysql_result($result,0,"numSeminars");
$sql = "select * from Seminar where companyID=$companyID";
$sresult = mysql($database, $sql);
$snum = mysql_numrows($sresult);
$numSeminarsLeft = $numSeminars - $snum;
if ($numSeminarsLeft <= 0) {
$errors = "Sorry - You need to purchase more basic seminar listings
in order to post any more seminars.";
}
}
}
}
if ($submit != "" && $numSeminarsLeft > 0) {
$tok = strtok ($required, ",");
while ($tok) {
if (!$$tok) {
$req[] = $tok;
$missing = 1;
}
$tok = strtok (",");
}
if ($missing) {
$errors = "The following fields are mandatory:\n
\n
\n\n";
$i=0;
while ($req[$i]) {
$errors = $errors . "- $req[$i]\n";
$i++;
}
$errors = $errors . "
\n |
\n";
}
if ($major2TopicID == "") { $major2TopicID = 0; }
if ($email) {
$testemail = exec("../cgi-local/validateemail.cgi '$email'");
if (!$testemail) {
$errors = $errors . "Invalid email address format.\n";
}
}
if (!$errors) {
$now = Date("Y-m-d h:m:s");
# $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++;
# }
$SeminarDeluxeID = 0;
$seminar = eregi_replace("'","\'",$seminar);
$keywords = eregi_replace("'","\'",$keywords);
$phone = eregi_replace("'","\'",$phone);
$email = eregi_replace("'","\'",$email);
$url = eregi_replace("'","\'",$url);
$now = eregi_replace("'","\'",$now);
$description = eregi_replace("'","\'",$description);
$audience = eregi_replace("'","\'",$audience);
$price = eregi_replace("'","\'",$price);
$schedule = eregi_replace("'","\'",$schedule);
$registrationNumber = eregi_replace("'","\'",$registrationNumber);
$accreditation = eregi_replace("'","\'",$accreditation);
$open = eregi_replace("'","\'",$open);
$image = eregi_replace("'","\'",$image);
$upsize = eregi_replace("'","\'",$upsize);
$topics = eregi_replace("'","\'",$topics);
$summary = eregi_replace("'","\'",$summary);
$courseObjectives = eregi_replace("'","\'",$courseObjectives);
$instructorBio = eregi_replace("'","\'",$instructorBio);
$SeminarDeluxeID = eregi_replace("'","\'",$SeminarDeluxeID);
$sql = "insert into Seminar (seminarID,companyID,seminar,eduTypeID,major1TopicID,major2TopicID,otherMinor1,otherMinor2,keywords,phone,email,url,active,dateEntered,description,dateModified,processed,minor1TopicID,minor2TopicID,audience, price, schedule, registrationNumber, accreditation, open, image, upsize, topics, summary, courseObjectives, instructorBio, SeminarDeluxeID, deluxeActive) values ('', $companyID, '$seminar', $eduTypeID, $major1TopicID, $major2TopicID, '', '', '$keywords', '$phone', '$email', '$url', 0, '$now', '$description', '', 0, 0, 0, '$audience', '$price', '$schedule', '$registrationNumber', '$accreditation', '$open', '$image', '$upsize', '$topics', '$summary', '$courseObjectives', '$instructorBio', '$SeminarDeluxeID', 0)";
# echo "$sql
\n";
$result = mysql($database, $sql);
$seminarID = mysql_insert_id();
# echo "result=$result, semid=$seminarID";
$sql = "select eduType from EduType where eduTypeID=$eduTypeID";
$result = mysql($database, $sql);
$eduType = mysql_result($result,0,"eduType");
if ($eduType != "Private" && $eduType != "Web Based Training") {
$dateslink = ", or here to add public dates for this seminar";
}
$template = File("addcourse2temp.html");
$i=0;
while ($i" . mysql_result($result,$i,"eduType") . "\n";
$i++;
}
$major1Topics = "