\n"; $i =1; while($trow = mysql_fetch_array($res)) { $tour_name = stripslashes($trow["tour_name"]); $handler = trim($trow["handler"]); $purl = "$site_url/tours-".$handler.".html"; $detx = substr($tour_name, 0, 28); if($handler =="great-american-steamboat-company") {$tour_op = substr($tour_name, 0, 27)."."; } elseif(strlen($tour_name) > 28) { $tour_op = $detx;} else{$tour_op = $tour_name;} if($handler == 'alexander-roberts'){ $bord = "style='border:1px solid #000 !important'";}else{$bord = "style='border:0px'";} if(file_exists('tour_operators/'.$handler.'.jpg')){ $logo_cont = "\"$tour_name\"
$tour_op";}else{$logo_cont = "$tour_op";} if (is_int($i / $cols)){ $alltours .="
$logo_cont
"; }else{ $alltours .="
$logo_cont
"; } $i++; }//close loop $alltours .="\n"; return $alltours; } /********************* River Cruise Operators Listing ****************************/ function rCruiseConts() { global $site_url; $cols = 4; $res = mysql_query("SELECT * FROM river_cruises WHERE status ='Active' Order by tour_name"); $alltours ="\n"; $i =1; while($trow = mysql_fetch_array($res)) { $tour_name = stripslashes($trow["tour_name"]); $handler = trim($trow["handler"]); $purl = "$site_url/river_cruises-".$handler.".html"; $detx = substr($tour_name, 0, 28); if($handler =="great_american_steamboat_company") {$tour_op = substr($tour_name, 0, 27)."."; } elseif($handler == "uniworld_boutique_river_cruises") { $tour_op ="Uniworld River Cruises"; } elseif(strlen($tour_name) > 28) { $tour_op = $detx;} else{$tour_op = $tour_name;} if(file_exists('tour_operators/'.$handler.'.jpg')){ $logo_cont = "\"$tour_name\"
$tour_op";}else{$logo_cont = "$tour_op";} if (is_int($i / $cols)){ $alltours .=""; }else{ $alltours .=""; } $i++; }//close loop $alltours .="
$logo_cont
$logo_cont
\n"; return $alltours; } global $tour_type; if($tp){$pext = "tp=$tp";}else{$pext = "pg=$tour_type";} /*********** Brendan ************** function brendest($tid, $coun='') { if($coun){$ctWhere = "AND Region='$coun'";}else{$ctWhere = "";} $sql = mysql_query("SELECT * FROM brendancountries WHERE tourID='$tid' $ctWhere ORDER by CountryName"); $cnt = mysql_num_rows($sql); $i = 1; while ($row = mysql_fetch_array($sql)) { $CouName = stripslashes($row["CountryName"]); if($i == $cnt){$coml ='';}else{$coml = ", ";} $CountryName .="$CouName$coml"; $i++; } return $CountryName; } $brendan_ind =""; IF($Destination) { $sqlx = mysql_query("SELECT * FROM brendanvacations LEFT JOIN brendancountries ON brendanvacations.tourID=brendancountries.tourID WHERE brendancountries.Region='$Destination'"); $cnt = mysql_num_rows($sqlx); $i = 1; while ($rows = mysql_fetch_array($sqlx)) { $tourID = trim($rows["tourID"]); $TourName = txtClean(stripslashes($rows["TourName"])); $Days = trim($rows["TourLength"]); $From = number_format($rows['StartingPrice'], 2); if($i == $cnt){$bliner ='';}else{$bliner = "class=\"btmln\"";} list($class) = mysql_fetch_array(mysql_query("SELECT CategoryName AS class FROM brendanHotelCats WHERE tourID='$tourID'")); $brendan_ind .="\n"; $i++; } }ELSE{ $SQLi = mysql_query("SELECT Region FROM brendancountries GROUP BY Region"); while ($regs = mysql_fetch_array($SQLi)) { $region = $regs["Region"]; $sqlx = mysql_query("SELECT * FROM brendanvacations LEFT JOIN brendancountries ON brendanvacations.tourID=brendancountries.tourID WHERE brendancountries.Region='$region'"); $cnt = mysql_num_rows($sqlx); if($cnt > 0) { $brendan_ind .="\n"; $i = 1; while ($rows = mysql_fetch_array($sqlx)) { $tourID = trim($rows["tourID"]); $TourName = txtClean(stripslashes($rows["TourName"])); $Days = trim($rows["TourLength"]); $From = number_format($rows['StartingPrice'], 2); if($i == $cnt){$bliner ='';}else{$bliner = "class=\"btmln\"";} list($class) = mysql_fetch_array(mysql_query("SELECT CategoryName AS class FROM brendanHotelCats WHERE tourID='$tourID'")); $brendan_ind .="\n"; $i++; } } } } //end loop for region $brendan_ind .="
Vacation Name Destinations Days Company Quality From
$TourName ".brendest($tourID,$Destination)." $Days Brendan $class \$$From
Brendan Vacations - $region
$TourName ".brendest($tourID,$Destination)." $Days Brendan $class \$$From
"; ********** Brendan Vac *****************/ function tour_detail($id){ $sqlx2q = mysql_query("SELECT * FROM bvusas_tdepart where marketvariationcode='$id' ORDER BY id"); if($data=@mysql_fetch_array($sqlx2q)){} return $data; } $brendan_ind =""; $sqlx = mysql_query("SELECT * FROM bvusas_tinfo group by contv ORDER BY contv,ctrv"); $cnt = mysql_num_rows($sqlx); if($cnt > 0) { while ($rows1 = mysql_fetch_array($sqlx)) { $sqlx2q = mysql_query("SELECT * FROM bvusas_tinfo where contv='$rows1[contv]' ORDER BY duration asc"); $cntq = mysql_num_rows($sqlx2q); if($cntq > 0) { $brendan_ind .="\n"; $xyr = date("Y")+1; $yr = date("Y"); $i = 1; while ($rows = mysql_fetch_array($sqlx2q)) { //$prd_Name = txtClean(stripslashes($rows["prd_Name"])); $price_d=tour_detail($rows[mvcode]); $ty=explode("@",$price_d[dpdetail]); $ty_price=explode("#",$ty[0]); $price=explode("!",$ty_price[1]); $cur_s="$"; $ctry=explode("~",$rows[ctrv]); for($j=0;$j \n"; $i++; $country=''; }} } } //end loop for region $brendan_ind .="
Vacation Name Destinations Days Company Quality From
Brendan - $rows1[contv]
$rows[tourname]
$country
 $rows[duration] Brendan $rows[cat_name] $cur_s".number_format($price[3], 2)."
