\r\n";
mail('jim.rolt@googlemail.com', $subject, $error, $headers);
}
$Place_ID = (is_numeric($_GET['Place_ID'])) ? $_GET['Place_ID'] : 1;
include'dataedit/sql.php';
if(isset($_GET['type'])){
switch($_GET['type']){
case 'activity':
$sql = "SELECT Name, Website, Town, Postcode, county, latitude, longitude, CountyNameCut, CountyName, bcomregion FROM Activities
INNER JOIN CountyDetails ON CountyDetails.RecordID = Activities.county
WHERE Activities.ID = $Place_ID";
$q = mysql_query($sql)or mailjim('q', "$sql\n".mysql_error());
$row = mysql_fetch_object($q);
$link = "activitypage.cfm?id=$Place_ID";
break;
case 'shop':
$sql = "SELECT Name, web AS Website, Shops.email, Town, Postcode, county, latitude, longitude, CountyNameCut, CountyName, bcomregion FROM Shops
INNER JOIN CountyDetails ON CountyDetails.RecordID = Shops.county
WHERE Shops.ID = $Place_ID";
$q = mysql_query($sql)or mailjim('q', "$sql\n".mysql_error());
$row = mysql_fetch_object($q);
$link = "shops.cfm?ID=$Place_ID";
break;
case 'sport':
$sql = "SELECT Name, Website, Town, Postcode, county, latitude, longitude, CountyNameCut, CountyName, bcomregion FROM Sports
INNER JOIN CountyDetails ON CountyDetails.RecordID = Sports.county
WHERE Sports.ID = $Place_ID";
$q = mysql_query($sql)or mailjim('q', "$sql\n".mysql_error());
$row = mysql_fetch_object($q);
$link = "sportdetail.cfm?id=$Place_ID";
break;
}
}
else{
$sql = "SELECT EstDetails.Name, Website, EstDetails.email, EstDetails.Town, EstDetails.Postcode, Enquiries, EstDetails.county, EstDetails.latitude, EstDetails.longitude, EstDetails.Description, CountyNameCut, CountyName, CountyDetails.CountryID, bcomregion, reviews.ID, Towns.ID AS tid FROM EstDetails
INNER JOIN CountyDetails ON CountyDetails.RecordID = EstDetails.county
LEFT JOIN reviews ON reviews.est = EstDetails.RecordID AND reviews.display = 1 AND reviews.type = 1
LEFT JOIN Towns ON Towns.Name = EstDetails.Town AND Towns.County = EstDetails.County
WHERE EstDetails.RecordID = $Place_ID";
$q = mysql_query($sql);//;or die("$sql\n".mysql_error());
$row = mysql_fetch_object($q);
$link = "showPlace.cfm?Place_ID=$Place_ID";
}
$stown = mysql_real_escape_string($row->Town);
$sql = "SELECT SQL_CACHE DISTINCT EstType
FROM EstDetails
INNER JOIN CountyDetails ON (County = CountyDetails.RecordID OR County2 = CountyDetails.RecordID)
AND CountyDetails.RecordID = $row->county
WHERE List = 1
AND EstType IN(1,2,4,5,7,12,15)
AND Town LIKE '".preg_replace("/[-\s]/", "_", $stown)."'";
$chktown = mysql_query($sql);
$chtown = array();
while($ets = mysql_fetch_object($chktown)){
$chtown[]= $ets->EstType;
}
?>
Location Map for $row->Name, $row->Town, $row->Postcode
EOT;
?>
county, $row->CountyNameCut);
include'locallinks.php';
$llins = new locallinks($row->county,$row->CountryID);
echo $llins->output;
include'adviva.txt';
include'burstmedia.txt';;
include'burstmedia.txt';
?>
Name, $row->Town, $row->CountyName'>";
}
include'yellowbcombox.php';
yellowbox($row->Town,$row->bcomregion);
//include'connect.php';
//connect($row->county, $row->Town);
?>
Map of
$row->Name, ";
if($row->Town > ''){
$townurl = ucwords(trim(strtolower(str_replace('-', ' ', $row->Town))));
echo"
";
if(in_array(1, $chtown) || in_array(12, $chtown) || in_array(5, $chtown)){echo"$row->Town";}
elseif(in_array(2, $chtown)){echo"$row->Town\n";}
elseif(in_array(4, $chtown) || in_array(15, $chtown)){echo"$row->Town\n";}
elseif(in_array(7, $chtown)){echo"$row->Town\n";}
elseif($row->tid){echo"$row->Town\n";}
else{echo $row->Town;}
}
echo"\n";
include'linkunit.txt';
if(!empty($row->Website)){echo" | Visit Website\n";}
if($row->Enquiries){echo" | FREE brochure\n";}
echo'