<%
if ($type == 2) {
%>
<%
} else {
%>
<%
}
%>
Search the vehicle list by using ctrl & F.
Columns are sortable by lot, year, make or model by clicking on the yellow heading.
|
<%
if ($type == 2) {
%>
Silver Scale -
How cars are evaluated by Silver Auctions on a scale from 1 to
5
-
Perfect - Either showroom-new
or in competitive judging would defeat all others in its class.
-
Excellent - Fully restored
or an outstanding original. Has the appearance of a
car only 1-2 yrs old.
-
Very Good - A typical
newer car that you see driven daily on the street. From
a distance of 15ft, only minor flaws are visible.
-
Fair - Vehicle is presentable
and OK in most aspects, but needs some work.
-
Restorable - Vehicle
runs, and is mostly complete but rough throughout. You
would not want it parked in front of your house.
<%
} else {
%>
<%
}
%>
|
| Lot |
Year |
Make |
Model |
Description |
<%
if ($type == 2) {
%>
Cond |
Bid Result |
Reserve |
Status |
<%
}
%>
Details |
<%
switch($sort) {
case "make":
case "model":
case "year":
$sqlQ = "SELECT el.* FROM event_lotdata el, event_cardata ec WHERE (el.flags != 1) AND el.eventid = '".RQ($id)."' AND el.id = ec.lotid AND fieldname = '".RQ($sort)."' ORDER BY fieldvalue";
break;
case "lot":
$sqlQ = "SELECT * FROM event_lotdata WHERE eventid = '".RQ($id)."' AND (flags != 1) ORDER BY lotnumber";
default:
$sqlQ = "SELECT * FROM event_lotdata WHERE eventid = '".RQ($id)."' AND (flags != 1) ORDER BY lotnumber";
break;
}
//$sqlQ = "SELECT el.* FROM event_lotdata el, event_cardata ec WHERE el.eventid = '".RQ($id)."' AND el.id = ec.lotid AND fieldname = 'make' ORDER BY fieldvalue";
$DBObj->query($sqlQ,$rCnt);
$cntr = 0;
while($rsLoop = $DBObj->getrow()) {
$sqlQ = "SELECT fieldname,fieldvalue FROM event_cardata WHERE lotid = {$rsLoop["id"]}";
$DBObj->query($sqlQ,$rCnt,2);
while($rsLoopX = $DBObj->getrow(2)) {
$$rsLoopX["fieldname"] = $rsLoopX["fieldvalue"];
}
/*
$make = $DBObj->query_r("SELECT fieldvalue FROM event_cardata WHERE lotid = {$rsLoop["id"]} AND fieldname = 'make'",2);
$model = $DBObj->query_r("SELECT fieldvalue FROM event_cardata WHERE lotid = {$rsLoop["id"]} AND fieldname = 'model'",2);
$year = $DBObj->query_r("SELECT fieldvalue FROM event_cardata WHERE lotid = {$rsLoop["id"]} AND fieldname = 'year'",2);
$bidprice = $DBObj->query_r("SELECT fieldvalue FROM event_cardata WHERE lotid = {$rsLoop["id"]} AND fieldname = 'bidprice'",2);
$reserveprice = $DBObj->query_r("SELECT fieldvalue FROM event_cardata WHERE lotid = {$rsLoop["id"]} AND fieldname = 'reserveprice'",2);
$description = $DBObj->query_r("SELECT fieldvalue FROM event_cardata WHERE lotid = {$rsLoop["id"]} AND fieldname = 'description'",2);
$condition = $DBObj->query_r("SELECT fieldvalue FROM event_cardata WHERE lotid = {$rsLoop["id"]} AND fieldname = 'condition'",2);
$result = $DBObj->query_r("SELECT fieldvalue FROM event_cardata WHERE lotid = {$rsLoop["id"]} AND fieldname = 'result'",2);
*/
if ($cntr++ & 1) $bgcolor = "#bfbfd9"; else $bgcolor = "#EAEAF2";
%>
| <%= $rsLoop["lotnumber"] %> |
<%= $year %> |
<%= $make %> |
<%= $model %> |
<%= $description %> |
<%
if ($type == 2) {
%>
<%= $condition %> |
$<%= $bidprice %> |
<%= $reserveprice %> |
<%= $result %> |
<%
}
%>
">View
Details |
<%
}
%>
|