"; /*********** Collette *****************/ $collette_ind =""; $sqlx = mysql_query("SELECT * FROM collette_tours ORDER BY region,Number_Of_Days,Tour_Name"); $cnt = mysql_num_rows($sqlx); while($rows = mysql_fetch_array($sqlx)){ $result[] = $rows; } $region = ''; IF($cnt > 0) { foreach($result as $row) { $tourID = trim($row["Tour_Id"]); $TourName = txtClean(stripslashes($row["Tour_Name"])); $Days = trim($row["Number_Of_Days"]); $From = number_format((float)$row['Price_From'], 2); $destinations = trim($row["destinations"]); if ($region != $row['region']) { $region = $row['region']; $collette_ind .=""; } if($i == $cnt){$bliner ='';}else{$bliner = "class=\"btmln\"";} $collette_ind .="\n"; } } $collette_ind .="
Vacation Name Destinations Days Company From
Collette - ".$region."
$TourName $destinations $Days Collette \$$From
"; /*********** Amawater Ways *******************/ function leastPrc($IGPID) { $price =""; $sql = mysql_query("SELECT cruise_only_pr FROM `ama_dates_prices` WHERE IGPID='".$IGPID."' ORDER BY cruise_only_pr ASC LIMIT 1"); $cnt = mysql_num_rows($sql); $rows = mysql_fetch_array($sql); $price = $rows["cruise_only_pr"]; return $price; } $amawaterways_ind =""; $query = mysql_query("SELECT * FROM `ama_cruises_information` GROUP by REGION_NAME ORDER BY CRUISE_YEAR,idx"); $cnt = mysql_num_rows($query); if($cnt > 0) { while ($rows1 = mysql_fetch_array($query)) { $sqlx1 = mysql_query("SELECT * FROM `ama_cruises_information` WHERE REGION_NAME='".$rows1["REGION_NAME"]."' ORDER BY CRUISE_YEAR,idx"); $cntq = mysql_num_rows($sqlx1); if($cntq > 0) { $amawaterways_ind .="\n"; $i = 1; while ($rows = mysql_fetch_array($sqlx1)) { $IGPID = $rows["IGPID"]; $ID = $rows["ID"]; $ITI_CODE = $rows["ITI_CODE"]; $CRUISE_YEAR = $rows["CRUISE_YEAR"]; $CRUISE_NAME = $rows["CRUISE_NAME"]; $sqlx2 = mysql_query("SELECT * FROM `ama_dates_prices` WHERE IGPID='".$IGPID."'"); $irow = mysql_fetch_array($sqlx2); $starts_in = $irow["embarkation_city"]; $ends_in = $irow["disembarkation_city"]; $starting_price = leastPrc($IGPID); $days = $irow["nights"] + 1; if($starting_price>0) { $price_from = "\$".number_format($starting_price,2).""; }else{ $price_from='Call'; } if($i == $cnt){$bliner ='';}else{$bliner = "class=\"btmln\"";} $amawaterways_ind .="\n"; $i++; } }//$cntq }//end loop }//$cnt $amawaterways_ind .="
River Cruises Starts in Ends in Days Company From
Ama - ".$rows1["REGION_NAME"]."
$CRUISE_NAME $CRUISE_YEAR $starts_in $ends_in $days Ama $price_from
"; /*********** Abercrombie & Kent ***************/ $aandk_ind =""; $sqlx = mysql_query("SELECT * FROM ak_feed group by series ORDER BY id"); $cnt = mysql_num_rows($sqlx); if($cnt > 0) { while ($rows1 = mysql_fetch_array($sqlx)) { $sqlx2q = mysql_query("SELECT * FROM ak_feed where series='$rows1[series]' ORDER BY days asc"); $cntq = mysql_num_rows($sqlx2q); if($cntq > 0) { $aandk_ind .="\n"; $xyr = date("Y")+1; $yr = date("Y"); $i = 1; while ($rows = mysql_fetch_array($sqlx2q)) { if($rows["base_price"]>0) { $cur_s="$"; $price="".number_format($rows["base_price"],2).""; }else{ $cur_s=""; $price='Call'; } $ctry=explode(",",$rows['ctr']); for($j=0;$j \n"; $i++; $country=''; }} } } //end loop for region /*********** AK Tour ***************** $aandk_ind ="
Vacation Name Destinations Days Company Price From
Abercrombie & Kent - ".$rows1["series"]."
".stripslashes($rows["name"])." ".$rows["brochure_year"]."
".substr($country,0,-2)."
 ".$rows["days"]." A & K $cur_s $price
