$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");
}
}
