No Customer found with this Email and Password. Try again!
}
}
?>
}
?>
if($longlat[0] != "" && $longlat[1] != "")
{
?>
}
else
{
?>
}
$hotel_det = mysql_fetch_array(mysql_query("SELECT * FROM hotels WHERE ID='".HOTEL_ID."'"));
$cityzone = mysql_fetch_array(mysql_query("SELECT * FROM cityzone WHERE ID='$hotel_det[idcityzone]'"));
?>
$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] != '')
{
?>
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]
$cityname = mysql_fetch_row(mysql_query("SELECT name FROM city WHERE ID='$cityzone[idcity]'"));
?>
if($hotel_det[allyearopen] == 1)
{
?>
Open All Year Round
}
elseif($hotel_det[openfrom] != "0000-00-00")
{
$opents = mysql_fetch_row(mysql_query("SELECT EXTRACT(DAY FROM openfrom),EXTRACT(MONTH FROM openfrom),EXTRACT(DAY FROM opento),EXTRACT(MONTH FROM opento) FROM `hotels` WHERE ID = '".HOTEL_ID."'"));
$months = array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
?>
Open between :
=$opents[0]?>
=$months[($opents[1]-1)]?>
/
=$opents[2]?>
=$months[($opents[3]-1)]?>
$cityname = mysql_fetch_row(mysql_query("SELECT name FROM city WHERE ID='$cityzone[idcity]'"));
?>
if($hotel_det[allyearopen] == 1)
{
?>
Open All Year Round
}
elseif($hotel_det[openfrom] != "0000-00-00")
{
$opents = mysql_fetch_row(mysql_query("SELECT EXTRACT(DAY FROM openfrom),EXTRACT(MONTH FROM openfrom),EXTRACT(DAY FROM opento),EXTRACT(MONTH FROM opento) FROM `hotels` WHERE ID = '".HOTEL_ID."'"));
$months = array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
?>
Open between :
=$opents[0]?>
=$months[($opents[1]-1)]?>
/
=$opents[2]?>
=$months[($opents[3]-1)]?>
}
?>
}
?>
if(HOTEL_ID > 0)
{
$comments = mysql_query("SELECT * FROM comments WHERE idhotels='".HOTEL_ID."' AND status='1'");
$num_comm = mysql_num_rows($comments);
if($num_comm > 0)
{
$overall = mysql_fetch_row(mysql_query("SELECT SUM(overall_vote) FROM comments WHERE idhotels='".HOTEL_ID."' AND status='1'"));
$overall_media = sprintf("%.1f",($overall[0]/$num_comm));
$room_comfort = mysql_fetch_row(mysql_query("SELECT SUM(room_comfort) FROM comments WHERE idhotels='".HOTEL_ID."' AND status='1'"));
$room_comfort_media = sprintf("%.1f",($room_comfort[0]/$num_comm));
$service_quality = mysql_fetch_row(mysql_query("SELECT SUM(service_quality) FROM comments WHERE idhotels='".HOTEL_ID."' AND status='1'"));
$service_quality_media = sprintf("%.1f",($service_quality[0]/$num_comm));
$food = mysql_fetch_row(mysql_query("SELECT SUM(food) FROM comments WHERE idhotels='".HOTEL_ID."' AND status='1'"));
$food_media = sprintf("%.1f",($food[0]/$num_comm));
$prices = mysql_fetch_row(mysql_query("SELECT SUM(prices) FROM comments WHERE idhotels='".HOTEL_ID."' AND status='1'"));
$prices_media = sprintf("%.1f",($prices[0]/$num_comm));
}
else
{
$overall_media = "0.0";
$room_comfort_media = "0.0";
$service_quality_media = "0.0";
$food_media = "0.0";
$prices_media = "0.0";
}
mysql_query("UPDATE hotels SET ovmedia='$overall_media' WHERE ID='".HOTEL_ID."'");
$eab_nowdate = date("Y-m-d",time());
$eab = mysql_fetch_array(mysql_query("SELECT * FROM early_booking WHERE idhotels='".HOTEL_ID."' AND eb_date_from<='$eab_nowdate' AND eb_date_to>='$eab_nowdate' AND eb_date>'$eab_nowdate'"));
$eab_icons = mysql_fetch_array(mysql_query("SELECT * FROM early_booking WHERE idhotels='".HOTEL_ID."' AND eb_date>'$eab_nowdate'"));
//$eab = mysql_fetch_array(mysql_query("SELECT * FROM early_booking WHERE idhotels='".HOTEL_ID."' AND eb_date>'$eab_nowdate'"));
?>
$hoteltype = mysql_query("SELECT * FROM hoteltype_list WHERE idhotels='".HOTEL_ID."' AND vote>'0'");
$hotgen = mysql_query("SELECT * FROM hotel_general_vote WHERE idhotels='".HOTEL_ID."' AND comment!=''");
if(mysql_num_rows($hoteltype) > 0 || mysql_num_rows($hotgen) > 0)
{
?>
$j=0;
$serv_hotel = mysql_query("SELECT * FROM service_hotel ORDER BY name ASC");
while($seh = mysql_fetch_array($serv_hotel))
{
$check_sh = mysql_num_rows(mysql_query("SELECT * FROM serv_in_hotel WHERE idhotels='".HOTEL_ID."' AND idservice_hotel='$seh[ID]'"));
$imagename = ($check_sh > 0)?"tick.gif":"cross.gif";
if($j%2==0)
{
?>
}
?>
=$seh[name]?>
if($j%2==1)
{
?>
}
$j++;
}
?>
$j=0;
$serv_room = mysql_query("SELECT * FROM service_room ORDER BY name ASC");
while($ser = mysql_fetch_array($serv_room))
{
$check_sr = mysql_num_rows(mysql_query("SELECT * FROM serv_in_room WHERE idhotels='".HOTEL_ID."' AND idservice_room='$ser[ID]'"));
$imagename = ($check_sr > 0)?"tick.gif":"cross.gif";
if($j%2==0)
{
?>
}
?>
=$ser[name]?>
if($j%2==1)
{
?>
}
$j++;
}
?>
Sincere reviews from real travellers of =SITENAME?> who have stayed in these hotels already.
Overall Satisfaction
Based on =$num_comm?> reviews
=$overall_media?>
Room Comfort
Service Quality
Food & Beverages
Value for Money
=$room_comfort_media?>
=$service_quality_media?>
=$food_media?>
=$prices_media?>
The rating system is scored from 1 (poor) to 5 (excellent).
$lastcom = mysql_query("SELECT * FROM comments WHERE idhotels='".HOTEL_ID."' AND status='1' ORDER BY ID DESC LIMIT 2");
$months2 = array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
while($lst = mysql_fetch_Array($lastcom))
{
$country = mysql_fetch_row(mysql_query("SELECT name FROM countries WHERE ID='$lst[idcountries]'"));
?>
$hotdeals = mysql_query("SELECT * FROM hotel_home_list WHERE idhotels='".HOTEL_ID."' AND hotpage='1'");
if(mysql_num_rows($hotdeals) > 0)
{
?>
}
$hotmonth = mysql_query("SELECT * FROM hotel_home_list2 WHERE idhotels='".HOTEL_ID."' AND hotpage='1'");
if(mysql_num_rows($hotmonth) > 0)
{
?>
}
?>
$eab_list = mysql_query("SELECT * FROM early_booking WHERE idhotels='".HOTEL_ID."' AND eb_date>'$eab_nowdate' ORDER BY eb_date ASC");
if(mysql_num_rows($eab_list) > 0)
{
?>
}
?>
$nowdate = date("Y-m-d",time());
$qseas = mysql_query("SELECT codenum FROM periods2 WHERE idhotels='".HOTEL_ID."' AND pday='".$nowdate."' ORDER BY pday ASC");
$rqs = mysql_fetch_row($qseas);
$discloc = mysql_fetch_row(mysql_query("SELECT signtype,locdisc FROM hotels_locations WHERE idhotels='".HOTEL_ID."' AND idlocations='".IDLOC."'"));
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]."' AND $adult_price_field>'0'"));
if($discloc[1] > 0)
{
if($discloc[0] == 'p')
$lowest_price = $low_price[0]+($low_price[0]*$discloc[1]/100);
else
$lowest_price = $low_price[0]-($low_price[0]*$discloc[1]/100);
}
else
$lowest_price = $low_price[0];
if($eab['eb_perc'] > 0)
{
$price_start_show_strike = sprintf("".$_SESSION['cursym']."%.2f ",($lowest_price/2));
$price_start_show = sprintf("%.2f",(($lowest_price-($lowest_price*$eab['eb_perc']/100))/2));
}
else
$price_start_show .= sprintf("%.2f",($lowest_price/2));
if($price_start_show > 0)
{
$check_bonus = mysql_query("SELECT b.idbonus,c.bonus_perc FROM bonus_hotels b,bonus c WHERE b.idhotels='".HOTEL_ID."' AND (c.datefrom<='".date("Y-m-d",time())."' AND c.dateto>='".date("Y-m-d",time())."') AND c.active='1' ORDER BY c.bonus_perc DESC LIMIT 1");
if(mysql_num_rows($check_bonus) > 0) // bonus found
{
$bnid = mysql_fetch_row($check_bonus);
$bonus_perc = $bnid[1];
}
else
$bonus_perc = 0;
$check_if_hide_prices = mysql_fetch_row(mysql_query("SELECT hideprice FROM hotels_hide_price WHERE idhotels='".HOTEL_ID."'"));
$hide_price = $check_if_hide_prices[0];
if($hide_price == 'n')
{
?>
Starting from =$price_start_show_strike?> =$_SESSION['cursym']?>=$price_start_show?> x person
if($bonus_perc > 0)
{
?>
NOW YOU CAN EARN =$bonus_perc?>% BONUS from each reservation
}
?>
}
}
}
?>
/// related hotels
$hotel_related = mysql_query("SELECT * FROM hotel_related_hotels WHERE idhotels='".HOTEL_ID."' ORDER BY RAND()") or die(mysql_error());
if(mysql_num_rows($hotel_related) > 0)
{
$h=0;
?>
}
$cityname = mysql_fetch_row(mysql_query("SELECT name FROM city WHERE ID='".$hotel_det['idcity']."'"));
?>