There are no Tour Operators in this category

"; else { // Record exist while ($row_tourop = mysql_fetch_array($sql_result)) { if (strlen($row_tourop[description]) > 120) $description = substr($row_tourop[description], 0, 120) . ""; else $description=$row_tourop[description]; $description=strip_tags($description); $tourop_name=urlencode($row_tourop[name]); $tour_output .= '

'.$row_tourop[name].'
'; $tour_output .= $description.' ...more

'; unset($description); } $include_file="inc_tour_search.php"; $_operator_additional_text="other tour operators"; } } elseif($_POST['tour_search']) { ## tour destination name query ## get codes from destination table if (isset($_REQUEST['locations'])) { $extra_sql=' AND ( departure_countries LIKE \'ALL\''; $extra_sql.=' OR departure_countries = \'\''; $extra_sql.=' OR departure_countries IS NULL'; foreach ($_REQUEST['locations'] as $location) { $temp_country_codes=explode(',',$location); foreach ($temp_country_codes as $temp_country_code) { $extra_sql.=' OR'; $extra_sql.=' departure_countries LIKE \'%'.$temp_country_code.'%\' '; } } $extra_sql.=' )'; } // SEARCH AND SEARCH RESULTS $search_string = $_POST['tour_string']; $search_string = ucwords($search_string); $sql_destination="SELECT country_code from countries WHERE country_name='$search_string'"; $mysql_result = mysql_query($sql_destination); if($mysql_result && (mysql_num_rows($mysql_result) > 0)) { $country = mysql_fetch_array($mysql_result); // search tourops-list where this destination comes into play $sql_tour_dest = "SELECT * from tourop_list WHERE destinations like '%$country[country_code]%'".$extra_sql; if($mysql_tour_dest = mysql_query($sql_tour_dest)) { if(mysql_num_rows($mysql_tour_dest) > 0) { // build results while($row_tourop = mysql_fetch_array($mysql_tour_dest)) { if (strlen($row_tourop[description]) > 120) $description = substr($row_tourop[description], 0, 120) . " ..."; else $description=$row_tourop[description]; $tourop_name=urlencode($row_tourop[name]); $description=strip_tags($description); $tour_output.='

'.$row_tourop['name'].'
'; $tour_output.=$description.' more

'; unset($description); $_operator_additional_text="other tour operators"; } } } } else $tour_output="

There are no Tour Operators in this category

"; $include_file="inc_tour_search.php"; } elseif($name && $name != "name") { // TOUR OPERATOR DETAIL PAGE // filter out Alphabetical listing with 'name' ## wanna get the full description here $search_name=urldecode($name); $sql_description="Select * from tourop_list WHERE name = '$search_name'"; if($mysql_result = mysql_query($sql_description)) { if(mysql_num_rows($mysql_result) > 0) { $desc_row = mysql_fetch_array($mysql_result); if($desc_row[destinations]) { $destinations = get_countries_desc($desc_row[destinations]); $departures = get_countries_desc($desc_row[departure_countries]); } $_operator_additional_text="another tour operator"; $full_output=' '; if ($site_vars['this_site']!='wordtravels') $full_output.= ''; $rowCount = 0; if (!empty($desc_row['telephone'])) $rowCount++; if (!empty($desc_row['fax'])) $rowCount++; if (!empty($desc_row['email'])) $rowCount++; if (!empty($desc_row['website'])) $rowCount++; if($desc_row['telephone']) { $full_output .=' '; if($desc_row['fax']) { $full_output.=' '; } $full_ouput.=' '; if($desc_row['email']) { $full_output.=''; } if($desc_row['website']) { $full_output.=''; } $newname=urldecode($name); if($desc_row['address']) { $full_output.=''; } session_start(); include_once('captcha/util.php'); // save the reviews if posted if ($_REQUEST['tour_review']=='xyz') { // check empty field // // do captcha processing $text = isset($_SESSION['CAPTCHA_SESSION_KEY'])? $_SESSION['CAPTCHA_SESSION_KEY'] : NULL; if(!$p=trim($_REQUEST['code'])) $MESSAGE = '

Error: no code submited!!

'; else if(!checkCaptchaCode($p)) $MESSAGE = '

Error: Invalid code submited!! Please try again

'; else { // // save the review; $sql = "INSERT INTO tourop_list_reviews (tourop_id, name, emailAddress, date_of_travel, review, created) VALUES (%s, '%s', '%s', '%s' , '%s', NOW())"; $sql = sprintf($sql, $desc_row[id], mysql_real_escape_string($_REQUEST['reviewName']), mysql_real_escape_string($_REQUEST['reviewEmail']), mysql_real_escape_string($_REQUEST['reviewDateofTravel']), mysql_real_escape_string($_REQUEST['touropReview'])); $res = mysql_query($sql); if ($res) { $success = 'Thank You! Your review was submitted. It will be approved before it becomes visible on the site.'; $output = 'The following review was posted for :'.$newname."\n\n"; $output.= $_REQUEST['touropReview']."\n"; // send the review to tourops@wordtravels.com if (!preg_match('/wtserver/',$_SERVER['HTTP_HOST'])) { $mailresult = mail ('tourops@wordtravels.com', "Wordtravels: Tour Operator Review Posting: ".stripslashes($_REQUEST["reviewName"]), $output, "From: ".'tom@wordtravels.com', "-f ".'tourops@wordtravels.com'); // temporary $mailresult = mail ('tourops@wordtravels.com', "Wordtravels: Tour Operator Review Posting: ".stripslashes($_REQUEST["reviewName"]), $output, "From: ".'tom@wordtravels.com', "-f ".'tourops@wordtravels.com'); } unset($_REQUEST); } else $MESSAGE = '