"; if($Destination!=''){ $sqlx2q = mysql_query("SELECT * FROM ak_feed LEFT JOIN crt_countries ON ak_feed.ctr LIKE crt_countries.country_name WHERE crt_countries.region='$Destination'"); $cntq = mysql_num_rows($sqlx2q); if($cntq > 0) { $xyr = date("Y")+1; $yr = date("Y"); $i = 1; while ($rows = mysql_fetch_array($sqlx2q)) { if($rows[base_price]>0) { $price="$".number_format($rows[base_price], 2); }else{ $price='Call'; } if($i == $cnt){$bliner ='';}else{$bliner = "class=\"btmln\"";} $aandk_ind .="\n"; $i++; $country=''; }} }else{ $sqlx = mysql_query("SELECT region FROM crt_countries GROUP BY region"); $cnt = mysql_num_rows($sqlx); if($cnt > 0) { while ($rows1 = mysql_fetch_array($sqlx)) { $region = $rows1["region"]; $sqlx2q = mysql_query("SELECT * FROM ak_feed LEFT JOIN crt_countries ON ak_feed.ctr LIKE crt_countries.country_name WHERE crt_countries.region='$region'"); $cntq = mysql_num_rows($sqlx2q); if($cntq > 0) { $aandk_ind .="\n"; $xyr = date("Y")+1; $yr = date("Y"); $i = 1; while ($rows = mysql_fetch_array($sqlx2q)) { if($rows[base_price]>0) { $price="$".number_format($rows[base_price], 2); }else{ $price='Call'; } if($i == $cnt){$bliner ='';}else{$bliner = "class=\"btmln\"";} $aandk_ind .="\n"; $i++; $country=''; }} } }} //end loop for region *********************************/ $aandk_ind .="
Vacation Name Destinations Days Company From
".stripslashes($rows[name])."
$rows[ctr]
 $rows[days] A & K $price
