\n" . "
\n" . "
\n" . $footer; } echo("$header"); */ $extrafooter = ""; if($Searchterm) { $extrafooter = "
\n" . "
\n" . "
\n"; } $Pg = (int)$Pg; if($Pg <= 0) { $Pg = 1; } $AuctionNumber = (int)$AuctionNumber; $DetailItemNumber = (int)$DetailItemNumber; trim($Searchterm); $Searchterm = str_replace(",", " ", $Searchterm); trim($Searchterm); /* require("connect_inc.php"); */ require("connect.php"); $CurrentAuctionNumber = 0; $zoekstring = "SELECT * FROM parameters WHERE ParameterName = 'CurrentAuctionNumber'"; if(!($queryresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } if($row = mysql_fetch_array($queryresult)) { $CurrentAuctionNumber = (int)$row["ParameterValue"]; } mysql_free_result($queryresult); $Anouncement = ""; $zoekstring = "SELECT * FROM parameters WHERE ParameterName = 'Anouncement'"; if(!($queryresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } if($row = mysql_fetch_array($queryresult)) { $Anouncement = $row["ParameterText"]; } mysql_free_result($queryresult); $SubAnouncement = ""; $zoekstring = "SELECT * FROM parameters WHERE ParameterName = 'SubAnouncement'"; if(!($queryresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } if($row = mysql_fetch_array($queryresult)) { $SubAnouncement = $row["ParameterText"]; } mysql_free_result($queryresult); $AuctionName = ""; $AuctionDate = ""; $AuctionInfo = ""; $CategoryName = ""; $GroupName = ""; $SessionName = ""; if($AuctionNumber) { $CategoryNumber = 0; $zoekstring = "SELECT * FROM auctions WHERE AuctionNumber = $AuctionNumber"; if(!($queryresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } if($row = mysql_fetch_array($queryresult)) { $AuctionName = $row["AuctionName"]; $AuctionDate = $row["DateText"]; $AuctionInfo = $row["InfoText"]; } mysql_free_result($queryresult); if($GroupNumber) { $zoekstring = "SELECT * FROM groups WHERE AuctionNumber = $AuctionNumber AND GroupNumber = $GroupNumber"; if(!($queryresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } if($row = mysql_fetch_array($queryresult)) { $pCategoryNumber = $row["CategoryNumber"]; $imin = $row["MinItemNumber"]; $imax = $row["MaxItemNumber"]; $SessionNumber = $row["SessionNumber"]; $zoekstring = "SELECT * FROM categories WHERE AuctionNumber = '" . $AuctionNumber . "' AND CategoryNumber = '" . $pCategoryNumber . "'"; if(!($catresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } if($catrow = mysql_fetch_array($catresult)) { $pCategoryName = $catrow["CategoryName"]; } mysql_free_result($catresult); $GroupName = "$pCategoryName, item numbers $imin-$imax"; $zoekstring = "SELECT * FROM sessions WHERE AuctionNumber = $AuctionNumber AND SessionNumber = $SessionNumber"; if(!($catresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } if($catrow = mysql_fetch_array($catresult)) { $SessionName = $catrow["SessionName"]; } mysql_free_result($catresult); } mysql_free_result($queryresult); } } else { $GroupNumber = 0; } if($CategoryNumber) { $zoekstring = "SELECT * FROM categories WHERE AuctionNumber = '" . $AuctionNumber . "' AND CategoryNumber = '" . $CategoryNumber . "'"; if(!($queryresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } if($row = mysql_fetch_array($queryresult)) { $CategoryName = $row["CategoryName"]; } mysql_free_result($queryresult); } if($AuctionNumber) { if($GroupNumber) { } else { } } else { echo("
\n"); } $zoekstring = ""; if($Searchterm) { $and = ""; $zoekstring = "SELECT * from books WHERE "; if($AuctionNumber) { $zoekstring = $zoekstring . $and; $zoekstring = $zoekstring . "AuctionNumber = $AuctionNumber"; $and = " AND "; } else { if((!($CategoryNumber)) && (!($CategoryNumber))) { $zoekstring = $zoekstring . $and; $zoekstring = $zoekstring . "AuctionNumber < $CurrentAuctionNumber"; $and = " AND "; } } if($CategoryNumber) { $zoekstring = $zoekstring . $and; $zoekstring = $zoekstring . "CategoryNumber = $CategoryNumber"; $and = " AND "; } if($GroupNumber) { $zoekstring = $zoekstring . $and; $zoekstring = $zoekstring . "GroupNumber = $GroupNumber"; $and = " AND "; } if(strlen($Searchterm) > 0){ $orlist = explode(" ", $Searchterm); $orcount = count($orlist); if($orcount >= 2) { $ori = 0; $orc = 0; while($ori <= ($orcount - 1)) { $SSearchterm = $orlist[$ori]; if($SSearchterm) { $SSearchterm = str_replace("\\", "\\\\", $SSearchterm); $SSearchterm = str_replace("'", "\'", $SSearchterm); if($orc) { $zoekstring = $zoekstring . " AND "; } else { $zoekstring = $zoekstring . $and; } $zoekstring = $zoekstring . "(Description LIKE '%$SSearchterm%' OR DescripRest LIKE '%$SSearchterm%' OR Note LIKE '%$SSearchterm%' OR NoteRest LIKE '%$SSearchterm%')"; $orc++; } $ori++; } if($orc) { $and = " AND "; } } else { $SSearchterm = str_replace("\\", "\\\\", $Searchterm); $SSearchterm = str_replace("'", "\'", $SSearchterm); $zoekstring = $zoekstring . $and . "(Description LIKE '%$SSearchterm%' OR DescripRest LIKE '%$SSearchterm%' OR Note LIKE '%$SSearchterm%' OR NoteRest LIKE '%$SSearchterm%')"; $and = " AND "; } } if(strlen($Searchterm) > 0){ $zoekstring = $zoekstring . " ORDER BY AuctionNumber,ItemNumber"; } else { $zoekstring = $zoekstring . " ORDER BY ItemNumber"; } } else { if(($AuctionNumber) && ($GroupNumber)) { $zoekstring = "SELECT * FROM books WHERE AuctionNumber = $AuctionNumber AND " . "GroupNumber = $GroupNumber ORDER BY ItemNumber"; } } if($zoekstring != "") { if($AuctionNumber) { echo("
\n");
if($AuctionNumber == $CurrentAuctionNumber) {
echo("COMING AUCTION
\n");
printf("%s\n", EscapeHTMLCodes(strtoupper($AuctionName)));
} else {
printf("AUCTION RESULTS FROM %s\n", EscapeHTMLCodes(strtoupper($AuctionName)));
}
if($SessionName != "") {
printf("
%s\n", EscapeHTMLCodes($SessionName));
}
if($GroupNumber) {
printf("
%s\n", EscapeHTMLCodes($GroupName));
}
echo("
\n");
if($AuctionNumber == $CurrentAuctionNumber) {
echo("COMING AUCTION
\n");
printf("%s\n", EscapeHTMLCodes(strtoupper($AuctionName)));
} else {
echo("RECENT AUCTION
\n");
printf("%s\n", EscapeHTMLCodes(strtoupper($AuctionName)));
}
echo("
\n");
if($AuctionNumber == $CurrentAuctionNumber) {
echo("COMING AUCTION
\n");
printf("%s\n", EscapeHTMLCodes(strtoupper($AuctionName)));
echo("
ITEM DETAIL PAGE\n");
} else {
printf("AUCTION RESULTS FROM %s\n", EscapeHTMLCodes(strtoupper($AuctionName)));
echo("
ITEM DETAIL PAGE\n");
}
echo("
<< Back to previous page
\n"); $zoekstring = "SELECT * from books WHERE AuctionNumber = " . $AuctionNumber . " AND ItemNumber = " . $DetailItemNumber; if(!($queryresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } if($row = mysql_fetch_array($queryresult)) { echo("
| \n"); $imgfn = ""; $padbr = $row["ItemNumber"]; $padlen = strlen($padbr); while($padlen < 5) { $padbr = "0" . $padbr; $padlen++; } $imgfn = ""; if($AuctionNumber) { if(file_exists("../bnitemimages/" . $AuctionNumber . "-" . $padbr . ".jpg")) { $imgfn = $AuctionNumber . "-" . $padbr . ".jpg"; } } $price1 = (string)$row["Price1"]; if(strlen($price1) >= 2) { $price1 = substr($price1, 0, (strlen($price1) - 2)); } $price1 = number_format((float)$price1,0,"","."); $price2 = (string)$row["Price2"]; if(strlen($price2) >= 2) { $price2 = substr($price2, 0, (strlen($price2) - 2)); } $price2 = number_format((float)$price2,0,"","."); $PriceSold = (string)$row["PriceSold"]; if(strlen($PriceSold) >= 2) { $PriceSold = substr($PriceSold, 0, (strlen($PriceSold) - 2)); $PriceSold = number_format((float)$PriceSold,0,"","."); } else { $PriceSold = ""; } printf("%s", EscapeHTMLCodes($row["ItemNumber"])); echo(" | \n"); echo(" \n");
if((1 == 0) && ($imgfn != "")) {
echo(" | \n");
echo("\n");
printf("%s", str_replace("¶", "", EscapeHTMLCodes($row["Description"])));
printf("%s", str_replace("¶", "", EscapeHTMLCodes($row["DescripRest"])));
echo(" ");
if((int)$row["AuctionNumber"] < 313) {
echo("(Nlg. $price1 - Nlg. $price2)");
if($PriceSold != "") {
echo(" Nlg. $PriceSold");
}
} else if((int)$row["AuctionNumber"] < 315) {
if($price1 != 0) {
echo("(Nlg. $price1 - EUR $price2)");
} else {
echo("EUR $price2");
}
if($PriceSold != "") {
echo(" Nlg. $PriceSold");
}
} else {
if(($price1 != 0) && ($price2 != 0)) {
echo("(EUR $price1 - EUR $price2)");
} else if($price1 != 0) {
echo("EUR $price1");
} else if($price2 != 0) {
echo("EUR $price2");
}
if($PriceSold != "") {
echo(" EUR $PriceSold");
}
}
echo(" ");
if($row["Note"]) {
printf("¶ %s", str_replace("¶", "", EscapeHTMLCodes($row["Note"])));
printf("%s", str_replace("¶", "", EscapeHTMLCodes($row["NoteRest"])));
}
echo(" | \n");
echo("
\n"); echo("
\n"); } mysql_free_result($queryresult); include($relpath . "close.php"); } else { //display groups //-------------- echo("
\n");
if($AuctionNumber == $CurrentAuctionNumber) {
echo("COMING AUCTION
\n");
printf("%s\n", EscapeHTMLCodes(strtoupper($AuctionName)));
echo("
ORDER OF THE SALE\n");
} else {
printf("AUCTION RESULTS FROM %s\n", EscapeHTMLCodes(strtoupper($AuctionName)));
}
echo("
\n"); $row = "dummy"; $currow = $firstrow - 1; mysql_data_seek($queryresult, $currow); while(($row) && ($currow < $lastrow)) { $row = mysql_fetch_array($queryresult); if($row){ $currow++; if($currow <= $lastrow){ echo("
| \n"); $imgfn = ""; $padbr = $row["ItemNumber"]; $padlen = strlen($padbr); while($padlen < 5) { $padbr = "0" . $padbr; $padlen++; } $imgfn = ""; if($AuctionNumber) { if(file_exists("../bnitemimages/" . $AuctionNumber . "-" . $padbr . ".jpg")) { $imgfn = $AuctionNumber . "-" . $padbr . ".jpg"; } } $price1 = (string)$row["Price1"]; if(strlen($price1) >= 2) { $price1 = substr($price1, 0, (strlen($price1) - 2)); } $price1 = number_format((float)$price1,0,"","."); $price2 = (string)$row["Price2"]; if(strlen($price2) >= 2) { $price2 = substr($price2, 0, (strlen($price2) - 2)); } $price2 = number_format((float)$price2,0,"","."); $PriceSold = (string)$row["PriceSold"]; if(strlen($PriceSold) >= 2) { $PriceSold = substr($PriceSold, 0, (strlen($PriceSold) - 2)); $PriceSold = number_format((float)$PriceSold,0,"","."); } else { $PriceSold = ""; } printf("%s", EscapeHTMLCodes($row["ItemNumber"])); echo(" | \n"); echo(" \n");
if($imgfn != "") {
echo(" | \n");
echo("\n");
printf("%s", str_replace("¶", "", EscapeHTMLCodes($row["Description"])));
printf("%s", str_replace("¶", "", EscapeHTMLCodes($row["DescripRest"])));
echo(" ");
if((int)$row["AuctionNumber"] < 313) {
echo("(Nlg. $price1 - Nlg. $price2)");
if($PriceSold != "") {
echo(" Nlg. $PriceSold");
}
} else if((int)$row["AuctionNumber"] < 315) {
if($price1 != 0) {
echo("(Nlg. $price1 - EUR $price2)");
} else {
echo("EUR $price2");
}
if($PriceSold != "") {
echo(" Nlg. $PriceSold");
}
} else {
if(($price1 != 0) && ($price2 != 0)) {
echo("(EUR $price1 - EUR $price2)");
} else if($price1 != 0) {
echo("EUR $price1");
} else if($price2 != 0) {
echo("EUR $price2");
}
if($PriceSold != "") {
echo(" EUR $PriceSold");
}
}
echo(" ");
if($row["Note"]) {
printf("¶ %s", str_replace("¶", "", EscapeHTMLCodes($row["Note"])));
printf("%s", str_replace("¶", "", EscapeHTMLCodes($row["NoteRest"])));
}
if($imgfn != "") {
echo("![](\"./images/camera.gif\") Click here to view image \n");
}
echo(" | \n");
echo("
\n"); } else { break; } } } mysql_free_result($queryresult); if($hitsteller > $rowsperpage) { echo("
\n"); echo("
\n"); } if($AuctionNumber) { if($GroupNumber) { if($AuctionNumber == $CurrentAuctionNumber) { echo("
", EscapeHTMLCodes($AuctionDate)); // echo("
\n"); printf("%s", EscapeHTMLCodes($AuctionInfo)); echo("
\n"); if($SubAnouncement != "") { echo("
\n"); echo($SubAnouncement); echo("
\n"); } echo("
\n"); echo("Conditions of sale/Verkoopvoorwaarden
\n"); echo("(Credit Card Payment not accepted)
\n"); echo("
\n"); } else { //display groups //-------------- if($AuctionNumber == $CurrentAuctionNumber) { echo("Online bidding form\n"); echo(" N.B. We sell approximately 200 items per hour
\n"); } else { printf("%s
", EscapeHTMLCodes($AuctionInfo)); } // $zoekstring = "SELECT * FROM groups WHERE AuctionNumber = $AuctionNumber ORDER BY GroupNumber"; $zoekstring = "SELECT * FROM groups WHERE AuctionNumber = $AuctionNumber ORDER BY MinItemNumber"; if(!($queryresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } $pLastSessionNumber = 0; echo("
| \n");
printf(" %s \n", EscapeHTMLCodes($pSessionName)); echo(" | \n");
echo("\n"); echo(" | \n"); echo("
| \n"); printf("%s\n", EscapeHTMLCodes($pCategoryName)); echo(" | \n"); echo("\n"); printf("%s-%s\n", $imin, $imax); echo(" | \n"); echo("
\n", EscapeHTMLCodes($pDateText)); } mysql_free_result($queryresult); $zoekstring = "SELECT * FROM auctions WHERE AuctionNumber < $CurrentAuctionNumber ORDER BY AuctionNumber"; if(!($queryresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } $hitsteller = mysql_num_rows($queryresult); if($hitsteller >= 1) { if($Anouncement) { echo("
\n"); printf("%s", SFormatting(EscapeHTMLCodes($Anouncement))); echo("
\n"); } echo("
\n"); echo("Browse our most recent auction catalogues including sale results:
\n"); while($row = mysql_fetch_array($queryresult)) { $pAuctionNumber = $row["AuctionNumber"]; $pAuctionName = $row["AuctionName"]; printf("" . "%s
\n", EscapeHTMLCodes($pAuctionName)); } echo("\n"); } mysql_free_result($queryresult); $zoekstring = "SELECT * FROM auctions WHERE AuctionNumber > $CurrentAuctionNumber ORDER BY AuctionNumber"; if(!($queryresult = mysql_query($zoekstring, $sock))){ include($relpath . "close.php"); } $hitsteller = mysql_num_rows($queryresult); if($hitsteller >= 1) { echo("
\n"); echo("View future auctions:
\n"); while($row = mysql_fetch_array($queryresult)) { $pAuctionNumber = $row["AuctionNumber"]; $pAuctionName = $row["AuctionName"]; printf("" . "%s
\n", EscapeHTMLCodes($pAuctionName)); } } mysql_free_result($queryresult); } } } include($relpath . "close.php"); ?>