$row_get_properties['album_array'] = $album;
}
if ($row_get_properties['photo_path'] == null) {
$row_get_properties['photo_path'] = 'N/A';
}
if (count($row_get_properties['album_array']) < 1) {
$row_get_properties['album_array'] = 'N/A';
}
//$row_get_properties['title_to_land']=translate_title_to_land($row_get_properties['title_to_land']);
if ($realtor_1 = get_realtor_profile($row_get_properties['list_realtor_1_id'])) {
$row_get_properties['realtor_1_profile'] = $realtor_1;
}
if ($realtor_2 = get_realtor_profile($row_get_properties['list_realtor_2_id'])) {
$row_get_properties['realtor_2_profile'] = $realtor_2;
}
if ($realtor_3 = get_realtor_profile($row_get_properties['list_realtor_3_id'])) {
$row_get_properties['realtor_3_profile'] = $realtor_3;
}
$row_get_properties['type_of_dwelling'] = translate_property_type($row_get_properties['type_of_dwelling']);
if ($row_get_properties['sub_area_desc'] != 'VVWDT') {
$row_get_properties['area'] = translate_city_area($row_get_properties['area']);
} else {
$row_get_properties['area'] = "温市中心";
}
if ($row_get_properties['lot_size_sqt'] == 0) {
$row_get_properties['lot_size_sqt'] = 'N/A';
}
if ($row_get_properties['lot_size_sqm'] == 0) {
$row_get_properties['lot_size_sqm'] = 'N/A';
}
/*$timestring_updated_local=strtotime($row_get_properties['date_updated_local']);
echo "Error selecting database, exited.";
exit;
}
$sysid = isset($_GET['sysid']) ? $_GET['sysid'] : $_POST['sysid'];
if (!empty($sysid)) {
$selectSQL = "SELECT * FROM listings" . " LEFT JOIN listing_realtors ON listings.sysid=listing_realtors.sysid" . " LEFT JOIN listing_firms ON listings.sysid=listing_firms.sysid" . " WHERE publish_on_internet='Y' AND status='A' AND listings.sysid=" . $sysid;
$get_property = mysql_query_or_die($selectSQL, $useradmin);
$propertyObject = array();
if ($propertyObject = mysql_fetch_assoc($get_property)) {
$photo_array = get_album($sysid);
$realtor_array = array($propertyObject['list_realtor_1_id'], $propertyObject['list_realtor_2_id'], $propertyObject['list_realtor_3_id']);
$firm_array = array($propertyObject['list_firm_1_code'], $propertyObject['list_firm_2_code']);
$realtor_profile_array = array();
$firm_profile_array = array();
foreach ($realtor_array as $realtor_id) {
$realtor_profile = get_realtor_profile($realtor_id);
array_push($realtor_profile_array, $realtor_profile);
}
foreach ($firm_array as $firm_code) {
$firm_profile = get_firm_profile($firm_code);
array_push($firm_profile_array, $firm_profile);
}
//var_dump($realtor_profile_array);
//var_dump($firm_profile_array);
} else {
echo "Error: The property you are looking for is no longer active";
exit;
}
$address = $propertyObject['address'] . ' ' . $propertyObject['city'] . ' ' . $propertyObject['province'];
$geo_address = get_geocode($address, $sysid);
}
