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 {
$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");
$sql = "insert into Seminar values ('', $companyID, '$seminar', $eduTypeID, $major1TopicID, $major2TopicID, '', '', '$keywords', '$phone', '$email', '$url', 0, '$now', '$description', '', 0, 0, 0)";
/* echo "$sql
\n"; */
$result = mysql($database, $sql);
$seminarID = mysql_insert_id();
$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 = "