$intPropID = $_GET["propID"]; $sql = "SELECT * FROM property, area, state_of_trade, proptype, branch WHERE property.prop_ID = " . $intPropID . " AND "; $sql .= " property.area_id = area.area_ID AND property.state_of_trade_id = state_of_trade.state_ID "; $sql .= " AND property.type_id = proptype.type_ID "; $sql .= " AND property.Branch = branch.Branch_ID"; if (DB::isError($res = $con->query($sql))) { die(DB::errorMessage($res)); } $from = isset($_GET['from']) ? (int) $_GET['from'] : 0; $limit = 1; $pager = new DB_Pager($res, $from, $limit); $data = $pager->build(); if (DB::isError($data)) { die(DB::errorMessage($data)); } while ($row = $pager->fetchRow(DB_FETCHMODE_ASSOC)) { $pc = explode(" ", $row['Postcode']); $intOSX = $row["osx"]; $intOSY = $row["osy"]; $SQLTrans = "SELECT places.place_ID, places.place_type, places.place_title, places.place_desc, places.place_osx, places.place_osy, pl_type.pl_type_id, pl_type_title FROM places, pl_type WHERE (places.place_type = 1 OR places.place_type = 2) AND places.place_type = pl_type.pl_type_id ORDER BY sqrt((abs(places.place_osx-" . $intOSX . ")*abs(places.place_osx-" . $intOSX . "))+(abs(places.place_osy-" . $intOSY . ")*abs(places.place_osy-" . $intOSY . "))) LIMIT 1"; $rowTrans = $con->getRow($SQLTrans, DB_FETCHMODE_ASSOC); if (DB::isError($resTrans = $con->query($SQLTrans))) { die(DB::errorMessage($resTrans)); } $intTransType = $rowTrans['place_type']; $strTransType = $rowTrans['pl_type_title']; $strTransTitle = $rowTrans['place_title']; $strTransDesc = $rowTrans['place_desc']; $intTransOSX = $rowTrans['place_osx']; $intTransOSY = $rowTrans['place_osy']; if ($strTransType == "Station") {
} else { printf('<TH ALIGN="CENTER"> </TH>'); } echo " </THEAD>\n"; echo " <THEAD>\n"; echo " <TH>Date/Time</TH>\n"; echo " <TH>ID</TH>\n"; echo " <TH>From</TH>\n"; echo " <TH>To</TH>\n"; echo " <TH class=\"subject\">Subject</TH>\n"; echo " <TH ALIGN=\"CENTER\">Size</TH>\n"; echo " <TH ALIGN=\"CENTER\">SA Score</TH>\n"; echo " <TH>Status</TH>\n"; echo " </THEAD>\n"; // Get rows while ($row = $pager->fetchRow(DB_FETCHMODE_OBJECT)) { $status_array = array(); if ($row->isspam == 'Y') { array_push($status_array, "Spam"); } if ($row->iswhitelisted == 'Y') { array_push($status_array, "Whitelisted"); } if ($row->virusinfected == 'Y') { // Get virus name if (preg_match(VIRUS_REGEX, $row->report, $virus)) { array_push($status_array, "Virus ({$virus['2']})"); } else { array_push($status_array, "Virus"); } }