\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } $timestart = microtime(); 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'; $sql = "SELECT EstDetails.RecordID, EstDetails.Name, EstType, EstType2, EstType3, EstTypeAlt, Town, EstDetails.description, website, EstDetails.email, reviews.id AS Rid, Details.DPrice FROM EstDetails LEFT JOIN Details ON Details.RecordID = EstDetails.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)."' AND (EstType IN(2,5,7) OR EstType2 IN(2,5,7) OR EstType3 IN(2,5,7) OR EstTypeAlt IN(2,5,7)) ORDER BY RAND()"; $q = mysql_query($sql)or mailjim("q", "$sql\n".mysql_error()); if(mysql_num_rows($q) == 0){ header("HTTP/1.1 404 Not Found"); header("Location: https://information-britain.co.uk/errordoc.php"); exit(); } $sql = "SELECT ID, Towns.Description, brochure, brochurelink, telcode, Towns.postcode, population, gridref, council, jobs, tips, clientpic, piclink, snippet, Towns.weather, EstDetails.Name 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); $st = mysql_query("SELECT CountyName, CountyNameCut, CountryID, bcomregion FROM CountyDetails WHERE RecordID = $county")or mailjim("st", mysql_error()); $stuff = mysql_fetch_object($st); $sql = "SELECT 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 id FROM famousdates WHERE town = '$qtown' AND county = $county "; $fd = mysql_query($sql)or mailjim("fd", "$sql\n".mysql_error()); $didyouknow = mysql_query("SELECT id FROM didyouknow WHERE town = '$qtown' AND county = $county")or mailjim("didyouknow", 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); $town = ucwords(trim(strtolower(str_replace('-', ' ', $_GET['town'])))); $sql = "SELECT EstType, TYPE FROM EstDetails INNER JOIN EstablishmentType ON EstablishmentType.ID = EstDetails.EstType WHERE town = '$qtown' AND county = $county AND EstType IN(4,5,7,15,20)"; //determine if town has sc,inns, cotts $etc = mysql_query($sql)or mailjim("etc", "$sql\n".mysql_error()); $echeck = array(); while($estcheck = mysql_fetch_object($etc)){ $echeck[$estcheck->EstType] = $estcheck->TYPE; } $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); $dnum = (count($description) < 10) ? count($description) : 10; for($i=0; $i<$dnum; $i++){$virep .= $description[$i].' ';} } $townurl = str_replace(' ', '-', $town); echo << Bed and Breakfast in $town. Online booking for $town Bed and Breakfast, $stuff->CountyName EOT; ?>
CountyNameCut); include'locallinks.php'; $llins = new locallinks($county,$stuff->CountryID); echo $llins->output; include'featuredtownhotels.php'; feature($county, $qtown); include'adviva.txt'; include'burstmedia.txt';; if($county == 16){ ?> The London Pass
Big Bus Tours
postcode)){ $wday = date("D"); $wdate = date("j M"); $xml = simplexml_load_string($towndetails->weather, 'SimpleXMLElement', LIBXML_NOCDATA); echo <<
Click for 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; } include'yellowbcombox.php'; yellowbox($town,$stuff->bcomregion); echo << Loading...
EOT; ?>
Join in
Email page to a friend
\n"; ?> $town
- Britain's favourite town
EOT; if(!empty($towndetails->telcode) || !empty($towndetails->postcode) || !empty($towndetails->population) || !empty($towndetails->gridref) || !empty($towndetails->council) || mysql_num_rows($didyouknow) > 0 || mysql_num_rows($fd) > 0 || $townrev->num > 0){ echo"

Information"; if(isset($towndetails->brochure) && $towndetails->brochure == 1){ if(!empty($towndetails->brochurelink)){echo" | Free Brochure";} else{echo" | Free Brochure";} } echo"

County - $stuff->CountyName
\n"; //"$town Map
\n"; if(!empty($towndetails->telcode)){echo"Tel code: $towndetails->telcode | code search
\n";} if(!empty($towndetails->postcode)){echo"Postcode: $towndetails->postcode | code search
\n";} if(!empty($towndetails->population)){echo"Population: $towndetails->population
\n";} if(!empty($towndetails->gridref)){echo"Grid Reference: $towndetails->gridref
\n";} if(!empty($towndetails->council)){ $pos = stripos($towndetails->Name, 'council'); $councilname = ($pos === false) ? $towndetails->Name : substr($towndetails->Name, 0, $pos); echo"Council: $councilname
\n";} if(!empty($towndetails->jobs)){echo"$town Jobs
\n";} if(!empty($towndetails->tips)){echo"$town Travel Tips
\n";} if(mysql_num_rows($didyouknow) > 0){echo"Rather interesting $town facts
\n";} if($townrev->num > 0){echo"$town Reviews ($townrev->num)
\n";} if(mysql_num_rows($fd) > 0){ $famousdates = mysql_fetch_object($fd); echo"$town History
\n"; } } echo<<Britains Favourite Town
$town guide EOT; if(mysql_num_rows($tips) > 0){ $tip = mysql_fetch_object($tips); echo"
$town Tips:
\n\"$tip->tip...more

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

A Visitor's View:
$virep...More

\n
"; } ?>
Bed and Breakfast in $town"; if(empty($towndetails->snippet)){ echo"

"; $townurl = rawurlencode($town); if(!empty($towndetails->Description)){ echo"Town Guide"; } echo " | Hotels\n"; $handyarray = array(4 => array('selfc', 'Self Catering'), 7 => array('budget', 'Budget'),15 => array('selfc', 'Holiday Parks')); foreach($handyarray as $key => $value){ if(array_key_exists($key, $echeck)){ echo" | {$echeck[$key]}"; } else{ echo" | {$value[1]}"; } } if($county != 16){ echo" | Today's Best Rates | LATE DEALS\n"; } echo '

'; } else{ echo"\n

$towndetails->snippet.. \n"; if(!empty($towndetails->Description)){echo"Read More

";} echo "Hotels\n"; $handyarray = array(4 => array('selfc', 'Self Catering'), 7 => array('budget', 'Budget'),15 => array('selfc', 'Holiday Parks')); foreach($handyarray as $key => $value){ if(array_key_exists($key, $echeck)){ echo", {$echeck[$key]}\n"; } else{ echo", {$value[1]}\n"; } } if($county != 16){ echo", Today's Best Rates, LATE DEALS\n"; } } echo"

\n"; $details = array(); while($places = mysql_fetch_object($q)){ $details['Hotel'][$places->RecordID] = array('Rid'=>$places->Rid, 'website'=>$places->website, 'email'=>$places->email, 'description'=>$places->description, 'Name'=>$places->Name, 'DPrice'=>$places->DPrice); } include'hotelsummarynew.php'; showPlace('Hotel'); include'dailyfeature.php'; ?>