AK - $region
".stripslashes($rows[name])."
$rows[ctr]
 $rows[days] A & K $price
"; /*********** Viking River Cruises *****************/ $viking_ind =""; IF($Destination) { $sqlx = mysql_query("SELECT * FROM vikingRiverCruises LEFT JOIN vikingCruiseTypes ON vikingRiverCruises.GroupName=vikingCruiseTypes.GroupName WHERE vikingRiverCruises.Region='$Destination' GROUP BY vikingRiverCruises.CruiseName, vikingCruiseTypes.Year ORDER BY vikingCruiseTypes.Year ASC"); $cnt = mysql_num_rows($sqlx); $i = 1; while ($row = mysql_fetch_array($sqlx)) { $id = $row['id']; $PackageCode = $row['PackageCode']; $vid = $row['vid']; $Year = $row['Year']; $GroupName = $row['GroupName']; $CruiseName = $row['CruiseName']; $Duration = $row['Duration']; $FromCity = $row['FromCity']; $ToCity = $row['ToCity']; list($PriceFrom) = mysql_fetch_array(mysql_query("SELECT Price AS PriceFrom FROM vikingDatesPrices WHERE PackageCode = '$PackageCode' ORDER BY Price ASC LIMIT 1")); list($xPriceFrom) = mysql_fetch_array(mysql_query("SELECT BrochurePrice AS xPriceFrom FROM vikingDatesPrices WHERE PackageCode = '$PackageCode' ORDER BY BrochurePrice ASC LIMIT 1")); if($PriceFrom > 0){ $Pricing = "\$".number_format($PriceFrom, 2);} elseif($PriceFrom == 0 && $xPriceFrom > 0){ $Pricing = "\$".number_format($xPriceFrom, 2);}else{$Pricing = "Call";} if($i == $cnt){$bliner ='';}else{$bliner = "class=\"btmln\"";} $viking_ind .="\n"; $i++; } }ELSE{ $SQLi = mysql_query("SELECT Region FROM vikingRiverCruises GROUP BY Region"); while ($regs = mysql_fetch_array($SQLi)) { $region = $regs["Region"]; $sqlx = mysql_query("SELECT * FROM vikingRiverCruises LEFT JOIN vikingCruiseTypes ON vikingRiverCruises.GroupName=vikingCruiseTypes.GroupName WHERE vikingRiverCruises.Region='$region' GROUP BY vikingRiverCruises.CruiseName, vikingCruiseTypes.Year ORDER BY vikingCruiseTypes.Year ASC"); $cnt = mysql_num_rows($sqlx); if($cnt > 0) { $viking_ind .="\n"; $i = 1; while ($row = mysql_fetch_array($sqlx)) { $id = $row['id']; $PackageCode = $row['PackageCode']; $vid = $row['vid']; $Year = $row['Year']; $GroupName = $row['GroupName']; $CruiseName = $row['CruiseName']; $Duration = $row['Duration']; $FromCity = $row['FromCity']; $ToCity = $row['ToCity']; list($PriceFrom) = mysql_fetch_array(mysql_query("SELECT Price AS PriceFrom FROM vikingDatesPrices WHERE PackageCode = '$PackageCode' ORDER BY Price ASC LIMIT 1")); list($xPriceFrom) = mysql_fetch_array(mysql_query("SELECT BrochurePrice AS xPriceFrom FROM vikingDatesPrices WHERE PackageCode = '$PackageCode' ORDER BY BrochurePrice ASC LIMIT 1")); if($PriceFrom > 0){ $Pricing = "\$".number_format($PriceFrom, 2);} elseif($PriceFrom == 0 && $xPriceFrom > 0){ $Pricing = "\$".number_format($xPriceFrom, 2);}else{$Pricing = "Call";} if($i == $cnt){$bliner ='';}else{$bliner = "class=\"btmln\"";} $viking_ind .="\n"; $i++; } } } } //end loop for region $viking_ind .="
Vacation Name Days Starts In Ends In Style Quality From
$GroupName $Year ($CruiseName) $Duration $FromCity $ToCity River Cruise Deluxe $Pricing
Viking River Cruises - $region
$GroupName $Year ($CruiseName) $Duration $FromCity $ToCity River Cruise Deluxe $Pricing
"; /*********** Africantravel *****************/ $africantrvl_ind =""; $sqlx = mysql_query("SELECT * FROM african_popular group by extra ORDER BY id"); $cnt = mysql_num_rows($sqlx); if($cnt > 0) { while ($rows1 = mysql_fetch_array($sqlx)) { $sqlx2q = mysql_query("SELECT * FROM african_popular where extra='$rows1[extra]' ORDER BY Days asc"); $cntq = mysql_num_rows($sqlx2q); if($cntq > 0) { $africantrvl_ind .="\n"; $xyr = date("Y")+1; $yr = date("Y"); $i = 1; while ($rows = mysql_fetch_array($sqlx2q)) { $pricepart=explode("^",$rows[acco_pricing]); $price=explode("~",$pricepart[0]); if($price[2]!='Contact Us' && $price[2]!='N/A'){ $cxf="$"; $priceo=$price[2]; }else{ $cxf=''; $priceo='Call'; } $priceo = str_replace("From", "", $priceo); if($i == $cnt){$bliner ='';}else{$bliner = "class=\"btmln\"";} $africantrvl_ind .="\n"; $i++; }} } } //end loop for region $africantrvl_ind .="
Vacation Name Destinations Days Company From
African Travel, Inc. - $rows1[extra]
$rows[TourTitle] $rows[Country] $rows[Days] Africantrvl $cxf$priceo
"; /*********** Contiki Travel *****************/ function cntour_detail($id){ $sqlx2q = mysql_query("SELECT * FROM chusas_tdepart where marketvariationcode='$id' ORDER BY id"); if($data=@mysql_fetch_array($sqlx2q)){} return $data; } $contiki_ind =""; $sqlx = mysql_query("SELECT * FROM chusas_tinfo group by contv ORDER BY contv,ctrv"); $cnt = mysql_num_rows($sqlx); if($cnt > 0) { while ($rows1 = mysql_fetch_array($sqlx)) { $sqlx2q = mysql_query("SELECT * FROM chusas_tinfo where contv='$rows1[contv]' ORDER BY duration asc"); $cntq = mysql_num_rows($sqlx2q); if($cntq > 0) { $contiki_ind .="\n"; $xyr = date("Y")+1; $yr = date("Y"); $i = 1; while ($rows = mysql_fetch_array($sqlx2q)) { //$prd_Name = txtClean(stripslashes($rows["prd_Name"])); $price_d=cntour_detail($rows[mvcode]); $ty=explode("@",$price_d[dpdetail]); $ty_price=explode("#",$ty[0]); $price=explode("!",$ty_price[1]); $cur_s="$"; $ctry=explode("~",$rows[ctrv]); for($j=0;$j \n"; $i++; $country=''; }} } } //end loop for region $contiki_ind .="
Vacation Name Destinations Days Company Quality From
Contiki Travel - $rows1[contv]
$rows[tourname]
$country
 $rows[duration] Contiki $rows[cat_name] $cur_s".number_format($price[3], 2)."
