0) while($row = mysql_fetch_row($result)) { $pagetitle = "Model Shops in " .$row[1]. ""; $seokey = "Model Shops, UK, ". $row[1] .""; $seodesc= "The ". $row[1] ." Model shop directory has over ". $row[3] ." upto date entries."; } include "header.php"; echo ""; include "includes/menu.php"; echo "
"; echo ""; include "includes/pagehead.php"; echo "
"; } echo "
Model Shops > Model Shop Directory > "; $query = "SELECT countryid, country FROM ms_clubs_country WHERE countryid = '$countryid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "Model Shops in " .$row[1]. "

Add a Model Shop

"; $query = "SELECT countryid, country FROM ms_clubs_country WHERE countryid = '$countryid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "
Model Shops in " .$row[1]. "

"; } $result = $db->sql_query("SELECT a.countryid, a.country, b.countyid, b.countryid, b.county, p.countryid, p.countyid FROM ms_clubs_country a, ms_clubs_county b, ms_clubs p WHERE a.countryid = p.countryid AND b.countyid = p.countyid AND p.countryid = '$countryid' AND p.active = '1' GROUP BY p.countyid ORDER BY b.county"); //we add this line because we need to know the number of rows $num_rows = mysql_num_rows($result); echo "\n"; //set the number of columns $columns = 2; //changed this to a for loop so we can use the number of rows for($i = 0; $i < $num_rows; $i++) { $row = mysql_fetch_array($result); if($i % $columns == 0) { //if there is no remainder, we want to start a new row echo "\n"; } echo ""; if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_rows) { //if there is a remainder of 1, end the row //or if there is nothing left in our result set, end the row echo "\n"; } } echo "
"; echo "
" .$row[4].""; echo "
"; include "includes/topshops.php"; echo "
"; echo "
"; echo ""; include "footer.php"; } function clubscounty($countyid) { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $query = "SELECT a.countryid, a.country, b.countyid, b.county, b.countryid, COUNT(c.cid), c.countyid FROM ms_clubs_country a, ms_clubs_county b, ms_clubs c WHERE a.countryid = b.countryid AND b.countyid = c.countyid AND b.countyid = '$countyid' AND c.active = '1' GROUP BY b.countyid"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { $pagetitle = "" .$row[3]. " Travel Agents"; $seokey = "" .$row[3]. " travel agents"; $seodesc= "There are currently " .$row[5]. " Travel Agents listed in " .$row[3]. " in the Travel Agents Directory."; } include "header.php"; echo ""; echo "
"; $query = "SELECT p.countryid, a.countryid, a.country, p.active FROM ms_clubs p, ms_clubs_country a WHERE p.countryid = a.countryid AND p.countyid = '$countyid' AND p.active = '1' LIMIT 0,1"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; } echo ""; $query = "SELECT cid, countryid, countyid FROM ms_clubs WHERE countyid = '$countyid' AND active = '1' LIMIT 1"; $result = $db->sql_query($query); if($db->sql_numrows($result)>0) { while($row =$db->sql_fetchrow($result)) { $countryid = $row[1]; $result2 = $db->sql_query("SELECT p.countyid, b.countyid, b.county FROM ms_clubs p, ms_clubs_county b WHERE b.countyid = p.countyid AND p.countryid = '$countryid' AND p.active = '1' GROUP BY b.countyid ORDER BY b.county ASC"); while($row2 = $db->sql_fetchrow($result2)) { echo ""; } } } echo "
".$row[2]."
" .$row2[2]. "
"; echo "
"; include "includes/menu.php"; echo ""; echo "
"; } echo "
$sitename > Travel Agents Directory > "; $query = "SELECT a.countryid, a.country, b.countyid, b.county, b.countryid FROM ms_clubs_country a, ms_clubs_county b WHERE a.countryid = b.countryid AND b.countyid = '$countyid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "" .$row[3]. " Travel Agents

Add a Travel Agent | Rate & Review New

"; $query = "SELECT countyid, county FROM ms_clubs_county WHERE countyid = '$countyid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "

" .$row[1]. " Travel Agents

"; } echo ""; $query = "SELECT b.countyid, b.county, c.townid, c.countyid, c.town, p.countyid FROM ms_clubs_county b, ms_clubs_town c, ms_clubs p WHERE b.countyid = p.countyid AND c.townid = p.townid AND p.countyid = '$countyid' AND p.active ='1' GROUP BY p.townid ORDER BY c.town"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; $townid = $row[2]; $result2 = $db->sql_query( "SELECT b.countyid, b.county, c.townid, c.countyid, c.town, p.countyid, p.townid, p.club, p.cid FROM ms_clubs_county b, ms_clubs_town c, ms_clubs p WHERE b.countyid = p.countyid AND c.townid = p.townid AND p.townid= '$townid' AND p.active = '1' ORDER BY p.club"); while($row2 = $db->sql_fetchrow($result2)) { echo ""; } } echo "

