if( (!isset($_REQUEST['search'])) && (!isset($_REQUEST['cat'])) )
{
?>
}
else
{
?>
}
?>
:: BY TYPE ::
if(LOCVIEWTYPE == 0)
{
$numh_er = mysql_num_rows(mysql_query("SELECT * FROM hotels h,hotels_locations l WHERE h.ID=l.idhotels AND h.status='1' AND l.idlocations='".IDLOC."' AND h.exc_resorts_in='1'"));
}
else
{
$numh_er = mysql_num_rows(mysql_query("SELECT * FROM hotels WHERE exc_resorts_in='1' AND status='1'"));
}
if($numh_er > 0)
{
?>
}
if(LOCVIEWTYPE == 0)
$numh_r = mysql_num_rows(mysql_query("SELECT * FROM hotels h,hotels_locations l WHERE h.ID=l.idhotels AND h.status='1' AND l.idlocations='".IDLOC."' AND h.resorts_in='1'"));
else
$numh_r = mysql_num_rows(mysql_query("SELECT * FROM hotels WHERE resorts_in='1' AND status='1'"));
if($numh_r > 0)
{
?>
}
$idloc = IDLOC;
$dispcat = mysql_query("SELECT * FROM categories ORDER BY rank ASC");
while($cats = mysql_fetch_array($dispcat))
{
if(LOCVIEWTYPE == 0)
$numhotels = mysql_num_rows(mysql_query("SELECT * FROM hotels h,hotels_locations l WHERE h.ID=l.idhotels AND h.status='1' AND l.idlocations='".IDLOC."' AND h.idcategories='".$cats['ID']."'"));
else
$numhotels = mysql_num_rows(mysql_query("SELECT * FROM hotels WHERE idcategories='".$cats['ID']."' AND status='1'"));
if($numhotels > 0)
{
?>
}
}
?>
if(LOCVIEWTYPE == 0)
{
?>
:: BY LOCATION ::
}
?>
if(LOCVIEWTYPE == 0)
{
$cityzone = mysql_query("SELECT * FROM cityzone ORDER BY idcity ASC,zone");
while($czo = mysql_fetch_array($cityzone))
{
$cityname = mysql_fetch_row(mysql_query("SELECT name FROM city WHERE ID='".$czo['idcity']."'"));
$nh = 0;
$hotels = mysql_query("SELECT * FROM hotels WHERE idcityzone='".$czo['ID']."'");
while($htl = mysql_fetch_array($hotels))
{
$check_loc = mysql_num_rows(mysql_query("SELECT * FROM hotels_locations WHERE idhotels='".$htl['ID']."' AND idlocations='".IDLOC."'"));
if($check_loc > 0)
$nh++;
}
if($nh > 0)
{
$newname = '';
$newname = $czo['ID']."_".str_replace("[^a-zA-Z0-9-_ ]","_",trim($cityname[0]));
if($czo['zone'] != "")
$newname .= "_".str_replace("[^a-zA-Z0-9-_ ]","_",$czo['zone']);
$newname .= ".htm";
?>
=$cityname[0]?> - =$czo['zone']?>
}
}
}
?>
$live_help_code = mysql_fetch_row(mysql_query("SELECT livehelp FROM locations WHERE name LIKE '%".str_replace("www.","",$_SERVER['HTTP_HOST'])."%'"));
if($live_help_code[0] != '')
{
?>
print str_replace("\\","",$live_help_code[0]);
?>
}
?>
CONTACT US
E mail
if($_SESSION['membid'] > 0 || $_COOKIE['membid'] > 0)
{
if($_COOKIE['membid'] > 0 && $_COOKIE['membid'] == $_SESSION['membid'])
$user_id = $_COOKIE['membid'];
else
{
@setcookie('membid','',time()-3600);
$user_id = $_SESSION['membid'];
}
$customer = mysql_fetch_row(mysql_query("SELECT first_name,last_name,verified FROM customer WHERE ID='".$user_id."'"));
?>
Welcome back
$tot_amount_in = mysql_fetch_row(mysql_query("SELECT SUM(amount_in) FROM customer_account WHERE idcustomer='$user_id' AND active='1'"));
$tot_amount_out = mysql_fetch_row(mysql_query("SELECT SUM(amount_out) FROM customer_account WHERE idcustomer='$user_id' AND (retstatus='1' OR active='1')"));
$bonus_credit = $tot_amount_in[0]-$tot_amount_out[0];
if($bonus_credit > 0)
{
?>
Bonus Credits:
}
?>
My Booking [Log out ]
}
else
{
?>
My Booking
}
?>
$catpages = mysql_query("SELECT * FROM category_pages ORDER BY rank ASC");
while($ctp = mysql_fetch_array($catpages))
{
$num_pages = mysql_query("SELECT * FROM pages WHERE idcategory_pages='".$ctp['ID']."'");
if(mysql_num_rows($num_pages) > 0)
{
$p=0;
$pids = array();
while($plc = mysql_fetch_array($num_pages))
{
$check_loc = mysql_num_rows(mysql_query("SELECT * FROM pages_locations WHERE idlocations='".IDLOC."' AND idpages='".$plc['ID']."'"));
if($check_loc > 0)
$p++;
}
if($p > 0)
{
print "".$ctp['name']." ";
$listpages = mysql_query("SELECT * FROM pages WHERE idcategory_pages='".$ctp['ID']."' AND showaslink='0'");
while($lpg = mysql_fetch_array($listpages))
{
$check_page_loc = mysql_num_rows(mysql_query("SELECT * FROM pages_locations WHERE idpages='".$lpg['ID']."' AND idlocations='".IDLOC."'"));
if($check_page_loc > 0)
{
?>
=str_replace("\\","",ucwords(strtolower($lpg['title'])))?>
}
}
print " ";
}
}
}
?>
DESTINATIONS
Antalya Hotels
Bodrum Hotels
Kusadasi Hotels
if( (!isset($_REQUEST['search'])) && (!isset($_REQUEST['cat'])) )
{
?>
}
$num_comp_list = mysql_query("SELECT * FROM compare_list WHERE session_id='".session_id()."' ORDER BY ID ASC");
if(mysql_num_rows($num_comp_list) > 0)
{
?>
}
if($_REQUEST['action'] == 'mailing')
{
if($_REQUEST['sub'] == 'reg')
{
if($_REQUEST['name'] != '' && $_REQUEST['email'] != '' && preg_match("/@/",$_REQUEST['email']))
{
$error = '';
$sitefrom = preg_replace("/http:\/\/|www./si","",$_SERVER['HTTP_HOST']);
//print "INSERT INTO mailing(name,email,sitefrom,onxml) VALUES('".addslashes($_REQUEST['name'])."','".trim($_REQUEST['email'])."','$sitefrom','0') ";
$check_mail_exist = mysql_num_rows(mysql_query("SELECT * FROM mailing WHERE email='".trim($_REQUEST['email'])."'"));
$check_custmail_exist = mysql_num_rows(mysql_query("SELECT * FROM customer WHERE email='".trim($_REQUEST['email'])."'"));
if($check_mail_exist == 1 || $check_custmail_exist == 1)
{
$error .= "You are already in our Mailing list!";
?>
=$error?>
}
else
{
mysql_query("INSERT INTO mailing(name,email,sitefrom,onxml) VALUES('".addslashes($_REQUEST['name'])."','".trim($_REQUEST['email'])."','$sitefrom','0')") or die(mysql_error());
?>
You have been subscribed!
}
}
}
}
###############################################################################################
### SHOW HOTEL BY SEARCH
elseif( (isset($_REQUEST['search']) && $_REQUEST['search'] != "") || $_REQUEST['idcateg'] != "" || $_REQUEST['cat'] != "" || $_REQUEST['idcityzone'] > 0)
{
//print "";
//print_r($_REQUEST);
//print " ";
$show_list_hotel = 0;
if($show_list_hotel == 0)
{
if(LOCVIEWTYPE == 0)
{
$keyw = ($_REQUEST['keyword'] != "")?"AND h.name LIKE '%".$_REQUEST['keyword']."%'":"";
$cityzo = ($_REQUEST['idcityzone'] > 0)?"AND h.idcityzone='".$_REQUEST['idcityzone']."'":"";
if($_REQUEST['cat'] != "")
{
if($_REQUEST['cat'] == "exclusive_resorts")
$cat_id = "AND h.exc_resorts_in='1'";
elseif($_REQUEST['cat'] == "resorts")
$cat_id = "AND h.resorts_in='1'";
else
{
$categ_id = mysql_fetch_row(mysql_query("SELECT ID FROM categories WHERE pagename='".$_REQUEST['cat']."'"));
$cat_id = ($_REQUEST['cat'] != "")?"AND h.idcategories='$categ_id[0]'":"";
}
}
else
{
if($_REQUEST['idcateg'] == "exclusive_resorts")
$cat_id = "AND h.exc_resorts_in='1'";
elseif($_REQUEST['idcateg'] == "resorts")
$cat_id = "AND h.resorts_in='1'";
else
{
//$categ_id = mysql_fetch_row(mysql_query("SELECT ID FROM categories WHERE pagename='".$_REQUEST['idcateg']."'"));
$cat_id = ($_REQUEST['idcateg'] > 0)?"AND h.idcategories='".$_REQUEST['idcateg']."'":"";
}
}
if($_REQUEST['sort_by'] == "stars")
$ord_by = "h.stars ".$_REQUEST['sort_type'];
elseif($_REQUEST['sort_by'] == "name" || $_REQUEST['sort_by'] == '')
$ord_by = "h.name ".$_REQUEST['sort_type'];
elseif($_REQUEST['sort_by'] == "visits")
$ord_by = "h.visits ".$_REQUEST['sort_type'];
elseif($_REQUEST['sort_by'] == "ovmedia")
$ord_by = "h.ovmedia ".$_REQUEST['sort_type'];
else
$ord_by = "h.name ".$_REQUEST['sort_type'];
if(isset($_REQUEST['prev']))
$page = $_REQUEST['page']-1;
elseif(isset($_REQUEST['next']))
$page = $_REQUEST['page']+1;
else
$page = 0;
$idloc = IDLOC;
$limit = 10;
$offset = ($page > 0)?$page*$limit:0;
$query = mysql_query("SELECT * FROM hotels h,hotels_locations l WHERE h.ID=l.idhotels AND h.status='1' $cityzo AND l.idlocations='".IDLOC."' $cat_id $keyw ORDER BY $ord_by") or die(mysql_error());
while($hotels = mysql_fetch_row($query))
{
$show_hotel = 0;
if($_REQUEST['idhotp'] > 0)
{
$check_ht = mysql_num_rows(mysql_query("SELECT * FROM hoteltype_list WHERE idhotels='".$hotels[0]."' AND idhoteltype='".$_REQUEST['idhotp']."'"));
if($check_ht > 0)
$list_in_hotel[] = $hotels[0];
}
else
$list_in_hotel[] = $hotels[0];
}
}
else
{
$keyw = ($_REQUEST['keyword'] != "")?"AND name LIKE '%".$_REQUEST['keyword']."%'":"";
$cityzo = ($_REQUEST['idcityzone'] > 0)?"AND h.idcityzone='".$_REQUEST['idcityzone']."'":"";
if($_REQUEST['cat'] != "")
{
if($_REQUEST['cat'] == "exclusive_resorts")
$cat_id = "AND exc_resorts_in='1'";
elseif($_REQUEST['cat'] == "resorts")
$cat_id = "AND resorts_in='1'";
else
{
$now_cat_id = mysql_fetch_row(mysql_query("SELECT ID FROM categories WHERE pagename='".$_REQUEST['cat']."'"));
$cat_id = ($_REQUEST['cat'] != "")?"AND idcategories='".$now_cat_id[0]."'":"";
}
}
else
{
if($_REQUEST['idcateg'] == "exclusive_resorts")
$cat_id = "AND exc_resorts_in='1'";
elseif($_REQUEST['idcateg'] == "resorts")
$cat_id = "AND resorts_in='1'";
else
{
$now_cat_id = mysql_fetch_row(mysql_query("SELECT ID FROM categories WHERE pagename='".$_REQUEST['idcateg']."'"));
$cat_id = ($_REQUEST['idcateg'] != "")?"AND idcategories='".$now_cat_id[0]."'":"";
}
}
if($_REQUEST['sort_by'] == "stars")
$ord_by = "stars ".$_REQUEST['sort_type'];
elseif($_REQUEST['sort_by'] == "name" || $_REQUEST['sort_by'] == '')
$ord_by = "name ".(($_REQUEST['sort_type'] != '')?$_REQUEST['sort_type']:"ASC");
elseif($_REQUEST['sort_by'] == "visits")
$ord_by = "visits ".$_REQUEST['sort_type'];
elseif($_REQUEST['sort_by'] == "ovmedia")
$ord_by = "ovmedia ".$_REQUEST['sort_type'];
else
$ord_by = "name ".$_REQUEST['sort_type'];
if(isset($_REQUEST['prev']))
$page = $_REQUEST['page']-1;
elseif(isset($_REQUEST['next']))
$page = $_REQUEST['page']+1;
else
$page = 0;
$limit = 10;
$offset = ($page > 0)?$page*$limit:0;
//$query = mysql_query("SELECT * FROM hotels h,hotels_locations l WHERE h.ID=l.idhotels AND h.status='1' $cityzo AND l.idlocations='".IDLOC."' $cat_id $keyw ORDER BY $ord_by") or die(mysql_error());
$query = mysql_query("SELECT * FROM hotels WHERE status='1' $cityzo $cat_id $keyw ORDER BY $ord_by") or die(mysql_error());
while($hotels = mysql_fetch_array($query))
{
$check_loc = mysql_num_rows(mysql_query("SELECT * FROM hotels_locations WHERE idhotels='".$hotels['ID']."' AND idlocations ='".IDLOC."'"));
$show_hotel = 0;
if($check_loc > 0)
{
if($_REQUEST['idhotp'] > 0)
{
$check_ht = mysql_num_rows(mysql_query("SELECT * FROM hoteltype_list WHERE idhotels='".$hotels['ID']."' AND idhoteltype='".$_REQUEST['idhotp']."'"));
if($check_ht > 0)
$list_in_hotel[] = $hotels['ID'];
}
else
$list_in_hotel[] = $hotels['ID'];
}
}
}
// code for prices
if($_REQUEST['sort_by'] == "price")
{
$values_min = '';
$values_max = '';
if($_REQUEST['amount'] != '')
{
$amount_in = explode(":",$_REQUEST['amount']);
$values_min = $amount_in[0];
$values_max = $amount_in[1];
}
else
{
$values_min = '0';
$values_max = '1000';
}
}
else
{
$values_min = '0';
$values_max = '1000';
//$in_hotel = $list_in_hotel;
}
$in_hotel = array();
$list_hotels_ids = array();
$season_day = array();
if(count($list_in_hotel) > 0)
{
foreach($list_in_hotel as $ind=>$idhotel)
{
$eb_discount_price = 0;
if($_REQUEST['theDate'] != '')
{
$season_day = mysql_fetch_row(mysql_query("SELECT codenum FROM periods2 WHERE idhotels = '".$idhotel."' AND pday = '".$_REQUEST['theDate']."'"));
}
else
{
//$season_day = mysql_fetch_row(mysql_query("SELECT codenum FROM periods2 WHERE idhotels = '".$idhotel."' AND pday = '".date("Y-m-d",time())."'"));
$season_day[0] = ''; //mysql_fetch_row(mysql_query("SELECT codenum FROM periods2 WHERE idhotels = '".$idhotel."' AND pday = '".date("Y-m-d",time())."'"));
}
if($season_day[0] != '')
{
$price_adult_day_prz = ($_SESSION['prz'] != '')?"adult_price_2_".$_SESSION['prz']:"adult_price_2";
//print "SELECT MIN($price_adult_day_prz) FROM prices2 WHERE idhotels='".$idhotel."' AND $price_adult_day_prz>'0' AND period_codenum='".$season_day[0]."' ";
//$price_adult_day = mysql_fetch_row(mysql_query("SELECT MIN($price_adult_day_prz) FROM prices2 WHERE idhotels='".$idhotel."' AND $price_adult_day_prz>'0' AND period_codenum='".$season_day[0]."'"));
$price_adult_day = mysql_fetch_row(mysql_query("SELECT MIN($price_adult_day_prz) FROM prices2 WHERE idhotels='".$idhotel."' AND period_codenum='".$season_day[0]."'"));
//print "$idhotel - price adult = $price_adult_day[0] ";
if($price_adult_day[0] >= 0)
{
$price_adult_day = sprintf("%.2f",($price_adult_day[0]/2));
if($price_adult_day >= $values_min && $price_adult_day <= $values_max)
{
if($_POST['theDate'] != '')
$eb_info_price = mysql_fetch_array(mysql_query("SELECT * FROM early_booking WHERE idhotels='".$idhotel."' AND (eb_date_from<='".$_POST['theDate']."' AND eb_date_to>='".$_POST[theDate2]."') AND eb_date>='".date("Y-m-d",time())."'"));
else
$eb_info_price = mysql_fetch_array(mysql_query("SELECT * FROM early_booking WHERE idhotels='".$idhotel."' AND (eb_date_from<='".date("Y-m-d",time())."' AND eb_date_to>='".date("Y-m-d",time()+(60*60*24))."') AND eb_date>='".date("Y-m-d",time())."'"));
$eb_discount_price = $eb_info_price['eb_perc'];
if($eb_discount_price > 0)
{
$list_hotels_ids["$idhotel"] = sprintf("%.2f",$price_adult_day-($price_adult_day*$eb_discount_price/100));
}
else
{
$list_hotels_ids["$idhotel"] = sprintf("%.2f",$price_adult_day);
}
}
}
else
{
if($_REQUEST['sort_by'] != "price")
$list_hotels_ids["$idhotel"] = '0.00';
}
}
else
{
//print "hotel = $idhotel ";
//print "sort by = ".$_REQUEST['sort_by']." ";
//if($_REQUEST['sort_by'] != "price")
$list_hotels_ids["$idhotel"] = '0.00';
}
}
}
if($_REQUEST['sort_by'] == 'price')
{
asort($list_hotels_ids, SORT_NUMERIC);
}
foreach($list_hotels_ids as $idhotel=>$price)
{
$in_hotel[] = $idhotel.":".$price;
}
?>
if($_REQUEST['theDate'] != '')
{
$mdate1 = strtotime($_REQUEST['theDate']);
$mdate2 = strtotime($_REQUEST['theDate2']);
//print date("d-m-Y",$mdate1)." - ".date("d-m-Y",$mdate2)." ";
$days = 0;
for($k=$mdate1; $k<$mdate2; $k+=(60*60*24))
$days++;
?>
Check-in: =date("d M Y",strtotime($_REQUEST['theDate']))?> / Check-out: =date("d M Y",strtotime($_REQUEST['theDate2']))?> / =$days?> Nights
}
if($_REQUEST['cat'] != '')
{
switch($_REQUEST['cat'])
{
case "exclusive_resorts" : $category = "Exclusive Resorts"; break;
case "resorts" : $category = "Resorts"; break;
case "5star" : $category = "5 Stars"; break;
case "4star" : $category = "4 Stars"; break;
case "3star" : $category = "3 Stars"; break;
case "2star" : $category = "2 Stars"; break;
case "1star" : $category = "1 Stars"; break;
case "apart" : $category = "Apart"; break;
case "hvillages" : $category = "Holiday Village"; break;
case "pensions" : $category = "Pensions"; break;
}
$title_cat = "Hotels in Category : $category ";
}
elseif($_REQUEST['idcateg'] != '')
{
switch($_REQUEST['idcateg'])
{
case "exclusive_resorts" : $category = "Exclusive Resorts"; break;
case "resorts" : $category = "Resorts"; break;
case "1" : $category = "5 Stars"; break;
case "2" : $category = "4 Stars"; break;
case "3" : $category = "3 Stars"; break;
case "4" : $category = "2 Stars"; break;
case "5" : $category = "1 Stars"; break;
case "16" : $category = "Apart"; break;
case "10" : $category = "Holiday Village"; break;
case "17" : $category = "Pensions"; break;
}
$title_cat = "Hotels in Category : $category ";
}
elseif($_REQUEST['keyword'] != '')
{
$title_cat = "Search for Keyword: ".$_REQUEST['keyword']." ";
}
?>
=$title_cat?>
if($_REQUEST['cat'] != "")
{
?>
if(count($in_hotel) > 0)
{
$mdate1 = strtotime($_POST['theDate']);
$mdate2 = strtotime($_POST['theDate2']);
$theDate = $_POST['theDate']; //sprintf("%04d-%02d-%02d",$_POST[theDate_yy],$_POST[theDate_mm],$_POST[theDate_gg]);
$theDate2 = $_POST['theDate2']; //sprintf("%04d-%02d-%02d",$_POST[theDate2_yy],$_POST[theDate2_mm],$_POST[theDate2_gg]);
if($mdate1 > $mdate2)
{
print "Arrival date is after Departure date!! ";
print "Please search again ";
exit();
}
?>
$limit = 10;
$numrows = count($in_hotel);
$pagenow = ($_REQUEST['page']>1)?$_REQUEST['page']:1;
$limit_min = ($limit*$pagenow)-$limit;
$limit_max = $limit*$pagenow;
$end = ($limit_max < $numrows)?$limit_max:$numrows;
if($_REQUEST['idcityzone'] > 0)
{
$cityzone = mysql_fetch_row(mysql_query("SELECT idcity,zone FROM cityzone WHERE ID='".$_REQUEST['idcityzone']."'"));
$cityname = mysql_fetch_row(mysql_query("SELECT name FROM city WHERE ID='".$cityzone[0]."'"));
$addcz = "in $cityname[0] ";
if($cityzone[1] != "")
$addcz .= "(".$cityzone[1].") ";
}
?>
Found =$numrows?> Hotels =$addcz?>. Show Results from to =$end?>
$y=0;
foreach($in_hotel as $ind=>$idhpr)
{
$dethot = explode(":",$idhpr);
$idh = $dethot[0];
$price_x_person = sprintf("%.2f",$dethot[1]);
if($limit_min <= $ind && $limit_max > $ind)
{
?>
//print "SELECT * FROM hotels WHERE ID='$idh' ";
$row = array();
$row = mysql_fetch_array(mysql_query("SELECT * FROM hotels WHERE ID='$idh'"));
$overall_media = 0;
$overall_media += sprintf("%.1f",$row['ovmedia']);
$days = ($mdate2 - $mdate1)/(60*60*24);
$price_tot = 0;
$family_tot = 0;
$price_adult = 0;
for($j=$mdate1; $j<$mdate2; $j+=(60*60*24))
{
$price_adult_prz = ($_SESSION['prz'] != '')?"adult_price_2_".$_SESSION['prz']:"adult_price_2";
$season = mysql_fetch_row(mysql_query("SELECT codenum FROM periods2 WHERE pday='".date("Y-m-d",$j)."' AND idhotels='".$row['ID']."'"));
$price_adult = mysql_fetch_row(mysql_query("SELECT $price_adult_prz,family_price,idroom_type FROM prices2 WHERE period_codenum='".$season[0]."' AND idhotels='".$row['ID']."'"));
//print "day ".date("d.m.Y",$j)." = $price_adult[0] ";
$family_tot += $price_adult[1];
$price_tot += $price_adult[0];
}
$image_eab_icon = '';
/*
if(isset($_POST['theDate']))
{
$eab_icon = mysql_fetch_array(mysql_query("SELECT * FROM early_booking WHERE idhotels='".$row['ID']."' AND eb_date_from<='$theDate' AND eb_date_to>='$theDate' AND eb_date>'".date("Y-m-d",time())."'"));
}
else
*/
$eab_icon = mysql_fetch_array(mysql_query("SELECT * FROM early_booking WHERE idhotels='".$row['ID']."' AND eb_date>'".date("Y-m-d",time())."'"));
if($eab_icon > 0)
$image_eab_icon = " ";
if($row['main_image'] != "" && file_exists("./thumb/".$row['main_image']))
{
?>
' width="120" height="90" border="0">
}
else
{
?>
NO IMAGE
}
$acc_type = array();
$acc_type = mysql_fetch_row(mysql_query("SELECT name,info FROM acc_type WHERE ID='".$row['idacc_type']."'"));
?>
=strtoupper($row['name'])?>
if($row['stars'] > 0)
echo str_repeat(" ",$row['stars']);
?>
if($acc_type[0] != '')
{
?>
=$acc_type[0]?>
}
if($row['idcityzone'] > 0)
{
$cityzone = mysql_fetch_row(mysql_query("SELECT idcity,zone FROM cityzone WHERE ID='".$row['idcityzone']."'"));
$cityname = mysql_fetch_row(mysql_query("SELECT name FROM city WHERE ID='".$cityzone[0]."'"));
print "";
print $cityname[0];
if($cityzone[1] != "")
print " - ".$cityzone[1];
print " ";
}
if($row['longitude'] != "" && $row['latitude'] != "")
{
?>
Show Map
}
if($row['allyearopen'] == 1)
{
?>
Open All Year
}
elseif($row['openfrom'] != "0000-00-00")
{
$openfrom = strtotime($row['openfrom']);
$opento = strtotime($row['opento']);
$months = array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
?>
Open between :
=date("d M",$openfrom)?> / =date("d M",$opento)?>
}
?>
=str_replace("\\","",$row['desc_1'])?>
//$eb_discount = 0;
//$earlybook = mysql_fetch_array(mysql_query("SELECT * FROM early_booking WHERE idhotels='$idh'"));
//$eb_info = mysql_fetch_array(mysql_query("SELECT * FROM early_booking WHERE idhotels='".$idh."' AND (eb_date_from<='".$_POST[theDate]."' AND eb_date_to>='".$_POST[theDate2]."') AND eb_date>='".date("Y-m-d",time())."'"));
//$eb_discount = $eb_info['eb_perc'];
if($row['instant_conf'] == 1)
{
?>
=$image_eab_icon?>
}
else
{
?>
=$image_eab_icon?>
}
?>
$serv_hotel = mysql_query("SELECT * FROM serv_in_hotel WHERE idhotels='".$idh."'");
while($svh = mysql_fetch_array($serv_hotel))
{
$sico = mysql_fetch_array(mysql_query("SELECT * FROM service_hotel WHERE ID='".$svh['idservice_hotel']."'"));
if($sico['showhome'] == 1 && $sico['icon_image'] != "" && file_exists("./upload/".$sico['icon_image']))
{
?>
}
}
$hoteltype_icons = mysql_query("SELECT * FROM hoteltype_list WHERE idhotels='".$idh."'");
if(mysql_num_rows($hoteltype_icons) > 0)
{
while($thp = mysql_fetch_array($hoteltype_icons))
{
$htco = mysql_fetch_array(mysql_query("SELECT * FROM hoteltype WHERE ID='".$thp['idhoteltype']."'"));
if($htco['icon_image'] != "" && file_exists("./upload/".$htco['icon_image']))
{
?>
0)
{
?>
(=$thp['vote']?>/100)
}
?>
}
}
}
?>
if($overall_media > 0)
{
?>
:: Overall Rating ::
}
else
{
if($_REQUEST['sort_by'] == "ovmedia")
{
?>
:: Overall Rating ::
0.0
}
}
?>
$orig_final_x_person = 0;
$def_orig_final_x_person = 0;
$def_price_final_x_person = 0;
if($price_x_person > 0)
{
if($eb_info['eb_perc'] > 0)
{
$price_final_x_person = sprintf("%.2f",($price_x_person-($price_x_person*$eb_info['eb_perc']/100)));
$orig_final_x_person = sprintf("%.2f",$price_x_person);
}
else
$price_final_x_person = sprintf("%.2f",$price_x_person);
?>
Starting from
$check_loc_disc = mysql_fetch_row(mysql_query("SELECT signtype,locdisc FROM hotels_locations WHERE idhotels='".$idh."' AND idlocations='".IDLOC."'"));
//print "SELECT signtype,locdisc FROM hotels_locations WHERE idhotels='".$idh."' AND idlocations='".IDLOC."' ";
if($check_loc_disc[1] > 0)
{
if($check_loc_disc[0] == 'p')
{
$def_orig_final_x_person = $orig_final_x_person+($orig_final_x_person*$check_loc_disc[1]/100);
$def_price_final_x_person = $price_final_x_person+($price_final_x_person*$check_loc_disc[1]/100);
}
else
{
$def_orig_final_x_person = $orig_final_x_person-($orig_final_x_person*$check_loc_disc[1]/100);
$def_price_final_x_person = $price_final_x_person-($price_final_x_person*$check_loc_disc[1]/100);
}
}
else
{
$def_orig_final_x_person = $orig_final_x_person;
$def_price_final_x_person = $price_final_x_person;
}
if($def_final_x_person > 0)
{
?>
=$_SESSION['cursym']?>
}
?>
=$_SESSION['cursym']?>
price x person x day
}
?>
0)
{
$mydays = ($days > 0)?"$days":"1";
printf("Rate for $mydays nights : ".$_SESSION['cursym']."%.2f (per person)",($def_price_final_x_person*$mydays));
}
else
print "No price avalaible in selected dates! ";
?>
Click For Details >>
}
}
?>
$y++;
}
else
{
?>
}
}
}
################################################################################################
else
{
?>
//$ban_flash = mysql_query("SELECT b.ID, l.idbanners_flash, b.nodate, b.dateto, l.idlocations
//FROM banners_flash b, banners_flash_loc l WHERE b.ID = l.idbanners_flash AND l.idlocations = '".IDLOC."'
//AND (b.nodate = '1' OR b.nodate = '0' AND b.dateto > NOW())");
$banner_js = mysql_query("SELECT b.ID, b.main_title, b.descz_1 ,b.descz_2, b.descz_3, b.textpos, b.linkto, b.image, l.idbanner_js, b.nodate, b.datefrom, b.dateto, l.idlocations
FROM banner_js b, banner_js_loc l WHERE b.ID = l.idbanner_js AND l.idlocations = '".IDLOC."'
AND (b.nodate = '1' OR (b.nodate = '0' AND b.datefrom <= NOW() AND b.dateto >= NOW()))") or die(mysql_error());
if(mysql_num_rows($banner_js) > 0)
{
?>
while($bjs = mysql_fetch_row($banner_js))
{
if($bjs[6] != '')
{
?>
=$bjs[1]?>
".$bjs[2]:""; ?>
".$bjs[3]:""; ?>
".$bjs[4]:""; ?>
}
else
{
?>
=$bjs[1]?>
$bjs[2]":""; ?>
$bjs[3]":""; ?>
$bjs[4]":""; ?>
}
}
?>
}
else
{
?>
}
if(BANNERS == 1)
{
?>
}
?>
Latest Reservations
$u=0;
$last_res_ticker = '';
/*
$lastres = mysql_query("SELECT * FROM reservation WHERE resdtime!='' AND idcustomer>'0' ORDER BY resdtime DESC LIMIT 10");
if(mysql_num_rows($lastres) > 0)
{
while($rev = mysql_fetch_array($lastres))
{
$check_hotel_loc = mysql_num_rows(mysql_query("SELECT * FROM hotels_locations WHERE idhotels='$rev[idhotels]' AND idlocations='".IDLOC."'"));
if($check_hotel_loc > 0)
{
if( $u < 3 )
{
$hotelname = mysql_fetch_row(mysql_query("SELECT name,stars FROM hotels WHERE ID='$rev[idhotels]'"));
$dateres = date("Y-m-d H:i",$rev['resdtime']);
$last_res_ticker .= "".$hotelname[0]." ".str_repeat("*",$hotelname[1])." ".nicetime($dateres)." ";
}
}
$u++;
}
}
*/
$lastres = array();
$rand_min = getrandmin();
$query = mysql_query("SELECT DISTINCT(idhotels) FROM reservation WHERE sitefrom LIKE '%".$loctype['name']."%' GROUP BY idhotels ORDER BY ID DESC LIMIT 3");
$j=0;
while($row = mysql_fetch_row($query))
{
$lastres[$row[0]] = $rand_min[$j];
$j++;
}
asort($lastres);
foreach($lastres as $idht=>$minago)
{
$hotelname = mysql_fetch_row(mysql_query("SELECT name,stars FROM hotels WHERE ID='$idht'"));
if($hotelname[1] > 0)
{
$last_res_ticker .= "".$hotelname[0]." ".str_repeat("*",$hotelname[1])." $minago minutes ago ";
}
else
$last_res_ticker .= "".$hotelname[0]." $minago minutes ago ";
}
?>
Professional advice, secure payment, fast replies since 1998!
$nowdate = date("Y-m-d",time());
$qrand = mysql_query("SELECT n.ID,n.dateshow,n.title,n.main_desc FROM news n,news_locs l WHERE (n.datefrom<='$nowdate' AND n.dateto>='$nowdate') AND n.random_new='1' AND l.idlocations='".IDLOC."' ORDER BY RAND() LIMIT 1");
//print "SELECT n.ID,n.dateshow,n.title,n.main_desc FROM news n,news_locs l WHERE (n.datefrom<='$nowdate' AND n.dateto>='$nowdate') AND n.random_new='1' AND l.idlocations='".IDLOC."' ORDER BY RAND() LIMIT 1 ";
if( mysql_num_rows($qrand) > 0)
{
$news_rand = mysql_fetch_row($qrand);
?>
}
?>
$no_news = ($news_rand[0] > 0)?"AND n.ID!='".$news_rand[0]."'":"";
$qrest = mysql_query("SELECT n.ID,n.dateshow,n.title,n.main_desc FROM news n,news_locs l WHERE (n.datefrom<='$nowdate' AND n.dateto>='$nowdate') AND n.random_new!='1' $no_news AND n.ID=l.idnews AND l.idlocations='".IDLOC."' ORDER BY n.priority DESC,n.ID DESC LIMIT 2");
//print "SELECT n.ID,n.dateshow,n.title,n.main_desc FROM news n,news_locs l WHERE (n.datefrom<='$nowdate' AND n.dateto>='$nowdate') AND n.random_new!='1' $no_news AND n.ID=l.idnews AND l.idlocations='".IDLOC."'ORDER BY n.priority DESC,n.ID DESC LIMIT 2 ";
if(mysql_num_rows($qrest) > 0)
{
?>
}
?>
$earlybooknum = 0;
$limit_ea = ($_REQUEST['eball'] != "")?"1000":"5";
$eabookqw = mysql_query("SELECT * FROM early_booking WHERE eb_perc>0 AND eb_date>='".date("Y-m-d",time())."' ORDER BY eb_perc DESC");
while($ebqw = mysql_fetch_array($eabookqw))
{
//print "SELECT * FROM hotels_locations WHERE idlocations='".IDLOC."' AND idhotels='".$ebqw['idhotels']."' ";
$check_loc_qw = mysql_num_rows(mysql_query("SELECT * FROM hotels_locations WHERE idlocations='".IDLOC."' AND idhotels='".$ebqw['idhotels']."'"));
//print $ebqw['idhotels']." - ".$check_loc_qw." ";
if((LOCVIEWTYPE == 1 || $check_loc_qw > 0))
$earlybooknum++;
}
$earlybook = mysql_query("SELECT * FROM early_booking WHERE eb_perc>0 AND eb_date>='".date("Y-m-d",time())."' ORDER BY eb_perc DESC");
if($earlybooknum > 0)
{
?>
$ebx = 0;
while($eab = mysql_fetch_array($earlybook))
{
$htdet = mysql_fetch_row(mysql_query("SELECT name,codename,stars,idacc_type FROM hotels WHERE ID='".$eab['idhotels']."'"));
$acc_type = mysql_fetch_row(mysql_query("SELECT name FROM acc_type WHERE ID='$htdet[3]'"));
$check_loc = mysql_num_rows(mysql_query("SELECT * FROM hotels_locations WHERE idlocations='".IDLOC."' AND idhotels='".$eab['idhotels']."'"));
//print "B) SELECT * FROM hotels_locations WHERE idlocations='".IDLOC."' AND idhotels='".$eab['idhotels']."' ";
//print "$eab['idhotels'] = $check_loc ";
if($htdet[1] != "" && $ebx < $limit_ea && (LOCVIEWTYPE == 1 || $check_loc>0))
{
?>
=$htdet[0]?>
0)
print str_repeat("*",$htdet[2]);
?>
=$acc_type[0]?>
Reserve until:
=date("d F Y",strtotime($eab['eb_date']))?>
=$eab['eb_perc']?>%
$ebx++;
}
}
?>
if($_REQUEST['eball'] != "")
{
?>
}
else
{
?>
}
?>
}
?>
$topr=0;
$topmedia_qw = mysql_query("SELECT * FROM hotels ORDER BY ovmedia DESC, name ASC");
while($tmed_qw = mysql_fetch_array($topmedia_qw))
{
$check_loc_qw_1 = mysql_num_rows(mysql_query("SELECT * FROM hotels_locations WHERE idlocations='".IDLOC."' AND idhotels='".$tmed_qw['ID']."'"));
if((LOCVIEWTYPE == 1 || $check_loc_qw_1 > 0))
{
$list_tr[] = $tmed_qw['ID'];
$topr++;
}
}
if($topr > 0)
{
?>
$limit_tr = ($_REQUEST['trall'] == "")?"5":"10";
$show = 0;
$topmedia = mysql_query("SELECT * FROM hotels ORDER BY ovmedia DESC, name ASC");
while($tmed = mysql_fetch_array($topmedia))
{
$check_loc_qw_2 = mysql_num_rows(mysql_query("SELECT * FROM hotels_locations WHERE idlocations='".IDLOC."' AND idhotels='".$tmed['ID']."'"));
if((LOCVIEWTYPE == 1 || $check_loc_qw_2 > 0) && ($show < $limit_tr))
{
?>
' width="70" height="44" border="0">
=$tmed['name']?>
0)
print str_repeat("*",$tmed['stars']);
?>
$price_start_show = '';
$nowdate = date("Y-m-d",time());
$qseas = mysql_query("SELECT codenum FROM periods2 WHERE idhotels='".$tmed['ID']."' AND pday='".$nowdate."' ORDER BY pday ASC");
$rqs = mysql_fetch_row($qseas);
if($rqs[0] != '')
{
//$idseason = mysql_fetch_row(mysql_query("SELECT idseason FROM periods WHERE codenum='$rqs[0]'"));
$addfix = ($_SESSION['prz'] != '' && $_SESSION['prz'] != 'def')?"_".$_SESSION['prz']:"";
$adult_price_field = "adult_price_2".$addfix;
$low_price = mysql_fetch_row(mysql_query("SELECT MIN($adult_price_field) FROM prices2 WHERE period_codenum='".$rqs[0]."'"));
$price_start_show .= sprintf($_SESSION['cursym']."%.2f",($low_price[0]/2));
if($low_price[0] > 0)
print "From $price_start_show per day ";
}
?>
$eabs = mysql_fetch_array(mysql_query("SELECT * FROM early_booking WHERE idhotels='".$tmed['ID']."' AND eb_date>'".$nowdate."'"));
if($eabs['eb_perc'] > 0)
{
?>
EB Discount =$eabs['eb_perc']?>%
}
?>
$show++;
}
}
?>
if($_REQUEST['trall'] != "")
{
?>
}
else
{
?>
}
?>
}
?>
$hdl=0;
$hotdeals_qw = mysql_query("SELECT * FROM hotel_home_list WHERE homepos='1'");
while($hdl_qw = mysql_fetch_array($hotdeals_qw))
{
$check_hdl_loc_qw = mysql_num_rows(mysql_query("SELECT * FROM hotels_locations WHERE idlocations='".IDLOC."' AND idhotels='".$hdl_qw['ID']."'"));
if((LOCVIEWTYPE == 1 || $check_hdl_loc_qw > 0))
{
$hdl++;
}
}
if($hdl > 0)
{
?>
$limit_hd = ($_REQUEST['hdall'] == "")?"5":"10";
$hotdeals = mysql_query("SELECT * FROM hotel_home_list WHERE homepos='1'");
?>
$max_hd = 0;
while($hds = mysql_fetch_array($hotdeals))
{
$htdet = mysql_fetch_row(mysql_query("SELECT name,codename,stars, main_image FROM hotels WHERE ID='".$hds['idhotels']."'"));
$check_hdl_loc_qw_1 = mysql_num_rows(mysql_query("SELECT * FROM hotels_locations WHERE idlocations='".IDLOC."' AND idhotels='".$hds['idhotels']."'"));
if($htdet[1] != "" && (LOCVIEWTYPE == 1 || $check_hdl_loc_qw_1) && $max_hd<$limit_hd)
{
?>
=$htdet[0]?>
0)
print str_repeat("*",$htdet[2]);
?>
=nl2br($hds['note'])?>
$max_hd++;
}
}
?>
if($_REQUEST['hdall'] != "")
{
?>
}
else
{
?>
}
?>
}
?>
$gof=0;
$hotdeals2_qw = mysql_query("SELECT * FROM hotel_home_list2 WHERE homepos='1'");
while($goqw = mysql_fetch_array($hotdeals2_qw))
{
$check_goloc_qw = mysql_num_rows(mysql_query("SELECT * FROM hotels_locations WHERE idlocations='".IDLOC."' AND idhotels='".$goqw['idhotels']."'"));
if((LOCVIEWTYPE == 1 || $check_goloc_qw > 0))
{
$gof++;
}
}
if($gof > 0)
{
$limit_go = ($_REQUEST['goall'] == "")?"3":"10";
$hotdeals2 = mysql_query("SELECT * FROM hotel_home_list2 WHERE homepos='1'");
?>
}
?>
}
###############################################################################################
?>
Terms & Conditions
|
Reservation Procedure
|
Payment Procedure
|
Cancelation Policy
|
Help
|
E mail
|
Home
=SITENAME?>
Tel:
+90 242 3212690 Fax: +90 242 3213966
© Copyright by Sonar Ltd & =SITENAME?> 1998-=date("Y",time())?>.
All Rights Reserved. Nothing contained on this website
may be reproduced without express written permission. =SITENAME?>
does not assume responsibility for errors or omissions in the content of this
website. Your
use of this web site is subject to =SITENAME?>'s
terms & conditions .