1 or $num = 0 */
if ($num == 1) {
$companyID = mysql_result($result,0,"companyID");
/* get current sid counter */
$sresult = mysql($database, "SELECT * FROM SidCounter");
$sid = 0 + mysql_result($sresult,$c,"sidID");
/* reset the SID at 999 */
if (($sid > 999) || ($sid < 0)) { $sid = 0; }
/* increment SID by 1 and update it in the table. */
$sid = $sid + 1;
$sresult = mysql($database, "UPDATE SidCounter SET sidID = $sid");
if ( mysql_affected_rows() == 0 ) {
$sresult = mysql($database, "INSERT INTO SidCounter VALUES ('1')");
}
$sid = "" + $sid + getMyPid();
$now = Date("YmdHis");
$sql = "insert into Sid values ('', '$sid', '$companyID', NULL, '$now')";
$sresult = mysql($database, $sql);
}
}
/* if no $sid yet, ask for email/password (from template), and exit */
if (!$sid) {
$template = File("logontemp.html");
$i=0;
while ($i
Sorry - invalid sid.\n";
}
$companyID = mysql_result($result,0,"companyID");
$sql = "select * from Company where companyID=$companyID";
$result = mysql($database, $sql);
$num = mysql_numrows($result);
if ($num == 0) {
$results = $results + "
Sorry - invalid companyID.\n";
}
$company = mysql_result($result,0,"company");
$numSeminars = mysql_result($result,0,"numSeminars");
$sql = "select * from Seminar where companyID=$companyID";
$sresult = mysql($database, $sql);
$snum = mysql_numrows($sresult);
$numSeminarsLeft = $numSeminars - $snum;
$template = File("indextemp.html");
$i=0;
while ($i