".$row[4]."
".$row2[7].""; $cid = $row2[8]; $result3 = $db->sql_query( "SELECT AVG(rating), COUNT(crid) FROM ms_shop_rev WHERE cid = '$cid' GROUP BY cid"); while($row3 = $db->sql_fetchrow($result3)) { if(!empty($row3[0])) echo "\"" " . number_format ($row3[0], 0, '.', ',') . "/10"; else echo "Rate & Review"; } echo "

"; } echo ""; $query = "SELECT e.eventid, e.event, e.organiser, DATE_FORMAT(e.startdate, '%D %M %Y') as startdate, DATE_FORMAT(e.enddate, '%D %M %Y') as enddate, e.address, e.address2, e.address3, e.townid, e.countyid, e.postcode, e.parking, e.disabled, e.refresh, e.active, t.townid, t.town, c.countyid, c.county, e.transport, e.website FROM ms_events e, ms_clubs_town t, ms_clubs_county c WHERE e.townid = t.townid AND e.countyid = c.countyid AND e.active = '1' AND e.startdate > CURDATE() -1 AND e.countyid = '$countyid' ORDER BY e.startdate ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
"; $query = "SELECT countyid, county FROM ms_clubs_county WHERE countyid = '$countyid'"; $result = $db->sql_query($query); if($db->sql_numrows($result)>0) while($row = mysql_fetch_row($result)) { echo "

Travel Events

Travel Events and Exhibitions taking place in ". $row[1] .". If you know of any events not in our listings, please use the following form: [Add an Event]
". $row[3] .""; if(!empty($row[4])) echo " - ". $row[4] .""; else echo ""; echo "
". $row[2] ." ". $row[1] ."
". $row[5] .""; if(!empty($row[6])) echo ", ". $row[6] .""; if(!empty($row[7])) echo ", ". $row[7] .""; if(!empty($row[16])) echo ", ". $row[16] .""; if(!empty($row[18])) echo ", ". $row[18] .""; if(!empty($row[10])) echo " ". $row[10] .""; echo "
[More Details]
"; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } function clubsredir($param1,$param2) { global $nukeurl,$db; list($shopname,$tid) = mysql_fetch_row(mysql_query("SELECT p.club, p.townid FROM ms_clubs p WHERE p.cid='$param2';")); list($location) = mysql_fetch_row(mysql_query("SELECT t.town FROM ms_clubs_town t WHERE t.townid='$tid';")); header("HTTP/1.0 301 Moved Permanently"); header("location:$nukeurl/".str_replace(" ","-",$shopname)."-Model-Shop-".str_replace(" ","-",$location)."-$param2.html"); } function clubs($cid) { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $query = "SELECT p.cid, p.club, p.townid, c.townid, c.town, b.countyid, b.county, p.address FROM ms_clubs p, ms_clubs_town c, ms_clubs_county b WHERE c.townid = p.townid AND b.countyid = p.countyid AND p.cid = '$cid' AND p.active = '1'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { $pagetitle = "" .$row[1]. " Reviews, Travel Agent in " .$row[6]. "."; $seokey = "" .$row[1]. ",reviews"; $seodesc= "" .$row[1]. " are a Travel Agency in " .$row[6]. ". Add your own review of " .$row[1]. " or read what other users have written."; } include "header.php"; echo ""; include "includes/add.php"; echo "
"; include "includes/menu.php"; echo "
"; include "includes/toprated.php"; echo ""; echo "
"; } echo "
$sitename > Travel Agents Directory > "; $query = "SELECT p.cid, p.club, p.townid, c.townid, c.town, b.countyid, b.county, a.countryid, a.country, p.countryid FROM ms_clubs p, ms_clubs_town c, ms_clubs_county b, ms_clubs_country a WHERE c.townid = p.townid AND b.countyid = p.countyid AND a.countryid = p.countryid AND p.cid = '$cid' AND p.active = '1'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "" .$row[1]. "

