//set colour change for each row
$rowcolour=1;
//set table font size
$fontsize=2;
// Include the header file
include ("../include/header.php");
require("../include/sqlcon.php");
$sql = new MySQL_class;
$sql->Create("triumphstag_db");
$sql1 = new MySQL_class;
$sql1->Create("triumphstag_db");
echo("
");
$date2=(time() - 5184000);
$deletedate= (date ("d F Y h:iA",$date2));
echo(" Please note that anything entered before $deletedate will have been deleted
\n");
$sql1->Delete("delete from stagdataparts where datestamp < $date2 ");
$sql1->Query("Select id,part,price,location from stagdataparts");
$totalentries = $sql1->rows;
Echo ("There are a total of $totalentries entries
");
//********************List the entries Wanted acording to Section **********************************
echo("Wanted Adverts
");
echo("");
echo("");
echo(" | ID | Wanted | Part | Price | Location | Date Entered |
");
$sql->Query("SELECT id,section,part,price,location,datestamp from stagdataparts where section ='Wanted' order by $sort");
for ($i = 0; $i < $sql->rows; $i++) {
$sql->Fetch($i);
$id = $sql->data[0];
$section= $sql->data[1];
$part= $sql->data[2];
$price= $sql->data[3];
$location = $sql->data[4];
$date = $sql->data[5];
$date1 = (date ("d F Y ",$date));
if ($date >(time() - 2592000)) {
$icon = "";
} else {
$icon="";
}
//assemble each row of the table
//check row colour and alternate
if (1==$rowcolour){
$bgcolour="bgcolor='#FFFFFF' bordercolor='#FFFFFF'";
$rowcolour=0;
} else {
$bgcolour="bgcolor='#F4F4F4' bordercolor='#F4F4F4'";
$rowcolour=1;
}
echo (" $icon |
$id |
$section |
$part |
$price |
$location |
$date1 |
");
}
echo ("
");
//********************List the entries Going Spare acording to Section **********************************
echo("
");
echo("Going Spare Adverts
");
echo("");
echo(" | ID | Going Spare | Part | Price | Location | Date Entered |
");
$sql->Query("SELECT id,section,part,price,location,datestamp from stagdataparts where section ='Going Spare' order by $sort");
for ($i = 0; $i < $sql->rows; $i++) {
$sql->Fetch($i);
$id = $sql->data[0];
$section= $sql->data[1];
$part= $sql->data[2];
$price= $sql->data[3];
$location = $sql->data[4];
$date = $sql->data[5];
$date1 = (date ("d F Y",$date));
//assemble each row of the table
//check row colour and alternate
if (1==$rowcolour){
$bgcolour="bgcolor='#FFFFFF' bordercolor='#FFFFFF'";
$rowcolour=0;
} else {
$bgcolour="bgcolor='#F4F4F4' bordercolor='#F4F4F4'";
$rowcolour=1;
}
if ($date >(time() - 2592000)) {
$icon = "";
} else {
$icon="";
}
echo (" $icon |
$id |
$section |
$part |
$price |
$location |
$date1 |
");
// echo (" $icon | $id | $section | $part | $price | $location | $date1 |
");
}
echo ("
");
//*************** add a link to show Stags for sale out of the registry *********************
?>
// Java Script for ebay items
// old script for Dave was = "http://ilapi.ebay.com/ws/eBayISAPI.dll?EKServer&ai=e%7ew%7fzi&bdrcolor=FFCC00&cid=0&encode=ISO-8859-1&endcolor=FF0000&endtime=y&fntcolor=000000&fs=0&hdrcolor=FFFFCC&img=y&lnkcolor=0000FF&logo=1&num=25&numbid=y&paypal=y&popup=y&prvd=1&query=Triumph+Stag&r0=3&shipcost=y&siteid=3&sort=MetaEndSort&sortby=endtime&sortdir=asc&srchdesc=y&tbgcolor=FFFFFF&title=Support+TriumphStag.net+by+accessing+eBay+through+the+links+on+these+pages&tlecolor=FFCE63&tlefs=0&tlfcolor=000000&track=1509805&width=600"
?>
Not finding it here??
You can help support Triumphstag.net by using the ebay links below when searching/ purchasing on EBay.
For every purchase made through these links a very small amount is contributed towards the upkeep of the triumphstag.net site.
So Next time you are looking for a Triumph Stag Part on Ebay, Please do start HERE!!
or
Click here for Stag Parts on eBay!!!