Create("triumphstag_db"); $sql1 = new MySQL_class; $sql1->Create("triumphstag_db"); //Get Post Variables $commnumber= $_REQUEST['commnumber']; /////////////////// //Collect data from registry for commsion number x (passed as an argument to this page) $sql->QueryRow("select * from stagdata where commnumber = $commnumber AND status <> 'deleted'"); $row = $sql->data; //**************** //FieldIT - Oliver Field - Added if condition to stop seek error //**************** $sqlAuditAdded = new MySQL_class; $sqlAuditAdded->Create("triumphstag_db"); $sqlAuditAdded->QueryRow("select min(id) from stagdataAudit where reference = '$commnumber' and action='Added'"); $rowAuditAdded = $sqlAuditAdded->data; if ($rowAuditAdded[0] == '') { $dateAdded = '(Sorry: Date added was not recorded at the time)'; } else { $sqlForSingAuditRow = 'select datestamp from stagdataAudit where id='.$rowAuditAdded[0]; $sqlAuditAdded->QueryRow($sqlForSingAuditRow); $rowAuditAdded = $sqlAuditAdded->data; $dateAdded = (date ("d F Y h:i:s A",$rowAuditAdded[0])); } //Now get each field and put it in a variable $id=$row[0]; $comprefix=$row[1]; $commnumber=$row[2]; $comsufix=$row[3]; $paintcode=$row[4]; $trimcode=$row[5]; $newpaint=$row[6]; $bodynumber=$row[7]; $salesnumber=$row[8]; $bdateday=$row[9]; $bdatemonth=$row[10]; $bdateyear=$row[11]; $handdrive=$row[12]; $eprefix=$row[13]; $enumber=$row[14]; $esufix=$row[15]; $etype=$row[16]; $gbprefix=$row[17]; $gbnumber=$row[18]; $gbtype=$row[19]; $axlenumber=$row[20]; $axletype=$row[21]; $wheels=$row[22]; $aircon=$row[23]; $condition=$row[24]; $modified=$row[25]; $modifiedtxt=$row[26]; $comments=$row[27]; $pdateday=$row[28]; $pdatemonth=$row[29]; $pdateyear=$row[30]; $name=$row[31]; $country=$row[32]; $state=$row[33]; $postzip=$row[34]; $email=$row[35]; $emailpvt=$row[36]; $club = $row[37]; $homepage=$row[38]; $username=$row[39]; $psw=$row[40]; $pswq=$row[41]; $pswa=$row[42]; $datestamp=$row[43]; $stolen=$row[44]; $stolendate=$row[45]; $stolentxt=$row[46]; $forsale=$row[47]; $forsaleprice=$row[48]; $forsaletxt=$row[49]; $status=$row[50]; $updated=$row[51]; $stagpic=$row[52]; //calculate special cases $date = (date ("d F Y h:i:s A",$datestamp)); //concatonate commision number & engine number $comnum = ($row[1].$row[2].$row[3]); $engnum =($row[13].$row[14].$row[15]); //Get paint & Trim name from code given $pcolour = $sql1->QueryItem("select description from stagdatatrimpaint where code = '$paintcode'"); $tcolour = $sql1->QueryItem("select description from stagdatatrimpaint where code = '$trimcode'"); //$cnumfull = $sql1->QueryItem("select concat(comprefix, commnumber, comsufix) from stagdata where commnumber = $commnumber"); //$engnum = $sql1->QueryItem("select enumber from stagdata where commnumber = $commnumber"); //$engtype = $sql1->QueryItem("select etype from stagdata where commnumber = $commnumber"); $cname = $sql1->QueryItem("select countryname from stagdatacountry where countrycode = '$country'"); //test for picture $picture="Picture

"; if ( $stagpic == NULL) { $picture="Sorry no picture"; } if ($stagpic == "") { $picture="Sorry no picture"; } //test if there is text in the homepage field, if yes then the feild is hyperlinked if ( $homepage == NULL) { $homepage1=" Sorry no homepage listed"; } else { $homepage1=("Visit $names Homepage"); } //test if there is text in the email field, if yes and the emailpvt field is no then the field is hyperlinked if ( $email == NULL or "No" == $emailpvt) { $email1="Witheld or not provided"; } else { $email1=("Email"); } //test to see if an engine number is given, if yes then that is output, if no data is taken from engine type if ( "Triumph V8" == $etype ) { $eng1="$etype (Number: $engnum )"; } else { $eng1= "$etype"; } //look for modified data if ( "Yes" == $modified ) { $mod=" Any Modifications are listed below

$modifiedtxt

"; } else { $mod= "No modifications listed for this Stag"; } // Now take this data an display it using HTML code // check for stolen stag if ("Yes"==$stolen) { echo ("

"); echo ("

Stolen Stag!

"); echo (" "); echo (""); echo ("

Stolen on the $stolendate

$stolentxt

"); } // check for stag for sale if ("Yes"==$forsale) { echo ("

"); echo ("

For Sale

"); echo (" "); echo (""); echo ("

Asking Price : $forsaleprice

$forsaletxt

"); } //FieldIT changed from $date to $dateAdded echo ("$comnum was first recorded in the registry $dateAdded GMT"); $rowstart="tr bgcolor='white'>

"); echo (" "); echo ("<$rowstart>Commission Number"); echo ("<$rowstart> Left or Right hand drive "); echo ("<$rowstart>Paint "); echo ("<$rowstart> Trim"); echo ("<$rowstart> Body Number & Sales Number "); echo ("<$rowstart> Registered build date (dd-mm-yyyy)"); echo ("<$rowstart> Engine"); echo ("<$rowstart> Gearbox"); echo ("<$rowstart> Axle"); echo ("<$rowstart> Wheels"); echo ("<$rowstart> Aircon Fitted"); echo ("<$rowstart> Condition"); echo ("<$rowstart> Date Acquired (dd-mm-yyyy)"); echo ("<$rowstart> Location"); echo ("<$rowstart> Email the owner"); echo ("<$rowstart> See the owners Homepage"); echo ("<$rowstart> This Owner is a member of"); echo ("
$comnum $handdrive
Original colour = $pcolour (code:$paintcode), Current colour = $newpaint
Trim Colour = $tcolour (code: $trimcode)
T $bodynumber LD or LE / $salesnumber LD or LE
$bdateday-$bdatemonth-$bdateyear
$eng1
$gbprefix Number: $gbnumber Type: $gbtype
Axle Number : LD$axlenumber Type: $axletype
$wheels
$aircon
$condition
$pdateday-$pdatemonth-$pdateyear
$state, $cname
$email1
$homepage1
$club
"); //***************list the modified & Comments fields************** echo (" "); echo ("$mod"); echo (""); echo (""); echo ("
Any comments are listed below

    $comments

"); //******************************************************************** echo (" "); echo ("$picture"); //echo (""); echo ("
"); ?>