"; $query = "SELECT p.cid, p.club, p.address, p.phone, p.fax, p.countryid, p.countyid, p.townid, p.description, p.email, p.website, p.active, p.location, p.count, p.source, p.sourceurl, c.townid, c.countyid, c.town FROM ms_clubs p, ms_clubs_town c WHERE p.townid = c.townid AND cid = '$cid' AND p.active = '1'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; if($isadmin) { echo ""; } echo ""; $result2 = $db->sql_query( "SELECT AVG(rating), COUNT(crid) FROM ms_shop_rev WHERE cid = '$cid' GROUP BY cid"); while($row2 = $db->sql_fetchrow($result2)) { if(!empty($row2[0])) echo ""; } echo ""; if(!empty($row[4])) echo ""; if(!empty($row[10])) echo""; if(!empty($row[8])) echo ""; if(!empty($row[12])) echo ""; $result2 = $db->sql_query( "SELECT cid, manfid FROM ms_clubs_brands WHERE cid = '$cid' GROUP BY cid LIMIT 1"); while($row2 = $db->sql_fetchrow($result2)) { echo ""; } echo ""; echo "
[Edit]

" .$row[1]. "

User Rating: \"" " . number_format ($row2[0], 0, '.', ',') . "/10
Rate & Review this Travel Agent New | Read Reviews
Address: " .$row[2]. "
Telephone: " .$row[3]. "
Fax: " .$row[4]. "
Website: " .$row[10]. "
" .$row[8]. "
" .$row[12]. "
Stockists Of:
"; $result3 = $db->sql_query( "SELECT b.cid, b.manfid, m.manfid, m.manufacturer, b.cbid FROM ms_clubs_brands b, ms_gear_manufacturer m WHERE b.manfid = m.manfid AND cid = '$cid'"); while($row3 = $db->sql_fetchrow($result3)) { echo "\"". "; } echo "
Data Source: "; if(!empty($row[15])) echo "" .$row[14]. ""; else echo "" .$row[14]. ""; echo "
[Update Entry]
"; } echo "

Rate & Review this Travel Agent New | Add a Travel Agent

"; echo "

Read Reviews...

"; $query = "SELECT cid, rating, submittedby, comments, IF(CHAR_LENGTH(comments)>57,RPAD(LEFT(comments,57),60,'.'),comments) AS title, crid FROM ms_shop_rev WHERE cid = '$cid' ORDER BY crid DESC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; if($isadmin) echo ""; echo ""; $commenttext = ereg_replace("Holiday","Holiday",$row[3]); echo"
[Edit]
" . $row[4] ."
Rating: \"" " . number_format ($row[1], 0, '.', ',') . "/10
" . $commenttext ."

Submitted By: " . $row[2] ."

"; } else { echo "Unfortunatly we do not have any reviews of this Travel Agent at present. If you have used this Travel Agency then why not add one now using the following link: Rate & Review this Travel Agent

"; } echo "

"; include "includes/newshops.php"; echo " "; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } function events() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Travel Exhibitions & Events"; $seokey = "Travel Exhibitions and Events"; $seodesc= "The Travel Exhibitions & Events directory has many events for you to visit."; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; include "includes/newevents.php"; echo ""; echo "
$sitename > Travel Exhibitions & Events

"; echo ""; $query = "SELECT e.eventid, e.event, e.organiser, DATE_FORMAT(e.startdate, '%D %M %Y') as startdate, DATE_FORMAT(e.enddate, '%D %M %Y') as enddate, e.address, e.address2, e.address3, e.townid, e.countyid, e.postcode, e.parking, e.disabled, e.refresh, e.active, t.townid, t.town, c.countyid, c.county, e.transport, e.website FROM ms_events e, ms_clubs_town t, ms_clubs_county c WHERE e.townid = t.townid AND e.countyid = c.countyid AND e.active = '1' AND e.startdate > CURDATE() -1 ORDER BY e.startdate ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
Travel Exhibitions & Events

Welcome to our page on Travel Exhibitions & Events. We have listed many events taking place over the coming months. Please confirm all the details of any event or exhibition before travelling.

We have tried to keep the listing as easy and simple to read as possible. We have included a few images as keys to help you see what is available at a glance.

Key:
\"Free= Free Parking
\"Disabled= Disabled Access
\"Refreshments= Refreshments Available
\"Public= Public Transport Links
\"Website= Website Available


