Sorry - required parameters not passed.\n";
}
$sql = "select * from Sid where sid='$sid'";
$result = mysql($database, $sql);
$num = mysql_numrows($result);
if ($num == 0) {
$results = $results . "
Sorry - invalid sid.\n";
echo "$results";
exit;
}
$companyID = mysql_result($result,0,"companyID");
$sql = "select companyID from CompanyDeluxe where companyID=$companyID";
$result = mysql($database, $sql);
$num = mysql_numrows($result);
if ($num == 0) {
$results = $results . "
You must be a Seminar Deluxe member to use the online registration feature. To order your deluxe seminar listing(s) so that you can receive online orders, please click here.\n";
echo $results;
exit;
}
$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");
/* all=1 means unprocessed only */
/* all=2 means processed and unprocessed */
if ($all != "1") {
$clickall1 = "Click here to process credit card numbers for new registrations.
\n";
}
if ($all != "2") {
$clickall2 = "Click here to view all registrations.
\n";
}
if ($markProcessed) {
$sql = "update CompReg set cardNumber='', compProcessed='1' where regID=$regID";
$result = mysql($database, $sql);
$regID=0;
}
$num=0;
$sql="";
if ($regID > 0 || $search != "" || $all != "") {
$sql = "select * from CompReg where companyID=$companyID and processed=1";
if ($all != "2" && $search == "") {
$sql = $sql . " and compProcessed=''";
}
if ($regID > 0) {
$sql = $sql . " and regID=$regID";
}
if ($search) {
$criteria=0;
if ($firstNameSearch) {
$sql = $sql . " and firstName like '%$firstNameSearch%'";
$criteria=1;
}
if ($lastNameSearch) {
$sql = $sql . " and lastName like '%$lastNameSearch%'";
$criteria=1;
}
if ($organizationSearch) {
$sql = $sql . " and organization like '%$organizationSearch%'";
$criteria=1;
}
if ($seminarSearch) {
$sql = $sql . " and seminar like '%$seminarSearch%'";
$criteria=1;
}
if (!$criteria) {
$search="";
$sql="";
}
}
if (!$search) {
$firstNameSearch="";
$lastNameSearch="";
$organizationSearch="";
$seminarSearch="";
}
/* echo "'$sql'
\n"; */
if ($sql) {
$sql = $sql . " order by lastName, firstName";
$result = mysql($database, $sql);
$num = mysql_numrows($result);
}
if ($num == 0) {
if ($regID) {
$results = "
Sorry - registrant number $regID not found.\n";
}
elseif ($search != "" || $all != "") {
$results = "
Sorry - no registrations found.\n";
}
}
elseif ($num == 1) {
$results = "\n";
$lresult = mysql_Listfields($database,"CompReg");
$lnum = mysql_NumFields($lresult);
$i=0;
while ($i < $lnum) {
$Fname = mysql_FieldName($lresult,$i);
$results = $results . "| $Fname | ";
$Fval = mysql_result($result,0,"$Fname");
$results = $results . "$Fval |
|---|
\n";
$i++;
}
$results = $results . "
\n";
$results = $results . "\n";
}
else {
$results = $results . "\n";
$results = $results . "| Reg\# | First Name | Last Name | Organization | Seminar | Location/Date | ";
$results = $results . "
|---|
\n";
$i=0;
while ($i < $num) {
$regID = sprintf("%06d", mysql_result($result,$i,"regID"));
$firstName = mysql_result($result,$i,"firstName");
$lastName = mysql_result($result,$i,"lastName");
$organization = mysql_result($result,$i,"organization");
$seminar = mysql_result($result,$i,"seminar");
$locationDate = mysql_result($result,$i,"locationDate");
/* $billMe = mysql_result($result,$i,"billMe"); */
$results = $results . "| $regID | $firstName | $lastName | $organization | $seminar | $locationDate | ";
$results = $results . "
\n";
$i++;
}
$results = $results . "
\n";
}
}
$template = File("regtemp.html");
$i=0;
while ($i