<?php
include_once("../common/database.class");
include_once("../common/common.class");
include_once("../lang/eng.php");
$db=new database;
$common=new common;
$xPath=$common->path;
$search="";
$title="Holiday cottages with a personal hot tub";
$description="Holiday cottages with a personal hot tub for your own private use";
$keywords="holiday cottages,  hot tub, self-catering holiday, weekend break";
$scriptname="Cottages-personal-hot-tub";
$description1="Holiday cottages, country cottages, houses and apartments with a personal hot tub for your own private use. Enjoy an indulgent self-catering holiday or weekend break soaking your cares away in a bubbly hot tub. Display details of each cottage with its own personal hot tub by clicking on the photographs and book that relaxing break soon.";
$destitle="Holiday cottages with a personal hot tub";
$xTemplate="../search/maintemplate.html"; 
$fullcontent=$common->return_file_content($db,$xTemplate); 
$mysql="select * from country";  
$xRead=$db->get_rsltset($mysql); 
preg_match("/<{country_loopstart}>(.*?)<{country_loopend}>/s",$fullcontent,$xMonthmatch);  
for ($i=0; $i<count($xRead); $i++)
	{
$sel=""; 
$xMonthmatch1=$xMonthmatch[1]; 
$countryid=$xRead[$i][0];  
$country=$xRead[$i][1];  
$xMonthmatch1 = preg_replace("/{{(.*?)}}/e" , "$$1" , $xMonthmatch1);
$mysql="select * from county where countryid=$countryid order by countyname";  
$xRead1=$db->get_rsltset($mysql); 
$xMonthlists=""; 
preg_match("/<{county_loopstart}>(.*?)<{county_loopend}>/s",$xMonthmatch1,$xMonthmatchs);  
for ($j=0; $j<count($xRead1); $j++)
	{
$sel=""; 
$xMonthmatchs1=$xMonthmatchs[1];   
$countyid=$xRead1[$j][0];         
$countyname=$xRead1[$j][2];  
if(strlen($countyname)>10) 
{
$countyname=substr($countyname,0,8);  
$countyname.=".."; 
}$scriptname=$xRead1[$j][6];   
$xMonthmatchs1 = preg_replace("/<{(.*?)}>/e" , "$$1" , $xMonthmatchs1); 
$xMonthlists.=$xMonthmatchs1; 
}
$xMonthmatch1=preg_replace("/<{county_loopstart}>(.*?)<{county_loopend}>/s",$xMonthlists,$xMonthmatch1);  
$xMonthlist.=$xMonthmatch1;
}
$fullcontent=preg_replace("/<{country_loopstart}>(.*?)<{country_loopend}>/s",$xMonthlist,$fullcontent);  
$xMonthlist=""; 
preg_match("/<{first_loopstart}>(.*?)<{first_loopend}>/s",$fullcontent,$xMonthmatch);  
for ($i=0; $i<count($xRead); $i++)
	{
$sel=""; 
$xMonthmatch1=$xMonthmatch[1]; 
$countryid=$xRead[$i][0];  
$country=$xRead[$i][1];  
$mysql="select * from cottages,country ctry,county,owners own where (IndoorSpaBath like '%Y%' AND NoUnits = '1' OR OutdoorSpaBath like '%Y%' AND NoUnits = '1' OR summary like '%private hot tub%') and CottCountry=$countryid\ and CottCountry=ctry.countryid and CottCounty=countyid  and own.ownerid=cottages.ownerid  and (is_paid <> 'n') order by countryname, countyname"; 
$mysql=stripslashes($mysql); 
$xRead1=$db->get_rsltset($mysql); 
if($xRead1[0][0]!="")
{
$xMonthmatch1 = preg_replace("/{{(.*?)}}/e" , "$$1" , $xMonthmatch1);
$xMonthlists=""; 
preg_match("/<{second_loopstart}>(.*?)<{second_loopend}>/s",$xMonthmatch1,$xMonthmatchs);  
for ($j=0; $j<count($xRead1); $j++)
	{
$sel=""; 
$xMonthmatchs1=$xMonthmatchs[1]; 
$CottageId=$xRead1[$j][0]; 
$cottage_name = $xRead1[$j][4]; 
$county_id1 = $xRead1[$j][7]; 
$q = "select countyname from county where countyid='$county_id1'"; 
$v = $db->get_a_line($q); 
$county = $v[0]; 
$Description=$xRead1[$j][111];         
$Description=stripslashes($Description); 
$mainphoto=$xRead1[$j][89]; 
$searchimage=$xRead1[$j]['searchimage']; 
if($searchimage!="no" or $searchimage!="") 
{
$ty=split("/",$searchimage); 
$type=$ty[1];
if($type=="pjpeg") { $type="jpg"; } 
if($type=="jpeg") { $type="jpg"; } 
$Photo=$common->upload_directory1."/".$CottageId."_search.".$type;   
}  
else 
{  
if($mainphoto!="no" or $mainphoto!="") 
{
$ty=split("/",$mainphoto); 
$type=$ty[1];
if($type=="pjpeg") { $type="jpg"; } 
if($type=="jpeg") { $type="jpg"; } 
$Photo=$common->upload_directory1."/".$CottageId."_main.".$type;   
}  
}  

$ownerid=$xRead1[$j][1]; 
$mysql="select * from owners where ownerid=$ownerid"; 
$xResultOwner=$db->get_a_line($mysql); 
$phone=$xResultOwner[6]; 
$mobile=$xResultOwner[7]; 
$email=$xResultOwner[15]; 
$Alt=$xRead1[$j][11]; 
$url=$xRead1[$j][88];   
if($url=='')
{
  $url1="../site/Cottage_details.php?Cottageid=$CottageId";

$XXXtargetXXX="";   
// $image="<a href=\"$url\"><img border=\"0\" src=\"$Photo\" alt=\"$Alt\" width=\"150\" height=\"127\"></a>"; 
}
else
{
      $str1=substr($url,0,4);
     if($str1=="http")
     {
         
     $url1="$url";
     }
     else
     {
          $url1="http://".$url;
     }
    
$XXXtargetXXX="target='_new'";
//  $image="<img border=\"0\" src=\"$Photo\" alt=\"$Alt\" width=\"150\" height=\"127\">"; 
}
$xMonthmatchs1 = preg_replace("/<{(.*?)}>/e" , "$$1" , $xMonthmatchs1); 
$xMonthlists.=$xMonthmatchs1; 
} 
$xMonthmatch1=preg_replace("/<{second_loopstart}>(.*?)<{second_loopend}>/s",$xMonthlists,$xMonthmatch1);   
$xMonthlist.=$xMonthmatch1; 
}
}
$fullcontent=preg_replace("/<{first_loopstart}>(.*?)<{first_loopend}>/s",$xMonthlist,$fullcontent);   
$fullcontent = preg_replace("/{{(.*?)}}/e" , "$$1" , $fullcontent); 
echo $fullcontent
?>