File: hetels-list.php this is called via the iframe in index.php
| > Uses MySQL Database to generate markers dynamically
| > Module written by: Sreeprakash. N
| > Date started: 7/15/2005
|
| > Module Version Number: 1.0.0
| > DBA Checked: Najeeb Jabbar
| > Quality Checked: by Gayatri. S. Prakash
+-------------------------------------------------------------------------
*/
/*-------------------------------------------------------------------------*/
// This include file has MySQL DB Details and functions
/*-------------------------------------------------------------------------*/
/*-------------------------------------------------------------------------*/
// This include file has MySQL DB Details and functions
/*-------------------------------------------------------------------------*/
require("admin/inc/config.inc");
include("phpweather/phpweather.php");
require("phpweather/output/pw_text_en.php");
require("phpweather/output/pw_images.php");
/*-------------------------------------------------------------------------*/
// This file can be called with two parameters via Type and Name
/*-------------------------------------------------------------------------*/
if (!isset($_SESSION)) {
session_start();
}
$thisType=$_GET['Type']; //Restaurant , Real-Estate , default Hotel
$thisName=$_GET['Name']; //Abbey
if(!isset($thisType))$thisType=$_GET['type'];
if(!isset($thisName))$thisName=$_GET['name'];
if(!isset($thisType)||$thisType=="")$thisType="Hotel";
$_SESSION[thisType]=$thisType;
$xx="-80.224145";
$yy="25.787676";
if($thisType=="Disney"){
//The coordinates are different than our Miami Beach maps. Here are the coordinates to Kissimmee, FL:
//map.centerAndZoom(new GPoint(-81.412867, 28.303988), 6)
$xx="-81.412867";
$yy="28.303988";
}
if(!isset($thisName)||$thisType==""){
echo "Sorry, need the name of the $thisType.";
exit;
}else{
if($thisType=="Hotel"){
$sql="select * from tblMapDetails where type='Hotel' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'map-hotels.gif');
$details="Get rates";
$template='popuptemplate_hotel.htm';
}elseif($thisType=="Restaurant"){
$sql="select * from tblMapDetails where type='Restaurant' and name like '%$thisName%'";
//$tpl->assign("hotelsimage", 'restaurants.gif');
$details="Reservations";
$template='popuptemplate_restaurant.htm';
}elseif ($thisType=="Real-Estate"){// Real Estate
$sql="select * from tblMapDetails where type='RealEstate' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'map-real-estate.gif');
$details="Request a showing";
$template='popuptemplate_real_estate.htm';
}
elseif ($thisType=="Attractions"){
$sql="select * from tblMapDetails where type='Attractions' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'map-attractions.gif');
$details="Request a showing";
$template='popuptemplate_attractions.htm';
}
elseif ($thisType=="Disney"){
$sql="select * from tblMapDetails where type='Disney' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'disney-world.gif');
$details="Get rates";
$template='popuptemplate_disney.htm';
}
elseif ($thisType=="House-for-sale-by-owner"){
$sql="select * from tblMapDetails where type='House_For_Sale_By_Owner' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'map-house-for-sale.gif');
$details="Request a showing";
$template='popuptemplate_house_for_sale_by_owner.htm';
}
//Schogini: Edited by anish on 20-03-06
elseif ($thisType=="Nightlife"){
$sql="select * from tblMapDetails where type='Nightlife' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'restaurants-title.gif');
$details="Request a showing";
$template='popuptemplate_nightlife.htm';
}
//Schogini: Edited by anish on 19-04-06
elseif ($thisType=="Caribbean_Bahamas"){
$sql="select * from tblMapDetails where type='Caribbean_Bahamas' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'island.gif');
$details="Request a showing";
$template='popuptemplate_Caribbean_Bahamas.htm';
}
//Schogini: Edited by anish on 02-05-06
elseif ($thisType=="Shopping"){
$sql="select * from tblMapDetails where type='Shopping' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'shops-stores.gif');
$details="Request a showing";
$template='popuptemplate_Shopping.htm';
}
//Schogini: Edited by anish on 16-06-06
elseif ($thisType=="Traffic-Camera"){
$sql="select * from tblMapDetails where type='Traffic-Camera' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'shops-stores.gif');
$details="Request a showing";
$template='popuptemplate_traffic_camera.htm';
}
//Schogini: Edited by anish on 16-06-06
elseif ($thisType=="Visitor-Pass"){
$sql="select * from tblMapDetails where type='Visitor-Pass' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'shops-stores.gif');
$details="Get a Visitor Pass";
$template='popuptemplate_Visitor-Pass.htm';
}
//Schogini: Edited by anish on 29-07-06
elseif ($thisType=="Community"){
$sql="select * from tblMapDetails where type='Community' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'shops-stores.gif');
$details="Request a showing";
$template='popuptemplate_community.htm';
}
//Schogini: Edited by anish on 14-08-06
elseif ($thisType=="Recycling"){
$sql="select * from tblMapDetails where type='Recycling' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'shops-stores.gif');
$details="Request a showing";
$template='popuptemplate_recycling.htm';
}
//Schogini: Edited by anish on 02-09-06
elseif ($thisType=="Vacation-Rentals"){
$sql="select * from tblMapDetails where type='Vacation-Rentals' and name like '%$thisName%'";
$tpl->assign("hotelsimage", 'shops-stores.gif');
$details="Request a showing";
$template='popuptemplate_vacation-rentals.htm';
}
$resultall=gQuery($sql);
$numberall = $resultall->numRows($resultall);
if($numberall>1){
$html="Sorry, more than one record found.";
}else{
if($db_row=$resultall->fetchRow()){
$name=s($db_row[name]);
$street=s($db_row[street]);
$city=s($db_row[city]);
$image=s($db_row[image]);
$url2=$db_row[urldetails2];
$s1s="";$s1e="";
$s2s="";$s2e="";
$s3s="";$s3e="";
if($thisType=="Caribbean_Bahamas"){
$html="$s1s$name$s1e
";
$html.="$s2s{$street}
";
//$html.="$city, {$db_row[state]} {$db_row[zip]}$s2e
";
$html.="![](\"admin/mapimages/$image\")
";
}elseif($thisType=="Traffic-Camera"){//edited by anish 22-06-2006
$html="$s1s$name$s1e
";//edited by anish 01-07-2006 to remove link
$html.="$s2s{$street}
";
$html.="{$db_row[city]}, {$db_row[state]} $s2e
";
//edited by anish to make camera image live 22-07-2006
$html.="![](\"$url2\")
";
}else{
$html="$s1s$name$s1e
";
$html.="$s2s{$street}
";
$html.="$city, {$db_row[state]} {$db_row[zip]}$s2e
";
$html.="
";
}
/*$html="$s1s$name$s1e
";
$html.="$s2s{$street}
";
$html.="$city, {$db_row[state]} {$db_row[zip]}$s2e
";
$html.="
";*/
//Schogini: Edited by anish on 02-02-06 to display business details on rightside
$htmlside.="$s1s$name$s1e
";
$htmlside.="$s2s{$street}
";
$htmlside.="$city, {$db_row[state]} {$db_row[zip]}$s2e
";
if(isset($db_row[description])&&trim($db_row[description])!=""){
if($thisType=="Traffic-Camera"){
$new_desc=preg_replace("/\'/","\\'",$db_row[description]);
//$new_desc=substr($new_desc,0,20)."..";
//$new_desc=split_to_lines($new_desc,35);
$html.="$s2s{$new_desc}$s2e
";
}else{
$new_desc=preg_replace("/\'/","\\'",$db_row[description]);
//$new_desc=substr($new_desc,0,20)."..";
$new_desc=split_to_lines($new_desc,30);
$html.="$s2s{$new_desc}$s2e
";
}
}
/*$new_desc=preg_replace("/\'/","\\'",$db_row[description]);
//$new_desc=substr($new_desc,0,20)."..";
$new_desc=split_to_lines($new_desc,35);*/
$desc="$new_desc
"."";
//if(isset($db_row[description])&&trim($db_row[description])!="")
//$html.=$desc;
//Schogini: Edited by anish on 02-02-06 to display business details on rightside
//$htmlside.="{$db_row[description]}
";
if(!empty($db_row[description])&&trim($db_row[description])!="")$htmlside.=$desc;
if($thisType=="Visitor-Pass") {
$html.="$s3sBusiness Profile$s3e ";
$htmlside.="$s3sBusiness Profile$s3e ";
}elseif($thisType=="Traffic-Camera") {
//$html.="$s3sView Details$s3e ";
//$htmlside.="$s3sView Details$s3e ";
}else{
$html.="$s3sView Details$s3e ";
$htmlside.="$s3sView details$s3e ";
}
if(isset($db_row[urldetails2])&&trim($db_row[urldetails2])!=""){
//Schogini: Edited by anish on 02-02-06 to display business details on rightside
if($thisType!="Traffic-Camera") {
$html.="- $s3s$details$s3e
";
$htmlside.=" $s3s$details$s3e
";
}
}
if(isset($db_row[longitude])&&isset($db_row[lattide])){
if(trim($db_row[longitude])!=""&&trim($db_row[lattide])!=""){
$xx=$db_row[longitude];
$yy=$db_row[lattide];
}else{
$html="Sorry, coordinates not found.";
#$xx="-80.224145";
#$yy="25.787676";
}
}
}else{
$html="Sorry, record not found.";
}
}
}
//print "API: ".$api."
";
//Schogini: Edited by anish on 11-08-06 to display weather on rightside
$weather = new phpweather();
$data = $weather->decode_metar();
$type = 'pw_text_en';
$text = new $type($weather);
$icons = new pw_images($weather);
//echo $w['image']['url']."Anish";
$sign="°C";
$sign2="°F";
$sign=htmlentities($sign);
$sign2=htmlentities($sign2);
$tpl->assign("image1", $icons->get_sky_image());
$tpl->assign("image2", $icons->get_winddir_image());
$tpl->assign("image3", $icons->get_temp_image());
$tpl->assign("title1", $weather->get_location());
$tpl->assign("title2", $weather->get_location());
$tpl->assign("title3", $weather->get_location());
$tpl->assign("temp", $data['temperature']['temp_c'].$sign);
$tpl->assign("speed", $data['wind']['miles_per_hour']);
$tpl->assign("feel", $data['temperature']['temp_f'].$sign2);
$tpl->assign("dir", $data['wind']['deg']);
$tpl->assign("sky", $data['clouds'][0]['condition']);
$tpl->assign("types", $thisType);
$tpl->assign("api",$api);
$tpl->assign("hotelname",$name);
$tpl->assign("infohtml", "$html");
//Schogini: Edited by anish on 02-02-06 to display business details on rightside
$tpl->assign("inforightside", "$htmlside");
$tpl->assign("long", $xx);
$tpl->assign("latt", $yy);
$tpl->display($template);
?>