If you would like to include your own exhibition or event in our listings, then please use this form: [Add an Event].
". $row[3] .""; if(!empty($row[4])) echo " - ". $row[4] .""; else echo ""; echo "
". $row[2] ." ". $row[1] ."
". $row[5] .""; if(!empty($row[6])) echo ", ". $row[6] .""; if(!empty($row[7])) echo ", ". $row[7] .""; if(!empty($row[16])) echo ", ". $row[16] .""; if(!empty($row[18])) echo ", ". $row[18] .""; if(!empty($row[10])) echo " ". $row[10] .""; echo "
"; if(!$row[11]==0) echo "\"Free "; else echo ""; if(!$row[12]==0) echo "\"Disabled "; else echo ""; if(!$row[13]==0) echo "\"Refreshments "; else echo ""; if(!$row[19]==0) echo "\"Public "; else echo ""; if(!$row[20]==0) echo "\"Website "; else echo ""; echo "
[More Details]
"; include "includes/topevents.php"; echo "
"; echo ""; include "footer.php"; } function eventspage($eventid) { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $query = "SELECT event, organiser FROM ms_events WHERE eventid = '$eventid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { $pagetitle = "". $row[1] ." ". $row[0] ." Travel Exhibitions & Events"; $seokey = "". $row[1] .", ". $row[0] .", Travel Exhibitions, Events"; $seodesc= "Full details of the ". $row[0] ." organised by ". $row[1] .", including maps and further information."; } include "header.php"; echo ""; include "includes/menu.php"; echo "
"; include "includes/newevents.php"; echo ""; include "includes/pagehead.php"; echo "
Travel Agent Reviews > Travel Exhibitions & Events >"; $query = "SELECT eventid, event, organiser FROM ms_events WHERE eventid = '$eventid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo " ". $row[2] ." ". $row[1] .""; } echo "