"; /*********** Insight Vacations *****************/ function intour_detail($id){ $sqlx2q = mysql_query("SELECT * FROM ivusas_tdepart where marketvariationcode='$id' ORDER BY id"); if($data=@mysql_fetch_array($sqlx2q)){} return $data; } $insight_ind =""; $sqlx = mysql_query("SELECT * FROM ivusas_tinfo group by contv ORDER BY contv,ctrv"); $cnt = mysql_num_rows($sqlx); if($cnt > 0) { while ($rows1 = mysql_fetch_array($sqlx)) { $sqlx2q = mysql_query("SELECT * FROM ivusas_tinfo where contv='$rows1[contv]' ORDER BY duration asc"); $cntq = mysql_num_rows($sqlx2q); if($cntq > 0) { $insight_ind .="\n"; $xyr = date("Y")+1; $yr = date("Y"); $i = 1; while ($rows = mysql_fetch_array($sqlx2q)) { //$prd_Name = txtClean(stripslashes($rows["prd_Name"])); $price_d=intour_detail($rows[mvcode]); $ty=explode("@",$price_d[dpdetail]); $ty_price=explode("#",$ty[0]); $price=explode("!",$ty_price[1]); $cur_s="$"; $ctry=explode("~",$rows[ctrv]); for($j=0;$j \n"; $i++; $country=''; }} } } //end loop for region $insight_ind .="
Vacation Name Destinations Days Company Quality From
Insight Vacations - $rows1[contv]
$rows[tourname]
$country
 $rows[duration] Insight $rows[cat_name] $cur_s".number_format($price[3], 2)."
