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