Error: '.mysql_error().'
An Error occured during submital. Please try again

'; } $_SESSION[CAPTCHA_SESSION_KEY] = NULL; } if($desc_row['description']) { $full_output.=''; // check for reviews for this tourop $tsql = "SELECT * FROM tourop_list_reviews where tourop_id = ".$desc_row[id]." AND approved=1"; $tres = mysql_query($tsql); if (mysql_num_rows($tres) > 0) { while ($row = mysql_fetch_array($tres)) $userReviews[] = $row; } //$userReviews = false; // // open review cells and rows $full_output.=''; // add form validation javascript: $full_output.=' '; // activate form validation $full_output .= ' '; // show the form if there is an error message. if (isset($MESSAGE)) { $full_output .=' '; } } if($destinations) { $newname=urldecode($name); $full_output.=' '; } if($departures) { $full_output.=' '; } if($desc_row['keywords']) { $full_output.=' '; } $full_output.="

'.$desc_row['name'].'

Tel:

'.$desc_row['telephone'].'

'; } if(!empty($desc_row['logo_path']) && file_exists("images/tourops/".$desc_row['logo_path'])) $full_output.='

'; $full_ouput.='

Fax:

'.$desc_row['fax'].'

Email:

'.$desc_row['email'].'

Web:

'.displayurl($desc_row['website']).'

Address:

'.$desc_row['address'].'

Description:

'.$desc_row['description'].'

'; // script output for toggle review && style for field validation $full_output.=' '; // open review box $full_output .='

'; if (isset($success)) { $full_output.=' '; } $full_output .= '

User reviews for '.$newname.' ('.(isset($userReviews) ? count($userReviews) : '0').')	Add A Review
'.$success.'

'; if ($userReviews) { foreach ($userReviews as $review) { $full_output .='

'.stripslashes($review['name']).' '.($review['date_of_travel'] ? '('.stripslashes($review['date_of_travel']).')' : '').'

'.stripslashes($review['review']).'

'; } } else { $full_output .= '

There are no User Reviews for '.$newname.'

'; } $revName = (empty($_REQUEST['reviewName']) ? '' : $_REQUEST['reviewName']); $revEmail = (empty($_REQUEST['reviewEmail']) ? '' : $_REQUEST['reviewEmail']); $revDate = (empty($_REQUEST['reviewDateofTravel']) ? '' : $_REQUEST['reviewDateofTravel']); $revReview = (empty($_REQUEST['touropReview']) ? '' : $_REQUEST['touropReview']); // addreview form $full_output .= ' '; // close of review box $full_output .= '

'; // close review cells & row $full_output.='

Destinations:

'.$newname.' specialise in holidays to '.$destinations.'

Departure Countries:

'.$departures.'

Keywords:

'.$desc_row['keywords'].'

"; } } } // includes list of Characters for search if(!$include_file) $include_file="inc_tour_search.php"; //end Ad_hotel information // NEW TOUR OPERATOR LISTING $sql_travel = "SELECT * FROM tour_operators WHERE "; if(!$province_code) $sql_travel .= "country_code='$country_code'"; elseif ($req_destination_type == "Provinces") $sql_travel .= "province_code='$province_code'"; $sql_travel.=" AND show_in_column='1' LIMIT 1"; $sql_result = mysql_query($sql_travel) or die(mysql_error()); if($sql_result) $travel_listing_row=mysql_fetch_array($sql_result); $meta_title = $newname." Holidays - Tour Operator"; $meta_description = $newname." Travel Holidays - read an independent description of this tour operator. Unbiased travel reviews of $newname and other tour operators."; $meta_keywords = $newname.", Holidays, Travel, Reviews, description"; // INCLUDE ALL META DATA INTO TEMPLATE if ($site_vars['include_tpl_top']) echo get_tpl($site_vars['include_tpl_top'],$meta_title,$meta_description,$meta_keywords); ## END TOUR OPERATOR LISTING if (!$site_vars['show_only_body']) { ?> <?php echo $newname." Holidays - Tour Operator" ?> "> "> \n"; if ($site_vars['this_site'] == "wordtravels" && !$_COOKIE[aid]) { ?> \n" . "\n" . "

You are logged in as " . $agent_details['name'] . ". Logout.

" . "\n\n"; } if ($site_vars['show_header']) { ?>

Travel Guides Home - Tour Operators -

Tour Operators

London City Break

"; if (!$site_vars['show_only_body']) { if ($site_vars['this_site'] == "wordtravels" && !$_COOKIE[aid]) { ?>