"; /*********** Trafalgar *****************/ function tftour_detail($id){ $sqlx2q = mysql_query("SELECT * FROM ttusas_tdepart where marketvariationcode='$id' ORDER BY id"); if($data=@mysql_fetch_array($sqlx2q)){} return $data; } $trafalgar_ind =""; $sqlx = mysql_query("SELECT * FROM ttusas_tinfo group by contv ORDER BY contv,ctrv"); $cnt = mysql_num_rows($sqlx); if($cnt > 0) { while ($rows1 = mysql_fetch_array($sqlx)) { $sqlx2q = mysql_query("SELECT * FROM ttusas_tinfo where contv='$rows1[contv]' ORDER BY duration asc"); $cntq = mysql_num_rows($sqlx2q); if($cntq > 0) { $trafalgar_ind .="\n"; $xyr = date("Y")+1; $yr = date("Y"); $i = 1; while ($rows = mysql_fetch_array($sqlx2q)) { $price_d=tftour_detail($rows[mvcode]); $ty=explode("@",$price_d[dpdetail]); $ty_price=explode("#",$ty[0]); $price=explode("!",$ty_price[1]); $cur_s="$"; $ctry=explode("~",$rows[ctrv]); for($j=0;$j \n"; $i++; $country=''; }} } } //end loop for region $trafalgar_ind .="
Vacation Name Destinations Days Company From
Trafalgar - $rows1[contv]
$rows[tourname]
$country
 $rows[duration] Trafalgar $cur_s".number_format($price[3], 2)."
"; /*********** displayTours fxn ************/ function displayTours($text){ global $brendan_ind,$collette_ind,$aandk_ind,$africantrvl_ind, $contiki_ind, $insight_ind, $trafalgar_ind; $text = str_replace('[ALLTOUROPERATORS]', tourConts(), $text); $text = str_replace('[BRENDANTOURS]', $brendan_ind, $text); $text = str_replace('[COLLETTETOURS]', $collette_ind, $text); $text = str_replace('[AandKTOURS]', $aandk_ind, $text); $text = str_replace('[AFRICANTRAVEL]', $africantrvl_ind, $text); $text = str_replace('[CONTIKI]', $contiki_ind, $text); $text = str_replace('[INSIGHT]', $insight_ind, $text); $text = str_replace('[TRAFALGAR]', $trafalgar_ind, $text); $text = str_replace("[COSMOS]", "", $text); $text = str_replace("[GLOBUS]", "", $text); $text = str_replace("[MONOGRAMS]", "", $text); $text = trim($text); return $text; } /*********** displayTours fxn ************/ function displayRCruises($text){ global $amawaterways_ind,$viking_ind; $text = str_replace('[RIVERCRUISES]', rCruiseConts(), $text); $text = str_replace('[AMAWATERWAYS]', $amawaterways_ind, $text); $text = str_replace('[VIKINGRIVERCRUISES]', $viking_ind, $text); $text = str_replace("[AVALONWATERWAYS]", "", $text); $text = trim($text); return $text; } /**************** End rePlacer **********************/ ?> |

Call:

Welcome to !

"; }else{ echo $pcontents."
"; } include("footer.inc.php"); ?>