| |
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
| |
|
| 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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
|
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
)
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:13:36
Array
(
[product_code] => 9DB
[season_id] =>
[p] => 0
[prevproduct_id] =>
[nextproduct_id] =>
[product_id] => 0
[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 = '9DB' AND
web_products.SEASON_ID = ''
ORDER BY
web_products.SEASON_ID
[result1] => Resource id #16
[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 = '0'
ORDER BY
web_departures.Departure_Date
[result_departures] => Resource id #17
[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 = '0'
ORDER BY
web_highlightsandinclusions.HighlightAndInclusion_Type DESC,
web_highlightsandinclusions.HighlightAndInclusion_Description
[result_highlights] => Resource id #18
[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 = '0' AND
web_productdependance.ProductDependance_Type = '0'
ORDER BY
web_products.Product_Code
[result_options] => Resource id #19
[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 = '0' AND
web_productdependance.ProductDependance_Type = '1'
ORDER BY
web_products.Product_Code
[result_options2] => Resource id #20
[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 #21
[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 = '0'
ORDER BY
web_itineraries.Itinerary_DayNumber
[result_tourpath] => Resource id #22
[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 = '0' AND
web_productunits.ProductUnit_Active = '1'
ORDER BY
web_productunits.PRODUCTUNIT_ID
[result_tourrates] => Resource id #23
[row_validity] =>
)
|
|
