0 )
{
$meta = mysql_fetch_object( $query );
$title = $meta->title;
$heading = $meta->heading;
$description = $meta->description;
$keywords = $meta->keywords;
}
elseif( $_GET['area'] == "itinerary" )
{
$cruise = explode("|", $_GET['cruiseid']);
$query = mysql_query("SELECT `rp`.`packageid`, `rp`.`saildate`, `r1`.`length`, `rp`.`packagedesc`, `rp`.`region`, `rs`.`name`, `r1`.`activitydate` AS `startdate`, `r2`.`activitydate` AS `enddate`, `r1`.`locationname` AS `embark`, `r2`.`locationname` AS `disembark` FROM `royalcarib_prices` `rp` JOIN `celebrity_ships` `rs` ON ( `rp`.`ship` = `rs`.`ship` ) JOIN `royalcarib_itinerary` `r1` ON ( `rp`.`packageid` = `r1`.`packageid` ) JOIN `royalcarib_itinerary` `r2` ON ( `rp`.`packageid` = `r2`.`packageid` ) WHERE `rp`.`packageid` = '".$cruise[0]."' AND `rp`.`saildate` = '".$cruise[1]."' AND `r1`.`saildate` = '".$cruise[1]."' AND `r2`.`saildate` = '".$cruise[1]."' ORDER BY `r1`.`activitydate` ASC, `r2`.`activitydate` DESC LIMIT 1");
$meta = mysql_fetch_object( $query );
$title = "Celebrity Cruises: ".ucwords( strtolower( substr( $meta->packagedesc, 3 ) ) )." aboard the ".$meta->name;
$heading = "Celebrity Cruise
".ucwords( strtolower( substr( $meta->packagedesc, 3 ) ) );
$description = "Celebrity Cruise ".ucwords( strtolower( substr( $meta->packagedesc, 3 ) ) )." aboard the ".$meta->name." departing on ".date("F d, Y", strtotime( $meta->saildate ) )." for ".$meta->length." nights.";
$keywords = "celebrity, celebrity cruise, celebrity itinerary, ".ucwords( strtolower( substr( $meta->packagedesc, 3 ) ) ).", ".$meta->name;
}
elseif( $_GET['area'] == "cruisecalendar" )
{
$ships = array("CN" => "Celebrity Century",
"CS" => "Celebrity Constellation",
"EC" => "Celebrity Eclipse",
"EQ" => "Celebrity Equinox",
"IN" => "Celebrity Infinity",
"MR" => "Celebrity Mercury",
"ML" => "Celebrity Millennium",
"SL" => "Celebrity Solstice",
"SM" => "Celebrity Summit",
"XP" => "Celebrity Xpedition");
$title = "Celebrity Cruises: Itinerary Search".( $_GET['s'] != "ANY" ? " - ".$ships[$_GET['s']] : "" )."".( $_GET['d'] != "ANY" ? " - ".$_GET['d'] : "" );
$heading = "Itinerary Search";
$description = "";
$keywords = "celebrity, celebrity cruise, celebrity itinerary, celebrity cruise search, celebrity itinerary search";
}
elseif( isset( $_GET['specialid'] ) )
{
if( isset( $_GET['specialid'] ) )
{
$link = mysql_connect('localhost', 'dusti_royalcarib', 'Royalcarib') or die('Could not connect');
mysql_select_db('dustin_roycalcarib') or die('Could not select database');
$query = mysql_query("SELECT * FROM `ail_specials` WHERE `id` = '" . $_GET['specialid'] . "' AND `cruise_line` = 'Celebrity' LIMIT 1");
if( mysql_num_rows( $query ) > 0 )
{
$s = mysql_fetch_object( $query );
}
else
{
header('HTTP/1.0 404 Not Found');
die();
}
$title = $s->heading;
$heading = $s->heading;
$description = $s->heading;
$keywords = $s->heading;
}
else
{
header('HTTP/1.0 404 Not Found');
die();
}
}
else
{
$title = "Celebrity Cruises";
$heading = "Celebrity Cruises";
$description = "Luxury Celebrity Cruise Ship Travel Agency: Providing luxury cruises at a discount to the group and the individual";
$keywords = "Celebrity Cruise, Carribean Cruises, Luxury Cruises, Celebrity Mediterranean Cruises, Celebrity cruises discounted, last minute cruise specials, royal caribbean, discounts cruises, discounted cruises, cheap cruises,cruising,special cruise offers, discounted cruises, budget cruises, cruises for less, inexpensive cruises,low cost cruises,low prices cruises,cruise consolidators,cruise ships,travels,holidays,vacations,honeymoons,weddings anniversaries,resorts,cabins,beach,sun,islands,caribbean cruises,southern caribbean cruises,eastern caribbean cruises,western caribbean cruises,bahamas cruises,alaska cruises,world cruises,bermuda cruises,mediterranean cruises,european cruises,greek islands cruises,transatlantic cruises,luxury cruises,panama canal cruises,orient cruises,african safari cruises,south pacific cruises,australia cruises,new zealand cruises, downunder cruises,european rivers cruises,russian cruises,india cruises,hawaiian cruises,new england cruises,fall foliage cruises,far east cruises,theme cruises,pga golf cruises,family cruises,upscale cruises,5 star cruises, all inclusive resorts";
}
echo "".$title."
";
?>
".$heading."";
?>
';
if( time() > strtotime( $s->end_date ) )
{
echo 'This Promotion has Expired. ';
}
echo '
' . $s->heading . '
' . $s->sub_heading . '
' . $s->main_content . '
Terms and Conditions: ' . $s->terms . '
';
}
else
{
header('HTTP/1.0 404 Not Found');
die();
}
}
else
{
include "news.php";
}
?>
Sail the World in the Lap of Luxury
111 2nd Ave NE Ste 610, St Petersburg, Florida 33701
Toll Free: (888) 313-8883 Phone: (727) 906-0444 Fax: (727) 906-0445
Fla. Seller of Travel Reg. ST-35612
© 2005- Atlantis International Ltd. Inc.