"; $query = "SELECT e.eventid, e.event, e.organiser, DATE_FORMAT(e.startdate, '%D %M %Y') as startdate, DATE_FORMAT(e.enddate, '%D %M %Y') as enddate, e.address, e.address2, e.address3, e.townid, e.countyid, e.postcode, e.parking, e.disabled, e.refresh, e.active, t.townid, t.town, c.countyid, c.county, e.map, e.transport, e.times, e.admission, e.contact, e.website, e.description FROM ms_events e, ms_clubs_town t, ms_clubs_county c WHERE e.townid = t.townid AND e.countyid = c.countyid AND e.active = '1' AND e.eventid = '$eventid' ORDER BY e.startdate ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { if($isadmin) { echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
[Edit]
". $row[2] ." ". $row[1] ."
". $row[3] .""; if(!empty($row[4])) echo " - ". $row[4] .""; else echo ""; echo ""; echo "

"; echo "". $row[5] ."
"; if(!empty($row[6])) echo "". $row[6] ."
"; if(!empty($row[7])) echo "". $row[7] ."
"; if(!empty($row[16])) echo "". $row[16] ."
"; if(!empty($row[18])) echo "". $row[18] ."
"; if(!empty($row[10])) echo "". $row[10] .""; echo "

"; if(!$row[11]==0) echo "\"Free "; else echo ""; if(!$row[12]==0) echo "\"Disabled "; else echo ""; if(!$row[13]==0) echo "\"Refreshments "; else echo ""; if(!$row[20]==0) echo "\"Public "; else echo ""; if(!$row[24]==0) echo "\"Website "; else echo ""; if(!$row[24]==0) echo "

Website: ". $row[24] .""; else echo ""; echo "

"; echo "
"; if(!$row[21]==0) echo "Opening Times: ". $row[21] .""; else echo ""; if(!$row[22]==0) echo "

Admission: ". $row[22] .""; else echo ""; if(!$row[23]==0) echo "

Email: ". $row[23] .""; else echo ""; echo "
". $row[25] ."
". $row[19] ."
[Add an Event]
"; include "includes/topevents.php"; echo "
"; include "includes/eventkey.php"; echo "
"; include "includes/newsletter.php"; echo ""; include "footer.php"; } function eventsadd() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Add a Travel Exhibition & Event"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; include "includes/newevents.php"; echo ""; include "includes/pagehead.php"; echo "
$sitename > Travel Exhibitions & Events > Add a Travel Event

Add a Travel Event
You can use the following form to add any Travel exhibitions or events to our site. Please add as much detail as possible to enhance your listing. Once it has been reviewed it will be added to our site.
Organiser:
Enter the event name below, simply 'Exhibition' will suffice if it does not have a specific name.
Event:
Start Date: (YYYY-MM-DD)
If this is a one day event please leave the end date blank.
End Date: (YYYY-MM-DD)
Address:
Address:
Address:
Town:
Other Town:
County:
Other County:
Postcode:
Free Parking:
Disabled Access:
Refreshments :
Transport Links:
Opening Times:
Admission Costs:
Contact Name:
Event Email:
Event Website: (Optional)
Please use the description field to add any further details regarding you event, this will enhance your listing. You can include details such as visting layouts etc.
Description:


Please confirm you are a human by ticking this box.
"; echo ""; include "footer.php"; } function eventssent() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $result = $db->sql_query("INSERT INTO ms_events_pending (organiser,event, startdate, enddate, address, address2, address3, townid, othertown, countyid, othercounty, postcode, parking, disabled, refresh, transport, times, admission, contact, eventcontact, website, description, timestamp) VALUES ('".forSql($_POST["organiser"])."','".forSql($_POST["event"])."','".forSql($_POST["startdate"])."','".forSql($_POST["enddate"])."','".forSql($_POST["address"])."','".forSql($_POST["address2"])."','".forSql($_POST["address3"])."','".forSql($_POST["townid"])."','".forSql($_POST["othertown"])."','".forSql($_POST["countyid"])."' ,'".forSql($_POST["othercounty"])."','".forSql($_POST["postcode"])."','".forSql($_POST["parking"])."','".forSql($_POST["disabled"])."','".forSql($_POST["refresh"])."','".forSql($_POST["transport"])."','".forSql($_POST["times"])."','".forSql($_POST["admission"])."','".forSql($_POST["contact"])."','".forSql($_POST["eventcontact"])."','".forSql($_POST["website"])."','".forSql($_POST["description"])."', UNIX_TIMESTAMP());"); $pagetitle = "Event Sent"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; include "includes/newevents.php"; echo ""; include "includes/pagehead.php"; echo "
Model Shops > Model Exhibitions & Events > Event Sent

Thanks - Your event submission has been received and shall be processed shortly.
"; include "includes/newsletter.php"; echo ""; include "footer.php"; } function shopdirectory() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Travel Agents Directory"; $seokey = "travel agents directory"; $seodesc= "The Travel Agents Directory lists and reviews hundreds of Travel Agents in the UK."; include "header.php"; echo ""; include "includes/add.php"; echo "
"; include "includes/menu.php"; echo "
"; include "includes/toprated.php"; echo "
"; echo ""; echo "
$sitename > Travel Agents Directory

Travel Agents Directory

Welcome to our directory of Travel Agents in the UK. This list comprises of travel agents and can be helped kept up-to-date with your input. If you know of a Travel Agent that is not listed, please use the 'Add a Travel Agent' form and submit to us for inclusion.

If you have experienced one of our listed Travel Agents and would like to leave us a review, then please feel free to use the 'Reviews & Ratings' page to submit comments or use the link on the company page you are looking at.



Add a Travel Agent | Rate & Review New

"; if($isadmin) { $query = "SELECT co.countryid, co.country, cl.countryid, cl.active FROM ms_clubs_country co, ms_clubs cl WHERE co.countryid = cl.countryid AND cl.active = '1' GROUP BY co.countryid ORDER BY co.country ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "

" .$row[1]. "

"; $countryid = $row[0]; $result2 = $db->sql_query("SELECT a.countryid, a.country, b.countyid, b.countryid, b.county, p.countryid, p.countyid, COUNT(p.cid) FROM ms_clubs_country a, ms_clubs_county b, ms_clubs p WHERE a.countryid = p.countryid AND b.countyid = p.countyid AND p.countryid = '$countryid' AND p.active = '1' GROUP BY p.countyid ORDER BY b.county"); //we add this line because we need to know the number of rows $num_rows = mysql_num_rows($result2); echo "\n"; //set the number of columns $columns = 2; //changed this to a for loop so we can use the number of rows for($i = 0; $i < $num_rows; $i++) { $row2 = mysql_fetch_array($result2); if($i % $columns == 0) { //if there is no remainder, we want to start a new row echo "\n"; } echo ""; if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_rows) { //if there is a remainder of 1, end the row //or if there is nothing left in our result set, end the row echo "\n"; } } echo "
"; echo "
" .$row2[4]." "; if($isadmin) { echo "(".$row2[7].")"; } echo "

"; } } echo "
"; $result = $db->sql_query("SELECT town, townid FROM ms_clubs_town GROUP BY townid ORDER BY town ASC"); while($row=$db->sql_fetchrow($result)) { echo " "; $townid = $row[townid]; $result2 = $db->sql_query("SELECT townid, club, cid FROM ms_clubs WHERE active = '1' AND townid = '$townid' ORDER BY club"); while($row2 = $db->sql_fetchrow($result2)) { if($rowcounter%2==1) $bgcolor="#FFFFFF"; else $bgcolor="#F4F4F4"; echo ""; $cid = $row2[cid]; $result3 = $db->sql_query("SELECT p.cid, p.club, AVG(r.rating) AS rating, COUNT(r.crid) AS count, r.cid FROM ms_shop_rev r, ms_clubs p WHERE r.cid = p.cid AND p.cid = '$cid' GROUP BY p.cid"); if (mysql_num_rows($result3) > 0) while($row3 = $db->sql_fetchrow($result3)) { echo ""; } else { echo ""; } $rowcounter++; } } echo "
LetterTravel AgentReviewsPassenger Rating
{$row["town"]}
{$row2["club"]}{$row3["count"]}\""" . number_format ($row3[rating], 1, '.', ',') . "/10
\"\"
"; echo " "; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } function modelclubadd() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Add a Tour Operator"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; echo ""; echo "
$sitename > Tour Operators > Add a Tour Operator

Add a Tour Operator
You can use the form below to add your Tour Operator.
Tour Operator:
Address:
Address:
Address:
Town:
Other Town:
County:
Other County:
Postcode:
Telephone: (This is Published)
Website:
Opening Days:
Opening Times:
Contact Name:
Contact Email: (Not Published)
Please use the description field to add any further details regarding your Tour Operator.
Description:


Please confirm you are a human by ticking this box.
"; echo ""; include "footer.php"; } function modelclubsent() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $result = $db->sql_query("INSERT INTO ms_model_clubs_pending (club, address, address2, address3, townid, othertown, countyid, othercounty, postcode, telephone, website, type, description, timemeet, daymeet, name, email, timestamp) VALUES ('".forSql($_POST["club"])."','".forSql($_POST["address"])."','".forSql($_POST["address2"])."','".forSql($_POST["address3"])."','".forSql($_POST["townid"])."','".forSql($_POST["othertown"])."','".forSql($_POST["countyid"])."' ,'".forSql($_POST["othercounty"])."','".forSql($_POST["postcode"])."','".forSql($_POST["telephone"])."','".forSql($_POST["website"])."','".forSql($_POST["type"])."','".forSql($_POST["description"])."','".forSql($_POST["timemeet"])."','".forSql($_POST["daymeet"])."','".forSql($_POST["name"])."','".forSql($_POST["email"])."', UNIX_TIMESTAMP());"); $pagetitle = "Model Club Sent"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; echo ""; include "includes/pagehead.php"; echo "
Model Shops > Model Clubs > Model Club Sent

Thanks

Your club submission has been received and shall be processed shortly. In the meantime it would great if you can add a link back to the Model Shops website by adding one of the two links below to your website:

Text Link:

Club listed on Model Shops

Image Link:

"; echo ""; include "footer.php"; } function shopadd() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Add a Travel Agent"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
$sitename > Travel Agent Directory > Add a Travel Agent

Add a Travel Agent
Please use the form below to submit your model shop to our website. Fill in as much of the form as you can as this will enhance you listing. Once we have received your submission we shall review it and add it to the website with 12 hours.
Agency Name:
Phone:
Fax:
Full Address:
Please use the description field to add any further details regarding you agency, this will enhance your listing. You can include details such as what type of holidays you sell and anything you may specialise in etc.
Description:
Email:
Website: (Optional)


Please confirm you are a human by ticking this box.
"; echo ""; include "footer.php"; } function shopsent() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $result = $db->sql_query("INSERT INTO ms_clubs_pending (club, address, phone, fax, description, email, website, timestamp) VALUES ('".forSql($_POST["club"])."','".forSql($_POST["address"])."','".forSql($_POST["phone"])."','".forSql($_POST["fax"])."','".forSql($_POST["description"])."','".forSql($_POST["email"])."','".forSql($_POST["website"])."', UNIX_TIMESTAMP());"); $pagetitle = "Model Shop Sent"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; include "includes/pagehead.php"; echo "
Model Shops > Model Shop Directory > Model Shop Sent

Thanks

Your model shop submission has been received and shall be processed shortly. In the meantime it would great if you can add a link back to the Model Shops website by adding one of the two links below to your website:

Text Link:

Club listed on Model Shops

Image Link:

"; include "includes/newsletter.php"; echo ""; include "footer.php"; } function modelclubhome() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Tour Operators Directory"; $seokey = "tour operators"; $seodesc= "A directory of Tour Operators located in the UK."; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
$sitename > Tour Operators Directory

Tour Operators Directory


Add a Tour Operator

"; $query = "SELECT m.club, m.address, m.address2, m.address3, m.townid, m.countyid, m.postcode, m.telephone, m.website, t.townid, t.town, c.countyid, c.county FROM ms_model_clubs m, ms_clubs_town t, ms_clubs_county c WHERE m.townid = t.townid AND m.countyid = c.countyid"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; echo ""; echo ""; echo ""; } echo "
". $row[0] ."
". $row[1] .""; if(!empty($row[2])) echo ", ". $row[2] .""; if(!empty($row[3])) echo ", ". $row[3] .""; if(!empty($row[10])) echo ", ". $row[10] .""; if(!empty($row[12])) echo ", ". $row[12] .""; if(!empty($row[6])) echo " ". $row[6] .""; echo "
Telephone: ". $row[7] ."
"; echo ""; include "footer.php"; } function blogs() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Travel Blogs & Websites"; $seokey = "Travel Blogs and Websites"; $seodesc= "A collection of links to travel blogs, news & websites. "; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
$sitename > Travel Blogs & Websites

"; $query = "SELECT b.catid, b.title, b.url, b.description, b.timestamp, b.active, c.catid, c.category FROM ms_blogs b, ms_blogs_category c WHERE b.catid = c.catid AND b.active = '1' ORDER BY b.timestamp DESC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
". $row[1] ."
". $row[3] .""; echo "
Link: ". $row[2] ."
Added: ".date("jS M Y",$row[4])."
"; echo ""; include "footer.php"; } function blogadd() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Add a Travel Blog or Website"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; include "includes/pagehead.php"; echo "
$sitename > Travel Blogs & Websites > Add a Blog or Website

Add a Travel Blog or Website
If you have a Travel related blog or website, then please use the form below.

Details of how to link back to us are found on the next page.
Category:
Other:
Title:
Url:
Description:
Email: (not published)


Please confirm you are a human by ticking this box.
"; echo ""; include "footer.php"; } function blogsent() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $result = $db->sql_query("INSERT INTO ms_blogs_pending (catid, othercat, title, url, description, email, timestamp) VALUES ('".forSql($_POST["catid"])."','".forSql($_POST["othercat"])."','".forSql($_POST["title"])."','".forSql($_POST["url"])."','".forSql($_POST["description"])."','".forSql($_POST["email"])."', UNIX_TIMESTAMP());"); $pagetitle = "Link Submission Sent"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
$sitename > Travel Blogs & Websites > Link Submission Sent

Thanks

Your link submission has been received and shall be processed shortly. In the meantime it would great if you can add a link back to Travel Agent Reviews website by adding one of the two links below to your website:

Text Link:

Travel Agent Reviews
"; include "includes/newsletter.php"; echo ""; include "footer.php"; } function advertise() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Advertise on Travel Agent Reviews"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; include "includes/pagehead.php"; echo "
$sitename > Advertise

Advertising on Travel Agent Reviews.com

TravelAgentReviews.com sometimes offer advertising space for anyone looked to promote their products or service to a UK audience. Advertisers are able to deliver their messages through our website to people interested in travelling and holidays.

We are always interested in hearing from dynamic companies who are looking to promote with us, so why not get in touch with us today for more information and opportunities available.

Contact us here
"; include "footer.php"; } function searchresults() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Search Results"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; include "includes/pagehead.php"; echo "
"; include "includes/searchbox.php"; echo ""; include "footer.php"; } function clubstown($townid) { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $query = "SELECT COUNT(p.cid), p.club, p.townid, c.townid, c.town, b.countyid, b.county, p.address FROM ms_clubs p, ms_clubs_town c, ms_clubs_county b WHERE c.townid = p.townid AND b.countyid = p.countyid AND p.townid = '$townid' GROUP BY c.townid"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { $pagetitle = "Travel Agents in " .$row[4]. ", " .$row[6]. ""; $seokey = "" .$row[4]. " Travel Agents"; $seodesc= "We have ". $row[0] ." travel agencies listed in ". $row[4] ." ". $row[6] ." in our Travel Agent directory"; } include "header.php"; echo ""; echo "
"; $query = "SELECT t.townid, t.town, t.countyid, c.countyid, c.county FROM ms_clubs_town t, ms_clubs_county c WHERE t.countyid = c.countyid AND t.townid = '$townid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) $result = $db->sql_query($query); if($db->sql_numrows($result)>0) { while($row =$db->sql_fetchrow($result)) { $countyid = $row[2]; $result2 = $db->sql_query("SELECT c.townid, c.active, t.townid, t.town, t.countyid FROM ms_clubs c, ms_clubs_town t WHERE c.townid = t.townid AND t.countyid = '$countyid' AND c.active = '1' GROUP BY t.townid ORDER BY t.town ASC"); while($row2 = $db->sql_fetchrow($result2)) { echo ""; } } } echo "
" .$row2[3]. "

"; include "includes/menu.php"; echo ""; echo "
"; } echo "
$sitename > Travel Agents Directory > "; $query = "SELECT p.cid, p.club, p.townid, c.townid, c.town, b.countyid, b.county, a.countryid, a.country, p.countryid FROM ms_clubs p, ms_clubs_town c, ms_clubs_county b, ms_clubs_country a WHERE c.townid = p.townid AND b.countyid = p.countyid AND a.countryid = p.countryid AND p.townid = '$townid' LIMIT 1"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "" .$row[6]. " > Travel Agents in " .$row[4]. "

"; $query = "SELECT p.cid, p.club, p.townid, c.townid, c.town, b.countyid, b.county, a.countryid, a.country, p.countryid FROM ms_clubs p, ms_clubs_town c, ms_clubs_county b, ms_clubs_country a WHERE c.townid = p.townid AND b.countyid = p.countyid AND a.countryid = p.countryid AND p.townid = '$townid' LIMIT 1"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "

Travel Agents in " .$row[4]. "

"; } echo "

"; $query = "SELECT p.cid, p.club, p.address, p.phone, p.email, p.website, p.townid, p.active, c.townid, c.countyid, c.town FROM ms_clubs p, ms_clubs_town c WHERE p.townid = c.townid AND p.townid = '$townid' AND p.active = '1' ORDER BY p.club ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "
"; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "". $row[1] . ""; echo "
T: ". $row[3] .""; echo "A: ". $row[2] ."
"; if(!empty($row[5])) echo "\"Website "; if(!empty($row[4])) echo "\"Email "; echo ""; echo "\"More"; echo "

"; } echo "
Add a Travel Agent | Rate & Review New
"; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } function addclubreview() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Rate & Review Travel Agents"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; echo"
$sitename > Travel Agents Directory > Rate & Review Travel Agents

Submit Your Travel Agent Review

To leave a review of your travel agent, please use the form below. If a Travel Agent is not listed, then please use the 'other' field to let us know who you are leaving the review about and we will add them to our site. If the travel agency is listed, please select it in the drop down box.

If you submit a review that offers no information or value to other travellers, your review will not be added. Any reviews with potentially libelous content will not be authorised.

Travel Agent:
Other Travel Agent:
Rate Your Experience: (1 is Very Bad, 10 is Very Good)
Your Comments:
Your Name:
Email Address:
Please confirm you are a human and tick this box.
"; echo ""; include "footer.php"; } function clubreviewsent() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $result = $db->sql_query("INSERT INTO ms_shop_rev_pending (cid, other, submittedby, email, rating, comments, timestamp, pendip) VALUES ('".forSql($_POST["cid"])."','".forSql($_POST["other"])."','".forSql($_POST["submittedby"])."','".forSql($_POST["email"])."','".forSql($_POST["rating"])."','".forSql($_POST["comments"])."',UNIX_TIMESTAMP(),'".forSql($_SERVER['REMOTE_ADDR'])."');"); $pagetitle = "Review Sent"; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; echo "
"; echo ""; include "includes/pagehead.php"; echo "
"; echo "
Model Shops > Model Shop Directory > Rate & Review Model Shops > Sent

Thanks - Review Recieved.
"; echo " "; include "footer.php"; } function countryredir($param1) { global $nukeurl,$db; list($country) = mysql_fetch_row(mysql_query("SELECT p.country, p.countryid FROM ms_clubs_country p WHERE p.countryid='$param1';")); header("HTTP/1.0 301 Moved Permanently"); header("location:$nukeurl/Model-Shop-Directory.html"); } function shopsaz($letter) { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$sitename,$correcturl; $pagetitle = "Travel Agents - ".$letter.""; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; include "includes/pagehead.php"; echo "
$sitename > Travel Agents Directory > Travel Agents A-Z

Travel Agents - ".$letter."

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

"; $query = "SELECT p.cid, p.club, p.townid, p.active, c.townid, c.countyid, c.town, p.address, p.phone FROM ms_clubs p, ms_clubs_town c WHERE p.townid = c.townid AND p.active = '1' AND p.club LIKE '".$letter."%' ORDER BY p.club ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "
"; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "". $row[1] . ""; echo "
T: ". $row[8] .""; echo "A: ". $row[7] ."
"; if(!empty($row[5])) echo "\"Website "; if(!empty($row[4])) echo "\"Email "; echo ""; echo "\"More"; echo "

"; } echo "
Add a Travel Agent | Rate & Review New
"; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } switch($op) { case "clubscountry": clubscountry($countryid); break; case "clubscounty": clubscounty($countyid); break; case "clubs": clubs($cid); break; case "clubsredir": clubsredir($param1,$param2); break; case "events": events(); break; case "eventspage": eventspage($eventid); break; case "eventsadd": eventsadd(); break; case "eventssent": eventssent(); break; case "shopdirectory": shopdirectory(); break; case "modelclubadd": modelclubadd(); break; case "modelclubsent": modelclubsent(); break; case "shopadd": shopadd(); break; case "shopsent": shopsent(); break; case "modelclubhome": modelclubhome(); break; case "blogs": blogs(); break; case "blogadd": blogadd(); break; case "blogsent": blogsent(); break; case "advertise": advertise(); break; case "searchresults": searchresults(); break; case "clubstown": clubstown($townid); break; case "addclubreview": addclubreview(); break; case "clubreviewsent": clubreviewsent(); break; case "countryredir": countryredir($param1); break; case "shopsaz": shopsaz($letter); break; } ?>