\r\n";
mail('jim.rolt@googlemail.com', $subject, $error, $headers);
}
//include'memcache.php';
include'dataedit/sql.php';
if(intval($_GET['county']) > 0 && intval($_GET['county']) < 142){ $county = intval($_GET['county']);}
else{
header("HTTP/1.1 404 Not Found");
header("Location: https://information-britain.co.uk/errordoc.php");
exit();
}
$qtown = !empty($_GET['town']) ? mysql_real_escape_string($_GET['town']) : 'Worcester';
$town = !empty($_GET['town']) ? $_GET['town'] : 'Worcester';
$books = mysql_query("SELECT *
FROM Books
WHERE CountyID = $county
AND townname IS NULL
GROUP BY id")or mailjim("books", mysql_error());
$lbooks = mysql_query("SELECT SQL_CACHE * FROM Books
WHERE townname = '$qtown' AND CountyID = $county")or mailjim("lbooks", mysql_error());
$rev= mysql_query("SELECT countyreviews.id FROM countyreviews WHERE county = $county LIMIT 1");
$townpix = mysql_query("SELECT townpix.*, EstDetails.Name
FROM townpix
INNER JOIN EstDetails ON EstDetails.RecordID = townpix.clientid
WHERE townpix.town = '$qtown'
AND townpix.county = $county")or mailjim("townpix", mysql_error());
$act = mysql_query("SELECT SQL_CACHE Activities.ID, Activities.Name, ActivityTypes.TYPE
FROM Activities
INNER JOIN ActivityTypes ON ActivityTypes.ID = Activities.TYPE
WHERE County = $county
AND Town LIKE '".preg_replace("/[-\s]/", "_", $qtown)."'
Order by TYPE, Name ")or mailjim("act", mysql_error());
$sql = "SELECT Towns.Description, brochure, brochurelink, telcode, Towns.postcode, population, gridref, council, jobs, clientpic, piclink, Towns.latitude, Towns.longitude, snippet, Towns.weather, EstDetails.Name, history FROM Towns
LEFT JOIN EstDetails ON EstDetails.RecordID = Towns.council
WHERE Towns.Name LIKE '".preg_replace("/[-\s]/", "_", $qtown)."' AND Towns.County = $county";
$details = mysql_query($sql)or mailjim("towndetails", "$sql\n".mysql_error());
$towndetails = mysql_fetch_object($details);
//$details = mysql_query_cache($sql);
//$towndetails = $details[0];
if(!empty($towndetails->clientpic)){
$sql = "SELECT Name FROM EstDetails WHERE RecordID = $towndetails->clientpic LIMIT 1";
$Ename = mysql_query($sql)or mailjim("Ename", "$sql\n".mysql_error());
$pname = mysql_fetch_object($Ename);
}
$events = mysql_query("SELECT SQL_CACHE eventid, event, events.month AS emonth, location, town, months.month, day, detailcounty, CountyName
FROM events
INNER JOIN months ON months.id = events.month
INNER JOIN CountyDetails ON CountyDetails.RecordID = events.county
WHERE county = $county
AND town = '$qtown'
AND ( exactdate = '0000-00-00'
OR exactdate >= NOW() )
ORDER BY emonth, event")or mailjim("events", mysql_error());
$famous = mysql_query("SELECT SQL_CACHE * FROM famous WHERE birthplace = '$qtown' AND birthcounty = $county")or mailjim("famous", mysql_error());
$didyouknow = mysql_query("SELECT SQL_CACHE id FROM didyouknow WHERE town = '$qtown' AND county = $county")or mailjim("didyouknow", mysql_error());
$sql = "SELECT EstDetails.RecordID,
EstDetails.Name,
EstType,
EstTypeAlt,
EstType2,
EstType3,
Town,
EstDetails.description,
website,
EstDetails.email,
CountyName,
CountyNameCut,
CountyDetails.CountryID,
bcomregion,
reviews.id AS Rid,
Details.DPrice
FROM EstDetails
LEFT JOIN Details ON Details.RecordID = EstDetails.RecordID
INNER JOIN CountyDetails ON (County = CountyDetails.RecordID OR County2 = CountyDetails.RecordID)
LEFT JOIN reviews ON EstDetails.RecordID = reviews.est AND reviews.display = 1 AND reviews.type = 1
WHERE List = 1
AND (EstDetails.County = $county OR EstDetails.County2 = $county)
AND Town LIKE '".preg_replace("/[-\s]/", "_", $qtown)."' ORDER BY RAND() ";
$poptemp = mysql_query($sql)or die("tmp insert error: $town Tips: Town Guide";
$join = ' | ';
}
echo" | Hotels\n";
foreach($etarray as $key => $value){
if($value != 2){
if($value == 7){
echo array_key_exists($key, $details) ? " | $key\n" :
" | $key\n";
}
else{
echo array_key_exists($key, $details) ? " | $key\n" :
" | $key\n";
}
}
}
if($county != 16){
echo"$joinToday's Best Rates\n";
}
}
else{
echo" $towndetails->snippet.. \n";
if(!empty($towndetails->Description)){echo"Read More. ";}
echo"Hotels\n";
$comma = '';
foreach($etarray as $key => $value){
if($value != 2){
if($value == 7){
echo array_key_exists($key, $details) ? ", $key\n" :
"$comma $key\n";
$comma=',';
}
else{
echo array_key_exists($key, $details) ? ", $key\n" :
"$comma $key\n";
$comma=',';
}
}
}
if($county != 16){
echo" or you can find Today's Best Rates or get a LATE DEAL\n";
}
}
echo" "$towndetails->quote"
$sql\n".mysql_error());
if(mysql_num_rows($poptemp) == 0){
header("HTTP/1.1 404 Not Found");
header("Location: https://information-britain.co.uk/errordoc.php");
exit();
}
$details = array();
$chid = array();
$count = 0;
$etarray = array('Bed and Breakfast' => 2,
'Budget' => 7,
//'Camping' => 17,
//'Caravan Park' => 19,
//'Cottage' => 20,
'Holiday Park' => 15,
//'Inn' => 5,
'Self Catering' => 4); //types we want to put on the page
$excarray = array('Camping','Caravan Park','Cottage','Holiday Park','Self Catering','Budget');
while($row = mysql_fetch_object($poptemp)){
if($row->EstType == 1){//should this be a hoteltown page?
header("HTTP/1.1 301 Moved Permanently");
header("Location: https://information-britain.co.uk/hoteltowns.cfm?town=$town&county=$county");
exit();
}
if($count == 0){ //get county name
$CountyName = $row->CountyName;
$CountyNameCut = $row->CountyNameCut;
$CountryID = $row->CountryID;
$bcomregion = $row->bcomregion;
}
foreach($etarray as $key => $value){
if($row->EstType == $value || $row->EstType2 == $value || $row->EstType3 == $value || $row->EstTypeAlt == $value){
$details[$key][$row->RecordID] = array('Name'=>$row->Name, 'Town'=>$row->Town, 'description'=>$row->description, 'website'=>$row->website, 'email'=>$row->email, 'Rid'=>$row->Rid, 'et' => $value, 'DPrice'=>$row->DPrice); //add establishment to details array
if(in_array($key, array('Hotel','Bed and Breakfast','Self Catering', 'Inn','Budget','Cottage')) && !in_array($row->RecordID, $chid)){
$count ++;
$chid[] = $row->RecordID; //count each establishment once only
}
}
}
}
ksort($details);
if($count < 8){
$hotelids = array();
foreach($details as $a => $b){
foreach($b as $c => $d){
$hotelids[] = $c;
}
}
$hotelids = array_unique($hotelids);
$exclude = implode(',',$hotelids);
if(empty($exclude)){
header("HTTP/1.1 404 Not Found");
header("Location: https://information-britain.co.uk/errordoc.php");
exit();
}
if($towndetails->latitude){
$sql = "SELECT EstDetails.RecordID, EstDetails.Name, EstDetails.Town, EstDetails.description, EstDetails.website, EstDetails.email, TYPE,
SQRT( POW( 69.1 * ( latitude - $towndetails->latitude ) , 2 ) + POW( 69.1 * ( $towndetails->longitude - longitude ) * COS( latitude / 57.3 ) , 2 ) ) AS distance
FROM EstDetails
INNER JOIN EstablishmentType ON EstablishmentType.ID = EstType
WHERE latitude IS NOT NULL
AND EstType IN(1,2,4,5,7)
AND RecordID NOT IN($exclude)
GROUP BY distance
ORDER BY distance ASC
LIMIT 10";
$others = mysql_query($sql);
//$others = mysql_query_cache($sql);
//echo $sql;
}
}
$cott2 = mysql_query("SELECT RecordID FROM EstDetails
WHERE Name LIKE '%Cottages in%'
AND county = $county");
$cottlink = mysql_fetch_object($cott2);
$sql = "SELECT SQL_CACHE id, LEFT(tips,49) AS tip FROM Towns WHERE Name = '$qtown' AND County = $county AND tips > ''";
$tips = mysql_query($sql)or mailjim("tips", "$sql\n".mysql_error());
$sql = "SELECT COUNT(*) AS num
FROM EstDetails
INNER JOIN reviews ON reviews.est = EstDetails.RecordID AND reviews.display = 1
WHERE county = $county AND town LIKE '".preg_replace("/[-\s]/", "_", $qtown)."'";
$townreviews = mysql_query($sql)or mailjim("Townreviews", "$sql\n".mysql_error());
$townrev = mysql_fetch_object($townreviews);
$sql = "SELECT SQL_CACHE id FROM famousdates WHERE town = '$qtown' AND county = $county ";
$fd = mysql_query($sql)or mailjim("Famous dates", "$sql\n".mysql_error());
$sql = "SELECT SQL_CACHE id, title FROM Cultural
WHERE (town = '$qtown'
OR town2 = '$qtown'
OR town3 = '$qtown')
AND (county = $county
OR county2 = $county
OR county3 = $county)
ORDER BY title";
$cultures = mysql_query($sql)or mailjim('culture', "$sql\n".mysql_error());
$query = "SELECT SQL_CACHE review FROM countyreviews
WHERE display = 1
AND county = $county
AND town = '$qtown'
ORDER BY id DESC LIMIT 1";
//echo $query.'
';
$view = mysql_query($query)or die(mysql_error());// mailjim('q', "$query\n".mysql_error());
if(mysql_num_rows($view) == 1){
$vi = mysql_fetch_object($view);
$virep = '';
$description = explode(' ', $vi->review);
$num = (count($description) < 10) ? count($description) : 10;
for($i=0; $i<$num; $i++){$virep .= $description[$i].' ';}
}
echo <<
\n\"$tip->tip...more
";
}
elseif($towndetails->clientpic > 0){
echo"
";
}
if(!empty($towndetails->postcode)){
$wday = date("D");
$wdate = date("j M");
$xml = simplexml_load_string($towndetails->weather, 'SimpleXMLElement', LIBXML_NOCDATA);
echo<<
5 day $town Weather
$wday
$wdateMax {$xml->Forecast[0]->maxtemp}°C
Min {$xml->Forecast[0]->mintemp}°C
{$xml->Forecast[0]->day->windspeed_mph} mph
Provided by Weather2 More Accommodation
';
$join = '';
if(empty($towndetails->snippet)){
if(!empty($towndetails->Description)){
echo"
$towndetails->name
\"$tip->tip...more"; } echo'
'; if(isset($virep)){ echo"$virep...More
\n"; } if(mysql_num_rows($events) > 0){ echo"";
$monthcheck = '';
$counter = '';
while($row= mysql_fetch_object($events)){
if($monthcheck != $row->month){
echo"$row->month
";
$monthcheck =$row->month;
}
echo"$row->event
\n";
}
//echo'Add an Event';
}
include'yeddabox.txt';
?>