| |
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 907:
Undefined variable: product_name
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 908:
Undefined variable: product_detail
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 909:
Undefined variable: product_summary
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 920:
Undefined variable: product_duration
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 924:
Undefined variable: product_distance
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 928:
Undefined variable: product_mealcode
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 933:
Undefined variable: product_departurepoint
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
| |
|
| Duration: |
|
| Distance: |
|
| Meal Code: |
|
| Departures: |
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 935:
Undefined variable: product_format
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 943:
Undefined variable: product_format
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 954:
Undefined variable: product_departuretime
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 957:
Undefined variable: product_returntime
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
)
|
| Highlights: |
- Aboriginal Culture
- Coral Bay
- Kalbarri National Park
- Karijini National Park
- Monkey Mia
- Monkey Mia Dolphins
- Nambung National Park
- Ningaloo Reef
- Northern Beaches
- Pinnacles Desert
- Seasonal Wildflowers (Aug - Dec)
- Shell Beach & Stromatolites
- Canyoning
- Entry fees and meals as indicated
- Hiking
|
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 986:
Undefined variable: producttype_id
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
[row_highlights] =>
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 986:
Undefined variable: producttype_id
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
[row_highlights] =>
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 1044:
Undefined variable: product_specials
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
[row_highlights] =>
)
An error occurred in script '/home/ata/www/docs_xposure/httpdocs/includes/functions_itinerary.php' on line 1081:
Undefined variable: product_bookinginformation
Date/Time: 9-8-2010 00:50:25
Array
(
[product_code] =>
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 599
[query1] =>
SELECT
web_products.PRODUCT_ID,
web_products.PRODUCTTYPE_ID,
web_products.SEASON_ID,
web_products.SUPPLIER_ID,
web_products.LOCATION_ID,
web_products.REGION_ID,
web_products.AVAILABILITY_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_products.Product_Summary,
web_products.Product_DeparturePoint,
TIME_FORMAT(web_products.Product_DepartureTime, '%h:%i %p') AS Product_DepartureTime,
TIME_FORMAT(web_products.Product_ReturnTime, '%h:%i %p') AS Product_ReturnTime,
web_products.Product_Duration,
web_products.Product_Distance,
web_products.Product_MealCode,
web_products.Product_Specials,
web_products.Product_BookingInformation,
web_products.Product_Gallery,
web_products.Product_Picture,
web_products.Product_Map,
web_products.Product_Commissionable,
web_products.Product_Format,
web_products.Product_Level
FROM
web_products
WHERE
web_products.Product_Code = '' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #17
[query_departures] =>
SELECT
web_departuredays.DEPARTUREDAY_ID,
web_departuredays.DepartureDay_Day,
web_departures.DEPARTURE_ID,
DATE_FORMAT(web_departures.Departure_Date, '%D %M %Y') AS Departure_Date
FROM
web_departuredays
RIGHT OUTER JOIN web_departures ON (web_departuredays.DEPARTUREDAY_ID = web_departures.DEPARTUREDAY_ID)
WHERE
web_departures.PRODUCT_ID = '599'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #18
[query_highlights] =>
SELECT
web_highlightsandinclusions.HighlightAndInclusion_Description,
web_highlightsandinclusions.HighlightAndInclusion_Type
FROM
web_highlightsandinclusions
INNER JOIN `web_producthighlightsandinclusions` ON (web_highlightsandinclusions.HIGHLIGHTANDINCLUSION_ID = `web_producthighlightsandinclusions`.HIGHLIGHTANDINCLUSION_ID)
WHERE
`web_producthighlightsandinclusions`.PRODUCT_ID = '599'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #19
[query_options] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #20
[query_options2] =>
SELECT
web_products.PRODUCT_ID,
web_products.Product_Code,
web_products.Product_Name,
web_products.Product_Detail,
web_accommodations.Accommodation_Name
FROM
web_productdependance
INNER JOIN web_products ON (web_productdependance.PRODUCTSLAVE_ID = web_products.PRODUCT_ID)
INNER JOIN web_accommodations ON (web_productdependance.ACCOMMODATION_ID = web_accommodations.ACCOMMODATION_ID)
WHERE
web_products.Product_Active = '1' AND
web_productdependance.PRODUCTMASTER_ID = '599' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #21
[query_validity] =>
SELECT
web_seasons.SEASON_ID,
web_seasons.Season_Season,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo
FROM
web_seasons
WHERE
web_seasons.Season_Active = '1' AND
web_seasons.SEASON_ID = ''
[result_validity] => Resource id #22
[query_tourpath] =>
SELECT
web_itineraries.Itinerary_DayNumber,
web_itinerarydays.ItineraryDay_Title,
web_itineraries.Itinerary_MealCode,
web_itinerarydays.ItineraryDay_Content,
web_itineraryaccommodations.ITINERARYACCOMMODATION_ID,
web_itineraryaccommodations.ItineraryAccommodation_Name,
web_itineraries.Itinerary_Accommodation
FROM
web_itinerarydays
INNER JOIN web_itineraries ON (web_itinerarydays.ITINERARYDAY_ID = web_itineraries.ITINERARYDAY_ID)
INNER JOIN web_itineraryaccommodations ON (web_itineraries.ITINERARYACCOMMODATION_ID = web_itineraryaccommodations.ITINERARYACCOMMODATION_ID)
WHERE
web_itineraries.PRODUCT_ID = '599'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #23
[query_tourrates] =>
SELECT
web_products.Product_Code,
web_products.Product_OnlineDiscount,
DATE_FORMAT(web_seasons.Season_ValidFrom, '%D %M %Y') AS Season_ValidFrom,
DATE_FORMAT(web_seasons.Season_ValidTo, '%D %M %Y') AS Season_ValidTo,
web_productunits.ProductUnit_Unit,
web_productrates.ProductRate_Rate,
web_productunits.PRODUCTUNIT_ID,
web_producttypes.ProductType_OnlineDiscount,
ROUND((web_productrates.ProductRate_Rate - (web_productrates.ProductRate_Rate * ((web_products.Product_OnlineDiscount + web_producttypes.ProductType_OnlineDiscount) / 100))), 2) AS ProductRate_OnlineRate
FROM
web_seasons
INNER JOIN web_products ON (web_seasons.SEASON_ID = web_products.SEASON_ID)
INNER JOIN web_productrates ON (web_products.PRODUCT_ID = web_productrates.PRODUCT_ID)
INNER JOIN web_productunits ON (web_productrates.PRODUCTUNIT_ID = web_productunits.PRODUCTUNIT_ID)
INNER JOIN web_producttypes ON (web_products.PRODUCTTYPE_ID = web_producttypes.PRODUCTTYPE_ID)
WHERE
web_products.PRODUCT_ID = '599' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #24
[row_highlights] =>
[row_validity] =>
)
| Tour Path: |
| Day 1: Perth to Kalbarri (L, D)
|
|
We depart Perth and head North through market gardens and vineyards to join up with Highway 1 on our way to Nambung National Park and the fascinating Pinnacles Desert. After exploring these unique formations we continue our journey northwards along coastal roads to Geraldton.
After a short break we head out to some local sand dunes for an adrenalin rush sand boarding down these huge slopes. From here we continue on towards Kalbarri and our overnight accommodation.
Accommodation: Hostel
|
| |
| Day 2: Kalbarri to Shark Bay (L)
|
|
After an early rise we have a short drive to Murchison Gorge in Kalbarri National Park. Here we take time to view Natures Window, the Loop and discover the wonders of the Z-Bend Gorge. At Z-Bend Gorge it is an exhilarating 150 metre descent into the heart of the gorge – well worth the effort – where there is time to explore and swim in the tranquil fresh water pools. For the adventurous there is even an opportunity to try your hand at abseiling (optional activity at additional cost).
This afternoon it’s time to make our way toward Monkey Mia, stopping at the beautiful Shell Beach and then onto Denham for our overnight stop.
Accommodation: Hostel
|
| |
| Day 3: Shark Bay to Coral Bay (B, L, D)
|
|
After a short drive across the Peron Peninsula we make our way down to the beach and the world famous Monkey Mia dolphins – its a unique experience and there are some fantastic photo opportunities. Almost as famous as the dolphins are Monkey Mia’s pelicans. Check them out during the dolphin feeding.
Soon it is time to leave and head towards Carnarvon, however before we leave the Shark Bay area we stop at the fascinating stromatolites at Hamelin Pool. A take a well earned break at Carnarvon before we finish the day by driving the highway Coral Bay, the Jewel of the North.
Accommodation: Hostel
|
| |
| Day 4: Coral Bay to Exmouth (B, L, D)
|
|
Today is yours to explore Coral Bay and the wonders of the Ningaloo Reef and its fantastic marine life. You can go snorkeling, cruise on the glass bottom boat, take a quad bike tour or even a joy flight over the reef (all optional extra’s). Today is a day to relax.
Late afternoon and its time for the short drive into Exmouth.
Accommodation: Hostel
|
| |
| Day 5: Exmouth (B, L, D)
|
|
A full day to explore Exmouth. After breakfast it’s time to jump on the bus and head out to Yardie Creek in the Cape Range National Park. Then we start our slow return to Exmouth. Have a swim or sunbathe at beautiful Turquoise Bay and discover this northern part of Ningaloo Reef, Enjoy spectacular views from historic Vlahming Head Lighthouse, stroll along pristine beaches. We return to our hostel late afternoon.
Accommodation: Hostel
|
| |
| Day 7: Karijini National Park (B, L, D)
|
|
You will see why we have allowed the next two days to explore and bask in the magnificence of this National Park area and it’s Gorges. The Hamersly Ranges were formed over 2,500 million years ago and are some of the most unusual landforms on earth. From cascading waterfalls found deep in the gorges to fresh still pools ideal for swimming, we experience it all. Some of the gorges are so narrow that you can touch both sides at once.
Accommodation: Campground
|
| |
| Day 8: Karijini National Park (B, L, D)
|
|
Another day in the spectacular Karijini exploring the magnificent gorges, lookouts and swimming holes.
Accommodation: Campground
|
| |
| Day 9: Karijini National Park to Pardoo Station (B, L, D)
|
|
We depart Karijini this morning and take a leisurely drive out of the park towards outback Pardoo Station before spending our last night together before heading for Broome.
Accommodation: Caravan Park
|
| |
| Day 10: Pardoo Station to Broome (B, L)
|
|
On route to Broome today we enjoy a leisurely break and take in the glory of the stretching sands of 80 mile beach. Enjoy a stroll along the beach before we embark on our final leg into Broome.
|
| |
|
|
|
