\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:
$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 << Bed and Breakfast in $town. Online booking for $town Bed and Breakfast, $CountyName EOT; ?>
output; if(mysql_num_rows($tips) > 0){ $tip = mysql_fetch_object($tips); echo"

$town Tips:
\n\"$tip->tip...more

"; } include'featuredtownhotels.php'; feature($county, $qtown); include'adviva.txt'; include'burstmedia.txt';; ?>
"; if($trow->caption){echo"$trow->caption";} } elseif(mysql_num_rows($townpix) > 0){ echo"$trow->Name
$trow->Name"; } elseif($towndetails->clientpic > 0){ echo"$pname->Name
$pname->Name"; } 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
$wdate
Max {$xml->Forecast[0]->maxtemp}°C
Min {$xml->Forecast[0]->mintemp}°C
{$xml->Forecast[0]->day->windicon}
{$xml->Forecast[0]->day->windspeed_mph} mph
{$xml->Forecast[0]->day->condition}
Provided by Weather2
EOT; } if($towndetails->latitude > 0){echo'
';} echo'

More Accommodation

'; $join = ''; if(empty($towndetails->snippet)){ if(!empty($towndetails->Description)){ echo"

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"

\n"; if(isset($towndetails->quote)){ echo<<

"$towndetails->quote"
$towndetails->name

EOT; } if(mysql_num_rows($tips) > 0){ $tip = mysql_fetch_object($tips); echo"

$town Tips:

\n

\"$tip->tip...more"; } echo'

'; if(isset($virep)){ echo"

A Visitor's View

$virep...More

\n"; } if(mysql_num_rows($events) > 0){ echo"

$town Events

"; $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'; ?>

B&Bs in $town - ".count($details)." places to stay\n"; include'newbcombox.php'; newbox($town, $bcomregion); include'hotelsummarynew.php'; foreach($details as $key => $value){ if(!in_array($key, $excarray)){ //if(count($value) < 6){ showPlace($key); /* } else{ echo"{$cont['Name']}' {$cont['Town']}' \n"; if(!empty($cont['website']) || !empty($cont['email'])){ echo' *featured*'; } else{echo'*book online*';} echo"\n"; } echo"\n"; } */ } } if(mysql_num_rows($others) > 0){ //if(!empty($others)){ echo"

Other Places to Stay near $town

\n"; $details = array(); while($row = mysql_fetch_object($others)){ // foreach($others as $row){ $dist = sprintf("%01.2f", $row->distance); $details['Hotel'][$row->RecordID] = array('Name'=>$row->Name, 'Town'=>$row->Town, 'description'=>$row->description, 'website'=>$row->website, 'email'=>$row->email, 'distance'=>$dist); //add establishment to details array } showPlace('Hotel'); } include'dailyfeature.php'; ?>