\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'

'; if(!empty($row->ID)){ echo "Reviews\n"; } if(!empty($row->Website)){ echo "Website\n"; } $match = array(); $partners = array('activehotels.com', 'laterooms.com', 'superbreak.com', 'cottagesdirect.com', 'booking.com' ); foreach($partners as $partner){ if(strpos($row->Description, $partner) !== false && empty($row->Website)){preg_match("/]*{$partner}[^>]*/", $row->Description, $match);} } if(!empty($match[0])){echo"{$match[0]}>Book Online\n";} elseif(strstr($row->Website, 'hostelbookers') || ($row->assoc == 1)){ echo"Book Online\n"; } ?>